SUMMARY

• Over 8 Years of IT experience in Software design, development and implementation of software projects including around 8 years of experience in implementation and customization using Oracle Applications, worked on AR, AP, GL, OM, INV, PO, OLM, FA modules.
• Having Good expertise in all the stages of Full software development life cycle implementation (SDLC).
• Good and thorough understanding of system development process, from initial planning through deployment.
• Experience in Application System Administration activities like managing concurrent managers, application user set up, defining responsibilities, value sets, flex fields, registering menus, reports, tables.
• Experience working with Interfaces, conversions and EDI in AP, AR, GL, PO, OM and INV Modules.
• Proficient in writing stored procedures, packages, functions, triggers, materialized views and XML.
• Experience in developing and modifying reports using Oracle BI Publisher, Oracle Reports and Discoverer.
• Well versed with client server environment and tools like Developer/2000, SQL*Loader, and TOAD, PL/SQL developer, SQL Navigator.
• Experience in developing web sites or forms using Microsoft Visual Studio.
• Excellent communication and inter - personal, analytical and good documentation skills.
• Ability to learn new things quickly and to work under the pressure.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 12.0.6, 11.0.3, 11.5.9, 11i ( AR, AP, GL,INV, PO, OM, OLM, FA) and CRM (Customers Online, Sales Online, Tele Sales & TCA)

Operating Systems: MS-DOS, UNIX, SOLARIS 8.0, WINDOWS 95/98 and WINDOWS NT

Languages: PL/SQL, XML, VB.Net, Shell Scripting, VB.net, HTML

RDBMS: Oracle 10g/9i/8.x

Tools: SQL*PLUS, SQL*Loader, Toad, PLSQL Developer

GUI Tools: Developer 2000, Reports6i, Discoverer Administrator 4i, Oracle BI Publisher 10.1.3, Oracle XML Publisher 5.6.2, Microsoft Visual Studio 2008, Crystal Reports Developer 12.0.0.683

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, NJ

Sr Oracle Applications Techno-Functional

Responsibilities:

• Support PO, Receiving and Matching Invoice process and resolve issues on daily basis.
• Help resolving issues with Orders flow in and out of Oracle Applications.
• Support and maintain Positive Pay process to transmit outstanding checks information to Banks.
• Support and maintain AR Lockbox process to create automatic receipts in Confidential .
• Involved in production support for the existing and enhancements done.
• Designed Developed Discoverer reports In PO, AR, INV, OM areas.
• Help users in Month End Period Close by resolving Pending transactions.

Environment: Oracle Applications R12 (AR, INV, PO, RCV, OM, GL), Toad 12.0, Oracle Forms Builder 10g, Oracle Discoverer, Oracle 11g, UNIX, XML, PL/SQL 8.x, Winscp403, FileZilla, putty 0.60.

Confidential, New Jersey

Sr.Oracle Technical Developer

Responsibilities:

• Supported VPS system with the monthly Allocation Process, Product Planning setups.
• Involved in Production support.
• Involved in understanding and gathering requirements for enhancements and bug fixing.
• Prepared Functional/Technical/Test/Installation scripts for all the Enhancements and Bug fixes.
• Been active in developing new custom forms, reports and customizing existing logic/architecture for on-going projects.

Environment: Oracle Applications R12 (OM, INV, AP, AR) SQL Navigator, SecureCRT, Oracle Forms Builder 10g, Oracle Reports 6i, Oracle 10g, UNIX, PL/SQL 8.x, SQL developer, Winscp403, putty 0.60, TortoiseSVN.

Confidential, Pennsylvania

Sr. Oracle Application Performance Tuner/ Technical Developer

Responsibilities:

• Involved in discussion with client in understanding the customizations and requirements.
• Working on improvements of the jobs consistently which run beyond expected time according to the business.
• Involved in suggesting code changes for meeting expected performance and implemented the solution upon approval.

