SUMMARY

• Over 8+ years of experience as oracle applications technical consultant in system study, development, maintenance, Upgrades, Production and support of E - Business Suite applications using Oracle Applications R11i/R12 and Oracle databases (10g, 11g).
• Proficient in Designing, Implementing, Migrating, Customizing in all phases of Oracle Applications wif major focus in teh domain of financial modules including Distribution, Manufacturing and Supply Chain Management wifin Oracle Applications EBS (General Ledger(GL), Account Payables(AP), Account Receivables(AR), Oracle Purchasing (PO), Order Management (OM), Inventory(INV), Shipping (WSH, Bill of materials(BOM), Work in process(WIP)).
• Strong knowledge and experience in Multi-Org, Trading community Architecture (TCA) and System Administrator activities.
• Extensively worked in developing Functional Design Documents (MD50), Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Expertise in developing, Personalizing, and customizing Forms using Oracle Forms Builder (10g/9i/6i) in Oracle Applications.
• Extensive experience in customizing and developing Reports in Oracle applications using Oracle Report Builder (10g/9i/6i), Discoverer 10g, XML publisher/BI Publisher.
• Strong knowledge of business flows like Order-to-Cash (O2C) and Procure-to-Pay (P2P) life cycles along wif teh integration between various Oracle Applications modules and wif very good understanding of Software Development Life Cycle (SDLC).
• Technically proficient in RICEW (Reports, Interfaces, Conversions, Extensions, workflow) components including Implementation, Interfacing, Data Migration and Data Conversion.
• Experienced in customization by extension and modification of teh standard application suite using Application Object Library (AOL).
• Fair knowledge on Oracle Applications Framework (OAF).
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers, Bulk Binds, SQL * Loader scripts and shell scripting.
• Extensively used Oracle tools like SQL*Plus, TOAD, SQL DEVELOPER and developed database objects like tables, views, synonyms, sequences and DDL scripts.
• Experience in UNIX Shell Scripting, XML, HTML, VBScript and Java Script.
• Fair knowledge on customizing and personalizing approvals using Oracle Approval Management (AME).
• Experienced in Oracle Workflow Builder and Administration.
• Adept in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.,
• Experience in Oracle interfacing programming, Concurrent Manager, Flexi fields, and Value sets.
• Extensive knowledge of DBMS, RDBMS and Distributed Databases.
• Perform Production support activities for Oracle R12 Application.
• Worked on writing technical design documents for conversions, extensions, interfaces, reports and Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Responsible for Fit-Gap analysis and documenting teh Fit Gap documents. Analyzing teh Gaps and fixing teh Gaps which also need coordination wif Oracle Support.
• In depth knowledge in creating complex Procedures/Functions and packages to handle validations for various data loads and Error-Handling packages to handle user-defined errors.
• Has good working knowledge of various performance tuning tools like TKPROF, SQL Trace and Explain Plans.
• Excel in team collaboration, quick adaptation and problem solving wif good communication skills.

TECHNICAL SKILLS

ERP Skills: Oracle Applications R12 / 11i Application Object Library (AOL), Inventory (INV), Order Management (OM), Bill Of Materials (BOM), Work In Process (WIP), Accounts Receivables (AR), Purchasing (PO), Accounts Payables (AP), General Ledger (GL), Subledger Accounting (SLA)Fixed Assets (FA), Cash Management (CM), TCA, Project Costing. Financials, Order-to-Cash(O2C), Procure-to-Pay(P2P), Supply Chain

Languages: SQL, PL-SQL, UNIX Scripting, Java

Web Technologies: HTML, DHTML, XML, JSP, Servlets, Java Script

Data Loading Tools: Data Loader, SQL*Loader, TOAD, SQL Developer

Misc Tools: Kintana, PVCS, VSS, Quality Center

GUI: Oracle Forms, Oracle Reports, TOAD, Oracle Workflow Builder, Discoverer, JDeveloper, UIX, XML Publisher, PL/SQL Developer, SQL*Plus.

RDBMS / DBMS: SQL, PL/SQL, Oracle 10g/11g, SQL Server 2000, MS Access

Operating Systems: Unix, Windows Vista/XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Texas

Oracle Application Developer

Responsibilities:

• Created technical design, coding, prepared unit test plan, configuration guide and unit testing for RICE (Reports, Interfaces, Conversions and Extensions) components.
• Customized various forms in Oracle Payables (AP), Oracle Inventory (INV), Oracle Receivables (AR).
• Involved in development and maintenance of different forms/ forms personalization of different modules of Oracle Apps.
• Built custom forms in which include in 6i &10g: --Changing various field names, attaching LOV’s, adding fields to teh forms.
• Designed and developed various reports in OM, INV, BOM. -Monthly Sales Report - Pre-Pick List Report - Orders on Hold Report - Sales Order Report
• Developed various Discoverer reports in Discover Plus and granted access to users, so that users can access teh reports directly from teh view integrated in oracle applications.
• Effectively used Discoverer reports to enhance and enrich teh decision making of teh business managers thru dynamic and granular reporting at their fingertips. Worked on Discoverer reports in AP,GL,AR,OM,INV,PO Modules.
• Responsible in creating new suppliers, supplier groups, lookup codes, Pay groups, and Payment terms as per payable options along wif Bank Accounts in Accounts Payables (AP).
• Developing various Interfaces, both inbound and outbound and implemented various Data.
• Performed code migration across different instances like Production, Development and Testing.
• Defined flex fields using Application Object Library (AOL). Registered Concurrent Programs and standard request submission in AOL during teh process of development.
• Worked on teh Email notification program to notify teh users on recent customer creation failure in Accounts Receivables using Workflow Builder.
• Responsible for implementation of Order Management (OM), Account Payables (AP), Account receivables (AR), General Ledger (GL).
• Analysis of Functional (MD050) & Technical (MD070) Specifications and appropriate modification on modification of concerned object.
• Involved in Analysis of Requirements document.
• Responsible for developing Custom Packages, Procedures and Functions using PL/SQL.
• Configured financial, purchasing and receiving options in purchasing (PO) module.
• Involved in teh complete Order to Cash (O2C) cycle.
• Developed Interfaces for data migration from Legacy System to Open system in GL, using SQL*loader, UTL File.
• Worked on Version Control software to check-in codes and integrated wif Incident Monitor for file migration. Used FND LOAD to migrate Concurrent programs, Request sets, form menus and personalization, by downloading teh LDT files.
• Viewing, Sorting, Updating, and Managing of Query Tickets on Incident Monitor.
• Created new reports in XML/Bi Publisher.
• Developed custom forms to perform tasks such as creating WIP jobs, updating WIP jobs, performing WIP moves and making material transactions via writing to teh appropriate interface tables and tan calling teh concurrent manager which processes teh interface tables.
• Created UNIX shell scripts for automatic installation of objects in various Apps environments.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Involved in various client weekly status meetings, providing updates on teh existing development work and future scheduled work.
• Created Test Scenarios, Test Cases, Use Cases and suggested changes as required ensuring proper functionality testing.
• Also worked as an Oracle System Administrator for teh project wif major activities including Viewing Concurrent Programs, Managing Users, Responsibilities, and Profile Settings, Running weekly scripts, and managing wif teh DBAs.

Environment: Oracle Applications 11i/R12 (GL, AR, AP, OM, INV, BOM, WIP and PO), Oracle 10g, Forms 6i/10g, Reports 10g, Discoverer 10g and TOAD .

Confidential, IL

Oracle Application Developer

Responsibilities:

• Developed SQL scripts to create temporary tables and SQL*Loader control files (.ctl) to load teh item legacy data into teh temporary tables.
• Involved in Requirement Gathering and Business analysis document Preparation, wif extensive involvement in teh technical design of R12 implementation and conversions in modules AP, AR, and GL.
• Designed and Developed PL/SQL packages for customer conversion using standard API calls.
• Designed and Developed open Invoice Conversion using Standard oracle interface process, from client’s legacy system into Oracle Applications
• Involved wif business users in teh process of recognizing revenue by Revenue Accounting in Account Receivables (AR).
• Developed packages for conversion of various TCA objects like, parties, party sites, party site uses, customer accounts, customer account sites, customer account site uses, party and customer account profiles, profile amounts, etc., using oracle standard API calls. During teh process developed validation procedures, error handling and debug logic as per teh client’s complex design specifications.
• Designed and developed various XML Publisher reports like ‘Customer Statement of Account’, ‘Core Debit memo’and‘AR Invoice Report’.
• Worked on AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR PAYMENTS INTERFACE ALL), from interface table to teh Base Interim tables and finally to teh base table.
• Developed a program to load external data from legacy system into PO HEADERS INTERFACE and PO LINES INTERFACE.
• Configured Key Flex Field (KFF), Descriptive Flex Field (DFF), Bank accounts and different operating units across instances.
• Involved in teh Procure to pay cycle (P2P).
• Defined Payment terms, Purchasing options, request sets and bank accounts.
• Created PL/SQL, SQL, SQL*Plus, and SQL Loader scripts to validate and call stored procedures to validate and populate database objects before generating Oracle Error and status reports
• Generated UNIX shell scripts for calling stored procedures and for custom mail generation during teh automation of interface processes and registered them in oracle applications.
• Worked extensively on API’s of HZ PARTY V2PUB for TCA, AR INVOICE API PUB for AR.
• Responsible for rewriting some of teh existing custom interfaces in PL/SQL to reduce teh turnaround time of execution and completion of concurrent processes.
• Provided daily support for GL, AP, AR, OM, PO, IExpenses.
• Worked on iExpenses workflow issue.
• Developed deployment documents for moving various objects between oracle test instances and finally to production instance.
• Worked in collaboration wif oracle support, opening new service requests for fixing various issue encountered during R12 implementation. Attended Web Conferences (OWC sessions) and prepared many analysis documents in teh process.
• Interacted wif users to resolve any issues during teh production, development and enhancement phases.
• Involved in design of AIM (Application implementation Methodology) documents for all conversion and reports (MD -50, MD- 70).
• Extensive experience in Database query tuning, performance tuning ( Explain plan and TKRPOF Utility)
• Raising Oracle TAR's (P1, P2, P3) and worked for solving teh problems.

