Appalaraju Nimmana (“Raazu”) Contact # +1-630-***-****

adco5l@r.postjobfree.com

Having 19+ years of experience in end-to-end TMS product implementation for various large fortune 500 customers.

Having 14 years of experience in end-to-end OTM/GTM implementation for various clients, performing both FUNCTIONAL and TECHNICAL Solution Design and implementation work including integration with Oracle EBS, SAP, JD Edwards and with third party systems

Project Management and Resource Management activities, Business Analyst Role

Creating project strategic plans and executing them with teams, work experience with JIRA application.

This breadth of experience in IT and Business combined with years of comprehensive experience in OTM in both Inbound and Outbound logistics molded me into a highly capable and very versatile OTM Consultant who can take an OTM project alone and lead a team.

Analysis of customer specifications, design changes, operations performance, and recommendations of IT integration enhancements.

Involved in various implementations for OTM/GTM space for customers ranging from Retail, Manufacturing, Oil & Gas, Telecommunications Equipment Company, 3PL’s across the globe.

Having experience in Order Management, Shipment Management, Planning and Execution, Contract and Rate, Operational Planning, Fleet Management

Configurations and Setup for master data objects, Rates for various Transport modes: Truckload, LTL, Rail, Parcel, and Ocean

Setup and configuring various business scenarios, Direct shipment, Multi-stop shipment, International – Door to Door, Shuttle moves between plants & DC’s, Pool points, Cross dock, Cross dock / Pool, Intermodal movements

Implemented Organization complex network setup with Routing Network functionality for xDock, Pool Points and all other networks

Having experience in Compliance Rules & Screening, Product Classification, Restricted Party Screening, Embargo/Sanctioned Countries rules, Trade Transactions–Order Processing, Shipping & Document Management, License management, AES Filling

Integrated OTM/GTM with Oracle EBS / SAP / JDE / PC Miler / Mile-maker /SMC3 / Kewill / E2OPEN / EDI with partnering Carrier’s.

EDI Interfaces: Tender Offer (204), Tender Response (990), Invoice (210) and Shipment Status (214)

Perform OTM Upgrades for various Customers (V5.5 to V6.x)

Having experience in Agile methodology OTM implementation

Expertise in SOA/BPEL technology and Integration Solution design and development using SOA, BPEL, ESB, AIA, OSB

Extensive integration experience in OTM inbound and outbound interfaces, Web Services, XMLs and XSDs, XSL, External systems

Handled various projects in Java/J2EE technology

OTM/GTM Consultant, CES Global LLC

OTM/GTM Consultant, Associate Manager, Accenture Services Pvt Ltd

OTM/GTM Consultant, Managing Principal, Inspirage Software Solutions Pvt Ltd

OTM/GTM Consultant, Principal Consultant, Oracle Solution Services Ltd

OTM Consultant, Senior Consultant, Satyam Computer Services Ltd

Java/J2EE Technical Team Lead, Yalamanchili Software Products and Solutions

Java/J2EE Developer, Datasoft Solutions

Client : Hub Group, Oak Brook, IL

Environment : OTM 6.4.x

Role : On-Site Manager, OTM Techno Functional Consultant

Duration : May’2019 to On Going

Roles and Responsibilities:

Reporting & Management

oWeekly performance support ticking summary report present to AVP

oSprint stories performance report present to AVP at the end of the each sprint

oWork with scrum master/Business team to understand the enhancement stories

oProvide effort estimation for each story

OTM (Oracle Transportation Management) Production Support Activities:

oWork with client leads and with Managers to understand the OTM support issue tickets and work with OTM on-site/offshore team to perform the OTM production support related activities.

oOTM production support issue tickets will be monitored, organized and work with on-site/offshore team.

oHelp team to find the root cause of the issue and document it. Fix the issues with the appropriate solution.

oThe resolved issues will be tested in the lower OTM instance and will be migrated to the higher OTM instance and will be tested by QA team

oEnsure that the new functionalities and implementations, including configuration changes, are setup and migrated to production in following established release management processes