Environment: Oracle Applications 11.5.10/R12 (OLM, AP, AR, PO, OKL, OKC, GL), Performance Analysis for Toad, Foglight, Toad 9.5, Performance Tuner, Oracle Forms Builder 10g, Oracle Reports 6i, Oracle 10g, UNIX, XML, PL/SQL 8.x, SQL developer, Winscp403, putty 0.60.

Confidential, Massachusetts

Oracle Application Technical Developer

Responsibilities:

• Involved in discussion with client in understanding the flow of the current Webstore and how the orders are processed.
• Prepared functional and technical designs for the Order Import process and receiving payments.
• Developed a custom import program for the weborders in order to integrate with Oracle ERP 11i.
• Developed custom programs forEDI 850, EDI810 and EDI 856.
• Developed custom Program to load the Purchase Orders for EDI Customers, by extracting the fields from the file based on Interface File definition (PO 850 InBound Orders) and loadthem into Interface tables.

Environment: Oracle Applications 11.5.10 (OM, PO, INV, AR, GL), Oracle Forms Builder 10g, Oracle Reports 6i, Oracle 10g, UNIX, XML, PL/SQL 8.x, SQL developer, Winscp403, putty 0.60.

Confidential, California

Oracle Application Technical Programmer Analyst

Responsibilities:

• Participated in discussions with Client users and analyzed the requirements to create Techno-Functional Design’s for the following:
• Customer Conversion from MBDS(legacy system) to Oracle SCM.
• Custom What-If Horizontal Plan form.
• Interfacing the Sites information from Location Database to Oracle Demantra.
• Developed a custom form What-If Horizontal form which is a replica of the seeded Horizontal Plan in Advance supply chain with the following enhancements:
• Display only Supply, Demand and onhand information for a 90 days horizon.
• Allow users to edit the information in a field called ‘What-If’ which would recalculate the values for Supply, Demand and On-Hand quantities.
• Zoom into the Supply/Demand levels in order to show the Supply/Demand screen, which is a detailed view of when and how the quantities arrived.
• Coded for Customer and customer sites conversion going from MBDS(legacy system) to Oracle SCM.
• Upgraded reports from 11i to R12 using Oracle Reports Developer and Oracle BI Publisher.
• Involved in creating a new layout for AP checks so as to mimic the custom 11i AP check layout, which required creating a new RTF Template and XML Data Definition.
• Developed a custom ‘Account Analysis Report’ (in GL) including the drill down features to Distribution level for the AP and AR Invoices, which included following developments:
• Created custom API in order to include drill down query.
• Created Data definition with the updated XML template.
• Created new Template (RTF) for the data definition and attached the template to the custom program.

Environment: Oracle Applications R12 (OM, PO, INV, ASCP, AP, AR), Oracle Forms Builder 10g,, Oracle BI Publisher, Oracle Reports 6i, Oracle 10g, UNIX, XML, PL/SQL 8.x, Toad7, Winscp403, putty 0.60.

Confidential

Oracle Application Technical Consultant

Responsibilities:

• Involved in gathering the requirements from users for Suppliers, Customers, AP Invoices, AR Invoices, Customer Payments, Journal Entries.
• Discussed with IFS Applications (legacy system) Business analyst and Oracle users and prepared the functional documents depending on In and Out flow of data from and to Oracle.
• Worked on setting up the AR, AP and GL for the Interfaces/Conversions from & to Oracle.
• Developed custom program for migrating Customers and Suppliers for IFS (legacy system)
• Developed AR Invoices, AP Invoices, GL Journal’s Inbound Interfaces which come into Oracle from IFS. AP and AR Invoices Interface’s also handle cancellations.
• Developed customer Payments Outbound Interface from Oracle to IFS.
• Developed Suppliers, Customers Inbound Interface which also handles the updates, deletions if any.
• Developed reports for the financial depart, in order to review & reconcile the transferred /errored Customer/Suppliers/AR Invoices/AR Invoices/Journals.
• Modified Custom reports in order to work for the current legacy system (IFS).
• Involved in UAT, CRP1 & CRP2 and resolved issues as they arise.
• Supported post production issues for the current and existing customizations and Interfaces.
• Developed ‘ Of Conformance’(CofC) which includes customer, shipment, part and testing(against each part) information, which has the following sections:
• GUI interface: Developed a user interface website using ASPX pages, API’s & views to query, enter and or update the shipment information.
• CofC Report: Developed a crystal reports which works for the post and pre production shipments.
• Migrated pre-production CofC data from PICK (legacy system) into a data ware house system.
• Created DBlinks and API’s in order to access the data ware house data.
• Created complex views in order to access current and legacy data.

