Summary
Overview
Work history
Education
Skills
Languages
Projects
Timeline
Hi, I’m

Balqees Olaitan Shodiya

Birmingham,West Midlands
Balqees Olaitan Shodiya

Summary

A driven and meticulous professional with a strong commitment to utilising data-driven strategies for enhancing business efficacy and elevating the customer experience. Proficient in harnessing data to formulate practical resolutions for complex business dilemmas, proficient in data mining, and adept at crafting meaningful insights through data visualisation. Possesses a profound technical acumen, complemented by expertise in programming languages, data analytics, and advanced data visualisation techniques.

Overview

6
years of professional experience
5
years of post-secondary education

Work history

Fintech Girl
Lagos, Nigeria

Data Analyst Intern
01.2022 - 06.2022

Job overview

  • Built an Agency dashboard tracker for a Fintech Start-up Client to facilitate collections.
  • Developed a custom-based agency payment and collection model to improving agents' collections
  • Data extraction, wrangling, sorting, cleaning, visualizations, and presentations of insights to management.
  • Researched data integrity issues and identified root causes of inconsistencies and required cleanup.
  • Enhanced strategic decision making by generating and analysing sales and customer behaviour models.
  • Employed advanced knowledge of Excel, from SUMIF to INDEX MATCH and Power Query formulas.
  • Created detailed documentation outlining design and technical specifications of each solution.
  • Prepared Business Intelligence reports tracking sales and customer insights for management team.

Guaranty Trust Holding Company, Plc.
Lagos, Nigeria

Financial and Banking Analyst
01.2018 - 01.2023

Job overview

  • Preparation of financial accounts, analysis of the financial statement lines and financial modelling.
  • Worked with business teams to identify issues affecting financial results and profitability.
  • Delivered financial oversight and advice to corporate stakeholders, improving strategic planning.
  • Issued financial information and margin data to support revenue recognition.
  • Conducted comprehensive research on corporations, industrial developments and government reports to inform financial assessments.
  • Developed forecasting tools to analyse revenue variance, business pipeline and industry trends.
  • Evaluated financial data from multiple sources to produce accurate revenue/expense forecasts.
  • Detailed financial data in spreadsheets to identify trends and create revenue, profitability and expense forecasts.
  • Maintained complete and accurate financial records following optimal accounting principles.
  • Built and updated financial models to support ongoing budgeting and forecasting processes, analyse complex information and process real-time data.

KPMG AU (FORAGE)
United Kingdom

Data Analyst Intern (Virtual)
05.2023 - Current

Job overview

  • Analysed large datasets, drawing meaningful conclusions and providing actionable recommendations.
  • Improved data integrity with rigorous auditing and cleansing.
  • Generated reports from extracted data for analyses.
  • Researched data integrity issues and identified root causes of inconsistencies and required cleanup.
  • Identified trends and generated insights by conducting routine analyses of various data systems.
  • Employed advanced knowledge of Excel, from SUMIF to INDEX MATCH and Power Query formulas.
  • Created detailed documentation outlining design and technical specifications of each solution.
  • Prepared Business Intelligence reports tracking sales and customer insights for management team.

Education

Ulster University
Birmingham, United Kingdom

Master of Science from International Business with Data Analytics
01.2023

Olabisi Onabanjo University

Bachelor of Science from Biochemistry
09.2011 - 03.2016

University overview

  • Distinction - 4.80/5.00 CGPA
  • Awarded best graduating student (2014/2015 session).
  • Valedictorian of 2014/2015 session
  • Awarded Overall Best Graduating Student.
  • Dean's and Chancellor's award [2014/2015 session].

Skills

  • RELEVANT SKILLS & CERTIFICATE:
  • Association of Chartered Certified Accountants (Membership in-view), ACCA
  • Financial Modelling in Excel
  • Advanced Excel
  • Technical writing
  • Business process mapping
  • Business analysis
  • Advanced critical thinking
  • Data collection and analysis
  • Project documentation
  • Data mapping
  • Power point Presentation & MS Word
  • Power BI
  • SQL querying
  • Python
  • Data visualisation
  • JIRA
  • Data-driven decision making

Languages

English
Advanced

Projects

Automated Loan Approval Dashboard

Academic Project : Data Analytics Course

Duration : May 2023 - August 2023

Description :  Performed an extensive analysis using a dataset from a home loan company to ascertain the loan approval rate concerning the total number of loan applications submitted. To accomplish this task, I employed two essential tools: a real-time dashboard for continuous updates on the application system's status and Power Query to effectively merge and cleanse the provided data. The combination of a real-time dashboard and Power Query facilitated a comprehensive and data-driven analysis of loan approval rates, ultimately aiding in optimizing the company's lending processes.


The project aims to revamp loan approval using business analytics and BI tools. It emphasizes KPIs, resolves bottlenecks via credit and income analysis, and encompasses data processes, predictive modeling, and comprehensive reporting.

Timeline

Data Analyst Intern (Virtual)

KPMG AU (FORAGE)
05.2023 - Current

Ulster University

Master of Science from International Business with Data Analytics
01.2023

Data Analyst Intern

Fintech Girl
01.2022 - 06.2022

Financial and Banking Analyst

Guaranty Trust Holding Company, Plc.
01.2018 - 01.2023

Olabisi Onabanjo University

Bachelor of Science from Biochemistry
09.2011 - 03.2016

Similar Profiles

Create profile
Balqees Olaitan Shodiya