SUMMARY

• A highly motivated Oracle Applications Technical Consultant with 8 years in oracle applications with excellent knowledge on SQL, PL/SQL, Financials, SCM, Manufacturing, Oracle Forms& Reports.
• 8 years of experience as an Oracle Applications Technical Consultant.
• Expertise in Technical and Functional aspects of Oracle E - Business Suite (EBS) applications 11i/R12 Financial, SupplyChain, Order to cash and Manufacturing Modules which include Trading Community Architecture (TCA), Pricing (QP), EDI, AOL, General Ledger (GL), Service Contracts, Install Base, Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO),Inventory(INV) Cash Management (CM), Fixed Assets (FA), Oracle Time and Labor (OTL).
• Diversified technical expertise in Oracle E-Business Suite (EBS) Applications 11i/R12.
• Expertise in Functional Oracle Modules (Financials and CRM): iExpense,iProcurement, Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Sales Online, Install Base (IB), Field Service Technical Portal (FSTP).
• Experience in designing, developing and troubleshooting Reports, Interfaces, Conversions and Extensions (RICE) in Oracle Applications.
• Involved in implementing versions/upgrades of Oracle Applications 11i, and involved in implementing Oracle E-Business Suite Applications R12 for Oracle Business.
• Expert in Oracle Application Framework (OAF), customization, extension and creation of new OAF pages in Jdeveloper 9i/10g environment.
• Worked on creation of Purchase Order through API.
• 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.
• Experience in design and development of Interfaces, Conversions and Data Migration using SQL*Loader, Oracle Open Interfaces, APIs and UTL Files.
• Experience in handling Version control tools like PVCS, MERCURY, SERINA.
• Extensive experience in Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Knowledge in creating various navigations such as Purchase Order Collaborations, Shipment notices, Invoices and payments, Inventory Management and Supplier management with excellence in Order Management background and a very good understanding of the Order-to -Cash cycle.
• Involved in the customization, extension and personalization of OAF Components.
• Solid Knowledge on Oracle Identity Manager(OIM) and Oracle Waveset (OW).
• A methodical approach to problem solving to go with effective programming and coding techniques has led to a defined clarity in various stages of Software development life cycle (SDLC).
• Extensive experience in working with SQL Queries and in creating database objects like Tables, Triggers and Views.
• Having sound understanding of all phases of End to End ERP implementation such as Business process studies.
• Experience in Oracle Channel Revenue Management.
• Extensively worked on developing and customizing reports in 9i/10g/11g.
• Solid Knowledge and understanding of AOL/FND and TCA architecture.
• Extensively worked in Technical Design Documents using Application Implementation Methodology (AIM).
• Acquired sufficient level of good functional knowledge on financial accounting and business processes.
• Expertise in System Administration activities like application user setup, defining concurrent programs, responsibilities, values sets, flex fields, registering menus, forms, and reports.
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups.

TECHNICAL SKILLS

Oracle Applications: Version:R 12/11.5.10.2 Modules: GL, AP, AR, FA, INV, BOM, WIP, WSH,PO,OM,PA,HRMS,OIM

Database: Oracle10g/9i/8i

Tools: Forms 6i/9i/10g,11g, Reports 10g/9i/6i (Custom Libraries )SQL* Plus, SQL*Loader, SQL, XML Publisher/BI Publisher, Toad.

Languages: SQL, PL/SQL, C,C++,Java, UNIX Shell Script, XML

OS: UNIX (Sun/Solaris, HP)MS-Windows - NT, 2000 & MS-DOS

PROFESSIONAL EXPERIENCE

Oracle Apps Technical Consultant

Confidential, Richmond, Virginia

Environment: Oracle Apps R12/11.5.10, Oracle10g, SQL, UNIX, PL/SQL, Toad, Sql*Loader, XML/BI Publisher, MS-Office.

Responsibilities:

• Developed PL/SQL Packages, Procedures, 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.
• Hands on experience in INV, WIP, BOM,AP within the Oracle E-Business Suite (EBS) System.
• Worked on Accounts Payables (AP)to test Auto create invoices, payment Schedule, Posting and Period closing.
• Imported data from Legacy system to Account Receivables tables using SQL*Loader and validated them using PL/SQL Procedures.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• 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.
• Written Shell scripts which are used to call the Concurrent programs and these shell scripts were used in scheduling the Interfaces and other Extract programs.
• Worked on customizing iProcurement Requisition and Receiving pages.
• Created new concurrent request set and scheduled the Order Import interface program to run periodically.
• Experience in Channel Rebate and Point-of-Sale Management.
• Worked on AP to FA Interface to transfer AP Invoices to Fixed Assets.
• Extensively worked on Oracle Payments and iExpenses modules and extended and personalized various OAF pages including extensions of AM and Controller.
• Developed interfaces to load the General Ledger Data from legacy system into GL JE BATCHES,
• Worked with various third party vendors and end business users to work on the day-to-day production issues and also during business impacting changes and deployments in Oracle EBS to identify potential Setup/ Request changes to be made, identify bugs and apply necessary patches and use various performance tuning techniques (if necessary) to fine tune the existing business systems.
• Development of Oracle Order Management Inbound interface to load massive amount of Open Purchase Orders Programmatically by running user friendly concurrent programs.
• Customized Oracle standard report “Payables Account Analysis Report” to meet the business needs.
• 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.
• Developed Order Management, Inventory, Receivables, Shipping, Warehouse Management, Pricing queries to compare summary information of the standard and custom reports.
• Experience in Creating Planning Production Orders, Creating Firm Planning Orders, Creating Batches and Reversing Ingredients in OPM.
• Support and troubleshoot ERP modules that include iRecruitment, Manager Self-Service (HR) module.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Designed and developed reports and also trained the End Users.
• Bi Publisher (XML Publisher)/ Report Builder -
• Created templates for seeded oracle report such as Customer Invoice, Purchase order, Request for quotation, Dunning letter.
• Created Complex Matrix reports in XML/BI Publisher
• Created output format in XML, new templates for XML Publisher to display the reports in client requirement format.
• Collection, analysis and consolidation of users reporting requirements.
• Utilized FND REQUEST API to submit concurrent Program from Oracle Report after Report Trigger.
• Customized check printing report as per the business requirements.
• Unit & System testing for the developed components.
• UNIX shell scripting to move the files between interface directories.

Oracle Apps Techno Functional Consultant

Confidential, San Antonio, Texas

Environment: Environment: Oracle Applications 12.1.3 GL OM, AP, Microsoft SQL server 2008, Oracle 11.2.0.3, SQL *Loader, BI/XML Publisher 10g, SQL, UNIX, PL/SQL,Toad.

Responsibilities:

• Worked on creating the data mapping and interfacing the GL journals from the legacy system. Also defined GL batches, sources, categories and wrote SQL*loader scripts and PL/SQL script for the interface process.
• Developed various interfaces in GL, AP, AR, PO and OM which includes development of SQL Loader, validation process, record status notifications and publishing records status reports.
• Provide extended support during GL month end close process.
• Provided a performance optimized General Ledger (GL) integration improving GL accounting, reporting and accuracy.
• Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page.Modified PL/SQL custom extension.
• Defined customer profiles, customers, payment terms, payment methods and tax structures, including tax exemptions and exceptions in Accounts Receivables.
• Designed and developed SOA components to integrate ERP to Legacy Systems.
• Integrated ERP system to PMCS system using SOA components.
• Responsible for requirement analysis, design and development of custom applications in OAF.
• Designed and Implemented Order Discount Hold system and developed reports for holds placed and released.
• Analyzed and developed business requirements as necessary using advanced PL/SQL programming, Oracle Forms & Reports etc.
• Developing FA XML Publisher Reports, Form Personalization, Package creation and Performance Tuning.
• Customized many reports and also created new reports as per client requests using Report Builder and XML Publisher.
• Converting and migrating Customers and billing data from other systems into the new billing system.
• Developed Custom Interface programs using API’s.
• Customized OM Sales Acknowledgement report by Sales Reps.
• Developed interface scripts for importing Items from legacy system to Oracle inventory.
• Developed reports in Oracle inventory for comparison of available and on-hand quantities in various lots and sub-lots.
• Developed XML template for invoice report using XML/BI Publisher.
• Responsible for maintenance and fixing issues involving UNIX scripts for Rating/Billing/Invoicing/Formatting functionality on Rating (Pipeline) and Billing (Infranet) servers.
• Developed a package to import information into base tables.
• Worked on Auto Invoice to bring the legacy invoices in to Oracle in AR.

Oracle Apps Techno Functional Consultant

Confidential, Dayton Beach, FL

Environment: Oracle Applications, AP, PO, INV,OM, Shipping modules, UNIX, Oracle 11.2.0.3, and 12.2 SQL *Loader, BI/XML Publisher 10g, Forms 10g, SQL, PL/SQL, Toad

Responsibilities:

• Developed various interfaces in GL, AP, AR, PO and OM which includes development of SQL Loader, validation process, record status notifications and publishing records status reports
• Developed scripts to extract data from Oracle for General contractor Purchase Orders.
• Inserted project related Pos in to Purchasing module.
• Creation of new Qualifier Context and Attribute grouping for the Item attribute pricing (Custom API extension for advanced pricing).
• Involved in the Unit testing of Purchasing Module conversion Objects.
• Good knowledge in Supply chain Management in Oracle E-Business suite.
• Worked on Oracle Order Import API to validate and load the information from the interface tables into Oracle Order Management.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Involved in Development and Implementation of Customer Interface using TCA APIs, to bring customers into Oracle AR which arecreated in Legacy system, on a Daily basis.
• Involved in Importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.
• Developed payroll reports and interfaces between customer and ADP
• Developed various benefits interfaces which includes inbound from Cigna and out bound to Cigna.
• Created extra information types for each location.
• Created an interface for flex field values programmatically.
• Created vendors, vendor sites and vendor contacts related to the GBL.
• Customized standard PO Print report in PDF format.
• Designed and developed customers and their related information in AR.
• Invoice information and other related information in Oracle Applications is interfaced into the legacy Accounts Payables system by an outbound program.
• Defining or Modifying Responsibilities, Menus, Functions, Request Groups, Reports, Forms, Concurrent Requests,Request Sets, Concurrent Programs, Value-sets and defined Flex Fields.

Oracle Financial Technical Consultant

Confidential

Environment: Oracle Apps 11i/r12 Financial (GL, AR,AP,OM,PO), XML/BI Publisher, SQL, PL/SQL, SQL*Loader, Reports 9i/10g, Forms 9i/10g, UNIX

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.
• 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.
• Developed BI/XML Publisher reports in R12.
• Customized the RXi report in R12 for the AR Unapplied and Unresolved Receipts Register.
• Worked on performance tuning of various views/tables for better report execution time.
• Scheduled jobs on a daily/weekly/monthly basis and custom coded the forwarding mechanism of the reports outputs using third party scheduling tools.
• 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.
• Involved in development of reports based on business requirements and registered them in Oracle applications.

Oracle Apps Technical Consultant

Confidential, Houston, Texas

Environment: Oracle Apps 11i, GL, AP, AR, Sys Admin, Oracle 9i, Forms 6i, Reports 6i, XML Publisher, PL/SQL, SQL*Loader, Sun Solaris OS 2.8

Responsibilities:

• Worked on AP to FA Interface to transfer AP Invoices to Fixed Assets.
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format .
• Worked on Requisition Import Interface and Auto create Purchase Orders API, make changes to improve performance.
• Developed reports in AP and AR modules using Reports 6i.
• Worked on creating the data mapping and interfacing the GL journals from the legacy system. Also defined GL batches, sources, categories and wrote SQL*loader scripts and PL/SQL script for the interface process.
• Create XML publisher templates and attached them to their corresponding RDF files.
• Have done mapping 10.7 reports to 11i XML templates, writing Extent and Validation rules, plugging Validation and extends to Payment Process.
• Modified the Oracle seeded reports according to the end user requirements.
• Report using Developed customer invoice, Purchase Order XML Publisher.
• Create XML publisher templates and attached them to their corresponding rdf files.
• As per the company requirements, created and implemented XML Publisher reports for different products like AP and GL.
• Created new custom reports in XML/BI Publisher.
• Upgraded Standard 6i reports to XML/BI publisher reports.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Created Complex Matrix reports in XML/BI Publisher.

Oracle Developer

Confidential

Environment: Oracle Applications 11i, Oracle 9i, AR, AP, OM, INV, Reports 6i, Forms 6i, PL/SQL.

Responsibilities:

• Developed RICE objects as part of implementation of financial modules .
• Responsible for the design, development and import of invoice information into Oracle Receivables(AR).
• Designed and Developed packages for Journal Import Interface(GL) to import journals information into the system.
• Involved in defining inventory structures and controls for designing and implementing flexible inventory management system.
• Customized check printing report as per the business requirements.
• Wrote scripts in PL/SQL to download data into text files from various tables using DBMS UTL file package and procedures.
• Developed mapping documents to load purchase orders.
• Responsible for the design, development and import of invoice information into Oracle Account Receivables(AR).
• Customized some of the standard reports such as customer item cross references report, customer items report, item categories report, import customer items etc. according to the business requirement.
• Extensively worked with Open Interfaces in AR to create invoices from external feeder system through Auto Invoice and create receipts through Auto Lock box.
• Developed custom PL/SQL conversion program for loading PO Vendors using Oracle Standard Vendor API.
• Used Order Import to import data into Order Entry/Shipping for processing.
• Resolved the performance issues of key reports in AP, AR.