Summary:

• 6 and half years of experience in IT and 5 years as an Oracle Applications technical consultant.
• Extensive experience in both financial and manufacturing modules
• In-Depth understanding of Oracle Application architecture, experience with Multi-Org features of R12 and 11i.
• Proficient in Oracle Applications implementation with PL/SQL, SQL*PLUS, TOAD, SQL Loader, Data Loader, Database Triggers, Procedures, Functions, Oracle Reports 10g/6i Oracle Forms 10g/6i.
• Data Conversions through Interfaces and APIs and Custom Development using Oracle Applications Coding and GUI Design Standards, Concurrent manager, flex field’s setup, Integration Testing, documentation (AIM) etc.
• Developed Reports in BI Publisher/Xml Publisher
• Developed Custom Packages, enhancements to existing, proposed new ideas, flexible methodology, and best procedures and implemented the same.
• Initiated, developed and implemented automated scripts and hence decreasing manual intervention which is desired in ERP.
• Extensive experience in the customization by extension and modification of the standard application suite using Application Object Library (AOL).
• Extensive knowledge in Oracle ERP Application modules such as Inventory, Order Management, IStore.
• Extensive experience in coding Interface Programs for importing data from Legacy Systems.
• Implemented and Customized Work Flow to send approval notification mails through Lotus notes mailing system. Involved in developing various interfaces to integrate with other systems data.
• Experience in developing client server solutions using Oracle 6i/10g Forms and Oracle 6i/10g Reports. And also expertise in building Reports in Discoverer 4i/10g Administrator including maintenance of Business Area and Work Book.
• Used various Software Tools (PVCS, Developer 2000, TOAD, Kintana Etc).
• Worked on Multiple platforms (Windows Servers, Sun Solaris, HP-UNIX, & Linux).
• Coordinated with the development team to identify the product gaps by creating Tars and ERs to resolve various issues.
• Aptitude to swiftly troubleshoot and resolve various Oracle Applications issues which arise during the Project and the ability to work in a dynamic, team-oriented environment
• Well Conversant with analysis, creation of detail design, coding, implementation, Quality and Documentation.
• Extensive knowledge in Oracle ERP Application modules such as Inventory, Order Management, IStore.

Oracle Applications: R12/11i, 10.7. General Ledger, Oracle Receivables, Oracle Payables,
Oracle Cash Management, Oracle Assets, Oracle Order Management,
Oracle Inventory, Oracle Purchasing, Shipping, iExpenses,
iSupplier, iReceivables, iComp, iProcurement, iStore.
Oracle Administration: AOL, SYSADMIN, Oracle Workflow Administrator, OA Frame Work Developer
Oracle Tools: Reports 6i/10g, Forms 6i/10g, Workflow Builder 2.5, Discoverer 9i/10g,
BI/XML PUBLISHER
Database: Oracle 10g/9i/8i/8.0, MS SQL Server 7.0, DB2, PL/SQL, SQL.
Developer Tools: TOAD, SQL*PLUS, SQL* Developer, SQL*Loader
Operating Systems: HP-UX, AIX, SCO, Windows NT 4.0/2000/XP, Win 95/98/3.1, Novell.

Professional Experience:

Confidential,Appleton, WI 03/2011- Present

Sr. Oracle EBS Techno Functional Consultant
Confidential,is the industry\'s most extensive provider of solutions focused on helping educators help students succeed. It is one of the preferred resources for educators, offering the most innovative curriculum and supplemental learning solutions, supported by the best service around. The Project is designed to extend the functionality of Oracle system to meet the business requirements, by building new reports, forms, personalizing forms, interfaces and workflow processes.
Responsibilities:

• Senior consultant with Oracle EBS R12 experience.
• Worked for designing and developing integrations for Oracle EBS.
• Have strong experience in modules like Order Management, Inventory, Receivables, Order-to-Cash cycle, Pricing, Purchasing, Project Costing and worked on API\'s.
• Worked on Accounts Payables, Inventory, Accounts Receivables, General Ledger, Engineering, Quoting and Purchasing modules of Oracle Financials/Manufacturing.
• Worked on a number of form customizations in Inventory, Purchasing and Developed YearEnd product inventory status reports in Inventory module.
• Developed new custom forms in Inventory module. Worked on customizing Oracle seeded reports in PO, AP, Inventory and AR modules.
• Configurator Extensions created and attached to each case model through configurator extension rule. This extension will enable the paint selections made by the user in the run time configurator during the sales order entry in the order management to save as the configurator attributes.
• Responsible for publishing content for Istore.
• Creating UI’s as per client requirement.
• Developed reports in oracle BI publisher/Xml publisher like Null Buyer Item, Future Cost Update and Backordered items Report and registered them as Concurrent Programs.
• Converted oracle Seeded reports in Reports10g to XML reports.
• Designed and developed various PLSQL programs and registered them as concurrent programs to fetch the data and write to Comma Separated files in the predefined Server location. Utilized UTL_FILE Utility for writing data to the file in middle tier.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
• Customized the Accounts Payable Vendor Entry Form as per requirements
• Created new End User Layer (EUL) for Oracle Discoverer version 10g. Created business areas and folders based on SQL codes and Views. Administered security of Oracle application users and Responsibilities through Discoverer Administrator.
• Developed simple to Complex worksheets, pivot reports using Discoverer Plus and shared the workbooks with users and responsibilities.
• Modified Customer Validation Program in Receivables.
• Scheduled various concurrent programs and reports to run on a specified time daily without interfacing other standard programs using Sys Admin Responsibilities.
• Created an Oracle Alert that triggers whenever a new responsibility is added or there is a change in existing responsibility for the user accounts.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Utilized FND_LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities and Programs, Value Sets and others.
• Involved in iProcurement Requisitions Approval Workflow customization.
• Extensively worked on Production issues, and resolved various bugs working in collaboration with Oracle Support on Sev1 and Sev2 Service requests.

Environment: Oracle Apps Release R12 (12.1.3), Oracle Database (11g), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER

Confidential,Arlington, VA 12/2009-03/2011

Sr. Oracle EBS Consultant
Confidential,is an innovative financial services company offering a full suite of easy-to-use online brokerage, investing and related banking solutions, delivered at a competitive price. E*TRADE empower individuals to take control of their financial futures by providing the products, tools and services they need to meet their near- and long-term investing goals. The project is an upgrade from Oracle 11i to R12, basically working on conversions, interfaces and custom report development.
Responsibilities:

• Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.
• Work closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and conversions for eBusiness applications.
• Worked on form customizations in Purchasing, Inventory. Developed custom forms in Inventory, Engineering modules. Developed reports in Oracle Purchasing, Inventory, Order Management. Also customized a number of oracle seeded reports. Developed scripts for importing Items, Item revisions, Item categories, Default shipping/receiving subinventories and Bills of materials into Oracle.
• Worked on the Data Conversion using SQL*Loader to import legacy Suppliers in the PO Module.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices
• Used Auto Invoice Interface to import Standard Invoices from a Legacy system into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
• Customized the AR Invoice, Sales Tax Reports in Receivables.
• Customized the Auto Accounting and Auto Invoice Programs in Receivables.
• Converted Fixed Assets Data from Legacy System to Mass Additions Table using SQL Loader and developed programs for Conversion of Tax Data from flat Files to Tax Interface Tables
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL_FILE package at periodic intervals.
• Constructed Discoverer reports using custom business areas, and granting the access to the workbooks as per the responsibility restriction.
• Developed Custom Program to load freight tax exception data in Receivables.
• Developed various FSG Reports in GL, by creating column and row sets. Few of the include P/L reports cross ledgers, Balance Statements across periods and Fiscal years.
• Extensively worked on Migration and Testing of the Deliverables in different instances.
• Developed an Interface Program for updating the Item prices on Price Lists, based on the legacy flat file. Registered the process as concurrent program and scheduled it to run at regular intervals, automating the file handling.
• Developed Interface process for the Journals Import in GL, for Daily Journal processing from the legacy systems. Supported the program after implementing in production.
• Developed an Interface Program for loading large orders from flat files to Oracle Order Management Base tables. Customized the Order Import Process mapping the custom Price Lists in OM.
• Developed Order Import Error Report in OM, and Developed a Shell Program to send the report as an email.
• Imported Payments from legacy system into Oracle Receivables using Lockbox Interface. Involved in the process of splitting the bank file to feed Auto lockbox.
• Responsible for customizing reports and writing the reports with required specifications by using Oracle Reports 10g and also using XML Publisher.
• Responsible for the setup and configuration of Configurator.
• Involved in Process Mapping, Gap Analysis and Module design and implementation for iStore, iPayment and Configurator.
• Interacting with the ERP group and Websphere group to make sure that iStore, iPayment and Configurator integrate with all the related modules like Order Management, HTML Quoting, Receivables, Inventory, Bills of Materials and Work In Progress.
• Technical and functional consultant for iStore, Configurator.

Environment: Oracle Apps Release 11i (11.5.10.2)/R12.0.6, Oracle 10g SQL*Plus, SQL*Loader, Forms 10g, Shell Scripting, TOAD, Discoverer, XML Publisher, OA Frame Work, PVCS, HP-Unix

