CV

April 2010 - Present                     Xerox                                  Ireland/Holland

IT Consultant  -- Oracle ERP

Cureent role involves designing Technical approach/solution/specifications liasing with the Functional consultant adhering to the Business needs.

Involvement also including following the full software development cycle which includes     version control,testing,migrations and implementation of the solution.

Worked on developing an outgoing interface between AP Payment Batches information to   an external system with EDIFACT format conforming to an in-between GENTRAN system.

In this project I make use of Oracle Object-Relational features to create a multi-dimentional Oracle table having numerous Oracle Object types to hold the AP Payment/Invoice data to be used to create the flat file to be FTPied.

Developed and implemented another interface which involved an extract of various infomation  from from Inventory such as Items/BOMs(using BOM APIs)/On-Hand etc and also information from requisitions/POs, OM and INV.

Developed the Direct Shipment/In Country Procurement Interface project and also an outgoing Interface with PTO/BOM Items information,Sales Orders information interfaced to external systems for future Supply Planning.

Direct Ship involves creating requisition on all eligible Sales Orders which then auto-creates POs by calling auto-create APIs and all PO/SOs are brought in-line with their Dates and quantities using SO/PO update APIs. PO approval is also managed.

Currently finishing work on total automation of PO receipts and automatic Pick Release/Ship Confirm along with Auto Invoice with all validations required along with automating reservations for both serial controlled and non serialized items.

This project a complete Supply chain solution starting from Sales Orders being created from a feed from an external system to automatic creation of Requisitions/POs as Approved or Incomplete as neccessary just a Oracle standard Drop Shipments along with a custom Oracle form mimicking the standard Oracle's Additional Line Information screen where one can see the drop ship information.

This futher goes onto creating reservation for the SOs related to POs based on an incoming feed with PO information. This process then proceeeds to create Move Orders/transact them/split lines if serialised and do the assignment and Pick Release and Ship Confirm and also submit the trip stop to balance the Inventory and bring the SO to status Interfaced.

Both the above project cover the larger aspect of total Supply Chain Management for Xerox.

Using Docushare as the document repository and Serana (Dimensions) as Program Version Control System(PVCS).

Experience Jan 2009 - Dec 2009 De Post Belgium
IT Consultant

Worked on customising Oracle MRP Forecasting process to suit De Post's business requirements. This involves applying forecasting rules setup in the item location level and running the standard Oracle Compile Item Forecast using the standard Re-order Point Planning(ROP).
This also involves updating forecast values generated depending on the item is they are Saleable or Non-Saleable by creating a view upon the apps schema which was based on numerous Materialized Views(MVs) upon a different schema with frequent refreshes to ensure no performance problems while the users retrieves the data required transparently.

Finished a project on Non-Catelog Requisitions customisation which involved handling NCH requisitions created through iProcurement and also created a custom form to enable the Auto-Creattion of POs in Oracle. This also involved changing the CUSTOM.pll/forms Personalizations for various PO/Releases screen validations.

Finished a project on Accounts Payables(AP) VAT revisions linked to Fixed Assets(FA) which have been Retired or not retired etc and creating custom Reports. This process is made up of 4 parts.
This project included follow up and co-ordination with the business as well as maintaining issues logs and performing progress reporting. This further involved liaising with the infrastructure team and also the DBAs.
The first One-time revision which is used to Revised the VAT with a new tax pro-rata and run for a period of months. A correction invoice is created using the calling the Standard AP Import open Interface for the change in VAT amounts.
This also includes the usage of Oracle's data collection facility using database object table types efficiently collect data into custom tables for VAT revision calculations.
The Annual Revision is program is done once a year and uses data from the One Time program and also creates a correction AP Invoice.
The Ad-hoc program as the name suggests is run AD-Hoc and takes into consideration only Invoices linked to Assets which have been fully Retired and calculations based on the Retirement type used. This also retrieves Accounts Receivables (AR) TAX line information for certain calculation purposes.
The last program is a complex Oracle report based on all of the above for reporting purposes.
All of the above use a Ref Cursor for dynamically passing the query and headings to create a spreadsheet as an output which is sent to the user by using mutt facility in UNIX.
The above programs are a mixture of Oracle reports,PL/SQL packages,views and database object types.
Also automated Item category assignment using the open Interface with data being supplied
as a flat file. Worked on changing custom Oracle Forms as well.

