SUMMARY

• Around 8+ years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS
• Strong experience on Supply Chain Management modules (specifically Order Management, Inventory, Purchasing, Install Base modules) and functional data
• Experience in technical and functional areas of Oracle Application Financials (AR, GL and AP), SCM (OM, WMS, INV and PO), Projects Accounting, iExpense and iProcurement modules.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Data Conversions and Extensions/Customization) using SQL, PL/SQL, UNIX Shell scripts and SQL*Loader, TOAD, PUTTY.
• Good knowledge of business flows like Order-to-Cash (O2C) and Procure-to-Pay (P2P) along with the dependencies and relationships between Oracle Applications modules.
• Proficiency with tools used to support Oracle Applications development including Forms, Reports, and XML Publisher.
• Developed multiple complicated XML Publisher reports, used features like XML bursting and conversant with XSLT syntaxes, conditional formatting etc.
• Experience using workflow components like Workflow Builder, Workflow Engine, and Workflow Monitor.
• Configuring the application based on solution design, performed gap analysis and designed workaround solutions.
• Excellent knowledge on Functional Analysis and Implementation, Techno/Functional analysis on Interfaces/Legacy conversions, Views, Reports.
• Brief knowledge on AIM documents like MD050, MD070 and MD120.
• Especially on Design and Development of Technical Specifications (MD70) based on functional Specifications (MD50), Preparation of Unit Test Cases (TE30) and Installation (MD120) Documents.
• Expertise in process/data flow, base tables, interface tables and standard APIs.
• Proficient in registering Concurrent Programs, Form, Functions, Tables, developing Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library (AOL), System Administration and Documentation in Oracle Applications.
• Hands on expertise knowledge in Oracle Back-end (server-side) PL/SQL Development using SQL*Loader, SQL developer and Toad as development tools. Created and maintained Database objects.
• Hands-on experience in Data Conversion, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Worked in projects that involved fine tuning of queries for faster retrieval of data and involved in resolving various Troubleshoot issues.
• Documented BR100 and applied configuration forCreditManagement, Advanced Collections and Receivables

TECHNICAL SKILLS

Enterprise Applications: Oracle E-Business Suite R12, 11.5.4 to 11.5.10.

ERP/Modules: Oracle SCM (OM, INV, BOM, WIP, PO), Oracle Financials (GL, AR, AP, FA, CM), AOL, Sys. Admin, iExpense and iProcurement modules

Programming Languages: SQL, PL/SQL, C, C++, HTML

Development Tools: Reports 9i/10g, Forms 9i/10g, Discoverer 10g/4i, Developer 2000, Developer Suite 10g, XML/BI Publisher, Oracle Web Application Server 4.0.8, Oracle Enterprise Manager(OEM) (2.1.0), application deployement automation ( UDeploy),Power BI

Database: Oracle 9i/10g/11g

Tools: TOAD, SQL*PLUS, SQL* Loader, SQL developer, PUTTY

Operating System: Windows 98/2000/XP/, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Oracle Apps Techno Functional Developer

Responsibilities:

