Ade Adebayo
Senior Data Analyst
London,ENG
Summary
Experienced data management consultant skilled in navigating fast-paced, agile development environments. Proactively plans and prioritizes tasks to ensure timely achievement of project objectives. Collaborative and team-oriented, excels in problem-solving and applying logical thinking to drive progress towards improvement goals.
Overview
11
11
years of professional experience
4
4
years of post-secondary education
Work History
Technical Data Analyst
Department for Environment, Food and Rural Affairs (DEFRA)
London, England
2 2023 - Current
- Attached to the Nature Recovery Management System project and responsible for Data Analysis and management, as required
- Leveraged Python, SQL, and Power BI to define data elements and create visualisation, improving reporting efficiency by 30%
- Designed Conceptual and Logical Data models, enhancing system integration and data flow by 25%
- Engaged with SMEs and stakeholders, achieving a 95% approval rate on project deliverables
- Implemented data quality strategies during migration, reducing errors by 40% and optimizing ETL processes, increasing data processing speed by 35%
- Defined technical requirements and aligned data models with organizational goals, contributing to a 15% boost in project success.
Data Migration Specialist
Equifax UK
Leeds, NYK
02.2022 - 02.2023
- Business Rules Analysis & Rationalization: Conducted comprehensive analysis and rationalisation of business rules, optimising process efficiency and contributing to a 20% reduction in operational inconsistencies
- Product Pricing Management: Collaborated with the Business & Product Pricing Management team on product merging and decoupling strategies, resulting in 15% improvement in product categorization and pricing accuracy
- Contract Entry for C2O Transformation: Supported the C2O team in entering contracts efficiently, ensuring smooth contract transformation and reducing onboarding time by 25%
- Support for Data Migration & Validation: Facilitated data migration and C2O UI validation with business users during Mock & Bill Compare cycles, improving data accuracy by 30%
- ADEP Creation (Jira Tickets): Identified data quality issues during testing cycles and created Jira tickets, resolving 95% of critical issues before final migration
- Issue Resolution with Data Migration Team: Collaborated with the data migration team to ensure all migration issues were clearly understood and resolved, contributing to a smooth transition with minimal downtime
- Daily Standup Contributions: Actively participated in daily data migration standup calls, ensuring all logic was followed and communicated any changes promptly, increasing team alignment by 20%
- Business Communication on Migration Logic: Kept the Business C2O Team Lead up-to-date on migration logic, improving stakeholder understanding and reducing communication delays by 15%
- Documentation of cutover and go-live implementation alongside technical and non-technical stakeholders.
Business Intelligence Analyst
Govia Thameslink Railway
London, England
02.2019 - 02.2022
- Developed in-depth performance reports using Windows Server SQL, SSIS, Power BI, and Excel to support the Customer Analytical platforms
- Managed data extracts, SQL queries, campaign reporting, and maintained data quality, improving operational reporting
- Built KPIs and performance reports on Maximo leveraging Power BI and Excel, and conducted UAT on database enhancements, logging issues on JIRA
- Provided insights, identified trends, and engaged stakeholders to improve business operations and respond to MI queries
- Managed the central data center for reporting, reconciled data sources across Excel, XML, and SQL databases, and ensured GDPR compliance.
Data Governance Analyst
Tesco
Hatfield, Hertfordshire
08.2018 - 02.2019
- Created and managed the Data Governance framework aligned to DAMA principles, establishing data ownership and stewardship across the group
- Defined a target operating model for Data Governance and Data Management, covering people, processes, and technology
- Established and maintained a Data Governance Forum to drive policies, standards, and processes for operationalising governance
- Delivered a comprehensive data governance change plan, providing leadership and challenging the status quo across the organization
- Implemented a metadata strategy to support the Data Lake, including the collection and population of data into the catalogue
- Collected and reported data lineage for metadata, master data, and reference data using Collibra, ensuring transparency across the data lake environment.
Data Analyst (Migration)
UK Mail
Coventry, Coventry
07.2017 - 06.2018
- Worked as the data Analyst on 3 main Projects: Migrated Customer Data and GDPR Data options from Mailchimp to SalesForce CRM
- Migrated Meeting room Bookings Data from legacy UltrasoftBIS to OfficeRnD Bookings system
- Migrated Finance Data (AP/AR/GL/FA etc.) from Microsoft Dynamics NAV to SAP Business ByDesign
- Created several parameterised Dynamic Stored Procedures and ETL scripts to extract data from the legacy systems into the staging tables
- Provide specific sample data and report extracts to SMEs across board, for end-to-end User Acceptance Testing (UAT)
- Assisted the Finance department with Business Logic for transforming data from legacy systems to to-be systems.
Business Intelligence Analyst
B&Q
Eastleigh, Hampshire
03.2017 - 06.2017
- Worked on Business intelligence projects due within six months leveraging tools such as PoweBI and SQL server
- Delivered actionable insights for business intelligence projects by analyzing and visualizing data with Power BI and SQL Server
- Collaborated with stakeholders to identify business requirements and design data models that supported analytics and reporting
- Developed self-service analytics solutions through Power BI, enabling stakeholders to access meaningful data visualizations
- Built and optimized data collection systems to improve data quality and statistical efficiency for customer and product datasets
- Created and enhanced customized applications by developing stored procedures, triggers, and functions, and refined data for analysis using Power Query and Power Pivot in Excel.
Data Analyst (Business Intelligence)
University of Warwick IT Services
Coventry, Coventry
08.2015 - 03.2017
- Utilising PowerBI, Excel and Access, I worked on creating dashboards and reports for a range of stakeholders to enhance the quality of data and related processes resulting in a 30% improvement in data accuracy and a 25% reduction in manual processing time..
Data Analyst
South London and Maudsley NHS Trust
London, England
07.2013 - 08.2014
- Gained in-depth knowledge of the Trust's legacy finance system using MS SQL Server, providing subject matter expertise and developing similar expertise in the SAP target system
- Authored SQL scripts, created Pivot Tables, and produced technical documentation to support data discovery, data warehouse builds, and system mapping
- Performed data profiling, cleansing, and quality rule setting to resolve data exceptions and improve data integrity for migration
- Led data mapping workshops and collaborated with multi-disciplinary teams, applying Agile methodologies to achieve project milestones and facilitate data migration
- Implemented security standards, managed data migration issues, and acted as a key point of contact, securing business buy-in and enhancing stakeholder knowledge through Agile demos.
Education
Master of Science - Computer Networks Administration And Management
University of Portsmouth
Portsmouth 09.2010 - 01.2012
Bachelor of Science - Business Information Systems
University of Portsmouth
Portsmouth 09.2007 - 06.2010
Skills
Database – Microsoft SQL Server, PostgreSQL, Azure Data Factory, Oracle database
Data Query Language – SQL, Python (Matplotlib, NumPy, Pandas), DAX
Data Visualisation - Tableau, MS Excel, Looker, Adobe Analytics
Data Governance – Collibra, Microsoft Purview
Operations Management – SharePoint, Smartsheet, Visio, JIRA, Maximo, Salesforce, Dynamics365, ServiceNow
Data Modelling – ER Studio, Erwin, Lucidchart, Sparx EA
Keen eye for detail, Excellent Communication, Data collection
Data Cleaning, Advanced Excel, ETL processes, Report Writing
Training
- BCS Foundation Certificate in Business Change, 01/2017
- DAMA-DMBOK, 04/2019
- ITIL V4 Foundation Certification, 04/2021
- Master Data Quality Manager Certification (ISO 8000 – MDQM), 04/2019
- Azure Fundamentals, 04/2018
- Office 365 Training, 04/2018
- Power BI Training, 04/2018
References
Available on request.
Timeline
Data Migration Specialist
Equifax UK
02.2022 - 02.2023
Business Intelligence Analyst
Govia Thameslink Railway
02.2019 - 02.2022
Data Governance Analyst
Tesco
08.2018 - 02.2019
Data Analyst (Migration)
UK Mail
07.2017 - 06.2018
Business Intelligence Analyst
B&Q
03.2017 - 06.2017
Data Analyst (Business Intelligence)
University of Warwick IT Services
08.2015 - 03.2017
Data Analyst
South London and Maudsley NHS Trust
07.2013 - 08.2014
Master of Science - Computer Networks Administration And Management
University of Portsmouth
09.2010 - 01.2012
Bachelor of Science - Business Information Systems
University of Portsmouth
09.2007 - 06.2010
Technical Data Analyst
Department for Environment, Food and Rural Affairs (DEFRA)
2 2023 - Current
Similar Profiles
CHIDIEBERE AGOMOCHIDIEBERE AGOMO
CATEGORY OFFICER at Department for Environment Food and Rural AffairsCATEGORY OFFICER at Department for Environment Food and Rural Affairs
Robert RobinsonRobert Robinson
Agriculture field officer at DEFRA (Rural Payments Agency)Agriculture field officer at DEFRA (Rural Payments Agency)
Charlie Benger StevensonCharlie Benger Stevenson
Technical Lead at DefraTechnical Lead at Defra
Muhammed PanjwaniMuhammed Panjwani
Warehouse Supervisor at Unichem 2005 CompanyWarehouse Supervisor at Unichem 2005 Company
Iwona SzczurIwona Szczur
Housekeeping cleaner at self employedHousekeeping cleaner at self employed