Bright Kwame Dogbey

Designed and built a comprehensive data framework from scratch to utilize a more data led approach to digital marketing strategies across 22 countries in Africa.
Collaborated with a cross-functional team of digital strategists to develop an end-to-end data led media buying strategy for FMCG clients.
Utilized data and insights to segment customer targets for various FMCG brands to enable the creation of more refined target groups that align with each brand's preferred audience.
Streamlined reporting processes, reducing report generation time by 50% while enhancing data accuracy and accessibility utilizing tools like Microsoft Excel and PowerBI.
Developed and maintained multiple end-to-end dashboards and reports using Power BI to track and visualize key performance indicators (KPIs) of client’s major brands.
Led a team of analysts and digital strategists to develop a comprehensive end-to-end real time sentiment monitoring dashboard to inform and advice a client about real time outlook on their brand and develop strategies on how to elevate their brands reach and engagements.

Designed and built a comprehensive data framework from scratch to utilize a more data led approach to digital
marketing strategies across 22 countries in Africa.
● Collaborated with a cross-functional team of digital strategists to develop an end-to-end data led media buying
strategy for FMCG clients.
● Utilized data and insights to segment customer targets for various FMCG brands to enable the creation of more refined
target groups that align with each brand's preferred audience.
● Streamlined reporting processes, reducing report generation time by 50% while enhancing data accuracy and
accessibility utilizing tools like Microsoft Excel and PowerBI.
● Developed and maintained multiple end-to-end dashboards and reports using Power BI to track and visualize key
performance indicators (KPIs) of client’s major brands.
● Led a team of analysts and digital strategists to develop a comprehensive end-to-end real time sentiment monitoring
dashboard to inform and advice a client about real time outlook on their brand and develop strategies on how to elevate their brands reach and engagements.

Executed data cleaning on 3M+ records in an SQL database and built a fraud detection model to generate insights for a financial product using Python.
This cut monthly expenditure by 30%, resulting in $62,500+ savings monthly.
Owned data, definition, and reporting on 3 customer growth KPIs for product and marketing teams and automated reporting using Oracle Analytics and Tableau.
This saved up to 5 man hours weekly.
Established a growth forecasting model using Python (ARIMA) to support the FP&A team in predicting revenues and promoting accountability and transparency.
This contributed to 5% overall revenue growth in 1 month.
Slashed churn rate by ~10% by conducting data mining, modeling, and statistical analysis to assess customer journey on 30K+ users and deliver data-based recommendations to sales and marketing teams.
Led a comprehensive BI system audit to identify and correct reporting anomalies to regulatory authorities.
This saved the company more than $2M in fines and tax deficit payments.
Constructed 8 Tableau Dashboards with interactive views, trends, and drill-downs along with user-level security to promote transparency for leadership and 5 business teams.
Led a team of analysts and data governance specialists to document and review the processes and logic used to report on KPIs.
This promoted accountability and reduced project delegation and handing-over time by over 6 hours.

Developed 5+ Visualforce pages using Apex for proprietary Salesforce applications to track the flow of business.
This provided real-time data to streamline business decisions for senior management.
Optimized data processing and storage using AWS services such as S3, EC2, and Redshift.
This improved data processing time by ~20%.
Collaborated with 4 cross-functional teams to perform A/B testing on 2 cold-calling techniques to simplify marketing efforts.
This resulted in a more effective Lead Generation system that contributed to a 3.5% revenue growth.
Designed a scala and spark-based configurable framework to connect to MySQL and load in Big Query to reduce data loading time by ~10 seconds and also improve scalability.
Promoted transparency and accountability on 3 business KPIs among internal business teams and 2000+ clients by collaborating with the team to establish real-time reporting using SQL and PowerBI dashboards.
Advised mid-level management to adopt a data verification process to optimize data quality and demand generation efforts for clients.
This boosted sales by ~15% in the next quarter.
Managed Enterprise analysis - planning and scoping several inter-related initiatives and supporting senior-level business stakeholders to make informed decisions about which initiatives to tackle and how to go about it.

Studied and segmented 3000+ customers using SQL based on demographics, sales, and financial data and built a Python time-series model to predict customer purchasing behavior and streamline product recommendations.
Reengineered ETL process by leveraging MS SQL’s standard API to improve data latency and extract Salesforce and Facebook data in real time.
This optimized data analysis activities for the 5-member data team.
Migrated data to AWS using services such as AWS Snowball and AWS Database Migration Service (DMS) to enable easier access and analysis of data.
Trained 2 interns on SQL CTEs and the use of Python in performing data exploration, data cleaning, data visualization with Seaborn, and statistical methods such as the Pearson correlation method.
Independently and collaboratively created 14+ Power BI and Tableau dashboards to reveal insights and support weekly reporting on KPIs for management and marketing teams.

Tutored students on the course contents in the springboard Data Analytics Amazon B2B program curriculum.
Provided guidance and career support to students to navigate challenges and overcome obstacles.
Designed a career development roadmap to help students properly network and create secure top jobs before their graduation.

Worked with aspiring data analysts to train them, and develop goals, plans, and resources to achieve success in their journey to become data analysts and beyond.
Provided guidance and support to help mentees navigate challenges and overcome obstacles.
Built relationships with mentees to establish trust and understanding.
Collaborated with the foundation’s staff and community partners to connect mentees with resources and opportunities.
Facilitated workshops and events to support mentees’ personal and professional development.