Environment: Oracle Applications R11.5.10 (AP, GL, AR), Microsoft Visual Studio 2008, Reports 6i, Oracle 10g, UNIX, PL/SQL 8.x, SQL*Loader, Toad7, Oracle BI Publisher, Crystal Reports V12, Winscp403, putty 0.60, IFS (ERP) applications 7.

Confidential, New Jersey

Oracle Application Techno-Functional Consultant

Responsibilities:

• Involved in upgrading process from 10.5.7 to 11.5.10.2
• Involved in gathering, analyzing requirements and generating Functional designs for the Inbond/Outbond Interfaces for vendors, Invoices, and payments which flow between Legacy systems (Markdown Allowance, Freight, and Compliance Network, SKUS) and Oracle AP system.
• Configuration of Oracle AP for Bank accounts, Payments, Printer Styles.
• Involved in setting up Chart of Accounts, Value Sets, Code Combinations, Calendars, Multiple currencies, Reporting Set of Book and Set of books.
• Defined Auto Posting, Mass Allocations in GL module.
• Modified CUSTOM.pll also worked on Forms Personalization according to the user requirements.
• Developed custom form to provide the cross values for all the department invoices and new invoices in 11i in order to reverse engineer the data while flowing in and out of the Oralce to SKUS.
• Developed Custom program to generate the Outbound File for EDI 810 (Invoices) based on File definition.
• Developed Custom Program for EDI 856(ASN) and generate outbound file.
• Created 3WayMatch Interface for posting Invoices, Holds, Payments and Distributions from 3WayMatch (home grown system) to Oracle AP.
• Analyzing requirements & creating techno-functional design of this system.
• Interacted with legacy systems using DB links to get the necessary data an wrote a custom code which interfaces between the 3waymatch system and Oracle AP.
• Generated Instead of triggers, Oracle AP API’s, Synonyms.
• Created a custom code for Creating, Updating and Deleting Invoices, holds, Payments, Distributions, Vendors, and Attachments as the part of this Interface using Oracle API’s and Import programs.

Environment: Oracle Applications R10.5.7 /R11.5.10 (AP, GL), Match3Way system, Reports 6i, Oracle 10g, UNIX, PL/SQL 8.x, SQL*Loader, Toad7, Winscp403, putty 0.60.

Confidential, California

Oracle Application Technical Consultant

Responsibilities:

• Involved in upgrading process from 11.5.4 to R12
• Worked on upgrading Workflows, Reports, Request sets, Forms, Interfaces.
• Worked on Period Close & open activities in GL, AP, INV modules.
• Following are some major reports, which were fixed in Oracle Builder from 6.0.8.11.3 :
• Confidential US Pick Slip
• Confidential OSC AR Audit Detail Report
• Confidential Order Status Picture
• Confidential Generate Selected EDI Invoices
• Following are the major Workflows which were upgraded: shipping Notification WF for Credit Card & COD order types.
• Confidential Line Flow - Corp Cons Shipment
• Developed Outbond Interface for Extracting data from Oracle Applications to convert into KumaVision for the following data:
• On hand Quantities, also developed both 350 & 610 documents explaining the technical design along with the migration steps.
• AR History, also developed both 350 & 610 documents explaining the technical design along with the migration steps.
• General Ledger Journals, also developed both 350 & 610 documents explaining the technical design along with the migration steps.
• Developed Confidential Sales Compensation Report, which shows commissions and bonuses achieved by the Sales force. Additional information will be displayed such as quantity and Average Price List (ASP) for the period, quarter to date and year to date timeframes. The report parameters are Salesperson and Period.
• Developed 350 document, which explains the technical developments & changes for this report
• Developed 610 document, which gives the migration steps for this report
• Developed a custom workflow process which would automate the process for generating miscellaneous receipt for Platinum (Order Type) Shipments. Also, developed relevant 350, 610 & 410(Unit Test Results) documentation.
• Developed Confidential Co-Packaging Custom program to populate records in the Installed Base and Service Contracts at the time of shipment for the Co packaged item.
• Developed Confidential US Replenishment Report for the Leads to use as a tool to track inventory levels. This report will enable Leads/shipping personnel to plan and replenishment inventory accurately to ensure that there’s sufficient quantity at all times.

