SUMMARY

• An industrious and motivated Oracle Applications Techno Functional Consultant, with over 7 + years of proven expertise in design, development and code optimization as Oracle Developer and experience in Software Lifecycle Development of Oracle Applications, Development, Testing and Implementation.
• Expertise in oracle core application such as registration of Custom applications, registration of Forms and Reports, Interfaces, Value Sets, Menus Registration of Custom Menus and Responsibilities.
• Strong knowledge on O2C (order to cash), P2P (procure to pay) transactional flows and drop ship processes with experience in related setups.
• Proficient in designing and building process for data flow of RICEW (Reports, Interface, Conversions, Extensions and workflows) utilizing: SQL Loader, UTL FILE utilities, staging data, and interfacing using APIs and Oracle standard interface process.
• Proficient in creating database objects like Tables, views, functions, PL/SQL Packages, Stored Procedures, APIs, Indexes, Functions, Database Triggers, Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling, SQL * Loader scripts and UNIX shell scripting to automate the execution of the batch processes.
• Experience with internet modules including iSupplier, iProcurement, iExpenses and iReceivables and well versed with FNDLOAD utility to migrate concurrent programs, request sets, value sets and other AOL Objects between various application instances.
• Experience in Functional/Technical Knowledge in Oracle Applications with Distribution and Supply Chain Modules like (OM - Order Management, PO-Purchasing, INV-Inventory, WSH-Shipping) Financial modules like (AP-Oracle Payables, AR-Oracle Receivables, GL-General Ledger)
• Worked on developing OAF pages, Customizations, Personalization's and Extensions of View Objects and Controller Objects and hands on experience in using UNIX and Shell commands to create jobs, automate processes.
• Strong exposure on Trading Community Architecture (TCA) and multi-org in 11i and R12.
• Excellent skills in Oracle 9i,10g,11g environments using SQL,PL/SQL, Oracle Forms Builder 6i/10g and Reports Builder 6i/10g and experience in Designing and developing reports using XML/BI Publisher.
• Tuning of customized application including reports and backend customization by using different application tuning techniques like EXPLAIN PLAN, SQL*TRACE, TKPROF, HINTS, DBMS PROFILER etc.
• Possess strong technical skills and business knowledge coupled with product knowledge in Oracle E-Business Suite.
• Proficient in using Oracle Reports 6i/9i/10g and Forms 6i/9i/10g for both development and customizations as per client system design specifications.
• Experience in various development tools like SQL Developer, SQL*Loader, TOAD, WINSCP, PUTTY.
• Worked in designing various Technical and Functional Documents like MD50, MD070, MD120 and Conversion Mapping documents like CV040, CV060 using AIM Methodology. Profound experience in unit testing, Integrating and User acceptance testing activities.
• Having good experience in developing custom objects in Application Object Library (AOL), like Executables, Concurrent programs, Profiles, Value sets, Descriptive Flex Fields, Custom menus, functions, responsibilities, request sets.
• Interact with people at all levels and Possess excellent communication and problem solving skills, and work ethics.
• Expertise in Requirements gathering, application technical design, documentation and unit testing of custom module components.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 11i(11.0.3,11.5.9,11.5.10.2), R12(12.0.4, 12.0.6, 12.1.3)Purchasing (PO), Accounts Payable (AP), Account Receivable (AR), Order Management(OM), Inventory (INV), General Ledger, SLA, EBTAX, iExpenses, Sourcing, iSupplier, iProcurement, Shipping, Advanced Pricing, Application Object Library(AOL), Approval Management (AME), Workflow Administration.

Languages: SQL, PL/SQL, UNIX, C, C++, Core Java, XML, HTML

Oracle Development Tools: Toad, SQL Developer, Putty, SQL*PLUS

GUI Tools: Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i, XML(BI) Publisher, Workflow Builder, Discoverer

Operating Systems: Windows (XP,7,8), Unix, Sun Solaris, Linux

