Mykolai

Ponomarchuk Mykolai
Location: Kyiv, Ukraine

Phone number(s): [открыть контакты](см. выше в блоке «контактная информация»)
Skype: nils86_p
E-mail: [открыть контакты](см. выше в блоке «контактная информация»)

Portfolio: https://www.youtube.com/@ponomarchuk.
mykola

LinkedIn.com: [открыть контакты](см. выше в блоке «контактная информация»)

Analyst, architect
(last updated on 10.01.2023)

Summary

I has experience in web scraping, PHP, XML, HTML, CSS, JScript, Python, Java, C#, VBA, Oracle,
MS SQL server, ETL, and various BI tools such as Power BI, Tableau, SSRS, and more. They
have held positions such as Data Architect, Senior Analyst, Business Consultant, Business
Analyst, Head of ETL Developers Team, Risk Analyst, and DB/ETL Programmer in companies
such as UkrEnergo, Fractal.ai, SoftServeinc.com, UniCredit Bank, Ukrainian Railways Company,
and Repryza restaurant network. They have expertise in various programming languages,
database management, data mining, and data analytics.engineer.

Experience

Experience in: Web scraping, PHP, XML, HTML, CSS, JScript, Python 3.6, Java, C#,
VBA Excel add-in (Informatica as the similar ETL tool).
Hands on: Oracle, MS SQL server, ETL;
Microsoft Power BI, Tableau, SSRS, Periscope, Mode, Looker, Synapse Analytics,
Data Explorer, Cosmos, Hive, MR, RedShift, Snowflake

Data architect, senior analyst
UkrEnergo, digital transformation unit
Sep 2022 - Dec 2022
Developing solution for data transformation from legacy to MSRS report service and RDB.

Business consultant (AI and BI domain)
Fractal.ai
Sep 2021–Sep 2022
Business layer support and implementation. In this role, I'm responsible for Microsoft stack and financial domain in Fractal
analytics outsource company. Usually my steak based on Power BI, Python, SSRS, Azure Ml and few open source
frameworks as a part of client vision.
Business analyst
SoftServeinc.com
Mar 2021–July 2021
Responsibilities
● Own the data architecture for Customer Security and Trust Engineering (CST-E). Lead the design, analysis, and

data architecture efforts for real-time services and big data platforms to solve complex business problems.

● Define data standards for use across the CST-E technology stack.

● Assist in the transformation of high volume complex data structures into relevant information that can be used

by Data Scientists, BI Analysts, and investigators.

● Work closely with product planning and business stakeholders to help define the strategy to best meet our

customers’ needs.

● Become an expert on system architecture, functionality, and data flows as well as operations, processes, and

tools. Leverage business and application knowledge to create flexible and robust data solutions.

● Create and maintain a robust data dictionary and facilitate user adoption.

● Advocate on behalf of stakeholders and data consumers.

● Manage multiple tasks and projects simultaneously, prioritize workload effectively, and thrive in a dynamic

environment.

● Coordinate with data owners to obtain access and identify data handling and security requirements.

● Create proof-of-concept tools to validate connectivity, throughput, and limitations of those data sources.

● Effectively manage trade-offs between effort/schedule and customer benefits.

● Collaborate with Engineers, Data Scientists, System Architects, Program Managers, Analysts, and Investigators

to implement successful solutions.

Short term projects as a self driven developer
Bank Aval, Kernel, Dacius etc.
Sep 2020 - Aug 2021
SQL, Power Bi, python, LookML

Business analyst, head of ETL developers team
State Statistics Service of Ukraine ( government sector )
Nov 2019 - Sep 2020
I work closely with data lake and report specialists to produce new output form reporting tool and identify needs in new
solutions for this workflow side (Power BI, MySQL, PHP7, Python3, JavaScript).
My design and realization you can see on my youtube channel.
Also in this role I was hands on Redshift and GIT.