Environment: Oracle Applications R11.5.4 /R12 (AP, OKC, OM, PO, INV, AR, CN), Oracle Workflow Builder 2.5, Oracle BI Publisher, Reports 6i, Forms Builder 6i, Oracle 10g, UNIX, PL/SQL 8.x, SQL*Loader, Toad7, PL/SQL Developer, Winscp403, putty 0.60, Share Point server 2007.

Confidential, New York

Oracle Application Technical Consultant

Responsibilities:

• Developed Install Base Status report using Oracle Discoverer 10g, this report present all the wrong data in the entire Install Base Module and prepared the technical document.
• Worked on WAS 1.1 project (Witness Actionable Systems) for the following developments:
• Conversion of Vendors, Sites & their Contacts from legacy system (Great Plains) to Oracle Applications: Created staging tables, developed shell scripts which invokes sqlldr to load the data file into staging tables, created concurrent programs for validating the staging data & populate interface tables (AP SUPPLIERS INT, AP SUPPLIER SITES INT, AP SUP SITE CONTACT INT), ran oracle import programs to populate base tables (PO VENDORS, PO VENDOR SITES ALL, PO VENDOR CONTACTS), prepared MD 120 & MD 570 for the entire process.
• Involved in defining Employees as Vendors, by converting all the Employees defined in HR module into the AP module, using the similar process mentioned above but with the CLASSIFICATION TYPE ID as employee & their respective numbers.
• Moving all Vendor Sites & their Contacts from one Operating unit to other: prepared a data file of the existing vendor sites & contacts, loaded all in their respective staging tables, developed new programs which validates the data according to the new operating unit & populates them into interface tables, then ran oracle API’s to populate respective base tables.
• Generated Custom process for Importing GL Budgets in Oracle.
• COGNOS is an external system used for Budget Planning which provides Budget Balances in the end of the day, which needs to be imported into Oracle.
• Developed a process to provide Inventory Turns Report for all the Items of all the Organizations. This process involves in 3 phases, as explained below:
• Worked on printing “AP- Dual Remittance Check” which is used for issuing checks for the vendors. Involved in preliminary setups for defining its Payment Programs, Payment Formats & its relevant Bank Payment Format.
• Worked on resolving production tickets.
• Worked on developing Order Import Program to import orders from legacy system.
• Customized PO Approval Workflow for sending out PO notifications to the preparer & approver, by adding new functions & PL/SQL procedures.
• Upgraded Service Contracts report from 11.5.9 to 11.5.10, by adding new fields, functions and prepared new mapping document for 11.5.9 to 11.5.10 in Oracle Discoverer 10g.
• Developed CIS Non Conformance Report, which is generated for all the defective products after undergoing quality analysis using Oracle Reports 6i.
• Worked extensively on issues related to OKC, OM, PO, AP, CSI modules.
• Involved in full software development cycle(SDLC)
• Worked on creating triggers on data base tables prior to update of interface tables upon the business requirements.
• Worked System Administrator to create various Concurrent Programs, Requests sets, and for changing Profile Options.
• Customized Reports according to business requirements in CSI, OKC, OM, PO.

