OBJECTIVE:

• To be an all rounder - Willing to take high risks and responsibilities in any work area/domain.
• To gain continuous knowledge.
• To be an Enterprise/Solution Architect.

SUMMARY:

• Have total 15 Years of professional experience in IT Industry including Oracle Transportation Management Techno functional, Demantra, FTI, Shell scripting, SQL scripting, Oracle DBA and UNIX Administration and 11 Years of experience in Implementation, Migration and Support of Oracle Transportation Management (OTM) for various customers.
• Good knowledge on Transportation Management process and Logistic process. As a Solution Architect involved in both Implementation as well as Support for OTM projects.
• Business Process understanding, Mapping and Design and application configuration for OTM module, and also prepare the Business Requirement document concording to the client requisite.
• Configuration: Create users, Roles, Custom Screen Sets, Smart Links, Business Monitors, Saved Queries and VPD.
• Master Data: Capable of creating Business Model with Locations, Contacts, Contact Notifications, Service Providers, Items, Commodities, Equipments and their related Power Data.
• Automation Agents: Capable to create Basic to Advanced Agents.
• Order Management / Planning: Creation of Order base / Order Release, Prepare Buy / Sell Shipments, Creation of MULTI-STOP and MULTI-LEG shipments with Required Itinerary, Tendering with Service Providers with Consolidated and Single Shipment.
• Involved in product presales activities, OTM s and Talent development.
• Worked on Oracle Transportation Management - Successfully implemented 5 implementations/Migrations of different versions (V5.5, V6.x) of OTM.
• Have experience in Installation, Configuration, Customization of different OTM versions (5.x, 6.x), and Integrating OTM with Fusion Transportation Intelligence (FTI), Rateware, PCMiler and external systems.
• Have experience on Oracle Database Administration.
• Good programming experience in SQL, Performance tuning, shell scripting.
• Have experience on different flavor of UNIX operating system: HPUX, Solaris, RHEL, and AIX.
• Good managerial skills and team building skills along with programming skills in various technologies.
• Excellent communication and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting.
• Successfully completed the and on ITIL V3 Service management Foundation and Oracle Certified Professional s.

PROFESSIONAL SKILLS:

Industry Exposure

Transportation & Logistics (SCM)

Consulting Domain

Transportation & Logistics (SCM) vertical

TECHNICAL SKILLS:

Product: Oracle Transportation Management (v5.5/6.x), Oracle reports 10g, BI Publisher

Operating System: HPUX 11i, Linux, AIX, Solaris and Windows 2003 / XP.

Languages: C, Shell Scripting, SQL, PL/SQL

Database: Oracle 9i, Oracle 10g, Oracle 11g.

Tools: & Utilities: Toad 7.6, Oracle SQL Developer 1.2.1, PUTTY, Winscp

Web Technology: XML, XSL, jspx

Application servers: Weblogic 10g, OAS

PROFESSIONAL EXPERIENCE:

Confidential

Environment: OEL 5.3, Oracle 11g. OTM 6.3.x/6.4.x

Languages: XML, XSL .

Tools: Oracle SQL Developer, Putty, XML Marker, OTM Application, FTI

Solution Architect

Responsibilities:

• Have the complete knowledge of Delivery Planning, Execution, Settlement, FTI and Visibility functionalities and thorough understanding of design.
• Participating in design discussions for Problem Reports and Change Requests.
• Perform fit-gap analysis and provide solution to the new enhancements.
• Involved in configuration, unit testing, UAT support and documentation.
• Analyze and document the specifications from requirements Solution design & documentation.
• Provide technical and functional solutions for the customer.
• Support and for global roll outs and user .
• Contributed in critical delivery flows and improvements.
• Participated in IKEA cloud journey POV implementation readiness and have the complete understanding of challenges with client.
• Provide solution for every problem and enhancement with Oracle if required.

Confidential

Environment: OEL 5.3, Oracle 11g. OTM 5.5, OTM 6.2, OTM 6.3.1

Languages: XML, XSL .

Tools: Oracle SQL Developer, Putty, XML Marker, OTM Application.

Project Lead

Responsibilities:

• Leading and managing the offshore team.
• Involved in configuration, unit testing, UAT support and documentation.
• Perform fit-gap analysis and provide solution to the new enhancements.
• Setting up the Test/Quality Environments, Installation of OTM 6.2/6.3.1, migrating the data from 5.5 to 6.2/6.3.1. Integrating the FTI, Rateware and PCMiler application with OTM.
• Configuring the OLTP and ROD databases. Data management between OLTP and ROD. Configuring ODI to access FTI Dashboard. Troubleshooting the OTM and FTI issues.
• Working in validating and migrating the custom PL/SQL functions and procedures from v5.5 to v 6.2.5/6.3.1 .
• Working in validating and migrating the custom views and materialized views from v5.5 to v 6.2.5/6.3.1
• Validating the agents, screensets, ACL’s after migration from 5.5 to 6.2.5/6.3.1 .
• Working on xsl style sheets and use these style sheets to outbound transmission interfaces.
• Working on inbound messages coming in to OTM as per 6.2/6.3 xml structure.
• Working on reports, converting RDF’s to BI publisher reports.
• Maintaining versioning to all the changes done as per 6.2/6.3 with Eclipse Control Version System.
• Working and resolving both technical and functional related issues during migration.
• Providing the solution for every problem faced by client, if required workings with Oracle OTM support.

