▪Full Life Cycle Data Migration Role - Extract/Transform/Loading of data for an Asset Backed Securitisation (ABS) project. A significant transformation of financial data from Nominal values to Discount Cash Flow values (DCF) along with corresponding changes in business procedures and processes.▪Liaised with key stakeholders in gathering data requirements, this included SMEs from the IT/Finance/Treasury Departments and 3rd Party IT Software providers.▪Data items defined in mapping database explaining data definition, data type, schema properties, mapping rules, transformations and dependencies.▪SQL extraction script written in TOAD using PL/SQL code to extract, transform and load all data items in my own schema in a test environment.▪These SQL scripts were written by the following mapping rules process - using the data dictionary/entity relationship diagrams, meeting with Legacy system SMEs and contacting the 3rd Party software provider (when required) to identify how to extract the data requirements.▪Validation - Testing the sql extraction scripts accuracy by checking the front end and sampling a few random agreements.▪Data Cleansing – checking various attributes for data quality e.g for customers checked for duplicate entries and incorrect postcodes. ▪Two way Full Volume Comparators developed to reconcile all data items from 3rd Party Software Provider and TBAC. ▪To manage the volume of mismatches, micro tested 400 agreements that were not reconciling and debugged them and re ran the comparator.▪In TOAD – Used advanced SQL queries to investigate unreconciled data attributes – followed with extensive use of Excel/Access VBA to automate effective MI/Dashboads reports of expected and actual data differences and translated into PowerPoint presentations - meetings with Business Owners organised to go through defect issues (raised in HP Quality Centre) and pursued to resolutions.▪3 phases of Dry Run Testing and Go live Cutover Implementation

▪Responsible for the Extract/Transform/Loading of data for an Asset Backed Securitisation (ABS) project - a significant transformation of data from Nominal values to Discount Cash Flow values (DCF) along with corresponding changes in business procedures and processes.▪Contributing to the daily project meeting with all key Stakeholders including Developers/ Project Managers/Senior Business Managers from various teams▪Creating and executing test scripts to ensure delivery and validation of the new DCF values.▪Extensive use of Excel/Access VBA to automate the reconciliation of expected and actual data transformations▪Extracting Data from SAP BW via the Analysis Process Designer – Developing /editing & executing when required.▪Transforming data in SQL Server 2008 running advanced queries to investigate unreconciled ABS data.▪Meetings with Business Owners to go through defect issues and resolutions▪Expertise in Excel - developing effective MI reporting and translating into PowerPoint presentations. ▪Validation/Development/Loading of ABS data into SQL Tables. Extensive Automotive of Transforming the Source Data into the correct Data type and format. ▪Strong testing techniques working within a SAP environment – highlight/escalating testing based risks & pursuing problems to conclusion▪Involved in 3 phases of Dry Run Testing and then Go live – Raising/Editing/ Closing Defects in HP Quality Centre▪Documenting all new processes and conducting workshops to handover procedures and KT to business leads.▪Exchanging functional and technical best experiences & practices with peers.▪An understanding of how data is held and structured in SharePoint 2010.

▪Responsible for managing the End to End delivery of the assigned SAP Objects – Material Master/Classification/Open Orders/Vehicle Management System (VMS)/Vehicle Inventory.▪Involved liaising with the Business customers, ABAP Developers, SAP Functional Consultants, Business Analysts and IT SMEs to understand the requirements and complete various documentations.▪Each data object in itself is a mini project and involves all aspects of the Extract, Transform and Load process. ▪Direct engagement with business managers for reconciliation as well as managing the testing phases of data loading and resolving errors that arise. ▪Deep understanding and knowledge transfer from Functional Consultants to understand the data requirement▪Deep dive into Legacy application and making sure mappings and transformations are correct▪Developed jobs in BODS – created various jobs in Business Objects Data Services to reconcile financial data from PeopleSoft and SAP for the General Ledger Migration object.▪Data Loading from BODS – running various jobs to load data at different testing phases. Using the BODS tool to transport the data, analyse and the reporting of issues arising to internal teams.▪SQL/RDBMS – Using Oracle SQL Developer to query/profile/model data from legacy systems and producing in depth analytical documents to support my SAP streams assigned.▪Automation of Reconciliation report in VBA Excel▪Using HP Quality Centre – to manage and resolve data migration defects.▪Advanced Excel – development of reports in Excel using pivot tables and vlookup/countif formulas. Training team members on how to run these reports as a back up and creating procedures.▪Recruiting New Staff – Short listing and interviewing candidates and helping with the selection process.▪Producing Trackers and effective methods to track problem areas ▪Producing Data Quality reports to drive all data cleansing resolutions

