SUMMARY

• Software Professional around 11+ years of experience in Oracle Applications, and overall experience of around 9 Years in analysis, design, development, testing and implementation of applications and production support in the Client Server environment using Oracle Applications R12 (12.1.3).
• Currently working as Procurement Consultant for Procure - to-pay Production Support of 12.1.3 for client Michelin.
• Worked Extensively in Oracle Purchase Order (PO), Quality (Customised), Inventory (INV), SCM and PPOD (Custom Module).
• Technically proficient in RICE (Reports, Interfaces, Configuration, Enhancements) methodologies including Implementation, Interfacing, Conversion, Data Migration and Data Conversion.
• Good understanding and functional knowledge in Purchasing Module and basic Knowledge of iProcurement Module, Oracle iSupplier Portal, Sourcing and Oracle Inventory
• Extensive Data base development experience includes Oracle 9i, Oracle 10g, Oracle 11g SQL, and PL/SQL; Query Optimization, Trouble shooting, Packages, Stored Procedures and Functions.
• Competitive in Development and customization of XML Publisher Discoverer and knowledge of APEX
• Strong Knowledge on Application Implementation Methodology (AIM).
• Good Working Experience in Reports 10g for both development and customization of Several Reports as per client specifications.
• Extensive work experience in integrating Oracle EBS Systems with Oracle APEX and other customer legacy systems.
• Strong in using Oracle Workflow Builder to develop various activities such as Notifications, Functions, and Processes.
• Involved In migration of developed components using STAT to testing and production Instance along with production support.
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• Presently working on 24 X 7 Production Support responsible for ensuring Timely Closure of Month end and Year End Activities for multiple business units of the client for functional and technical streams.

TECHNICAL SKILLS

ERP: Oracle Application R 12( 12.1.3) / 11i (11.10.2)

Business Areas: Procure to Pay

Knowledge: PO, i-Supplier Portal (Customized), PPOD(Custom Module), INV, Quality (Customized) and SCM

Tools: Developer 2000 (6i, 10g), XML Publisher 5.6, BI Publisher, Toad 7.6, SQL*Plus 8.0, SQL * Loader, UTL File

Languages: PL/SQL, SQL, Developer-2000 (Reports 6i & Forms6i),forms10g,Reports 10g

Operating Systems: MS-DOS, Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential

Environment: Oracle Applications 12.1.3

Techno functional Consultant

Responsibilities:

• Developed a concurrent program to display and clear the pending receiving transactions based on the Operating units, Inventory Organization and transaction type.
• Worked on restoring the deleted PO Receipts.
• Functional Consultant for Oracle R12 Finance, Supply chain, and OPM
• Prepared Kanban update program: This is a customization based on a custom module PFEP. The card size should be the product of tray size and number of trays for container form PFPE. This also involves personalization of pull sequence form to restrict the Kanban size updating from the Pull sequence form.
• Worked on PRR detail report to correct the PRR report and modified the report layout (Custom modules related to Quality).
• Worked on “AAM EDI Validate 856 ASN Data” concurrent program to clear the pulls struck in work list in i-Supplier Portal.
• Involved in development of Reports & Customization of reports.
• Worked on XML Publisher.
• Work with external systems integrated with Oracle (PLM, Kewill, Web Methods, GXS, Apex, Clear Orbit, OLS, EDI etc;)
• Working as Oracle EBS Techno-Functional lead in IT Consulting. Having Strong implementation experience in EBS modules like WMS, MSCA, OM, INV, Shipping and YMS with exposure to Purchasing and OPM modules in Oracle R12 & 11i Versions.
• Triage, Daily Support for Financials, Procurement, Inventory, and OPM Modules
• Travel to OPM Plants, Process Flow Capture, Create Use-Cases, and process design
• Working on PPOD (Custom module) issues and i-supplier issues.
• Prepared job aid from PPAP completion from suppliers. Also prepared job aids for PPAP, PRR and PFPE - AAM Quality modules.
• Working on AAM Quality, PO / Receiving and i-Supplier portal issues. Involved in development of Form Personalization’s.
• Working on Month end activities, Production support issues and provide support of R12 Cutover activities

Confidential

Environment: Oracle Apps 11i

Consultant

Responsibilities:

• Worked on Technical Tickets related to PO and Manufacturing modules
• Direct Point of contact for PPOD (Production Purchase Order - Custom Application)
• Involved in modification of Reports (RDF and SQL), Procedures and Packages to fix the bugs
• Worked on High Jump scanner issue for Receipt preparation
• Worked on AAM EDI ASN Cancelation Program (Custom program to cancel uncompleted Shipment Notifications) on changing the code for not deleting the ASN’s that got error for some reason or manual intervention.
• Implementing Feeder systems using Oracle APEX to Import the data from flat files to Staging
• Worked on PPOD’s getting cancelled even after all Approvals (Custom Application - APEX and PL/SQL)
• Worked on various PPOD issues (Custom Application) and many repetitive issues were closed by code fixing in the APEX application as well as in PL/SQL Package to Interface the PPOD into Oracle Applications.
• Worked on STAT tool for migration of the objects into PROD
• Worked on Data fixes and code migration
• Modified the PL/SQL Package for PPOD to check the Supply Agreement for New BPA’s created by PPOD Application and Update to check the Supply Agreement if it is not checked
• Worked on Custom report “AAM Summarized & Categorized Purchase Variance Report (Excel)” to add few additional columns as requested by the user.
• Worked on custom report “AAM Top 10 Disbursed Items by Account” to correct the error. Report was previously giving data only for few Sub-inventories and data related to some Sub-inventories is not populating.

Confidential

Environment: Oracle Apps 11i

Consultant

Responsibilities:

• Worked PO report to add additional footer messages for China Rollout in XML Publisher
• Developed new custom report “FLS Receipt to Inventory Report” for China rollout in XML Publisher
• Worked on several XML Templates
• Worked on Item Category Updating (one time process)
• Worked on Sales Order Acknowledgement Report
• Worked on High priority Production Support Tickets and CSR’s
• Worked on MRP Pegging Report.
• Designed OPM implementation solution, created sample recipe
• Implementing Feeder systems using Oracle APEX to Import the data from flat files to Staging

Confidential

Environment: Oracle Apps 11i

Business Analyst

Responsibilities:

• Worked on Items Interface and BOM Interface
• Point of contact for the Product test team on data flow
• Monitoring of all interfaces across all the test environments
• Triage of messaging issues
• Validation of BOM/Pricing/Costing etc... across OMEGA and Gii

Confidential

Environment: Oracle Apps 11i, Reports6i, Discoverer

Consultant

Responsibilities:

• Worked on PL/SQL Packages to integrate TIBCO tool for B2B Messages
• Worked on production support issues
• Worked on Discoverer Administrator to analyse the Queries of Custom folders, Item Classes and Hierarchies
• Implementing a centralized Oracle APEX Application Dashboard for the business to access both the Oracle EBS R12.1.3 and other Line of Business data using various Drill down, Aging and Matrix reports.
• Worked on Discoverer Desktop check the conditions, logo, subtotals, parameters etc… for the work books / work sheets
• Involved in the implementation of Service Contracts legacy application using APEX 4.1 to accommodate the custom Drop ship business processes and Integrated with Oracle e-Business modules.
• Worked on Discoverer Reports like customizing workbooks to meet the business needs
• Defined the architecture for "Tally" a custom module for stocking and maintaining the lot cost inventory items based on OPM
• Performed Root cause analysis (RCA) for errors in 3B11 messages and suggested the suitable solution to avoid the errors while sending the message.

Confidential

Environment: Oracle Apps 11i, Reports6i, XML publisher Reports, Discoverer

Consultant

Responsibilities:

• Developing XML Reports on un credited Checks
• Develop and Customize the Discoverer Workbooks such as modifying the conditions, parameters and changing the Logo to meet the requirement
• Worked on Discoverer Administrator to create simple folders, Item classes and Functions
• Customize the Concurrent Programs and RDF reports to modify the hardcode values as per the standards
• Worked on Conversions

Confidential

Environment: Oracle Apps 11i, Reports6i, XML publisher Reports, Discoverer

Associate

Responsibilities:

• Report on Suppliers whose payments exceed the given currency amount (passed as parameter) during a financial year
• Discoverer report to display all the employee expenses that are to re-embers, with all details like Employee name, Expense, Amount Account Details etc..
• AP Interface to process employee expenses
• Bank Reconciliation interface

Confidential

Environment: PL/SQL, Forms 6i, Reports 6i

Associate

Responsibilities:

• Reports Development. Worked on developing and customizing reports
• Worked on modifications of custom programs developed previously
• Develop software programs as assigned