SUMMARY

• 8+ years of Experience in Development of Applications in Oracle ERP Application (Financial, Manufacturing and Distributions) and Client - Server environment.
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite and Release 12.
• Extensive experience in Oracle Applications EBS 11i Oracle Financials (OM, INV,PO, AR, AP, GL, CM, CSF, CSI, CSD) modules of Oracle Applications 11i in multi Org, multi Currency environment.
• Extensive Experience in Oracle Application customizations including Forms, Reports and Concurrent Programs.
• Extensively experienced in the technical and functional aspects of Oracle Applications R12/11i/10.7.
• Experience in Oracle Applications modules that includes Order Management, Inventory, Oracle Advanced Pricing, Shipping Execution, Accounts Receivables, Accounts Payable, General Ledger, Cash Management, Purchasing, Procurement,E-Commerce Gateway (EDI) and Workflow.
• Worked on Oracle Workflow involving various activities such as Notifications, Functions, and Processes.
• Strong working knowledge of business flows like Order-to-Cash and Procure-to-Pay along with the dependencies and relationships between Oracle Applications modules.
• Good understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Strong in PL/SQL and topics like Bulk collects, Dynamic SQL, Collections.
• 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.
• Hands on Experience in Oracle Discoverer 4i/9i/10g which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Supported the production system with day-to-day issues and worked with business users and Oracle Support as required.
• Ability to interact with individuals at all levels and Accustomed to working under tight schedules.

TECHNICAL SKILLS

Oracle Applications: OracleApplication 11i/12

Technical Modules: AOL, System Administration.

Functional Modules: AR, AP, GL, CM, OM, PO, INV, CSF. CSI, CSD

Tools: OracleDiscoverer, Developer2000, (Form 6i and Reports 6i), TOAD, SQL*PLUS.

Languages: C, SQL, PL/SQL.

RDBMS: Oracle 10g, 9i, 8i, 6i.

Operating Systems: WINDOWS 7/XP/2000/NT, UNIX.

Other Tools: SQL Loader, Microsoft Office - Word, Excel, PowerPoint, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, NC

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Analyzed the existing elements and customizations in business process.
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Release program to release orders. Wrote packages and worked extensively on validations in the orders released from OM to AR, OM to TDW and populating the interface tables.
• Modified the existing Interface Program to import Invoices to AR.
• Enhanced custom processes, defined setups for Oracle Alerts (ALR) to inform business users of certain events.
• Worked on Development, Unit Testing, Implementation and Documentation of Claims & Incentives, OM to TDW Projects and AP, AR, OM Oracle EBS Modules.
• Customized the order header workflow to make certain header level attributes mandatory before the order is booked.
• Developed PL/SQL packages to communicate data to business users. Automated emails sent as CSV attachments and minimized month end issues and efforts to reconcile.
• Enhanced the functionality in the following custom forms and reports.
• Performed performance improvements and fine tuning of materialized views.
• Took part in enhancing ETL process. Worked on Informatica mappings, sessions and workflows. Ran scripts to load updated data into dim tables.
• Generated unit testing documents. Documented processes in MD-70, MD-120 based on requirements.

Environment: Oracle Applications R11.5.10.2 (EBS) (GL, AR, AP, FA, CM, INV), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, Informatica and UNIX.

Confidential, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications eBusiness Suite open interface tables.
• Used CONCSUB to call the Concurrent Process and execute the job in Unix Shell Script
• Developed new custom processes, functions, defined new events, subscriptions in OEOH and OEOL Workflows to update the shipping method and carrier information after order has been BOOKED. Also modified the transaction type set ups to route the workflow through custom process.
• Took part in Development, Testing, Implementation and Documentation of ALC, AUDITS Projects and PO, AP, AR, OM Oracle EBS Modules.
• Worked extensively on TCA Customer Conversion in loading the new Customer details from Legacy System to Oracle AR Tables.
• Converted GL Balances, Purchase orders, Sales Orders, Pricing Discounts from Legacy System to Oracle.
• Worked inOracle Cash Management modules to load, import and auto-reconcile bank statement transaction against payments in Accounts Payable (AP)/AR.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating Indexes.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Cancellation and creation of order lines using Process order API.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Created different Template for Payment Process Request (PPR).
• Designed and developed the following custom reports in OM and INV modules as per the client requirement
• Developed the bursting process to email, Fax and print a document based on the business rules at the same time.
• Designed and Developed AR pre Processor program to massage the date before Creating the Interfaces.
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets
• Designed a technical document MD-70 based on functional document MD-50

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO, DR, FS), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential, CA

