SUMMARY:

• Over 7+ years of experience as an Oracle Applications consultant with expertise in Oracle Financial modules(General Ledger GL, Account Payables AP, Account Receivables AR), Supply Chain Management modules (Order Management OM, Purchasing PO, Process Manufacturing OPM, Inventory INV, Shipping WSH, Fixed Assets FA, Enterprise Asset management EAM, Advanced Pricing).
• Experienced in various full life cycle implementations, production support, and upgrading Oracle Applications.
• Involved in upgrading the system from oracle applications 11i to applications R12.
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Extensive experience in developing and modifying CEMLI (Configuration, Extension, Modification, Localization, Integration).
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data into Oracle Applications using PL/SQL and SQL*Loader.
• Expertise in Workflow, UNIX Shell Scripting in UNIX Environment.
• Extensively worked on PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Good knowledge in Order to Cash (O2C) and Procedure to Pay (P2P) business flows.
• Good Knowledge and understanding of Application Object Library (AOL) and Trading Community Architecture (TCA).
• Design and Development of Customized Order Cycles using Oracle Workflow
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Extensively used Oracle Application Framework (OAF) applications for creation of OAF pages, extension and customization of OAF pages in JDeveloper 11g environment.
• Firsthand knowledge and experience on all OAF concepts: list of values, page redirect, partial page rendering, View Objects(VO), Entity Objects(EO), Application Module(AM), SPEL, VO Extensions, CO Extensions, Personalizations etc.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
• Customized existing forms appearance and incorporated new functionalities. Developed new forms using template.fmb and custom.pll.
• Efficient in developing reports by using bind and lexical parameters using Reports 6i/9i/10 g.
• Strong knowledge of data conversions from legacy system into Oracle Application modules.
• Experienced in Performance Tuning and analyzing using Tkprof, SQL Trace, and Explain Plan.
• Excellent Interpersonal communication, documentation skills and experience coordinating with project managers, business analysts, Architects, DBA’s and Developers.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 documents.

TECHNICAL SKILLS:

Tools: Oracle Forms 10g/6i/4.5, Reports 10g/6i/2.5, Workflow Builder 2.6.3.5, Discoverer10g/4i, SQL Navigator, Oracle JDeveloper 11g, TOAD, SQL*PLUS, EDI, Export, Import, SQL*Loader, SQL*PLUS, XML publisher 5.6.3/5.6.2, OA Framework

ERP/CRM: Oracle Applications R12/11i/11.0.3

Applications: Oracle Manufacturing OM, PO, INV, OPM, WSH, BOM, WIP, EAM, Oracle Financials GL, AP, AR, FA, AOL, Sys. Admin, iProcurement

RDBMS: Oracle 7.x/ 8i/9i/10g, Access, SQL Server 7.x, 2000

O/S: Windows NT/XP/2000/98, UNIX, Linux, MS - DOS

Languages: SQL, PL/SQL, Web PL/SQL, C, C++, C#, Java, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Responsible for customization of R12 modules like OM, Purchasing, AP, AR, GL and INV.
• Involved in complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
• Responsible for developing PL/SQL packages to coordinate with a third party automated control system called LSI to access the database and log operational data into staging tables which will then be processed through custom interfaces to process the data and perform necessary actions.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts
• Worked on UNIX server to create custom directory structure in dev instance.
• Involved in customization of various reports as per the user requirements, which includes customized mailing label report, sales order acknowledgement report, Order Status Summary report, printed purchase order and packing slip report, Vendor Performance report.
• Developed PL/SQL Triggers to monitor the database activities and to implement the necessary database constraints.
• Extensively used bar coding to generate data into flat files and then extracting and processing the data using SQL Loader.
• Worked extensively on CEMLI (Configuration, Extension, Modification, Localization, Integration) framework.
• Part of performance tuning team, tuned PL/SQL code and SQL queries using Execution plan and TOAD.
• Worked on integrating Oracle database with a subsidiary of the company running on Microsoft Access Database to pull necessary data required by the application by using Data Mapping, Triggers and Procedures etc.
• Created and maintained technical documentation such as Source to Target mapping, Technical Architecture Design, Data Flow Diagrams and Application Support Manual.
• Worked on customizing existing OAF Screens, forms and reports as per business needs using custom PLL's, OAF Substitutions, Form Personalizations.
• Customized supplier inquiry page using VO Extension and controller extension of OA Framework using Oracle JDeveloper .
• Developed a custom page using OA Framework to register new suppliers and submit for approval.
• Implemented a sophisticated Coil Tracking system thereby providing the ability to track the inventory throughout its timeline.
• Developed a bidding system for creating price lists for existing and potential customers upon which will be used to generate sales orders.
• Coordinating with other teams of the project for pre and post development (Business team and Functional team).

