Summary
Overview
Work History
Education
Skills
Volunteer Experience
Additional Learning
Affiliations
Timeline
Generic

David Cho

Toronto,Canada

Summary

Senior Business Analyst with over 9 years of experience driving data-informed decision-making through advanced data analysis, project management, and technology integration. Proven expertise in developing sophisticated Excel models and automating reporting workflows, improving data accuracy and operational efficiency by up to 30%. Adept at collaborating with cross-functional stakeholders to gather requirements, perform root cause analysis, and translate business needs into actionable solutions. Committed to leveraging deep analytical skills and business acumen to guide strategic initiatives and deliver measurable business value.

Overview

8
8
years of professional experience

Work History

Business & Financial Analyst

CITY OF TORONTO
Toronto, Canada
12.2022 - Current
  • Spearhead project deliverables and strategize business process executions which resulted in an increase in productivity by 25%.
  • Present succinct project status updates and solutions to stakeholders and management to increase transparency, alignment, and communication.
  • Facilitate and lead cross-departmental team planning sessions to enhance data accuracy while documenting, analyzing, and updating business processes.
  • Create Microsoft MS Excel templates utilizing advanced validation rules to reduce data entry input errors by 20%.
  • Streamline report generation process by creating macros/VBA, automating the data compilation and analysis, and enhancing productivity by 30%.
  • Strategizing a new data analysis methodology to enable team members to review large sets of data in a timely manner to meet deliverable deadlines.
  • Evaluate City of Toronto's financial, asset and grant data to strategize next steps to correctly cleanse, map, migrate data, and provide data-driven recommendations to stakeholders.
  • Investigate comprehensive reporting issues on financial data in SAP ECC by identifying the root cause, analyzing the data, and engaging with divisional subject matter experts (SMEs) to resolve the issues.
  • Took the initiative to learn Udemy Excel courses, attended advanced MS Excel workshops and subscriptions to stay ahead in data analysis/validation and automation techniques resulting in the reduction of financial data discrepancies by 25%.
  • Boost team collaboration by coaching and supporting colleagues on best practices in financial data analysis by conducting one-on-one sessions to increase confidence and competence within the team.

Manager, Dietitian and Wellness Programs

LOBLAWS
Mississauga, Canada
02.2021 - 12.2022
  • Spearheaded strategic development for performance, revenue, and reconciliation reporting, delivering data-driven reports to senior management.
  • Established Standard Operating Procedures [SOPs] for technology training, the on/offboarding process and continual improvement projects, focusing on data and sales reporting.
  • Optimized team dynamics by restructuring the onboarding process, minimizing ramp up time for new onboards.
  • Analyzed and automated Wellness Program data with Macro and VBA coding to cleanse and enrich data with applicable attributes reducing staff's efforts to complete manual entry by 60%.
  • Increased data accuracy in dietary reports by auto-populating required data fields with logic-based responses and incorporating data-validation, reducing potential manual errors by 30%.
  • Investigated and resolved financial inconsistencies with Accounts Receivable team regarding an evolving online payment process and system ensuring that it aligns with GAAP.
  • Consolidated, cleansed, and enriched large sets of financial data extracted from various insurer web portals and prepared comprehensive weekly, monthly, quarterly, and annual financial reports for Senior Management.
  • Led data cleansing activities and restricting values with data validation techniques and conditional formatting to significantly boosting system reliability and documenting standard operating procedures for future use.
  • Enhanced team performance through targeted training and troubleshooting for the new online Point of Sales [POS] platforms.

Master Data Analyst

LOBLAWS
Mississauga, Canada
06.2019 - 02.2021
  • Managed Loblaw's master data by monitoring, developing databases, implementing standards, and ensuring accuracy and timely execution of all requests.
  • Proactively identified and rectified data gaps.
  • Coordinated with other departments for data creation and maintenance.
  • Audited master data routinely to ensure compliance with internal data governance policies.
  • Streamlined data validation processes by defining clear validation rules, automating the validation, leveraging any available validation libraries, and implementing data cleansing to enhance data integrity and reliability.
  • Enhanced report generation speed by 30% by utilizing caching in SAP, data integration tools such as Extract, Transform, Load (ETL) tools to efficiently integrate and enrich data from multiple silos.
  • Maintained positive relationships with stakeholders providing clear and frequent communication updates.
  • Facilitated cross-departmental workshops to align data management strategies.
  • Conducted in-depth data trend analysis to forecast and mitigate risks.
  • Automated repetitive tasks created new validation rules and pre-populated previously manual data fields using logic-based advanced MS Excel formulas.
  • Teamed up with IT to create a real-time data dashboard, enabling quicker decision-making by providing instant access to key performance metrics.

