John Opeyemi Dada
Data Analyst/Engineer at Henalog Global Services
Based in Lagos
About
In recent years, John has demonstrated focused interest in data and has acquired advanced skills in data analytics, data science and engineering. Interested in deploying technologies, data and AI to support, transform and strengthen existing businesses, while helping to build new and sustainable ones, John is seeking career opportunities that can take advantage of his skills and experiences, in environments where learning, growth and innovation are entrenched. A go-getter, committed to accomplishing tasks within timelines using available resources, and an effective team-player, John is dedicated to continuous development and channeling personal and team's strengths towards delivering on organization's objectives.
Skills
Projects
Experience
Oct 2023 till date
Data Engineer at Henalog Global Services
I. Joined a team developing a mobile application that will serve as a digital payment solution unique for providing credit services to users booking rides on ride-hailing platforms. II. Was responsible for design of data warehouse architecture, database performance optimization and implementation of scalable data warehousing solutions at every stage of the product. III. Designed and implemented scalable lake storage solution for this product in Azure.
June - Oct 2023
Data Engineer at Freelance
I. Designed data ingestion pipelines that ingested data from different sources into company’s data lake storage. II. Implemented triggers on data pipelines based on frequency and/ or requirement for incoming data to automate pipelines. III. Implemented workflows in data pipelines to transform incoming data based on data warehousing requirements and needs of data analysts and other data consumers. IV. Implemented dataflows that moved trans
Feb to June 2023
Data Enginering Trainee at DataTalksClub
I. Developed programming in CLI skills including Bash, PowerShell, pgcli, which serve as a faster alternative to GUI for working with software. and containerization with Docker. II. Applied advanced Python programming skills to develop ETL pipelines for extracting data into local RDBM systems such as PostgreSQL using pgAdmin, Docker and Docker-compose. III. Applied advanced Python programming skills to develop ETL pipelines for extracting, transforming and loading data into GCS (Bucket). IV. Applied SQL skills to transform data in data lakes and migrate them to data warehouses such as BigQuery where they are deployed for consumption. V. Orchestrated and implemented workflows to manage and monitor data pipelines setup as DAGs in Apache Airflow to load data into local and cloud-based
2022 - 2023
Data Science Trainee at OneCampus Academy
I. Developed intermediate to advanced Programming skills in Python necessary for bigdata and analytics. II. Developed complete and deployable Python scripts for Grocery Store Sales and Inventory Management Application. III. Used versatile python libraries such as pandas, matplotlib, seaborn to analyze and visualize complex, public datasets and discover crucial relationships that exist between target variable and other features in diverse datasets. IV. Acquired skills necessary for training data science algorithms from scratch and deployed these skills to train several classification and regression models including DecisionTree, LogisticRegressor, RandomForest, ExtremeRandomTree, LightGBM, XGBoost, LinearRegression, PolynomialRegression, Lasso and Ridge regression algorithms.
2021 - 2022
Data Analyst Trainee at Quantum Analytics NG
I. Developed intermediate to advanced Excel skills as introductory data analysis tools. II. Worked with complex datasets to perform exploratory data analysis, and deliver actionable insights via interactive dashboards built in Ms-Excel and PowerBI. III. Developed basic SQL skills and worked on publicly available databases such as Adventure Works to implement SQL queries in Microsoft SQL Server and PostgreSQL. IV. Evaluated of Sales trends in order to understand competitive environment, product performance and effectiveness of strategies; V. Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending actions; VI. Created databases and developed database objects, including tables, views and materialized views using S
Education
2006-2011
Electrical/ Electronics Engineering at University of Lagos
Statistics Computer programming Engineering Mathematics Computer-Aided Design Power Systems Analysis, Design and Planning Power System Protection High Power Engineering Electronics Circuits Analysis and Design Electrical Circuits and Systems Analysis and Synthesis Electrical Machines Electromagnetics Communication Systems Control Systems Analysis and Design