oSchedule/attend daily calls/meetings with on-site/offshore OTM team and track the status of each activity

oSchedule/attend calls/meetings with client to present the daily status of the OTM Support Activities and issue ticket status.

2. Enhancement/Development Activities:

oThe enhancement/development activities are performed with Agile methodology. The sprint will be conducted for every 2 weeks and the list of enhancements/development activities will be published in it; • Understand the business enhancements/new development requirements of OTM (functional and technical)

oAssign each development activity to the offshore team, ensure their understanding of the requirement and the activity’s completion

oAnalyze the business requirements and perform the Fit-Gap analysis and document them

o Prepare and propose solutions for the new enhancements/requirements.

oMake the detailed development activities list with priorities and work with the OTM team to implement the solution

oDemonstrate the new solution to the client and ensure that the solution has been tested and validated thoroughly

oEnsure that the new functionalities and implementations, including configuration changes, are setup and migrated to production in following established release management processes up on client’s approval

o Schedule daily call/meetings with on-site/offshore OTM team and track the status of each development activity

oAttend daily sprint call/meetings with client to present the status of each development activity

Client : Avery Dennison, Mentor, OH

Environment : OTM 6.4.x

Role : Solution Architect, OTM Techno Functional Consultant,

Duration : May’2018 to May’2019

Roles and Responsibilities:

OTM Implementation, Development activities

oEnd-to-End solution implementation in OTM, Configuring the Avery Dennison USA domestic and international routing network in OTM. Avery Dennison routing network includes USA domestic plant to plant, plant to distribution center (DC), DC to DC, plant to customer, DC to Customer, plant to cross dock, plant to international customer, cross dock to international customer, plant to pool point, cross dock to pool point etc.,

oConfiguring the complex rate and fuel surcharge setups in OTM for various service providers for different transportation modes like Truckload, Less Than Truckload, Parcel, Rail, Ocean

oSetup and configuring various business scenarios, Direct shipment, Multi-stop shipment, International – Door to Door, where client manages the primary leg only, Shuttle moves between plants & DC’s, Pool points, Cross dock, Cross dock / Pool, Intermodal movements

oScheduling the meetings / conference call with business to understand the requirements and demonstrate the proposed solutions to meet their requirements.

oDocumenting the detailed business requirements and performing the fit/gap analysis and implementing the solution in Oracle Transportation Management.

oConfiguring the master data setup in OTM such as Avery Dennison plan locations, various customer locations, item details, trailer details Design the solution to implement in Oracle Transportation Management.

oConfigure and setup the bulk plan schedule jobs for various sites, cross docks and pool points to optimize the equipment and freight cost

oDeveloping the code in automated agent workflows to execute and meet all the business requirements

oWorking with EDI / middleware team to understand and map the data elements between OTM and Carrier Systems for various business objects like EDI 204 (Tender Offer), EDI 990 (Tender Response), EDI 214 (Shipment Status)

oWork with off-shore team, assign tasks, follow up the off-shore activities, understand and provide the required guidance to off-shore team to complete the assigned activities.

oScheduling/running the daily status calls with on-site and offshore team to discuss about the status of daily activities and the project status

oCreating the test scripts for various test cases for OTM build objects and update them in Application Lifecycle Management system.

oScheduling meetings/conference calls to do knowledge transfer to the Avery Dennison functional and technical team

oParticipating in various testing life cycles with the Avery Dennison functional/super users team and working on fixing the issues raised by them.

Client : Western Digital, San Jose, CA, USA

Environment : OTM 6.4.x

Role : OTM Techno Functional Consultant

Duration : Oct’2017 to May’2018

Roles and Responsibilities:

OTM Cloud Implementation

OTM Implementation, Development activities & Support Activities

oInvolved in phase 1A and 1 B of OTM Implementation for Order Management, Shipment Management, Rate Management and Freight Settlement

oWorking with Business users and understand the requirements and provide the solution design

oAgents workflow configurations

oRates configurations and CSV preparations