Oracle Applications Technical Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications eBusiness suite open interface tables.
• Created custom Interfaces per the client requirements to convert Standard Orders, RMA’s and Dropship orders.
• Involved in Setting up Fixed Assets fully, uploaded & purged the Fixed Assets data and prepared the reports
• Developed a custom program to upload the item attributes into the Oracle using the ITEM Import. This program will read the CSV file uploaded by user and create/update the item category/category sets and updates item attributes.
• Extracting and loading catalog data from internal and external data sources for use with oracle internet Procurement, Creating Item level, Category level information templates, Settings for Realms for iProcurement.
• Developed new Custom Reports like Supplier Payments Reports, Customer Balance Reports etc. and modified existing AR Receipt (Lockbox) Interface.
• Developed functions to implement intercompany rules.
• Converted the customer information from Legacy system into Oracle Applications using custom programs and APIs to affect the HZ tables in TCA.
• Cancellation and creation of order lines using Process order API.
• Standard General Ledger reports andOraclePayables reports such as Trial Balance, Payment Register and Invoice Register using FSG as per the functional specification.Designed and developed the following custom reports in OM and INV modules as per the client requirement
• Customized the Order line workflow to apply custom holds before the order is booked using Holds Pub API.
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential, NY

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications EBS open interface tables.
• Worked on the setups of Order to Cash life cycle. This included Customer, Order Types, Item and credit checking rules.
• Used using CONCSUB to call the Concurrent Process and execute the job in Unix Shell Script
• Used the EDI 810 Inbound data to capture the information and initiate the shipping transaction in Oracle.
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders. Wrote packages to validate and populate the interface table.
• Utilized the purchase order extractions program to extract Purchase Order data in EDI 850 format and transfer to GENTRAN, the EDI Translator. GENTRAN transmits the data to the drop ship vendor
• Developed custom API’s to change the Confidential order lines after pick release.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Cancellation and creation of order lines using Process order API.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Designed and developed the following custom reports in OM and INV modules as per the client requirement-
• Customized the order header workflow to make certain header level attributes mandatory before the order is booked.
• Customized the Order line workflow to apply custom holds before the order is booked using Holds Pub API.
• Designed and developed Bill and Routing Interface by dumping the data files into the BOM base tables.
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO, BOM), Oracle11g, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNIX.

Confidential, PA

Oracle Applications Techno Functional consultant

Responsibilities:

• Analyzed existing elements for pre-conversion processing.
• Worked on complete setups of Order to Cash life cycle. This includes Defining Customers, Defining Order Types, Defining Organizations, Defining Items and Credit checking rules.
• Worked on the Item import conversion to import Inventory items from the legacy system into Oracle Applications.
• Set up of inventory organizations, sub inventories, shipping networks, transaction sources etc.
• Customized Oracle Seeded reports in Order Management and Accounts receivables. Includes customization of Orders by Item and Sales Order Acknowledgement report as per the functional requirements
• Developed and Implemented Interface program to import invoices to AR, performed validations of invoices and performed necessary setups for the auto invoice master program.
• Resolved the performance issues of key reports in OM, INV.
• Created custom Interfaces per the client requirements to convert Standard Orders, RMA’s and Dropship orders.
• Developed PL/SQL packages to validate legacy data for items conversion with categories in Oracle Inventory (INV) module.
• Used the FTP utility to transfer files like raw data, reports etc between UNIX servers.
• Used SQL*LOADER with the help of Control Files to load data from pipe delimited flat files into ORACLE staging tables.
• Developed a package that validates invoice information and load the invoices into AR by running auto invoice daily.
• Worked on Customer Listing - Detail/Summary report and Dunning History report. Registered these reports as concurrent programs in AOL and modified request group to add these concurrent programs.
• Created of various Oracle Alerts (ALR) to inform internal users of certain events, or to notify customers of account status.
• Customized a number of financial reports like Invoice History Report, Invoice Aging Report, Payment Register Report etc in AP using ORACLE Report Builder 6i.
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
• Worked with Discoverer 9i so users would have the ability to generate ad-hoc reports and also show the data in the form of Excel Files.
• Involved in document and code reviews.
• Performed Pl/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Deeply involved in writing ORACLE database objects like STORED PROCEDURES, FUNCTIONS, and PACKAGES using PL/SQL.

