• Functional, integration, regression, exploratory, smoke, end-to-end testing • Automated DWH Testing Framework development and maintenance • Creating SQL scripts as a part of automated testing framework • Monitoring and reporting on test results • Technical documentation development and maintenance • Creating and maintaining test cases Main Tools: AWS (AWS S3, AWS Glue, AWS Glue Data Quality, AWS Athena, AWS Step Functions, AWS Lambda, DynamoDB), Tricentis qTest, DBeaver, Bitbucket.

• Building hybrid DWH (by Inmon and Kimball) with 3NF and Star / Snowflake schemas • Extraction, transformation and loading source data to DWH with PL/SQL procedures • SQL and PL/pgSQL query optimization • Python for analysis: basics, OOP, pandas • AWS: IAM Roles and Policies, S3 Service, EC2 Types and EBS Volumes, Amazon Redshift, AWS Glue • Developing and publishing Reports and Dashboards in Power BI Desktop • Working with business requirements and their clarification • Creating test documentation (test strategy, test plan, checklist, test cases, defect reporting, data mapping) • Dashboard and ETL Result testing and verification (preparing checklists, bug reports, data mapping, data profiling, test strategy) • Working with flat files (.csv, .xlsx)

- Designing and creating reports and dashboards using BI tools such as IBM Cognos Analytics - Migrating reports from SAP BusinessObjects to IBM Cognos Analytics using PL/SQL (Oracle)

• Collection, integration, and visualization of financial data in Power BI • Application of Python scripts to ingest monthly data from multiple sources using API in order to update data for analytical portals on the bank’s website (https://www.kdb.kz/en/analytics/analytical-portal-foreign- trade-of-the-RK/) • Gathering, cleaning, and transformation of data from diverse sources using Pandas, ensuring data accuracy and consistency for analysis

• Development of content strategy for Youtube channel and conduct data analysis to identify trends and areas of improvement • Utilization of data insights to develop targeted content that resonated with the target audience

• Training data and dataset preparation for machine learning algorithms training • Matching related data from different data sources, providing quality assurance for data sets

HSE, Finance

EPAM

Stepik, Python

Stepik, Python

freeCodeCamp, Python

Stepik, Statistics

Stepik, SQL

freeCodeCamp, Web Design

Sololearn, SQL

British Council