Position: SQL & BI Developer/Data Analyst
Category: SQL
English level: intermediate
Years of experience: 2


SQL/DWH Developer
ProCredit Bank Ukraine • Feb. 2022 - Present

Control the quality and adequacy of data stored and processed in information systems.
Develop an information data warehouse, add new components, and make changes in accordance with the Bank's requirements.
Analyze the correctness and optimality of technical solutions for the operation of information systems and the implementation of technical tasks.
Create and maintain procedures, functions, and triggers in MS SQL to support data processing and analysis.
Ensure the safety of data in information systems.
Prepare and maintain documentation for new developments and systems. Ensure the relevant documentation is up-to-date for changes made.

DEPARTMENT MANAGER OF PURCHASING
Epicentr K LLC. • Nov. 2018 - Mar. 2021

Built out the data, reporting infrastructure using BI tools to provide real-time insights into the product and business KPIs;
Provided assortment data analysis, creating data-driven decisions culture over the department;
Developed pricing strategies, including promotional offers to increase the turnover of lower sales volume goods;
Made data visualizations regarding the most profitable products based on conducted detailed analysis on company-wide data;
Developed and maintained technical support documentation.

CHIEF FINANCIAL ECONOMIST OF CONSTRUCTION SUPPLIES DEPARTMENT
Epicentr K LLC. • Dec. 2015 - Nov. 2018

Interpreted data and analyzed results using statistical techniques and provided reports to make business strategy recommendations (cost-benefit, forecasting, impact analysis);
Prepared budgets and sales forecasts to the stakeholders to improve KPI-based trading processes and revenue control;
Revenue and margin control.

FINANCIAL ECONOMIST OF CONSTRUCTION SUPPLIES DEPARTMENT
Epicentr K LLC. • Dec. 2011 - Dec. 2015

Provided analysis and comparison of data sales of different categories of goods, product groups with sales for previous periods;
Controlled the turnover of goods, analysis of the most valuable and lower sales volume goods using ABC analysis;
Prepared KPI reports and delivered revenue control using BI tools.
As a SQL and BI developer, I possess a thorough understanding of database concepts and am proficient in designing and maintaining databases. Additionally, I have expertise in data analysis and visualization, as well as in the areas of statistics, and probability. My passion lies in transforming data into meaningful insights that can help to solve business problems and contribute to the success of your company.