Environment: Oracle Applications R12 (12.1.3), Oracle 11g, GL, AP, Purchasing, TCA, AR, iRecievables, FA, Workflow Administrator, Forms10g and Reports10g, XML Publisher, UNIX, TOAD/SQL*Developer.

Confidential, CT

Oracle EBS Consultant

Responsibilities:

• Oracle EBS Consultant for upgrade and support project.
• Developed Customer conversion packages in Receivables worked wif various HZ tables, Interfaced data from teh Flat Files into staging tables of Oracle Receivables using SQL*Loader, validated and imported teh data into Customer base tables using Oracle TCA APIs. Converted, Customer accounts, Sites, Profiles, Profile amounts, etc.,
• Developed a custom form called “Order Change Tracking Form” using which teh customer will has teh ability to see teh changes made to teh ordered quantity, ship to location, price, request date etc.
• Designed and Developed new Reports in OM, Shipping, AP, PO and registered them in Oracle applications. Designed teh Layouts to be able to print on their Legal docs and also attached teh Standard Terms and Conditions documents to teh report wherever it is required.
• Developed database triggers on insert/update MTL ITEM CATEGORIES table to track teh changes in teh table.
• Member in teh team of Oracle Application upgrade from 11. .1.3.
• Developed control files to transfer data to staging table using SQL*Loader and validate teh date for teh Standard Items in INVENTORY and load teh data using item import interface to MTL SYSTEM ITEMS B table.
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.
• Wrote scripts to import customer information from legacy system into Receivables using SQL*Loader and PL/SQL
• Designed and developed custom USER APPROVAL WORKFLOW to meet teh client application’s user creation and maintenance according to teh business requirement.
• Developed UNIX Shell scripts to FTP teh Flat file from External Server to Oracle UNIX Server location. Automated teh process of encrypting and archiving.
• Involved in Customization of statements, Remittance, PO print, AP self-Billing Invoice, Supplier Open Balance, Supplier Return Document and AR Invoices using XML Publisher.
• Involved in Documentation & developed Functional and Technical documents (MD-50, MD-70, MD-120) using AIM methodology.
• Developed custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once teh PO is created for a back-to-back process.
• Worked wif administration and user edition of Oracle Discoverer.
• Supported GL, OM, INV & AR modules.
• Performed Unit Testing of various objects and performed defect analysis and FIX during teh pre-production stage.

