Mykolai

Ponomarchuk Mykolai
Location: Kyiv, Ukraine

Phone number(s): [open contact info](look above in the "contact info" section)
Skype: nils86_p
E-mail: [open contact info](look above in the "contact info" section)

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

LinkedIn.com: [open contact info](look above in the "contact info" section)

Analyst, architect
(last updated on 07.05.2024)

Summary

I have experience in web scraping, PHP, XML, HTML, CSS, JScript, Python (PySpark, Hadoop),
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 a 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 analyst
Dec 2022 - till now
As a self-employed, I made the ml models for cargo transferring in government startup “єЧерга” and provided
solutions in military tech such As computer vision for turrels and solar systems for drone detection.
Python (Scikit Learn and Prophet Lib), Excel VBA add-in, Power BI, and SQL. Also clients needs push me into the
ocean of big data so I have quiet experience in pyspark and hadoop for node orchestration.

Data architect, senior analyst
UkrEnergo, digital transformation unit
Sep 2022 - Dec 2022
Developing solutions for data transformation from legacy to MSRS report service and RDB. Also I use Tableau and
SnowFlake and dbt to cover project opportunities.

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, Tableau, SnowFlake, 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 kilograms of sugar in each restaurant.

DB Programmer
Feb 2004 - Sep 2005 (1 year)
OTIS, IT department
Elevator company / Head office location
My first experience started at the Kyiv elevator factory. I was responsible for KPI calculation and report systems to improve
the quality of services and notify the 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 an engineer

Kyiv Technical College (Kyiv, Ukraine)
Graduation year: 2005
Programmer
Language skills

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

Courses, Training, 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)