Environment: Oracle Applications R11.5.10 (AP, CSI, OKC, OM, PO), Oracle Workflow Builder 2.5, Reports 6i, Oracle Discoverer 10g, Oracle 10g, UNIX, PL/SQL 8.x, SQL*Loader, Toad7, PL/SQL Developer, Winscp403 .

Confidential, Austin, Texas

Oracle Application Technical Consultant

Responsibilities:

• Involved in upgrading the reports from 11.0.3 to 11.5.10
• Upgraded Reports in Oracle Builder from 6i to 10g.
• Developed UNIX Install Scripts in moving the files from older version to 11.5.10
• Worked on creating ldt’s using FNDLOAD generic loader. The created ldt’s were moved from test instance to production through shell scripts.
• Worked with functional integration team while testing the reports which was upgraded.
• Developed queries and packages using PL/SQL for customized reports. Supported and fixed defects and issues which were raised by business users in Oracle Discoverer 4i.
• Developed Confidential Matched Purchase order Report.
• Developed Confidential Matched Purchase Order Report, which presents all the purchase orders which match with the AP invoices using Oracle Discoverer 4i.
• Generated TKPROF and Explain Plan for all the reports to analyze each and every SQL Statement.
• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.
• Developed the custom Oracle reports in Oracle XML Publisher.
• Designed reports using Oracle BI Publisher:
• Invoice Aging Report.
• Worked extensively on issues related to FA, OM, INV, GL, AP, AR, PO modules. Used iTAR mechanism of Oracle Support for obtaining relevant patches.
• Involved in full software development cycle(SDLC)
• Created Views and Materialized views to improve query performance by precalculating expensive join and aggregation operations on the database prior to execution and storing the results in the database
• Extensively used AOL and System Administrator modules for set up of various concurrent programs, Requests sets, Value sets and Descriptive flex fields.
• Developed customized Reports according to business requirements in FA, OM, INV, PO, AP, AR using Oracle Discoverer 4i, Oracle Reports 6i, and Oracle XML Publisher 5.6.2.
• Worked on Creating Standard Purchase Orders after inserting the data into PO HEADERS INTERFACE, PO LINES INTERFACE, PO DISTRIBUTIONS INTERFACE tables and then calling import Standard Purchase Order Concurrent Program.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICE INTERFACE, AP INVOCIE LINES INTERFACE tables and Calling Payable Import Program.
• Wrote the Program to insert data into Receiving Interface tables RCV TRANSACTIONS INTERFACE, RCV TRANSACTIONS INTERFACE tables based on the different Transactions and Receiving Transaction Processor process data from the interface tables and the quality updates are done.
• Wrote a package on AR Auto Invoice interface, Imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice import program and wrote a custom program in grouping the invoices based on the requirement.
• Worked on the Oracle Inbound Ship Confirm API’s, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs, through WSH DELIVERIES PUB, WSH DELIVERY DETAILS PUB and WSH FREIGHT COSTS PUB shipping API’s

Environment: Oracle Applications R11.5.10 (OM, INV, PO, AR, GL, AP), Reports 6i, Discoverer 9i, Oracle 10g, Oracle BI Publisher 5.6.2, UNIX, PL/SQL 8.x, SQL*Loader, Toad7.

Confidential, CT

Oracle Applications Technical Consultant

Responsibilities:

• Worked on creating End User Layers, building Business Areas, Discoverer Workbooks and Parameterized reports using Discoverer 9i
• Customization of Standard Customer’s online/Sales on line/ Trading Community Architecture/FA/INV/PO/OM/AR Reports and Involved in creating Business Areas using Discoverer 9i
• Customization of Standard Customer’s online/Sales on line/ Trading Community Architecture/FA/OM/PO/AR/INV Reports, which includes extensive PL/SQL code (Procedures and Functions).
• Involved in granting Privileges on EUL, Workbooks to End User Layer.
• Extensively worked on Format Triggers, Formula Columns, Summary Columns and Placeholder Columns for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports 6i.
• Tuning the Custom billing process which was running more that 24 hours by analyzing the process and programs. TKPROF was generated for all the programs to analyze each and every SQL Statement.
• Reports designed using Discoverer 9i & Oracle XML Publisher for modules FA, OM, PO, AR, CRM:
• Cost Summary Report
• Active Vendors Report
• Inventory Material Transaction Summary and Detail Reports.
• Holds Release Report
• Sales order Shipped by OrderType
• Worked extensively in Procure to Pay cycle.
• Worked in Order to Cash cycle.
• Defined users and responsibilities in applications 11i
• Define pick release rules, document sequences & shipping parameters.
• Responsible for org sub inventories & loading.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the legacy data into the staging tables.
• Used SQL *Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.
• Developed PL/SQL packages to pre-validate and clean up the data in the staging tables and insert the data into the INTERFACE tables.
• Designed and Developed MD 50, MD 70, CV 40, CV 60 for Custom Conversions and Interfaces.
• Created technical documentation and gave support to the users.

Environment: Oracle Applications R11.5.9 (PO, OM, INV, AR, FA, AP), CRM (COL, SOL, TCA), Discoverer 9i, Oracle 9i, SOLARIS 8.0, Reports 6i, PL/SQL 8.x, SQL*Loader, Toad7,Oracle XML Publisher.

Confidential, Dallas, TX

Oracle Applications Technical Consultant

Responsibilities:

• Gathered Business Requirements, Designed and customized Oracle Reports and Discoverer Workbooks in modules like INV, Customer’s online/Sales on line/ Trading Community Architecture, PO, OM and AR.
• Involved in creating Business Area’s, Folders and Item Classes in Discoverer Admin.
• Developed Discoverer Workbooks Using Discoverer 4i:
• Onhand Quantities Report
• Po Detail Report
• Inventory Reconciliation Report
• Responsible for performance tuning of the existing procedures and table indexes.
• Developed Reprots using Oracle BI Publisher:
• Supplier Payments Due Report.
• Daily/weekly/Monthly Sales Order Report
• AP Account balance analysis Report.
• Developed Reports6i using Report Builder
• Price List Changes Report
• Customer and Product Transaction Listing Report.
• Created parameterized reports using Discoverer Plus.
• Involved in verifying the leads, opportunities, quotes and orders using Telesales Universal Search.
• Created Party and Person Relationships using Tele Sales Manager.
• Prepared technical and functional documentation for the reports and conversions developed and gave support to the users.

Environment: Oracle Applications 11.5.9 (PO, INV, AR, AP, CRM), ORACLE 10g, PL/SQL, Reports 6i, Discoverer 4i, Oracle BI Publisher, Toad 7.0.4.3, Windows 2000.

Confidential, Jacksonville, FL

Oracle Technical Consultant

Responsibilities:

• Responsible for developing and customizing complex Reports (6i) as per the client requirements in OM, IMV, PO.
• Interpreted the end-user business requirements to design and develop complex Disoverer 4i reports.
• Created parameterized reports using Discoverer Plus.
• Modified Sales order Acknowledgement Report
• Involved in defining Transaction types.
• Prepared Functional and Technical Requirement Specifications based on the Business Requirement Documents.
• Interaction with the Business users and identifying the gaps/requirements.
• Defining set up options, Job and Position flex fields, Purchasing position hierarchy, Job and position attributes purchasing cycles, RFQ’ s for suppliers in purchasing module.
• Setting up Purchasing Document type, Line Type, Parameters Purchasing Approval Hierarchy, Employee set up.
• User support on performing various activities like train the users to enter POs, Requisitions etc.
• Involved in Supply Chain Management of Order Management.
• Created the Invoices against sales orders for the Customers using the Pick release report, Interface Trip report and Auto Invoice Interface program.
• Defined shipping and pick release documents, Sales order types, Pick Release grouping Rules, Pricing agreements in Order Management module.

Environment: Oracle Applications R11i (OM, INV, PO, AR, Shipping), PL/SQL SQL*Loader, Toad7, XML Publisher, HP-UX 11.0, Discoverer 4i/3i, Oracle 8.1.7.