SUMMARY:

• Over 11+ years of IT experience in System Analysis, Design, Development, Implementation, Upgrade, Customization, Testing and Production Support of Oracle E Business Suite (EBS) 11i/R12 as an Oracle EBS Technical Consultant. Hands on experience asOracle Apps Tech Lead and Oracle Apps Senior Technical Consultant among different industries.
• Extensive experience in the technical aspects of Oracle Applications (SQL, PL/SQL and SQL*Loader, Forms, Reports, XML Publisher, Discoverer, SQL, PL/SQL, Interfaces and Conversions).
• Involved in all aspects of SDLC with functional knowledge in Procure - to-Pay (P2P) and Order-to-Cash (O2C).
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Conversions and Extensions/Customization).
• Extensive experience in Requirements gathering, Analysis and understanding of AS IS and TO BE models.
• Experience in preparing Functional requirement Document and Test cases.
• Functional exposure in Oracle Applications Modules like AP, AR, GL, PO, INV, OM, FA, SLA, ASCP, AOL and HRMS.
• Proficient in data migration activities.
• Successfully lead teams through various phases of implementation and support with strong decision making and motivation skills.
• Worked extensively on Trading Community Architecture (TCA) and Multi-Org Environment.
• Proficient in Customization/Development of Oracle Forms and Reports using Developer 2000 as per client specifications.
• Proficient in developing Discoverer Reports.
• Involved in performance tuning in oracle using Explain plan and Tkprof.
• Expertise in preparing AIM documents like MD070, CV060, TE020, MD050 and MD120
• Prepare & Review Test Plan, Test scope Documents and Test cases, Key resource in successful execution of UT (Unit Testing), FIT (Functional Integration Test), SIT (Systems Integration Test) and CAT (Client Acceptance Test)
• Strong problem solving & technical skills coupled with confident decision make for enabling effective solutions lead to the high customer satisfaction
• Worked in onshore-offshore model, managed and development team and delivered complex projects following the quality standards.

KEY SKILLS:

• Requirements Gathering and Analysis
• Technical Specifications Documentation
• Reporting Experience
• Integration and User Acceptance Testing

TECHNICAL SKILLS:

Operating systems: Windows XP/2K, UNIX/LINUX, Citrix Server

Database skills: Oracle 9i/10g/11g

Languages: SQL, PL/SQL

Tools: SQL, PL/SQL, SQL*Plus, TOAD, SQL*Loader, Forms 6i/10g, Reports 6i/10g, XML Publisher, Oracle Discoverer, Form Personalization, Oracle Workflow, Oracle Alerts, Data Loader, Oracle Application Framework Concepts, Winscp, FileZilla, Noetix, Putty, HP Quality Center, Kintana, SVN, Assyst, Remedy

ERP: Oracle EBS (R12, 11i)

Functional Modules: Oracle R12/11i AP, AR, GL, OM, INV, PO, AOL, FA, HRMS

Methodology: Oracle AIM

Education: Master of Computer Applications from Osmania University, India

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Oracle Apps Tech Lead

Responsibilities:

• Worked on data moment fix from entities to CORE by doing root cause analysis.
• Processed backlog data to CORE from entities.
• Handled data migration lead activities to new R12 system.
• Modified PO inbound interface.
• Identified and fixed duplicate receipts issues.
• Identified and fixed customer outbound issues.
• Handled month end activities for data moments and also handled reporting to business during month end.
• Worked with oracle support for solving accounting issue for AP distributions.
• Worked on XLA tables to back track GL and FA issues related to consolidation.
• Worked closely with the users to fix production issues.
• Created discoverer report that will give the receipts write-off details.
• Developed custom form for generating entering quick invoices.
• Involved in BOLT go-live activities.
• Created documents related to business flows.
• Fixed the issue with custom AP material create form.
• Created documents for custom objects.
• Involved in lead activities.

Environment: Oracle Applications 12.1.3/11.5.10 (GL, AP, AR, PO, OM, FA), Oracle 11g/10g, Forms, Reports, XML Publisher, Discoverer, Noetix, Toad, Oracle AIM, SVN, Remedy.

Confidential, Boston, MA

Oracle Apps Tech Lead

Responsibilities:

• Bug fix for production issues.
• Identified and fixed chart of accounts issue.
• Identified the root cause and fixed JPM Extract issue related to positive pay.
• Identified the root cause for i-Proc Auto Account Generator.
• Created custom code to in corporate log messages in to a custom table via workflow.
• Fixed Discoverer double join issue.
• Modified existing customer conversion to be feasible with ROW countries.
• Involved with Spain and Poland team for UIT, code migration and Go-Live Testing.
• Involved in client requirement gathering, feasibility analysis, and code review.
• Developed discoverer reports for NA and ROW.
• Used Jira tool for creating ODM requests for each sprint.
• Used Jira tool for generating month/week/sprint wise reports and published them to the client.
• Created PO extract report.
• Used XLA JOURNAL ENTRIES PUB PKG for manually reverse entries wrongly happened at source.
• Created handy SQL Queries for Functional Consultant those were used during Month End activity.
• Fixed CVR rules issue.
• Created templates in accordance with AIM documentation those were used by the team for RICE documentation.
• Prepared MD050 for RICE development.
• Handled code review and document review for each object in every sprint before RICE delivery.
• Successful in delivering sprint objects in time by working closely with the onsite and offshore team.
• Customized existing Journal Entry form to show all the segments of the accounting string.
• Identified and fixed month end minimum billing program issue.
• Created templates for documentation.
• Fixed foreign character issues for XML reports.
• Developed FA Accumulation Depreciation report.
• Created Captive Non-Captive report.
• Customized project account form.
• Migrated MKS to SVN.

Environment: Oracle Applications 12.1.3/11.5.10 (GL, AP, AR, PO, OM, FA, iProc), Oracle 11g/10g, Forms, Reports, XML Publisher, Discoverer, Noetix, Toad, Oracle AIM, AtlassianJIRA, Oracle Demand Management, SVN, Assyst, IBM Asset Manager.

Confidential, NA

Responsibilities:

• Modified existing customer conversion to be feasible with ROW countries.
• Worked on data migration activities from 3rd party systems.
• Created bank conversion.
• Created XML publisher reports for GL, AR and AP.
• Developed discoverer reports.
• Modified existing discoverer reports to be feasible with ROW countries.
• Identified and fixed foreign language Date and Number issue fix for PL/SQL.
• Handled entire code migration of RICE and Discoverer reports.
• Prepared test cases and involved in testing.
• Involved in client requirement gathering.
• Involved in setup implementation during go live.
• Involved in setup verification during go live.
• Handled Quick invoice form customization.
• Created code pack installation scripts.
• Handled additional responsibility as a Cell Lead for Germany and Netherlands implementation.
• Retrofit existing 11i objects to R12.
• Helped team members to understand the requirements.
• Gave training on Discoverer to team members.

Environment: Oracle Applications 12.1.3/11.5.10 (GL, AP, AR, PO, OM, FA, iProc), Oracle 11g/10g, Forms, Reports, XML Publisher, Discoverer, Toad, Oracle AIM, Atlassian JIRA, MKS, Panaya.

Confidential, Branchburg, NJ

Oracle Apps Technical Consultant

Responsibilities:

• Handled entire OPM form personalization.
• Created XML based reports for OPM.
• Created Discoverer based reports for OPM, PO and OM.
• Developed PO interface for loading third party purchasing information to the R12 system.
• Developed supplier conversion for loading legacy data to the R12 system.
• Involved in feasibility analysis.
• Modified FNDLOAD script for loading personalization such that the script will update or create specific personalization.
• Created custom form for tissue creation.
• Along with development activity was handling the team for timely delivery.
• Involved in all RICE code bundle installations.
• Involved in code review and document review.

Environment: Oracle Applications 12.1.3 (GL, AP, AR, OPM, PO, OM), Oracle 10g, Forms 10, Reports 10, XML Publisher, Discoverer, Toad, Oracle AIM.

Confidential, Austin, TX

Oracle Apps Technical Cell Lead

Responsibilities:

• Accepted additional responsibility as a cell lead and was successful.
• Handled end to end data migration activity.
• Created common package containing most of the commonly used functions, procedures and global variables that can be used by any RICE.
• Developed COA Engine that will generate new R12 COA segment combination for each of the 11i COA segment combination.
• Developed Customer conversion.
• Developed GL Balances conversion.
• Developed GL daily rates interface.
• Created common lookups that contain 11i and R12 mapping that can be used by conversions.
• Created common mail program using shell script.
• Modified existing EMF (Error Messaging Framework) asset that was used by all the conversions for reporting.
• Involved in all RICE code bundle installations.
• Involved in code review and document review.

Environment: Oracle Applications 12.1.3 (GL, AP, AR, PO, OM), Oracle 10g, Forms 10, Reports 10.

Confidential, San Antonio, TX

