Data Analyst (Remote)

Описание

Daniyar Amanzholov
+77786737036
amanzholovdaniyar1@gmail.com linkedin.com/in/daniyaramanzholov/

Experienced Business Intelligence Analyst and Business Analyst with 5+ years of experience in developing and designing Power BI dashboards and reports. Ability to receive and monitor data from multiple data streams and interact effectively with cross-functional teams and stakeholders. Experience with advanced querying and optimization techniques. Experience with ETL processes, including data integration with Azure Data Factory, data transformation, and data loading.

EXPERIENCE
Senior Power BI Developer
Self-employed. Astana, Kazakhstan
Current project - US based retail company
Dec 2023 - Present

Power BI consulting services
Transitioned 12 legacy management reports to Power BI
Single-handedly covering the full spectrum of the BI project implementation:
Requirements gathering from the business/POs
Analyzing complex datasets and transforming raw data into data marts
Building optimized data models that ensure the best front-end experience
Complex DAX calculations and report features
UX/UI based dashboard design
Security management
UAT testing, documentation and user training


Senior Business Analyst
Alshaya Group (via EPAM), Dubai
Jun 2023 - Dec 2023

Single point of contact for multiple stakeholders and cross-functional teams to translate complex business requests to executional technical tasks for BI team
Cooperated with executives to determine top business and data needs to implement new methods and enhance processes
Established a new requirements gathering process for BI reporting and enforce good data practices like documentation and knowledge sharing
Performed BA review of Power BI reports from business needs perspective and provided improvement ideas to the dev team
Consulted dev team on UX/UI, report optimization and complex DAX formulas
Initiated and conducted sessions to gather and elicit requirements, and getting clarifications on requirements through verbal communication and specific frameworks


Senior BI Developer
Merck & Co. (via EPAM), Rahway, NJ
Sep 2022 - Jun 2023
Improved legacy Power BI reports by creating a consolidated and optimized dimensional data model
Developed KPI dashboards for top management
Optimized power query transformations and improved previous reports' performance
Implemented various improvements to the report's capabilities and features based on new client requirements including: complex transformations, DAX formulas and interactive report features
Trained & coached internal stakeholders on effective report and dashboard utilisation

Business Intelligence Analyst
EPAM Systems, Astana
Apr 2022 - Present

Implemented an ELT solution which extracts data from multiple sources (CSV, JSON files, relational database) and loads to DWH using Azure Data Factory
Development of Azure SQL DB with tables, constraints, schemas, index logic
Azure DevOps Repo and CI/CD pipelines configuration in order to deploy ADF, SQL DB, Power BI reports to Dev/UAT/Prod environments




Power BI Developer
Geometry, Astana
Aug 2020 - Apr 2022
Performed requirements elicitation and management (interviews, workshops), created documentation (hypotheses, business metrics design);
Liaised with stakeholders from 11 subsidiaries and a parent company to analyze the methodologies of multiple financial and management reports
Created a model that consolidates the data for all of the subsidiaries, while accounting for the intergroup transactions and share ownership by the parent company, as an outcome reduced management and financial reporting time from 2 weeks to 1 day
Developed KPI reports and dashboards for top management and department heads of Astana International Financial Centre, the financial hub of Central Asia

Financial Analyst in Deals Advisory
Ernst & Young, Almaty
Sep 2019 - Mar 2020
Due diligence on the retail group company, a diversified transport manufacturer, a company in the extractive industry
Research report on all of the Kazakhstani infrastructure projects that were open for foreign investments
Asset quality review of the largest 14 banks: cross-checked more than 300 appraisal reports on various assets

EDUCATION
Bachelor of Arts - Economics
Nazarbayev University, Astana
Aug 2014 - May 2019

SKILLS
Expert in: Microsoft Power BI, DAX, MDX, Power Query, SQL, TSQL, Googe Cloud Platform, Google Big Query, Microsoft Excel, Business Analysis, Power Point, Agile Methodologies, Presentation skills, Data Visualization, Google Sheets, Communications, Presentations, Multitasking
Intermediate in: Microsoft Sharepoint, Azure Data Factory, Logic Apps, Azure Synapse, Power Apps, Azure DevOps, Tableau, Python, Git, Data Integration, Data Modeling, Corporate Finance , Financial Reporting, Business Valuation


CERTIFICATIONS

Microsoft Certified: Azure Data Fundamentals
2022
Microsoft

Microsoft Certified: Power BI Data Analyst Associate
2022
Microsoft

Microsoft Certified: Azure Fundamentals
2022
Microsoft

CFA Research Challenge Central Asian Finalist
2019
CFA Institute

Passed CFA Level 1
2018
CFA Institute