Environment: PL/SQL, SQL, OA Framework, Oracle JDeveloper 11.1.1.3, TOAD 12.0.0.61, SQL *Plus, SQL Loader, Windows 7, UNIX, Oracle 10g, Oracle Applications R12, Oracle Reports 10g/6i, Oracle Forms10g/6i.

Confidential, Houston, TX

Oracle Technical Consultant

Responsibilities:

• Responsible for customization of R12 modules like OM, INV, Project Accounting, FA and EAM.
• Customized Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PLSQ L package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Involved in analysis, design and development of integration interfaces between Legacy systems and Oracle OPM.
• Personalization of Oracle forms like, Order Entry, Item Master, Material Transactions and various other forms using custom.pll, as per the client’s requirements, using Oracle Forms
• Provided the support in fixing the issues and enhancements related to OPM, Purchasing-OPM, Inventory and Legacy related interfaces.
• Customized standard Oracle Applications reports and developed custom reports in INV, OM and FA modules.
• Involved in handling issues related to EAM Work Orders and Assets Interfaces from POMD and QTrac legacy systems to Oracle.
• Expertise in generating reports using Oracle Reports 6i meeting variety of Business needs including custom Reports.
• Created and modified Oracle alerts to tailor customer’s needs and requirements.
• Worked on Fixed Assets Retirements and Sales from one organization to the other organization.
• Designed and developed Workflow Reprocess Interface Program, which will retry any workflow process that is error out.
• Developed custom solutions for Oracle forms using OAF JDeveloper .
• Involved in Implementation of business specific customizations using Oracle Applications Framework (OAF), to add 2 fields to capture the WorkOrder# and WorkOrderJob#.
• Involved in customizing Password Reset application in OA Framework.
• Personalized seeded and custom OA Framework pages to hide fields and buttons on the pages using Oracle JDeveloper.
• Developed UNIX scripts to perform various functionalities.
• Integrated BI publisher Report with the OAF Page (Button).
• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client requirement format.
• Involved in Defining Data groups, Request groups, Registering new forms and Reports, testing new forms and Reports from browsers etc.,
• Followed MD50 functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.

Environment: : Oracle Applications 11.5.10 (OM, INV, OPM, FA, EAM), OA Framework, Oracle JDeveloper 11.1.1.2, Reports 6i, XML/BI Publisher, Toad, SQL*PLUS, UNIX.

Confidential, North Carolina

Oracle Technical Consultant

Responsibilities:

