Position: CHIEF ANALYTICS SPECIALIST
Category: Data Analyst
Experience: 5 years | English: upper

DTEK

SOLVED PROBLEMS OF DIRECTION: 
o	Significant optimization of the unloading process and construction of automated data processing from billing systems.
o	Development of an automated system for verifying the correctness of data.

PERSONAL CONTRIBUTION: automation of electricity consumption forecast and implementation of plans by region, taking into account seasonality and customer migration.

Ukrposhta
PROBLEMS OF CORPORATE BUSINESS DIRECTION SOLVED:
O	regularly: reconciliation and validation of data between accounting systems (the company has implemented 3 accounting systems that reflect the main activities in terms of different areas), clarification and coordination of differences with branches and parallel division (retail network);
O	locally: detection and elimination of incorrect operation of the software together with the IT department: duplicate data, discrepancies in names, data loss, incorrect display.
PERSONAL CONTRIBUTION: Errors were detected and a number of software was written for the IT department to improve the performance of the software, as a result of which a lot of errors were corrected and the correct display of data in one of the accounting programs was set up.

Development of a weekly updated forecast of plans in terms of businesses, services, branches, units and money, taking into account market parameters, seasonality, regional specifics and operational constraints. Maintaining the accuracy of the forecast at 98%.

Maintaining a system of regular analytical reports and reports, identifying weaknesses and implementing measures to address the problem.
CHIEF ANALYTICS SPECIALIST • DTEK | DEPARTMENT OF DEVELOPMENT •
SEP 2021 –MAR 2022

KEY DIRECTIONS OF ACTIVITY:
•	ACCOUNTING OF DATA ON THE VOLUME OF ACCUMULATED ELECTRICITY (DATA WORKING)
MAIN TASKS: unloading, processing and collecting data from different billing systems, verification of data (reconciliation between different accounting systems), updating directories, maintaining statistics for the last few years.
MAIN SOURCES OF DATA: billing reporting systems, data from networks, SAP reports.
SOLVED PROBLEMS OF DIRECTION: 
o	Significant optimization of the unloading process and construction of automated data processing from billing systems.
o	Development of an automated system for verifying the correctness of data.
•	FORECASTING OF ELECTRICITY CONSUMPTION BY REGIONS AND TYPES OF CONSUMERS PER YEAR 
MAIN AREAS OF RESPONSIBILITY: forecasting the volume of electricity consumption by regions and types of consumers per year, taking into account the seasonality of consumption, the outflow of consumers and the connection of new consumers by regions and types of consumers.
PERSONAL CONTRIBUTION: automation of electricity consumption forecast and implementation of plans by region, taking into account seasonality and customer migration.
•	MAINTENANCE AND OPTIMIZATION OF OTHER REPORTS AND STATISTICS RELATED TO DISTRIBUTION, CONSUMPTION AND BALANCE OF THE ELECTRICITY MARKET

MS OFFICE (MS EXCEL, POWER POINT, OUTLOOK ETC)

Working with standard formulas (mathematical and logical, text, date and value formulas), building reports using tables, charts, PivotTables and PivotCharts, processing and querying data using Power Query (including direct query of data from files .xlsx, .csv, websites, SQL analysis server), building data models in the Power Pivot add-in.
Further design and visualization of work with Power Point..