SUMMARY:

• Senior Oracle Applications Technical expert having 11+ years of IT experience in analysis, design, development, testing, implementation and production support of complex applications using
• Oracle Applications (Financials and Supply Chain) R12/11i/10.7 NCA/SC/10.6, Oracle RDBMS tool set for Finance, Telecommunications, Banking, MIS Applications (Inventory system) under Unix, Client Server and Windows Environments.
• Extensive noledge and experience as a Technical Expert in Implementation, Customization, Interface, Conversion, Integration, Upgrade/Migration, Designing/ Developing Extensions to Oracle Applications, Application Integration Methodology (AIM), Application Set up Activities and Production Support of Financial and Supply Chain Modules GL, AP, AR, FA, OM, Billing, Shipping, PO, CM, INV of Oracle Applications (R12/11i/10.x) in Multi Org, Multi Currency environment.
• Experience includes Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical or functional issues.
• Experienced in teh implementation of Procure to Pay (P2P), Order to Cash (O2C) business process.
• Extensive experience in oracle RDBMS design and developing stored procedures, functions, packages, triggers, views, cursors using SQL and PL/SQL.
• Extensive noledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design,
• Experience in working on Oracle OAF & JDeveloper, Oracle PL/SQL, UNIX Shell Scripting, SQL tuning, in UNIX environment.
• Experienced in SQL*Loader, import, export, UTL FILE, optimization using (analyze, explain plan, TKPROF), snapshots.
• Experienced in developing forms and reports using oracle form builder, report builder.
• Involved in exhaustive performance tuning, monitoring and optimization of PL/SQL blocks in both development and production environment, for Oracle and SQL server databases.
• Involved in large volume data integrity/data migration using PL/SQL, UNIX scripts, SQL*Loader
• Extensive experience in Oracle Discoverer and XML/BI Publisher.

TECHNICAL SKILLS:

• Oracle Financials, Supply Chain modules of versions
• R12/11i/10.7sc (AP, AR, GL, FA, CM, OM, Billing
• Shipping, PO, INV, and AOL) SQL, PL/SQL, C,Un ix - shell scripting,
• HTML, Java.
• Oracle SQL*Plus,
• SQL*Loader, TOAD,
• JDeveloper, Oracle Discoverer, Oracle Designer,
• XML Publisher, EDI
• Oracle 7.x/8i/9i/10g, MS Access,
• MS SQL Server 7.0, Oracle9iAS, Apache Tomcat4.0.1, IIS.
• Oracle Reports 6i/9i/10g,
• Oracle Forms 6i/9i/10g
• UNIX (Solaris 8/2.x, Red Hat Linux 7.x/6.x), Windows NT

PROFESSIONAL EXPERIENCE:

Oracle Applications Technical Expert

Confidential, IL

Responsibilities:

• Involved in requirements gathering, functional/technical specification, development, deploying and testing.
• Worked on several Data Conversions to load data from legacy system to Oracle.
• Developed Customers interface to integrate with EDI Gateway.
• Worked on Form Personalization to launch custom reports from Sales Order form.
• Worked on Form Personalization to validate teh items on teh Internal Requisition are found on teh Interco price list at teh time of IR approval.
• Developed several customer-facing documents such as Sales Order Acnoledgement, Quote Acnoledgement, Packing Slip, Commercial Invoice using Reports 10g and BI Publisher.
• Created ad hoc reports using Discoverer.
• Handled several post-production issues.

Environment: Oracle Applications R12 BOM, WIP, INV, AP, AR, OM, PO Oracle 11g, Reports 10g, BI Publisher, Jdeveloper, SQL*Plus, PL/SQL, Stored Procedures, UNIX Shell Scripting, AOL, PVCS

Oracle Applications Technical Expert

Confidential, TX

Responsibilities:

• Gathered requirements and involved in development and testing of various adhoc reports in 11i and R12 for auditing purposes.
• Developed several temporary tables and indexes to handle large volumes of data.
• Customized various reports Inventory Activity Summary, Purchase Price Variance, Invoice Price Variance, GL Chart of Accounts Rollup and AP Trial Balance.
• Created custom tables, views, and packages for various business requirements.

Environment: Oracle Applications 11i/R12.1.3 AP, INV, PO, GL PL/SQL, Reports 10g, BI Publisher, Stored Procedures, Packages

Oracle Applications Technical Expert