Environment: Oracle Applications 11.5.10.2 (EBS) - (GL, AR, AP, FA, CM, INV), Oracle11g, PL/SQL, SQL*Loader, Oracle Reports, Discoverer 9i & 6i, XML publisher 5.6.3, Workflow 2.6, Perforce, TOAD, and UNIX.

Confidential, Pasadena,CA

Oracle Applications Technical Consultant

Responsibilities:

• Communicated effectively with the clients to understand and get information regarding their Business practice. Involved in requirement gathering and analysis and design of the application.
• Involved in the complete setup of pricing that included price lists, modifiers, qualifiers, profile options, lookups, attribute mapping, etc.
• Defined Transaction Type, Payment terms and Invoicing rule setups and invoice, receipt related setups in AR.
• Developed the PL/SQL Scripts to translate the old Asset Category to new Asset category values that are been setup in the R12 Fixed Assets
• Developed the SQL*Loader script to load the data to staging tables and then to interface tables for Order Import program to import orders. Wrote packages to validate and populate the interface table
• Developed PL/SQL packages to validate legacy data for items conversion with categories in Oracle Inventory (INV) module.
• Customized standard Oracle reports like Suppliers Report, Account Status Report, Account Analysis Report and Backorder Summary Report as per the business requirements.
• Extracting and loading catalog data from internal and external data sources for use with oracle internet Procurement, Creating Item level, Category level information templates, Settings for Realms for iProcurement.
• Extensively used XML functions like XMLELEMENT(), XMLFOREST(), XMLAGG() etc.for XML output and integrated with Xml Publisher for better lookup of the reports.
• Designed and Developed Blanket Sales Agreement and Blanket Release Reports using XML Publisher for better lookup.
• Used CONCSUB to invoke and execute the Concurrent Programs from Unix Shell Scripts.
• Developed ad-hoc reports according to user requirements and created custom business views/folders using Discoverer10g.

Environment: Oracle Applications R12 (EBS) (GL, AR, AP, OM, INV, PO), Oracle10g, PL/SQL, SQL*Loader, Developer 6i (Forms and Reports 6i), Discoverer 10g, XML publisher, Workflow 2.6, VSS, TOAD, and UNI

Confidential, Webster, NY

Oracle Applications Technical Consultant

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.
• 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.

Confidential, MN

Oracle Applications Technical Consultant

Responsibilities:

• Used SQL loader to import data into temporary tables and validated this data by creating custom PL/SQL procedures as required.
• Developed an Interface to load Requisitions data from flat file to Oracle Purchasing using PL/SQL Packages and Procedures, Validations and SQL*Loader Scripts.
• Extensively used API’s in the data conversion process and also in situations where complex business logic needs to be implemented.
• Customized standard Invoice on Hold report, Supplier Payment History Report and Aging Report as per the client requirements.
• Customized the Order Header and line workflow for lines fulfillment process.
• Worked on Customer conversions to import new customer accounts into Oracle Account Receivables.
• Developed PL/SQL procedures to load Price list Data (Qualifiers, Modifiers and Price Lists).
• Worked with the Oracle support teams and raised TARs to resolve issues.
• Create custom reports using XML publisher as requested by users.
• Worked on post-production support to debug and resolve issues.

Environment: Oracle Applications 11.5.9 (GL, AR, AP, PO, INV), Oracle Workflow Builder 2.5, Oracle Database 9i, SQL, PL-SQL, Reports 6i, Forms 6i, XML Publisher, TOAD, SQL* Loader.

Confidential

Oracle Developer

Responsibilities:

• System analysis and design for enhancements, Testing Forms, Reports and User Interaction.
• Database development included writing PL/SQL stored procedures, triggers, and functions.
• Developed Error-Handling package using PL/SQL tables to handle user-defined errors.
• Design and execute complex SQL Queries and PL/SQL codes to enhance the existing Reports.
• Accessed remote databases using DB-Links.
• Tuning the SQL scripts to improve performance.

Environment: Developer 2000, PL/SQL, SQL*Loader, TOAD, Windows 2000

Confidential

Software Engineer

Responsibilities:

• Involved in creating reports for FCIS
• Creation of Packages, stored procedures & triggers using PL/SQL
• Developing Generic Packages using PL/SQL to migrate data from fat files to Oracle Systems
• Involved in creating rule sets as for the business rules
• Involved in System Testing and Test plan preparation

Environment: Oracle 7.1, Developer 2000, Forms 5.0, Reports 3.0,SQL, PL/SQL, COM, XMLWindows NT 4.0, MS Access 2000.