Learn Data Skills
Beta
Oleksandr Solomakha

Oleksandr Solomakha

Senior Data Engineer

http://www.biotech.ca/ | Ottawa, Canada

Technologies

My Portfolio Highlights

My New Track

Python Fundamentals

My New Course

Introduction to Python

My New Track

Python Fundamentals

Analytical pathfinder, blazing trails to new insights and discoveries.

My Work

Take a look at my latest work.

course

Introduction to Functions in Python

course

Intermediate Importing Data in Python

course

Machine Learning for Time Series Data in Python

course

Preprocessing for Machine Learning in Python

course

Introduction to Python

course

Intermediate Python

course

Introduction to Functions in Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

EDX Microsoft degree in Data Science

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

BIOTECanada | Nov 2019 - Present

Director, Data Research and Analysis

• Developed and applied Natural Language Processing techniques for further Classification and Topic Modelling of datasets related to Biotech Industry • Provided guidance and specialized data science assistance for resource management optimization and marketing campaign optimization projects • Created and automated easily refreshable data model for royalty distribution. Applied classical linear programming methods taking into account several business logic rules, constraints and assumptions. • Leveraged Microsoft Cognitive Services Text Analytics to extract the key words and detect named entities from the returned Json file and implemented Sentiment Analysis in Power BI
Show More

Nokia | Aug 2019 - Nov 2019

Business Intelligence Consultant

• Provided the design/development of complex reports and dashboards to support business needs of Optical Business Operations team • Verified and improved data cleansing processes for ongoing reports • Applied advanced Gurobi solutions to price optimization and supply chain management projects • Initiated and managed ETL data manipulation that put data from multiple sources in one place to enable programmatically analyze and discover business insights • Interpreted data, analyzed results using statistical techniques, identifying patterns in complex data sets • Managed communication at senior and executive level independently performing tasks from end to end

Canadian Coast Guard/Garde côtière canadienne | Feb 2019 - Jun 2019

Senior Business Intelligence Analyst

• Created Ice Thickness prediction model with 97% accuracy ratio using Boosted Decision Tree Regression module in Azure Machine Learning Studio • Leveraged Agile approach to design from scratch advanced Power BI dashboard aimed to track daily performance of the underlying ETL process transferring cleaned tables from Coast Guard’s financial database to Azure SQL database used for Business Intelligence purposes • Gathered complex business requirements from financial department defining business problems and data requirements • Translated business requirements into specifications that are used by Business Intelligence team to implement innovative reports and dashboards

Distributel | May 2018 - Feb 2019

Telecom Cost Analyst

• Initiated changes to improve primary repository of all documents related to telecom costs of goods topic (invoices, contracts, service agreements, etc.) • Provided active monitoring, analysis of problems' root causes, preventative maintenance, extended service and continuous improvement of the stability and availability of the applications • Successfully resolved diagnosing issues of raw datasets (outliers, missing values, and duplicate rows) and cleaned data using Python to get it into a form ready for analysis • Leveraging Microsoft Power Query and Excel designed dashboard reports and implemented the feature to drill down invoices to obtain detailed circuit inventory breakdown • Introduced innovative approach of converting unstructured data from multiple PDF files into tabled structured CSV files • Performed deep analysis of all COG-invoices ensuring accuracy of costs through database audits, invoice reviews, report analyses and comparisons • Audited variances in billing and performed periodic audits to ensure integrity throughout the telecom validation process, interpreted the results and presented solutions to the discrepancies • Supported other areas such as Finance, Service Operations as a subject matter expert

Softina | Feb 2016 - May 2018

Data Scientist / Business Process Analyst

• Created, tested and improved full-scale working model (credit risks, fraud detection, loan granting, NLP) using Python, R, MS Azure machine learning, Gurobi, PySpark, Power BI, Tableau and data mining tools resulting in 200,000$ savings • Evaluated the evidence in support of existing marketing strategies for different stakeholders drawing on the evidence-based framework • Supported 12 web applications, including database connection configurations, writing technical/support documentation used in maintaining knowledge bases • Performed quantitative data analysis using a variety of statistical techniques for fraud detection, credit risk, NLP, demand estimation, customer behavior prediction using MS Azure ML • Argued the choice of target audience for marketing campaigns • Managed attendance, scheduling, budgeting and reporting at clinics/ department levels providing financial analysis and timely feedback • Designed and deployed new segmentation and advanced KPIs that best represent progress against the objective and build consensus with all engaged departments • Created, tested and improved predictive analytics business model using MS Azure ML • Implemented cleaning procedures supporting transformation and integration of the data using R, Python, Git, DAX, SQL, Jira, MS Power Pivot, Power BI, Power Query and Power Maps

The Canadian Medical Protective Association | Mar 2017 - Mar 2018

Data Analyst

