Velavan Alagirisamy Email & Phone Number

Greater Chicago Area

Lisle,Il, Usa

Program : CornerStone, Project :DNA (Drirect Ship New Approach)Worked as Technical architect on Order to Cash Drop Ship Project. This project is a phased approach to replace the existing Order Entry system (TOLAS), First phase is to bring only the drop ship orders into Oracle. Oracle will perform all actions required to support these sales order lines include customer invoicing, purchasing, vendor payments. o Designed and Developed inbound interfaces using SOA. Involved in design and mapping of EBO for Supplier from People soft, Item from PIM and Customer from Legacy system. Designed and Developed API’s for provider ABCS to call from SOA when these source systems publish.o Designed and outbound interfaces of AR invoice, Payable Invoice, Shipment information and commercial invoice information to various downstream systems. Designed and mapped the EBO’s for these integrations. Developed API’s for Requestor ABCS to call from SOA. Used the Business event from Oracle and apps adaptor from SOA to publish these information to downstream systems.o Automatic Debit Memo: Designed and developed a custom process to create automatic debit memos for Quantity variance and Price variance Holds in Payable invoices.o RMA Automation: Designed and developed custom process to Validate the RMA/Claim orders, create Logical receipt from dealer(customer), Logical Return to Supplier and Finally Close the PO Line for Receiving. Also Generate Debit Memo to Supplier if applicable.o Involved in various other ongoing Business process efficiency improvement projects.

Downers Grove, Il, Usa

Program : CornerStone, Project :PIMWorked as Solution architect on Navistar’s Parts MDM Solution. This project is to consolidate & maintain unique, complete and accurate master product information. Distribute this information as a single source of truth to all operational and analytical applications used by the Navistar Parts group. o Involved in defining the Application Architecture and Infrastructure Requirements. Proposing Conceptual solution, deciding structural and behavioral components of the proposed solution.o PDQ(Product Data Quality): Designed DSA’s for the Various inbound data Sources, Designed interfaces using PIM Connector. Designed and Developed conversion program to convert 3.2 million parts with 190 User Defined attributes.o PIM published item, cross references, related item information to multiple systems, involved in EBO design and mapping for SOA Layer. Designed and developed provider ABCS from PIM to SOA.o Setup the Integrated SOA Gateway to use getItemInformation web service. Designed and developed an PLSQL extension to send the additional item information through SOA.o Designed and Developed a batch publication program at the various stages of NIR(New Item request) and Change order process.

Master'S Degree, Mathematics

Post Graduate, Post Graduate Diploma In Computer Applications