Oracle Utilities: SQL Loader, UTL FILE, DBMS Utilities, TKPROF, WINSCP etc.

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Created new SQL*Loader Scripts to load CSV file data into staging tables and perform Validation of the data by calling Custom Packages/procedures.
• Used standard Oracle API to import AR receipts from legacy system into Oracle tables.
• Worked on Implementation and production support to Oracle Accounts Payable (AP), Purchasing (PO), Fixed Assets (FA) and Inventory (INV) modules.
• Analyzed the requirements, performing risk analysis for mapping the business processes. Understanding the gaps, recommended the necessary customizations.
• Worked on the Auto Lockbox in receivables that automatically creates receipts using the electronic information that the bank provides.
• Worked on creating a custom master/detail form to check history of a serialized item.
• Worked extensively on registering Concurrent Programs, defined Executables, custom value sets and creating Request sets and other Program setups.
• Customized reports Customer Open Balance Letter Report in Accounts Receivable (AR) module using oracle reports 9i.
• Customized the report Invoice Purchase History Report in Purchasing (PO) Module according to the business requirements.
• Involved in creation of setup documents and gap analysis.
• Worked on GL interface to import journals from legacy systems into GL interface tables.
• Defined Transaction Type, Payment terms and invoicing rule setups and invoice, receipt related setups in AR.
• Developed Test scripts for all finance modules, for performing Regression and UAT testing.
• Created Korn Shell scripts which act as a wrapper for various tasks like - for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Created SQL scripts to create database objects like tables, views, synonyms and sequences.
• Extensively worked on Multi Organization structure, MRC (Multiple Reporting Currencies), MOAC (Multi Org Access Control), TCA (Trading Community Architecture) and RBAC (Role Based Access Control).
• Involved in post-production support and enhancements of RICE objects in all three phases of project.
• Responsible for extensive data validations, feeding of live data and user acceptance for each module.
• Overseeing project implementation and process changes.
• Developed Custom PO requisition import program to validate and insert data in PO requisition interface table and call the Requisition IMPORT program.
• Created a custom report to list all the item import validation or standard errors with corresponding custom Error codes.
• Developed packages containing different procedures and functions using PL/SQL.

Environment: Oracle Apps 11i/R12, AR, AP, FA, PO, INV AOL, Oracle 9i/10g, TOAD, PL/SQL, SQL*LOADER, Reports 6i/10g.

