SUMMARY

• 13+ Years of IT Experience as a Senior Oracle Apps Consultant with Rich experience as Technical & Techno Functional Consultant in 11i & R12 Oracle EBS with Implementation, Upgrade, Support and Enhancement Projects.
• Worked with various Oracle Applications modules in the domains of Financials (GL, AP, AR, FA, CM, SLA, iExpenses) and SCM (OM, INV, PO, BOM, WIP, iProcurement, Shipping) & Service Contracts.
• Has Core Expertise in Design, Development and Customization of W.R.I.C.E. Components.
• Has strong knowledge of Application Implementation Methodology (AIM), prepared Functional Design (CV40, MD50) and Technical Design (CV60, MD70) and Installation Instructions (MD120) documents.
• Proficient in writing SQL &PL/SQL Program including Stored Procedures, Packages, Triggers, Functions using advanced features such as BULK COLLECT&COLLECTIONS for better performance.
• Developed Inbound and outbound Interfaces and Conversion Programs using PL/SQL, SQL*LOADER, UTL FILE package, UNIX Shell Scripting & Oracle packaged APIs.
• Developed Custom Forms using Oracle Forms 6i/10g and Customized existing ones using Form Personalization and CUSTOM.PLL.
• Dexterous in Customizing Oracle reports and developing new reports by using Oracle Reports 6i/10g and XML Publisher (BI Publisher).
• Development and Customization of Workflows as per the Business Requirements using Oracle Builder.
• Developed and modified various Discoverer Reports against NOETIX Views implemented on Oracle EBS Database.
• Designed and Developed Discoverer Workbooks based Oracle EBS Form and Report Screens as requirement specifications provided by Business.
• Performed User and Administration responsibilities in Discoverer Reports.
• Has Good Understanding on Procure to Pay and Order to Cash business cycles including the Data Model.
• Strong Knowledge of Application object Library (AOL), Trading Community Architecture (TCA).
• Performed Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF.
• Contacted Oracle My Support and raised Service Requests with appropriate Severity on behalf of the Client and took the same to Closure.
• Worked Closely with DBA & Business Users during Critical Production Issue Analysis & Resolution.
• Have Excellent Client/Customer Communication & Interacting Skills.
• Has Ability to work individually and as Team Member efficiently.

TECHNICAL SKILLS

ERP: Oracle E - business suite R12,11i.

Modules Worked On: Financials - GL, AP, AR, CM, FA, E-Biz Tax, SLA, iExpenses.

SCM: PO, OM, INV, WSH, BOM, WIP, iProcurement.

CRM: Service Contracts.

Tools: Forms 6i/10g, Reports6i/10g, Workflow Builder 2.6, XML/BI Publisher.

BI Tools: BI Publisher, Oracle Discoverer 10g, OBIEE 11g, NOETIX VIEWS 5.1

Languages: SQL, PL/SQL.

Databases: Oracle 10g, 11g, 12c.

Version Control Tools: Clear Case, MS-VSS, MS-TFS, SVN, Perforce.

Other Tools & Utilities: Win SCP, Putty, SQL*LOADER, Toad, SQL Developer, HPQC, Clear Quest, JIRA, Service Now, Kintana.

Scripting Language: UNIX Shell Scripting.

Operating Systems: Windows Family, UNIX/LINUX.

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Techno Functional Consultant

Responsibilities:

• Functional and Technical Design and Inbound and Outbound Interfaces with Subaru Partners.
• Technical Design and Development of Custom Workflow.
• Customization of RDF Reports as per the Change Requirements.
• Technical Design and Development of BI Publisher Reports.
• Root Cause Analysis of Production Support Issues and Provide Code Fixes and Data Fixes.
• Interacting with Oracle using My Support for raising SRs and following up with them during Issue Resolution.
• Preparation of UAT/QA Test Scripts and assist the Business Users/QA Team.
• Preparation of Functional Design (FRD) and Technical Design (TSD) Documents and User Guides.
• Subaru Passport AP Invoice Integration Solution Design and Development.
• Implementation of Read Only Diagnostics to comply with JSOX Requirements.
• SSLP Just Drive Rental Integration with Subaru Dealer Network.
• SSLP VIN Reinstatements Integration with Subaru Partners.

Environment: Oracle EBS 12.2.6, Oracle 11g, SQL Developer, GL, AP, AR, CM, UNIX, SQL, PL/SQL, Unix Shell scripting, Putty, WinSCP, SVN, Service Now, MS-OFFICE, BI Publisher, Reports 10g, Workflow 2.6, Forms 10g.

Confidential, Muscatine, IOWA

Oracle EBS Technical Consultant

Responsibilities:

• Resolved Tickets based on Priority Basis using Cherwell Tool.
• Development of Code Fixes and Data Fixes as part of the Resolution to Production Issues.
• Involved in the Re-design of WRICE Components such as Packing List to improve performance.
• Interacted with IT and Business Teams during Development to understand Requirements
• Worked on Customization of OM Sales Order Workflow.
• Worked on Workflow Approvals and workflow process methods in OM and PO modules.
• Worked on Customization of reports in Advanced Pricing and Order Management module.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Design and Developed Auto Receive PO and Close the PO’s interface in Purchasing.
• Involved in Procure to Pay (P2P) & Order to Cash (O2C) business flow.
• Designed and developed PO Requisition Interface to load PO requisitions from the legacy System into oracle purchasing (PO) using SQL*Loader and PL/SQL validations.
• Created Tables, Indexes, Views, Triggers, Stored Procedures, Functions and Packages.
• Performing the Setup Changes in various SCM Modules as part of the CR requirements.
• Creation of Test scripts and assisted the QA Team.
• Developed XML Publisher Reports from Concurrent Programs.

Environment: Oracle EBS 12.2.4, Oracle 11g, TOAD, OM, WSH, INV, UNIX, SQL, PL/SQL, Unix Shell scripting, Putty, WinSCP, Cherwell, TFS, MS-OFFICE, BI Publisher.

Confidential, Sunnyvale, CA

Techno Functional Consultant

Responsibilities:

• Offered Production Support for end to end ON-LINE order to cash cycle till the Rev Rec.
• Resolved Tickets on Priority Basis using the JIRA Tool.
• Performed Root Cause Analysis and presented the same to the Linked IT / Business.
• Developed Data Fix, Code Fix and Bug Fix whenever needed and implemented the same.
• Followed/Checked with Payment Gateway contact points to ensure the receipt of the Settlement Files/FX Rates.
• Offered extensive support to business during the On-line Month/Quarter End Close by performing the necessary steps as per the Close Checklist.
• Worked with Business Users to resolve variances reported from Revenue Reconciliation performed post close.
• Improved the performance of long running routine jobs using SQL Trace, TKPROF and Optimizer HINTS.
• Worked Closely with Record to Report and E-Commerce teams to resolve dependent issues of On-line process.
• Participated in Status Meetings with Project Team providing updates on the work time to time.

Environment: Oracle Applications R12 (12.2.4), AR, GL, CM, INV, Oracle 11g, SQL Developer, SQL*Loader, UNIX, SQL, PL/SQL, UNIX Shell scripting, Putty, Win SCP, Kintana. JIRA, Review Board, SVN, MS-OFFICE.

Confidential

Oracle EBS Technical Lead

Responsibilities:

• Worked on SCM modules, identified the objects for Customization/Retro fitment based on PANAYA list.
• Performed Functional and Technical Design for New Objects/Customizations as part of the Upgrade.
• Designed and Developed Data Conversion Scripts to migrate the legacy data into R12.
• Retro-Fitted the Forms, PLLs &Reports (RDF & XML Publisher), including the coding for MOAC in R12.
• Developed New In-bound/Outbound Interfaces for data flow in and out of oracle apps from external systems.
• Customized the Workflows to reflect the change in the business process, as part of this upgrade.
• Worked closely with QA team to resolve defects during testing of all retro-fitted CEMLIs/Customizations.
• Offered UAT and Post Go - Live Support for the SCM modules.
• Performing the Setup Changes in various SCM Modules as part of the Change Request requirements.
• Creation of Test scripts and assisted the QA Team.
• Order Details screen - Created an Order detail report in XML Publisher.
• Creating LDT files for Menus, Functions, and Concurrent programs.
• Customized Purchase Order (PO) Form using CUSTOM.pll for comparing the unit price entered with the component prices entered in the descriptive flex fields.
• Performance tuning and Query optimization for Reports and Interfaces using Explain plan.
• Analysis and Resolution of L3 Tickets by interacting with Production Support Team.
• Performed Code Review as per the checklist also participated in Peer Reviews.
• Providing KT to production Support Team about the Development before the Deployment.
• Participated in weekly status meetings with Project Team and Requirement discussions with Client.

Environment: Oracle Applications R12 (12.2.4), OM, PO, INV,WSH, AP, GL, Oracle11g,SQLDeveloper, SQL*Loader, UNIX, Unix Shell Script, SQL, PL/SQL, Forms 10g, Reports 10g, OAF, Jdeveloper11g, Workflow Builder 2.6, BI Publisher, Putty, WinSCP, HPQC, MS - TFS (Team Foundation Server), MS-OFFICE.

Confidential

Oracle EBS Technical Lead

Responsibilities:

• Responsible for Production Support and Enhancements for SCM Modules and CRM (Service Contracts).
• Understanding the Requirements in French by consulting the On-site Team in France.
• Preparing Solution design document for Enhancement Requests.
• Preparing the Technical Design Document and Implement the code change as per the specs.
• Analyzing the issues and finding out the root cause of the problem for the issues.
• Offered Month end /period close support for PO & INV Modules, coordinating with business from offshore.
• Open the SR with Oracle Support for critical issues (SEV1 and SEV2) and followed up to closure.
• Handled Tickets and Defects based on Priority and Severity Basis using IBM Clear Quest.
• Developed and Applied the Data Fixes to resolve the Issues on Production.
• Performed Unit Testing, logged the results in HPQC.
• Documented all the conversions according to the AIM documentation standards.
• Prepared MD70, MD120 using AIM Methodology.
• Developed inbound interfaces on PO receipt creation, sales order import and sales person conversion.
• Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions and Workflows as per client requirements.
• Experience in BI/XML Publisher Reporting Tool.
• Worked with SQL * Loader, UTL File for outbound and inbound interfaces
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Created parallel queries for the optimization of the SQL queries.
• Customized PO requisition workflow.
• Worked with performance tuning tools like Explain Plan and TKPROF.
• Maintained the Documentation (MD50, MD70, MD120 etc.).
• Performed Code Reviews and Participated in Peer Reviews.
• Participated in Weekly Status Meetings with Project Team.

Environment: Oracle Applications 11i (11.5.10.2), OM, PO, INV, Service Contracts, iProcurement, Oracle 9i (9.2.0.6.0),SQL Developer, SQL*Loader, UNIX, Unix Shell Script, SQL, PL/SQL, Forms 6i, Reports 6i, Workflow Builder 2.6, XML Publisher, Putty, Win SCP, HPQC, IBM Clear Quest, Clear Case, MS-OFFICE.

Confidential

Senior Oracle EBS Technical Consultant

Responsibilities:

• Resolved Service Requests and Change Orders using Client’s Ticketing Tool (HAL).
• Developed Discoverer Workbooks based on the Business Requirement Specifications.
• Modified the existing Discoverer Reports by including Parameters, changing conditions, adding new columns, Layout changes, calculations etc. to suit the change requirements.
• Created New Database Views, Folders and Business Areas to implement WW Reporting with NOETIX VIEWS.
• Performed the Join configurations, Folder Changes, Folder& Business Area Refresh, resolved BA Access issues using Discoverer Administrator.
• Performed the required code change to the NOETIX VIEW Definitions to suit the Business Change.
• Developed Database PL/SQL Functions and registered them with Discoverer for using in the Discover Desktop.
• Received Appreciation from Client-Side V.P., Finance and Corporate Controller for implementing Database Views in the NOETIX Layer on a short notice to facilitate Worldwide Reporting which helped the client to get a good view of number of Key functions in their Organization.
• Worked in Collaboration with a Business User to develop a specific Discoverer report “Category and Approval Report” for which Senior Procurement Manager from Client Side appreciated with good remarks.
• Acted as Single POC for all World-Wide Discoverer Support for Confidential in the absence of the On-Site Counterpart.
• Designed and Developed Custom Reports and Customized Standard Reports as per the Business Requirements using Oracle Reports 6i.
• Developed Custom Forms using Forms 6i and Customized existing Forms using Custom Library and Form Personalization feature.
• Designed and Developed Interface Programs using SQL*Loader, UTL FILE package and UNIX Shell scripting with available Open Interfaces and APIs.
• Created New Alerts and Customized Seeded Alerts to Suit the Business Change as required.
• Customized the Seeded Workflow to reflect the Business Process Change as requested.
• Developed New Reports (RDF, RTF) and converted Seeded Reports into XML Publisher Reports.
• Tuning SQL Statements to improve performance using EXPLAIN PLAN and TKPROF.
• Prepared Technical Design Documents MD 70 based on Functional Design MD 50.
• Designed the UTP and executed the Unit Test Cases for all the components developed.
• Resolved critical production and UAT issues by communicating with Business Users thru Mail, Chat and Client’s Net Meeting Facility.
• Participated in Status Meetings with the Offshore and Onsite Project Teams.

Environment: Oracle Applications 11i/R12, GL, AP, AR, PO, INV, FA, OM, iExpenses, Oracle 10g with NOETIX VIEWS 5.1, Discoverer 10g (Desktop and Admin), SQL Developer, SQL*Loader, UNIX, Unix Shell Script, SQL, PL/SQL, Forms 6i/10g, Reports 6i/10g, Workflow Builder 2.6, XML Publisher, Putty, Win SCP, Perforce, MS-OFFICE.