SUMMARY:

• An Oracle Consultant, willing to learn and undertake the challenges by forging ahead with the Emerging technical aspects.
• Oracle Applications Technical consultant with around 14 years of IT experience in Software development.
• Technical and Functional expertise in Oracle E - Business Suite R12/11i, Reports 10g/9i/6i, Forms 10g/9i/6i, XML/BI Publisher, Discoverer 4i/9i/10g, SQL, PL/SQL.
• Experience in the Implementation and Customization of Oracle Manufacturing, SCM and Financial modules
• About two and half years worked in US in various roles like Track Lead, Project Lead and analyst roles.
• Extensive Interfacing and Conversions between Oracle Applications and Legacy Systems.
• Experience in SQL*Loader, SQL* Plus, UTL FILE, CONCSUB Utility, Oracle Import/Export utilities
• Good Knowledge in Order to Cash (O2C) and Procure to Pay (P2P) and CRM flows.
• Well versed with TCA Architecture.
• Strong Knowledge in design and development of interfaces using API’s and Open Interfaces for integrating other applications with Oracle Applications.
• Experience in supporting the production system and handling day-to-day issues.
• Experienced in Customizing Standard Oracle Reports and developing Custom Reports by using Report builder, Discoverer and XML Publisher.
• Experienced in Customizing & personalizing Standard Oracle Forms with CUSTOM.pll & Forms Personalization.
• Adept at PL/SQL Packages, triggers, Functions, Stored Procedures.
• Sound working knowledge in UNIX Shell Scripting.
• Experience in Performance and Tuning using SQL Trace, Explain Plan, TKProf, Indexing and Hints.
• Experience with documentation using AIM (MD 50, MD 70, CV 40, CV 70) Methodology.
• Expertise in using version control tools like WinCVS, PVCS,SVN
• Successful execution experience of On-Site and Off-Shore Model.
• Very strong in requirements analysis, design, development, customization, testing and implementation
• Problem-solving and Proven ability to work under pressure.

TECHNICAL SKILLS:

Technology and Tools: Key Skills - Oracle E Business Suite (11i & 12i) Oracle Forms Oracle Reports Oracle Xml Publisher, Oracle Framework Oracle SQL Loader, Import, Export Good Knowledge on Oracle Application Modules Like OM, INV, PO, OPM, BOM, WIP, LMS, Install Base, Service Contracts, Service Request, AP,AR,GL and AOL and good exposure to other modules.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

• Provide Enhancement and Maintenance Support for Oracle Finance Modules and Service Contract.
• Provided support for Enhancement of Oracle Discoverer Reports and BI Publisher Reports.
• Provide Oracle Enhancement and Maintenance Support for various interfaces.

Technology: Oracle Applications R12

Confidential

Senior Consultant

Responsibilities:

• Provide Enhancement and Maintenance Support for Oracle SCM Modules.
• Provided support for Enhancement of Oracle Discoverer Reports
• Provide Oracle Enhancement and Maintenance Support for various interfaces.

Technology: Oracle Applications R12

Confidential

SCM Track Lead

Responsibilities:

• Worked on Service Contracts Conversion Upload
• Working on Data Management from Legacy into Application
• Worked on Complex multidimensional Report which will integrate three Applications which would give the Snapshot of the Data from Quote to Fulfillment and Invoiced and Pending items to be Fulfilled
• Worked on Flagging an Orders into Multiple Criteria and Flag them into multiple Accounting Rule, Provided Technical Solutions for the Proposed Requirement

Technology: Oracle Applications R12

Confidential

Lead

Responsibilities:

• Support project on 24/5 environment
• Standardized the delivery processes
• Managed a team size of 2 and worked on allocations and helped on trouble shooting
• One of the Point of contact for all P1 and high priority incidents
• Successfully provided solutions for all production related issue and delivered fix on time and maintained 100 % SLA
• Deliver the weekly status report of different applications that we support to all stake holders of the client.
• Processing Orders stuck Orders on Workflows providing Data Fix and Updating Business if the issues related to configurations.
• Identified the issues related to missing Functional Configurations and advised on the required operations to perform by the Business for fixing the issue issues.
• Performed multiple Data fixes related to Processing, Releasing and Cancelation of Orders.
• Performed Bug fixing on the various existing Programs for the issues reported by the Business.
• Since Oracle was the Master System which holds all the Master and Transactions Data which tightly integrated with the other systems. Supported Middleware, BI and SFDC Team on various issues related to integrations.
• Provided Solutions on Pricing and Sales Reps related issues .
• Supporting a Custom designed model which manages the Customers and Business Users which manages privileges, Permission and Roles and Responsibilities.
• Analyzed on various Code and Design related issues related to User Management and provided end to end solutions.
• Identified the current design Gaps on User management process and proposed appropriate solutions for resolving the gaps.
• Provided various data fixed to various issues related to Data.

Technology: Oracle Applications R12

Confidential

Tech Lead

Responsibilities:

• Design and development of custom packages to export Asset returns to external systems
• Design and development of custom process to import Sales order from external systems.
• Design and development of 64 data templates using XML publisher to support various customer reports formats.
• Design and development of various inbound and outbound processes.
• Created promotion packages to migrate the custom objects to different instances using FNDLOAD and UNIX shell scripts.
• Proposed solutions for identified GAPs, Issue resolutions, escalations, and Oracle TAR support.

Technology: Oracle Applications R12

Confidential

Application Developer

Responsibilities:

• Developed custom interface program to auto create sub inventories in application based on the sub inventories provided
• Design and Developed Custom interface program to automate the subinvetory and inter organization transfer process and send notifications to user with the details of the transactions and deactivate the source sub inventory
• Design and development of custom program to upload Purchase order.
• Design and development of Custom program to upload inventory items and on hands.
• Prepared technical documentation including MD200, MD60 and MD70
• Created promotion packages to migrate the custom objects to different instances using FNDLOAD and Unix shell scripts.

Technology: Oracle Applications R12

Confidential

Application Developer

Responsibilities:

• Designed and Developed custom interface program using UTL to load the PO date files FTP’ed by EDI process which loads reads the data from the data file and internally does all validations and migrate the data to target tables and send a email confirmations to user once the file is processed.
• Design and Developed Custom interface to generate outbound file using Oracle UTL utility for purchase orders.
• Design and Developed Custom Purchase order acknowledgement Report Using XML Publisher
• Development Custom Shell Script to process the data file send by EDI process based on First in First Out Method
• Developed Custom shell script to send mail notifications to user
• Developed custom program to export PO details to Excel
• Prepared technical documentation including MD200, MD60 and MD70
• Conducted conference room pilot and user acceptance testing sessions, user .
• Created promotion packages to migrate the custom objects to different instances using FNDLOAD and UNIX shell scripts.
• Customized sales order form to display minimum and maximum order quantity

Technology: Oracle Applications R12

Confidential

Application Developer

Responsibilities:

• Involved in preparation of estimation for development objects.
• Preparation of Technical Design documents
• Involved in POC for XML Gate Way and Business Events
• Developed Vendor conversion program to import vendors from the legacy system into Oracle with required validations

Technology: Oracle Applications R12

Confidential

DEVELOPMENT LEAD

Responsibilities:

• Understanding the client system, performing requirement and impact analysis and offshore team management. Tracking the development objects on daily basis and resolving the technical and functional issues with offshore.
• Release management at client side
• Resource Planning for Deliverables
• Estimation of Deliverables
• Involved in designing of Template Conversion and quardinated with the client data extraction team for data collection for conversions.
• Coordinate with offshore development team and the client
• Work with client for Data validation for the data uploaded through conversions.
• Design of Technical Document, UTP document, Conversion
• Data upload Status document.
• Ensuring the deliverable milestones are achieved on a timelybasis
• Review of technical design and code units
• Reviewing the Unit test Results.
• Understanding of Functional requirement and transferring into technical design
• Quality Review of the code Prioritize and manage Assignments against developers s.

