Summary
Overview
Work History
Education
Skills
Timeline
Hi, I’m

TUMASI AGYAPONG

Chicago,IL
TUMASI AGYAPONG

Summary

With a foundation in Business Analytics and Risk Management, and a track record of leading successful data-driven projects at ALDI, expertise lies in leveraging SQL, Python, and Tableau to drive strategic business decisions and operational efficiency. Proficient in synthesizing complex data sets, adept at applying machine learning techniques to identify trends and influence high-level decision-making. Demonstrated capability in project management and delivering actionable insights to non-technical stakeholders, resulting in significant cost savings and advanced goal achievement.

Overview

6
years of professional experience

Work History

ALDI

Data Analyst, Assortment Planning
06.2023 - Current

Job overview

  • Leading Assortment Planning project (with Agile Methodology), improving 13 inefficiently operating product categories, generating $6M in savings in 2023 and projecting approximately $8M in 2024
  • Executing SQL queries within internal and Hadoop databases, leveraging Circana data, engineering KPIs such as inventory turnover and customer acquisition costs in Python, visualizing results inTableau, resulting in permanent 50% reduction in time-to-market for key product categories, from 30 to 15 days
  • Utilizing data science and machine learning methods like regression, decision trees, SVMs, and time series forecasting to inform critical business strategies, contributing to record 15% increase in product category sales performance for key product categories
  • Facilitating 25% faster cross-departmental performance communication by translating financial data into accessible dashboards for non-technical stakeholders in planning, finance, and operations

Endominance

Data Analyst and Research Coordinator
07.2022 - 06.2023

Job overview

  • Implemented new survey database and managed over 7000 data points for Biotech AI startup, advancing midyear goal by 30% within 1 month
  • Executed comparative analysis and predictive modeling through R and Python and presenting data with R Markdown reports and Tableau visualizations yielding high quality insights for slide decks used by CEO for fundraising pitches, generating over $200K in additional funding within 1 year
  • Revamped fraud protocols, quality checking and reporting major flags to CEO resulting in protocol change and $10K+ reduction in cost.

AlphaSights

Survey Data Project Lead
05.2020 - 07.2022

Job overview

  • Led 3 survey specialists in project execution, survey interviews and analysis for top tier strategy consulting clients resulting in onboarding of single highest usage client of 2021, with over $700K in revenue generated within 2 months
  • Leveraged Python and SQL to perform sophisticated data analysis on large datasets, identifying key trends and actionable insights, and created visualizations in Tableau that drove strategic decisions in high-stakes consultant presentations.

Johns Hopkins Medicine, Department of Surgery

Research Assistant
06.2019 - 06.2020

Job overview

  • Analyzed data of 1000+ kidney donors in R for C-Level stakeholders at Hopkins Kidney Transplant Center.

Johns Hopkins Medicine, Adherence Research Center

User Experience Research Assistant
09.2018 - 05.2019

Job overview

  • Developed predictive model to identified key variables in drug adherence for $1.5M start-up health app.

Education

Johns Hopkins Carey Business School
Washington, DC

Master of Science from Business Analytics and Risk Management
08.2023

Johns Hopkins University
Baltimore, MD

Bachelor of Arts from Psychological and Brain Science with Honors
05.2020

Skills

  • Statistical Analysis (R, Python)
  • Data Visualization (Tableau)
  • Database Management (SQL, SSMS)
  • Big Data (Hadoop)
  • Version Control (Git)
  • Business Intelligence (Circana)
  • Spreadsheets (Excel, Access, VBA, Sheets)
  • ERP Software (SAP)
  • KPI Development
  • Agile Methodology
  • Project Management
  • C-Suite Presentation

Timeline

Data Analyst, Assortment Planning

ALDI
06.2023 - Current

Data Analyst and Research Coordinator

Endominance
07.2022 - 06.2023

Survey Data Project Lead

AlphaSights
05.2020 - 07.2022

Research Assistant

Johns Hopkins Medicine, Department of Surgery
06.2019 - 06.2020

User Experience Research Assistant

Johns Hopkins Medicine, Adherence Research Center
09.2018 - 05.2019

Johns Hopkins Carey Business School

Master of Science from Business Analytics and Risk Management

Johns Hopkins University

Bachelor of Arts from Psychological and Brain Science with Honors

Similar Profiles

CREATE PROFILE
TUMASI AGYAPONG