Outline of Responsibilities
• Supporting the Project Subject Matter Expert with detailed and in depth data analysis
• Cleaning and validating large sets of data prior to data loading and solving any data discrepancies
• Modelling spreadsheets using advanced Excel formulas and VBA
• Extracting data from various sources using Business Objects and SQL queries
• Developing automated reports in Excel and generating any ad-hoc reports when requested
• Producing standard operating procedures and user guides using Word, Visio and PowerPoint

Outline of Responsibilities
• Validating track asset data in line with the agreed template using Excel and Access
• Verifying large datasets using advanced Excel formulas
• Mapping new to old MIMS / Ellipse hierarchy changes
• Undertaking crucial format and content checks prior to system loading

Outline of Responsibilities
• Analysing the data trends using MIMS, Excel and Access
• Extracting data from MIMS to produce performance reports
• Ensuring data quality and integrity throughout large datasets
• Liaising with the track engineers to rectify any data issues
• Producing KPI reports for the management

Outline of Responsibilities
• Developing and maintaining various automated databases using Access and VBA
• Manipulating and analysing project data to produce various reports in Access
• Extracting data from in-house systems for data manipulation and analysis purposes
• Creating and updating the IT project plans using MS Project
• Inputting resource and cost data using MS Project

Outline of Responsibilities
• Validating and cleansing large datasets using primarily Excel and Access
• Interrogating the MIMS / Ellipse database to produce reports for comparison with the legacy data
• Extracting datasets from the MIMS / Ellipse database for comparison with track inspections
• Providing training and technical help for new MIMS / Ellipse users

Various jobs working for J Sainsbury plc and then the Occupational Pensions Regulatory Authority in Brighton