john mcgregor

The role included the personal involvement in projects, adherence to the design and change lifecycles, defining requirements, ownership of design products and a lead role in investigating and proposing robust solutions for business improvement with responsibilities around the Breach process. Introduced a standard Gap Analysis documentation, as well as Use Case and design specification templates to be used across the project team to help standardise feedback.

Responsible for working closely with the Cloud Adoption & Transformation Project Manager, to support on all aspects of the migration into a new data ecosystem. Working closely with all Customers Data Owners, their key business stakeholders, Customers Data Office, Enterprise IT services and other work streams within the Customers Data Programme ensuring that business activities and processes are migrated to align with the new data governance processes and to leverage the technology platform so that the migration is planned and implemented with minimal disruption to BAU business activities.

Delivered significant changes and improvements across the Change Control project within a Legal Department, analysing & documented legacy reporting systems, establishing data ownership & managing the development and transfer to new network systems whilst successfully developing new reporting solutions, managing UAT and successful delivery to clients.

The role was with an organisation that specifically looked at recovering monies for large organisations and in my role I was not only responsible for Analysing large amount of hard/soft data in order to identify unrecovered client assets. In the role I recovered over £250k of the £1m pa. unit target but through my analysis also devised a method that identifying unrecovered monies previously thought unaccountable, this was developed into a tool that was then used throughout the entire organisation with significant benefits.

* The role mainly revolves around the engagement with clients across the business gathering and analysing requirements around KPI/MI metrics, ensuring the design of new services are compliant and able to report not only Department goals but also monitor and report on customer experience. * Gap designing metrics and KPIs * Managing, producing or working with performance frameworks; * Communication and presentation of key ideas and concepts * Teamworking across multiple business disciplines and Departments * Facilitating workshops and meetings with stakeholders * Developing data design structures and specification documents * Producing User stories and technical specification documents for first phase implementation projects.

Successful implementation of activities as part of the HR & Payroll transformation and data program development (SAP) including requirements gathering, data cleansing, analysis, mapping and migration to new Success Factors solution, introduced new MI tables, reports, templates & dashboards and UAT test scripts all within the Project deadlines.

* Ensuring the Data recorded by the CRC’s was timely and accurate before further analysis. * Analysis of the data once loaded on to the Central hub for any errors or emissions. * Additional Analysis of the data to ensure performance targets are met. * Stakeholder Manager for the entire Northern region which consists of five this involved Contract Management, Defect Management, Process and Performance Analysis. * The creation and implementation of Risk management log and additional Risk analysis for senior stakeholders. * Developing data/reporting validation tools with the units Operational Assurance (OA) teams to investigate the accuracy and validity of key reporting and diversity data * Delivered Business case for the creation of an information portal for OA audit managers and Contract Managers. * Key Skills - Stakeholder Management, MS Excel (Advanced)l, MS Access, Identifying, managing and escalating risks. Evaluation of reporting efficiencies, present and future needs.

* Developed tools to meet the demanding analytical needs and operational metrics. * Worked with key stakeholders and project lead to map statutory and future reporting needs. * Developed Workforce planning reporting tools and technical guidance notes. * Re-structured HR monthly and Quarterly reports and developed reporting Dashboards. * Developed and introduced a simplified and automated process for the production of statutory information, making significant resource savings to the HR reporting unit. * Delivered on-site Excel training sessions with senior team members after identifying skills gap. * Key Skills - Evaluation of needs against statutory requirements, Stakeholder Management, MS Excel (Advanced), Business Objects reporting interface.

* Developed and delivered new HR reporting dashboards * Developed and delivered new reporting tools * Disseminated and rebuilt contractors reporting tool to remove errors and create a simplified and effective tool. * Worked closely with the HR Director to determine MI desired and needs in order to deliver clear, concise and accurate reporting. * Analysis lead to a successful re-negotiation of contract resulting in a potential future annual saving for the organisation in excess of £300,000. * Highlighted overspend of VAT to contractors of £80k * Key Skills - Evaluation of needs against statutory requirements, Stakeholder Management, MS Excel (Advanced), Business Objects reporting interface, Evidence gathering and Analysis, interpreting off the shelf HR and Payroll database system.

Engaged with HR directors to deliver data program development (Oracle) & standard reporting packs (BI), implemented a ‘Work Winning’ data warehouse, developed and conducted HR to Payroll audits across 8 different systems to ensure data quality and integrity across multiple systems, mapped and modeled data requirements, delivered extensive Excel reports/tools (VBA) validated, cleansed, maintained and prepared for the phased HR data migration to Oracle R12.

Responsible for the modeling and mapping of all HR & Payroll data throughout the migration developing & testing of Staff HR system for performance, absence monitoring and reporting, developed expenses & overtime claims tools ensuring relevant data/client dependencies and risks were fully accounted and managed throughout an Agile development and delivery as well as delivering on-site Excel training.

* Developed the Information Assurance policy in accordance to contractual and legal compliance. * Developed Assurance related policies such a Security Markings, Achieving of sensitive documentation and Information handling. * Developed and released various fact sheets relating to the Assurance policy and associated policies for staff use. * Assisted in the completion of Statement of Compliance. * Bespoke reporting including an in-depth analysis of client density across the entire demographic to determine current offices locations best met Service Users needs. * Supported the Senior Assurance manager in there day to day tasks. * Helped identify and initiate key responsibilities within the organisation that were associated with Information Assurance. * Key Skills - Stakeholder Management, Imparting Project discipline knowledge and disciplines across the unit, MS Excel (Advanced), Business Objects reporting interface