SUMMARY:

• Having around 6+ years of IT experience in developing cost - effective solutions as Technical Consultant using Oracle Applications R12, SQL, PL/SQL, Oracle RDBMS, Developer 2000 ( Forms and Reports), XML/BI Publisher and Discoverer Admin and Desktop.
• Extensively worked on Oracle ERP modules like Supply Chain Modules (PO,AP,GL,INV and OM) and AOL Objects.
• Technically proficient in RICE (Reports, Interfaces, Conversions, Extensions) Components.
• Having Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, collections, records, views, materialized views and Packages using PL/SQL.
• Strong knowledge in Oracle cursor management and exception handling.
• Hands on experience in design, development of end user screens and reports using Oracle Forms and Reports.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities like UTL FILE.
• Good knowledge on business flow’s in Procure-to-Pay and Order-to-Cash cycles.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Expertise in System Administration including oracle application activities like application user setups, defining responsibilities, request groups, value sets, registering, menus, forms, reports, Concurrent programs and providing support to apps users for any technical and functional issues.
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• Well versed with Unix Shell Scripting and Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
• Extensive experience in developing and customizing Reports using XML/BI Publisher with xml data template, Oracle Reports and Discoverer Reports.
• Expertise in requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
• Thorough knowledge of Oracle Apps Data model and how to leverage the data for effective Reporting.
• Possess strong technical skills and business knowledge coupled with product knowledge in Oracle E-Business Suite.
• Interact with people at all levels. Possess excellent communication and problem solving skills, and work ethics.

TECHNICAL SKILLS

ERP: Oracle Applications EBS R12 with Oracle

Databases: Oracle Database ( 9i, 10g, 11g )

Languages: SQL, PL/SQL, Advanced PLSQL like Collections, Varrays, Nested Tables, Index by tables,etc.

ERP Processes: PO, AP, GL, INV, and OM. Procure-2-Pay (P2P) and Order-2-Cash (O2C)

Technical Applications: AOL and SYSADMIN

Reporting Tools: Developer 2000, XML Publisher and Discoverer Reports.

Development Tools: TOAD, SQL*Plus, SQL Developer

Operating System: Windows XP/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, New Jersey, US

Technical Consultant

Environment: Oracle App, SCO-Unix, Window NT, Oracle 9i, Reports 6i, Forms 6i, Discoverer, TOAD, SQL*Loader, PL/SQL, SQL* Plus, AP, AR, PO, GL, OM and INV.

Responsibilities:

• This Project involves Implementation of Oracle Applications, Customized business application that runs entirely on Oracle E-Business Suite Server. I am a part of development team and mainly responsible for Design and Development
• Define value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures and Packages.
• Involved in the development of technical documentations of reports and interfaces.
• Worked closely with end-users/clients through complex problems involving deployment, Testing and conversion in procure to pay cycle.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the legacy system.
• Worked on Oracle's FNDLOAD utility for transferring/migrating Concurrent Programs, Request Sets.
• Developed Invoice and Customer conversion.
• Performed unit testing, integration testing for the PL/SQL interfaces developed.
• Customized shipping reports namely pick slip, packing list in OM, and Open Purchase order reports in PO.
• Customized Invoice History Report in Account Payable.
• Customized Payment Term Listing in Accounting Payable.
• Developed Purchase Order Invoice receipt Report as per user requirement.
• Involved in development of GL Transactional report to show the Journal Details.
• Developed Credit and Debit memo Account Payables Invoice Report.
• Involved in development of GL Transactional report to show the Journal Details.
• Worked on Customizing Oracle Sales Order report in Order Management.
• Developed GL Inbound Interface to import the Journals data from Legacy to Oracle applications GL base tables using the standard program ‘Journal Import’.
• Developed Outbound Interface in Oracle Inventory module to extract the data from Inventory base tables to Flat file by using the UTL FILE Package.
• Developed Purchase Order Inbound Interface.
• Customized Oracle standard PO forms calling the ZOOM functionality as per the client requirement.
• Developed XML/BI Publisher reports.
• Developed Discoverer Reports.
• Developed new Forms in Oracle Inventory to displays the Item Quantity details.

Confidential, Hartford, CT

Technical Consultant

Responsibilities:

• This Project involves Migration of Oracle Applications Customized business application that runs entirely on Oracle E-Business Suite 11i. As a technical consultant actively involved in Migrate, Customization of reports, developing interface programs, concurrent programming, PL/SQL procedures, functions and working on various modules of Applications.
• Registered PL/SQL Packages, Forms, Menus and reports as concurrent programs.
• Created D2K, XMLP Reports and worked extensively on Oracle backend with packages, Functions, Procedures.
• Designing and reviewing the technical documents.
• Development of Interface programs to Import the data from legay system Oracle Apps base Tables using SQL *Loader.
• Worked on creating application mode End User Layer, building business areas, and building Discoverer workbooks.
• Developed PL/SQL packages, procedures, functions for interface program to validate the data for AP, PO, OM, and INV modules.
• Customized Open Purchase Order print report.
• Customized various reports in Inventory like Inactive Items Report.
• Developed Inventory Report to show the on hand Quantities details of the item as per client requirement.
• Developed Requisition Report to show the PO Requisition Details which are approved according to the Supplier.
• Developed Credit and Debit memo Account Payables Invoice Report.
• Created application forms to meet the specific business needs using built in features available with Template.fmb form and its built-in stored procedures and attached libraries.
• Experience in customization of forms in Oracle Application using standard AOL functionalities using CUSTOM.PLL.
• Developed Purchase Order Interface Program to Transfer the Data from Legacy System to Oracle PO Base Tables.
• Developed package to extract the data from base tables into flat files by using UTL FILE Package.
• Registered concurrent programs, request groups for reports and concurrent requests.
• Combined both the concurrent programs as a request set.
• Performed unit testing, integration testing for the PL/SQL interfaces developed.
• Developed a SQL*Loader program which will populate the data from a flat file into a temporary table and registered that as a concurrent program.
• Customized Prepayment Detail Report.
• Developed Match Approval Purchase Order Report as per user requirement.
• Developed Open Purchase Order Lines Report.
• Performed AOL administration activities like creating request sets, creating responsibilities, creating users, adding menus etc.
• Involved in importing ITEMS from legacy system to Oracle Application base table MTL SYSTEM ITEMS B using the standard item import program. Wrote package to validate data before loading into the corresponding interface table.
• Developed Purchase Order Interface Program to Transfer the Data from Legacy System to Oracle PO Base Tables.
• Developed package to extract the data from base tables into flat files by using UTL FILE Package.
• Developed interface program to upload items into GL interface tables from Legacy System in Oracle General Ledger.
• Developed a custom interface, which will send PO information to external system.
• Well versed with Forms Customization.