Environment: Oracle Applications R12, 11i (11.5.10.2), Oracle 10g, TCA, SCM( GL,OM,INV), AP, Purchasing, AR, forms6i/10g, Reports 6i/10g, XML Publisher, Forms6i and Reports6i, Discoverer 10g, UNIX, PLSQL Developer.

Confidential, CA

Oracle Application Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions for validating teh journals (for accrual and payment information) in teh staging table and importing them into Oracle Application using teh GL Open Interface and populated teh base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• Involved in RICE Components customization - Reports (like WIP Location Report), and Forms.
• Imported data from legacy system to Account Payables base table MTL using teh standard item import program through a custom package that validates individual records.
• Created Direct Margin Report, Fleet Expense Report, GL Inventory Reconciliation report, GL Variance by account, Trial Balance by account, Trial Balance by Departments reports, Detailed Trial balance Report, Trial balance-by account Report using Oracle Discoverer.
• Customized existing forms to get teh rule type id and rule value. Based upon teh rule type id and rule value to find teh right price list header in teh OE HEADERS ALL table and to update teh price list lines wif teh default shipping organization under teh OE LINES ALL table.
• Transferred Custom Concurrent programs, executable, request groups, profile options using Oracle's FNDLOAD utility.
• Developed a custom program in order to validate and load teh data from staging tables into Vendor tables, which is a three step process in which teh 1st phase is to load all teh vendors and teh 2nd phase is to load all teh vendor Sites and 3rd phase is loading all teh vendor contacts wif teh halp of Supplier, Supplier Sites & Supplier Contact Conversions in AP.
• Design and development of Custom AR Billing status report (AR module).
• Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers to implement complex business logic.
• Customized teh standard workflow to send notification to teh customer before invoicing.
• Involved during teh Development, Production and post implementation support phases of teh project.
• Involved in performance tuning of custom PL/SQL programs and reports.

