Data Analysis

Josephine Adzo Ekpe

#**********@*****.*** ïjosephineadzoekpe H+1-814-***-****

Summary

Results-driven Finance and Business Analytics professional with a background in financial modeling, data analysis, and business management. Over five years of experience in financial services, risk management, and business oper- ations, with expertise in data visualization, financial modeling, and strategic decision-making. Adept at analyzing large datasets, optimizing financial performance, and supporting executive leadership with data-driven insights. Recent Projects

Student Success Analysis: A Predictive Analytics Capstone Project Franklin University, Ohio Oct 2024 – Dec 2024

• Developed predictive models (Logistic Regression, Random Forest, XGBoost) to analyze factors influencing success, translating findings into actionable strategies. Marketing Analytics Project

Franklin University, Ohio Feb 2024 – Mar 2024

• Analyzed revenue fluctuations in Google Merchandise Store using Google Analytics 4, identified root causes through data exploration and trend analysis, and presented findings with recommendations for improving revenue, utilizing visualizations to support insights and demonstrate data storytelling skills. Tableau Dashboard Projects

Franklin University, Ohio Sep 2023 – Dec 2023

• Designed interactive Tableau dashboards to visualize sales and profitability trends using Walmart Retail Store data, showcasing data visualization and analytical skills.

• Created a safety performance dashboard with airline data, highlighting improvements in safety measures through intuitive visualizations.

Professional Experience

Dickmafle Microfinance Ghana

Financial Analyst Jan 2018 – Dec 2022

• Assisted in evaluating loan applications by conducting creditworthiness assessments, analyzing financial state- ments, and reviewing borrower profiles to support risk-based decision-making.

• Collaborate cross-functionally to enhance data quality, reporting accuracy, and financial planning processes.

• Assisted in budget preparation, financial reporting, and expense management initiatives.

• Perform variance analysis on loan performance metrics to identify discrepancies and areas for improvement in credit policies.

• Created presentations and reports for stakeholders, incorporating key financial insights.

• Developed reports and dashboards using Excel and Tableau to monitor key financial and operational metrics. Subah Infosolutions Ghana Ltd Ghana

Executive/Project Assistant May 2013 – Dec 2017

• Led cross-functional project management initiatives for Sim Box Fraud Detection, Rural Telephony, Revenue Assurance, and Document Digitization, ensuring seamless stakeholder collaboration and alignment with exec- utive priorities.

• Managed vendor contracts, procurement processes, and financial reporting, ensuring compliance with corporate governance.

• Conducted data analysis on vendor performance, identifying opportunities for cost savings and operational improvements.

• Led projects to analyze financial data using SQL, and developed scorecard/reports on financial viability and performance of projects, and presenting same to MD and Board of Directors, resulting in enhanced business decision making, leading to 25% increase in bottom line.

• Utilized an Enterprise Resource Planning software to perform other finance duties such as creation of ledgers, accounts payable and receivable, budgeting, and payroll management. Ghana Commercial Bank (GCB) Ltd Ghana

Branch Operations Support Officer Jun 2007 – Aug 2007

• Opened new customer accounts and ensured all accounts opened were KYC compliant to ensure incidence of fraud and Money Laundering were reduced or prevented.

• Maintained vendor data accuracy in the Database Management System and created dashboards for reporting.

• Supported data analysis and reporting, using and Excel to generate insights on vendor spend and efficiency.

• Accurately captured data into an electronic system (GCNet) for processing trade and customs documents.

• Processed invoices and purchase orders, reducing errors and improving transaction accuracy. Technical Skills

• Data Analysis & Visualization: SQL, MS Access, Excel, Tableau, Power BI, R, Python.

• Statistical Analysis/Modeling & Machine Learning: Financial Modeling, Time Series & Trend Analysis, Simple & Multiple Linear Regression (Logistic models), Classification and Regression Trees (Decision Trees, Random Forests & XGBoost), Quantitative Text Analysis (Text Mining).

• Finance and Accounting: Financial Analysis & Reporting, Sensitivity and Scenario Analysis, Forecasting.

• Presentation : PowerPoint (Data Storytelling, Financial Decks)

• Communication and Soft Skills: Verbal and written communication, teamwork, problem-solving. Education

M.Sc. Business Analytics (STEM)

Franklin University, Columbus Feb 2023 - Dec 2024 (GPA: 3.9/4) M.Sc. Financial Services Risk and Operations

Glasgow Caledonian University, UK Aug 2010 - Sept 2012 Bachelor of Commerce

University of Cape Coast, Ghana Aug 2005 - May 2009 Certifications

SQL for Data Science by UC-DAVIS through Coursera May 2024 Marketing Analytics - Franklin University Apr 2024 Google Analytics Individual Qualification (GAIQ) Mar 2024 Data Visualization with Tableau - Franklin University Dec 2023

Contact this candidate