oConfiguration set up’s like screen set layouts, saved queries, action checks, business monitors in OTM

oCustom Track and Trace events configurations

oBulk planning issues monitoring and fixing them

oWorkbench configuration for Control Tower Operations for exceptions monitoring

oMacro development activities for Location and Rates CSV’s

oWork with ERP team, middleware team to create mapping documents for integration interfaces

Support Activities

oKeep monitoring the status of incident tickets raised by business in the portal and take the appropriate action

oInteract with business users, understand the current issues, provide the status of the issues and development activities

oAnalyze the current issues based on business user inputs and provide the proper details to development team and get it fixed

Client : CISCO, Morrisville, NC, USA

Environment : OTM 6.4.x

Role : OTM/GTM Techno Functional Consultant

Duration : Dec’2016 to Oct’2017

Roles and Responsibilities:

OTM (Agile Methodology OTM Implementation)

OTM Implementation & Development activities

oInvolved in Order Management, Shipment Management and Rate Management workflow configurations

oUnderstanding business processes, requirement gathering, analysis, interfaces development, administration configuration activities

oConfiguration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations in OTM/GTM

oCreated Oracle Packages, Stored Procedures, Functions, and Queries using PL/SQL.

oMigrating the OTM Configurations & Setups to Next level instances

oLeveraging the current AS IS solution and see how best it can fit into Cisco Services Org

oAdopt and implement OTM based on Agile methodology

oPart of Cisco Services Org OTM implementation and help team during implementation

oOTM to EBS integration interfaces solution and design

OTM Instances readiness & Maintenance

oCo-ordinate with infra, networking and DBA team to ensure the OTM instances are upgraded and is available for the development and sub-sequent releases

oCo-ordinate with Infra discovery team and ERMO team for OTM infra releases for development & testing

Architecting the OTM H/W for infra upgrade

oUnderstand and Review the current AS IS OTM architecture and design of Cisco Manufacturing Org

oOTM Environment setup (H/w and S/w), scaling and recommendations for Cisco Services Org OTM implementation

oOTM clustering setup and recommendations

GTM

Understand and review the current import/export compliance of Cisco Manufacturing Org

Configure and setup Oracle GTM

Develop Oracle GTM solutions (POC’s) and demonstrate to client to see how best the product can leverage the import/export compliance rules and screening the Party, Transactions

Determining the License and Documentation

Client : Hub Group, Chicago, IL, USA

Environment : OTM 6.3.x

Role : Techno Functional Consultant

Duration : Aug’2016 to Dec’2016

Roles and Responsibilities:

Involve in in-house OTM support activities

Work with business users and in-house project team to understand and provide solutions to support activities

Review the support ticketing system activities

Client : Office Depot, Boca Raton, Florida, USA

Environment : OTM 6.4.x

Role : Techno Functional Consultant, Solution Architect

Duration : Mar’2016 to Aug’2016

Roles and Responsibilities:

Work with business users and in-house project team to understand and documents the requirements

Understand the AS IS workflows, design the solution and implement it

Designed and implemented a custom advanced layout of Retail Hub Workbench W/Stops to have flexibility to the user to have all the related information of Order, Order Movements, Shipments Stops along with location maps to have better route and planning

OTM - Alert Reports for Failures in OTM - 2 New Reports to Support Retail Planning

Designed and implemented of Shipment work flow changes, Duplicate Invoice work flow changes, Appointment scheduling screen changes

Appointment scheduling screen enhancements

Workflow changes for Default Equipment and mass update of equipment on a Retail Shipment

Created Oracle Packages, Stored Procedures, Functions, and Queries using PL/SQL.

Implemented purge scripts for Order Base, SAW Shipments, Release Instructions on OB and its appointments

Screens/Manager layout/Advanced Layout customizations.

BI Reports development, complex custom Hazmat BOL report development and many other report changes

Integration interface redesign / performance tuning of Tender Offer and Hazmat Items

Client : Unilever, Latin America, North America