• As Senior Programmer/Software Developer, produced BI requirements analysis, designing, developing, testing and deploying Cognos reports and dashboards to meet with client’s objectives, needs and priorities. • Participated in the ETL design, providing input and recommendations on how to properly develop and implement the complex processes, optimize processes and tasks, minimize redundancy, meet technical goals, ensuring symmetry of work and improving efficiency within project team. • Participated in the ETL design, providing guidance on best practices, adapted principles, steps to take and patterns to adopt to properly maintain project. • Participated with the IT sector, accessed relational databases, viewed tables structures and proposed data structure and processes changes, providing alternatives and guiding team members on best practices and processes to ensure alignment of work with client’s vision, needs and technical restrictions. • Participated in preparing cut-over procedures, implemented all Cognos Uses Cases and created and optimized budgeting, forecasting and hierarchical dimensions and cubes to improve efficiency and to meet with client’s objectives, ensuring alignment of work with client’s objectives, standards and policies. • Built various data mart type schema, providing guidance and technical advice on best practices and processes to implement proper models and to optimize use of data within DW. • Delivered the complete end-to-end solution according to the business requirements using IBM COGNOS BI. • Participated to multiple meetings, JAD sessions, presentations and working sessions to support the preparation of a development strategy and discuss, gather, review and analyze business, system and functional requirements, analyzing, clarifying, interpreting, testing and integrating these steps to ensure compliance of work with client’s vision and goals delivering end to end this BI solution.

Digital Opportunity Trust | Apr 2014 - Dec 2015

Finance Systems Manager

• Performed statistical and financial monitoring, fund-based accounting and compliance checks on programs and projects including review and revision of cost allocations • Designed data mapping and transformation rules for data validations and controls • Proactively performed data analysis of large unstructured and structured datasets • Implemented business tools and achieved extensive progress in IntAcct system improvements related to financial reporting resulting in consolidated statements being available directly in Cloud ERP Software IntAcct system upon request • As a dedicated MS Excel expert I trained DOT colleagues how to use pivot tables effectively while making detailed variance analysis for appropriate projected cost distribution across active project budgets and affiliate core reserves • Provided prompt and accurate written instructions to country offices pertaining to financial aspects of project proposal development and evaluation

Veterans Affairs Canada | Nov 2013 - Apr 2014

Administrative Assistant

• Controlled and coordinated workload distribution among case managers and client service agents • Designed and implemented measurement framework and management HR reports • Verified and processed payment documentation for program expenditures • Provided administrative and veteran client services support

NSBC "Ukrainskiy proryv" | Aug 2010 - Sep 2012

Senior Business Controller

• Supervised, trained and recruited a team of five marketing campaigns controllers • Provided expertise in the planning, modeling, execution, analysis and insight of digital and direct marketing programs • Developed, implemented and automated internal control system for eight business units • Justified the choice of target audience for marketing communication • Transformed budget planning into a unified analytical process, resulted in significant improved accuracy of corporate revenue projection • Improved budgeting preparation procedure, interconnected with financial statements, summaries and management reports

Bertelsmann SE & Co. KGaA | Feb 2008 - Dec 2009

Senior Business Analyst / Data Architect

• Defined cluster for 7 million clients’ database • Performed advanced analytics for all types of recruitment and retention activities • Directed and coordinated financial, marketing and statistical processes using KPIs reports and risk management statements • Designed tool for calculating ROI of recruitment, resulting in USD 400 k yearly saving • Supported the integration of Marketing, Sales and Finance data into a single updated database format, resulted in faster retrieval of higher quality analytics • Improved financial decision support system by enhancing forecasting and budgeting implementing systematic variance analysis and comprehensive sales report analysis with following counsels • Supervised a team of three finance analysts

Bertelsmann SE & Co. KGaA | Jul 2002 - Feb 2008

Management Information Manager

• Developed and implemented membership classification system- databaseusing Cognos, SAP, Sybase • Designed and executed the business controlling Excel based tool of retailchain (71 shops), which covers the biggest cities of Ukraine • Supervised MIFO and ROI projects that every Bertelsmann’s profit centermust implement • Designed and implemented store chain and email marketing developmentstrategy • Controlled primary sales and marketing measures (membershipdevelopment, turnover, costs)

Bookclub Family Leisure Club | Jul 2001 - Jul 2002

Analyst, Statistics and Forecasting

• Developed and implemented classification system-database that enabled structured and controlled work with target groups • Processed sales and inventory statistics and forecasts

ESCC European School for Correspondence Courses | Oct 1998 - Jun 2000

Marketing Research Specialist

• Produced statistical analysis and reports on marketing channel effectiveness • Conducted marketing research and made proposals on marketing actions • Researched and made proposal on selection of most effective recruitment channels

My Education

Take a look at my formal education

Microsoft degree in Data Science edX | 2017
Certificate of Financial Management, Financial ManagementPerspectiva consulting center | 2009
Project Manager, Software Project ManagerTelesens Academy | 2003
Master of Science (MSc), Industrial Engineering & ManagementNational Technical University "Kharkiv Polytechnic Institute" | 1998
Working towards being a Chartered Professional Accountant, 6 modulesCPA Canada

About Me

Oleksandr Solomakha

Over the past 20 years, I have researched, developed and tested hundreds of customer relationship management solutions and advanced statistical models for a variety of clients.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free