SUMMARY:

• Oracle Applications Techno - Functional Consultant with over 7 years of experience in Designing, Implementing Enterprise Resource Management (ERP) solutions for Software, Manufacturing, Sales and Distribution Companies.
• Having over 7 years of experience in Implementation, Customization of Oracle Applications 11i, and Release12.
• Experience in designing, developing and troubleshooting Reports, Interfaces, Conversions and Extensions (RICE) in Oracle Applications.
• Developed Packages, Procedures, Functions and Database Triggers using PL/SQL.
• Experience creating SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Strong Functional and Technical knowledge in Order To Cash, Procure To Pay cycles, Oracle Applications Finance, Supply Chain, Distribution and Manufacturing modules like Oracle Inventory (INV), Order Management (OM), Bill of Materials (BOM), Advance Pricing, Trade Management (Channel Revenue Management), Work In Process (WIP), Shipping Execution, Purchasing (PO), Account Receivables (AR), Account Payables (AP) and General Ledger (GL).
• Excellent knowledge of AOL (Application Object Library)/FND and System Administration Modules.
• Extensive experience in SQL, PL/SQL, Developer 2000(Forms 6i/9i/10g, Reports6i/10g), UNIX Shell Scripts, ADI, SQL* Loader, Workflow, XML Publisher and Oracle 8.x/9.x/10g.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Having good experience with OA Framework Applications.
• Experienced in Unix Shell Scripting, administration and creating Command line arguments.
• Experienced in developing Technical Design documents (MD070) and participated in all aspects of software development Life Cycle.
• Possess good interpersonal, presentation and developmental skills with Strong analytical and problem solving approach and an excellent team player
• On-site coordination experience and worked with offshore team during knowledge transfer and development support.

TECHNICAL SKILLS:

ERP:: - Oracle apps R12, 11i (OM, INV, PO, AP, AR, GL, BOM, WIP P2P, O2C cycles).

Front End tools:: - Oracle J Developer (11g, 9.0.5), Forms6i/9i/10g, Workflow Builder2.6.3.5.

Reporting Tools:: -Oracle Discoverer 10g/4i, XML Publisher, Oracle Reports6i/10g.

Tools:: -SQL* Plus, SQL* Loader, Toad, SQL Developer, Informatica (ILM) Application 5.3.6.

Languages:: - SQL, PL/SQL, C, Java, HTML, UNIX Shell Scripting, XML.

RDMS:: - Oracle 11g/10g/9i/8i, MS Access.

Operating systems:: - UNIX, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Oracle Apps Technical Consultant

Responsibilities:

• Worked on project to integrate the transactional data from Amazon's Oracle Procurement System with a cloud based procurement system.
• Worked closely with the Amazon business users for gathering requirements and developing the custom applications.
• Worked as part of the team which was responsible for successful integration of procurement data from Oracle R12 with Coupa, which is a cloud based procurement system.
• Developed Receipts Inbound Interface which validates the PO Receipt Data from Coupa and creates the PO Receipts in the Oracle System.
• Developed Items interface which is scheduled to run every day, it exports any new items created in the Oracle ERP system to Coupa Procurement System.
• Developed Suppliers, Locations interfaces which are scheduled to run daily and these interfaces export supplier, supplier sites and ship to locations to Coupa Procurement System.
• Customized Purchase Order Workflow to stop the PO Document printing process, which is a very important process in the Purchase Order Workflow.
• Develop and Debug PL/SQL Stored procedures, packages, functions, triggers and indexes.
• Review, repair and modify software programs/code to ensure technical accuracy and reliability of them.
• Support end users in resolving day to day production issues associated with the above interfaces.
• Prepare technical documentation such as MD70 and document unit test cases.
• Supporting code migrations to different instances, unit testing, performances and bug fixes.
• Reviewing unit test cases, unit test results and validation as per the business requirements.

Application Modules: Oracle Applications/EBS R12 OM, PO, AP, INV UNIX, Oracle R12