Confidential

Environment: OEL 5.3, Oracle 11g. OTM 6.1, OTM 6.2

Technology: SQL, Shell scripting, XML, XSL

Tools: Toad, Text pad, XML Marker, OTM Application

Team Lead

Responsibilities:

• Integrated the fusion transportation intelligence with Oracle Transportation Management.
• Installation and Configuration of ROD database and Oracle Data integrator to access FTI. Configuring the Property settings to integrate FTI from OTM.
• Performing the Data load, syncing the data between OLTP and ROD database. Testing and analyzing the FTI Dashboard reports.
• Assisting the client with the roll up OTM patches by providing the complete step by step document to execute it.
• Configuring the agents and workflows
• Working on integration related development activities like - configuring the external systems, generating the interfaces
• Working on xsl style sheets and use these style sheets to outbound transmission interfaces.
• Updating the design document in regards to change requests asked by client at the time of development.

Confidential

Environment: OEL 5.3, Oracle 11g. OTM 6.1, OTM 6.2

Technology: SQL, Shell scripting.

Tools: Oracle SQL Developer 1.2.1, Putty, Winscp, MOS.

Web servers: BEA Weblogic 9.2.

Lead Consultant

Responsibilities:

• Involving in complete implementation of OTM.
• Installation and configuration of OTM 6.x.
• Migrate, upgrade and refresh of OTM application.
• Troubleshooting the OTM Application related issues.
• Configuring Scalability.
• Configuring automated agents, VPDs and OTM user roles.
• Integrating OTM with 3rd parties like PC Miler, Rateware and Milemaker.
• Integrating OTM with FTI.
• Understanding the technical and function modules.
• Configuring multi-stop and multi-leg shipments.
• Testing the OTM functionality.

Confidential

Environment: Windows XP, SOLARIS, OEL 4, 5, Oracle 9i, 10g, 11g.

Technology: SQL, Shell scripting.

Tools: Oracle SQL Developer 1.2.1, Putty, Winscp, MOS.

Web servers: BEA WebLogic 8.1, 9.2, OAS 10g.

Technical Analyst

Responsibilities:

• Understanding the customer requirement and SLA.
• Providing the solution to customer on OTM application and Database.
• Involving in complete implementation of OTM.
• Installation and configuration of OTM in single tier and Multi tier environment.
• Migrate, upgrade and refresh of OTM application.
• Troubleshooting the OTM Application related issues.
• Performing the health checks and Configuring Scalability.
• Configuring the OTM users, roles and Involving in domain copy.
• Integrating OTM with 3rd parties like PC Miler, Rateware and Milemaker.
• Integrating OTM with FTI.
• Understanding the technical and function modules.
• Providing end-to-end support to OTM application.
• Performing the DBA Activity of OTM application.
• Migration and Upgradation of Oracle Database.
• Cloning the Oracle Database.
• Installing the Oracle DB patch and Application patch.
• Monitoring of database, Checking Alert log files.
• Creation of Databases.
• Managing physical files of the database.
• Creation and Maintenance of Tablespaces.
• Table and index creation.
• Granting roles to user and profile management.
• Configuring a listener/Shared server configuration.
• Creating and managing undo/rollback segments.
• Managing the performance of the oracle

Confidential

Environment: Windows XP, HPUX, Oracle 10g. Oracle 11g.

Technology: SQL, Shell scripting.

Tools: Secure CRT 5.0, Toad 7.6, Oracle SQL Developer 1.2.1, BEA WLI 10.2. OAS 10g.

Technical Analyst

Responsibilities:

• Installation and upgradation of Demantra application.
• Understanding the Architecture of Demantra application
• Configuring and managing the Demantra application
• Deployment of Demantra war file from windows server to Linux middle tier.
• Configuration and Administration of Confidential .
• Refreshing Demantra schema from one instance to another.
• Creation of Databases.
• Managing physical files of the database.
• Creation and Maintenance of Tablespaces.
• Table and index creation.
• Granting roles to user and profile management.
• Backup and restore using RMAN.
• Configuring a listener/Shared server configuration.
• Creating and managing undo/rollback segments.
• Managing the performance of the oracle using SQL tuning.

Confidential

Environment: Windows XP, HPUX, Oracle 10g.

Technology: SQL, Shell scripting.

Tools: Secure CRT 5.0, Toad 7.6, Oracle SQL Developer 1.2.1, BEA Weblogic 8.5, BEA WLI 9.0.

Oracle DBA

Responsibilities:

• Installation and upgradation of oracle 10g on HPUX 11i.
• Monitoring of database, Checking Alert log files.
• Creation of Databases.
• Managing physical files of the database.
• Creation and Maintenance of Tablespaces.
• Table and index creation.
• Granting roles to user and profile management.
• Backup and restore using RMAN.
• Configuring a listener/Shared server configuration.
• Creating and managing undo/rollback segments.
• Managing the performance of the oracle using SQL tuning.
• Backup for front end weblogic application server deployments.