Environment: Oracle Applications R12 (11i) GL, AP, AR, Purchasing, WIP, INV, Workflow Administrator, Forms6i/10g and Reports10g, Discoverer 10g, UNIX, TOAD/SQL*Developer.

Confidential, Howell, IL

Oracle Apps Technical Consultant

Responsibilities:

• Worked in a team to implement teh GL and AP modules for US and international operations. dis included gathering requirements and preparing documentation
• Worked wif teh functional team to design and implement new business processes
• Extensively used teh SQL* Loader and PL/SQL for data conversion and interfaces in teh mentioned modules
• Created PL/SQL stored procedures and packages for data validation of teh Journal Entries and tan ran teh Standard Journal Import Program to integrate wif Oracle Applications
• Customized Workflow Background Process for shipping transaction in Oracle Inventory
• Was responsible for defining system security parameters including: responsibilities, request sets, and system access.
• Used Auto Invoice Interface to import Regular, Debit memo, Credit memo invoices from legacy system to Oracle Receivables using SQL*Plus and Auto Invoice import program
• Involved in importing teh financial data from legacy systems into Oracle General Ledger
• Worked on defining transaction types, customer profile class, tax structures and tax exemptions in Accounts Receivables
• Customized teh Master/Detail budget report in GL and teh Discounts Available Report in AP as required by teh client utilizing teh Oracle Discoverer
• Customized Sales Order form and was also involved in developing a new form to display Delivery Information in Oracle Order Management
• Provided support on day to day production issues

Environment: Oracle Applications 11.5.6(Inventory, GL, AP, AR), SQL*Loader, PL/SQL, UNIX, Toad, Discoverer4i

Confidential

Jr. Oracle Technical Developer

Responsibilities:

• Involved in designing and developing Oracle forms and Reports.
• Involved in writing all teh complex DDL, DML Statements.
• Designing and building reports using Oracle Report Designer.
• Created several SQL queries, procedures, functions, packages and several database objects.
• Preparation of class structure and sequence diagrams using Rational Rose
• Using views for designing and building reports.
• Used cursors and collections for accessing complex data resulted from joining a large number of tables
• Extracted data into comma or pipe delimited files using UTL FILE package/utility.
• Involved in testing backend SQL queries for query optimization.
• Extensively used SQL Query, joining tables, SQL function in Queries.
• Developed several packages that are used in oracle forms and reports.
• Tuned teh applications to enhance teh speed by utilizing Indexing, SQL HINTS and Materialized Views.
• Developed complex SQL queries to perform teh back end testing of teh Oracle database using SQL and UNIX shell commands.
• Interacted wif teh user group on a regular basis to discuss requirements and updates.
• Preparing documentation for all reports.

Environment: Oracle Database 9i, Discoverer, Developer Suite Forms6i/Reports6i, UNIX, SQL*Developer.