Tools: and Languages: SQL, PL/SQL, BI/XML Publisher, Forms 10g, Reports 10g, Toad.

Confidential, East Greenville, PA

Oracle Apps Technical Consultant

Responsibilities:

• Worked closely with Business users in gathering requirements and developing the custom applications.
• Developed the Shipping Document set namely Packing Slip, Commercial Invoice for International Shipment, Bill of Lading and Master Bill of Lading according to the Knoll's requirements.
• Developed a custom report in Order Management which shows all the bookings done by Sales reps for a given region.
• Developed a custom report to display the On Hand Quantity, Reservation Quantity, Inspection Quantity and Lead Time for a given item in the Knoll Inventory.
• Developed Inventory reservation report, Open Purchase Orders report and Shipping Summary report for users using Discoverer.
• Performed migration of Discoverer folders and workbooks from development instances to Production instance.
• Develop, design and support BI Publisher Reports as per the user’s requirements.
• Review, repair and modify software programs/code to ensure technical accuracy and reliability of programs.
• Supporting code migration to different instances, Unit testing, performances testing and bug fixes.
• Support end users in resolving several production issues.
• Developed the following technical documents DS160, TE020, CM050 and IM090 as per the AIM standards.

Application Modules: Oracle Apps 12.1.3 Order Management, AP, AR, Inventory.

Tools: and Languages: Oracle Applications/EBS R12 OM, AP, OLFM, Inventory BI/XML Publisher, SQL, PL/SQL, Discoverer, Reports 10g, Toad.

Confidential, Newark, CA

Oracle Apps Technical Consultant

Responsibilities:

• Worked closely with Business users in gathering requirements and developing the custom applications.
• As part of the upgrade to Oracle Applications R12, developed extensions and custom reports.
• Developed a concurrent batch program in Trade Management which allocates earned amount for products part of the Lumpsum/Flat Offers/Promotions. This program will be used by the Finance team on a monthly basis to determine the revenue earned for a given product in a Lumpsum offer.
• Developed email notifications in Offers Approval Workflow based on the different types of Offers.
• Developed a BI Publisher report in OCRM that shows detailed information about Transactional Claims and Deductions.
• As part of the SIT2 testing team, resolved defects and issues with regards to Offers, Claims and Pricing Margin Extracts.

Application Modules: Oracle Apps 12.2.3 OCRM, Oracle Trade Management, Advanced Pricing, OM, AP, AR.

Tools: and Languages: Oracle Applications/EBS R12 OCRM, Oracle Trade Management, Advanced Pricing, OM, BI/XML Publisher, SQL, PL/SQL, Forms 10g, Reports 10g, Toad.

Confidential, Santa Cruz, CA

Oracle Apps Technical Consultant

Responsibilities:

• Worked closely with Business users in gathering requirements and developing the custom applications.
• Worked on upgrade of Oracle Applications R11i to Oracle Applications R12
• Worked on custom Oracle Reports, Forms, Extensions and workflows.
• Developed a workflow for RMA in Order Management to AME that fetches the approver list as per the rules specified in AME.
• Worked on the upgrade of R11i version of Fixed Assets Generator Workflow as per the business requirements.
• Worked on the upgrade of the R11i version of iExpenses Workflow as per the business requirements.
• Developed a detailed report for Business Revenue Team which displays invoices and also the items associated with the invoices.
• Developed Suppliers Report with Site Bank Accounts which shows detailed information of suppliers and their bank accounts.
• Developed a custom program in Order Management module to update the accounting rules in Order Line based on shipping details.
• Worked on upgrades of over 20 custom reports namely Asset Additions Report, Asset Retirements Report, Vendor Paid Invoice History Report, and Shippers Export Report. Worked on retrofit of forms such as Receipts and RMA Receipts.
• Worked on OTC, PTP, ATF and DTB areas of Oracle Applications.
• Performed OAF personalization for Standard Customers at Account level and Ship to level.
• Worked on the upgrade of the OAF notification for the RMA to AME workflow.
• Worked on the OAF Java custom classes to populate the AME approver’s details and also the RMA details for the OAF notification in the RMA to AME workflow.

