Cecilia Ogunleye

– Managed and validated large-scale HR datasets for 3,000+ employees during a major business acquisition, ensuring data accuracy and regulatory compliance to support reliable integration reporting. – Partnered with HR, Finance and HRBPs to align workforce and financial datasets, improving consistency between HR and Finance systems. – Supported job profiling and data-mapping activities to ensure accurate alignment of employees to job families, divisions and reporting lines. – Validated HR dashboards and underlying datasets, resolving discrepancies and reducing reporting turnaround time by 30%. – Analysed workforce cost data and reconciled headcount and financial data within HFM to support budgeting, forecasting and financial planning processes. – Designed and implemented a monthly HR Finance reconciliation process, improving financial reporting accuracy and reducing data discrepancies. – Automated recurring manual reporting processes to improve efficiency & data accuracy. – Led training on position management and data governance across five territories, improving system adoption and data accuracy.

– Analysed market trends, competitor activity and customer behaviour using SQL to support high value retailer partnerships, contributing to a six-figure revenue increase. – Analysed transaction and purchase data to identify engagement trends and campaign response patterns, informing targeting strategies for retailer campaigns. – Produced sales forecasts and performance projections to support retailer negotiations and commercial planning. – Developed and maintained Power BI dashboards providing visibility of campaign performance, revenue trends and partner activity. – Delivered ad hoc analysis identifying key drivers of customer behaviour and measuring the impact of retailer campaigns on engagement and revenue performance. – Worked closely with Sales, Retail teams and senior stakeholders to translate complex data into clear, actionable insights.

– Built and maintained Power BI and Excel dashboards analysing workforce demographics, attrition and organisational movement. – Designed and optimised star schema data models in Power BI, enabling scalable dashboards and consistent reporting across business teams. – Implemented a Workday data governance framework, improving data quality by 26%. – Conducted employee survey analysis, delivering insights that improved workplace satisfaction by 12%. – Delivered and presented quarterly People Dashboards to senior leadership providing insights that inform strategic workforce decisions. – Analysed hiring and termination trends to inform retention and recruitment strategies and advise on workforce planning. – Delivered a workforce skills analysis that enabled targeted internal training, saving £100k+ in recruitment costs. – Acted as a key liaison between data owners across multiple territories, adapting communication for varying levels of data literacy.

– Produced daily, weekly and quarterly service performance reports for internal stakeholders and NHS England. – Built performance dashboards and KPI reports for multiple directorates providing visibility of performance and trends. – Ran SQL Server queries to analyse operational and historical performance data. – Supported data quality initiatives and FOI requests, ensuring compliance with national guidelines.