BI/Data analyst (t-SQL)
Self employed in RinfTeck Ukraine
May 2019 - Nov 2019
Code refactoring and documentation expecting (UML, Togaf, t-SQL, JIRA). I was proud for creating a monitoring
script solution which one illustrate difference between customer's side code localization and triggers/jobs status. Also I was
insect ETL process.
Risk analyst / solution architect at Strategic risk department
UniCredit Bank (http://www.unicredit.com.ua/)
over 500 employees Bank
Sep 2011 - Dec 2016 (5 years 4 months)
I was responsible for portfolio revaluation and information consolidation. Work in one of the biggest Ukrainian bank give me
team work experience and give practice with big data storage like a SAS, ProFix.
My second position as double employment are programmer in Credit risk unit. In this position I build pool of data from
Oracle through DBlink to MSSQL storage (joining contract details with client information date) and implement client-side
modeling interface.
According to my responsibilities, I already have experience in pivot queries, statistical analysis and I can implement bridges
between web technologies and intranet resources , like a MS Office products or DB storages (Oracle or Ms SQL data
servers).
In my practice I use Oracle BI instruments for data transfer from different sources and information consolidation.
Oracle 11g
● PL/SQL (pivot, functions + cursors, create as select statement, etc.)
● Performance tuning : EXPLAIN PLAN
● ETL tools: developing and produce tools by myself (sqlplus)
MS SQL Server 2008
● T-SQL package and optimization
● OLAP
● sqlcmd

DB/ETL Programmer
Feb 2009 - Sep 2011 (2 years 8 months)
Ukrainian Railways company, IT department (http://www.uz.gov.ua)
Railway support / Telecommunications
On this position I keep experience in Oracle programming. I was responsible for web-site protection and was written intranet
report system, based on Oracle package which one I made by myself.

DB/ETL Programmer / data miner
Feb 2005 - Sep 2009 (4 years)
Repryza restaurant network, IT department (http://www.uz.gov.ua)
Retail and distribution
I was responsible for data mining and logistic optimization. I was use MS SQL server data storage to calculate base needs
for all restaurants in network according to trends and historical data. For example: in the summer we should store more
fruits and ice cream and should have 100 kilogram of sugar in each of restaurant.

DB Programmer
Feb 2004 - Sep 2005 (1 year)
OTIS, IT department
Elevator company / Head office location
My first experience start from Kyiv elevator factory. I was responsible for KPI calculation and report systems to improve
quality of services and notify central office.
Education

USUFIT (Kyiv, Ukraine)
Graduation year: 2013
Enterprise economy, International Economics Master of Arts in Economics

NTUU KPI (Kyiv, Ukraine)
Graduation year: 2006
FEl, CAD it engineer

Kyiv technical college (Kyiv, Ukraine)
Graduation year: 2005
Programmer
Language skills

English - upper intermediate
Polish - elementary
Ukrainian - fluent
Russian - fluent

Courses, Trainings, Certification

Graduation year: 2015
http://www.codecademy.com/users/nils86/achievements (Python, PHP, jQuery)
https://www.sololearn.com/Profile/7202990/
https://www.sololearn.com/Certificate/1059-7202990/pdf/ (PHP Tutorial)
https://www.sololearn.com/Certificate/1081-7202990/pdf/ (Ruby Tutorial)
https://www.sololearn.com/Certificate/1023-7202990/pdf/ (CSS Fundamentals)
https://www.sololearn.com/Certificate/1060-7202990/pdf/ (SQL Fundamentals)
https://www.sololearn.com/Certificate/1080-7202990/pdf/ (C# Tutorial)
https://www.sololearn.com/Certificate/1075-7202990/pdf/ (Swift Fundamentals)
https://www.sololearn.com/Certificate/1082-7202990/pdf/ (jQuery Tutorial)
https://www.sololearn.com/Certificate/1073-7202990/pdf/ (Python 3 Tutorial)
https://www.sololearn.com/Certificate/1024-7202990/pdf/ (JavaScript Tutorial)
https://www.sololearn.com/Certificate/1068-7202990/pdf/ (Java Tutorial)