• This project includes working with Oracle Applications R12 (12.1.3) in implementation and enhancements team in Order Management, Accounts Receivables (AR), General Ledger (GL), Channel Revenue Management(CRM), Warehouse Management Shipping(WMS)
• Working on Account Restructure Process for all the Starkey clients which includes two main projects (Party Merge and Account Merge) on a large scale.
• Involved with the compensation plan design, development, configuration and code migration to production. In addition to creating and setup test environments ofOracleE-BusinessSuite for Account Merge Process.
• Worked on Organization setups, workflow hierarchy changes for business user for AR set ups
• Co- Ordinated the supporting tools with Oracle like Customer First and E-store for sync of data which is merged with all the relationships between the accounts intact.
• Worked on the scripts for initial account merge analysis to decide the survivor account into which all the related accounts are to be merged using GAP analysis.
• Gathered requirements and worked on bug fixing Account Maintenance Form(Custom form for Standard Oracle Customer Form ) restructure with new updates after the merge process
• Currently working on post live production support of the party merge process which is an ongoing project to merge over 50000 accounts.
• Developed around 6 custom XML BI Publisher reports in Receivables, Order Management and Credit Management modules.
• Worked on conversions from legacy systems to Oracle and bug fixes for the changes made as part of conversions.
• Worked on performance tuning of complicated sql statements to increase the efficiency of order process in production
• Worked on creating, enhancement and implementation of merging highly sensitive accounts of the business without much changes at various stages of TCA architectural level.
• Worked on last leg of integration of company’s highly sensitive project called “Phoenix Program” which is basically an Integration from Mainframe to Oracle systems
• Worked on post productions P1, P2 bugs and fixes after Integration.
• Customized the XML publisher Template for Standard Credit Hold Report.
• Developed Oracle E-Business Suite using PL/SQL, SQL*Plus, Workflow Builder, Application Object Library, Forms and Reports.
• Development of custom XML publisher and RDF reports in Purchasing (PO) and in Account Payable (AP), Account Receivables (AR) and Order Management (OM) modules for comparing data and inventory.
• Worked on creating XML reports and conversions certificated for Battery Futures Program using mainly Order Management, Inventory and Install Base modules.
• Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions in database tier
• Developed complex PL/SQL packages for the interface set up and concurrent programs for the flow of the Account set up requirements and transactions.
• Developed complex custom PL/SQL integration programs to ADD, EDIT and Update configurations in all oracle modules as per the requirements.
• Worked on creating SQL queries for analysts for analyzing data related to pricing and agreements of the current account structure in Starkey.
• Worked on creating various Values Sets as part of various conversion, integration and development activities and also in concurrent programs.
• Fixed Oracle Reports after party merge to enhance the report data for Month End, Statements and Invoice generation analysis.
• Worked on changing the payload sent from Oracle to Manufacturing Suite as part of conversion of data from Mainframes to Oracle.
• Worked on creating data flow from Oracle to BHOOMI regarding trail balance data generated in Oracle (both YTD and PYTD sales)
• Worked on correcting Starkey in-house banking request triggers to restrict the update for certail distribution lists across the business distribution lists.

Environment: Oracle e-Business Suite 12.1.3, Oracle Financials (AR, AP, GL, CRM), Oracle SCM (OM, INV, IB), PL/SQL Developer, Oracle SQL Developer, SQL Navigator,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader, SQL Plus, CRM tools, Manufacturing Suite

Confidential, Atlanta, GA

Sr. Oracle ERP Developer/ Techno Functional Consultant

Responsibilities:

• Worked on application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.
• Worked on Organization setups, workflow hierarchy changes for business user for requisitions and purchase order flows.
• Responsible for doing the gap analysis based on the customer's requirement.
• Worked as production support for project (HUM) in IT operations and handled issues post go-live and involved in user training sessions.
• Worked on the launch of company’s priced project HUM and also an updated version HUM Pro
• Responsible for Order Management and Customer setups in various instances, analyzing the Business Requirement Design as per the requirements suggested by the business and wrote required High Level Designs. Involved in reviewing technical design and functional testing of Custom OMS-Order Import Interface, system integration testing (SIT, JIT) and user acceptance testing (UAT) and pre-production instances.
• Worked on Month end closures for inventory and General Ledger and related issues regarding layer cost worked and journal import.
• Worked on the functional specification of Customer Import Interface Program.
• This interface picks up customer data from staging table and validates if the customer already exists in system. If not, it creates customer, customer sites and site uses (BILL TO/SHIP TO).
• Written functional specification for Order Import Interface Program.
• This interface picks up Auction Sales Orders data from staging table and creates Sales Orders. While creating Sales Orders, it verifies whether the inventory is sufficient to fulfill the Order.
• Hands on knowledge in on- going upgrade project from Oracle EBS 11.0.6 to 12 C
• Worked and implemented requirements related to Order to Cash (O2C) and Procure to pay (P2P) modules.
• Maintained BR 100 which had setups for customer class, profile class, document sequencing, payment types transaction types, value sets and various profile options.
• Gather requirements and worked on the functional specification and functional test scenarios for Customer Conversion, Price List Conversion, Sales Order Conversion and Project Expenditure Conversion.
• Developed complex PL/SQL packages for the interface set up and concurrent programs for the flow of the order shipments.
• Developed complex custom PL/SQL integration programs to ADD, EDIT and Update configurations in Oracle Quotes
• Managing defects during post production support and assigning defects to appropriate resources both Onsite and Offshore.
• Created web service on a custom PL/SQL package using Integrated SOA Gateway.
• Customized the XML publisher Template for Sales Order Acknowledgement Report.
• Developed Oracle E-Business Suite using PL/SQL, SQL*Plus, Workflow Builder, Application Object Library, Forms and Reports.
• Development of custom XML publisher and RDF reports in Purchasing (PO) and in Account Payable (AP) modules for comparing data and inventory.
• Technically proficient in writing Procedures, Packages, Functions, Triggers, views, records, constraints, synonyms, indexes and other database objects using SQL and PL/SQL for validating the data loads.
• Developed Error-Handling package using PL/SQL tables to handle user-defined errors.
• Tuning the SQL statements for optimal performance.

