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

• 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

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.

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.

Confidential

SCM Track Lead

Responsibilities:

• Worked on Service Contracts Conversion Upload
• Working on Data Management from Legacy into Application
• Worked on building multiple interface which integrate legacy and Oracle
• 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 .
• 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 training.
• 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 achievements.

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
• Achievements.