Matthew Andrew

Experienced data analyst with over ten years of expertise in data analysis, reporting, and IT skills. Highly proficient in Microsoft Excel including advanced functions, with a strong ability to manage data accuracy and develop reporting solutions. Proven capacity to handle multiple priorities, troubleshoot data issues, and support pension and payroll data administration.

Pensions Administrator (Home based remote) at Education Personnel Management Ltd (2025-10 – 2026-04)

• Ownership of allocated LGPS funds monthly and annual pension reporting
• Interrogating report data to ensure accuracy
• Develop innovative and automated reporting with LGPS funds
• Process and verify pension data for starters, leavers, opt out, opt ins, transfers, retirements
• Support Payroll colleagues with pension administration and portal usage for schools
• Support Auto enrolment and re-enrolment processes for schools by answering queries
• Responsible for monthly MDC, MCR reporting of Teachers Pensions service data
• Maintain pension records and ensure data accuracy in payroll and pensions portals (i-Connect, TPS portal, LGPS submissions)
• Attend regular team meetings and training to stay updated on policies and guidance

Pensions administrator (Home based remote) at IRIS Software Group (2025-04 – 2025-06)

• Collate MCR Monthly contribution reconciliation data returns for schools via payroll provider
• Upload monthly data into TPS Portal ensuring accuracy and timely submission
• Manage data ensuring fully validated, accurate information
• Resolve all queries with schools before data upload to TPS Portal
• Develop and maintain solid working relationships with schools, payroll providers, Council departments, and external agencies
• Resolve data queries from Teachers’ Pensions ensuring accurate teaching staff data
• Process starters and leavers forms for Local Government Pension Scheme (LGPS)
• Perform LGPS pensions calculations and data entry
• Communicate promptly and professionally with clients and scheme members via letter, email, and telephone

DB Pensions Data Specialist (Temp) at Cintra HR & Payroll Services (2023-11 – 2025-04)

• Run and specify data extracts from IRIS Payrite payroll system including bespoke reports
• Transform extracted data into required formats and structures
• Specify and perform data uploads to administration system
• Perform bulk Excel calculations
• Build and enhance Excel templates and macros for regular tasks
• Process joiners, leavers, deaths, retirements, EOYC, MCR and manual calculations
• Respond to enquiries via telephone, email, and pensions inbox
• Manipulate payroll data for pension upload forms ensuring data accuracy and integrity
• Collate data for missing starter and leaver info for LGPS submission
• Troubleshoot data issues and recommend improvements
• Liaise with third parties including LPPA, LGPS and other pension providers

MI Coordinator at Shaw Trust Midlands & Yorkshire (2023-04 – 2023-10)

• Transfer data into systems database for analysis and auditing
• Monitor data completeness ensuring timely receipt from all sources
• Identify data gaps and request missing data from relevant sources
• Review and perform quality checks on data
• Assist with daily office operations and ad hoc tasks as required

Data Analyst (Temporary contract) at Central Bedfordshire Council (2022-03 – 2022-05)

• Perform data entry into databases
• Analyze data producing tables and graphs for presentation
• Write concise and insightful reports and presentations
• Provide communication, consultation, and equality support to council
• Enhance brand and reputation of organisation and its services
• Provide intelligence about communities and customers through data analysis to support service development

Bank Systems Analyst (Part-Time) at Sue Ryder (2019-03 – 2022-02)

• Provide user administration and support for hospice clinical systems
• Deliver process improvements in use and deployment of clinical IT systems
• Assist clinical teams and senior management to develop data capturing and reporting templates based on service needs

Clerical Coordinator (Temporary contract) at Medical Records Library (2020-11 – 2023-04)

• Manage multiple clerical requests using Excel spreadsheets
• Manipulate data to aid medical records assistants
• Create lists to locate medical records in the library
• Liaise with management to develop processes to organise medical library

Performance Projects Officer (Temporary contract) at Bedford Brough Council (2018-02 – 2018-05)