Technology: Oracle Applications 12.0.1

Confidential

Conversion Lead

Responsibilities:

• Leading the Conversion Track (Team Size of 8)
• Client Interaction on weekly basis for Conversion Track with nsite lead
• Interaction with IBM/ Confidential counterpart in US for Deliverables.
• Resource Planning for Deliverables
• Involved in designing of Conversion Template.
• Involved in designing and development of common code utility packages
• Involved in design of Unit Test case structure
• Ensuring the deliverable milestones are achieved on a timely basis
• Peer Review of technical design and code units
• Reviewing the Unit test Results.
• Understanding of RSV(Functional Spec) and Preparation of
• Quality Review of the code
• Prioritize and manage Assignments against developers s

Technology: Oracle Applications 12.0.1

Confidential

Application Developer

Responsibilities:

• Worked on Interfaces to import items and item data (item attribute, item number) from existing system in to Oracle Inventory through Item Import Interface.
• Developed a custom report Material Receipt Note Report for material received, using XML publisher.
• Developed a custom report Stock Transfer Note for stock that transferred from one location to another, using XML publisher.
• Imported Sales Order into Oracle Order Management using custom validation program and Oracle Open Interface Program.
• Imported Price List into Oracle Advanced Pricing using custom validation program and Oracle API.
• Imported On hand Upload into Oracle Inventory using custom validation program.
• Imported item instance into Oracle Install base using custom validation program and Oracle API.
• Worked on customization to create a unique sequence number when item are received during receiving transaction.
• Worked with service Invoice Report using XML publisher.
• Modified and created new concurrent programs as well as executable files.

Technology: Oracle Applications 11.5.8

Confidential

Application Developer

Responsibilities:

• Provided Production Support for Custom Oracle Application Module CIM (Customer Item Maintenance).
• Involved in resolving Production Issues
• Translate customer requirements into formal requirementsand design documents, establish specific solutions.
• Delivered new and complex high quality solutions to clients inresponse to varying Business Requirements.
• Direct Interaction with client to generate ProgramRequirements
• Worked with customization of Oracle Applications Forms.
• Worked with customization of Reports
• Worked on Performance Tuning.
• Worked extensively on Inbound and Out bound Interfaces
• Worked extensively with PSLQ report.
• Worked with customization of Reports
• Worked with debugging the PSQL Packages.
• Prepared DATA Model for the CIM module and create flow
• Chart for jobs involved in CIM.

Technology: Oracle Applications 11.5.10.2

Confidential

Technical Analyst

Responsibilities:

• Sales Orders Conversion as entered
• Inventory Items Conversion
• Report on Inventory Item on hand quantities
• Custom report to see how many of each item that are ordered, shipped and how many that is not available in our inventory.
• Report on drop shipped item in Order Management
• Custom report to list all items, which is drop shipped on period wise.
• Form Customization in inventory

Technology: Oracle Applications 11.5.10.2

Confidential

Technical Analyst

Responsibilities:

• PO Receipts Conversion
• Outbound Interface for Cancelled Sales Orders
• Item Attachments Conversion
• Report on changes in Item Attributes of Inventory Item .
• Custom Report on changes in Item Attributes between Inventory Orgs.
• Report on Purchase order with Buyer details
• Custom report to display purchase order number, line no, quantity and unit price with buyer details

Technology:Oracle 9i, Oracle D2K 6i, SQL* Loader, Toad

Confidential

Software Engineer

Responsibilities:

• Developed the reports as per the Customer Requirement.
• Validating the Programs Done and Passing it to next stage.
• Developed packages specifications & packages body, Stored Procedures, views.

Technology:Oracle 9i, Oracle D2K 6i, SQL* Loader, Toad