Joel Otolorin

Experience

• 

  Nigeria Inter-Bank Settlement Systems PLC

  Jan 2009 - Jan 2021

  • Supervised end-to-end and ensured timely execution of daily business intelligence team's activities, achieving a 99% service delivery rate.• Managed relationships with internal and external stakeholders, addressing complaints promptly and closing issues within the agreed SLA thereby surpassing SLA compliance targets by 20%.• Designed, developed, and maintained comprehensive reports, and dashboards using SSRS, SAP BO/BI, Microsoft BI tools, and Power BI, significantly improving stakeholder data presentation and insights.• Created and managed highly efficient ETL processes using SSIS and SQL, ensuring 100% data accuracy and completeness.• Developed and maintained data models and databases using SQL Server and MySQL.• Implemented various business intelligence strategies, including analytics, ad hoc reporting, classified reporting, management dashboards, and information-sharing solutions.• Analysed financial, operational, and customer data, resulting in an improvement in efficiency, products' adoption and informed decision-making across the organisation.• Collaborated with various departments to identify business requirements and delivered data-driven solutions with a 95% satisfaction rate. Show less • Managed data warehouse and SAP Business Object/Business Intelligence server, ensuring integrity and accuracy of NIBSS data warehouse data.• Created and managed ETL process in migrating data from various arms of NIBSS platforms into the data warehouse achieving 99.5% data accuracy.• Developed and maintained reports and visualisations using SSRS (Report Builder), SAP Business Object/BI and Power BI providing stakeholder insights and increasing data-driven decision making by 30%• Trained operation & CRM teams on using NIBSS OLAP solution (SSAS) for products analysis, resulting in an improvement in their data analysis capabilities.• Built SQL queries for contact centre and operation teams, reducing report-generation time by 10% and improving overall operational efficiency.• Conducted data analysis on various products, identifying areas for improvement and increasing product performance by 15%.• Collaborated with cross-functional teams to identify business requirements and deliver data-driven solutions, leading to a 25% increase in process optimisation.• Prepared statistical data for metrics used in the bank's efficiency award annually, encouraging participation and improving overall performance by 20%. Show less • Enhanced transaction monitoring and risk aversion strategies for the firm and its clients, resulting in a 50% reduction in potential risks.• Streamlined and managed the NCR/ECPIX Cheque Clearing infrastructure, leading to a 70% improvement in automated processing efficiency.• Delivered technical support to Nigeria Automated Clearing System (NACS) banks, ensuring a 90% resolution rate for technical issues.• Accountable for managing the automated NCR/ECPIX cheque-clearing infrastructure.• Accountable for processing and rendering of clearing reports, files, and statistics to designated recipients.• Accountable for the management of the Data Centre Operations/server environment.• Perform routine full system back up and storing the backup tape at the DR site.• Implemented and managed an automated solution, reducing cheque-processing time in the region by 71%, from 7 days to 2 days. Show less

  • Senior Business Intelligence | Data Analyst

    Jan 2018 - Jan 2021

  • Data Warehouse Officer | Business Intelligence Analyst

    Jan 2013 - Jan 2018

  • Data Operations Support Analyst

    Jan 2009 - Jan 2013
• 

  Hexis Lab Limited

  Jan 2022 - Jan 2023

  Data Analyst

  • Carried out explanatory data analysis various datasets using Pandas, NumPy, Matplotlib and Seaborn from Python library in a Jupyter notebook environment.• Created interactive dashboard and result template for data queries using Power BI and Microsoft Excel.• Conducted systematic reviews on AI software, identified the common techniques and made recommendations, resulting in an increase in the laboratory's ability to leverage advanced data analysis technologies and accelerate the discovery processes. Show less

• 

  Primed Talent UK

  Aug 2024 - now

  AWS Cloud Practitioner Intern

  • Design secure, high-performing, cost-effective, highly available, and scalable systems by using AWS services according to best practices defined in AWS well-architected framework, Cloud Adoption framework• Learnt various AWS services including but not limited to EC2, EBS, EFS, IAM, VPC (Sub netting, Routing table configuration), Route 53, S3, Trusted Advisor, Systems Manager, Lambda, Config, Cloud front, AWS Organizations, Billing, Athena, Elastic load balancing, Auto scaling, SNS.• Gained knowledge on different areas like deployment automation using Cloud formation, Monitoring & logging using cloud watch, cloud trail, DevOps process like CI/CD, Configuration Management tools like GIT• Gained exposure to data mining and explored different AWS database services like RDS, Dynamo DB. Learnt Python basics and applied it with serverless services like lambda• Explored different ways to interact with AWS services like AWS CLI, Management console. Show less