Микола

Mykola Troian

CONTACT Phone: [відкрити контакти](див. вище в блоці «контактна інформація»)
Email: [відкрити контакти](див. вище в блоці «контактна інформація»)

PROFESSIONAL ​FEBRUARY 2025 – PRESENT
EXPERIENCE Data Analyst and Data Scientist

Performed complex data extraction and manipulation using advanced SQL queries
to prepare large datasets for analysis.
Designed and developed interactive dashboards and comprehensive reports to
visualize data trends, enabling stakeholders to track KPIs effectively.
Conducted advanced statistical analysis, including regression and correlation, to
identify key business drivers and patterns.
Developed and implemented machine learning models to support predictive
analytics and optimize internal processes.
Automated reporting workflows, significantly reducing manual data handling time.

NOVEMBER 2023 – JANUARY 2025
Billing Specialist (Tech sub-team)

Managed bill issuing and related operations, communicating effectively with
managers and requestors across various European markets.
Leveraged Alteryx and SQL to query databases and assist colleagues with complex
data requests, ensuring data accuracy.
Developed automation scripts using JavaScript for spreadsheets, which
streamlined billing processes and eliminated manual errors.
Created dynamic dashboards with formula-based interconnections to support
team monitoring and reporting.
Mentored newcomers from scratch and proactively resolved technical issues
before they impacted operations.

EDUCATION September 2019 — May 2023
​Higher, National Technical University of Ukraine “Igor Sikorsky
Kyiv Polytechnic Institute”, Kyiv
Faculty: Faculty of Physics and Mathematics
Specialty:
​
Mathematical and computer methods in modeling dynamic
systems.
​
Insurance and financial mathematics.