Confidential, Phoenix, AZ

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Organize all procurement activities relating to request for proposals, sealed bids, and price quotes.
• Coordinate and schedule meetings and appointments as requested; respond to inquiries which do not require the personal attention of the Procurement Specialist.
• Worked for designing and developing integrations for Oracle EBS.
• Correspond with vendors regarding prices, product availability, and delivery.
• Actively participate in the design, development and maintenance of interfaces to and from the Work closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and conversions for E-Business applications.
• Involved in the support of complete Procure to Pay and Order to Cash cycles.
• Propose business process improvements based on industry best practices using the oracle applications Order to Cash cycle.
• Configure oracle applications 11i for OM and AR within the “Order to Cash” business process.
• Develop and support Order to Cash processes (Order Management, Credit and Collections, Accounts Receivable and Channel Data Processing (e.g., rebates, channel inventor, POS).
• 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.
• 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
• Perform general clerical duties such as maintaining general files, typing, data entry, opening mail, and completing and processing standard purchasing forms.
• Maintain and update professional library publications.
• Evaluate business requirements propose alternatives and implement functional solutions within the oracle modules i.e. Order to Cash and Procure to Pay modules.
• Have strong experience in modules like Order Management, Inventory, Receivables, Order-to-Cash cycle, Procurement, Pricing, Purchasing, Project Costing and worked on API's.
• Extensively worked on Production issues, and resolved various bugs working in collaboration with Oracle Support on Sev1 and Sev2 Service requests.
• Process requisitions into purchase orders using BUYSPEED and any resulting change orders.
• Receive, open, screen, log and date stamps bid responses/quotations, mail as required and organize bids for review by the specialist.

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, Boston, MA

Sr. Oracle Apps Technical consultant

Responsibilities:

• Extensively worked on Migration and Testing of the Deliverables in different instances.
• 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
• Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.
• 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.
• 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.
• Customized the AR Invoice, Sales Tax Reports in Receivables.
• Work closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and conversions for eBusiness applications.
• 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.
• 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.
• 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.
• Constructed Discoverer reports using custom business areas, and granting the access to the workbooks as per the responsibility restriction.
• Responsible for the setup and configuration of Configurator.
• Involved in Process Mapping, Gap Analysis and Module design and implementation for iPayment and Configurator.
• 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 Custom Program to load freight tax exception data in Receivables.
• 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 sub inventories and Bills of materials into Oracle.
• Interacting with the ERP group and Web sphere group to make sure that 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 Configurator.
• Customized the Auto Accounting and Auto Invoice Programs in Receivables.
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals.
• 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.
• Worked on the Data Conversion using SQL*Loader to import legacy Suppliers in the PO Module.

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

Oracle Apps Technical Consultant

Responsibilities:

• Conducted Oracle applications System Administration duties including Defining users, Assigning Responsibilities and Defining Menus.
• Preparation of technical specifications from the functional specifications received from the functional team, technical design using AIM methodology.
• Form customization to customize the Customer Site form to make a field mandatory for a specific org-id and optional for other org-ids.
• Involved in unit testing and fixing the problem that occurred in UAT (User Acceptance Testing).
• Oracle Projects and tasks conversion.
• RMA conversion to transfer all Return Orders and Lines from external Source to Oracle using Sales Order API.
• Converted standard reports into BI Publisher Reports.
• Used FNDLOAD to move the AOL objects from one instance to other instance.
• Developing conversion programs and reports that are registered as concurrent programs and which are run from SRS form.
• Supported the CRPs, SIT and go-live activities.
• Worked on Order Import in Order Management (OM), Purchase Order conversions for PO.
• Involved in Personalizing the Custom OAF page.
• Created logical and physical database objects - tables, indexes, referential integrity constraints, and triggers to development needs.
• Responsible for custom program maintenance during the production support.
• Writing custom packages to develop conversion programs.
• Registered Concurrent program executable, defined concurrent programs attached to request groups and attaching request groups to responsibilities.
• Involved in data validation and data reconciliation and tracked the defects using Rational Quality Manager.
• Interacted with end users to gather requirements and Draft specifications during development Phase.
• Worked on interface tables of purchasing to update purchase order line details and wrote PL/SQL codes to validate data and used concurrent program to load the data into base tables.

Environment: Oracle Applications(EBS) 11.5.10.2 Financials(GL, AP, AR,FA), Supply Chain Management(PO, INV, OM), TCA, BI Publisher, Discoverer, Oracle 10g, Forms Builder 6i, Forms Personalization, Unix, TOAD, SQL*Loader.

Confidential

Oracle Applications Developer

Responsibilities:

• Designed and Developed Payables Open Interface to validate and import Invoice information into the Payables Interface tables and into the Payables base tables using Payables Open Interface Import.
• Worked on complete setups of Order to Cash life cycle.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Used SQL*Loader and PL/SQL package to import invoice data into Interface table in Accounts Receivables and by using Auto Invoice Master Interface transferred data into Oracle Receivables.
• Workflow:
• Customized workflow for customer credit check in order entry process of Oracle Order Management.
• Developed PL/SQL procedures for conversion of items using the open items import program.
• Involved in setups of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.
• Created Direct Margin Report, Fleet Expense Report, GL Inventory Reconciliation report, GL Variance by account, Trial Balance by account, Trial Balance by Departments reports, Detailed Trial balance Report, Trial balance-by account Report using Oracle Discoverer.
• Developed a custom program in order to validate and load the data from staging tables into Vendor tables, which is a three step process in which the 1st phase is to load all the vendors and the 2nd phase is to load all the vendor Sites and 3rd phase is loading all the vendor contacts with the of Supplier, Supplier Sites & Supplier Contact Conversions in AP.
• Oracle Reports:
• Developed and customized Oracle seeded reports in Order Management and Shipping. Reports were generated for Pick Slip, Pack Slip, Purchase Order and Shipping Label.
• Customized Invoice on Hold Report in Payables module according to user requirement.
• Customized the Customer order backlog report.
• Involved in modification of Credit Memo Transactions form in AR module. The transactions form was customized to make the reason field mandatory using CUSTOM.PLL.
• Extensively used FNDLOAD utility to migrate concurrent programs, request sets, value sets etc.
• Developed UNIX scripts to extract data and dump it into files and send e-mail report.
• Developed PL/SQL Procedures using Oracle Provided Standard API’s to update tables.
• As a Techno Functional Consultant, Involved in the preparation of MD050, MD070 documents using AIM methodology.

Environment: Oracle Apps 11.5.10.2(EBS), OM, AR, AP, GL, PO, INV, Advanced Pricing (QP), TOAD, Oracle Reports 6i, Oracle Forms 6i, SQL* Plus, SQL*Loader, Workflow Builder 2.6, SQL, PL/SQL.