Confidential,TX, USA 01/2009-10/2009

Role: Oracle Apps Techno Functional Consultant
Confidential,offer a wide range of high quality wholesale dollar items and dollar store products. With ample and sufficient warehouse space, Pride has the ability to buy in bulk at better prices, and can focus on providing its customers with the highest of quality merchandise at the most competitive costs. The project is a support project, where in existing Oracle applications system is monitored and maintained for better product Yielding. Responsibilities included supporting Oracle Applications and to enhance productivity for Pride Products.
Responsibilities:

• Designed a complete solution to accept orders through the WEB. It included creation of various database objects along with logic for advanced pricing and discounting. Configured modifiers and Qualifiers as per the business requirements
• Involved in the support of complete Procure to Pay and Order to Cash cycles.
• Designed and created custom forms to maintain data required for the advanced pricing and discounting matrix.
• Worked on interfaces mentioned below
• Order Import interface program
• Payables Invoice Import interface program
• Item Import interface program
• Optimized, tuned and redesigned some of the existing processes to suit the changing requirements.
• Customized some of the AR repots, including invoice printing report, collector information and some aging reports.
• Involved in Registration of Concurrent Programs, Executables, Creation of Responsibilities, Request groups, Menus, Submenus, Values sets, Forms, Functions in System Administration & AOL.
• Involved in various activities like preparation of technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.
• Developed many reports from the scratch using BI/XML publisher. Converted some of the oracle seeded reports into XML Publisher Reports
• Lastly, being actively involved in all aspects of ongoing development and tried to come up with standard solutions.
• Created functional specifications for a custom program to create totals, features and options and to create rule folders.
• Technical and functional consultant for Oracle Configurator.
• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans.
• Designed and Developed an Extension for “Automated Configurator Testing”. Extension allows the super-user/tester submit their test cases using an Excel spreadsheet at any given time, location and see the test result without going through the usual process. Excel spread sheet will have the same choices as available in the Configurator User Interface, to create a look alike feel.
• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans.

Environment: Oracle Applications 11.5.9, Oracle 9i, Developer 2000 (Reports 6i and Forms 6i), HP-Unix, Windows XP, XML Publisher, Workflow Builder, SQL/PLSQL, AIX

Confidential,India 09/2007-11/2008

Role: Oracle Apps Developer
Responsibilities:

• Development of Oracle Applications based standard APIs and Interfaces to legacy systems, customizations of Interfaces, Development of reports and forms using Oracle Developer 2000 kit. SQL and PL/SQL based coding.
• Good knowledge and project experience of Oracle Sys admin, AOL is essential. Knowledge of Oracle Workflow builder and Oracle Account Generator is desirable.
• Develop various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.
• Involved in analysis, design and development task.
• Prepared functional and technical design document.
• Involved in importing and exporting project from one instance to another instance.
• Involved in importing and exporting data from one instance to another instance using Data mover
• Developed SQR programs to calculate time utilization.

Environment: Oracle Database 9i, Developer 2000, SQL, PL/SQL, Oracle Applications 11i, SC, Order Entry, Shipping & Pricing, AR, AP, GL, Inventory, Purchasing, Unix, Windows NT, Pro*C,

Confidential,Bangalore, India 02/2006-08/2007
Role: Oracle Apps Developer
Responsibilities:

• Set-up Inventory Organization in-line with the present requirements and taking into consideration the future business requirements of the enterprise.
• Creation of database Triggers on Interface tables in AP & AR modules.
• Defined the Inter-Organization Network for in-transit shipments, defined items, item status, and item-category. Defined sub-inventory, locators & assigned items to the sub-inventory.
• Developed functional design for new forms and developed ad hoc reports for functional users and end users.
• Set up of Pricing for Order Fulfillment based upon the items, their hierarchy etc., price lists, qualifiers, pricing attributes and calculation of prices using formulas.
• Interfaced Shipping Execution Ship Notice/Manifest for outbound data. Oracle Payables Invoice inbound data and Payment Orders / Remittance Advice outbound data with trading partners. Interfaced Purchase Orders and Purchase Order Change Request outbound data and Response to Request for Quotation inbound data with trading partners.
• Responsible for customizing reports and writing the reports with required specifications.
• Customizing the application forms to meet the specific business needs using built in features available with (Template.fmb) form, built-in stored procedures and attached libraries.
• Customized Order Entry module cycles, agreements, RMA’s and customer relationships.

Environment: Oracle Database 9i, Developer 2000, SQL, PL/SQL, Oracle Applications 11i, SC, Order Entry, Shipping & Pricing, AR, AP, GL, Inventory, Purchasing, Unix, Windows NT, Pro*C,