June 2008 - Dec 2008 AtosOrigin Belgium
IT Consultant
Finished a Project developing the Automated Debt Collection Process using
Oracle Forms 6i, PL/SQL packages mostly in AR, facilitating the company to collect outstanding debts from customers. This also involves updating Customer Profile etc using HZ public APIs.
Development of an PL/SQL OM HTML Report called from the OM Work Flow Notification screen. This involves htf calls to generate the HTML document using Writetoclob functions.
Also involved numerous support work involving Business Events and Install Base(IB) contract creation/updation using APIs.
Worked on changes to CRM e-Business Centre/Service Requests screens for Customer Interactions recording defining Results/Outcomes and Reasons.
Worked on a Performance project which involves purging redundant Workflow activities/Business Events by using WF APIs to abort these activities and then calling the Oracle WF Purge program to purge these cancelled Workflows.
I am developing a process to Purge redundant message queues in the ASO_ORDER_FEEDBACK_T queue table by de-queuing the ones we have identified as too old or not necessary, this also involved using many ASO APIs and also identifying Orders with or without IB and contract entries etc.
Using Mercury Quality centre to track defects and solutions and test plans for this performance project.
Using HP OpenView for problem/changes tracking for support/installation. Work Orders and CVS for Version control .

April 2008 - June 2008 Roche/Ventana Medical Systems Strasbourg
IT Consultant
Role as a Team Leader liaising between the Business/Project Manager and the team of 3 others people. Managing the project, organizing meetings/minutes and acting as a go-between the project manager and the business and the team,
Involved in a Hybrid Technical/Functional role integrating external SAP system to Oracle Applications 11i. This role requires Drop Shipment setups which includes shipping defaulting rules,external line processing,PTO item processing ,auto approved PO creation etc.
This process is used to create Outbound EDI PO and Inbound EDI ASNs using the EDI gateway to interface with the external systems. Normal shipping information is also exchanged using the EDI Gateway. This involves setting up of Trading Partners/suppliers,transaction file format setups etc.
Also involved in customizing Oracle Install Base information using CSI public APIs and also issuing out Inventory using custom code.
Using Purchasing Document Open Interface(PDOI) to create Quotations and adding items in them and also adding these items to the Approved Supplier Lists(ASL). These are used in automating the PO approval/creation in the Drop Ship process.

July 2006 - January 2008 De Post Belgium
IT Consultant
Role mostly Logistics,Manufacturing,INV,OM,PO Etc working on Oracle Applications 11i (11.5.10).Functional role on scale 1 to 10 -- 6, Technical Role - 8 to 9.

Recent Interfaces include from flat file supplied to validating and inserting into Standard PO open interface tables and calling the Standard PO import to create approved PO and then receiving against the PO by inserting into the ROI tables and calling the receiving Processor.
Further changes made to the CUSTOM.pll to enable to change the LOVon the control section of the standard PO screens.
Created Interface to automatically create Approved Supplier List(ASL) from flat file which also included a Custom form to make corrections and re-submitting the Interface.
Developed Interfaces from Oracle to/from external Red Priarie WMS system to interface information between the two for all Items,Orders and Inventory Transactions ,PO Creation from flat file and receiving against PO under inspection or otherwise acnd Automatic Ship Confirm using Oracle APIs.
Completed software development on the "Closed Loop" Supply Chain project.
The objective of this project was to syncronize all Logistics operations across different systems from mutiple post stations into Oracle Applications.
This involved creation of PO Requsitions in Oracle from a flat file delivered from internal customer through the Requisition Interface.Once the Requestion has been converted to a Sales Order an interface was created to get required information when the Sales Order has been shipped or cancelled and a flat file is generated to be send to the user.

