SUMMARY:

• Over 10+ years of experience as Techno Functional Consultant in Oracle E - Business Suite Applications.
• Implementation and technical expertise in Oracle Applications R12/11i, across the SCM and Financial modules such as General Ledger (GL), Payables (AP), Receivables (AR), Purchasing(PO), Inventory (INV), Order Management (OM), Cash Management(CE), Fixed Assets(FA), Treasury, EBTax, System administration (AOL),iProcurement, iExpense.
• Experience in designing, coding and testing custom applications with an integration to Oracle Applications and other Custom Applications.
• Experience in developing inbound and outbound interfaces for Oracle General Ledger, Account Receivables, Purchasing, Quoting, Order Management and Inventory Modules.
• Expertise in developing and customizing reports using Oracle Reports using 10g/6i.
• Good experience in Forms Personalization and CUSTOM.pll
• Expertise in creation and customization of reports using XML publisher in OM, AR, AP and INV.
• Implementation and Customization of Oracle Applications 11i with good Technical skills in developing RICE Reports, Interfaces, Conversions and Extensions components.
• Complete knowledge on Procure to Pay (P2P), Order to Cash (O2C) flows.
• Perfect in coding and debugging Packages, Procedures, Functions, Triggers, Views and Indexes.
• Experience in developing UNIX Shell scripts for loading data into staging tables.
• Expertise in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Great expertise in testing web services via SOAP, using the open source testing tool SoapUI.
• Good expertise in using SPLUNK 6.5.2 version.
• Good expertise with RPA tool “Automation Anywhere”.
• Excellent problem-solving skills with an ability to identify problems and implement connective solutions.

TECHNICAL SKILLS:

ERP: Oracle EBS R11i, R12.x

Database Tools: SQL *Plus, SQL * Loader, Toad, SQL Navigator

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, Oracle XML Publisher

Document Methodologies: MD.070, MD.050, CV.060

Operating Systems: Unix (Shell Scripting), Windows XP/NT/95.

Support Tools: Mercury Quality Centre(QC), Serena Change Man Version Manager(PVCS), Kintana,RPA Tool(Automation Anywhere)BugZilla,JIRA,Splunk, Soap UI, Service Now, More4Apps.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis

Oracle EBS QA Lead

Roles and Responsibilities:

• Working with testing team to fix any build/code issues during the APT and IPT phase.
• Following the change management process to promote the code through different environments. (Dev, Test, QA, Prod Like and Production).
• Repsonsible for Application support which includes triage issues, works directly with the client resources to prioritize issues, root cause analysis, resolution of incident tickets and business requests.
• Responsible for Oracle Patch analysis, installation, testing and documenting.
• Responsible for scheduling and manual running of concurrent programs by passing user given parameters.
• Worked on Solving issues related to Blanket Purchase Agreements, EIS Reports, APEX UI Screens
• Responsible for resolving all the severity 1,2,3 tickets raised by end-users.
• Responsible for Performance tuning of SQL statements while debugging.
• Responsible for creating RFC’s (Request for Change) and ownership of deployments across the environments.
• Responsible for code changes and debugging of API’s using SQL, PLSQL.
• Responsible for monitoring SPLUNK and Web Services via SOAP UI.

Environment: Oracle Applications R12.2.6 - (modules OM, INV, iProcurement,iExpense,Purchasing), Work Flow Builder, PL/SQL, SQL Developer,More4Apps,Service Now, EIS Reports.

Order Management SME

Roles and Responsibilities:

• Responsible for Oracle Patch analysis, installation, testing and documenting while integrating with Trex.
• Responsible for scheduling and manual running of concurrent programs by passing user given parameters.
• Worked on EBTax to solve issues and implement a new tax rate for special Jobs in projects.
• Responsible for resolving all the severity 1,2,3 tickets raised by end-users.
• Responsible for Performance tuning of SQL statements while debugging.
• Responsible for creating RFC’s (Request for Change) and ownership of deployments across the environments.
• Responsible for giving transitions on RFC (Request for Change).
• Responsible for code changes and debugging of API’s using SQL, PLSQL.
• Responsible for UPK (User Productive Kit) supporting issue fixings.
• Given seminar on the R12 SLA (Subledger Accounting) architecture

Environment: Oracle Applications 11i - (modules OM, INV, AR, AP, and FA), Work Flow Builder, PL/SQL, SQL*Loader, Forms 6i, Reports 6i.

