SUMMARY

• Over 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.
• 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 wif major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), me-Expenses, me-Procurement
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Extensively experienced in Oracle PL/SQL Development me.e. Stored Procedures, Packages, Functions & Triggers.
• 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 teh integration and automated management of end-to-end business processes on teh sell side Product Configuration
• Hands on Experience in implementing ADF Security to Oracle ADF web 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) wif a strong focus on Oracle Service Bus (OSB)
• Created various routing rules inside teh ESB process to control teh flow of data to teh appropriateand right service for further processing
• Proficiency wif 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 wif 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), me-Expenses, me-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, Totowa, NJ

Oracle Apps Technical 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 teh implementation of data conversions in AP module and customization of reports.
• Developed AP Expense Report interface to load teh 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 teh business processes, requirements definition, and performed gap/fit analysis for General Ledger, Payables, and Purchasing 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 teh data
• Developed a package for GL Interface dat validates and imports journals to General Ledger.
• Implemented Event Alerts like to notify teh GL manager dat import is done and notifying teh manager when a large journal has been entered.
• Developed an interface to upload teh GL journal data into teh Oracle Application's General Ledger, developed a PL/SQL procedure, which transfers data to interface tables after performing necessary business validation.
• Involved in teh 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.
• 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 teh 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 wif knowledge in Unix Shell Scripting.
• 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 teh 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), ADF 11g, Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher

Confidential - Atlanta, GA

Oracle Apps Technical Developer

Responsibilities:

• Involved in Conversion of AP Invoices, using SQL*Loader to load legacy open Invoices data in to teh staging tables and PL/SQL Program to validate and load in to Payables Standard Tables.
• Designed process to convert Open PO’s from legacy systems and developed validation logic to make sure PO’s are imported wif Approved status. Handled un-received and partially received PO conversion as per business requirement.
• Automated custom Data Cleansing packages to normalize, cleanse, validate, extract, de-duplicate and interface teh legacy Supplier, Customer and Open AR Transactions data into teh pre-staging tables of Oracle custom conversion programs.
• Developed Wells Fargo credit card transactions Inbound Interface for different card programs using Standard Programs to Validate & Load teh 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 teh process.
• 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 teh interface table data into Oracle AR base tables
• Modified/customized AP Invoice workflow using custom hook to meet teh 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 custom reports like invoice prepayment report, undistributed liability report/extract, un-invoiced receipts report to meet teh business requirements using XML Publisher (BI Publisher).
• Developed custom interface and reconciliation report between oracle and Maximo, used for importing and reconciling purchase orders and receipts.
• Good Functional knowledge on Oracle Human Capital Management modules like Core HR, Self Service HR, Learning Management (OLM), Talent Management (OTM), Time and Labor (OTL)
• Used CRON Jobs to submit teh Concurrent programs and custom Interfaces as applicable
• Worked wif Sabrix team to develop interface for implementing business requirement for Tax.
• Interacted wif teh end user during production support by halping them to develop user required reports and modify teh existing as per teh requirement.
• Performance tuning of teh PL/SQL objects and report using DB links to interact wif Maximo and other system. During this process me has used trace, TkProf and Explain plans for optimization.

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

Confidential - Atlanta, GA

Oracle Apps Technical Developer

Responsibilities:

• Developed AP Invoice Interface to upload items into teh 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 teh customization of forms, which included development of new forms and customization of teh existing forms in Account Payables (AP).
• Involved in customization of several standard reports to serve important business processes very specific to teh client which include Invoice on hold report, vendor, payments, and analysis reports in AP.
• Customized teh Standard Receipt Batch Form in Accounting Receivables.
• Customized various Concurrent Programs and AR Aging Reports in Oracle Account Receivables.
• Designed and developed teh conversion process for historical AR transactions into Receivables during teh implementation process.
• Designed and developed a process to provide an Extract File at teh end of each GL period wif GL summary details of invoicing and cash activities for dat period.
• Involved in entering journals and open and close month end process for GL.
• Defined currency translation, conversion, revaluation and set teh profile options for GL.
• Developed Extracts in GL and AR modules and teh extracted files are sent via FTP to other systems using teh 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 teh 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 teh data in teh same or different system.
• Worked on Personalization of forms such as making fields mandatory, Validating fields using custom code in triggers.
• Worked extensively on teh 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 teh 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 teh Customizations and Extensions done on teh Oracle reports, Oracle forms using Oracle Apps version R12.
• Involved in performance tuning of various packages and reports and done code fixes to improve teh 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), Reports 9i/10g, Forms 9i/10g, Oracle 10g, SQL*Loader, Toad, Workflow, UNIX, XML Publisher, OAF & ADF

Confidential, Lexington.KY

Oracle Apps Technical Developer

Responsibilities:

• Worked on SQL* Loader to load all teh data given in flat files wif various special characters and comma delimiters.
• Worked on teh development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
• 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 teh invoices and payment information from teh legacy system and imported into Oracle Application using teh Payables Open Interface Import program and populated into teh Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into teh Order Import (OE) headers and line interface tables and then to OE base tables.
• Imported Items from legacy system into Oracle Inventory using teh Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Developed Discoverer Reports to get teh 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 teh 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 teh business requirements of teh client.
• Customized existing forms to define system Profile Options, Descriptive and Key Flex fields.
• Developed technical design and test documents complying wif 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, 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 teh Order Import interface program to run periodically.
• Developed SQL Loader scripts to populate staging tables.
• Involved in teh 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 teh 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 teh 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 teh business Requirements.
• Teh integration of key business processes across teh 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 dat 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 teh 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 teh frame work which would evaluate teh details collected for customer instances and then generate various reports.
• Worked on Tuning of queries of teh Custom Reports to improve teh performance utilizing diagnostic tools (Explain Plan, TK Prof).

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