SUMMARY

• An accomplished Oracle Applications Technical Architect/Manager with around 9 years of proven expertise in Software Lifecycle Development of Oracle Applications Design, Development, Testing and Implementation and good Project management and Team Management experience.
• Experienced Strong Technical Project Manager for the Oracle Apps Implementations.
• Worked as a Good Liaison between Implementation Partner and Client.
• Provided weekly Project Progress report with Achievements, Issues, Concerns and Milestones to the Implementation Partner and Client.
• Provided man - hour estimates with resource count for the needed development Accomplishments.
• Worked as a Team Lead for Technical Developers for Oracle Apps Implementations starting from requirements gathering to Go-live.
• Worked with Offshore Team for development of objects and with DBA for several DBA activities.
• Experience in different phases of Oracle Implementations from Start to Go-Live and involved in several organizations Go-Live.
• Experience and ability to co-ordinate and work closely with various project teams involving Business Users/End Users, Developers, Functional Team, Project Managers for successful implementations.
• Ability to interact with Functional users and Business analysts to gather requirements and to architect Industry standard feasible solution.
• Expertise in Designing solutions for complex business requirements and designed several customizations in Manufacturing and Supply Chain modules in Oracle Applications.
• Good experience in study/audit of existing business process and preparation issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using Custom.pll, reports using Report builder 6i, XML Publisher and exposure to Workflow, Oracle Discoverer, OAF using JDeveloper512 9i and development of business reports using OBIEE.
• Strong Hands on Implementation and Support projects in the functional & technical areas of Manufacturing (INV, WIP, BOM), Supply Chain Management (OM, WSH, PO, WMS, QP, CFG, MSCA), Financials (GL, AP, AR), and Application Object Library (AOL, SYS).
• Good functional knowledge in designing and configuration of Order-to-Cash (O2C) and Procure-to-Pay (P2P) life cycles.
• Designed and Hands-on experience in Data Conversion, Data Migration from different Legacy systems into Oracle and Developing Interfaces, Extensions from Oracle with other 3rd Party Systems.
• Designed and developed different inbound and outbound interfaces with oracle e-business suite. Developed several interfaces for 3rd party applications with Oracle E-business suite.
• Extensively involved in design, configuration, development and deployment of custom Process integration packs (PIPs) to support additional and unique requirements of Client business.
• Good knowledge and understanding of Oracle E-Business Suite PIP components.
• Extensive experience in administering SOA Suite 10/11g Servers, Web Logic and Oracle Application Servers.
• Developed API’s in Oracle Applications to support B2B Applications.
• Knowledge on Oracle Mobile Supply Chain Applications, Oracle Configurator and TCA Architecture.
• Strong programming Technical experience in creating Procedures, Packages, Functions, Triggers, UNIX shell scripts and other database objects using SQL and PL/SQL.
• Experience in customizing standard Oracle forms with the use of CUSTOM.PLL, Forms Personalization and OA Framework Personalization and Developing new forms using OA framework and Forms Builder.
• Extensive experience in developing Business requirement specification (BR100), Functional Specifications (MD50), Technical Specification Documents (MD70), Conversion Specifications (CV40, CV60) and other testing documents in AIM Methodology standards.
• A well-organized, detail-oriented team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS

ERP: Applications R 12/11.5.10.2/11.5.10/11.5.9/11.0.5/11.0.3.

E-Business Suite Modules: INV, OM, WSH, WMS, MSCA, QP, CFG, TCA, GL, AP, AR, PO, BOM, WIP, SYS.

Languages: SQL, PL/SQL, C, C++, Java

Tools: & Utilities: Forms 9i/6i, Reports 9i/6i, Discoverer 4i/10g, XML Publisher, SQL*PLUS, SQL*Loader, Workflow Builder 2.5, TOAD, SQL Developer, JDeveloper, SQL Navigator, Discoverer, OBIEE, MS Visio, FTP, Data loader etc.

Database: Oracle 11i/10g/9i/8i/8.x.

Operating Systems: Sun Solaris, HP-Unix, IBM AIX, Windows XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential

Techno Functional Architect

Responsibilities:

