Analytics & Reporting Lead

• Dec 2022 - Present

• Provide analytics through end-to-end product lifecycle, supporting product releases, growth & retention campaigns, and end of service life product reviews• Identify opportunities for increasing revenue or saving costs resulting from own project work• Support the sales and product teams with analytics knowledge and demonstrations as required• Build and maintain global analytics dashboards within Power BI and Excel VBA• Create time series forecasting models to predict growth using Python and popular libraries• Create business flow diagrams and documentation• Manage time between additional time zones including Australia and America• Evaluate process inefficiencies to recommend and build optimisations• Utilise Power Platform including Power Apps, Power Automate and Power BI• Mentoring colleagues sharing best practices and upskilling with various BI packages• Communicate with all levels of organisation and third parties, discussing complex ideas and analysis with non-technical language, making recommendations easy to understand Show less

Data Analyst

• Apr 2021 - Dec 2022

System and MI Analyst

• Oct 2018 - Feb 2021

• Implementation, development, and general maintenance of Cornerstone and other HRIS. • Create and maintain modellers using VBA and advanced excel formulas and functions. • Development of new dashboards using Power BI for presentation and ETL. • Migrate standard reports to Power BI for enhanced automation and security. • Migrate training data from satellite systems into master with VBA and Power BI/ DAX • Interpreting HR/ Payroll information to produce reports, including trend analysis, assessing data, suggesting recommendations and assumptions. • Maintain SharePoint security roles and link with Power BI for latest report sources. • Use Python and VBA to automate processes. • Update Cornerstone front page with latest company information using HTML/CSS. • Work with India and other global partners to ensure effective system maintenance. • Proactively monitor/audit data entry into the HR systems within the HR Service Centre • Plan and organise own workload undertaking numerous tasks operating to tight deadlines. • Build and manage relationships with key stakeholders including directors and other HRBPs. • Received multiple company recognition awards for Excellence and Curiosity. Show less

Workforce Information Analyst

• Sep 2016 - Oct 2018

• Collect, collate and handle complex numerical data producing statistical reports, trends and analysis • Collaborating with managers to assist their understanding of the implications shown in findings. • Create monthly KPI reports for the Trust and external organisations, as well as ad-hoc requests. • Recognise and analyse variances on period budgets, targets and rolling periods. • Increase productivity of Excel trackers using complex formula, functions and macros. • Undertake reconciliation with Finance Department to ensure the accuracy of data. • Effective system administration ensuring safe and secure access to the Trust’s ERP (Oracle). • Assist with implementation of GDPR with regards to asset registers, information sharing and risk. Show less

Senior Finance Administrator

• Jan 2013 - Sep 2016

• Accounts Receivable team member; the sole point of contact for large DWP and ESF contracts. • Submit monthly journals for accruals, prepayments, recharges and reversals. • Assist with Nominal Ledger Analysis leading to preparation of Management Accounts. • Month end analysis including budget and forecast variance, profitability and exception reporting. • Credit Control with frequent Aged Debt analysis relevant to monthly/ quarterly deadlines. • Raise, input and post invoices using Microsoft Excel, Dynamics AX, Sage and CRM. • Check compliance against strict external regulations and internal controls. • Proactively monitor, evaluate and report to maximise claims comparing with budget and forecasts. • Assist with audits and investigations; latest audit showed a 100% compliance. • Create and maintain complex Excel trackers that form the basis of key department targets. • Input vast amounts of confidential information into online bespoke ERP (Oracle and CogniSoft). • Streamline processes using efficient defaults, automated Excel templates and pivot tables. • Bank and subcontractor reconciliation. • Work closely with other departments to deal with potential claims that are initially non-compliant. • Run variety of reports and Advanced Finds for further analysis and investigation. • Host weekly meetings and Q&A to discuss escalated issues and promote good working practices. Show less