Ade Ibitoye

Data Analyst | Intelligent Automation Developer, 07/2023 - Current
JP Morgan Chase
• Design, develop, and optimize Alteryx workflows to automate critical business processes, resulting in increased efficiency and reduced manual effort.
• Create comprehensive process flow maps for Alteryx workflows, offering clear visual representations of data transformations and logic, aiding in communication, and troubleshooting efforts.
• Utilize Jira to meticulously document issues, changes, and enhancements, ensuring transparent and organized record of workflow modifications for future reference.
• Build and maintain data pipelines to extract, transform and load data from internal systems into Alteryx and Tableau.
• Collaborate with cross functional teams to gather and refine requirements, ensuring Alteryx workflows align with business requirements.
• Prepare high level analysis reports with Excel and Tableau
• Provide feedback on the quality of data including identification of billing patterns and outliers.
• Improve data quality by implementing cleansing routines, resulting in 25% reduction in data errors.
Customer Service Executive, 09/2022 - 06/2023
HSBC
• Provided exceptional customer service by promptly resolving customer queries and adhering to policies and procedures. Utilized technical proficiency in multiple systems to process a high volume of transactions with precision and accuracy. Ensured compliance with internal and external regulatory requirements.
• Demonstrated active problem-solving skills, thinking creatively, and paying attention to detail. Played a vital role in educating customers about HSBC products and promoting alternative digital banking platforms, resulting in increased digital account openings and reduced customer complaints.
• Efficiently addressed technical issues and transactional banking challenges while maintaining a keen eye for detail.
• Exceeded industry standards with a commitment to excellence, high standards, and a customer-centric approach. Achieved a 95% customer satisfaction rating by applying an insightful and logical approach to problem-solving.
• Managed banking and accounts with expert finance knowledge.
Data Analyst, 01/2017 - 12/2021
SG Resources Ltd
• Partnered with Business analysts, Data architects and business stakeholders from various teams to understand business processes, document project requirements and translate them into data insights to help them achieve their business goals.

Design, develop, and optimize Alteryx workflows to automate critical business processes, resulting in increased efficiency and reduced manual effort.
Create comprehensive process flow maps for Alteryx workflows, offering clear visual representations of data transformations and logic, aiding in communication, and troubleshooting efforts.
Utilize Jira to meticulously document issues, changes, and enhancements, ensuring transparent and organized record of workflow modifications for future reference.
Build and maintain data pipelines to extract, transform and load data from internal systems into Alteryx and Tableau.
Collaborate with cross functional teams to gather and refine requirements, ensuring Alteryx workflows align with business requirements.
Prepare high level analysis reports with Excel and Tableau.
Provide feedback on the quality of data including identification of billing patterns and outliers.
Improve data quality by implementing cleansing routines, resulting in 25% reduction in data errors.

Provided exceptional customer service by promptly resolving customer queries and adhering to policies and procedures.
Utilized technical proficiency in multiple systems to process a high volume of transactions with precision and accuracy.
Ensured compliance with internal and external regulatory requirements.
Demonstrated active problem-solving skills, thinking creatively, and paying attention to detail.
Played a vital role in educating customers about HSBC products and promoting alternative digital banking platforms, resulting in increased digital account openings and reduced customer complaints.
Efficiently addressed technical issues and transactional banking challenges while maintaining a keen eye for detail.
Exceeded industry standards with a commitment to excellence, high standards, and a customer-centric approach.
Achieved a 95% customer satisfaction rating by applying an insightful and logical approach to problem-solving.
Managed banking and accounts with expert finance knowledge.

Partnered with Business analysts, Data architects and business stakeholders from various teams to understand business processes, document project requirements and translate them into data insights to help them achieve their business goals.
Developed dashboards that increased insights, interpretations, and predictions for improved forecasting, resulting in 15% increase in forecast accuracy.
Performed ad-hoc reporting analysis as well as manipulating complex data on MS SQL server.
Developed SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables on SQL Server platform.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
Created dashboards that provide aggregate information regarding daily departmental operations and performed ad hoc analysis to identify potential issues.
Scheduled the reports to run on daily and weekly basis in report manager and email them to managers and analysts to review in excel spread sheet.
Data modelling
Data visualisation
Data validation
Data collection and analysis
Business intelligence expertise
Workflow automation
Cloud computing
Process improvement
Process mapping
Problem solving