PROFESSIONAL SUMMARY:

• Confidential has more than 10 years of experience in consulting, technical and functional areas.
• Expert in Oracle Transportation Management with 9 years of experience in Confidential integration, analysis, requirement gathering, solution design, configuration, testing, branding, implementation, enhancements and application support of various OTM projects.
• Also has knowledge in Java/J2EE and different Oracle applications.
• Implementation of various projects in different versions of OTM (4.5, 5.0, 5.5 and 6.3) in many countries globally.
• Experience in different roles such as Business Analyst, Project Lead, Onsite Coordinator, Support Analyst and offshore lead.
• Designed generic Lead Logistics Provider (LLP) framework an end - to-end TMS solution for Confidential to onboard various customers using generic setup.
• Worked on different OTM projects involving full cycle implementation, Confidential, B2B integration, branding, enhancements and maintenance.
• Project analysis and requirement gathering for many OTM projects.
• Preparation of Solution Design Specification (SDS) based on the project requirements.
• Worked as Integration Analyst in many projects developing mapping specifications for OTM, integrating with Oracle EBS, Kewill Flagship, CASS, RPMS, various LSPs, Confidential legacy and different end-client systems.
• Preparation of test plan, test scripts and execution of testing scenarios for unit and end-to-end testing.
• Worked on Order Management, Transportation Request Management, Shipment Planning, Rate Management, Shipment Booking Confirmation, Financials, Exception Management and Agent Configurations.
• Creation of Report Specifications for report development.
• POC and User training to business users.
• Good knowledge of PL/SQL, JSPX, XML, XSL and JavaScript.

TECHNICAL SKILLS:

Logistics: Oracle Transportation Management (OTM-Glog)

Databases: Oracle 9i & 10g, PL/SQL

Java, J2EE, Servlets, JSP, XML:

IDEs: TOAD, Net Beans, Websphere Application Developer

OS: UNIX, Windows 9x and XP.

Testing Tools: Win Runner, Load Runner, Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, Arizona

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 11g, SQL Developer, Altova XMLSpy.

Responsibilities:

• Gathering requirements for all modules involved and various system integrated with OTM.
• Designing Solution for all modules based on the Business Requirement Catalogue ( Confidential ).
• Preparation of mapping specification for Shipment update to capture line costs for Import shipments sent from Follownet Brazil.
• Bulk milestone upload functionality to log multiple events against PO/TR/shipments in OTM reducing manual overhead.
• Preparation of Report specification to generate scheduled TR and Shipment reports.
• Preparation of Configuration specification and user manual.
• Configuring the technical entities based on the configuration specification
• Preparation of test cases and executing the test scripts.

Confidential, Tempe, Arizona

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 11g, SQL Developer, Altova XMLSpy.

Responsibilities:

• Gathering requirements for all modules involved and various system integrated with OTM.
• Designing Solution for all modules based on the Business Requirement Catalogue ( Confidential ).
• Preparation of mapping specification for the creation of Purchase Order from MAXIMO system to OTM.
• Preparation of Shipment and shipment status mapping specification to communicate between OTM and service providers UPS 240, TOLL 214 and Confidential
• Preparation of Report specification to generate user adhoc PO Line reports.
• Preparation of Configuration specification and user manual.
• Configuring the technical entities based on the configuration specification
• Preparation of test cases and executing the test scripts.

Confidential, Tempe, Arizona

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 10g, TOAD.

Responsibilities:

• Solution designing of Settlement and Exception Management modules based on the Business Requirement Catalogue ( Confidential )
• Preparation of Configuration specification and user guide for the second phase of project.
• Configuring the technical entities based on the configuration specification
• Preparation of test cases and executing the test scripts
• Development of custom rate tool to generate rate related CSVs based on customer rate template.
• Handled multiple change requests raised by customer to upgrade business with more functionalities

Confidential

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 10g, XMLs and Altova XML Spy.

Responsibilities:

• Solution designing of all the modules of based on the Business Requirement Catalogue ( Confidential )
• Modules includes Transport Request, Shipment building, Tendering, Settlement and Exception Handling.
• Preparation of Configuration specification and guide for all the modules .
• Configuring the technical entities based on the configuration specification
• Preparation of test cases and executing the test scripts

Confidential

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 9i, XMLs and Altova XML Spy.

Responsibilities:

• Leading agent optimization project in increasing performance of the system.
• Project Plan creation for the agent optimization.
• Creation of business cases and options for the agent optimization.
• Providing support and resolution to all issues that are raised by customers.

Confidential, Davidson, North Carolina

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 9i, XMLs, Altova XML Spy and EBS, Oracle BPEL.

Responsibilities:

• Preparation of Delivery mapping specification for the creation of order release from Oracle Order Management and for Trip creation from OTM.
• Preparation of Voucher and Accrual mapping specification for making invoice entry in Oracle AP from OTM.
• Preparation of Shipment mapping specification for re-rating of parcel shipments from Kewill.
• Preparation of Shipment and invoice mapping specification for making invoice entry in OTM from CASS (third bill to party).
• Preparation of Tender, invoice and shipment status mapping specification to communicate between OTM and service providers.
• Documentation of MD50 and MD70 containing integration and technical details of development.
• Reviewing all mapping specifications of the project.
• Coordination with BPEL development team explaining business logics, resolving issues faced during development.
• Configuration of Agents, external systems and outxmlprofiles related to Shipments, Invoices and Vouchers.
• Preparation of test cases for Integration Unit and end-to-end testing
• Execution of test scripts of Unit and End-to-End Integration testing.

Confidential, Green Bay, Wisconsin

Technologies Used: Oracle Transportation Management (OTM-Glog), Oracle 9i

Responsibilities:

• Handled financial module in OTM of both Account Payables and Account Receivables.
• Technical design in OTM for both AP and AR.
• Creation of BR-100 for both Account Payables and Receivables and consolidation of all technical specifications.
• Configuration of Agents related to Shipments, Invoices and Vouchers.
• Configurations of User Roles, preferences, assign functions and association.

Confidential

Technologies Used: Oracle Transportation Management (OTM-Glog), TOAD 7.5, Oracle 9i, Microsoft Visual Source Safe 6.0, XMLs and Altova XML Spy.

Responsibilities:

• Preparation of High Level Solution Design document (HLD) based on Business Requirement Specification ( Confidential )
• Preparation of Integration Mapping Specification to map the message formats like EDIFACT and ANSI to XML
• Preparation of Report Specifications.
• Configuration of Agents, master data like locations, etc,.
• Configurations of User levels, preferences, assign functions and association.
• Configuration of Screen sets and menus.
• Customization of screen sets by modifying related XSLs.
• Preparation of Test Scripts and Test cases for Unit and End-to-End Testing.
• Execution of all test cases as per the Test Specification document.
• Onboarding all the carriers of the customer to OTM.

Confidential

Technologies Used: Oracle Transportation Management (OTM-Glog), XML, XSL, TOAD 9, Oracle 9i, Microsoft Visual Source Safe 6.0, Windows XP.

Responsibilities:

• Customization of screens by modifying XSLs.
• Configuration of Agents and master data like locations, saved queries, etc,.
• Configurations of User levels, preferences, assign functions and their association.
• Configuration of Screen sets and menus.
• Creation of Report Specifications based on the customer requirements
• Preparation of Test Scripts and Test cases for Unit and End-to-End Testing.
• Execution of all test cases as per the Test Specification document.

Confidential

Technologies Used: Oracle Transportation Management (OTM-Glog), XML, XSL, TOAD 9, Oracle 9i, Microsoft Visual Source Safe 6.0, Windows XP.

Responsibilities:

• Impact analysis of various business objects in version 5.0 that needs to be moved to version 5.5
• Analyzing Database structure of both 5.0 and 5.5
• Review of all the functionalities migrated to 5.5.
• Creation of Test Scripts and responsible for executing the test plans.
• Execution of all test cases during the functionality testing.
• Customizing the standard look and feel of the application using JSPx and XSLs.