Application Modules: Oracle Apps 12.1.3 ONT, AP, AR, FA, AME, BOM, WSH

Tools: and Languages: Oracle Applications/EBS R12 OM, AR, AP, UNIX, Oracle 11i, BI/XML Publisher, SQL, PL/SQL, Forms 10g, Reports 10g, Oracle JDeveloper, Toad.

Confidential, Memphis, Tennessee

Oracle Applications Techno Functional consultant.

Responsibilities:

• Worked closely with the business users during the requirement and design phases and developed internal design documents.
• Made changes to custom interfaces namely, Invoice Extract Air bill Interface, Air bill Activity Interface, Global FedEx Billing Online (GFBO), Oracle GL to PeopleSoft Interface, Bad Debt Invoice Update Interface, Open Invoice Extract Interface and Inbound Auto-Invoice interface.
• As part of Confidential Expansion to new markets, made changes in custom interfaces namely Oracle GL to PeopleSoft Interface, GCCS Interface, Receivables Interface and also BI Publisher Reports.
• Written Shell scripts that are used to call the Concurrent programs and these shell scripts were used in scheduling the Interfaces and other Extract programs.
• Modified the FedEx GL to PeopleSoft Interface to extract the GL Data from Oracle EBS for new domestic entities and send data to PeopleSoft system.
• Worked on issues with Manual Subledger Journal Entries API, XLA JOURNAL ENTRIES PUB PKG with Oracle Support, Applying patches in various instances, testing and validating.
• Worked on Oracle EBS forms performance issue relating to Informatica Application with Oracle and Informatica Support teams.
• Worked on XML/BI Publisher reports namely, FedEx Invoice/Airbill Activity Report, AR Negative Invoice Summary and Details reports, Oracle GL to PeopleSoft Summary and Detail reports, AR Bad Debt Report as per the Business requirements.
• Written Code and Unit Test case specifications and results documents and involved in end-to-end testing.
• Worked on performance tuning of SQL for FedEx Billing Online Concurrent Program and Aging Interface Program by implementing indexes and SQL Profiles.
• Involved in Informatica - FedEx EBS 12.1 Data Archive Implementation project, Installation and configuration of Informatica ILM Data Archive version 5.3.6 along with the OEBS 12.1 Accelerators
• Worked on ILM (Informatica Life Cycle Management) job scheduling process to archive and purge invoice related data (such as invoice header & lines info, transaction notes, adjustments, payments), aged invoices, strategies, work items, promise to pay, credit cases, accounting, E-business tax, GL journals & balances, disputes, mass upload process, credit card/direct debit payments.
• Also worked on production support for FedEx Custom Interfaces, resolved many defects and issues.

Application Modules: Oracle Apps 12.1.3 AR, AP, GL, SLA, OM

Tools: and Languages: UNIX, Oracle 11.2.0.3, SQL *Loader, BI/XML Publisher, SQL, PL/SQL, Toad, Informatica (ILM) Application 5.3.6, Oracle JDeveloper.

Confidential, Chicago, IL

Oracle Applications Techno Functional consultant.

Responsibilities :

