Adewole Aboyade-Cole
Romford,Essex
Summary
Data professional specializing in SQL, including BigQuery and Redshift, with a solid background in data validation and quality assurance. Expertise in data discovery, source identification, and KPI dataset creation, ensuring efficient dashboard-ready query outputs. Proficient in Python and R programming, alongside advanced Excel skills. Demonstrates strong multitasking abilities and time management, utilizing advanced data analysis tools for impactful insights.
Overview
1
1
Certification
5
5
years of post-secondary education
5
5
years of professional experience
Work history
Logistics Analyst/Process Control Specialist
Amazon
Tilbury, Essex
2021.10 - Current
- Enhanced data interpretation by developing interactive dashboards using Power BI.
- Led structured deep dives and root-cause analysis on performance variance, translating drivers into clear actions, owners, and timelines; protected service performance during Prime Week with ~9–10k units at risk.
- Delivered key insights by analysing patterns in extensive datasets.
- Increased productivity by using Python to automate routine tasks.
- Identified risks and trends in fulfilment performance by collaborating with site leadership during KPI-focused business reviews.
- Improved reporting accuracy and standardisation by building repeatable workflows in R.
- Optimised business review processes by using Python and R to streamline data handling and visualisation.
- Ensured operational data reliability through SQL queries in Amazon Redshift, transforming data from multiple warehouse tables for analysis.
- Calibrated control systems to improve operational performance.
- Identified issues in existing control systems and recommended improvement opportunities.
- Monitored process control systems to support efficient operations.
- Enhanced production efficiency by implementing process control strategies.
Human Associate Resources Partner
Amazon
Tilbury, Essex
2021.01 - 2023.08
- Analysed absence and attendance records within Salesforce to identify reasons for unauthorised absence.
- Maintained absence reporting datasets, ensuring quality checks for completeness, duplicates, and outliers.
- Supported implementation of scheduling interventions to reduce unauthorised absence hours.
- Ensured compliance with company policies through regular audits.
- Fostered positive work culture through proactive communication.
- Partnered with cross-functional stakeholders to translate analysis into targeted, evidence-based scheduling interventions, contributing to 37% reduction in unauthorised absence hours.
- Coordinated holiday schedules, minimising operational disruption caused by staff absences.
Education
MSc - Marketing
University of Essex
Colchester, Essex 2018.09 - 2019.09
BSc - Business Administration
Caleb University
Lagos, Nigeria 2012.08 - 2016.08
Skills
- SQL: BigQuery and Redshift
- Data validation and quality checks
- Data discovery and source identification
- KPI dataset creation and transformation
- Dashboard-ready query outputs
- Excel spreadsheet mastery
- Multitasking efficiency
- Data analysis tools
- Time management expertise
- Python programming acumen
- R and python proficiency
- Python coding experience
- Python coding
References
Available on Request.
Projects
- Multi-KPI Operational Performance Dashboard — Amazon Redshift SQL Built a Multi-KPI Operational Performance Dashboard using Amazon Redshift SQL, combining performance, quality, staffing, cost, and volume data into dashboard-ready datasets for AWS QuickSight. Wrote complex SQL using CTEs, joins, aggregations, CASE statements, COALESCE, and date logic to transform raw warehouse data into structured KPI outputs by site, week, region, metric group, and unit. Identified and validated reliable warehouse tables, cross-checking outputs against existing KPI sources to improve data accuracy and support leadership decision-making on site-level cost opportunities. Link: https://github.com/Adewole-211/Data-Analysis-Portfolio/blob/main/SQL%20examples/multi_kpi_join_v1.sql
- Warehouse Productivity Reporting Workflow — R Built a repeatable warehouse productivity reporting workflow in R, using dplyr, tidyr, lubridate, ggplot2, and openxlsx to clean, transform, summarise, and export KPI datasets. Created site-level and week-over-week productivity summaries across multiple warehouse metrics, including tables, wide-format tables, and dashboard-ready Excel outputs. Produced root-cause analysis outputs and visualisations, grouping performance issues by process path and root cause to highlight BPS contribution and operational improvement areas. Link: https://github.com/Adewole-211/Data-Analysis-Portfolio/blob/main/Script%20Templates%20From%20Work/Warehouse%20Productivity%20Reporting%20Workflow.
- Seoul Bike Rental by Month and DOW — Tableau Built an interactive Tableau dashboard analysing Seoul bike rental patterns by month and day of week, enabling users to identify seasonal demand trends and weekly usage patterns Links: https://public.tableau.com/views/SeoulBikeRentalbyMonthandDOW/Dashboard1?:language=en-GB&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
Certification
- Google Data Analytics Professional Certificate (2025)
- Google Advanced Data Analytics Professional Certificate (ongoing)
Timeline
Logistics Analyst/Process Control Specialist
Amazon
2021.10 - Current
Human Associate Resources Partner
Amazon
2021.01 - 2023.08
MSc - Marketing
University of Essex
2018.09 - 2019.09
BSc - Business Administration
Caleb University
2012.08 - 2016.08