This project also involved RMA creation from information supplied in a flat file and
also all Inventory Transactions from across all post stations were interfaced into Oracle which involved automatic creation of Material Transactions (Issues,Receipts,Interorg Shipments) in Oracle by calling the Transaction worker through PL/SQL.

This project also required a back out plan/programs to reverse all of the above.

Completed multiple scripts for the DE Post which included all Onhand Quantity including all Issue Transactions ,Receipt Transactions in week by week buckets for a whole year. Daily Receipt information were also gathered.

Customised AR/AP Customer Refunds/Unrelated Payments which involved multiple Oracle forms, Forms Personalization for customising seeded AR Transactions/Receipts screens. Oracle Reports were generated using XML Publisher.

Numerous Performance tuning for Custom Oracle Reports, PL/SQL.

All of the above were done adhering to strict coding standards, version control using SVN and install files which held UNIX checksums and ldt files downloaded using FNDLOAD.

December 2000 - July 2006 HDS Ltd Stoke Poges, Bucks
Information Analyst/Engineer
? Involved in a support and development role for HDS which involved a Technical and Functional role with Oracle Inventory/Order management/Supply Chain/Purchasing/Financial/Workflows/Forms/Reports/High Jump Bar-coding/Loftware printing applications.. My role also involves Month-End support and helping with Inventory/OM Re-concilations, Inter-Company Invoicing etc.
? Completed Technical development for Traceability Project for HDS which involved Conversion of Non-serialized Spare parts to Serialized Spare parts,automatic issue/receving of Spare parts to and from the European Distribution Centre(EDC) of HDS by a bespoke concurrent program using Oracle APIs. This also involves of receiving new Spare Parts from the factory in Japan in the form of a flat file which is interfaced into our Oracle Applications system before the actual parts physically reach the EDC. Also automating Serailised Oracle Cycle Count through the bar-code gun at the warehouse.This development was done using Hijump Bar-coding Software. Creating Custom Defaulting Rules for Order Line - Subinventory based on a DFF. Many Oracle Forms/Reports developed or changed.
? Completed a HRMS Personnel Requisition project which is a bespoke new process which automates the current manual process of hiring new personnel for HDS. This involves a new Oracle Workflow Process and a customised Self Service HTML/PLSQL Form which records the Requisition data and also kicks off a Business Event which runs the workflow. This notifies the approvers defined in the set-up asking for their approval and also notifies HR of the progrees of the approval status. Javascripts and HTML were also used to create this Self Service Oracle form.
? Completed a Profit After Tax (PAT) project which involves creating Material Transactions Accounts for the vendor owned organizations we have in the HDS European Distribution Centre (EDC).
? Successfully implemented the project which does a automatic return of defective spare parts to engineer locator sites in Oracle using custom code to do a Sub Inventory Transfer and then transacting an Account Issue to an established GL account for invoicing.
? Involved in Oracle 10.7 to 11i conversion, which successfully went live on January 2003, which included Converting Open Orders, Items, Reports, forms, PLSQL scripts etc. This also included a lot of co-ordination between the team here and in the US.
? Since been involved in developing/supporting the High Jump Bar-coding software for our distribution centre in Holland, which includes bar-code label printing (Loftware).
? Involved in developing/supporting customised Total Supply Chain Management (TSCM) project which involves automated Advanced Shipping Notice (ASN) / long term / short term supply plan from factories in Japan/France as a flat file, FTPed to our system which is then interfaced into Oracle with items being received into Intransit Sub-Inventory while adjusting demand/supply plans.
? Involved in developing HDS Bespoke Warehouse Management System (WMS) which went live in January 2004. This tracks and processes all items moved as orders or individually on pallets, packed onto boxes until they are moved to the trucks for despatch. These movements are done via the Bar-Code guns in the warehouse which runs Highjump Bar-coding Software. This involves customised code using Oracle APIs to facilitate Allocation after Pick Release Ship Confirm,Trips to interface Shipment transactions to InventoryTransactions,Move Orders etc.
? Part of the project team to enhance the bespoke HDS WMS process to accommodate HDS new product which consists of a large number of Child products with a frame. This involved simultaneously moving whole bins with multiple items. Also automated automatic conversion of Loan Orders into Sales Orders with auto-allocation. The HDS packs slips were re-designed and created new as Post-Script Oracle Reports. This customer facing document displayed most Order header information also with Item information with qty packed. HDS Bit-Map Logos were also displayed on these Pack Slips.
? Just had a Test Director 8.0 Training though haven't done any actual project testing using this tool we in HDS will be using this tool in the future.
? Been actively involved in creating Oracle Self Service Web Application pages (OSSWA) for the Warehouse Management System and also for users at the warehouse for ad-hoc reports, which can be downloaded to excel.
? All the while involved in the day-to-day Technical Support issues in the Logistics/Financial operation of HDS and using new web based Kintana/PVCS tools to maintain software integrity and standards.
? Been on 5 day Oracle Workflow training and also worked on Workflow development for HDS.
?
August 1999-December 2000 EDS UK Ltd Stoke Poges, Bucks
Information Engineer.
Working for EDS on Hitachi Data Systems (HDS) account providing technical support and development to their financial and logistic operations in Europe using Oracle Applications. Over 1 year technical experience of Oracle Applications Logistics/Financial modules (OE, IN, PO, GL, AP, AR, FA,) including Oracle Reports/Forms development and customisation in a multi-currency, multi-org environment. Regular use of Program Version Control Software (PVCS), Chain Link Apps* Integrity and Clarify Front Office 98 to maintain software standards and logs. Development and maintenance of DB triggers, stored procedures and packages
Euro Implementation: Changing the functional Currency of HDS Holland from GBP to EUR. Completed Mar-2000.
The only Technical member of the team, which to date has involved:
Conversion work:
Financial conversion for information held in partitioned tables, e.g. Vendor Sites, Customer address, Site uses.
Open AR and AP invoices, unapplied receipts and prepayments conversion.
Fixed Assets conversion through mass additions process.
Conversion testing, auditing the conversion data.
Technical project documentation, test plans and adherence to project plan.
February 1998-August 1999 EDS UK Ltd Milton Keynes, Bucks
Information Engineer.
Working mostly with Oracle Developer 2000 on RDBMS v7.3.4, developing and maintaining Forms and Reports for EDS' Oil Logistics, Accounting and Shipping product. This software supports refinery processes from the point where shipments of crude oil are ordered to the point where vessels are loaded with finished products.
My role is in development of product enhancements and support for existing versions. Our clients are at oil company head offices and refineries worldwide including Shell, Texaco, Petronas, Preem, and Petrogal, and there is regular communication to gather requirements for changes and determine solutions.
Platform: Oracle: RDBMS 7.3.4, Forms 5.0, Reports 3.0, SQL*Menu, Schema Manager 1.2.2, SQL Worksheet 1.2.2, PL/SQL 2.3.4; and Visual C++ v5
May 1997-Sep 1997 Information Management Systems (IMR) Bangalore, India
? IBM Mainframe Training (CA-Realia)
November 1996-February 1997 Brainware Pvt Ltd Bangalore, India
Software Engineer
Created a prototype software model using Oracle Developer 2000 for a Hotel Management Software system. This was used to maintain all guest information, check in/out details, all F&B information, housekeeping and room charges information processing.
Platform: Oracle: RDBMS 7.1, Forms 4.5, PL/SQL, SQL*Menu, SQL*Plus v3.1.