• Wrote scripts in PL/SQL to download data into text files from various tables using DBMS UTL file package and procedures.
• Developed PL/SQL Packages, Procedures and Functions for validating the Invoices and Payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program (AP) and populated the base tables.
• Wrote SQL*Loader scripts to migrate the data from the text files and populated the intermediate table like RA CUSTOMER PROFILES INTERFACE, RA CUSTOMERS INTERFACE, RA CONTACT PHONES INTERFACE.
• 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.
• Development of Oracle Order Management Inbound interface to load massive amount of Open Purchase Orders Programmatically by running user-friendly concurrent programs.
• Created a PL/SQL package to consolidate multiple invoices (orders) to print on a single invoice based on the PO number in order to mimic the original customer PO.
• Responsible for converting all the PO vendors, vendor sites and vendor contacts into Production.
• Performed Extensive Application Tuning for order to cash business process.
• Migrated custom value sets, DFFs and packages from 11i to R12. This involved modification of code to include the new R12 tables
• Developed Order Management, Inventory, Receivables, Shipping, Warehouse Management, Pricing queries to compare summary information of the standard and custom reports
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.
• Utilized FND REQUEST API to submit concurrent Program from Oracle Report after Report Trigger.
• Developed several new forms using TEMPLATE.fmb & Customized standard forms through custom.pll.
• Unit & System testing for the developed components.
• UNIX shell scripting to move the files between interface directories.
• Creating AIM Documentation like MD50, MD70 for Functional and Technical Documentation for the projects.

Application Modules : Oracle Apps OM, INV, AR, AP, GL

Tools: and Languages: UNIX, Developer (Forms & reports 6i, XML publisher), PL/SQL, SQL

Confidential, Pittsburgh, PA

Oracle Applications Technical consultant

Responsibilities:

• Developed SQL*Loader control file according to the mapping tables to populate the custom load tables using the extract file.
• Worked on customer interface to load the customers from legacy system in TCA model.
• Worked on developing interfaces for GL and AR to load legacy data into 11i system using Journal Import and Auto Invoice import programs
• Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
• Used seeded Oracle interface programs (Import Standard Purchase Orders and Receiving Transaction Processor) to create new POs and receipts.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables (OE HEADERS IFACE ALL and OE LINES IFACE ALL).
• Designed and developed interface program to Order Import from legacy system into interim tables using SQL * Loader and developed a PL/SQL program to validate the data and send to Interface tables.
• Upgradation, Implementation and Production Support of Oracle Application 10.7/11.0.3/11 i.
• As part of upgradaton work the AP Invoice Conversion to convert the invoice date.
• Developed BI/XML Publisher reports in R12.
• Customized the RXi report in R12 for the AR Unapplied and Unresolved Receipts Register.
• Built the report using Reports Builder 6i and integrated it with the application (based on the descriptive flex fields) to solve the client’s reporting needs.
• Proficient with the System administrator responsibility, which included customizing menus, adding new concurrent requests, request sets, registering the automation scripts as concurrent programs and created scheduling process that invokes the script periodically.
• Worked with performance tuning tools like Explain Plan to improve the performance of various custom PL/SQL packages developed.
• Responsible for gathering user requirements, which involved a lot of interaction with the users
• Developed MD 70, MD120, CV40 and TE20 documentation.
• Developed reports in GL, AR, AP, OM, PO, INV, Planning and WIP.

Application Modules: - Oracle Apps OM, INV, PO, PA, AP, GL

Tools: and Languages: UNIX, Developer (Forms & Reports 6i, XML publisher), PL/SQL, SQL

Confidential, Maryville, IL

Oracle Applications Techno Functional consultant.

Responsibilities:

