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.
• Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
• Experienced in loading data from flat files into database tables using SQL*Loader,
• Excellent communication skills, with strong troubleshooting, and problem solving ability
• 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), Subledger Accounting, 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, Indianapolis, IN

Sr. Oracle EBS Fusion 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 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.
• Worked on Oracle Integration Cloud to integrate Confidential and Mule soft to Oracle Cloud Apps.
• Experience with SSO, Active Directory, Oracle Fusion Security
• Experience in BI Publisher, OTBI, reports
• Worked on Sub ledger accounting and XLA tables to track the accounting entries and develop the reports on the same.
• Hands on experience in HCM Extracts.
• Have worked on FBDI Use the Auto Invoice file-based data import spreadsheet to import external transaction data.
• Implemented AP Invoice import through Payables Open Interface Import Program
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them into base tables using TCA APIs.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables.
• Implemented several custom logics for Form Personalization using ZOOM Functionality.
• Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to $AU TOP on forms server of client.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances
• Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location.
• Automated the process of encrypting and archiving
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Used Bulk Collect feature to improve performance.
• Developed PL/SQLprocedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Used GIT to maintain code changes.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Worked on Payment Workflow to enhance the approval process as per the business need.

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.
• Developed custom reports like Transaction register, Receipt register
• Worked on Order import interface program.
• Worked on drop ship order and back to back orders
• 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, MA

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.
• Postproduction support.
• Worked on AR Invoice Print Report, AR Credit Note/debit Note Print Report.
• Worked on AR Invoice, Customer Interfaces.
• 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.