PROFESSIONAL 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 with major focus in the domain of financial modules including Distribution, Manufacturing and Supply Chain Management within 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 with the integration between various Oracle Applications modules and with 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 the 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 the Fit Gap documents. Analyzing the Gaps and fixing the Gaps which also need coordination with 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.
• Have good working knowledge of various performance tuning tools like TKPROF, SQL Trace and Explain Plans.
• Excel in team collaboration, quick adaptation and problem solving with 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.

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, NY

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 the 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 the reports directly from the view integrated in oracle applications.
• Effectively used Discoverer reports to enhance and enrich the decision making of the 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 with 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 the process of development.
• Worked on the Email notification program to notify the 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 the 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 with Incident Monitor for file migration. Used FND LOAD to migrate Concurrent programs, Request sets, form menus and personalization, by downloading the 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 the appropriate interface tables and then calling the concurrent manager which processes the 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 the 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 the project with major activities including Viewing Concurrent Programs, Managing Users, Responsibilities, and Profile Settings, Running weekly scripts, and managing with the 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, Addison, IL

Oracle Application Developer

Responsibilities

• Developed SQL scripts to create temporary tables and SQL*Loader control files (.ctl) to load the item legacy data into the temporary tables.
• Involved in Requirement Gathering and Business analysis document Preparation, with extensive involvement in the 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 with business users in the 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 the process developed validation procedures, error handling and debug logic as per the 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 the Base Interim tables and finally to the 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 the 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 the 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 the existing custom interfaces in PL/SQL to reduce the 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 with 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 the process.
• Interacted with users to resolve any issues during the 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 the 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, NJ

Oracle EBS Consultant

Responsibilities

• Oracle EBS Consultant for upgrade and support project.
• Developed Customer conversion packages in Receivables worked with various HZ tables, Interfaced data from the Flat Files into staging tables of Oracle Receivables using SQL*Loader, validated and imported the 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 the customer will have the ability to see the changes made to the 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 the Layouts to be able to print on their Legal docs and also attached the Standard Terms and Conditions documents to the report wherever it is required.
• Developed database triggers on insert/update MTL ITEM CATEGORIES table to track the changes in the table.
• Member in the team of Oracle Application upgrade from 11.5.10 to 12.1.3.
• Developed control files to transfer data to staging table using SQL*Loader and validate the date for the Standard Items in INVENTORY and load the 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 the client application’s user creation and maintenance according to the business requirement.
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location. Automated the 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 the PO is created for a back-to-back process.
• Worked with 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 the 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, Baco Raton,FL

Oracle Application Developer

Responsibilities

• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the 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 the 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 the rule type id and rule value. Based upon the rule type id and rule value to find the right price list header in the OE HEADERS ALL table and to update the price list lines with the default shipping organization under the 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 the data from staging tables into Vendor tables, which is a three step process in which the 1st phase is to load all the vendors and the 2nd phase is to load all the vendor Sites and 3rd phase is loading all the vendor contacts with the help 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 the standard workflow to send notification to the customer before invoicing.
• Involved during the Development, Production and post implementation support phases of the 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, Herndon,VA

Oracle Apps Technical Consultant

Responsibilities:

• Worked in a team to implement the GL and AP modules for US and international operations. This included gathering requirements and preparing documentation
• Worked with the functional team to design and implement new business processes
• Extensively used the SQL* Loader and PL/SQL for data conversion and interfaces in the mentioned modules
• Created PL/SQL stored procedures and packages for data validation of the Journal Entries and then ran the Standard Journal Import Program to integrate with 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 the 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 the Master/Detail budget report in GL and the Discounts Available Report in AP as required by the client utilizing the 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, Wilmington, DE

Jr. Oracle Technical Developer

Responsibilities

• Involved in designing and developing Oracle forms and Reports.
• Involved in writing all the 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 the applications to enhance the speed by utilizing Indexing, SQL HINTS and Materialized Views.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
• Interacted with the 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.