Environment: Oracle e-Business Suite 12.1.3, Oracle SCM (OM, INV, BOM, WIP, PO), Oracle Financials (GL, ARCM), Supply Chain Planning instance, PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader., EDI (IBM Sterling Integrator)

Confidential, Las Vegas, NV

Oracle Apps Techno Functional Consultant

Responsibilities:

• This project includes working with Oracle Applications R12 (12.1.3) in implementation and enhancements team in Accounts Payables (AP), Purchase Order (PO), EB Tax, General Ledger (GL), iExpenses and iProcurement modules, Warehouse Management Shipping(WMS).
• Created intercompany transaction, consolidation, elimination of entries setups and configuration for use in general ledger.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Coordinated with business users and IT, in developing new solutions based on gap analysis
• Reviewed and approved any configuration change documentation for General Ledger (GL), Cash Management (CM), Accounting Receivables (AR) and Accounting Payables (AP).
• Gathered requirements and created Functional Designs for the Technical Staff to develop customization for theOracleR12 Incentive Compensation module.
• Created conversion rules from existing databases and use TOAD for SQL queries to ensure data attributes were transferred correctly.
• Completed the configuration and set-up procedures to define Classification Rulesets, Descriptive Flex Felds and activate Pay Periods.
• Involved in setting up Descriptive Flex fields and mapping of Costing fields with Oracle financial.
• Extensively used FND APIs like FND FILE, FND SUBMIT, FND MESSAGE, FND PROFILE, FND PROGRAM and FND REQUEST.
• Customized the functional areas of Financial Management System using Forms 10g. Designed and developed various custom packages, triggers and forms.
• Used SQL trace facility and TKPROF accurately to assess the efficiency of the SQL statements when application runs & used tools with EXPLAIN PLAN.
• Developed Employee Interface where the data will be extracted from other system through DB link.
• Undertook performance-tuning activities on the Oracle EBS applications, concurrent manager and with exceptions in database tier

Environment: Oracle e-Business Suite 12.1.3, Oracle Financials (GL, AR, AP, CM), Supply Chain Planning instance, EB Tax, iExpenses, iProcurement modules, PL/SQL Developer, Toad,Oracle Workflows, Oracle Forms, Oracle Reports, Data Loader, SQL loader.

Confidential, Union, NJ

Oracle Apps Techno-Functional Consultant

Responsibilities:

• This project includes working in the up gradation of Oracle (11.5.10.2) to R(12.1.3 along with using Oracle Applications R12 (12.1.3) on rebuilding the Interfaces and Customizations on Account Payables and purchasing modules and also on designing and development of custom interfaces on the Oracle AP and Oracle AR, AdvancedCollectionsand Cash Management.
• Worked on rebuilding the Interfaces and Customizations on Account Payables and purchasing modules.
• Analysis and design strategy for conversion of Legacy Data into Oracle R12 Project Accounting (PA) module.
• As an Oracle Techno Functional consultant responsible for Enhancements and Production support of RICE components in GL, SLA, AP, PO and AR with Oracle BI / XML Publisher Reports.
• Drafted technical design document for Credit card conversion from 11i to R12.
• Performed several setups in Inventory (INV), Order Management (OM) and Shipping modules.
• Worked on testing the flow of Order to Cash and Procure to Pay cycles.
• Customized several oracle standard forms using CUSTOM.PLL and Forms Personalization.
• Validation and code fixing of all database objects in Oracle Applications 11i INV, PO modules.
• Involved in enhancement of the existing system by developing new forms for the system and integrating them with existing modules.
• Experience inHCMData Loader Automation/FBL Automation
• Worked on OracleeBusiness Suite (eBS) modules such as HR, Employee Self-Service
• Time and Labor and related application/infrastructure software needed to support theOracleeBusiness HRMS Modules.
• Frequently worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Used Forms Personalization created a special trigger in sales order for booking according to user requirement
• Extensively worked on Workflow builder in AR and developed a new workflow to send notifications.
• Customized standard Oracle Reports by adding extra field or extra parameter to sort data in a report for Manufacturing and Financial Modules.
• Created and customized output format in XML, new templates for XML Publisher to display the reports in client requirement format.
• Customized XML publisher report for AR Invoice in the client specified layout.
• Developed reports and data extracts in OM, WSH, INV and AR.
• Worked on oracle standard API using PL/SQL in Order Management and advanced pricing modules.
• Developed Finance Reports like: Comparative Sales Report, Daily Sales Report using Discoverer Admin, Discoverer Desktop and Discoverer Viewer.
• Developed programs to load data from intermediate tables into BOM Interface tables.
• Expertise in writing PL/SQL packages for Creating and managing customers using TCA (Trading Community Architecture) in AR.
• Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs.
• Developed SQL queries to compare summary information of the standard and custom reports in Order Management, Inventory, Receivables

Environment: Oracle Applications EBS 10g/11.5.10/R12 (AR, AP, PO, OM, INV), Reports 6i/10g/11i, Forms 6i/10g/11i, SQL* Loader, OAF, Discoverer, PL/SQL, Workflow builder 2.6, XML publisher, TOAD, Windows XP.

Confidential, Charlotte, NC

Oracle Apps Technical Consultant

Responsibilities:

• Design of documents and guides for new users of Oracle Financials R11i (GL, AP, AR, FA, PO)
• Developed conversion programs for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables.
• Used Auto invoice Master Program to load the interface table data into Oracle AR base tables.
• Involved in user meetings to gather requirements for Compensation Plan changes.
• Developed a custom wrapper program (Inbound Interface) to validate and import the legacy Open AR Receipts data into Oracle base tables using standard API.
• Involved in development of TCA Customer Conversion program which includes data validation and API calls.
• Analyzed the source data and created Mockup report and data mapping sheet with the used attributes in plans.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Worked on Auto invoice interface to load invoices automatically from legacy systems to Oracle Receivables interface tables.
• Designed and Developed packages for Journal Import Interface to import journals information into the system.
• Designed and developed Compensation Plans along with Plan Elements, Formulas, Expressions and Rate Tables to calculate the Commission and Bonus for policy sales force.
• Helped the Data Store team to load new and prior period transactions and new sales categories.
• Customization of PO Requisition Approval workflow to send FYI email notification to the CFO based on the requisition amount.
• Sending Commission statements and Trends to individual reps through email as an attachment using UNIX shell scripting.
• Developed various customized PL/SQL packages, Functions for data validation perspective and used in the Expressions of the Formula.
• Generated weekly/monthly Reports using Discoverer for Department wise Payments to vendors.
• Extensively worked in tuning the Oracle Database queries using Indexes, Explain Plan, Optimizer Hints, and SQL Trace for high efficiency.
• Prepared Unit Test Cases and User Manuals to help business for future reference.
• Prepared and reviewed launch doc for migrating related components for deployment.
• Interacted with the users to resolve any issues during all the phases of the project.

Environment: Oracle 11g, Oracle APPS-12i (OIC, CRM), XML Publisher report, Oracle Report 10g, Style Sheet, Shell Scripts, SQL*LOADER, UNIX, TOAD,AIM

Confidential

Oracle Business Analyst

Responsibilities:

• Developed WIP open Move Transaction Interface to load data from external data collection devices (like Manufacturing Execution Systems, Automated Test Equipment).
• Worked on Open Resource Transaction Interface to load resource transaction information into the oracle WIP from external source.
• The Cost Manager is launched to load the data in interface table into oracle WIP base tables.
• Defined Transaction Types, Auto Invoice process, Auto Accounting and Auto Lock box in Receivables.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables
• Worked on Payables Standard Invoice Interface to import Invoices data into Oracle AP base tables. Various validations are performed on the staging table data.
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Worked on INV in defining a New Item in inventory, increasing the On-Hand Quantity. Involved in defining the Price List.
• Imported BOM’s and Routings from legacy system into oracle Bill of Materials (BOM) using standard BOM and Routing Interface program.
• Used Purchasing Document Open Interface program to load the data into Oracle base tables.
• Involved in customization of Standard Oracle Reports in Purchasing (PO) and Order Management (OM) as per client requirement, using Oracle Reports and XML/BI Publisher.
• Involved in customization of schedule order form and moved Promise Date from one canvas to another, using Oracle Forms.
• Involved in customization of Standard Oracle Reports in Purchasing and Order Management as per client requirement, using Oracle Reports.
• Supported my team lead in interacting with functional leads, technical lead and data management team in order to document the technical and development specifications using standard AIM documents like MD070, CV060, MD120 and resolve certain data requirement issues.

Environment: Oracle Applications R12, 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory, Purchase Order Oracle 9i, Discoverer 10g, MS Access 7.0, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i/10g, Forms 6i/10g, UNIX.