Сергій

SERGIY GRINKEVYCH
Summary
Experience highlight:

• Data analysis, Power BI reports development and configuration – 5 years.
• Power BI consulting and trainings – 4 years.
• Designing MS Fabric data storage and transformation solutions, architecture – 1 year.
• Designing Azure data storage and ETL solutions (T-SQL, Synapse, Data Factory) – 2 years.
• Microsoft Dynamics 365 systems implementation - 2 years.
• Formalization of development and management processes for Power BI projects.
• Managing a team of 5 developers
• Applied knowledge of operational processes in various fields (production, sales and marketing,
promotional activities, etc.).

Personal qualities: responsible, honest, ethical, loyal, non-conflict, impartial.

Certifications
Microsoft Certified: Fabric Analytics Engineer Associate
https://learn.microsoft.com/api/credentials/share/en-gb/SergiyGrinkevych/79C2785D55F5129D

Microsoft Certified: Azure Data Engineer Associate
https://learn.microsoft.com/api/credentials/share/en-gb/SergiyGrinkevych/45251BEDB0595764

Microsoft Certified: Power BI Data Analyst Associate

https://learn.microsoft.com/api/credentials/share/en-gb/SergiyGrinkevych/5B678C80607A8618

Microsoft Certified: Azure Enterprise Data Analyst Associate
https://learn.microsoft.com/api/credentials/share/en-gb/SergiyGrinkevych/4A526DB8A2EB2277

Education
2016 – 2018
National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”.
Bachelor's degree in Computer Science. Artificial Intelligence specialty
2018 – 2020
Taras Shevchenko National University of Kyiv.
Master's degree in Computer Science. Software engineering specialty
Work experience
BI Engineer/Consultant, SMART business, Ukraine
JUN 2021 – Present
• Analysis of business processes and data.
• Architecture of MS Fabric and Azure data storage and transformation solutions.
• Design and development of Power BI data visualization solutions.
• DAX, Power Query, SQL proficiency.
• Formalization of development and management processes for Power BI projects.
• Managing a team of 5 developers
• Specifications and technical documentation creation.
• End users support, consultancy and training.

ERP Consultant, Innoware, Ukraine
FEB 2020 – MAY 2021
• Participation in implementation and support projects related to NAV and BC ERP systems.
• Data analysis, development, and configuration of Power BI reports and visualizations.
• Specifications and technical documents creation.
• Testing of Modifications.
• End users support and consultancy.

Promotion Event Supervisor, All Motion Group, Ukraine
DEC 2019 – JAN 2020
• Managing a Nestle promotional campaign for the Svitoch brand.
• Managing the team of 5 people, planning working hours and changes.
• Setting goals for the team, conducting training for specific roles.
• Providing analytical reports on current performance to management.

Operations Intern/ Database Administrator, British American Tobacco, Ukraine
JUL 2019 – OCT 2019
• Analysis of the processes of production lines and improvement of production line metrics.
• Data analysis and visualization using Excel and SQL databases.
• Implementation of the "Autonomous Maintenance" pillar within the "Integrated Work System"
• Training and instructing of pilar members.

Lead Researcher, CIENCE, Ukraine
APR 2019 – JUL 2019
• Creation and support of a B2B customers database based on an ideal customer profile
• Analysis of the customers data to improve conversion rate
Project experience
Smart Price Insights

• Work with historical sales data, competitors’ data and optimal repricing data from “Price Insights”
solution
• Managing a team of 5 developers
• Formalization of development and management processes for Power BI related projects
• Implemented the use of GIT for simultaneous development and version control of PBI projects
• Designed and developed set of Power BI reports embedded in web application
• Data storage and transformations using Azure Data Bricks and MS Fabric

Smart Demand Forecast

• Work with historical sales data and demand forecast data from predictive machine learning
solutions
• Design of data storage and transformations processes using Azure Synapse and Data Factory
• Transferred analytical model DWH from Azure Synapse to Data Lake in format of delta tables
• Designed and developed set of Power BI reports embedded in web application

AB Inbev, Belgium
Creation of an application for factory employees to monitor line KPIs and personal metrics in real time.

• Analysis of business processes of brewery and workers needs
• Building Power BI reporting solution using combined data from Azure SQL DB, Postgres SQL DB,
Rest APIs (using combination of Direct Query and Import modes)
• Creation of DB objects and queries to prepare data from replication DB for analytical purposes
• Work with features such as: generating deeplink URLs and reports with different behavior based
on URL filters received; localization of displayed information; managing reports versioning for
different environments; work with on-premises gateways
• SQL queries and DAX optimization
• Managing differences in time zones and objects nomenclature between different environments
SMART business, Ukraine

• Providing consultations and estimations of costs for Azure and Fabric data analysis solutions.
• Creation and support of internal company reporting in the areas of Marketing, HR, accounting,
workload management.
• Work with data from: Azure SQL DB, Microsoft CRM and BC systems, Smart HCM LMS solution.

Arterium, Ukraine
Creation of Power BI analytic solution based on combined data from the IFS system and Sharepoint file
storage regarding manufacturing, logistic and quality management processes.

• Creation and support of storage database (Azure SQL)
• Management of data update and transformation processes using Azure Datafactory and blob
storage (Parquet)
• Creation of interactive Power BI reports to display descriptive data analytics
• Creation of a role model of access
• User support and consultation

More info: https://www.smart-it.com/customers/stories/success-story-arterium/

Ahmad Tea USA,UAE
Creating Power BI sales and warehousing operations reports based on BC/NAV ERP system data.

Melillo Consulting Inc., USA
Creating Power BI sales, and time and attendance reports based on NAV ERP system data.

Orbico Group, Moldova
Localization solution implementation for NAV ERP system for fixed assets accounting processes and
cash transactions.