Senior Oracle Apps Technical Consultant

Responsibilities:

• Analyzed the Apps 11i RICE objects.
• Analyzed the Apps R12 RICE objects.
• Tweaked UIAT tool as part of the upgrade for making it work with the current available instance.
• Generated reports using UIAT tool for knowing the RICE level impact on the upgrade.
• Fixed RICE and DB Objects that have issues as part of the upgrade.
• Changed the custom RICE for R12 changes.
• Fixed HPQC issues.

Environment: Oracle Applications 12.1.3, Oracle 10g, Forms 10, Reports 10.

Confidential, Parsippany, NJ

Oracle Apps Technical Consultant

Responsibilities:

• Developed Outbound Interface for transferring ASCP related data to flat files.
• Created Host program (Shell Script) for sending mails to users.
• Developed new ASCP reports using Discoverer.
• Re-Developed ASCP reports using Discoverer that were .rdf’s in Apps 11i.
• Created .ldt files and moved the source code to share point.
• Created client specific AIM documents for each and every RICE developed.

Environment: Oracle Applications 12.1.1/12.1.3 (GL, AP, AR, PO, OM, WMS, FA), Oracle 10g, Forms 6i/10g, Reports 6i/10g, Discoverer 10g.

Confidential

Senior Oracle Apps Technical Consultant

Responsibilities:

• Analyzed the Apps 11i RICE objects.
• Analyzed the Apps R12 RICE objects.
• Tweaked UIAT tool as part of the upgrade for making it work with the current available instance.
• Generated reports using UIAT tool for knowing the RICE level and Data Base level impact on the upgrade.
• Fixed RICE and DB Objects that have issues.
• Fixed HRMS fast formulas issue.
• Identified missing custom and standard .rdf files and fmb’s during upgrade.
• Re-Compiled the custom forms and reports.
• Fixed the forms and reports that were invalid due to R12 changes.
• Fixed Discoverer reports.
• Created DB objects for making the custom objects work.
• Created automated shell script that will migrate all the custom 11i forms and reports to R12 instance, generate fmx and to move each fmx to respective path.

Environment: Oracle Applications 12.1.1/12.1.3 (GL, AP, AR, PO, OM, WMS, FA), Oracle 10g, Forms 6i/10g, Reports 6i/10g, Discoverer 10g.

Confidential, Mountain View, CA

Oracle Apps Technical Consultant

Responsibilities:

• Reviewing the Functional Specifications and based on FDD’s preparing TDD’s.
• Customized existing Forms as per the requirements using Form Builder 6i.
• Developed and customized various Reports for analysis purpose as per the business requirements using Report Builder 6i.
• Developed Inbound Interfaces to load data into base tables using SQL*LOADER.
• Developed Outbound Interfaces to load from base tables to flat files using UTL FILE package.
• Created Database Triggers and Stored Procedures.
• Personalized the Oracle Standard Employee Form.
• Prepared KFF report.
• Worked on Oracle Apps Alerts.
• Registered Staging Tables with AOL.
• Created Concurrent Programs, Executables, Value Sets and Registered Forms and Reports to the AOL.
• Created Unit Test cases as part of Apps Development.
• Involved in Migration of Apps from Testing Instance to Production Instance.
• Involved in day-to-day Production Support and resolved the issues.
• Development and Customization of new and existing Reports.
• Extensively used SQL*LOADER and UTL FILE package for developing Inbound/Outbound Interfaces to load data from/to legacy systems to/from apps base tables.
• Developed Conversion to load legacy data to apps base tables.
• Customized existing Form using Custom.pll.
• Created Stored Procedures and Triggers as per business requirements.
• Registered concurrent programs with AOL.
• Analyzing Functional/Technical specifications.

Environment: Oracle Applications 11.0.3 (GL, AP, AR), Oracle 9i, Forms 6i, Reports 6i.

Confidential, Milpitas, CA

Oracle Apps Technical Consultant

Responsibilities:

• Created Inbound Interface using SQL*LOADER.
• Created Outbound Interface.
• Created customized reports.
• Developed client specific reports.
• Created Procedures and Packages and registered them as concurrent Programs.
• Created tables and registered them with AOL.
• Developed conversion to load data to the Apps Base tables using API’s.
• Customized existing forms using custom.pll.
• Defined Concurrent Programs, Executables and Request Sets.
• Created Value Sets in various modules of the application.
• Created test cases and done Unit Testing.

Environment: Oracle Apps 11i, Forms 6i, Reports 6i, Oracle 9i.