SUMMARY

• Over 7+ 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.
• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business suite P2P and O2C cycles.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), I-Expenses, I-Procurement
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Proven hands on experience in re-engineering of various RICEW objects as part of R12 upgradations/re-implementations and major business changes which impact existing custom objects such as forms, reports, interfaces, Oracle Alerts, workflows, interfaces, PLSQL API’s and OAF pages
• Experience working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities and SQL* Navigator.
• Quote-to-cash(or QTC or Q2C) is an information technology term for the integration and automated management of end-to-end business processes on the sell side Product Configuration
• Hands on Experience in implementing ADF Security to Oracle ADF web applications.
• Hands on experience in using OPM Inventory API’s as part OPM integration with other internal applications
• Extensive experience in migrating legacy applications to Oracle ADF Framework.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Expertise in application design development and deployment of Oracle ADF, Web Center, SOA, Java and J2EE Technologies
• Expertise in Oracle Service Oriented Architecture (SOA) with a strong focus on Oracle Service Bus (OSB)
• Created various routing rules inside the ESB process to control the flow of data to the appropriate and right service for further processing
• Good experience in Order-to-Cash, Procure-to-Pay and Inventory business process flows.
• Hands on experience in personalization and extensions of OAF frame works across P2P and O2C modules
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder.
• Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms).
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.

TECHNICAL SKILLS

ERP: Oracle E-business suite R12/11i/ 11.0.3/11.5.10.2 version Modules worked on: Accounts Payable (AP),(AP)AP SUPPLYERS, Accounts Receivable (AR), Oracle General Ledger (GL), Oracle Purchasing (PO), Order Management (OM), Shipping, Oracle Inventory (INV), I-Expenses, I-Procurement,Experience in administering and supporting Hyperion, Supply Chain Management, Order to Cash, OAF & ADF, GL Transfer, GL Journals, QTC or Q2C, Oracle EBS Techno-Functional Specialist (Oracle HCM - Core HR, OTM, OTL, OLM, Payroll; Oracle Financials - GL)

Languages: Java,J2EE,SQL, PL/SQL, C, C++

Databases: Oracle 8i, 9i, 10g, 11g MS Access, MYSQL

Others: PowerPoint, MS-Word, MS-Excel, MS-PowerPoint

Tools: Oracle - Developer 2000/6i, 10g (Forms, Reports), SOA, OSB 11g, Toad 6.0/8.0/9.0, Oracle Utilities, Oracle Workflow 2.6, XML reports

Operating Systems: Windows NT, Windows 95/98/2000/XP/7, HP UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle R12 EBS Developer

Responsibilities:

• Involved in Configuration/Setups in PO, AP and AR.
• Involved in development of Invoice Update history, purchasing and payment related reports (AP, PO).
• Setup Supplier Types, Pay Groups, Distribution Sets, Payment Documents, and new Payment Formats for core AP.
• Involved in the implementation of data conversions in AP module and customization of reports.
• Developed AP Expense Report interface to load the invoices from multiple sources like Legal Invoices, Quarterly Payroll, etc., into Accounts Payable in a periodic basis.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables (AR) according to Client Requirements.
• Creation of a custom ADF application, connecting to EBS database, web services API's
• Involved in documenting the business processes, requirements definition, and performed gap/fit analysis for General Ledger, Payables, and Purchasing modules.
• Developed brand outbound interfaces using PLSQL across P2P and SCM modules
• Worked on ADF Quick Search using Auto Suggest behaviour.
• Worked on simple and advanced search functionality in ADF.
• Implemented Oracle Service Bus (OSB) for messaging services, connecting to database and for creating proxy over existing web services
• Worked on PL/SQL packages which will be invoked from SOA layer to insert the data
• Developed a package for GL Interface that validates and imports journals to General Ledger.
• Implemented Event Alerts like to notify the GL manager that import is done and notifying the manager when a large journal has been entered.
• Involved in the customization of PO Approval Workflow.
• Customized PO reports, AP Check Print and Created many reports in Financial Modules of Cloud.
• Performed Data Conversions in Financials, Procurement (GL, PO, AP) in Oracle Cloud Applications.
• Inventory Plan configuration for OPM functionality
• During this project developed various RICEW object across Financials, SCM and MFG
• Created Reports, Analyses and BI Publisher reports in Oracle Cloud Applications.
• Developed SLA functions to change accounting string (Events Shipping FOB, Receiving, Intercompany transfers and more).
• Implementation and customization of Oracle Workflow Processes in the Oracle e-Business Suite.
• Worked on PL/SQL, Forms, Reports and Unix Shell Scripting.
• Developed programs using SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Added an vendor type lookup code in supplier register page using VO extension in OAF (Oracle Framework)page
• Migration of OPM setups and Inventory modules
• Responsible for implementing new features in Oracle E-Business Suite to enhance application architecture and performance.
• Developed an Interface Program to import customers, locations, customer’s sites and customer contacts by using the TCA API’s.
• Developed PL/SQL programs using TCA API’s to validate and import customers from legacy system into base tables.
• Developed interface to load Requisitions data corresponding to Bulk Supply Sales Orders to Oracle Purchasing using PL/SQL Packages and Procedures.
• Designed and developed custom Outbound Pricing Process for corporate customers using PL/SQL Packages.
• Worked extensively on various bug fixes in Reports 10g and Forms 10g.
• Involved in development of custom reports using Reports 10g and XML/BI Publisher.
• Involved in writing Technical Design Document (MD070) as per Oracle AIM Methodology.

