Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

PHILIP ODURO BOSOMPEM

ACCRA

Summary

A dynamic Data Analyst at MPHARMA PHARMACEUTICALS COMPANY LIMITED with expertise in SQL (Postgres, MySQL), Metabase, Excel, Tableau, Power BI, SPSS, and Python (Pandas). Proficient in uncovering actionable insights from data, I drive strategic decisions and foster growth.

My leadership, problem-solving, and communication skills enable effective collaboration across teams. Additionally, I adeptly handle data engineering tasks, ensuring data accuracy and efficiency using tools like Airbyte for ETL processes.

I'm committed to continuous learning and empowering teams through Metabase training, fostering a culture of data-driven decision-making. Proven track record in spearheading initiatives that resulted in substantial membership and revenue growth.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst

MPHARMA PHARMACEUTICALS COMPANY LIMITED
Accra
10.2021 - Current
  • At MPHARMA COMPANY LIMITED, I am not just a Data Analyst, but a catalyst for transformative insights, turning raw data into strategic gold that fuels our business growth and success. Here's a glimpse into how I've contributed.
  • Driving Strategic Growth: Designed and built inventory management dashboards in collaboration with the product manager to support mPharma’s transition from SAP to an in-house ERP, resulting in $250,000 in savings annually.
  • Impact Analysis for the 'Mutti Keep My Price' Initiative: Designed and executed an impact analysis, demonstrating a 50% growth in membership and a significant revenue increase. Highlighted the initiative's success through detailed data evaluation.
  • Active Mutti Membership Boost: Drove a 60% increase in active membership and contributed to successful fundraising by performing segmentation analysis on the user base using SQL and sharing growth recommendations with leadership.
  • Leadership in Analytics: Facilitated alignment between data platforms (Metabase, Power BI) and stakeholders by translating complex insights into actionable strategies. Led company-wide Metabase training, democratizing data access, and significantly boosting departmental productivity.
  • Data Engineering Expertise: Engaged in creating Materialized Views (MVs), performing table updates, and maintaining data infrastructure to ensure accuracy and accessibility. Utilized Airbyte for ETL processes, enhancing the robustness and reliability of data pipelines.

This comprehensive view showcases my multifaceted role in steering data-driven initiatives, demonstrating expertise not only in strategic analysis but also in data engineering, fostering growth, and acting as a crucial link between data insights and the company's overarching success.

Education

Bachelor of Science - Resource Enterprise and Entrepreneurship

University of Energy And Natural Resources
Sunyani, GHANA
10.2021

Skills

Technical Skills:

  • SQL: Proficient in writing complex queries and manipulating databases efficiently
  • Metabase: Skilled in utilizing Metabase for data visualization and analysis
  • Excel: Advanced proficiency in Excel, including data analysis, pivot tables, and macros
  • Tableau and Power BI: Experience in creating interactive and insightful visualizations for data-driven presentations
  • Python (Pandas): Knowledgeable in using Pandas for data manipulation and performing basic statistical analysis

Soft Skills:

  • Leadership: Demonstrated leadership qualities, as seen in my role as a de facto Head of Analytics, driving initiatives and fostering collaboration
  • Results-Oriented: Proven ability to deliver tangible results, such as the significant growth in Mutti membership and revenue, showcasing a goal-driven approach
  • Problem Solving: Adept at identifying issues, analyzing root causes, and implementing effective solutions, as seen in query rewriting to validate and ensure the success of initiatives
  • Communication: Strong communication skills, both verbal and written, enabling effective collaboration with cross-functional teams and translating complex data insights into actionable strategies

Certification

  • MySQL for data analytics and Business intelligence [UDEMY], 2022
  • Data Analyst virtual internship [Microsoft Power BI], PWC, 2022
  • Certified SQL Developer, Programming Hub, 2022
  • Introduction to SQL, Datacamp, 2022
  • Microsoft Power BI Bootcamp [FestMan learning Hub], 2022
  • Certified Business Intelligence with Microsoft Excel, AQSKILLS, 2021

Timeline

Data Analyst

MPHARMA PHARMACEUTICALS COMPANY LIMITED
10.2021 - Current

Bachelor of Science - Resource Enterprise and Entrepreneurship

University of Energy And Natural Resources
PHILIP ODURO BOSOMPEM