SUMMARY:

• Around 11 Years of IT experience in Software design, development and implementation of software projects including around 10 years of experience in implementation and customization using Oracle Applications, worked on AR, AP, GL, OM, INV, BOM, WIP, PO, OLM, FA modules.
• Expertise in all stages of software development life cycle implementation (SDLC).
• Thorough understanding of system development process, from 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, BOM, 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.
• Involved in Design, development and customization of Reports, Inbound/Outbound Interfaces, EDI, SOA and OAF pages.
• Hands on experience on Performance tuning of existing customizations.
• Conversion of data from legacy system to Oracle Applications.
• Customizing workflows according to business requirements.
• Experience in developing OAF pages and interfaces in SOA.
• 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:

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

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, Java, C, C++

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

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

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, OAF, SOA

PROFESSIONAL EXPERIENCE:

Confidential,East Greenville,PA

Sr. Oracle Applications TCA Analyst

Responsibilities:

• Understand and design MD50, 70 for all TCA related interfaces, conversions, in and out of Oracle and other legacy systems (JD Edwards).
• Good understanding of JDE Edward TCA modules.
• Organize Approval meetings with the business for the changes and enhancements as required.
• Help test the Interfaces and Conversions and Approve as they are done.
• Create Test case scenarios for TCA and its integration with AP, AR and OM modules.
• Work with users in User Acceptance Testing using OATS system for all the Cycles.
• Proactively resolving Pre/Post Go-Live issues and track them as required.
• Design and maintain MDM per business requirements.
• Work with D&B integration for proper data maintenance and usability.
• Design and maintain Adhoc-request as raised.
• Use Sharepoint for issue tracking and document maintenance.
• Worked on generating and reworking on OBIEE reports and its maintenance.
• An active member in understanding & designing PIM interfaces with the legacy systems.
• Responsible to the educate users on PIM and its related interfaces.

Environment: Oracle Applications R12 (TCA, AR, AP, INV, PIM, PO, BOM), JD Edwards 8.9, PL/SQL Developer, Oracle 11g, OBIEE, UNIX, XML, Winscp403, putty 0.60, OBIEE.

Confidential,Blue Bell,PA

Sr. Oracle Applications Techno-Functional

• Setup and maintain Cycle Counts for all warehouses and technicians for DSAT business unit.
• Created a daily automated consumption process in Inventory to lower inventory levels according to its daily consumption.
• Modified Checks according to organizational changes and did the necessary Functional setups.
• Created Batch files on windows to support file transfers with our clients on timely bases, which are scheduled to run daily. These batch files are also responsibly for validating and acknowledging the files.
• Support Applications with daily issues across the board, which includes custom applications and vanilla Oracle.
• Worked with JIRA tracking system for daily support.
• Worked on generating OBIEE reports and its maintenance.

Environment: Oracle Applications R12 (AR, AP, INV, PO, GL), PL/SQL Developer, Oracle 11g, OBIEE, UNIX, XML, Winscp403, putty 0.60, Java.

Confidential,Mount Laurel,NJ

Sr. Oracle Applications Techno-Functional

• 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.
• Understanding existing customizations in OAF and resolving issues with it.

Environment: Oracle Applications R12 (AR, INV, BOM, 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, Java.

Confidential,Cherry Hill,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.
• Worked on OAF customizations and maintenance.

Environment: Oracle Applications R12 (OM, INV, BOM, WIP, 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,Wayne,Pennsylvania

Sr. Oracle Application Performance Tuner/ Technical Developer

• 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

Oracle Application Technical Developer

• 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 for EDI 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 load them 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,Santa Ana,California

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 ‘Certificate 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,Burlington,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 reference 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,San Diego,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,Melville,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:
• 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:
• Creates a temporary table which to store the information.
• Studies the life cycle of an item, calculates & inserts this information into the temporary table.
• Retrieves the same in a report (RDF format).
• 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.