Data Consultant (Contract)

LOBLAWS
Mississauga, Canada
03.2019 - 06.2019
  • Managed multivendor issues, enhancing Document Change Requests [DCR] processing efficiency.
  • Streamlined data management, boosting SAP system accuracy.
  • Developed SOPs, increasing data entry precision and team productivity.
  • Maintained high data integrity for UPCs, ensuring reliable company metrics.
  • Uphold stringent data integrity standards for accurate UPC management.
  • Guided team in data management best practices, boosting operational accuracy.
  • Fostered a collaborative team environment to elevate data handling skills.

Data Specialist

CURTIS INTERNATIONAL
Mississauga, Canada
03.2018 - 03.2019
  • Streamlined data integration with advanced Microsoft Excel functions.
  • Automated routine tasks to boost data processing efficiency.
  • Implemented rigorous validation techniques to ensure data integrity.
  • Enhanced invoice accuracy by meticulous application of V lookup and pivot table analyses.
  • Ensured 99% data accuracy by employing advanced validation protocols.
  • Developed innovative data consolidation methods for optimized reporting.
  • Pioneered innovative data consolidation techniques with MS Word and MS Excel to streamline reporting processes.
  • Refined financial forecasting through cross-departmental collaboration.
  • Mentored junior data analysts, improving team skills and project outcomes.

Special Operations Supervisor

CONSOLIDATED FASTFRATE
Woodbridge, Canada
12.2016 - 03.2018
  • Spearheaded operations in a unionized facility, ensuring policy enforcement and accurate reporting.
  • Initiated strategic projects for quality assurance and timely service delivery.
  • Enhanced facility efficiency by implementing data-driven operational adjustments.
  • Pioneered innovative process improvements to enhance service quality.
  • Negotiated with management across all levels to achieve organizational goals.
  • Developed strategic partnerships to streamline supply chain operations.
  • Managed potential claims, reducing escalations by 30% through policy alignment.
  • Mentored junior staff, elevating team performance and morale.
  • Boosted team productivity by fostering a culture of continuous improvement.
  • Cultivated a supportive work environment, increasing staff retention.

Education

Bachelor (Specialized Honours) - Finance and Business Economics

York University
Toronto, ON

Ontario College Diploma - Marketing

Seneca College
Markham, ON

Project Management Certification Candidate -

University of Toronto

Skills

  • Data analysis
  • Accounting/Financial analysis
  • Root cause analysis
  • Strategic planning
  • Change management
  • Process improvement
  • Logistical planning
  • Technology Implementation
  • Data Visualization
  • Develop SOP documentation
  • Performance management
  • Supply Chain Management
  • Project Management
  • Stakeholder engagement
  • Training
  • SAP ECC/S4 HANA
  • VBA automation
  • Financial analysis
  • Data validation
  • Microsoft Excel
  • Stakeholder communication
  • Project management
  • Cross-department collaboration
  • Report generation
  • Team leadership
  • Problem solving
  • Data visualization

Volunteer Experience

  • Pianist, Valleyview Residence Nursing Home, 541 Finch Avenue West, Toronto, ON
  • Kitchen Help, Salvation Army Toronto Harbour Light Ministries, 160 Jarvis Street, Toronto, ON

Additional Learning

  • Udemy, Six Sigma White Belt Certification
  • Udemy, Microsoft Office Shortcuts and Speed Tips
  • Udemy, The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
  • Udemy, Google Analytics for Beginners/ Hands-on Training Course
  • Udemy, Project Management Fundamentals: Crash Course for Beginners

Affiliations

  • Pianist for church and nursing homes
  • Volunteer for the Salvation Army

Timeline

Business & Financial Analyst

CITY OF TORONTO
12.2022 - Current

Manager, Dietitian and Wellness Programs

LOBLAWS
02.2021 - 12.2022

Master Data Analyst

LOBLAWS
06.2019 - 02.2021

Data Consultant (Contract)

LOBLAWS
03.2019 - 06.2019

Data Specialist

CURTIS INTERNATIONAL
03.2018 - 03.2019

Special Operations Supervisor

CONSOLIDATED FASTFRATE
12.2016 - 03.2018

Bachelor (Specialized Honours) - Finance and Business Economics

York University

Ontario College Diploma - Marketing

Seneca College

Project Management Certification Candidate -

University of Toronto

Similar Profiles

CREATE PROFILE
David Cho