▪Responsible for ensuring that Trust Data is managed securely and loaded to the Lorenzo Regional Care product safely.▪Using and developing DM tools to transport the data, analyse and the reporting of issues arising both internally and to Trust Deployment teams.▪Experience of using relational databases and creating analytical query through SQL.▪Extensive Knowledge/experience of data migration through ETL process.▪Issue reporting and managing loaded data and reviewing/resolving error reports ▪Development of information reports and reviewing reporting metrics and data. ▪Analysing and validating data models, structures, and processes.

▪Manage all aspects of 18 week referral to treatment (RTT) monitoring and reporting within the Trust and to external agencies. Implement all new 18 weeks RTT reporting requirements.▪Responsible for the accurate and timely production of all routine and ad-hoc reports as required by all internal and external agencies (including general managers/clinicians/senior staff), presenting such reports as required in a clear concise manner.▪Attend 18 weeks RTT meetings carrying out all analysis as required. ▪Proactive role in establishing algorithms, applying definitions as appropriate and understanding their impact, and communicate these to staff at all levels, offering explanations and support where necessary.▪Support the production and validation of all information relating to patient activity and clinical information▪Support the development of information reporting by maintaining hospital based information systems and the integrity of the data structures.▪Development of information report using SQL & embedding into Excel and automating with Visual Basics.▪Production of regular weekly/monthly reports that are submitted to strategic health authorities and the Department of Health to monitor the Trust’s performance.▪Experience of using relational databases and creating advance queries on SQL.▪Data Validation and testing with upgrade of IPM system to LE2.2.

▪Extract, manipulate and present information from the Warranty system (WACS) on both a routine and ad-hoc basis to meet regular and one-off information requirements including forecasting and predicting future warranty budgets to the Finance Dept. ▪Design and use appropriate validation mechanisms and checking routines to ensure that all reports produced meet the user’s requirements. Investigate results in detail if figures appear inaccurate or are queried by report users.▪Regularly review analysis with Directors and Managers to highlight fluctuations over time through trends analysis and exception reporting.▪Automate new and existing procedures across the whole business in order to minimise time spent producing and processing information.▪Use appropriate presentation techniques to produce reports that can be understood and used by non-technical staff, and provide additional commentary to highlight issues and trends▪Produce weekly electronic finance reports on warranty and month end’s information packs to Directors and Managers▪Encourage improved data quality by highlighting areas of concern to appropriate staff, liaising actively with teams to understand and resolve data quality issues. ▪Conduct weekly spot audits on service dealers and report results to Directors and Management ▪Project Management - Supplier Recovery Project: Design & implementation of supplier recovery reporting tool onto the current warranty system: Designing a functional specification, assisting in testing/validating and supporting.

A member of the ESR Data Management Team; involved in the one of the world’s largest Oracle data migration programmes for the National Health Service.▪Organising and managing client visits ensuring that all targets and milestones are met within Project timelines▪Dealing with customer needs and requirements to ensure business objectives are met▪Defining HR Workstructures for over 20 individual NHS trusts based within UK. ▪Reviewing current Organisational set up and implementing Organisation Hierarchy using both HR & Finance Models▪Translating Legacy HR Data into required standard Oracle migration load templates▪Validating Workstructues Templates and providing error reports to customers▪Loading Templates into Oracle HRMS using internal load software, Data Loader and concurrent requests▪Determining mapping rules for key data▪An understanding of the full migration project lifecycle ▪Data Cleansing – looking at reports and resolving dirty data issues

▪Reviewed current standard reporting processes on Absence, Sickness & Overtime and re-engineered ad-hoc reporting to achieve a substantial saving.▪Development of new suite of reports for HR Management▪Identify and access relevant data sources and undertake in-depth analysis providing trend data, comparative data ▪Provide information and analytical support to Coventry PCT to support Commissioning and Operational Managers▪Management of website for Mental Health Trust▪Running accurate, analytical detailed reports, ensuring information is summarised in a clear and exact manner▪Daily maintenance of HR Data, ensuring capture in time for monthly pay runs