Technical Skills
Software & Technical Architecture: Agile
Deployment Platforms: JVM, .Net, WebSphere Application Server (liberty), IIB 10, Intellig, Eclipse, Pycharm, Weblogic, dockers and Kubenetes
Data Storage Technologies Platforms: ORACLE, MSSQL, MYSQL, DB2, BIGSQL, NoSQL, Hive, HBASE, Azure Data Factory, Google BigQuery, Kafka, Hadoop, AzureSynapse ,DataBricks,hdfs,IBM gpfs, Data Modelling, dbt,Data Lake, pub sub Dataflow, spring batch for ETL
Data Science & Data Analytics: PowerBI, IBM Cognos, Tableau , PowerApps, EXCEL, Macro, VBA
Testing Tools: selenium, soapUI, Postman, Apache Jmeter
CI/CD: Teamcity, GitLab,GithHub, Jenkins
Design Tools: Visio, LucidChart
Programming Languages: JAVA, Excel macro, .Net, Python, PySPARK, PLSQL, SQL, C, C++, SCALA, Spring, Lambda, JAX-WS, JDBC, EJB3, JMS, Hibernate, Java,Spring Boot,RESTful APIs,Agile Methodologies,Git,JUniT/MOCKITO,IntelliJ IDEA,Jenkins,JIRA
Frameworks: Axis2, Spring, actuator,Security, git, Spring batch for ETL,Junit,Mockito,
Cloud: GCP, IBM Cloud, Azure, AWS
ETL Tools: SSIS, SSRS, IBM DataStage, ADF, SCOOP, AIRFLOW
Business Analysis: Requirement Gathering, Stakeholder Engagement
Project collaboration tools: Jira Confluence
Certifications
DB2 Technical Mastery (IBM)
Infosphere Guardium Technical Mastery (IBM)
IBM Mobile Foundation V8.0 Application Development
Education
University of Bristol
Postgraduate diploma in Advanced Computing: Machine Learning, Data Mining, HPC
University of Lagos, Nigeria
MSc, Statistics
Federal University of Technology Minna, Nigeria
B.Tech Mathematics/computer Science
Employment
PCWORTHS & DATA ASSOCIATES LTD
Product development: (Contract) May 2023 –September2024
Java and Data Architect
Project Rent affair Management and Collection for Commercial Bank
Application consists of multiple tiers:
Backend APIs developed using Java 11, Spring and jetty frameworks), deployed on Google Cloud Platform (GCP) as APP Engine
Utilizing MySQL and Microsoft SQL Server for database management and implementation of the data models.
Batch processing handled by CRONJOBS using Spring Batch.
Mobile application integration using Flutter for Android and iOS platforms with the API suite created .
Admin module created with .NET 6.0 Razor Pages application.
UI/UX design implemented using Figma.
Built TDD with junit and BDD test result with Cucumber.
Payment module integrated with Stripe API, SQAUD API, and PaysStack API.
Built suit of Spring Microservice to expose Investment Enquiry, AccountStatement, Loans and overdraft data for Notifications and encrypted email for Flex cube 12 . This is done by building PLSQL stored procedure called with jdbcTemplate withing Microservices(SOAP & REST)
Built the Junit Tests and integrated into the Jenkins Pipeline.
Frontend for Mobile Using Flutter 3.19 and build frontend with react.js for the Web
GraphQL Java 8 Spring Boot to rapidly create the User Administration Module for profiling customers and devices.
Data Engineering/ArchitectureProjects
Designed and implemented a Data Warehouse for Loans, Account Enquiry, and Money Market using the Kimball methodology with a focus on 3rd Normal Form (3NF) data modeling.
Optimized data structures for rapid retrieval, reducing latency for Power BI reports.
Developed complex DAX functions to support the creation of dynamic and ad-hoc Power BI reports, enhancing data insights and decision-making capabilities.
Designed and implemented a robust ETL pipeline to integrate data from diverse sources, including on-premise OLTP Treasuryr Appllication databases(Flexcube) and third-party enrichment web hooks, into Azure Data Lake Gen2 using Azure Data Factory in a pipeline in Azure Synapse Analytics and saved as parquet and avro types using gzip compression
Create Storedprocude to output recordset that is stored in the azure data lake storage in parquet and avro file format. Create Jupyter Notbooks to manage the delta in the respective azure storage accounts for PowerBI report to display the reports.
Utilized ADF activities and Link Services synchronization for seamless data flow within the pipeline.
Configured the pipeline to output data in the Parquet file format, enhancing efficiency, and employed the Snappy compression algorithm for optimal storage.
Extended ETL capabilities by integrating a PySpark notebook, enabling efficient processing of delta data.
Implemented a Hive table schema to present the processed data, ensuring ease of access and analysis.
Created a data pipeline that interrogate the file on HDInsight on azure onpremise cloud on premise and populate GCP bigquery table. Using Java 8+
Migrated Onpremise DataWarehouse on MSSQL sever for ATM /POS transaction datamart to SnowFlake Database on GCP.
Manager - Technology (Delivery, Java), Publicis Sapient, London| Digital business transformation & consulting company, Sep 2022 to April 2023
Senior Software Engineer delivering secured microservices to clients:
Lloyds Banking Group
Java/ Data engineer delivering microservices in a secured manner using ForgeRock 7.2.0.
Collaborated with SMEs to agree on the rules and structure of the data exchange.
Build the Roadmap for onboarding journeys on Azure into the Confluence portal
Developed OAuth2.0 security architecture on Java 11 Spring-boot to connect mobile/internet banking, IVR and other applications that need to connect to the security service. This is deployed on docker images and orchestrated on K8
Deployment of Spring security orchestration webservice into kubenetics cluster on GCP. This is deployed on docker images and orchestrated on K8
Created realms using minimal code on ForgeRock 7.2.0 for federated authentication and authorization, with multifactor capabilities and deployed it rotating a 2KB encryption key that was rotated.
Mitigated OWASP security concerns with JSON Web Signatures (JWSs) to mitigate and incorporated a signed authority certificate to fortify the development process.Created dataflow of enriched data from thirdparty into Credit Decision Datawarehouse bigquery on GCP. Using spring batch.
Developed a Spring Boot RESTful microservice for Lloyds Banking Group, leveraging Java and the Spring framework. This is deployed on docker images and orchestrated on K8
Created Consumers and Producers for external data enrichment for Pub and Sub on GCP to enrich the decision support system.
Senior Java/Data Engineer, PCworths & Data Associates LTD, London| Data engineering consulting company, Jul 2022 to Aug 2022
Mick George
Digital transformation – migration of SSIS ETL to Azure data factory for business continuity due to SSIS ETL support coming to a close.
Gathered requirements from stakeholders to create the functionality of the classic SSIS jobs and migrated the data into ADFv2.
Created the dataflow diagrams with Visio.
Designed the ETL flow with Visio
Migrated SSIS ETL jobs into Azure Data Factory and Integration runtimes.
Senior Java BigData Engineer, ALVA GROUP, London| Reputational intelligence and analysis company, May 2022 to Jul 2022
Led workshops with senior stakeholders to document the specification for the notification schedule and reputational intelligence notification.
Developed an ETL job to process text articles into a Postgres database.
Constructed an alert notification service for email and push notifications.
Optimized Postgres SQL procedures and functions and deploy the service to AWS.
Created a microservice using java 11 Spring Boot and monitor jobs on AWS.
Perform Stress test on the microservices to guarantee
Chief Software and Data Architect, First Bank Nigeria Ltd, Feb 2020 to Apr 2022
Built Equity Predictive Model using Facebook Prophet and LSTM for Nigeria Stock, this was turned into weekly forecast for for select customers that subscribed to advisory service.
Performed Statistical analysis of Retail product to determine the possibility of Cross Sell and lucrative Market Basket Analysis and this achieved the target 20% month on month 20% charges revenue for the bank
Led workshops with stakeholders to gather requirement for the Channel Stability
Datawarehouse. Created the Data Models.
Created consumers to process the swift file MT103 against the Finacle Banking System using Java 11.
Built the technical design document for each incidence and also define the metrics
Built the Data models for incidences of the Channels Stability.
Led technical teams by creating the frameworks in design and implementation of ETL jobs on SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
Implemented secure and scalable Data Lake on Azure for ATM journal files. Created data pipelines with Azure Data Factory to extract, transform, and load data into the lake. Employed Azure Databricks for data processing, analytics, and machine learning, delivering a solution that met the client's needs and enhanced their analytics capabilities
Created ETL jobs on Azure Databricks to receive and store data from Reuters, using aggregate/descriptive statistics to share with bank teams, and scheduled on Azure Data Factory.
Deployed classic SSIS package to Azure DataFactory V2 and implemented IIB 10 and
WebSphere Application Server Network Deployment for data exchange using REST services over TLS.
Designed and optimized storage techniques to reduce the storage of the Data Warehouse in the cloud database and create a blueprint for database object coding and scripting standards.
Led the design pattern of microservices, using loosely coupled techniques to simplify complex ETL jobs and created a Java 8 microservice that interacts with noSQL databases using Java 8 MapReduce concepts.
Created dashboard using react.js by consuming spring services endpoint marshaling the datapoints to create interactic analytics and graphs
Developed an interactive dashboard using React.js, integrating Spring service endpoints to fetch and marshal data points.
Designed analytics and dynamic visualizations to display incidents, empowering contact center agents with actionable insights.
Digital Alliance and Services Manager| SunTrust Bank, Lagos Nigeria, May 2019 – Jan 2020
Led the team and engage the third-party Loan merchants to create the Business Requirement Document for data exchange with Flexcube and T24 Banking Software
Engaged the third-party data providers: Nigerian interbank Settlement organization, credit scoring service providers, GSM Telco companies, anti-money laundering organization to enrich the prospective retail loan customer data across the mention areas.
Developed the business requirement document to create the 360 degree portal for customer.
Developed the data analytics flow document with Lucid Chart to create the eligibility criteria and implemented it using Python/SQL and the model is pickled and wrapped in a webservice. That is called from the channels: IVR, USSD, and Web & Mobile banking Platforms.
Market place solutions were developed to acquire more customers and retail accounts. Customized and bespoke solutions were provided to strategic business units of the bank.
Created API economy solution guidelines for onboarding startups in the payment ecosystem who required integration with Flexcube banking software using node.js and express framework.
Managed a team of developers and business analysts to build a digital loan eligibility model.
Lead Software & Data Architect, SallySoft International Lagos, Nigeria Sep 2017 to Apr 2019
Implemented Misys Trade Finance to integrate with Flexcube banking application, using IIB 9.
Created 360-degree view of customer on SharePoint 2013 and migrated the application to 2016
Trained developers on IBM Business Intelligence using IBM Cognos/Power BI and mobile application development using IBM MobileFirst 8.0.0 in IBM digital Skills for Africa in IBM innovation center.
Supported Top Tiered Banks on IBM Cognos server support and dashboard creation.
I created an APP for mass transit with AI using IBM cloud services and won $7000 US Dollars for SallySoft in IBM Watson Build Challenge, Africa, and Middle East, 2018.
Developed a Trade Registration Portal using Node.js 8 for the backend and SQL Server 2012 for data storage, ensuring efficient and secure transaction processing.
Information Management Specialist - BIGDATA Analytics, IBM, Aug 2013 to Jun2016
Worked on projects related to big data, IBM Cloud, and application migration to DB2 and WebSphere application server in Nigeria, Ghana, Egypt, and Morocco.
Created data architecture designs, data governance, and enterprise data architecture implementations for tier-1 organizations.
Conducted big data and big insight boot camps for 5 universities in Nigeria, Ghana, Egypt, and Morocco and provided training on Infosphere DataStage ETL development.
Optimized DB2 database management and executed application porting from MSSQL, ORACLE11G to DB2
Conducted DB2 and Websphere ND deployment enablement sessions for IBM Business Partners.
Business Solution Architect -Deputy Manager, Access Bank Plc, Feb 2007 to Jul 2013
Led the development of various applications and services using JEE, PLSQL, and other technologies for the bank's Contact Center Operations, including an Internet banking application as addendum to Flexcube Banking Softaware, a webservice, and an Account Activity Alert via SMS.
Led the development of Java Action components for Cisco Customer Voice Portal 4.01 for the bank's Interactive voice response application with Flexcube core banking software.
Led the development of a single sign non-webservice utility to talk to Active Directory for authentication.
Led the development of ISO8583 message Format Bridge to talk to Flexcube using JPOS 1.5, JDK1.6.
Developed an SMS and Email Notification portal using Node.js 6 and Express 3 framework, enabling reliable and efficient message delivery.ssss
Software Engineer May 2004 to Dec 2006
Zenith Bank Plc; First Bank Nig Ltd; Neptune Software Plc
Loaded data sources into a data warehouse using ETL process., that takes data fron FINACLE banking software. Built PLSQL procedure for ETL pipeline
Administered databases on Linux platform.
Generated Management Information System using J2EE technology and XML format.
Programmer, Allied Soft Limited, May 2001 to Apr 2004
Used MSSQL .NET 2.0, Visual basic 6 and Visual C++ 6.0 to develop the Human Resources and Loan module of the Xceed 1.0.