Hey there! My name is Serikzhan, financial data analyst with diversified experience; data analyst graduate from Skillfactory and Yandex (online programming schools), currently based in Almaty. I specialize in product analytics, and my areas of expertise include, but are not limited to: FinTech, EdTech, eCommerce, and Retail.
As of November 2023, my portfolio of projects includes:
I'm constantly monitoring situations in the data-driven markets and am currently open to professional proposals.
Download CV As of November 2023, my portfolio of projects includes:
- 2 commercial projects: 1. Aggregator of banking CC (App), 2. Management reporting in Power BI;
- 20 non-commercial educational tasks;
- 5 commercial freelance projects;
- 3 independent projects;
- 40+ business tasks;
- 1500+ exercises
- access and manipulate data in relational databases (PostgreSQL) with SQL;
- design interactive reports and visualizations using MS Power BI, DAX, M;
- work in Excel, Google Sheets, and formats, such as CSV, JSON, XML, etc;
- work with Python to extract insights and patterns, conduct detailed analysis;
- use applied mathematics and statistics for business decisions, run A/B testing;
- perform mobile + web analytics using tools such as Google Analytics, Firebase, etc.
I'm constantly monitoring situations in the data-driven markets and am currently open to professional proposals.
Work experience
Senior Financial Data Analyst at Digital Bank (Kazakhstani top 8)
(April 2023 - November 2023)
(April 2023 - November 2023)
• Development of management reporting in Power BI (calculations in DAX, M)
• Updating custom reports in PBI and maintaining their relevance
• Automation of the ETL process from the source system to the BI report
• Calculations of transfer pricing, costs, profits
• Analysis of income statement, balance sheets, distribution of costs by profit centers
• Generating reports in the Colvir system, SQL queries, Postgres, DBeaver, DWH
• Updating custom reports in PBI and maintaining their relevance
• Automation of the ETL process from the source system to the BI report
• Calculations of transfer pricing, costs, profits
• Analysis of income statement, balance sheets, distribution of costs by profit centers
• Generating reports in the Colvir system, SQL queries, Postgres, DBeaver, DWH
Analyst | Content manager in Way2Pay (IT-sandbox)
(December 2022 - March 2023)
(December 2022 - March 2023)
• Preparation of technical specifications together with PO, PM, developers, designer
• Data collection: web scraping, parsing, conducting surveys, field research
• UI analytics of 80+ banking apps; participated in app design in Figma
• Development of content and data storage sources, analytical dashboards in Excel, Power BI.
• Data collection: web scraping, parsing, conducting surveys, field research
• UI analytics of 80+ banking apps; participated in app design in Figma
• Development of content and data storage sources, analytical dashboards in Excel, Power BI.
Data Analyst | Student Mentor at Skillfactory
(February 2020 - March 2023)
(February 2020 - March 2023)
- Encouraging students through a mentoring program (Data Analyst);
- Helping students with adaptation to a new profession, providing psychological support in the educational process;
- Discussing learning difficulties and finding solutions;
- Publication of motivating and analytical posts;
- Organization of online coworking for joint classes, and other professional development activities.
Consultant, Management Consulting department at Century Integration (startup)
(December 2019 - June 2020)
(December 2019 - June 2020)
• Prepared marketing research and business plans for adhoc projects, developed financial models and presentations in the FMCG segment; collected and structured data on international and CIS markets.
Nurteam Audit, Consultant-Auditor
(April 2019 - June 2019)
(April 2019 - June 2019)
• Participated in 4 audit projects to verify the correctness of the Financial Statements preparation according to IFRS standards, in manufacturing, pharmaceutical, oil and gas enterprises of the Republic of Kazakhstan.
Freelancer, independent observer at KABC
(December 2017 - April 2019)
(December 2017 - April 2019)
• Conducted collection, analysis, archiving of news data in the field of fintech, financial markets for internal use database; processed, analyzed, and documented over 2.5 GB of data.
Assistant to Managing Partners at Mintax
(January 2016 - April 2016)
(January 2016 - April 2016)
• Managed requests of managing partners; prepared analytical notes and specifications for the company's websites, described business processes of the group's non-profit company, automated routine workflow.
Manager, business consulting department at Helios soft
(February 2015 - August 2015)
(February 2015 - August 2015)
• Conducted marketing research, modeled business plans, studied implementation of a balanced scorecard in the enterprise.
Sales Analyst | Manager, Financial Services department at Kazpost
(October 2013 - July 2014)
(October 2013 - July 2014)
• Prepared consolidated sales reports, analyzed the financial performance of the company's 16 regional divisions, and made monthly/annual sales forecasts; as a team member, improved the profitability of regional offices by 2-10%.
Account Manager | Financial Analyst at Trade
(October 2011 - September 2013)
(October 2011 - September 2013)
• Collected and analyzed data from global financial markets; conducted fundamental, technical analysis of traded assets, advised clients on risk management issues.
Consultant at Interconsult Info
(November 2009 - May 2011)
(November 2009 - May 2011)
• Supported clients on installation and adaptation of the information database "Legal Consultant", developed commercial partnerships, sales scripts; managed direct sales and invoicing.
Sales Development Manager at Saad
(October 2008 - October 2009)
(October 2008 - October 2009)
• Carried out production calculations, marketing research; conducted negotiations with suppliers and retail chains; managed indirect sales, control of billing and return of goods on consignment.
Audit Specialist at Ernst & Young
(August 2007 - October 2008)
(August 2007 - October 2008)
• Participated in 10 external audit projects in the banking, manufacturing, oil and gas industries of the Republic of Kazakhstan; collected primary accounting information, performed audit and analytical procedures.
Education
Data Analyst at Skillfactory - Online Programming School (Hons)
- Worked with product and marketing metrics;
- Developed the foundations of analytical and algorithmic thinking;
- Mastered applied knowledge of mathematical statistics for data analysis;
- Collected, processed, visualized data using: Google Analytics, Google Tag Manager, Amplitude, Yandex.Metrics, Python (Pandas, Numpy, Plotly, Matplotlib), SQL, Google Sheets, Power BI (DAX, PowerQuery);
- Prepared conclusions and recommendations for data-driven businesses.
MBA Program at Hult - International Business School
Development of practical skills and knowledge, critical thinking in a number of business disciplines demanded by employers around the world + the practice of interaction in multicultural teams.
Hult International Business School website, MBA program 
Financial analysis in IBS at KazEU named after T. Ryskulov
Financial analysis, budgeting and planning, statistical methods in business.
Publication about IBS Business School - KAZEU 
KIMEP - Kazakhstani Institute of Management Economics and Prognosis
Bachelor of Business Administration (4-year program),
degrees received:
major: Accounting;
minor: Finance
KIMEP University website degrees received:
major: Accounting;
minor: Finance
Professional Skills
- – Professional qualification in data analysis:
Profession: Data Analyst
specialization: Product Analyst;
— Analysis and visualization of data in companies of various sizes and locations;
— Application of data analysis methods in data-driven companies;
- Ability to work both independently and in a team;
- Excellent communication and persuasion skills;
- Excellent analytical skills;
- Customer focus in multitasking mode.
Medium, LinkedIn, Twitter, Facebook
Publications
Over the past 4 years, I have written and published more than 10 articles, 1500+ posts (in English and Russian) covering various topics on social and content platforms.
Articles on Medium (in English)
My articles on Medium - a publishing platform
If you are a student or an adult, who educate yourself to learn new skills or master your current competencies, this article is for you. In the next few paragraphs, I would like to talk about goal setting in education and share an example of how to put it into practice.
...
...
...
I started bot chat communication, answered the questionnaire, after which they offered an intermediate logic test — I correctly answered 27 out of 30 questions — that’s 90%, but instead of continuing the conversation, I was refused ...
I started bot chat communication, answered the questionnaire, after which they offered an intermediate logic test — I correctly answered 27 out of 30 questions — that’s 90%, but instead of continuing the conversation, I was refused ...
Feed comments on LinkedIn
My feed comments on LinkedIn - social and networking platform
My reply:
FMPOV, it is very important to find a golden ratio between personal trust and professional attitude... what do I mean? I mean, I would try to wear George's shoes for a moment, think how it is to be George, to embrace efforts he made and feelings he felt ...
Gary's question:
FMPOV, it is very important to find a golden ratio between personal trust and professional attitude... what do I mean? I mean, I would try to wear George's shoes for a moment, think how it is to be George, to embrace efforts he made and feelings he felt ...
Gary's question:
- What would you do first in this situation? (See the case) >>>
My reply:
The harsh true part is “corporate environments that care more about the numbers than they do about the kids..” FMPOV, the so-called ‘leadership’ stereotype, which is artificially imposed on kids from the very beginning, so that everyone could start to think of leadership as the main skill to make an impact and nobody wants to be led by others because of stereotypical ‘loser’ morality dimensions - is what nourishes the ‘competitive’ kind mindset in the corporate environments with high performance, efficiency, profits, fame and recognition among the top priorities.
...
Hugo Ângelo Silva:
The harsh true part is “corporate environments that care more about the numbers than they do about the kids..” FMPOV, the so-called ‘leadership’ stereotype, which is artificially imposed on kids from the very beginning, so that everyone could start to think of leadership as the main skill to make an impact and nobody wants to be led by others because of stereotypical ‘loser’ morality dimensions - is what nourishes the ‘competitive’ kind mindset in the corporate environments with high performance, efficiency, profits, fame and recognition among the top priorities.
...
Hugo Ângelo Silva:
- - "Absolutely a great video about Millennials and the future of organizations managing new generations to come."
Biography
Work experience
Short biography
Hey there!
My name is Serikzhan, now I live in Almaty, Kazakhstan; also lived and studied in Moscow, Boston, New York cities.
For the last 3+ years, I have participated in 2 commercial projects as a data and financial analyst. Currently, I'm improving my SQL + Python skills, previously earned my Data Analyst degree from Skillfactory (online programming school) with a specialization in Product Analytics. For the moment, I have collected a portfolio of:
In addition to IT experience, I have 10+ years of diverse work experience (financial markets and advisory activities, audit and assurance services, management consulting, direct sales), which in general contributes to my productivity and ability to integrate data analysis experience for a specific business niche.
My name is Serikzhan, now I live in Almaty, Kazakhstan; also lived and studied in Moscow, Boston, New York cities.
For the last 3+ years, I have participated in 2 commercial projects as a data and financial analyst. Currently, I'm improving my SQL + Python skills, previously earned my Data Analyst degree from Skillfactory (online programming school) with a specialization in Product Analytics. For the moment, I have collected a portfolio of:
- 1. Aggregator of banking credit cards (App: Way2Pay); 2. Management reporting in Power BI.
- 20 non-commercial projects in the field of EdTech, eCommerce, GameDev;
- 5 commercial freelance projects in FinTech, EdTech, eCommerce and Retail.
In addition to IT experience, I have 10+ years of diverse work experience (financial markets and advisory activities, audit and assurance services, management consulting, direct sales), which in general contributes to my productivity and ability to integrate data analysis experience for a specific business niche.
userikzhan@gmail.com
Photos used in publications belong to the authors:
Isaac Smith from Unsplash, Engin Akyurt, Leeloo Thefirst from Pexels.com
Isaac Smith from Unsplash, Engin Akyurt, Leeloo Thefirst from Pexels.com
