Data Analyst Business

ERNEST FOSU

Phone Number: +*** – ** – ******* E-mail Address: **********@*****.***

Github: ERNESTFOSU LinkedIn: ernest-fosu

Date of Birth : 3rd April, 1988

Address : Ghana Post GPS GE- 181 - 8037 Kwabenya Accra -Ghana

CAREER OBJECTIVE

A customer centric, emotionally intelligent, lean six sigma trainee, and a deeply analytical data enthusiast from mathematics heavy educational background,with over five years in using data analysis, machine learning and statistical analysis to pitch ideas and seeking new challenges in a structured enterprise that operationalizes the collection and processing data for continues improvement and decision making

ACADEMIC QUALIFICATION

●MPhil Statistics. – University Of Ghana, Legon Accra 2018 – 2020

●BSc. (Hons) Biomedical Engineering – Kwame Nkrumah University of Science and Technology (KNUST), Kumasi – Ghana 2009 – 2013

SKILLS

●LEAN PRINCIPLES -DMAIC

●Knowledge in Advanced Statistics – Multivariate regression analysis, correlation, Analysis of Variance (ANOVA) etc, Advanced Data analysis,data mining, Data engineering -data extraction,cleaning and wrangling techniques to prepare data for modelling and derivation of insights .knowledge in supervised and unsupervised machine -learning algorithm

●Able to design experiment,test hypothesis of one or more variants with A/B testing

●SQL,Python,R, SPSS,ETL tools -Spark,Airflow .visualization tools –Tableau,PowerBI, Matplotlib

●Advanced Excel, Perform VLOOKUP,PIVOT AND UNPIVOT TABLES

●Able to perform data modelling,creating KPIs with PowerQuery

●Foundational Knowledge in GIS,the use of ArqGIS to process ruster and vector data

●Cloud services –AWS S3, Redshift,Heroku

WORK EXPERIENCE

Business Analyst : World Vision-Shared Service Ghana JULY 2021 – PRESENT

Works with World Vision shared service to provide business analytics solutions to finance,procurement, human resources and operations department of World Vision field offices around the World .

Working with various stakeholders and customer to understand value stream to identify bottleneck,and areas for continuous improvement

creating dashboards and operational metrics with powerBI

Performing data modelling, database architectural design, designing schemas and normalization of databases to enhance ingestion and retrieval of data

Adopting an agile principles with scrum methodologies to come up with data product and methodologies that ensures operational excellence

Actively supporting cross functional teams in the development of KPIs and metrices

Designed and built databases for transactional and analytical purposes

Write complex queries to extract data,used PowerBI’s DAX to perform quick measures and quick table calculations

Granting SharePoint access request and creating of forms

Providing accurate documentation and training to stakeholders and users of data analytics product

Building and maintaining of dashboard with KPIs such as SLA,NPS,CSAT etc

Data Analyst : Roche Ghana JULY 2019 -APRIL 2020

● Built machine learning models and predictive forecast for Roche clients around the world

●Used patient’s data such as genome analysis,temperature and other vital signs to build Personalized healthcare for patients

●Queried data,run an etl pipeline and built highly interactive reports with documentation in Tableau to answer supply chain questions

●Conducted regular or adhoc statistical analysis,such as hypothesis testing,statistical power,confidence interval with R

Data Analyst: PEG Ghana. MAY, 2018– JUNE,2019.

●Provided analytical support for cross-functional strategic projects spanning Credit, Commercial, Customer Experience, Operations and Finance.

●Worked with data engineers and ETL specialist to build and maintain an ETL pipeline using Apache Airflow to move data from transactional database to Redshift and preparing the data to be consumed by analytical and visualization tools

●Built exceptional analytics and reporting on regular or adhoc basis with marketing teams that strategies and helps answers questions relating to marketing KPIs, reducing churn by identifying churn drivers, predicting churn with logistic regression,customer retention and conversion, customer segmentation and designing product for separate segments,testing and validating hypothesis with A/B testing etc,

●Filtered,segmented,grouped,created business metrices (KPIs),performed trend analysis from company’s enterprise Datawarehouse – Amazon Redshift with extracted and live data to answer questions for various departments of the company

●Carried out a between-subjects A/B experiment that failed to reject the hypothesis that customers of one of two payment plans were more likely to default on their payment .The above conclusion helped the sales and marketing department to re-examine their marketing strategy reducing initial default rate by 80% while maintaining and even expanding market size

●Worked with Financial team in using SQL to generate monthly receivables –based on expected amount and actual recovered amount by reconciling Mobile Money Source data with what is on the CRM system

●Desiged, built and maintained real-time operational and strategic reports and dashboards in Tableau to disseminate data across all levels of the organization.

●Worked with data engineers to build and maintain databases for both transactional and analytical purposes

●Participated in cross-functional process improvements for Mastering Data across all data domains. Assist in identifying and resolving gaps in data quality and governance with emphasis on root-cause analysis, people, and process.

●Communicated with stakeholders and ensure effective time management across multiple deliverables

Data and Clinical Engineering Manager: National Center for Radiotherapy & Nuclear Medicine, Korle Bu Teaching Hospital NOVEMBER 2015 – JULY 2018

liaised with the IT unit in writing SQL queries to pull data from an in -house data management system running on Microsoft SQL server for analysis

Looked at inventory and supply data,built data dashboard that told stories for a business cases which improved demand planning accuracy for the Pharmacy,stores and procurement unit .This was largely successful with PowerBI-Using powerQuery to clean data and generate quick measures,quick table calculations

Overseeing the day-to-day administration of the department’s engineering program through operational and technical supervision of technicians for equipment integrity .

Drafted and prepared Quarterly reports on equipments

Data Analyst : Ghana Health Service – National Service SEPTEMBER 2013– JULY 2014

Recorded data,analyzed test results and kept meticulous report with excel

Liased with Kumasi Centre for Collaborative Research(KCCR) to suggest actionable solutions in cultivate high quality healthcare in the MALARIA program based on analyzed data from clinical trials .

Drafting and preparing reports, creating data dashboards and telling stories with data

PERSONAL QUALITIES

●Good communication and presentation skills

●Organizational skills and heavily result-oriented

●Great peoples’ skills and a customer centric person

●Quick to understand and a fast learner,capable of learning anything should the need arise

●Has the ability to work independently or be part of a team.

●High level of professional and personal integrity

●Discipline and yet flexible

●A life long learner constantly learning to improve in both professional and personal

●Team player and great leadership skills

CERTIFICATIONS

●SIX SIGMA FOUNDATIONS

●DATA STRATEGY

●CULTURE OF KAIZEN

●LEARNING DATA GOVERNANCE

●QUALITY MANAGEMENT FOR OPERATIONAL EXCELLENCE

●OPERATIONAL EXCELLENCE FOUNDATION

●INFORMATION SECURITY AND DATA PROTECTION

●PROJECT MANAGEMENT FOUNDATION

●AGILE FOUNDATION

●AGILE REQUIREMENT

●FUNDAMENTAL COURSE IN AWS

●DATA SCIENCE NANODEGREE (ONGOING) – UDACITY

●LEARNING HOW TO LEARN-COURSERA

●CREATING YOUR PERSONAL BRAND

●PROBLEM SOLVING TECHNIQUES

●SQL FOR DATA SCIENCE –COURSERA

●DATA ANALYSIS WITH TABLEAU

●MACHINE -LEARNING -COURSERA

●CRITICAL THINKING

Contact this candidate