Summary
Overview
Work History
Education
Skills
PROJECTS
Timeline
Generic

Francis Esoroibeba

Toronto,Canada

Summary

Highly skilled Data Analyst with 5 years of experience specializing in data-driven decision-making and business intelligence. Adept at designing, developing, and maintaining interactive dashboards and reporting systems, leading to significant improvements in operational efficiency and decision-making processes. Proficient in SQL, Python, and BI tools like Tableau and Power BI, with extensive experience in cloud-native infrastructure and data warehousing. Seeking to contribute to a reputable organization's growth through innovative data solutions and impactful reporting

Overview

8
8
years of professional experience

Work History

OPERATIONS ANALYST

CARGOJET INC.
12.2022 - Current
  • Implemented an Excel macros-based ETL system for the flight schedule management portal, resulting in a daily time-saving of 2 hours through reduced manual processing.
  • Collaborated with internal teams to address data quality issues in a complex environment, achieving a net 0 delay in cargo delivery for the year.
  • Provided technical assistance in troubleshooting issues related to operational systems.
  • Developed training materials for staff members on operational procedures to ensure project continuity and knowledge sharing.
  • Created detailed documentation outlining procedures for all operations-related activities.

DATA ANALYST

EDO STATE GOVERNMENT
12.2018 - 05.2022
  • Designed, developed and maintained over 10 dashboards for real-time monitoring of ongoing projects' key business metrics, resulting in a 60% reduction in report generation time.
  • Increased engagement rate by 60% through trend and pattern analysis of historical data for Digital Marketing using Python, Excel PowerPivot, and DAX.
  • Streamlined and automated the ministry's document approval process, resulting in a more than 35% reduction in processing time.
  • Led ad-hoc investigations and presented opportunities and bottlenecks to senior management, contributing to a 10% growth in revenue.

DATA ANALYST

VIISAUS TECHNOLOGY LIMITED
04.2016 - 10.2018
  • Developed and maintained business reporting systems using Python, SQL, and Tableau to automate the revenue collection process for the Edo State Government, leading to a pilot revenue increase of over 500%.
  • Collaborated with cross-functional teams, successfully implementing an initiative to register 200,000 unemployed citizens.
  • Maintained documentation on analyses and reporting pipelines, improving knowledge sharing and project continuity.
  • Collected and analyzed data from 2500 Libya Returnees for the Managing Migration through Development Programme (MMDP), leading to a funding and rehabilitation partnership with the International Organization for Migration (IOM).

Education

Post-Graduate Diploma - Analytics for Business Decision Making

Mohawk College
Ontario, Canada

Bachelor of Science - COMPUTER SCIENCE

University of Benin

Skills

  • Data Analysis & Visualization: Tableau, PowerBI, Excel
  • Programming & Scripting: Python, SQL, R
  • Data Management: ETL, Data Warehousing, Relational Databases
  • Dashboard Development: Creating interactive, user-friendly dashboards
  • Cloud Infrastructure: AWS
  • Experiment Design: A/B testing
  • Documentation: writing and maintaining analysis/ reporting documentation
  • Stakeholder Collaboration: Translating business needs into data solutions
  • Complex Problem Solving: wrangling data to answer real world questions
  • Communication: Effective with technical and non-technical stakeholders

PROJECTS

Global Deforestation Trend

  • To address global deforestation and its environmental impact, I conducted an exploratory data analysis using World Bank data, uncovering trends in forest area, total land area, and regional dynamics since 1990.

ATS Services in Hamilton, Canada

  • My second-place project submission for the 2023 HEAD (Higher Education Analytics Data) Competition for Data Analysts explores changes in ATS bus services due to the COVID-19 pandemic, analyzing ridership patterns from the Pre-Covid Era (2019) to the Post-Covid Era (2022) to provide actionable insights for service optimization.

US Census Demographic Distribution

  • In this extensive data analysis project, I investigated key metrics like unemployment, income, and transportation in the United States, revealing correlations, distributions, and rankings to provide strategic insights for policymakers, businesses, and communities.

Timeline

OPERATIONS ANALYST

CARGOJET INC.
12.2022 - Current

DATA ANALYST

EDO STATE GOVERNMENT
12.2018 - 05.2022

DATA ANALYST

VIISAUS TECHNOLOGY LIMITED
04.2016 - 10.2018

Post-Graduate Diploma - Analytics for Business Decision Making

Mohawk College

Bachelor of Science - COMPUTER SCIENCE

University of Benin

Similar Profiles

CREATE PROFILE
Francis Esoroibeba