Confidential, IL

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Actively involved in teh Data Conversion from legacy system to Oracle.
• Developed SQL*loader scripts to load data into staging tables.
• Developed Conversion programs to bring Bills of Material, Routings, Suppliers, Approved Supplier List, Org Item Attachments, Sourcing Rules, Sourcing Rule Assignments and Item Cost into Oracle Applications.
• Developed several packages, standalone stored procedures, triggers and functions for various business requirements.
• OA Framework - Extended Controllers (CO) and View Objects (VO) using jdeveloper to add a custom Check Box in MES Workstation page that reads and updates database table.
• Created several reports for Business Users using Reports 10g, Discoverer and BI Publisher.
• Worked on handling post-production issues

Environment: Oracle Applications R12 BOM, WIP, INV, AP, AR, Oracle 11g, Reports 10g, BI Publisher, Discoverer, JDeveloper, SQL*Plus, PL/SQL, Stored Procedures, UNIX Shell Scripting, AOL, PVCS

Oracle Technical Expert

Confidential, IL

Responsibilities:

• Worked closely with teh Business Users and Functional Team for requirements gathering.
• Designed various Mapping, Design, and Testing Documents.
• Actively involved in teh data migration from legacy system to Agile PLM.
• Worked on various PL/SQL procedures to clean and modify teh data as per business requirement.
• Wrote several queries in Microsoft Access to retrieve legacy data.
• Created several reports for Business Users to find discrepancies in data.
• Created Mapping files to import Customers, Standards, Models and s data into Agile.
• Also worked on Change Orders and Relationships in Agile.
• Involved in thorough testing of teh data that went from legacy into Agile.

Environment: Agile PLM, Microsoft Access (2007), Oracle 10g, PL/SQL, Stored Procedures

Oracle Applications Technical Developer

Confidential, TX

Responsibilities:

• Upgraded E-Business suite from 11.5.10.2 to 12.1.1 and implemented Oracle On Demand where Oracle Applications environment is upgraded from Windows to Linux.
• Worked closely with teh Business Users and Functional Team for requirements gathering.
• Designed various Mapping, Design, Testing and Installation Documents.
• Developed Conversion Programs to bring Invoices, Suppliers and Supplier banks into Oracle applications.
• Designed, Developed, Unit-Tested and Migrated teh AR Facilities Interface, by which teh end user was able to upload to Oracle AR using a flat file (csv).
• Upgraded custom Forms/Reports 6i to Forms/Reports 10g as part of R12 upgrade.
• Customized standard reports like Cash Requirement report, Aging 7 Buckets - By Account report.
• Developed various custom reports using Reports 6i/10g and SQL*Plus.
• Analyzed and migrated some of teh Standard Reports from Oracle 6i to BI Publisher. Also worked on XML Bursting to send teh report outputs as email attachments.
• Provided production support for existing Oracle Reports.
• Modified custom form using Forms 6i to automatically submit a concurrent request report when button is pressed.
• Involved in forms personalization to meet business requirements.
• Developed custom enhancements to track HR Employee and Assignment changes, PO approval modifications, Job approval and assignments changes for Audit Purposes and developed BI Publisher reports for business users.
• Created custom Tables, Triggers, Sequences, Synonyms, Packages, Functions, Stored Procedures, for implementing various logic and functionalities as demanded by teh specification.
• Created custom responsibilities, menus based on teh User requirements.
• Extracted teh FNDLOAD Scripts, validated teh LDT files and migrated teh FNDLOAD scripts to teh intermediate instances for user testing.
• Provided Post-Production Oracle technical support and transitioned code and design documents successfully. me was able to complete successfully all teh post-production tickets, which required my support and was able to resolve issues in a timely manner. Teh tasks included working across modules in AR, AP and FA.

Environment: Oracle Applications 11i/R12 AP, AR, GL, PO, FA, HR Oracle 10g, Reports 6i/10g, Forms 6i/10g, BI Publisher, SQL*Plus, PL/SQL, Stored Procedures, SQL*Plus, UNIX Shell Scripting, AOL, PVCS

Oracle Applications Technical Developer

Confidential, Sanford, NC

Responsibilities:

• Developed several packages, standalone stored procedures and functions for various business requirements.
• Created SQL*Loader scripts to load data into staging tables.
• Designed and developed numerous packages and procedures to load data from temporary tables into Oracle base tables.
• Handled Discoverer Administration and EUL development for Applications.
• Created Discoverer Business Areas and Custom Folders for AP, GL, PO, and OM modules. Generated multiple Ad-hoc reports in end user layer.
• Customized various standard reports like Invoice Aging Report, Bill of Lading, Item Categories Report using Reports 6i.
• Developed various custom reports using Reports 6i and XML Publisher.
• Extensively utilized teh Application Object Library to register Shell Scripts, Forms and reports.
• Wrote UNIX shell script to automate teh FTP process.