Environment: Oracle Applications R12.1.3 (AP, PO, GL, INV), OPM Inventory, OPM costing, OPM Quality, Order to Cash, ADF 11g, Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential - Atlanta, GA

Senior Oracle R12 EBS Developer

Responsibilities:

• Involved in Conversion of AP Invoices, using SQL*Loader to load legacy open Invoices data in to the staging tables and PL/SQL Program to validate and load in to Payables Standard Tables.
• Developed Wells Fargo credit card transactions Inbound Interface for different card programs using Standard Programs to Validate & Load the data into ap credit card trxns all.
• These transactions are used by employees while creating an expense report. Payable invoice for Wells Fargo will also generated by the process.
• Customized the (Oracle Framework) OAF page using Controller extension as per the client requirement.
• Part of global re-implementation team and extensively worked on data conversion of master and transactional data (Suppliers, Customers, AP, AR, OM and Inventory)
• Modified/customized AP Invoice workflow using custom hook to meet the business requirements.
• Designed, developed and documented an inbound interface for AR Invoices.
• Personalized AP Invoice Form and FND Concurrent Request Screens to disable, validate and submit programs.
• Developed Transfer Rules and Open Inventory Balances Interfaces in OPM
• Developed custom interface and reconciliation report between oracle and Maximo, used for importing and reconciling purchase orders and receipts.
• Used CRON Jobs to submit the Concurrent programs and custom Interfaces as applicable
• Worked with Sabrix team to develop interface for implementing business requirement for Tax.
• Interacted with the end user during production support by helping them to develop user required reports and modify the existing as per the requirement.
• Migration of interfaces from GPRS systems (master items and formulas define tool) to CDOA, OPM (Routings, Formulas and version control) and Inventory.
• Performance tuning of the PL/SQL objects and report using DB links to interact with Maximo and other system.
• During this process I have used trace, TkProf and Explain plans for optimization.

Environment: Oracle Applications R12.1.3, 11.5.10.2 (AP, PO, AR, OM, GL, INV), Contracts, OM, INV, iExpenses, iProcurement, P2P, OPM Inventory, HCM,(OLM, OTM, OTL ) Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential - Atlanta, GA

Oracle EBS Developer

Responsibilities:

• Developed AP Invoice Interface to upload items into the Oracle Payables.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable (AR) by using Customer Interface.
• Involved in development of Invoice Update history, purchasing and payment related reports in AP.
• Worked on the customization of forms, which included development of new forms and customization of the existing forms in Account Payables (AP).
• Customized the Standard Receipt Batch Form in Accounting Receivables.
• Customized various Concurrent Programs and AR Aging Reports in Oracle Account Receivables.
• Designed and developed the conversion process for historical AR transactions into Receivables during the implementation process.
• Designed and developed a process to provide an Extract File at the end of each GL period with GL summary details of invoicing and cash activities for that period.
• Involved in entering journals and open and close month end process for GL.
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Developed Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script.
• Responsible for all Configuration setups & Testing related to Fixed Assets (Categories, Locations, Asset Key, FA Calendars, System Controls, FA Lookups).
• Developed OAF Controller & VO extensions in MSCA module to meet several business requirements.
• Developed code fixes for Oracle Warehouse Management WMS, MSCA and Conducted multi-step material routings.
• Contributed in the redesign/rewrite of PO Workflow approval customizations in R12.
• Customized and developed Oracle Forms/Reports, Workflow and Data Conversion in AP, AR, GL Project Modules.
• Primary responsibility for development and maintenance of reports, workflows and interfaces in Oracle Financials Projects modules during staged rollouts of E-Business Suite.
• Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
• Worked on Personalization of forms such as making fields mandatory, Validating fields using custom code in triggers.
• Worked extensively on the customization of Auditor Reports using BI/XML Publisher.
• Created new custom Self-service pages using Oracle Application Framework (OAF) in Oracle applications R12 and PL/SQL.
• Created a PL/SQL package to create and handle procedure and function which perform required actions in the backend.
• Developed many reports and designed to view output in different formats like PDF, EXCEL, RTF and HTML using BI/XML Publisher.
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms using Oracle Apps version R12.
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using TOAD.
• Involved in design of AIM (Application Implementation Methodology) documents (MD-50, MD-70) for all conversion and interfaces.

Environment: Oracle Applications R12.1.3, 11.5.10.2 (AP, Purchasing, AR, OM, GL, INV), SCM (O2C, Quote to Order, OM, INV, PO and P2P), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher, OAF & ADF

Confidential, Lexington.KY

Oracle EBS Developer

Responsibilities:

• Worked on SQL* Loader to load all the data given in flat files with various special characters and comma delimiters.
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• 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 into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed Discoverer Reports to get the employees information Period wise, monthly and yearly.
• Developed workbooks using Discoverer to develop custom reports for business analysis.
• Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.
• Developed new reports using Report Builder 9i and also customized seeded reports in purchasing (PO) module.
• As per the company requirements, created and implemented XML/BI Publisher reports for different products like PO, AP and GL.
• Creation of new custom reports using Oracle XML/BI Publisher.
• Developed AR Credit memo and AR Customers forms.
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.
• Developed technical design and test documents complying with Oracle AIM standards.

Environment: Oracle Applications R12, 11.5.10.2 (GL, AR, AP, Purchasing, OM, INV, BOM), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher, Discoverer

Confidential, Paoli, Pennsylvania

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically.
• Developed SQL Loader scripts to populate staging tables.
• Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.
• Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
• Part of the Implementation team for Order to Cash life cycle.
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Customized various transactions in Accounts Receivables (Invoices, Receipts, and Credit Memos and Debit Memos etc).
• Developed Code for Custom AP Invoice Import Program. This interface reads invoices from ASCII data file and loads the standard Oracle Payables invoice Interface tables.
• Involved in Performance tuning of various queries and stored procedures.
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
• Involved in Customization of Standard Trail balance Report using Reports builder as per the business Requirements.
• The integration of key business processes across the supply chain for stakeholders Supply Chain Management (SCM)
• Customized Inactive Item Report and Cancelled Sales Order Report.
• Extensively worked on Report Triggers and Formula Columns.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Developed various reports using Discoverer according to business needs.
• Created custom folders, item classes in Discoverer Administration, cross tab, page detail reports, conditions, parameters, sharing of workbooks in Desktop edition of 9i/10g.
• Developed Technical design document using AIM methodology.
• Used CUSTOM.PLL extensively to modify the functionality provided by standard forms according to client requirements and created custom forms using zoom functionality.
• Register generated reports, forms, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL*Plus scripts etc.
• Designed the frame work which would evaluate the details collected for customer instances and then generate various reports.
• Worked on Tuning of queries of the Custom Reports to improve the performance utilizing diagnostic tools (Explain Plan, TK Prof).

Environment: SCM, OM, INV, PO Oracle Applications 11i, Oracle9i, SQL*Loader, PL/SQL, TOAD, UNIX, Windows 2000, Reports 6i, Forms 6i/10g, Discoverer 10g,