Download CV

Resume

I bring expertise in data analytics, process improvement, and business analysis, with a track record of delivering data-driven solutions across various industries.

My Skills

  • Extract Transform Load (ETL)
  • Data Cleaning + Preparation
  • Data Exploration + Analysis
  • Statistical Data Analysis
  • Data Visualization
  • Dashboard Development
  • Insights Reporting + Delivery
  • SQL Querying
  • Predictive Modelling
  • Regression Analysis
  • Classification
  • Business Analysis

Projects Experience

Project-01

Fire Department Business Case

  • Executed project to predict high risk fire areas within the City of Montreal.
  • Enhanced data quality and prepared variables for analysis by conducting data preprocessing and feature engineering on multiple datasets such as fire department data to determine intersections where fires have occurred and the causes; reviewed and cleaned more than 2 million lines of data using Alteryx.
  • Accessed City of Montreal website to extract data related to regional municipalities and their populations.
  • Integrated multiple datasets without a common key by leveraging geospatial data, enabling comprehensive analysis and insights to determine patterns and identify correlation between populations (more residential or commercial) and the risk/likelihood of fire occurrence.
  • Developed a predictive model aimed at identifying high-risk fire areas for the upcoming month; based on model, was able to pinpoint high risk fire areas – results indicated that areas with high rise apartments were most vulnerable due to the lack of municipal resources available to perform regular fire inspections.

01

Fire Department Business Case

Learn More
Project-02

Bike Sharing Company's Revenue Augmentation Proposal

  • Analyzed BIXI’s annual reports to identify areas of opportunity to increase revenue

  • Identified supplementary avenues aligning with the city’s post-COVID mandate to assist small businessses and revitalize the downtown core. This included exploring potential tourism initiatives

  • Proposed revenue-generating opportunites, including designing tourist routes, contests for local residents, leveraging social media, and collaborating with advertising agencies

02

Bike Sharing Company's Revenue Augmentation Proposal

Learn More
Project-03

Restaurant Wine Selection Business Case

  • Built a classification model to categorize wines by type, quality, and profitability and created a
    predictive model for restaurant use to enable selection of profitable wines; data originated from a
    wine-making company and included list of all establishments to which they supply wine.
  • Leveraged SQL statements to extract data from APIs including wine lists, chemical composition, and
    how much profit each brand makes; reviewed and cleaned 400,000 lines of data.
  • Led initiative to enhance data quality and integrity by conducting thorough review and validation of
  • datasets used in BI deliverables, implementing quality control measures to ensure comprehensiveness, efficiency, and accuracy, while adhering to team’s business/data governance requirements and best practices.

03

Restaurant Wine Selection Business Case

Learn More

Employment History

TRIBE CANADA - Toronto, ON

Not-for-profit that provides career and professional development programming/support to underserved communities.

Community Data Analyst (Part-Time) | June 2023 – Present

  • Master collecting and managing data from varied sources, ensuring its accuracy and relevance for community project succcess.
  • Expertly analyze complex datasets to extract meaningful trends and patterns, effectively translating these insights into actionable reports for stakeholders in community projects.
  • Foster collaboration with project teams and community leaders, effectively align data analysis with community needs, and present data-driven insights to non-technical audiences.
  • Evaluate project outcomes against objectives, prepare detailed progress and impact reports, and contribute to strategic planning and implementation of community-focused initiatives.
  • Ensure adherence to legal standards and ethical practices in data handling, particularly in privacy and confidentiality, and remain updated on sector-specific policies and trends.

Manager, Inclusive Education (Part-Time) | Feb 2021 – June 2023

  • Develop financial literacy programs and training for members of equity-deserving communities,
    partnering with community groups to deliver workshops for clients; apply various techniques to help
    motivate, engage, and prompt participants to take positive financial action.
  • Employ strong analytically-anchored problem-solving skills, applying robust critical reasoning
    capabilities to proactively identify risks and issues and recommend solutions for coaching clients.
CANADIAN IMPERIAL BANK OF COMMERCE (CIBC), Toronto ON

Client Loyalty Representative | Oct. 2018 – Sept. 2021

  • Demonstrated a client-centric approach, focused on cultivating lasting customer relationships by
    providing personalized financial guidance, addressing concerns, and ensuring exceptional service
    delivery throughout the banking journey.
  • Increased team’s client experience (NPS) score 25% by achieving the highest personal NPS through
    delivery of exceptional service to clients; 80% of calls were rated as “Promoter”.
  • Reviewed and resolved escalated issues and supported clients to use self-service options, leading to
    expedited issue resolution and increased client independence, reducing call volume and labor costs
    for CIBC.
  • Collaborated with technical support, back-office and other cross-functional teams to investigate and
    resolve escalated issues, identifying and eliminating systemic problems, reducing churn, and driving
    long-term customer loyalty.
  • Coached and trained both new and current employees to facilitate professional growth.

Imperial Service Representative | Oct. 2016 – Oct. 2018

  • Analyzed individual client trends to provide personalized financial advice and services to high-net
    worth clients or those with complex banking needs.
  • Leveraged robust understanding of CIBC’s full range of financial products and services to share
    insights with high-net-worth clients and colleagues.
  • Researched and compiled data from multiple sources, using resulting analysis to offer needs-based
    solutions to clients.
  • Spearheaded bill payment investigations in line with Bank’s compliance procedures, opening cases
    and escalating to fraud management team as needed.
  • Managed credit product applications for customers, taking ownership of quality of data; conducted
    thorough quality control checks to ensure accuracy, efficiency, and compliance with business
    requirements.

Education

B.Eng. (Bachelor of Engineering, Manufacturing) - University of Ontario Institute of Technology
Training + Certifications

  • Certificate in Data Analytics for Business Decisions – McGill University

  • Certificate in Business Analysis (IIBA) – Topron Consulting Inc.

Theodora Sarpong

Data Analyst enthusiast. I’m excited to take whatever challenges you have to throw at me.

Contact

theodora.bsarpong@gmail.com
LinkedIn