Alexander Kirillov

Middle

Registration: 03.03.2025

Specialization: BI Developer

— Experienced BI-developer with extensive knowledge of IBM Cognos Analytics 11, Oracle Database, PostgreSql, Power BI and Snowflake. — Successfully worked as a Middle BI-developer in the Central Bank of Russia before transitioning to a role as a Middle BIdeveloper at EPAM for an internal project. — Utilized Postgresql for various tasks. — Worked on a project for Danone Company, utilizing Power BI and Snowflake for data analytics. — Learned additional courses in Calculus, Theory of Probability, and Linear Algebra, as well as proficiency in ANSI SQL, DAX, and Python coding. Certifications: — Author Professional Reports Advanced. — IBM Cognos Framework Manager: Design Metadata Models. Publications: — Method of short take-off of the aircraft. Patents: — The method of shortened take-off of an aircraft. — The way to learn swimming.

SQL Business Intelligence Oracle PostgreSQL Power BI Python

Portfolio

Danone

● Implemented migration of reporting from Microstrategy to Power BI. Tasks performed: ● Development of reports in Microsoft Power BI (creating views, building data models, visualization, deployment, bug fixing).

EPAM

Internal EPAM project. Tasks performed: ● Migration of metrics from Java to PostgreSQL. ● Support and testing of code for new metrics.

PMI

Project: ● Development and maintenance of Power BI reporting. Tasks performed: ● Creation of data models and Power BI metrics. ● Migration of reports from a cloud service to an on-premise solution.

Skills

Python

Power BI

SQL

PostgreSQL

IBM Cognos Analytics

Oracle

Snowflake

Business Intelligence

Work experience

BI Developer

since 01.2024 - Till the present day |PMI

Power BI Desktop, Power BI Service, PostgreSQL, ClickHouse

Project: ● Creating and maintaining reports on Power BI. Tasks completed: ● Creation of Power BI data models and metrics. ● Migration of reports from a cloud service to an on-premise solution.

ETL / BI / DWH Developer

06.2023 - 01.2024 |Danone

Snowflake, Power BI Desktop, Power BI Service, Informatica Cloud, Git

Project: ● Creation of reporting for divisions in Kazakhstan. Tasks completed: ● Creation of data flows based on Informatica Cloud. ● Creation of DB objects for ETL pipelines and for Power BI datasets. ● Creation of Dataflow for Power BI datasets. ● Creation of Power BI data models and metrics. ● Deployment of Informatica Cloud and Snowflake objects.

SQL Developer

01.2023 - 05.2023 |RNT

PostgreSQL

Project: ● Internal Project. Tasks completed: ● Improving the performance of the code of existing views.

BI Developer

07.2022 - 12.2022 |Danone

Snowflake, Power BI Desktop, Power BI Service

Project: ● Transfer of reporting from Microstrategy to Power BI. Tasks completed: ● Development of reporting in Microsoft Power BI (creation of views, creation of data models, visualization, deployment, bug fixing).

SQL Developer

12.2021 - 06.2022 |EPAM

PostgreSQL

Project: ● Internal project. Tasks completed: ● Translation of metrics from Java to PostgreSQL. ● Support of the code of new metrics and its testing.

BI Developer

09.2018 - 12.2021 |Central Bank of the Russian Federation

Oracle DBMS, IBM Cognos Analytics 11, IBM Cognos Framework Manager, SQL, MS Excel, TortoiseSVN, XML

Project: ● BI solutions based on IBM Cognos BI. Tasks completed: ● Developing reports in IBM Cognos Analytics 11 in accordance with the technical requirements. ● Building data models in IBM Cognos Framework Manager. ● Modifying existing and creating new objects in Oracle DBMS in accordance with business requirements.

Educational background

Applied mechanic (Masters Degree)

2016 - 2018

Baltic State Technical University "VOENMEH" named after D.F. Ustinov

Rocketry (Bachelor’s Degree)

2012 - 2016

Baltic State Technical University "VOENMEH" named after D.F. Ustinov

Languages

RussianNativeEnglishIntermediate