SUMMARY:

• Over Eighteen (18) years of IT experience in analysis, design, development, upgrade and implementation phases using Oracle Application Tools in multi - user, client-server, open systems, operational and development environment.
• Oracle Modules: PO, AP, expense, AR, FA, WMS, INV, PA, GL, OAF, Workflow and AME.
• Technical Expertise in R12/11i, writing Interfaces, Conversion scripts, Oracle v7.x/8i/9i/10g, SQL*Loader, PL/SQL, Developer 6i (Forms 6i and Reports 6i) and Forms and Reports 10g, Developer 2000 (Oracle Forms v4.x and Reports v2.x), Discoverer 3i and BI publisher.
• Extensively involved in writing customizations, interfaces and Extensions on RICEW objects using PL/SQL Packages and procedures.
• Extensively worked with Oracle Application Modules in R12 (12.1.3), 11i (11.5.10) and 10.5.9 environment.
• Experience in using PL/SQL, Oracle Forms and Reports.
• Experienced in Oracle customizations software including Nucleus, CorisPlus, Oracle Energy, VMDB and OEIS.
• Worked as Oracle Consultant with major clients including Confidential on wide range of Application projects.
• Strong technical and communication skills.

TECHNICAL SKILLS:

Hardware: IBM PC/XT/AT and Sun.

O/S: UNIX, MS-Windows, MS-Windows NT, MS-DOS, VMS.

Databases: Oracle 10g, Oracle v9i, Oracle v8i, Oracle 7.x

Tools: PL/SQL, TOAD, Developer BI publisher reports, XML Gateway. Oracle Developer 6i, Developer 2000 (Oracle Forms v 6i/4.5 and Oracle Reports v 6i/2.5/2.0),Oracle Forms and Reports 9i, Oracle Forms v4.0, Oracle Reports v2.0, Oracle Discoverer 2000, Integrated GEMMS v3.21.09, Oracle Reports v2.0/2.5, SQL*Forms 3.0, SQL*Plus 3.1.

ERP Application: Oracle R12 (12.1.3) and Oracle Applications (11i) 11.5.10

Modules: PO, AP, iExpense, AME, AR, FA, WMS, INV, Projects, GL and Workflow

Languages: XML, C, C++, JAVA, ASP .NET, VB.NET

Software: Microsoft Office, Windows 2000, Remedy, ServiceNow, PVCS, FileZilla.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle Applications Developer

Responsibilities:

• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i in Iprocurement and Iexpense modules.
• Developed complex reports in Iprocurement, Iexpense, and HR and have extensive experience in Workflows, AME, APIS, PL/SQL and performance tuning.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Worked with the business functional areas to research and identify the best technical solution to support business processes.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)

Environment: LINUX x86, OAF, PL/SQL Developer, TOAD, Oracle Applications R12.1.2, Oracle Reports 10g, SQL*Plus, Oracle BI Publisher 10.1.3.

Confidential, Houston, TX

Sr. Oracle Applications Developer

• Extensive experience as Oracle Applications e-Business Suite Consultant and Technical Developer in Design, Development and Implementation of Oracle Applications R12/11i.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Finance Suite.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in FA, General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO).
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder.
• PL/SQL: Worked on analyzing specifications and coding complex PL/SQL stored procedures, packages, API Calls and Bulk Collect.
• Interfaces: Written Inbound/Outbound interfaces to Third Party Applications.
• Production Support: Monitoring interfaces, concurrent programs, trouble shooting.
• Extensively worked on performance tuning using Explain Plan, Indexes, Hints, DBMS profiler, SQLTRACE, and TKPROF.
• Expert knowledge in Oracle reports 10g and BI Publisher reports.
• Have knowledge of Discoverer reports.
• Successfully delivered design of schema requirement in database, size, table structures, and Process flow through packages, procedures and triggers.
• Extensively involved in preparing detailed CEMLI methodologies and documentation (MD15, MD50, MD70, and MD 120).
• Worked on customizing complex workflows.
• Good knowledge of generating account generators.