• Created Weekly Project status Report to the Implementation Manager and Client to keep track of overall project status with the Miles stones provided.
• Schedule meetings with the client to update the Project status and to discuss necessary steps to meet client deadlines for the Development.
• Conducted Daily status meetings with Functional, Technical and DBA involved in the Implementation.
• Worked with Functional team to carve out the Technical architecture for the GAP Analysis.
• Co-ordinate Offshore team status with Client to meet client deadlines.
• Worked on Technical Designs for the Business requirements provided. Hands on Experience in designing the Technical Architecture for the complex business requirements.
• Development of Technical Designs with the offshore team and keep track of progress with status calls.
• Involved in gathering requirements for the Business Users and extracting detail Specifications from the Integration partners.
• Understanding the Business requirements and perform GAP analysis with Oracle E-business Technical Architecture.
• Worked on Technical Designs architecture for the Implementation.
• Worked on critical development objects
• Resolved issues encountered in testing with Business users at client site.

Confidential

Techno Functional Architect

Responsibilities:

• Worked with WAMAS team to understand and gather the detail specifications of the Interface.
• Designed and developed Interface Program has been developed to send all the picking information (Items, locations, routes and sales orders) to Wamas as soon as pick release is completed in oracle.
• C51ustom Interface program sends data to Wamas and waits to get the acknowledgement for the data being sent. Label print API has been developed to call based on the acknowledgements received from WAMAS.
• Items, locations and routes information will be sent to Wamas periodically and Sales order information will be sent as soon as the Sales order has been pick released and replenishments completed.
• Programs has been developed to update the item attributes information in Oracle.
• Onhand quantity load program has been developed to load initial on hand balances.
• Prepared documentation for MD50 and MD70 documents for this Interface.
• Worked with Offshore team to develop and completes the tasks as per deadlines.

Confidential

Techno Functional Architect

Responsibilities:

• Involved in gathering requirements for Kewill Interface with Kewill Team.
• Installed Kewill Adapters (Java and PLSQL) in Oracle for this Interface.
• Designed API’s to send required information to Kewill using Kewill provided adapters for different carriers.
• Waybill number is received back from Kewill and updated against the delivery in Oracle.
• API’s has been designed to perform SHIP, PSHP and CSHP transactions in Kewill.
• Worked on Technical design document and prepared documentation on this Interface.

Confidential

Techno Functional Architect

Responsibilities:

• Developed label API as per the carrier requirements in Oracle.
• API sends information to the Cipher label system and populates the information as designed in the Layout.
• API has been developed to print based on label type, printer and Ship method associated with the delivery.
• Labels will get printed automatically as soon as the pick release is completed for a given sales order.
• Picking information received back from WAMAS system will be automatically pick confirmed in oracle.
• Developed LPN Full pick, LPN Partial Pick and Pick None API’s to perform Pick Confirmation in Oracle.
• Alerts has been developed to notify the users for the processing Errors in Oracle.

Confidential

Techno Functional Architect

Responsibilities:

• Providing the weekly Project status to the Implementation Manager and Client to keep track of overall project status with the Miles stones provided.
• Involved in discussions with the client on the Project status and taking necessary steps to meet client deadlines for the Development.
• Development of Technical Designs with the offshore team and keep track of progress with status calls.
• Involved in gathering requirements for the Business Users and extracting detail Specifications from the Integration partners.
• Understanding the Business requirements and perform GAP analysis with Oracle E-business Technical Architecture.
• Worked on Technical Designs architecture for the Implementation.
• Worked with Functional team to carve out the Technical architecture for the GAP Analysis.
• Co-ordinate Offshore team status with Client to meet client deadlines.
• Worked on critical development objects
• Resolved issues encountered in testing with Business users at client site.
• Integration of Oracle WMS with PeopleSoft: Worked on Integration of Oracle WMS with PeopleSoft through ODI (Oracle Data Integrator). Interfaces have been developed to transfer the Master Data and Transactional Data between two systems using ODI. Messaging approach has been used for the interfaces.
• Designed and Developed Interface programs to load Items, Customers, Suppliers, Departments, Locators, Item cross references, Categories, Unit of Measures conversions, Sales orders, Purchase orders data into WMS.
• Designed and developed several triggers and API’s to send Inventory adjustments and receiving transaction data from WMS to PeopleSoft.
• Designed and developed a picking interface between Lucas and Oracle WMS system.
• Developed custom API to perform pick confirmation, partial picks and pick none transactions in Oracle.
• Developed a custom program to pick release the sales orders as per the client requirement and call the pick slip documents once the order has been pick released.
• Developed custom program to load On hand quantity from legacy system into Oracle WMS.
• Developed custom API’s to create deliveries, assign deliveries, Pack, Unpack, and Split transactions among child and parent LPN as per client requirements.
• Developed a custom program to print freight documents for a delivery as per client needs.
• Designed and developed custom Pick slip and Pack slip report as per client requirements.