• Responsible for implementation and customization of R12 modules like OM, INV, PO, PA and Purchasing.
• Customized standard Oracle Applications reports and developed custom reports in OM, WSH and INV modules
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Involved in designing of Conversion/Interface Implementation Strategy for Accounts Payable and Accounts Receivable.
• Design various XML publisher reports in BOM, WIP and Order Management modules
• In AP supplier Interface, used SQL *Loader to load data from flat file to staging tables, validated the records in the staging table then loaded into Ap supplier interface table. Validation scripts validated items like Vendor id, Ship to location, currency code and so on.
• Developed procedures, packages, views, functions and triggers using PL/SQL & SQL to transform data between source staging area to target staging area.
• Created promotion packages to migrate the custom objects to different instances using FNDLOAD and UNIX shell scripts.
• Expertise in generating reports using Oracle Reports10g meeting variety of Business needs including custom Reports.
• Worked extensively on RICE ( Reports, Interfaces, Conversions, Extensions) components.
• Developed new forms in Project Accounting, Purchase and done customization in Requisition, Purchase Order forms through form personalization
• Involved in Defining Data groups, Request groups, Registering new forms and Reports, testing new forms and Reports from browsers etc.,
• Worked on personalization and extensions of Oracle standard pages using Oracle Applications Framework (OAF). Have extended the HRMS Self Service screens using OAF to meet the various business requirements using Oracle JDeveloper 11g.
• Personalized HRMS screens using OAF.
• Created the materialized views and also created the partitioning tables.
• Developed forms personalization and XML Bursting reports and Account Generator Workflow Customization.
• Provided support and fixed issues during testing of the products and after go live.

Environment: : Oracle Applications - R12 (AR,AP,PO,GL,FA,PA,OM, HRMS, INV, Advanced Pricing, iProcurement), Oracle 10g, OA Framework, Discoverer 10g, Reports 10g,XML/BI Publisher, Workflow Builder 2.6.3.5, Forms 10g, Toad, SQL*PLUS, UNIX.

Confidential

Oracle Applications Consultant

Responsibilities:

• Developed control file to load sales orders created in legacy system into staging tables using SQL * loader then validated data and inserted into interface tables.
• Developed PL/SQL scripts to load order data from external system to OM interface tables and OE base tables.
• Developed PL/SQL Package to check data in the auto lockbox tables for compatibility with Account Receivables (AR) and transfer the data into Quick Cash tables for the application receipts to the corresponding open transaction & update customer's balances.
• Designed and developed to load PO requisitions from the legacy System in to purchasing interface tables.
• Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs
• Designed and developed Customer and Auto Invoice interfaces to import the invoice information into AR.
• Worked on data conversions from Legacy system to Oracle.
• Registered user defined tables into applications using Exec.ad dd.register table.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects).
• Worked on Oracle Reports 6i for generation of various custom reports in procurement modules and registered them in the applications.
• Experience in customization of XML Publisher reports for Oracle Purchasing.
• Modified the PL/SQL report by adding some columns to the report based on the client's requiement and developed many reports by using lexical parameters in before, after parameters and before report triggers..
• Designed and developed Purchase Order report, AR Invoice reports, Dunning Letters, AP Check and FSG reports using Oracle BI Publisher
• Developed the Request sets that are scheduled to submit concurrent programs in a desired sequence as per the functional document.
• Used SQL * Loader and UTL FILE packages for data interfaces
• Created Request Groups and Value sets for reports.
• Created several Profiles and FND MESSAGES in the process of development.
• Part of performance tuning team, tuned PL/SQL code and SQL queries using Execution plan and TOAD.

Environment: Oracle Applications 11.5.9 (AR, AP, OM, INV, BOM, WSH), Oracle 9i, UNIX, Developer 6i, Workflow Builder 2.6, Oracle Reports 6i, Discoverer 4i, XML Publisher.

Confidential

Oracle Developer

Responsibilities:

• Worked as part of the Reports Development team.
• Customized Cancelled Orders Report, Orders Summary Report by using Discoverer.
• Developed Cash requirements report in Account Payables using Report6i.
• Customized the standard AP Check Print Report in Account Payables using XML/BI Publisher.
• Involved in creation of PL/SQL stored procedures, Packages, Procedures, Functions, Cursors, Triggers.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Involved in creation of SQL scripts.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables.
• Responsible for creating the Database tables, indexes, constraints in Oracle 8i.
• Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL.
• Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Invoices are ported from the Excel sheets to the Oracle Database using SQL * LOADER.
• Involved in Unit Testing and Performance Testing for reports.
• Coordinated with Offshore team during testing phase.

Environment: Oracle Applications 11i, Accounts Payables, Oracle 8i, Reports 6i, Discoverer 4i, PL/SQL, SQL * Plus, SQL Loader.