Oluwole Okusolubo
Toronto,ON
Summary
Proven Data Engineer with a track record of enhancing data operations and security at Clydefield Limited. Expert in SQL and database administration, I've automated pipelines to slash processing times by 50% and mentored teams to foster best practices. My collaborative approach and technical prowess drive efficiency and innovation.
Detail-oriented data engineering designs, develops and maintains highly scalable, secure and reliable data structures.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Engineer
Clydefield Limited
05.2017 - 06.2022
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
- Designed scalable, cloud-based data architectures leveraging AWS and Azure to support enterprise-level data operations, ensuring high availability and cost efficiency.
- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
- Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
- Automated data pipelines processing over 10 TB daily, reducing processing time by 50%and enhancing system reliability.
- Led the deployment of machine learning models into production environments, optimizing inference time by 30%, enhancing real-time analytics.
- Implemented real-time data quality monitoring systems that reduced downtime by 25%and improved data accuracy by 95%.
- Mentored junior data engineers, promoting best practices in data pipeline optimization and cloud infrastructure management.
- Managed ETL processes for financial and telecommunications clients, automating workflows to reduce integration times by 60%.
- Developed distributed computing frameworks using Hadoop and Spark to process large datasets efficiently for Airtel Nigeria’s network performance analysis.
- Migrated legacy on-premises systems to cloud-based solutions, achieving 40% cost savings for high-profile clients.
- Supported data scientists in model deployment, ensuring seamless integration and optimized performance across cloud environments.
- Design of data pipelines and the development of relational databases to support reporting and analytics functions.
Application Support Associate
Skye Bank Plc
07.2015 - 04.2017
- Increased operational efficiency by developing automated scripts for routine tasks and reporting purposes.
- Developed customized training materials to improve user adoption rates and overall application proficiency.
- Transform data from raw data into useful data systems while striving for efficiency by aligning data systems with business goals.
- Continuously improved the support experience by gathering feedback from users, implementing changes based on their input, and closely monitoring satisfaction levels post-implementation.
- Delivered exceptional customer service, consistently meeting or exceeding response time targets for incident resolution.
- Design, build and maintain data architecture (data pipelines, databases and data lake/warehouse)
- Develop and maintain ETL processes Swift-Alliance and Auto-Swift Messaging System Support (local and international transaction messaging system)
- Central Bank of Nigeria (CBN) and Nigeria Financial and Intelligent Unit (NFIU) data reporting using advanced excel, tableau and Power-BI
- Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
- Automation and implementation of Vision Performance Reporting Tool for Business Intelligence, performance monitoring and Performance Management (MPR/Budgeting and Staff Appraisal system )
- Credit Risk Management Financial Reporting and System Support.
- Entrust 2FA Support (Second level authentication for system and apps)
- Loan application system Support (for Customer loan origination, processing and reporting)
- ITELLER (cheque clearing) system support
- Data Centre Infrastructure Management and control
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
Application Support and Data Analyst
Mainstreet Bank Limited
12.2013 - 06.2015
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Improved data visualization techniques, making insights more accessible to non-technical stakeholders.
- Provided day-to-day support for various applications, Monitored Logs and actively investigated and resolved production issues.
- Assisted in the development and maintenance of data quality assurance processes, ensuring data accuracy and integrity across databases.
- Assisted in Automation and implementation of Vision Performance Reporting Tool for Business Intelligence, performance monitoring and Performance Management (MPR/Budgeting and Staff Appraisal system).
- Maintained application and optimizing the application and reducing process rate by 20%.
- Learned new technology for software application and teaching them to our teammate(mentoring).
- Developed and optimized raw SQL queries and stored procedures in MySQL, improving query performance by 30% and reducing execution time.
- Created and maintained ETL processes and Utilized MS Excel to analyze and visualize data using power BI, creating charts, graphs, pivot tables, and utilizing advanced Excel functions for accurate reporting.
- Management Reporting with document and file Management Systems including SharePoint, Microsoft Office (word excel, Power point, SharePoint), Adobe.
- Data Centre Infrastructure Management and control.
Database Administrator
Computer Warehouse Group
11.2011 - 11.2013
- Collaborated with development teams to design and implement efficient database structures for new applications.
- Assisted senior administrators in fine-tuning database configurations for optimal performance and reliability.
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
- Streamlined processes for data migration and integration tasks, ensuring smooth system upgrades and transitions.
- Supported the resolution of database issues by troubleshooting performance bottlenecks and addressing user concerns.
- Assisted in maintaining data security through regular backup procedures and access control measures.
- Maintained robust backup schedules resulting in swift restoration following hardware or software failures.
- Aided in the implementation of disaster recovery plans to minimize downtime during unexpected events or system failures.
- Hands-on experience with database standards and end user applications
- Strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts
- Experience with developing high quality and optimized SQL stored procedures and queries
- Problem solving skills and ability to think algorithmically Scripting language experience such as Python and Javascript
- Experience supporting and working with cross-functional teams in a dynamic environment Strong communication for working with internal and external stakeholders
Education
Post-Graduate Certificate - Cloud Architecture And Administrator
Seneca Polytechnics of Applied Arts And Technology
Toronto04-2023
Post-Graduate Certificate - Big Data Analytics
Georgian College of Applied Arts And Technology
Barrie, ON08-2022
Bachelor of Science - Computer Engineering
University of Lagos
Lagos, Nigeria09-2009
Skills
- ETL development
- Data warehousing
- Data modeling
- Data pipeline design
- SQL expertise
- Data security
- Database administration
- Scripting languages
Languages
English
Full Professional
Certification
- AWS Certified Cloud Practitioner, December 2022
- Information Technology Infrastructure Library, May2014.
- Oracle 10g Database Certified Professional, July 2009
- Oracle 10g Database Certified Associate, June 2009
- Oracle (SQL) Certified Expert, May 2009
- Big Data Analytics with Hadoop and Apache Spark,Feb 2022.
- MapReduce and YARN, January 2022
- Developing Distributed Applications Using ZooKeeper, Feb 2022.
- Controlling Hadoop Jobs using Oozie. Feb.2022
- Cybersecurity: Incident Reporting and Response in Energy, December 2024
Timeline
Data Engineer
Clydefield Limited
05.2017 - 06.2022
Application Support Associate
Skye Bank Plc
07.2015 - 04.2017
Application Support and Data Analyst
Mainstreet Bank Limited
12.2013 - 06.2015
Database Administrator
Computer Warehouse Group
11.2011 - 11.2013
Post-Graduate Certificate - Cloud Architecture And Administrator
Seneca Polytechnics of Applied Arts And Technology
Post-Graduate Certificate - Big Data Analytics
Georgian College of Applied Arts And Technology
Bachelor of Science - Computer Engineering
University of Lagos
Similar Profiles
Mayank PareekMayank Pareek
Sap Hana Module User, Oracle ERP User at Adarsh Marketing, Asian Paints Limited ,Berger Paints India Limited, JSW Paints Private LimitedSap Hana Module User, Oracle ERP User at Adarsh Marketing, Asian Paints Limited ,Berger Paints India Limited, JSW Paints Private Limited
KOJO HASTINGSKOJO HASTINGS
CEO at Genelec Capital Limited, Genelec Support Services Limited•Genelec Infrastructure Development Services Limited•Zenith Hygiene Systems Ghana LimitedCEO at Genelec Capital Limited, Genelec Support Services Limited•Genelec Infrastructure Development Services Limited•Zenith Hygiene Systems Ghana Limited
RAKESH JRAKESH J
Network Engineer at EQL FINANCIAL TECHNOLOGIES PRIVATE LIMITED (Formerly name of INDIAFILINGS PRIVATE LIMITED)Network Engineer at EQL FINANCIAL TECHNOLOGIES PRIVATE LIMITED (Formerly name of INDIAFILINGS PRIVATE LIMITED)
Angelica AbuqueAngelica Abuque
Home Childcare Provider at BRADLEY MAZDAHome Childcare Provider at BRADLEY MAZDA
Shana KhoshnawShana Khoshnaw
Tutor at Toronto District School BoardTutor at Toronto District School Board