Position: Junior Data Engineer
Category: Data Engineer
English level: fluent
Years of experience: 3

1. Built data ingestion from Postgres DB in Cloud SQL into BigQuery using Federated Queries, Cloud Composer 2 (Airflow) and Python.

2. Recovered financial debt amounting to #40 Million naira at BuyPower Inc using analytics skill of SQL. Furthermore, I collaborate with software engineers to fix the issues that led to debt, thus ensuring Data compliances and boosting trust with our clients and stakeholders.

3. Ensured clean energy sustainability at low cost for Smarterise clients that resulted in more than 30% reductions in annual operational cost by culling insights from their energy data.


MSc Financial Engineering at WorldQuant University Feb 2022 (95/100)
UPWORK
Role: Data Engineer Freelancer
1. Working as an external Data Analytics Expert contractor to help multinational clients get data-driven insights using various tools such as python, Metabase, DBT, Google Data Studio, BigQuery, GitLab etc. (Èquipe Totem Inc.)
2. Building Data pipeline to migrate data from google sheets, Mixpanel, and Postgres DB into Data Warehouse using Google Cloud Composer 2 (Airflow), python, federated queries for a tech startup. (WebVerif)

Company: BuyPower ABUJA, NG
Role: Data Engineer [buypower.ng(YC 2017)]
Timeframe: SEPT 2021 - PRESENT

1. Lead a team of three Data Engineers, and collaborate with Engineering management on continual improvement of the ETL process, Documentation, data pipeline architecture and system architecture design to minimize operation cost by 40%.
2. Design and implement data ingestion pipelines (batch and stream) for data replication automation of request logs from an unstructured database(MongoDB, Firebase), relational database (MYSQL in Amazon RDS) to Data Warehouse (BigQuery).
3. Build multiple observability ETL systems (DBT)  that give several teams insight into their operations, increasing transparency of information and reducing time to insight from days to mere seconds.
4. Culling Insights and preparing multiple Google Data Studio dashboards for various teams and stakeholders from Data warehouse to answer business questions and consolidate the company’s long-term goals and visions.
5. Implementing several schema and query optimisation techniques which reduced the overall time required to execute queries by up to 70%
Tools used include Bigquery, SQL, Python, Google Data Studio, GCP (Cloud Functions, Scheduler, VM Instance, Cloud SQL, Cloud Storage), Google Colab, MySQL, MongoDB, RestAPI, Firestore

Company: Smarterise LAGOS, NG
Role: Data Analyst
Timeframe: APR 2020 - AUG 2021
1. Performed ETL on big energy data (Millions of rows)
2. Presented summarized data insights on energy consumption and power quality to save more than 30% of the annual operational budget of our clients.
3. Built from scratch a comprehensive KPI sales report for a Multinational client to track their sales records and make data-driven decisions to increase their annual sales.
4. Applied ML model in predicting energy load profile for research and recommendation purposes.
Tools used include Python, Excel, Power BI, Google Colab