Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Roman Porublyovyy

Winnipeg,MB

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

13
13
years of professional experience

Work History

Data Analyst

NFI Parts
01.2022 - Current
  • Created Excel based tools (combining VBA, Power Query, Power Pivot and SQL) to streamline several business processes
  • Used advanced Power Query functionality that allows end users to pass any parameters, including large lists, directly to SQL query
  • Retrieved data was further processed into numerous reports with Excel formulas, more standard Power Query steps or Power Pivot
  • Wrote SQL queries to build reports and extract data on ad hoc basis from Oracle database
  • Created multiple Power BI reports, some of high complexity, to meet needs of internal customers and answer questions about business operations
  • Implemented Power BI reporting based around shared datasets
  • Leveraged composite data model in Power BI to create report that brings together KPI’s from 9 other reports to create single page “dashboard” for buyers to use
  • Unlike built Power BI dashboard functionality this allows for all visuals to be filtered simultaneously
  • Used Power BI in conjunction with Python to develop tool that suggests best way to expedite late purchase orders based on specific logic that tracks all sources of supply and allocates them to sales orders
  • Create Power BI report that tracks supplier price increases against prices of input commodities for each given supplier
  • Ran several routine reports that require some data manipulation
  • Used Power Automate to create and send out non-standard notifications.

Commercial Operations Analyst

Medicure Inc
11.2018 - 01.2022
  • Generation of regular reports
  • Administered and customized Dynamics 365 for Customer Engagement
  • Created and edited forms, business rules, views, entities, process flows, managed roles, implemented 3rd party solutions
  • Automated routine business processes with Power Automate
  • Developed app using Microsoft PowerApps framework to track interactions of customers/potential customers with company’s marketing materials
  • Providing data-driven support for business decisions
  • Created new and edited existing Power BI Reports
  • By applying Power Pivot and DAX improved and streamlined existing Excel reports generated within other departments
  • Used Power BI and advanced DAX scripting to create sales bonus calculation and tracking system that considers complexities of real-life business operations
  • Wrote web-scrapping scripts in Python when assigned with data collection tasks
  • Used Python to manipulate large amounts of data and to automate some routine tasks
  • Used Azure Data Factory to preform basic ETL tasks
  • Oversaw sales territory creation and realignments.

Production Analyst

Palliser Furniture
07.2017 - 11.2018
  • Calculating employee efficiency bonuses
  • Generation and optimization of reports for senior management, often with use of Excel Macros
  • Data collection and analysis
  • Implementation of initiatives aimed at improving production and inventory visibility
  • Production scheduling

Security Guard

Paladin Security, Manitoba Hydro
01.2011 - 01.2017
  • Stationed at 360 Portage, Place
  • Handling emergency situations and alarms
  • Performing reception desk duties
  • Controlling access to and overseeing normal operations of high-rise building
  • Handling various requests of Manitoba Hydro employees and visitors
  • Writing detailed and accurate reports

Education

Microsoft Certified: Azure Data Fundamentals -

Microsoft
08.2023

Microsoft Certified: Azure Fundamentals -

Microsoft
07.2023

Advanced DAX For Microsoft Power BI Desktop -

Udemy.com
07.2021

Python For Data Science And Machine Learning Bootcamp -

Udemy.com
08.2018

Python For Finance: Investment Fundamentals & Data -

Udemy.com
08.2018

Python 3: Deep Dive (Part1) -

Udemy.com
07.2018

Data Analysis With Pandas And Python -

Udemy.com
05.2018

MySQL For Data Analytics And Business Intelligence -

Udemy.com
03.2018

Python Beyond The Basics - Object-Oriented Program -

Udemy.com
03.2018

Python For Everybody Specialization -

Coursera.com
03.2018

Level 1 Exam -

CFA Institutes
12.2017

BBA - Finance, Supply Chain Management

I.H. Asper School of Business, University of Manitoba
06.2017

Skills

  • Microsoft Dynamics 365
  • Microsoft PowerApps
  • Power Automate
  • Power Query
  • Beginner to Intermediate C#
  • MS Office Suite including Word, Excel, Access
  • Excel VBA
  • Power BI, DAX
  • Power Pivot
  • SQL (MySQL, Oracle SQL)
  • Beginner to intermediate level of skill in Python Programming Language (including Pandas, Beautiful Soup, MatplotLib, Seaborn)

Languages

English
Full Professional
Ukrainian
Native or Bilingual
Russian
Native or Bilingual

Timeline

Data Analyst

NFI Parts
01.2022 - Current

Commercial Operations Analyst

Medicure Inc
11.2018 - 01.2022

Production Analyst

Palliser Furniture
07.2017 - 11.2018

Security Guard

Paladin Security, Manitoba Hydro
01.2011 - 01.2017

Microsoft Certified: Azure Data Fundamentals -

Microsoft

Microsoft Certified: Azure Fundamentals -

Microsoft

Advanced DAX For Microsoft Power BI Desktop -

Udemy.com

Python For Data Science And Machine Learning Bootcamp -

Udemy.com

Python For Finance: Investment Fundamentals & Data -

Udemy.com

Python 3: Deep Dive (Part1) -

Udemy.com

Data Analysis With Pandas And Python -

Udemy.com

MySQL For Data Analytics And Business Intelligence -

Udemy.com

Python Beyond The Basics - Object-Oriented Program -

Udemy.com

Python For Everybody Specialization -

Coursera.com

Level 1 Exam -

CFA Institutes

BBA - Finance, Supply Chain Management

I.H. Asper School of Business, University of Manitoba

Similar Profiles

CREATE PROFILE
Roman Porublyovyy