Environment: Oracle Applications 11.5.10 AP, GL, FA, OM, PO, INV, Oracle 10g, Reports 6i, XML Publisher, Discoverer, PL/SQL, Stored Procedures, SQL* Loader, SQL*Plus, UNIX, AOL, PVCS

Oracle Applications Developer

Confidential, Jamesburg, NJ

Responsibilities:

• Participated in gathering teh user requirements and involved in writing technical design documents.
• Developed several packages, standalone stored procedures and functions for various business requirements.
• Extensively worked with SQL scripts to validate teh pre and post load data.
• Created database tables with complex constraints applicable to teh business rules.
• Personalized various forms according to teh business needs.
• Developed SQL*loader scripts to load data into custom tables.
• Optimized and tuned SQL and PL/SQL script using EXPLAIN PLAN and TKPROF.
• Involved in teh production release cycles and provide technical support for teh same.
• Developed and customized reports in applications using Oracle reports 6i and XML Publisher.
• Create database links between production databases.
• Migrated tables and indexes to different tablespaces.
• Developed form level triggers, menus, alerts and screens.
• Participate in data sourcing, extract data investigation process and work with teams to develop PL/SQL code to extract, clean and sort data for flat file generation.

Environment: Oracle Applications 11.5.10 OM, INV, AP, AR, GL, Oracle 9i, Reports 6i, XML Publisher, PL/SQL, Stored Procedures, TKPROF, SQL* Loader, SQL*Plus, Windows NT, UNIX, AOL

Oracle Applications Developer

Confidential, Bay Pines, FL

Responsibilities:

• Extensively involved in writing PL/SQL Stored procedures, functions and packages.
• Created Database tables with complex constraints applicable to teh business rules.
• Created new menu entries using forms personalization.
• Created a very user-friendly GUI interface, with extensive use of features of Oracle Forms 9i.
• Developed various Oracle forms and screens to change teh functionalities of Catalog Maintenance.
• Developed SQL*loader scripts to load data into custom tables.
• Developed various Complex Queries, Views for Generating Reports. Used Hints to Achieve teh Performance and Tuned SQL Queries and Stored Procedures, improved teh performance of teh Reports
• Developed and maintained UNIX Shell scripts to automate repetitive database processes.
• Developed form level Triggers, menus, alerts and screens.
• Created triggers to populate data into teh underlying tables of teh views.
• Created ad-hoc reports for teh End users using Discoverer.
• Provided scripts for export and import of schema objects, tables, data to ensure baselines for new product development and for backups.

Environment: Oracle Applications 11i, AP, AR, GL, Oracle 9i, PL/SQL, SQL*Loader, Discoverer, TOAD, Shell Scripts, Windows NT 4.0/2000/XP, UNIX.

Oracle Applications Developer

Confidential, NY

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, and development, deploying and testing.
• Provided back-end support for customized forms for customer, supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
• Doing unit testing on forms, reports, PL/SQL stored procedures, functions, triggers, packages, views and cursors.
• Analyze, design and develop stored objects in PL/SQL to support payment processing using Credit Cards, Electronic Check and Money Orders.
• Design screens using oracle developer forms.
• Design and develop relevant triggers, stored procedures, sub-programs and packages with advanced PL/SQL programming techniques such as ref cursor, collections, and bulk operation.
• Code and test Oracle stored procedures using PL/SQL.

Environment: Oracle 9i, AP, OM, PO, Developer 2000, Forms 6i, Reports 6i,Discoverer, PL/SQL Stored Procedures in Order Management, Database Triggers, TOAD, UNIX.

Oracle Applications Developer

Confidential

Responsibilities:

• Created temporary tables and developed SQL*Loader control files to load data from external systems.
• Wrote PL/SQL package to perform validations on imported data and tan load teh data to interface tables.
• Worked on interfaces and API’s.
• Developed new reports and customized teh existing reports according to teh requirements.
• Creating database triggers, PL/SQL stored procedures.
• Extensively performed DML, DDL, DCL, and Transactional Control Statements.

Environment: Oracle Apps 11i, SQL, PL/SQL, Forms6i, Reports6i, TOAD, OM, GL, AP and AR