PROFESSIONAL SUMMARY:

• Over 11 years of Techno - Functional experience in Oracle E-business suite Release 11i and 12 - Performing Techno-Functional work in Finance,HRMS, and Order management modules of Oracle Applications (Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP)).
• Experienced Technical Development skills in the domainof Oracle Applications E- Business Suite using SQL, PL/SQL, Forms, Reports, Workflow I Publisher and discoverer reports.
• Expertise in developing RICE components (Reports, Interfaces, Conversions, Extensions) in the domain of Oracle Application E-Business suite.
• Experience in customizing Oracle workflows such as the PO Approval process, Order/Line.
• Good understanding of Order to Cash (O2C) and Procure to Pay cycle (P2P)
• Excellent perspective on converting the functional specifications into technical design and development.
• Able to clearly articulate and effectively communicate ideas, problems, and solutions with individuals at all levels
• Having Very good exposure of implementation and support for Oracle E-business suite Release 11i and 12.
• Well versed with Onsite Offshore model and effectively handled onsite assignment.
• Followed quality and coding standards with all the deliverables delivered to client

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Oracle EBS Technical Consultant

Environment: Oracle E-Business Suit R12, Oracle SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Workflow, Unix, SQL Loader.

Responsibilities:

• Worked on developing custom code, maintenance and support for multiple modules like Order Management, Purchasing and OPM.
• Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
• Worked on multiple projects, which include developing SQL Loader code for loading data into staging tables, PLSQL code for validation and insert/update of data and emailing the output to the user.
• Development and Debugged Oracle Forms and Form Personalization.
• Worked with SOA integrator.
• For information on how to install or upgrade Oracle E-Business Suite Integrated SOA Gateway from earlier releases, and how to perform setup tasks for both SOAP and REST services
• For troubleshooting information on potential problem symptoms and corresponding solutions for Oracle E-Business Suite Integrated SOA Gateway
• Developed and Integrate Oracle using third party applications like SOA and Web Methods.
• Worked with SOA integrator for PO acknowledgement.
• Debugged Reports, PL/SQL codes and UNIX scripts and provided various code fixes.
• Post production support.
• Worked on Payables Open interface to import standard Invoices from third Party in AP.
• Worked on PO import interface program.
• Prepared various documents like MD70 (Technical Design Doc), MD120 (Deployment Doc)
• Involved in technical testing of various bug fixes.
• Modifying existing functions based on Problem Report/Change Request (PRCR) and maintaining Product compatibility.
• Provided End users on customizations and outbound and inbound interfaces flows.
• Frequent Client Interaction to discuss future enhancement and optimization solution.
• Worked on various custom developments, maintenance and support.
• Worked on Migrating/Creating customers, accounts, sites from third party system to Oracle.
• Worked on various performance issues to during production support.
• Assisted functional/business with various analysis and prod issues.
• Developed custom XML Publisher, Oracle Reports (RDF) as per business requirements.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Experience with Oracle Supplied Packages such UTL FILE.
• Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
• Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files.
• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Used Version Control (PVCS, Clear Case) to maintain code changes.
• Proactively tuned SQL queries, Views using Explain Plan, Hints, indexes, and SQL trace.

Confidential, Monroeville, PA

Oracle Apps Techno-Functional Analyst

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, Workflow, OAF.

Responsibilities:

• Worked Primarily on Forms, Reports and Pl/Sql Packages, Function etc.
• Manages the team to deliver the objects within the deadline.
• Part of the complete implementation cycle.
• Managing the team and ensuring the quality delivery of the objects by them.
• Working as Technical lead which involves gathering requirement from client and assigning the work to other technical consultants and working on the objects.

Confidential

Sr. Oracle EBS Technical Consultant

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, Workflow.

Responsibilities:

• Involved in Requirement gathering and technical design documentation.
• Written PL/SQL stored Procedures, Functions and Packages for implementing the business logic.
• Developed the custom Form that call location specific Report.
• Developed customer RDF reports using Oracle 10g.
• Developed a new customer forms in OM.
• Unit testing and code reviews for modified objects.
• Prepared various documents like MD70 (Technical Design Doc), MD120.
• Worked on multiple projects, which include developing SQL Loader code for loading data into staging tables, PLSQL code for validation and insert/update of data and emailing the output to the user.
• Used FND-LOAD to migrate Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files
• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Confidential, Melbourne, FL

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, Workflow.

Responsibilities:

• Involved in Requirement gathering and technical design documentation.
• Development and modification of custom forms using Forms 6i.
• Developed new reports using Reports 6i.
• Worked on Custom APIs and Interfaces of Receivables.
• Worked on various production issues.
• Written PL/SQL stored Procedures, Functions and Packages for implementing the business logic.
• Worked on Receivables open interface.

Confidential, Orrville, OH

Environment: Oracle E-Business Suite R12, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher, Workflow.

Responsibilities:

• Modified queries, Procedures, Functions and Packages to make R12 complaint
• Customized the XML reports including adding sub templates to main template, Company Logo, Common terms and conditions etc.
• Developed the custom Form that call location specific Report.
• Unit testing and code reviews for modified objects.
• Added the new items through personalization based on requirement.
• Hiding and disabling the items based on conditions.
• Worked on the development of interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP, GL.
• Developed outbound interface to extract the data from the Oracle Apps Tables to the Flat file using UTL File utility as per client requirement.
• Handling the Issues (Tickets) & analyzing the root cause of the problem and giving fixes.

Confidential

Environment: Oracle Apps R12

Responsibilities:

• Involved in level 2-production support.
• Resolved various burning prod issues to support month end.
• Worked on various code fixes/Enhancement resulted due to prod issues.
• Very good understating of finding the root cause of the prod issues and fixing the same.
• Debugged SQL’s, PL/SQL, Reports and Forms to resolve prod support issues.
• Provided Functional and business a user for custom features.
• Enhanced various programs to improve performance.
• Involved in Requirement gathering and technical design documentation.
• Development and modification of custom forms using Forms 6i.
• Developed new reports using Reports 6i.
• Worked on Custom APIs and Interfaces of Receivables.
• Worked on various production issues.
• Written PL/SQL stored Procedures, Functions and Packages for implementing the business logic.
• Worked on Receivables open interface.

Confidential

Oracle Apps Technical Analyst

Environment: Oracle E-Business Suite 11i, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher.

Responsibilities:

• Developed and customized Oracle Alerts as per client’s requirement.
• Creation of new reports using XML Publisher, Discoverer.
• Creation of new Custom Forms
• Worked on personalization
• Conversion scripts prepared for Item master, Item Sub Inventory Defaults, Item Opening Balances.
• Conversion scripts prepared for Item Issues and Item Receipts (Up and Down Inventory).
• Conversion scripts prepared for Supplier master, Supplier sites and supplier contacts.
• Conversion scripts developed for customer master.
• Conversion scripts prepared for Loading Suppliers and Customer Opening Balances.
• Developed API’s for projects information
• Migration from the Legacy system to ERP system
• Development of User and Manuals.
• Development of RICE Components.
• Post go-live Technical support in all the modules mentioned above.
• Researched and resolved problems using Metal link as well as opening up SR.

Confidential

Environment: Oracle E-Business Suite 11i, Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, XML Publisher .

Responsibilities:

• Finalizing the logic with client for extracting the Open and master data from existing 11i application.
• Testing the scripts for master and transitional data on UAT and PROD instance.
• Uploading legacy data to R12 instance using scripts, WebADI and data loader.
• Debugging of reports, modification of migration scripts / reports according to end user requirements.
• Development of interfaces and conversions for Suppliers, customers, Open AP Invoices, AR Invoices.
• Uploading the India localization taxes and tax categories using Data loader.
• Uploading Asset data assets / depreciation reserve / cost of assets using WebADI.
• Post Go-Live Technical support for all the modules mentioned above.
• Leading the technical team and completing all these activities well in time.