Oracle APPS Techno Functional consultant

Roles and Responsibilities:

• Created PLSQL packages/procedures/functions and necessary objects as per business requirements, to validate the termination of contracts and populating data to QTC/BV databases through AR Interfaces, this approach reduces operational expenditure by enabling them to perform the contract cancellation.
• Responsible for PLSQL validations for ITEM, ITEM CATEGORIES, BOM, HR interfaces while populating data from C3 legacy system to base tables.
• Experience in implementing Oracle EBS globally in multiple countries in a multi-currency and multi ledger environment.
• Defining system parameters for Cash management with the default set of books and other information
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
• Developed a package to import expense information into Oracle Payables.
• Responsible for development of open interface for interfacing AR transactions from legacy system into AR in Oracle Applications.
• Executed the Payables Transfer to GL program and resolved the issues during the process and Credit Memo generation processes efficiently.
• Validated Importing GL calendar into Treasury.
• Verified and validated that all bank account data has been successfully imported into Treasury System.
• Creating custom Reports and Forms for the end users to check the details and errors.
• Optimized the performance of Reports and Concurrent Programs by using the Materialized view concept, Indexes, Histograms, Hints etc.
• Designed and developed custom workflow Item types to send notifications from Concurrent Programs/PLSQL procedures.
• Used Oracle API's across the customization of the Order to Cash process.
• Developed Item Interface process to Create and Bulk Update Items.
• Created triggers on order lines to perform custom validations.
• Created Alerts to notify users on various business events.
• Setting up the Coverage Types, Coverage Templates etc.
• Creating Service Contracts from Service Contract Authoring form, Service Items Setup in Oracle Inventory Using these Coverage Types from the Oracle Applications 11.5.9 Vision Instance.
• Customized the Accounts Payable Vendor Entry Form as per requirements.
• Designed and developed custom Ship Confirm Form based on the business requirements using Forms 6i.
• Provided Level 2 support to the business users to identify the problem and give a quick solution.
• Actively interacted with users in gathering requirements for development.
• Prepared standard AIM documentation for each object undertaken.
• Worked on DFT utility Framework changes (where in all the common utilized 12 framework features are merged to behave as unique 3-4frameworks).
• Responsible for Capturing Review Comments log, preparation of Validation Scripts, UTC, SIT Test Cases, checking in the code into PVCS repository, creation of KP via KINTANA code migration tool.
• Responsible for defect tracking and defect solving in QC.

Environment: Oracle Apps 11i (INV, AP, AR, GL, OM, AOL), PL/SQL, SQL*Loader, Forms 6i, Reports 6i, XML

Oracle PLSQL Developer

Roles and Responsibilities:

• Worked in development and testing of reports, using Digital Fuel.
• Customized reports as per the requirement.
• Worked in the development of SDR Framework and Construction of SLA’s.
• This frame work holds set of 91 standard reports which are designed as Standard Reports that are to be used for multiple customers.
• Created stored procedures and functions as part of report development.
• Actively involved in designing of reports with complex functionality.
• Prepared the Unit test cases for all the flows and reports designed and customized for all customers.
• Prepared the report configuration documents with complete details about the design steps.
• Involved in the analysis and creation of the DF Report Design document for all the 91 reports.
• Involved in the analysis and configuration of Change requests raised.
• Designed documents holding steps involved in activities carried on in design and development of all SDR reports and have shared the same with team mates for better understanding.
• Involved in Export and Import process for all the components across servers.
• Involved in Batch scheduling for the new components.
• Extensively worked in the UAT phase and had resolved the bugs.
• Expertise knowledge in using tool BUGZILLA.
• Prepared the SDR limitation document that captures the limitations of the tool.

Environment: SQL* Plus, Digital Fuel tool, Bugzilla.

Oracle EBS Technical consultant

Roles and Responsibilities:

• Worked on BSA RELEASE FORM prototype development.
• Developing Dealer Agreement reports using Oracle XML Publisher.
• Build DA templates by converting client DA documents (.DOC, .XLS, .PDF) into .rtf templates.
• Build PL/SQL procedures to generate the data in XML format. Responsible for performing the unit testing Build test cases and test reports.
• Responsible for creating SALES ORDERS from OM module.

Environment: XML publisher, Reports 6i, Forms, TOAD.