PROFESSIONAL SUMMARY:

• Over 11+ years of Techno - Functional experience in Oracle E-business suite Release 11i and 12 - Performing Techno-Functional work in Finance, HCM, and Order management modules of Oracle Applications (Oracle E-Business Suite (EBS) for Enterprise Resource Planning (ERP)).
• Experienced Technical Development skills in the domain of Oracle Applications E- Business Suite using SQL, PL/SQL, Forms, Reports, Workflow I Publisher, BIP Report for integration, OTBI Report and discoverer reports.
• Expertise in developing RICE components (Reports, Interfaces, Conversions, Extensions) in the domain of Oracle Application E-Business suite.
• OAF web pages application development (JDeveloper 10g, EBS R12.1.x, R12.2.x).
• Extensive SQL and PL/SQL development including implementations of Index and Hints management, Query optimization and various others on top of regular PL/SQL and SQL programming.
• 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), HRMS, Time and Labor module.
• 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 Fusion Technical Consultant

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

Responsibilities:

• Worked on developing custom code, maintenance and support for multiple modules like Order Management, Purchasing and OPM and HCM
• End-user page level customizations for adding client flavor to standard product.
• •Developed the several BIP Report for integration.
• •Design and developed the HCM extract for integration.
• Interfaces of creation of employee, update of employee, address API to load data from the legacy system to oracle.
• •Design the OTBI Report as per the client/business requirement.
• •Worked on the data security as and when required.
• •Responsibilities included development and debug of Pl/sql packages and procedure for integration of HCM module
• 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.
• Developed custom Web ADI and modified GL ledger WEBADI.
• 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 training 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.
• Experience developing and customizing Oracle EBS using OA Framework, ADF and PL/SQL.

Confidential, BOSTION

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.
• Worked on custom.pll to perform the zoom functionality.
• Debugged Reports, PL/SQL codes and UNIX scripts and provided various code fixes.
• Post production support.
• Worked on order workflow.
• 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.
• Provided End users training 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 orders 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).
• 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.
• 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, 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.
• 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.
• Workflow/Business Events
• 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 training 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.