Environment: LINUX x86, OAF, PL/SQL Developer, TOAD, Oracle Applications R12.1.3, Oracle Forms and Reports 10g, SQL*Plus, Oracle BI Publisher 10.1.3.

Confidential, Houston, TX

Oracle Applications Technical Consultant

• Worked on analyzing the data and creating procedures, triggers and packages and Bulk Collections.
• Worked on Oracle Application modules on R12 Upgrade (11.5.10 to R12).
• RICEW: New or modify existing RICEW objects using complex procedures and packages for PO, AP, FA AR and GL modules using Oracle PL/SQL and TOAD. Called Oracle API’s and modified Oracle Extensions.
• Oracle Personalization’s: Accomplished business requirements through personalization for PO, AP, AR, FA and GL screens.
• Written Oracle MD50-Design, MD70-Technical and MD120-Installation documents.
• Have created workflows from scratch and expert knowledge of account generators.
• Worked with the business functional areas to research and identify the best technical solution to support business processes.
• Proficiency with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, Workflow Builder.
• Experience in designing, developing, testing, performance tuning and supporting database applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Provided on-call and day-to-day support and worked as a part of team in 24x7 production environment.
• Interaction with the offshore development team for development of reports and changes needed in the requirements.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle, Applications R12.1.3 (AR, Invoicing, AP, GL), Oracle v10G, SQL*Plus, PL/SQL Developer, Oracle Forms and Reports 10g, Toad, and BI Publisher and experience in PO/AP/AR/GL /FA & Workflow Modules in OAF framework.

Confidential, Houston, TX

Sr. Oracle Applications Consultant

• Provided full support while batch processing and resolved errors within stipulated time period without affecting business process.
• Used TOAD, PL/SQL developer & SQL Developer tools for faster application design and developments.
• Worked with Data Stage for ETL purpose and transformation.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.
• Worked on PL/SQL Tuning and in reducing the cost of the queries.
• Created complex procedures and packages.
• Heavy use of PL/SQL Collections & Bulk collections and oracle analytical functions.
• Expertise in all the phases of System development life Cycle (SDLC)
• Writing code for enhancing existing programs or developing new programs.
• Experience programming PL/SQL batch environment utilizing large tables and high transactionthroughout requirements.
• Experienced in working with many complex SQL queries with joins, date functions, inline views,cursors, ref cursors, collections, partition tables, external tables, materialized views, sub-queries and analytical queries to generate reports.

Environment: HP UNIX, PL/SQL, Oracle 10g, Toad.

Confidential, Houston, TX

Sr. Oracle Applications Consultant

• Worked on reports, Form customizations, ETL Tools including XML Publisher.
• Written PL/SQL Stored procedures and packages in R12.
• New or modify existing RICEW objects using complex procedures and packages for PO, AP, FA WMS, INV and GL modules using Oracle PL/SQL and TOAD. Called Oracle API’s and modified Oracle Extensions.
• Designed, Developed and tested Complex Oracle Forms & Reports in Oracle Applications modules.
• Accomplished business requirements through personalization’s for PO, AP, AR and GL screens.
• Worked on data conversion and R12 implementation project.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle, Applications v 10.2.0.2.0 (AR, Invoicing, AP, GL), Oracle v10G, SQL*Plus, PL/SQL, R12 and experience GL/AP/AR/PO and FA modules.

Confidential, TX

Sr. Oracle Apps Consultant

• Worked on complex Unix Shell scripting to automate the process.
• Write complex PL/SQL Packages and Procedures and tune them in 10g.
• Worked on Oracle Application Conversions and R12 Upgrade projects.
• Worked on customer and AR Interfaces and custom conversions.
• Designed XML Templates AP payments for Global EFT/ACH/FX bank payments using Oracle XML Publisher.
• Written Inbound/Outbound interfaces to Third Party Applications.
• Worked on Reports, Form customizations, ETL Tools including XML Publisher.
• Written Oracle Design (MD50), Technical (MD70) and Installation (MD120) documents.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v10G, SQL*Plus, PL/SQL, MS SQL Server, .VB.NET, XML Gateway. R12 and experience in BOM, WIP, INV, GL, AP, AR, PO and oracle assets modules.

