Bright Kwame Dogbey

<p>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.<br>
Collaborated with a cross-functional team of digital strategists to develop an end-to-end data led media buying strategy for FMCG clients.<br>
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.<br>
Streamlined reporting processes, reducing report generation time by 50% while enhancing data accuracy and accessibility utilizing tools like Microsoft Excel and PowerBI.<br>
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.<br>
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.</p>

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.

<p>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.<br>
This cut monthly expenditure by 30%, resulting in $62,500+ savings monthly.<br>
Owned data, definition, and reporting on 3 customer growth KPIs for product and marketing teams and automated reporting using Oracle Analytics and Tableau.<br>
This saved up to 5 man hours weekly.<br>
Established a growth forecasting model using Python (ARIMA) to support the FP&A team in predicting revenues and promoting accountability and transparency.<br>
This contributed to 5% overall revenue growth in 1 month.<br>
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.<br>
Led a comprehensive BI system audit to identify and correct reporting anomalies to regulatory authorities.<br>
This saved the company more than $2M in fines and tax deficit payments.<br>
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.<br>
Led a team of analysts and data governance specialists to document and review the processes and logic used to report on KPIs.<br>
This promoted accountability and reduced project delegation and handing-over time by over 6 hours.</p>

<p>Developed 5+ Visualforce pages using Apex for proprietary Salesforce applications to track the flow of business.<br>
This provided real-time data to streamline business decisions for senior management.<br>
Optimized data processing and storage using AWS services such as S3, EC2, and Redshift.<br>
This improved data processing time by ~20%.<br>
Collaborated with 4 cross-functional teams to perform A/B testing on 2 cold-calling techniques to simplify marketing efforts.<br>
This resulted in a more effective Lead Generation system that contributed to a 3.5% revenue growth.<br>
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.<br>
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.<br>
Advised mid-level management to adopt a data verification process to optimize data quality and demand generation efforts for clients.<br>
This boosted sales by ~15% in the next quarter.<br>
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.</p>

<p>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.<br>
Reengineered ETL process by leveraging MS SQL’s standard API to improve data latency and extract Salesforce and Facebook data in real time.<br>
This optimized data analysis activities for the 5-member data team.<br>
Migrated data to AWS using services such as AWS Snowball and AWS Database Migration Service (DMS) to enable easier access and analysis of data.<br>
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.<br>
Independently and collaboratively created 14+ Power BI and Tableau dashboards to reveal insights and support weekly reporting on KPIs for management and marketing teams.</p>

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

<p>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.<br>
Provided guidance and support to help mentees navigate challenges and overcome obstacles.<br>
Built relationships with mentees to establish trust and understanding.<br>
Collaborated with the foundation’s staff and community partners to connect mentees with resources and opportunities.<br>
Facilitated workshops and events to support mentees’ personal and professional development.</p>