** ******** ****** ******** *****, Nigeria.
With 7 years of Business Intelligence and Data warehousing experience in Financial institutions. Am self-consultant with an extensive in both functional and technical design, Data integration, data quality, master data management and dashboard report. Implementations include Microsoft customer relationship management Dynamics 365 and VeriTouch, Enterprise Data Lake, Enterprise Data warehouse and reporting. Currently at First Bank of Nigeria on the implementation of Oracle Financial Services Analytical Application (OFSAA).
Dimensional Data Modeling (Star Schema, Snow-Flake, FACT, Dimensions Tables, Physical and Logical Data Modeling, ER Diagrams, Erwin 4.5/4.0/3.5 ETL)
Business Intelligence (SSAS, SSRS, Power BI.)
Cloud (AWS, Azure.)
Data Integration (SSIS)
Programming (SQL, TSQL, PL/SQL, Python)
Databases (Oracle, MS SQL Server, MYSQL.)
Environment (Windows, Linux.)
Senior Data Integration Developer 2018-Present
Workforce group (First Bank), Nigeria
Project: Oracle's Financial Services Analytical Applications (OFSAA)
Understanding Download specifications for various modules (ALM, PFT, FTP etc.) of OFSAA.
Understanding of logical and physical OFSAA data model and ETL Process.
Transforming business-oriented functional specifications into ETL and OFSAA Test Scenarios and associated Test cases.
Used Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
Developing PLSQL PACKAGES, PROCEDURES, FUNCTIONS based on the original data in the development environment.
Performing data extraction from core banking system (Finacle) to OFSAA staging using SSIS, PL/SQL Programming and T2T mappings.
Project: Microsoft Dynamics CRM 365
Reduced turnaround time from 24 hours to 3 hours, enabling Relationship managers to access newly created accounts in CRM (migrated from core banking solution) through ETL script development.
Provided over 4,000 users with access to Customer data (profile, segment, products, channels, transaction, cases, alerts, next best action etc.) through ETL development and implementation.
Established the data quality for CRM implementation by 55% and cleansing objectives from analyzed source data using talend Open Studio.
Automate and optimize ETL run processes for optimum performance which reduced extraction and transformation time by 2 hours.
Reviewed of Microsoft Dynamics CRM 365 Software requirement specification (SRS) with the business users.
Specified ETL Requirement for test and development environment to provide highly scalability and performance system.
Experience in analyzing the multiple source systems (Finacle, Finone, MIS etc.) and based on the business requirements build the transformation rules to extract, transform and load the data in the target CRM core systems.
Adapt ETL processes to accommodate changes in source systems and new business user requirements.
Prepared document for Data strategy and governance which contributes extensively to architecture repository.
Encrypted data using KingswaySoft PGP Encryption.
Senior Business Intelligence Developer 2017-2018
Intelfort limited (United Bank of Africa), Nigeria
Project: Data Lake
Developed project plans to implement Data Lake solution and identified requirements.
Worked with Business Analyst to understand the business and to design the architecture of the data lake.
Developed and maintained ETL to extract and transform data from multiple source systems to Staging area and ensure data availability at all times.
Increased data quality by 60% through cleansing.
Stored Customer’s data history which enable visibility into marketing and serve as a knowledge base for future marketing campaigns and activities.
Defined Data strategy and governance.
Conducted impact assessment and determine size of effort based on requirements for completeness and accuracy.
Worked with business requirements to identify and understand source data systems.
Dimensioned sources to different attribute e.g. Phone, email, location etc.
Validated Customer’s Phone no, email address etc. for correctness.
Developed dashboards and reports using SSRS and Power BI.
Prepared User Documentation and Technical Guide.
Database Developer 2012-2016
Ekons consulting limited (Access Bank, Polaris Bank, GT Bank), Lagos, Nigeria
Project: Electronic Financial Analysis and Surveillance System (eFASS)
Saved banks 2million charges from CBN for late submission of daily returns.
Developed application that import the bank transaction into excel sheet return template and generate XML files for each of the returns within 20mins.
Assisted bank return officer to timely submission of daily returns to CBN before 10am deadline through automated Returns Rendition System (RRS).
Automating the end-to-end workflow of regulatory reporting from data capturing to validation and report delivery to CBN with zero error tolerance.
Assisted Users to generate Daily, Monthly, Quarterly, Semi-annual, CRMS and FOREX returns.
Designed and developed Web-enabled Forms and Reports for the user interface using Oracle Application Express (APEX).
Lead development team (2 developers) to create database objects and designed user interface.
Translate business requirement and business conversion rules into technical specifications that the developers can understand and use to transform the data.
Responsible for Installation and testing database.
Reviewed, optimized, and created procedures and functions, ensured better performance; monitored server processes, backed up and restored database
Designed and Run Database Snapshot.
Define and Implement Error logging and alerting strategy.
Prepared user’s manual and technical documentation.
Trained the users.
Postgraduate Program in Data Science and Business Analytics in view
The University of Texas at Austin
Higher National Diploma in Electrical Electronics Engineering 2009
Lagos State Polytechnic, Nigeria.
Diploma in Electrical Electronics Engineering 2006
Lagos State Polytechnic, Nigeria.
West Africa Senior Secondary Certificate Examination 2000
Oke-Odo High School, Nigeria.