• Support Senior Performance Projects Officer
• Support directorates in implementing effective performance management frameworks
• Manipulate large data sets using pivot tables, vlookups, and Sumif for performance monitoring reports
• Maintain, validate, and update contextualised data across performance management databases: Synergy, LiquidLogic and AzeusCare
• Focus especially on Early Intervention and Safeguarding (EIS)

Bursary and Fees Administrator (Temporary contract) at Bedford College (2017-11 – 2018-02)

• Check validity of applications per College guidance and policy
• Update student databases with allocated awards
• Review student applications against Bedfordshire Bursaries criteria
• Allocate appropriate funding including approvals, manual awards, re-assessments, cancellations, and reinstatements

Administrator (Temporary contract) at ECL Civil engineering (2017-10 – 2017-11)

• Perform basic general administrative tasks
• Filing and matching invoices

HR Data Analyst (Temporary contract) at Bedford College (2016-04 – 2017-05)

Administrator/Data Analyst (Temporary contract) at Morrison Utility Services (2016-04 – 2017-05)

• Organise provision of new and return of old vehicles in timely manner considering lead times
• Ensure drivers have correct vehicle documents issued per company policy
• Update records accurately and timely including annual Drivers Licence audits and vehicle management reports
• Use pivot tables and vlookups to summarise information

HR Data Analyst (Maternity contract) at Bedford College (2015-05 – 2016-04)

• Assist in development and implementation of Access SelectHR systems including online recruitment, training, development, appraisal modules
• Troubleshoot and liaise with IT Services
• Maintain Access Select recording and reporting functions for maximal use and accuracy
• Produce suite of HR and college reports via Crystal reporting tool and Access SelectHR
• Produce monthly standard reports and circulation lists including course manager lists
• Manipulate large data sets using pivot tables, vlookups, sumproduct, Sumif, and countif for payroll reconciliation
• Provide mass data reports on HR statistics including starters, leavers, sickness absence, diversity, ethnic origin, gender, pay scales, turnover, FTE, and headcount analysis

Data Analyst at Horizon Health Choices Ltd (2014-09 – 2015-05)

• Perform data analysis duties for management and staff regarding internal systems
• Data cleansing and extract data from SystmOne database into MS Excel
• Manipulate large datasets using pivot tables, vlookups, sumproduct, Sumif, and countif
• Develop new reports and set up daily, weekly, and monthly batch reports
• Analyze management reports on First, Follow-up and telephone appointments, did not attend, referrals, injections, ENT, discharge, etc.

Business Data Analyst at Morrison Utility Services (2011-05 – 2014-09)

• Create monthly, quarterly, and annual reports using internal software and Excel/MS Office tools
• Liaise with operational management to ensure accurate forecasting and monthly review and analysis
• Design and develop KPIs for accurate and meaningful organisational performance measurement
• Report performance to Executive management
• Assist production of monthly forecasting and KPI reports

Database Administrator at Meller Designs (2009-11 – 2011-05)

• Maintain and update packaging waste database
• Liaise with relevant parts of business and suppliers
• Collate and issue annual packaging waste data submission forms for approval

Data Analyst/Technical Support Assistant (Career Change) at Mouchel Group (2002-07 – 2009-11)

• Develop and maintain reporting systems and databases for property contract delivery
• Coordinate information for Project Teams
• Liaise regularly with managers to meet reporting needs
• Provide reports using SAP HR MI, Crystal Reports, Oracle BI SQL Query Builder, Oracle BI Discoverer Plus, MS Access/SQL, MS Excel, and MS Visio
• Cleanse data for efficient, accurate, and streamlined reporting
• Develop MS Access based reporting solutions using Excel VB code for complex data manipulation
• Manipulate large datasets using pivot tables, vlookups, sumproduct, Sumif, and countif for report formatting
• Assist in producing annual reports for clients and data retrieval from relevant sources

O 'Level – St Johns RC School (1978 – 1984)

City & Guilds NVQ – New Age Training Ltd. (1996 – 1997)

City & Guilds – Bedford College (1996 – 1997)