Confidential, Clearlake, TX

Sr. Oracle Developer

• Implement and Write PL/SQL Packages and Procedures in 10g Environment.
• Worked on Complex VB.NET Programs.
• Worked on complex Unix Shell scripts to automate the process.
• Worked on GL Interface and custom conversions

Environment: Experience in 11.5.10 AR/AP/PO/GL, FA and GL modules, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus, PL/SQL, VBNET.

Confidential, Houston, TX

Sr. Oracle Developer

• Worked on complex Unix Shell scripting to automate the process.
• Customize and Support Oracle Custom Development.
• Lead Role in Oracle Customizations.
• Have written complex procedures and packages using PL/SQL and tested Complex Oracle Packages.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle v9i, Oracle Discoverer 4i/3.1 (Forms 6i and Reports 6i), SQL*Plus.

Confidential, Houston, TX

Sr. Oracle Developer

• Have written PL/SQL packages and called API’s in stored procedures and packages.
• Customized Oracle Forms and Reports.
• Worked on AP Interface ABOB Report, EGL AP Overhead Payables Report, Budget-to-Actual FA Report, and EGL.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle, Applications v11.5.9 (AR, Invoicing, AP), Oracle v9i (Forms 6i and Reports 6i), SQL*Plus.

Confidential, Houston, TX

Oracle Developer/Analyst

• Developed interfaces for Vertex tax module to AR.
• Developed APIs to interface external systems to Oracle applications modules using Oracle Open interfaces.
• Responsible for creating stored Procedures and Packages for Back office Invoicing-using PL/SQL.

Environment: Windows NT, HP UNIX, PL/SQL, Oracle Financials v11i (AR, AP, Workflow), Oracle v8i, Oracle Developer 6i (Forms 6i and Reports 6i), Oracle Discoverer, Nucleus.

Confidential, Houston, TX

Programmer/Analyst

• Worked on Open Interface, Inventory, CorisPlus and Invoicing modules: Have written open interface procedures and packages Globalization of CORISplus Reports using Reportsv2.5.
• Team member in preparing specifications and documentation for Inventory, Customer, Invoicing and Interface modules.
• Provided technical support and troubleshooting for month-end closings for AR and Invoicing modules.

Environment: Windows NT, Digital Unix, PL/SQL v2.3, Oracle v7.3, Developer 2000 (Forms 4.5 and Reports 2.5), Oracle Discoverer, AOL v7.5.7.

Confidential, Houston, TX

Oracle Energy

• Worked on PL/SQL procedures and packages, Interfaces, Oracle Forms, Reports and Discoverer 2000.

Environment: HP-Unix, Windows NT, Developer 2000, Discoverer 2000, Forms 3.0/4.5, Reports 2.0/2.5, Server-K460.

Confidential, Houston, TX

Oracle Developer

• Involved in the customized development and testing of Oracle Financials Reports.

Environment: Novell NetWare, HP-UNIX, Developer 2000, Discoverer 2000 (Oracle Browser v2.0), Oracle Financials v10.5, Integrated Gemms v3.21.09.

Confidential, Houston, TX

Oracle Developer

• Involved in the development and testing of Vehicle Master Database (VMDB).
• This system provides tools for the management of ISS (International Space Station engineering data for Confidential .
• Was responsible for the development of Complex Database Procedures, Functions and Packages.

Environment: UNIX, Sun, Oracle v7.1, Oracle Forms v4.0, Oracle Reports v2.0.

Confidential, Houston, TX

Oracle Developer

• Involved in the development and testing of Oracle Environmental Information System (O.E.I.S) project being developed by Confidential for 13 major clients.
• Responsible of the development of two modules using Forms v4.5.

Environment: MS-Windows, NT, Sun, Oracle V7.1, Oracle Forms V4.5, and Oracle Reports V2.5.