Beta

Alexander Doan

Graduate

Mohawk College

Technologies

My Portfolio Highlights

My New Workbook

Explore a DataFrame

My New Course

Introduction to SQL

My New Workbook

Introduction to SQL

My New Workbook

Explore a DataFrame

Data wizard, conjuring insights from the depths of complex datasets.

My Work

Take a look at my latest work.

DataLab

Explore a DataFrame

course

Introduction to SQL

DataLab

Introduction to SQL

DataLab

Explore a DataFrame

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

IIBA Entry Certificate in Business Analysis

Mohawk College Lean Six Sigma - Yellow Belt

IBM Business Intelligence Analyst - Intermediate

DataCamp Course Completion

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

Courses

Introduction to SQL

Intermediate SQL

Introduction to Tableau

Courses

Introduction to SQL

Intermediate SQL

Introduction to Tableau

My Work Experience

Where I've interned and worked during my career.

Fortinos | Aug 2022 - Oct 2022

Business Analyst Intern Deli/Bakery/HMR

• Leveraged advanced excel functions to develop reporting formats that monitor product performance on a WTD, YTD, and YOY basis to aid management in making crucial decisions on product pricing and stock in 24 store locations. • Implemented new techniques to automate manual administrative tasks and improve workplace efficiency. • Analyzed raw data from MicroStrategy and prepared records for use in reports and visualizations to provide an overview of product supply movement from warehouse to store. • Produced infographics that condensed onboarding information to improve employee training during product launches. • Utilized SAP to query vital product information to maintain data integrity and replenish product inventory across all store locations.

Mohawk College | Jan 2022 - Apr 2022

Business Analyst Intern

Term Project: Improving Continuing Education Application Process • Analyzed documents to identify and plan an approach for collaboration with stakeholders to ensure effective communication strategies, drafting use cases to be translated into test cases and identifying functional and non-functional requirements. • Specified and modelled requirements to visualize current and future states to facilitate stakeholder understanding. • Successfully applied project management approached to lead a team on a short-term work schedule and facilitated group meetings on a small diverse team using SCRUM methodology to ensure project delivers value-adding solutions. • Utilized techniques outlined in the Business Analysis Body of Knowledge (BABOK) to facilitate requirements gathering activities and manage team collaboration.

Sofina Foods Inc. | Apr 2018 - Aug 2018

QA Laboratory Technician

• Operated lab equipment such as centrifuge, fume hood, incubator, autoclave, Bunsen burner, electronic pipettes, and titration assay to produce accurate test results. • Independently oversaw lab operations, initiated quality assurance procedures and maintenance of laboratory equipment utilizing a high level of attention to detail. • Promoted health and safety by following proper regulations, wearing personal protective equipment (PPE) and ensuring employees follow appropriate safety procedures to prevent workplace accidents. • Managed and documented existing processes to develop an as-is model to determine areas for improvement in accordance with the business process management lifecycle. • Investigated anomalies in KPI’s to determine the root cause and recommend potential solutions to successfully restore process performance to optimal conditions.

Sofina Foods Inc. | Apr 2017 - Aug 2017

Quality Assurance Technician

• Independently assessed products and completed food safety tests within a strict time constraint to provide quality products free from contamination. • Oversaw product handling processes throughout the business by ensuring activities were aligned with documented procedures. • Performed data entry and data compilation into an electronic database to allow easy retrieval of information on products. • Analyzed data to assist in the implementation of preventative procedures to safeguard against spoilage. • Executed internal and external quality audits, and operational reviews and projects to deliver timely results to stakeholders on quality issues and recommend solutions to improve product-handling • Showcased teamwork abilities by collaborating with government authorities to carry out inspections on incoming products, cross-referencing results to determine the presence of a defect. • Produced new documentation by leveraging Microsoft Office tools to compile physical data onto an online format in the last 5 years of company operation.

My Education

Take a look at my formal education

Graduate Certificate in Business AnalysisMohawk College | 2022

Bachelors of Science in Honours ScienceUniversity of Waterloo | 2021

About Me

We are currently living in a data-driven world. Data is necessary to make the right judgement and to carry out the most appropriate decisions.

Create Your Data Portfolio for Free