Oleg Kazanskyi Email & Phone Number

Canada

Canada

- Working with a team of engineers on a BI system that serves as a single source of truth, combining big volumes of data from nine ERPs across entities around the globe.- Creating, developing, deploying and maintaining sophisticated datasets focusing on high feedback speed across reports.Tools: Tabular Editor, C#, DAX, Power BI, PowerQuery- Working in an Agile environment with constant improvements and a regular learning approach.- Developing solutions for continuous monitoring of the data quality and performance.Tools: PowerAutomate. Data Lake, Data Warehouse, Sharepoint.- Working on machine learning models for forecasting. 1. Created a Time Series ML model for forecasting sales with an accuracy of an average of 30% better than the existing benchmark.Tools: SQL, Python, Pandas, Numpy, Statsmodel, Matplotlib, SARIMA, Exponential Smoothing.2. Made a model for the analysis of items most frequently bought togetherTools: Python, Pandas, Numpy, MLXtend, PowerBI, SQL, Jupyter, Spark, Apriori, FPGrowth, Sparse matrices.

Toronto, Ontario, Canada

- Established a "Data Culture" on organization-level BI reporting with clearly documented rules and requirements within the company.The company had a self-service business intelligence model with many BI developers that led to inconsistencies with the single source of truth. Setting up new rules, following the implementation of BI best practices, allowed the creation of a thriving BI environment with a self-serve culture.- Developed the scripts and tools required for proper management of the BI reporting system: 1. Created full visibility of reports usage statistics (# of openings, views, lags by user and department) for the dashboards across the organization.Tools: PowerShell, SSAS DMV Queries, Power BI, PowerAutomate 2. Created scripts that collect and visualize information about used data sources across all the Power BI Reports inside the organization with easy navigation on a table and even a column level.Tools: PowerShell, SSAS DMV Queries, Power BI, DAX, PowerQuery, PowerAutomate 3. Set up Power BI datasets and dataflow version control and storage system.Tools: Data Lake, Azure Storage, Dataflow.- Developed a PowerBI solution involving ML to analyze churn rate using Key Influencers visual inside the existing reports- Worked on sales forecast using Power BI dataflow built-in analytics.- Reached flawless performance of the critical Power BI reports with a long history of interruptions and operational issues.Tools: Dataflow, M Language, DAX.- Great data visualization and data analysis skills.

Moncton, New Brunswick, Canada

- Production Data Analysis. I created a data model that helps understand the influence of the growing cycle parameters on the harvest results. The list of parameters included Temperature, Humidity, CO2, Watering measurements (5min intervals) over the growing cycle and cultivation techniques. I applied Machine learning for data analysis and prediction.Tools used: Prediction: PCA, Clustering, Decision trees, Random Forest and Boosting techniques of Scikit learn.Data Transformation: Pandas, Numpy, DAX and PowerQuery.Visualization Seaborn, Matplotlib, PowerBI- Sales and Marketing. I created a Power BI semantic model with numerous reports and dashboards. The company received quick access to market information and sales KPIs visualization. That allowed us to react 3 times faster to any market changes and make information-based decisions. - Demand Planning. I implemented a full interconnection of the existing sales data with the future forecast and production capacity. The automated solution allowed the company to save 3200 man-hours a year in the planning department and achieve better materials forecasting.Tools used: Python automation, SQL integration, PowerBI reports and data transformation.- Quality assurance. Visualization of the customers’ complaints and other quality-related problems allowed us to detect the critical points and address them 2 times faster with a full reporting process automation.

Moncton, New Brunswick, Canada

Ukraine

- Set up sales of all the Adducate inc. brands on the Amazon marketplace (in the USA and Canada);- A full market analysis of the Toys categories was performed with definition of available and competitive areas;- Pricing determination;- Initial marketing setup with targeting on Amazon audience;- Led the project from the initiation stage to the full availability of the products on the marketplace. - 4 products got a “Amazon’s choice” mark after just 6 months of sales.

Ukraine

• Successful cooperation with the biggest retail appliance chains in Ukraine (Foxtrot, Comfy, MoYo, Rozetka, Allo);• Established 30 brand zones in the stores all over the country;• Private label cooperation with the biggest electricity provider on the market - DTEK company;• Becoming one of the best top selling Smart gadgets brand in Ukraine;• Sales grow 400% in 2 years;

Kyiv, Ukraine

• Ensuring tenders performance by department in strict timeline;• Ensuring a steady supply for production;• The department’s KPIs were improved for 30%, in particular of supply synchronicity (affects on storage level and possibility of production disruptions);• Improvement of existing and development of new working procedures;• Review and approval of a contract documentation (Contracts, Specifications, Tenders);

Kyiv

- Holding tenders for equipment and raw materials (substances, excipients, packaging materials); - Lead negotiations with suppliers in order to achieve best commercial terms and conditions;- Lead negotiations with domestic and foreign companies regarding development of current business activities and products (contract manufacturing, supply agreements);- Perform qualitative market survey in order to find a product with best matching characteristics (in-bulk, substances, raw materials, equipment, packaging materials);- Ensuring with documentation for registration of API and materials referring to Ukrainian legislation;- Preparation of contracts and its coordination with internal Customers (Confidential Agreements, Supply Agreements, Strategic Agreements);- Implementation of new materials and alternative manufacturers into internal documentation for the purpose of financial and economical safety of the company;

- Holding tenders for equipment and materials; - Negotiations with domestic and foreign companies;- Implementation of deliveries of domestic and imported goods;- Working with claims and returns;- Drafting of contracts;- Work with carriers;- Preparation of documents for custom clearance; - Managing of stock level;- Arranging deliveries according to forecasts of future consumption;- Search and implementation of alternative suppliers of raw materials;- Auditing of suppliers.

Certificate, Data Science And Business Analytics

DATA ANALYSIS WITH PYTHON, DATA VISUALIZATION WITH TABLEAU, BUSINESS STATISTICS, SUPERVISED LEARNING FOUNDATIONS, ENSEMBLE TECHNIQUES.

Master'S Degree, Finance