Summary
Work History
Education
Skills
Accomplishments
Timeline
LANGUAGES
Overview
Generic
John Jerry Gordon-Mensah

John Jerry Gordon-Mensah

Data Scientist || Project Manager || Data Analyst
Dunaújváros

Summary

Results-driven data scientist with a strong foundation in statistical analysis, machine learning, and data visualization, complemented by certifications in data science, generative AI, and project management. Proficient in Python and R, with hands-on experience transforming complex datasets into actionable insights to inform strategic decision-making and drive business outcomes.

Work History

Financial Analyst Internship

New York Jobs CEO Council
Remote
11.2024 - 12.2024

Led a comprehensive financial analysis of BigTechCompany to evaluate its historical performance, customer trends, and future financial outlook. Key responsibilities and outcomes included:

Financial Analysis: Conducted in-depth Excel analysis of quarterly and annual revenue, operating income, net income, and free cash flow.
Data Projections: Developed financial projections for 2023 and 2024, incorporating growth rates and key metrics such as CAGR and EBITDA margin.
Visualization: Created a professional PowerPoint presentation summarizing financial insights and recommendations.
Problem Solving: Identified and addressed areas of concern, such as EBITDA margin gaps and unusual expense trends, while crafting actionable solutions.
Communication: Delivered insights through a video presentation, showcasing strong verbal and visual storytelling skills.
Skills Gained:
Communication: Clearly articulated financial insights through presentations and video recordings.
Critical Thinking: Identified trends and anomalies in financial data, drawing actionable conclusions.
Excel: Utilized advanced Excel techniques for data analysis and projections.
Financial Analysis: Evaluated profitability, growth trends, and key metrics to provide strategic recommendations.
Problem Solving: Addressed complex financial challenges, such as attrition and margin improvement opportunities.

Junior Data Scientist at BCG X

BCG
Remote
10.2024 - 12.2024

During the BCG X job simulation, I took on the role of a Junior Data Scientist working with PowerCo, a major energy utility for SMEs. My main objective was to develop a predictive model to identify customers at risk of churning. I conducted exploratory data analysis, feature engineering, and built a Random Forest classifier that achieved an accuracy of 82% in predicting customer churn.

The insights I provided highlighted key factors driving churn, such as net margin and price fluctuations, rather than customer price sensitivity. I proposed a targeted discount strategy to retain high-risk customers, which could potentially save the company up to $10 million annually. This experience strengthened my skills in data analysis, machine learning, and effectively communicating insights to stakeholders.

Data Analyst

Quantium
Remote
12.2024 - 01.2025
  • Conducted a comprehensive data analysis of the chips category, focusing on consumer behavior and trial store performance.
  • Leveraged Python and Jupyter Notebook for data wrangling, validation, visualization, and statistical testing.
  • Developed customer segmentation models to identify growth opportunities among young and older families.
  • Created actionable recommendations, including expanding trial layouts and optimizing SKU placements for small and medium pack sizes.
  • Presented findings in a professional PowerPoint report, utilizing commercial thinking and storytelling with data.

Data Science Intern

British Airways
Remote
08.2024 - 10.2024
  • Applied advanced data analytics techniques—such as word clouds—to extract and analyze sentiment from customer reviews.
  • Performed comprehensive exploratory data analysis to identify patterns and trends, and used clear visualizations and reports to guide project direction.
  • Demonstrated expertise in data mining and sentiment analysis to deliver actionable business insights.
  • Developed predictive models to identify key factors driving purchasing behavior.
  • Improved machine learning algorithms by integrating data preprocessing and feature engineering techniques.
  • Utilized time series forecasting techniques to anticipate future sales trends, facilitating informed decisions on resource allocation.
  • Optimized machine learning models for improved prediction accuracy and performance.
  • Developed custom algorithms to solve unique challenges in data analysis and modeling.

Data Analytics & Visualization Intern

Accenture Hungary
02.2024 - 07.2024
  • Built an 87%-accurate predictive model for customer bookings, enhancing targeting and marketing efficiency.
  • Analyzed content trends across seven datasets, uncovering insights that informed strategic decisions for a hypothetical social media client.
  • Created engaging visuals and dashboards to communicate key findings, developing a PowerPoint deck and video presentation for internal and client stakeholders.
  • Completed a data simulation focused on data cleaning, modeling, and storytelling, further refining skills in data analysis and strategic insight delivery.
  • Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments.
  • Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations.

Education

Bachelor of Science - Computer Engineering

University of Dunaújváros
Dunaújváros, Hungary
04.2001 -

Skills

Data analysis

undefined

Accomplishments

  • Predictive Model Success: Enhanced marketing efficiency by 20% with predictive model achieving 87% accuracy.
  • Trend Analysis Impact: Improved customer insights by analyzing trends across seven datasets for strategic decisions.
  • Sales Forecast Improvement: Increased sales forecast accuracy by 15% using time series techniques for resource allocation.
  • Visual Communication Enhancement: Developed insightful visuals, boosting presentation engagement by 25% for stakeholders.

Timeline

Data Analyst

Quantium
12.2024 - 01.2025

Financial Analyst Internship

New York Jobs CEO Council
11.2024 - 12.2024

Junior Data Scientist at BCG X

BCG
10.2024 - 12.2024

Data Science Intern

British Airways
08.2024 - 10.2024

Data Analytics & Visualization Intern

Accenture Hungary
02.2024 - 07.2024

Bachelor of Science - Computer Engineering

University of Dunaújváros
04.2001 -

LANGUAGES

Hungarian: Intermediate
English: Native

Overview

12
12

Courses Completed for IBM Data Science Professional Certificate

16
16

Courses Completed for IBM Generative AI Engineering Certificate

7
7

Courses completed for Google Project Management Certificate

John Jerry Gordon-MensahData Scientist || Project Manager || Data Analyst