Ihor

Ihor Bilohai
Data Engineer
Address: Ukraine
Phone: [открыть контакты](см. выше в блоке «контактная информация»)
E-mail: [открыть контакты](см. выше в блоке «контактная информация»)

Work Experience

Name of employer: ZEZMAN Holding
Job title: Data Engineer\BI Developer
Dates of employment: February 2023 – Current Time
Project description: Head of department

 Writing SQL queries, stored procedures
 Creating different jobs
 ETL from different source to Google Big Query
 Implementation of Power BI reports, as well as data visualization
 Work with regular data updates
 Formation of regular reporting on operational and financial efficiency of Business
 Performing tasks in Bitrix
 Writing Python scripts to check data
 Connect google tables and advertising from Google Ads, Facebook Ads
 Monitoring the work of subordinates
Name of employer: NP Digital
Job title: DWH Developer\BI Developer
Dates of employment: November 2021 – January 2023
Project description: Data warehouse support and develop of reports

 Writing SQL queries, stored procedures
 ETL from different Linked Servers, to MS SQL Server
 Implementation of SSRS and Tableau reports, as well as data visualization
 Work with regular data updates
 Formation of regular reporting on operational and financial efficiency of Business
 Performing tasks in Jira
Name of employer: Intelligent Solutions
Job title: Database Developer\BI Developer
Dates of employment: July 2021 – December 2021 (part-time)
Project description: Financial data analysis and develop of reports in different projects
 Developing ETL system from Excel calculation
 Analysis financial measure
 Writing SQL queries, stored procedures for calculate different measures
 Control Power BI developers in dashbords development

Name of employer: TS Tech
Job title: BI Developer
Dates of employment: February 2021 – October 2021
Project description: Financial data analysis and develop of reports
 Support development DWH and BI web portal
 Writing SQL queries, stored procedures for regular data uploads
 ETL from MySQL sources to MS SQL Server
 Providing Business Management with analytical support, work with ad-hoc tasks
 Implementation of SSRS reports, as well as data visualization
 Development of automated reports in Visual Studio
 Performing tasks in Jira
 Writing Dynamic SQL procedures for reporting
 Assessment of the requirements in terms of the feasibility of their implementation
 Communication with business analysts, account managers, technical support

Name of employer: Proxima Research International
Job title: Business Analyst
Dates of employment: September 2020 – February 2021
Project description: Analysis and pharmaceutical data control
 Whiting technical documentation, user stories
 Development, implementation, improvement of business analysis tools
 Processing of regular reports with subsequent display of data on the dashboard
 Providing business management with analytical support, working with ad-hoc tasks
 Project management with regular calls with customers
 Critically assessing requirements in terms of the feasibility of implementation
 Help in the development of QlikView dashboards, as well as data visualization
 Automation of existing analytical processes

Name of employer: PUMB
Dates of employment: September 2018 – August 2020
Job title: Business Analyst
Project description: Financial data analysis and develop of reports
 Analysis of existing business processes in the company
 Analysis of business needs in process automation, preparation of technical specifications,
testing, verification of results
  A critical assessment of the requirements in terms of the feasibility of their
implementation
 Analysis of the impact of changes on the efficiency of business processes
 Performing tasks according to scrum methods in Jira
 Automation of the processes of uploading and processing data for reporting
 Writing SQL queries, stored procedures for regular data uploads
 Implementation of Power BI and SSRS reports, as well as data visualization
 Work with regular data updates
 Development of automated reports
 Automation of existing analytical processes
 Providing Business Management with analytical support, work with ad-hoc tasks
 Development, implementation, improvement of business analysis tools
 Formation of regular reporting on operational and financial efficiency of Business
 ETL from Sybase to MS SQL Server
Tools and technologies: Google Big Query, Transact SQL, Sybase, MySQL, Oracle, MS Power
BI, MS SSRS, MS Power BI server, MS Excel (Power Pivot), MS Excel (Power Query), Jira,
Confluence, Slack, QlikView (basic), Python (basic), ETL, Visual Studio, GitHub, Bitrix

Education

Dates of studying: 2011 – 2018
Name of institution: Kiev National University of Trade and Economics
Degree and major: Master’s Degree in computer Science and Information Systems

Dates of studying: 2016 – 2018
Name of institution: National Aviation University
Degree and major: Master’s Degree in Systems Programming
Certifications
Transact SQL
Data visualization