Power BI
Alexandre Baharov
Data Annalyst
Pierrefonds,QC
Summary
Multi-tasking and detail-focused specialist, well-known for successfully taking projects from beginning to completion. Polished and professional, offering proficiency in Power BI, SQL, Python, R, VBA, and machine learning solutions. Commended for consistently meeting new technical challenges and finding solutions to satisfy customer needs and business objectives.
Overview
12
12
years of professional experience
7
7
Years of experience with python
5
5
Years of experience with Power BI
6
6
Years of post-collegial education
11
11
Certificates
3
3
Languages
Work History
Consultant
EFESO Consulting
New York, NY
09.2021 - Current
- Created four data cleaning, analyses, reporting, and visualizations to support key process indicators (KPI) at different business levels.
- Created data analysis and dashboard to support distribution center business insights.
- Perform data collection, cleaning, and analysis of production data using Power BI.
- Piloted process mining using Power BI and PAFNow.
- Lead implementations of digital OpEx 4.0 Solvace platform at clients’ sites, linking it to current standards and coaching all involved parties.
Reliability Engineer
ITF Technologies
Montreal, QC
05.2020 - 09.2021
- Performed more than 30 reliability data manipulations from start to end: data collection, cleaning, exploration, statistical analysis and reporting using Python, SQL, R, VBA, and Latex.
- Developed documentation, diagrams, and specifications to meet project requirements and regulatory standards
- Implemented company-wide solution for data collection and follow-up of statistical process control and capability for key process indices from MES and ERP.
- Implemented Measurement System Analysis programs for three major projects using ANOVA, AIAG, or EMP statistical analysis.
- Redacted detailed reliability reports to internal and/or external clients.
- Designed twelve statistical tests that pinpoint various failure mechanisms (DOE).
Process Engineer
ITF Technologies
Montreal, QC
05.2018 - 05.2020
- Created three solutions for analysis and follow-up of key performance indicators, productivity, efficiency, and financial margins using Power BI, SQL, and VBA.
- Created three dashboards for communicating results using Power BI and Excel.
- Performed daily production analysis of MES data using SQL, Python, and R.
- Managed and improved production process involved generating more than 15 Million dollars of annual income.
- Managed multidisciplinary team composed of industrial and software technicians.
- Established project schedules and monitored tasks to meet milestones during each phase.
- Conducted root cause analysis to identify, prioritize and eliminate process losses
R&D Engineer
ITF Technologies
Montreal, QC
09.2016 - 05.2018
- Implemented machine vision solution for optical fiber-core analysis and station motor alignments using Python and OpenCV.
- Performed daily production analysis of MES data using SQL, Python, and R.
- Performed daily optical fiber analysis using Python and OpenCV.
- Implement VBA solution with user interface for finished goods matching.
- Led continuous improvement projects.
- Optimized future production workstations.
Production Manager
Comprod Communications
Boucherville, QC
02.2016 - 09.2016
- Led production department operations and 15% efficiency increase.
- Led purchasing departments and standardized purchasing procedures.
- Led incoming and shipping department and achieved 100% on-time delivery.
Production Engineer
ITF Technologies
Montreal, QC
04.2012 - 02.2016
- Analyzed and explored daily production data using VBA.
- Collaborated with ERP system implementation with data cleaning and preparation.
- Assisted in continuous improvement projects.
- Supervised production with 17 operators.
- Managed incoming and shipping department with two clerks.
Application Specialist
Isaac Instruments
Chambly, QC
04.2010 - 11.2011
- Set up SQL databases at customers’ site(s) for data collection.
- Configured hardware and software and linked with SQL databases for successful data collection.
- Established communication channels between customers and the R&D team.
- Created manuals and published guidelines for proper use of systems.
Education
MicroMasters - Data Science (online)
10.2019 - 12.2020
Bachelor of Science - Industrial Engineering
09.2004 - 04.2009
Skills
Data cleaning and preparation
undefinedCertification
Production Part Approval Process (PPAP)
Software
Excel
Access
Jupyter
Micorosoft NAV/ERP
Pycharm
Microsoft Sharepoint
Atlassian Jira
Timeline
Consultant - EFESO Consulting
09.2021 - Current
Production Part Approval Process (PPAP)
02-2021
Reliability Engineer - ITF Technologies
05.2020 - 09.2021
University of California - MicroMasters, Data Science (online)
10.2019 - 12.2020
Microsoft: Data Science Core
09-2019
Microsoft: Python for Data Science
09-2019
Microsoft: Ethics and Law in Data and Analytics
06-2019
Lean Six Sigma Green Belt
03-2019
Microsoft: Analytics Storytelling for Impact
12-2018
Managerial Leadership
12-2018
Process Engineer - ITF Technologies
05.2018 - 05.2020
Microsoft: Querying Data with Transact-SQL
12-2017
ISO 9001-2015 Internal Auditor
05-2017
Microsoft: Analyzing and Visualizing Data with Power BI
03-2017
R&D Engineer - ITF Technologies
09.2016 - 05.2018
Production Manager - Comprod Communications
02.2016 - 09.2016
Design Of Experiments (DOE)
03-2013
Production Engineer - ITF Technologies
04.2012 - 02.2016
Application Specialist - Isaac Instruments
04.2010 - 11.2011
Concordia University - Bachelor of Science, Industrial Engineering
09.2004 - 04.2009
Similar Profiles
BHARAT JAINBHARAT JAIN
Principal at EFESO IndiaPrincipal at EFESO India
Raghav P. Ramesh BabuRaghav P. Ramesh Babu
Sr. Consultant - Supply Chain Transformation at AIONEERS-EFESO Professional ServicesSr. Consultant - Supply Chain Transformation at AIONEERS-EFESO Professional Services
PRAVEEN KUMARPRAVEEN KUMAR
Senior Technology Manager at Business Consulting and Solutions, RXG Business Consulting and SolutionsSenior Technology Manager at Business Consulting and Solutions, RXG Business Consulting and Solutions