Abdulafeez Adefabi
Development
Lagos, Nigeria
Skills
Data Analysis
About
ABDULAFEEZ ADEFABI's skills align with Database Specialists (Information and Communication Technology). ABDULAFEEZ also has skills associated with System Developers and Analysts (Information and Communication Technology). ABDULAFEEZ ADEFABI has 5 years of work experience.
View more
Work Experience
Data Consultant
PwC Nigeria
October 2021 - Present
- Anomaly Detection in Valves (Oil and Gas): Spearheaded the development of a machine learning algorithm for anomaly detection in one of Nigeria's leading oil and gas firms. Utilized Azure Databricks, Spark, Azure SQL Database, Azure ML, Docker, and Azure Web Apps for seamless deployment. Implemented feature selection using VIF and PCA models to enhance model efficiency, demonstrating a profound understanding of data science methodologies and the Azure platform ERP Data Migration: Executed an ERP data migration for an African conglomerate comprising of 15 companies. Led the data mapping procedures from AX 2012 to Microsoft Dynamics 365, developed scripts to ensure accurate data tests and migration. Enterprise Data Clean up: Extensive consolidation of tables related to various domains, performed completeness, validity, uniqueness tests from over 100 tables from different source system and developed automated python script that sends request to an API and persists customer information to the new database. Datawarehouse Build: Designed, built and maintained data pipelines, as well as analyzing and modeling data to extract insights and drive business decisions. Built ETL processes for enterprise data warehouse, designed pipelines that moves data from different database sources - Oracle, Postgres, MySQL, and SQL Server to the EDW. Created data marts for the various business and objectives. Fleet Management Analytics Solution: Data Integration and transformation client's excel data into a SQL database. Created pre-aggregations cubes with Cube.js to speed up the custom data visualization embedded into the web solution developed for the client. PWC Bootcamp: Facilitated and supported an extensive training on Power BI, R and SQL to over 50 students spanning 7 weeks. Developed case studies and quizzes to task the participants and deepen their learning process. Developed comprehensive dashboards and an executive summary, critical to the clients' businesses, provided new business strategy from insights and pattern in data
Research Analyst
Helpman Associates
October 2019 - February 2021
- Facilitated data extraction from primary and secondary sources, removing corrupted data and fixing coding errors with Stata. Provided data analytics support for high-priority, enterprise-wide initiatives involving IT/Product development, customer service improvement, organizational realignment, and process reengineering. Supported and coordinated at least 2 clinical/biomedical trials and investigators; advised and assisted investigators in determining the appropriate statistical methodology to meet their study needs and objectives with Stata and WHO's Avenir tool. Analyzed local, national, and global trends that impacted the health and agriculture industry Prepared reports for the management stating trends, patterns, and predictions for data-driven decisions
Quality Assurance Personnel
December 2018 - October 2019
- Teqbridge Limited Used advanced data assurance skills to automate all land transactions in Lagos State improving ease of business and revenue. Prepare reports to communicate outcomes of quality activities. Documented processes and maintained data records whilst adhering to best practices in data analysis and collection.
Data Enumerator
IHS, KPMG, Pepsi
May 2018 - December 2018
- Assisted these organizations in asset management and analysis of economic data Verify and provide accurate GPS of locations of site, as well as current address through an automated GPS tracker
Education