Environment : OTM Upgrade (OTM Upgrade 6.2.5 to 6.3.5)

Role : Technical Functional Project Lead

Duration : Dec’2014 to Mar’2016

Roles and Responsibilities:

Led the setup/configuration and optimization of the Domains, Itineraries, Rates, Rate Services, Distance Engine (PCMiler), Planning Parameters, Calendars, Dispatch-Based Tendering, Workflow Parameters, Agents, Milestone Monitors, Business Monitors, Match Pay, Match Rules, Invoice Approval Rules, Allocation Rules, User Roles, VPD, VPD Predicates, VPD Contexts, User Associations, Account Policies, Access Control List (ACL), Custom Menus, Screen Sets, Manager Layouts, User Preferences, Actions, Alerts, Batch Processes including troubleshooting of Bulk Plan errors, optimizing Bulk Plan performance, and fine tuning the Planning Parameters to maximize savings..

Involved in Order Management, Shipment Management and Rate Management work flow configurations

Responsible for Project Management activities i.e. Ticket Monitoring, Weekly status Monitoring, Monthly account reviews, MOMs and Quality check.

Taking care of techno functional issues and troubleshooting of issue in day to day activities.

Work with Oracle Support for the Oracle Code Bugs, Enhancement Requests, Security issues and Performance issues.

Technically involved in

Order Configuration

oNeed to palletize the order base on the locations accepting the mixed freight or not

oLocations accepting a particular kind of pallet

oRainbow pallet configuration

oWorkflow configurations based on each country

Custom Order Split solution

oOrders should be split based on loose cargo or pallet

oOrders split will be done based on each customer’s restriction for each Latin America country

oOrders split will be done based on quantity restriction or weight restriction for each country

Performance tuning in SQL Queries based on OTM Analyzer and AWR reports

Provided the full Solution Design and code implementation for the one of the custom order management component - Order Split.

All technical migration activities for the Latin America OTM upgrade from 6.2.5 to 6.3.5, migration plan and execution.

Go-Live cutover activities, PGLS and Maintenance of post implementation of OTM solution

Client : Schlumberger, USA

Environment : OTM 6.2.5 Implementation

Role : Technical Functional Project Lead

Duration : Dec’2013 to Sept'2014

Roles and Responsibilities:

Project lead for 3 team members, managing new business requirements and design of current system for each deployment

Understanding and gathering the requirements and business processes, analysis, create process flow Visio documents

Set up/configured and optimized the Domain, Itineraries, Rates, Calendars, Itineraries, Equipment Types, Equipment Groups, Equipment Group Profiles, Planning Parameter Sets, Agents, Business Monitors, Match Pay, Match Rules, Invoice Approval Rules, Allocation Rules, Security (User Roles, VPD’s, VPD Predicates, VPD Contexts, Account Policies, User Associations), Custom Menus, Screen Sets, Manager Layouts, User Preferences, Actions, troubleshooting of Bulk Plan errors, optimizing Bulk Plan performance, and fine tuning the Planning Parameters.

Performed data conversion and bulk loading of Regions, Zones, Equipment Types, Equipment Groups, Equipment Group Profiles, etc.

Created Oracle Packages, Stored Procedures, Functions, and Queries using PL/SQL.

Customized some of the UIs by modifying the Screen Sets, XSLs, and JSPs.

Handling daily status call with team, team updates and work allocation to team. Writing use cases, unit test scripts for order management, shipment planning and execution, shipment approval and invoice approval. Tuning work flows and issue fixes.

OTM BI Report Development: Around 20+ reports were considered in the project, roles including requirement gathering, analysis, solution design and development

Client : National Oilwell Varco, USA,

Environment : OTM 6.3.2 /JDE/SOA/BPEL

Role : Technical Project Lead

Duration : Oct’2013 to Jan'2014

Roles and Responsibilities:

Understanding business processes, requirement gathering, analysis, interfaces development, administration configuration activities like FTP, JNDI, Email etc

Designed and mapped the following integration interfaces between OTM and JD Edwards:

oOrder Release, Item Master, Locations, Planned Shipment, Allocation, Shipment Actuals, Shipment Status (EDI 214), Invoice (EDI 810), Voucher.

Led the data conversion and bulk loading of master data (e.g. Carriers, Packaging, etc). Migrating code from client development environment to Oracle On Demand environment

XML’s and XSD’s creating and validating against JDE flat file

Prepare CSV templates for various master data and rate configurations. Solution design and demonstrate to user

Developed Technical Documents as per Client Requirements.

Developed Unit Test Case Documents as per Client Requirements

Client : Panasonic Aero, USA, OTM/GTM Implementation

Environment : OTM 6.3.2/GTM 6.3.2 /EBS/Kewill/SOA/BPEL

Role : Technical Functional Project Lead

Duration : Sept’2012 to Nov'2013

Roles and Responsibilities:

Lead OTM solution architect managing the design and implementation of GTM for compliance rules, License management, Product Classification, restricted party screening (RPLS), embargo/sanction country screening, purchase order screening, delivery screening

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations in OTM/GTM

Design Blueprint for client specific requirements

OTM/GTM customizations, XSLT code changes

Performed data conversion and bulk loading of Regions, Zones, Equipment Types, Equipment Groups, Equipment Group Profiles, etc.

Developed Technical / Functional design documents.

Developed Unit Test Case Documents as per Client Requirements

Created Oracle Packages, Stored Procedures, Functions, and Queries using PL/SQL.

Customized some of the UIs by modifying the Screen Sets, XSLs, and JSPs.

Troubleshooting the issues and fixing them. CRP support, UAT support, Go-live support

Interface development for OTM/GTM with EBS and Kewill using Oracle SOA/BPEL

oOTM Shipment to Kewill Booking, OTM Shipment to Kewill Booking Void, OTM Shipment to Kewill Label Reprint, Kewill Shipment Events to OTM Shipment Events, EBS Delivery to OTM Order Release, OTM Planned Shipment to EBS Trip

oXML’s and XSD’s creating and validating against Kewill flat file

oMD70 document creation/modification

oWritten a concurrent program in EBS for hazmat delivery creation and assign delivery lines to it

Project deliverables and Resource Management

Client : Unilever, Poland, OTM Implementation

Environment : OTM 6.2.5

Role : Technical Project Lead

Duration : Oct'2011 to Sept'2012

Roles and Responsibilities:

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations

Design Blueprint for client specific requirements

Performed Rate file generation, equipment definitions, defined order regions, multistop configurations in OTM

Freight settlement process configuration

Prepare CSV templates for various master data and rate configurations. Solution design and demonstrate to user

Developed Technical Documents as per Client Requirements.

Developed Unit Test Case Documents as per Client Requirements

Involved in CRP workshops and demonstrated the various solutions

Created some sample RIQ xml and tested with OTM using XML Transmitter to check RIQ results

Client : HUAWEI, China, OTM migration 5.5 to 6.2 & Performance Tuning

Environment : OTM 6.2

Role : Techno Functional Consultant

Duration : Aug'2011 to Oct'2011

Roles and Responsibilities:

OTM lead for upgrading HUAWEI environment from 5.5. to 6.2.

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations

Lead offshore team, maintaining good relationship with client team, issue management and escalation, migrating OTM v5.5 to OTM v6.2.

installing the Oracle 11g database, upgrade v5.5 functionalities to v6.2, fit-gap analysis, solution design

Proof of concept for BI Reports in OTM and testing the end to end functionality

Tuning existing SQL and PL/SQL code to improve performance

Client : Global Foundries, Singapore, GTM Implementation

Environment : GTM 6.2

Role : Techno Functional Consultant

Duration : Feb'2011 to Dec'2011

Roles and Responsibilities:

Led the design and implementation of GTM for compliance rules, License management, Product Classification, restricted party screening (RPLS), embargo/sanction country screening, purchase order screening, delivery screening

Design Blueprint for client specific requirements

