Role is to provide technical consultancy services for LSC Communications with regard to their Manhattan WMS solution.Currently undertaking an large Integration project between LSC's WMS and Pearson's Oracle EBS solution to replace existing legacy interfaces.

Worked on a comprehensive ERP migration project from iSeries to Oracle.System analysis of legacy iSeries, mapping and documenting of:• DB2 Database• Data flows• Batch Processing• System Integrations - Inbound and Outbound• AS-IS ProcessesMigration & Integration Analysis:• iSeries to Oracle Data Migration Mappings• Legacy Integration Requirements for remaining AS400 Functionality• iSeries/Oracle Integration Mapping• AS-IS/TO-BE System Integrations for Legacy and New Oracle ModulesDesign & Build:• Data Migration Database & Procedures• System Integrations• iSeries Integration & Procedure Decommissioning• Data Validation and Cleansing

Varied role providing development support and modernisation of existing applications to incorporate SQL and web functionality to provide modern interfaces to improve and streamline current processes. Role also includes management of large scale proposed changes to current business processes utilising the following methods:• As-Is mapping of current processes (Visio)• Requirements gathering from SMEs • Outlining of proposed To-Be processes• Presentation of Project Scope to Project Sponsors• Producing Technical Specifications• Issues Log management (Jira & Excel)• Programming resource managementProvided the above project support to deliver Triumphs new RMI website in accordance with new EU Type Approval legislation for Emissions and Repair & Maintenance Information for Independent Operators.

Senior Analyst directly responsible for research, development and maintenance of Pearsons UK Warehouse Management System, whilst also working as part of an international team maintaining and developing the company’s system worldwide. WMS application installed on various iSeries servers throughout the Pearson worldwide network. Part of my role was to provide remote development and support services for additional sites as and when required.Daily job entailed providing first line support for the UK based WMS application which included;Prioritising maintenance and development tasksAllocation of development and support tasks within teamResearching new solutions, methods and guidelines that may be of interest to the development/support teamDebugging complex batch processesPerformance tuning Another area of expertise has been the design, development and implementation of various inbound and outbound interfaces on the iSeries in several countries using various standards, these included;XML ASN’s from suppliersEDIFACT ASN’s to CustomersCarrier Shipment interfaces and tracking retrievalFreight Billing invoice retrieval from CarriersInvoice payment authorisation to SAPInternal Siemens system interfaces for DC automationParcel tracking web servicesSecondary role providing development and support for Pearsons European Bookmaster application.During my time at Pearson I also implemented an internal web portal on the iSeries that provided the following services;Real time planning and picking statisticsStock inventory management statisticsDaily shipping, volume and value enquiriesOrder shipment details and tracking dataData extract and report formattingThe web portal uses native iSeries programming, including CGIDEV2, for back end functionality and HTML, CSS, Javascript, Ajax and FusionCharts for the front end. The web pages are served from the IFS via Apache HTTP server on the iSeries.