• Involved in total Order to Cash and Procure to pay life cycle.
• Involved in setups in Oracle Distribution modules like Account Receivables, Oracle Inventory and Order Management.
• Developed Inventory “Items Conversion” & “Items Category Conversion program” to load Inventory data from into interface tables. Imported material transactions from data collection devices and other manufacturing inventory systems using open inventory transaction interfaces as part of WIP implementation.
• Handled “On Hand Quantity Conversion” using Setup, Null and Data validations to populate data into interface table.
• Imported move transactions using open move transaction interface in WIP.
• Used TCA APIs to convert legacy customer information into oracle.
• Created PL/SQL scripts for validation in Price list Conversion into R12 in Oracle Advance Pricing.
• Involved in Customer conversion to import Bulk of records at a time and developed “Customer open Interface” required to update the changes in customer information for a particular time period Using Timestamp. This interface was a scheduled job that will replicate any changes done on Customer tables.
• Handled “BOM Routing Conversion” and imported data into base tables.
• Handled “Bills Conversion” validations and imported data into base tables.
• Involved in Supplier/ Vendor API to insert new vendor, Vendor sites and Vendor contact information.
• Involved in performance tuning using Proper tables, using cursors and using proper indexes.
• Wrote a standalone query using PL/SQL block to trace the performance issue in a large code file.
• Involved in PO Requisition Import program to import requisitions into oracle applications.
• Involved in Standard PO Import Program to import purchase orders into oracle applications.
• Involved in AR Lockbox Interface to import receipts into Oracle Applications Account Receivables.
• Involved in Auto Invoice Interface to import Invoice, Credit Memo, Demit Memo, On account Credits into Interface table in Account Receivables.
• Created a custom XML Publisher PDF report for Order Acceptance using XML Publisher to include the sales order, pricing data from OM and customer details from TCA and include company logos, Terms and Conditions.
• Involved in Customizing PO Create Document workflow.
• Provide support and resolution to helpdesk tickets.
• Preparation of technical specifications from the functional specifications received from functional team like CV60, MD 50, and MD70 using AIM.

Application Modules: - Oracle Apps OM, INV, AR, AP, BOM, Advance Pricing, WIP.

Tools: and Languages: - XML publisher, Report Builder, TOAD, SQL*Loader, SQL, PL/SQL.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Worked as a team member to implement and develop interfaces according to business requirements for Purchasing (PO), Payables (AP), Inventory (INV), Receivables (AR) and General Ledger (GL).
• Implemented and tested Purchasing solution - Procure to Pay (P2P) Integrated purchasing with payables to allow matching invoices to PO receipts.
• Customized to modify PO Approval Hierarchy and Notification
• Involved in entering transactions like Regular Orders, Inter Company Invoicing, Regular Invoicing, Invoicing with Rules and different methods of Receipt Processing and application in OM.
• Created Customer setups, Bill-To, Ship-To Locations, Price List, Order Type and other setups in OM Module.
• Developed Interface for the Standard Items of Sales Orders Import in OM.
• Developed an interface program using API for loading item On Hand quantity balances.
• Defining setup option, Accounting Flex fields, set of books, security rules, recovery Journals, Budget, Budgets organizations mass budget formulae, roll up groups in General Ledger Modules.
• Interacting with the Users and functional team during the design and Worked with end users to translate their business information requirements into technical data definitions. Work closely with business analysts to understand and document business needs for decision support data.
• Developed Interfaces using PLSQL. Creating Packages, procedures and functions using PL/SQL developer.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
• Used PLSQL extensively to write SQL outbound, procedures, packages, database for validations etc.
• Identified and worked with external groups/teams to resolve issues found in testing. Responsible in Production Deployment, Production Planning and Production support.
• Activities also involved migration of deliverables such as PL/SQL packages, LDTs, shell scripts, rdfs, rtf templates, discoverer business areas, work-books etc to various environments using the PVCS versioning tool and Kintana migration tool.
• Interacted with end user for problems faced and providing necessary technical support by fixing the tickets.

Application Modules: Oracle Applications 11i, AP, PO, OM, INV, AR, GL, Oracle8i, Forms, Reports, SQL*Loader, TOAD, UNIX, Windows 2000.

Tools: & Languages: - Oracle Discoverer, Oracle Report Builder, SQL, PL/SQL.

Confidential

Oracle Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Used Oracle 9i features such as merge for various transformations.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in transferring the data between servers using Data Pump, Export & Import
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Creating Test scripts for the generated final Reports.
• Involved in data migration from SQL Server to Oracle 9i.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Attended meetings and review to discuss current issues and processes to tackle issues.

Environment: Oracle 9.2, Reports 6i, Forms6i, Windows, Linux, Toad, SQL Developer and SQL * Loader