Interact with business users and in-house project team to understand the requirements

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations

Custom manager layouts, external system configuration, and GTM integration with EBS order management

Prepare CSV templates for various master data and rate configurations. Solution design and demonstrate to user

Developed Technical Documents as per Client Requirements.

Developed Unit Test Case Documents as per Client Requirements

Project deliverables and Resource management

Client : DHL, Brazil, OTM Integration Implementation

Environment : OTM 6.1, EBS, SOA-BPEL

Role : Techno Functional Consultant

Duration : Nov'2010 to Feb'2011

Roles and Responsibilities:

Involved in implementing the Fleet management workflows

Involved in understanding the client requirements analyze and provide the overall integration solution design for OTM/EBS integration

Freight settlement workflow configurations

Designing and creating a proof of concept for OTM with ERP interfaces

OTM integrated with various systems such carrier, FFM system, etc., prepare a solution design document

Developed a POC for OTM with FFM system, configured agents, web services, external systems in OTM and developed an interface in BPEL

Client : Tesco Stores Ltd, UK, OTM Support & Development

Environment : OTM5.5, 6.0

Role : Techno Functional Consultant

Duration : Feb'2010 to Jan'2011

Roles and Responsibilities:

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations

Maintained good relationship with client team, issue management and escalation management.

Proof of concept creation, system configuration, master data template creation, master data loading, business process design, configuration, performance tuning and testing.

Provided solutions for various business requirements including redesigning a most critical inbound Purchase Order report in java, developed custom screens, configured notifications by using custom style sheets. Provided solution, design and development for many issues/requirements raised by support team. Performance improvement by tuning SQL queries in agents and vpd, implementing 5.5 features like copy refnums and migrating OTM v5.0 to 5.5. Search screen customizations, JavaScript changes.

Client : Ingersoll Rand, USA, OTM Implementation

Environment : OTM 6.0

Role : Techno Functional Consultant

Duration : July'2008 to Feb'2010

Roles and Responsibilities:

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations

OTM implementation and integration solution design and development between OTM and various systems such as CASS, Kewill, and EBS using SOA/BPEL middleware

EDI integration development activities for EDI 204, EDI 990, EDI 214, and EDI 210 messages

Additional configuration including workflow with agents, web services, saved queries, and external systems. UAT, Go-live and Post-production support after go-live.

Interfaces developed on the project:

oEBS Delivery to OTM Order Release

oOTM Planned Shipment to EBS Trip

oEBS Actual Trip to OTM Actual Shipment

oOTM Shipment to Carrier Pickup Notification

oCarrier Shipment Status to OTM

Client : Schneider Inc, USA, OTM Implementation

Environment : OTM 5.5

Role : Techno Functional Consultant

Duration : Oct’2007 to July'2008

Roles and Responsibilities:

Understanding and analysis of business processes, configuration set up’s like workflow agents, screen set layouts, saved queries, action checks and rates configurations

Fleet management workflows configurations

Developing/customizing the custom user interfaces in ADF to meet the customer’s requirements and testing the application. Customizations included menus, screen sets, manager layouts and assigning functions to the users based on their respective roles.

Involved in the configuration of domains, users, user roles, setting up of the user preferences and log files, Extraction and Uploading of XMLs/CSVs. Module developments in ADF.

Other OTM Projects:

Duration: Jun'2006 to Oct'2007

OTM/ Glog Competencies Improvement and Implementation

Coke, USA, OTM support, enhancements and bug fixes

BAX Global, OTM Customization.

Java / J2EE Projects:

Duration: Dec'2000 to May'2006

eBooking, APL Logistics, USA

CPADS, Reserve Bank of India, Mumbai

Credit Information System (CIS), Karnataka Bank, Mangalore

NARADA™ Control and Monitoring (CAM) System Product, CNB (Fiji), CITI Bank (Chennai)

Transportation System, Various Clients, Visakhapatnam

Billing System, Various clients, Visakhapatnam

Professional Summary

Employment Details

Project Details

Contact this candidate