SUMMARY:

• Around 8 years of experience in designing, developing, converting, implementing and upgrading Oracle Applications 11i and R12 Using ORACLE 10g/9i/8i, SQL, PL/SQL, Forms 9i/ 6i / 4.5, Reports 9i/6i/2.5, Discoverer 10g/4i/3i.
• Extensive experience in Designing, Implementing, Migrating, Customizing of Account Payables (AP), Account Receivables (AR), General Ledger (GL), Cash Management(CE), I - Payment, Fixed Assets(FA), Order Management/Order Entry (OM), Inventory (INV), Procurement (iProcurement, iSupplier Portal, Purchasing), Oracle Purchasing (PO), Grants Accounting, Bill of materials (BOM), Work In Process (WIP), Trading Community Architecture (TCA), Project Accounting (PA), Project Management, Project Costing, Project Billing, Oracle Incentive Compensation, AOL modules, OA Framework 5.6, System Administration modules of Oracle Applications.
• Conversant in Reports, Interfaces, Conversions and Extensions (RICE).
• Experience in Procure to Pay(P2P), Order to Cash (O2C), Quote to Cash.
• Have extensive experience in Customization of Oracle Application modules, which involved developing the XML/BI Reports Oracle 10g/9i/8i/7.x.
• Expertise in Customizing Oracle reports and developing custom reports by using Report 6i /9i/10g and Discoverer 4i / 10g
• Experienced in Customizing Oracle Forms with Forms personalization, Custom.pll on Forms 10g/9i/6i/4.5.
• Proficient in customizing Workflow in Oracle apps.
• Well versed with client server environment and tools like Developer/2000, SQL*Loader, SQL* Navigator and TOAD.
• Experience in enterprise level integration of legacy systems with Oracle System.
• Expert in preparing Technical specifications (MD070), Functional Specification (MD050), Conversion Mapping Documents (CV050), Future Business Mapping Document (BP-80) and Business Requirements Mapping Documents (BR-100) user manuals, test procedures document preparation.
• Excellent knowledge of Flex fields, Multi-Org and Multi-Currency.
• Experience with FSG reporting and development.
• Adept in PL/SQL Procedures, Functions and Packages and UNIX shell scripts.
• Interacted with users, fixed the bugs, developed test Plans and provided daily support.
• Experience in debugging, UAT testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Excellent analytical skills, strong verbal and written communication skills.
• Experienced in working in a team environment.
• Good understanding of accounting principles and financial processes

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications 11.0.3, 11i, R12

Oracle ERP Financials: Accounts Payables (AP), Account Receivables (AR)General Ledger (GL), Cash Management (CM), Fixed Assets

(FA), Project Accounting, TCA

Oracle ERP Manufacturing: Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Advanced Supply chain Planning (ASCP), Purchase Order (PO)Order Entry/Order Management (OM), Shipping, Advanced Pricing

Operating Systems: MS-DOS, UNIX, Linux, WINDOWS NT/XP/2000/98

Languages: PL/SQL, Java, C, C++, Java

RDBMS: Oracle 9i, 7.x/8.x, DB2

Development Tools: Developer 2000, BI/XML Reports Oracle 10g/9i/8i/7.x, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i

Discoverer 10g/4i Reports, Work Flow Builder 2.6.3

Database Tools: SQL*PLUS, SQL*Loader, TOAD, SQL*Navigator

Document M thodologies: MD.070, MD.050, CV.060

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Techno Functional Consultant

Responsibilities:

• Designed customizations, interface/conversion mapping, pre production testing, and related documentation.
• Developed and customized Financial Modules Interacted with end users to gather requirements and Draft specifications for development Phase.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• General Ledger (GL): Designed Set of Books, built chart of accounts, set up cross-validation rules and flex field segments. Defined journal sources, journal categories, Translation of balances from subsidiary units for reporting purposes and consolidation. Defined system controls and Set the profile options for GL, Creating of Sub ledgers and Globalization
• Did Accounts Payable set up and covered Vendor Maintenance, Invoice Processing, Payments, Payment Reconciliation and Period Close Process.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the Auto Invoice to import the customer invoices.
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Strong Oracle RICE development experience in all AP, AR, FA, GL, PO and OM Modules.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Wrote Functional Specification (MD050), Technical Specification (MD070), Conversion Mapping (CV040) documents for converting Vendors, Vendor Sites and Vendor Contacts.
• Designed, developed and documented an inbound interface for AP Invoices from windows based applications.
• Designed and developed Asset Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
• Developed PL/SQL Procedures for using multi Currency processing, revaluations and consolidations.
• Did Consolidation setups for Consolidation set, Consolidation, segment rules in General Ledger Module throughout global companies
• Responsible for providing production support for Account Receivables (AR) and Account payables (AP).
• Designed, documented and developed Bank Reconciliation interface to Oracle Cash management Interface.
• Responsible for running the Open Interface to import data from OM interface tables into the base tables.
• Worked in the Q2C process
• Designed and developed various interfaces and integrations such as Customer Master Data synchronization, Ariba (AP Erp system) with Oracle AP/PO, Sales-force integrations with Oracle Quotes and OM, Vertex integration (Tax engine) with Oracle ERP.
• Worked with users to provide the required functionality(to reduce configuration time) and efficient performance in producing quotes for complex products and services with the ability to integrate BOM, OM to maintain various components across the organization
• Analyzed an SR on interface trip stop program and modified and executed the script for different internal requisitions and sales orders (OM). Converted the same script into Concurrent request.
• Designed, developed an Inbound Interface between web based Order management system Odyssey and Order Management (OM) for importing Sales Orders.
• Creating staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader.
• Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
• Customized forms using CUSTOM.PLL file to meet the specific requirements.
• Utilized Forms Personalization utility to call a PLSQL procedure and updated the AR Descriptive flex fields with Depot Repair flex field data.
• Experience in System Administration activities like Managing Concurrent Programs and Responsibilities.
• Created a Report for End Users to get the vendor and its site information.
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports in Account Receivables (AR).
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register, Posted Payment Register, Unaccounted Transactions report and consolidation journal report in General Ledger (GL).
• Designed and developed complex Discoverer reports by communicating and interpreting end-user business requirements.
• Involved in creating business areas, user views, custom folders and joins for reporting using Oracle Discoverer 4i in Administrative edition as per the user requirements.
• Registered customized Oracle reports and BI/XML Publisher reports using System Administrator and Application Developer.
• Created custom templates with Data Definitions for BI/XML Publisher and Developed reports using reports 9i and registered as XML reports in applications.
• Uploaded and attached the templates to the custom reports in XML Publisher and processed the reports by customizing XML Gateway for the purpose of EDI.

Environment: UNIX, Oracle Applications R12/11i - AP, AR, Purchasing, GL, FA, Cash Management, OM, O2C, INV, TCA, Work Flow, Oracle Approvals Management (AME), OA Framework, Oracle 10g, Forms 9i, Reports 9i, Discoverer 4.1/9.0.2, XML publisher, SQL*Loader, PL/SQL developer, UNIX, Java, JDK, J2EE, TOAD.

Confidential, Arlington, VA

Techno Functional Consultant

Responsibilities:

• Designed and developed an interface custom package to create and Update vendor/vendor sites implementation according to BR which is not provided by standard API’s.
• Communication from legacy to Oracle applications were established through IBM MQ series using data contracts which were signed off for both parties integrating the applications.
• Designed and developed the Reconciliation process for GL module.
• Provided hands on to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.
• Written an API for Converting the Invoice Payments (AP) and was able to convert all the Historical Invoice Payment History into Production.
• Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices from a CSV file.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
• Strong Oracle RICE development experience in all AP, AR, GL, PO, INV and OM Modules.
• Did Consolidations setups for mapping set, mapping, segment rules in General Ledger throughout global companies.
• Setting up system for foreign currency translation and re-evaluation performing financial consolidation of multiple currency set of books.
• Created Asset categories and assigned the assets to that particular category in Fixed Assets.
• Invoked standard API’s within custom packages for creating and updating Customer, Sites and Contacts.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
• Analyzed, developed, configured and tested the AT&T customer model into the Oracle 11i TCA (Trading Community Architecture) framework.
• Responsible for creating an interface for Purchase Order upload, which creates PO from a CSV file.
• Written PL/SQL packages with cursors, functions and procedures for inserting the data into vendors, invoices and purchase orders interface tables from various staging tables while validating the data.
• Prepared Technical Specification (MD70) documents.
• Responsible for running Receivables open interface, imported data into RA interface tables and used the standard API Auto Invoice to import the customer invoices.
• Analyzed requirements of the client for various legacy applications that needed migration and integration with Oracle Applications.
• Prepared high-level and low-level designs for bridging and migrating data to AP, AR and PA modules.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API(Interfaces) to import the data from legacy system into OM using Order Import Concurrent Program.
• Created shell scripts to load data into staging tables of expenditures, tasks, events and projects of project accounting using SQL*Loader direct path.
• Worked on Inbound and Outbound programs for passing the Picked lines to the 3rd party system and shipping the records sent from 3rd party system back to Oracle.
• Created test scripts for every level of testing from unit testing stage to integration testing.
• Involved in Unit testing and wrote test cases for QA, also involved in UAT (User Acceptance Test).
• Involved in bug fixing reported from QA and End users.
• Involved in Post production Support, work involved supporting Apps, support in .

Environment: Oracle Applications 11i/R12 - AP, AR, GL, FA,O2C, OM, PO, INV, Service Contracts, Work Flow, Oracle 10g, Forms 9i/6i, Reports 9i/6i, SQL*Loader, XML Publisher, BPEL, PL/SQL developer, TOAD, Java.

Confidential, Aliso Viejo, California

Technical Consultant

Responsibilities:

• Implemented Oracle Financials 11i Account Payables and Project accounting for a large distribution network of a major apparel company.
• Designed customizations, interface/conversion mapping, pre production testing, and related documentation.
• Worked on Oracle API bug in Supplier Sites/Vendor Sites Open Interface Import, causing all the legacy data to be rejected because of duplicate Vendor Site Code.
• Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
• Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
• Responsible for converting all the Historical Invoices using Payables Open Interface Import into Production.
• Written an API for Converting the Invoice Payments and was able to convert all the Historical Invoice Payment History into Production.
• Designed and developed Technical Specifications for the Inbound Interfaces as per the Functional Specifications in OM.
• Used standard Order Import to load the Open Orders from the interface tables to the standard OM tables.
• Wrote PL/SQL packages/procedures to retrieve order booking data, based on the search criteria entered in the OA Framework based search screen.
• Handled the implementation stages for EDI, Financials, Purchasing and setting up the interface for Order Management system.
• Worked with interfaces from AP to PA (Project Accounting).
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.

Environment: UNIX, Oracle Applications 11.5.9 (11i) - PA, AP, AR, GL, OM, PO, TCA, OA Framework, Work Flow, Oracle 9i, Forms 6i, Reports 6i, XML publisher, SQL*Loader, PL/SQL developer, TOAD, Java.

Confidential

Technical Consultant

Responsibilities:

• Analysis of system and process improvements allowing users to perform more transactions, in less time, with better quality. Areas researched include: Oracle Customers Online (OCO/IMC) module, TCA framework, Service Contracts templates.
• Created an interface to import Order Management data from the legacy system to Oracle Order Management. Used SQL* Plus and PL/SQL to load and validate the data.
• Involved in Requirements Analysis, Design, Data Mapping and Client Interaction.
• Mapping, Design and Development of Invoice Interface from Legacy Entities to Oracle Payables.
• Designed and developed Auto Lockbox to load receipts and invoices into Oracle Receivables.
• Designed and developed PL/SQL packages to validate and import invoices into Oracle Receivables.
• Worked on Purchase Order interface and receivables interface by loading data into staging tables from the legacy system.
• Wrote PL/SQL code to validate and dump the data into interface tables.
• Then running import programs to load data from interface tables into base tables.
• Developed Discoverer reports for Oracle project accounting and Payables.
• Customized the Journal Entries Report in AR which is used to review the details that make up the general ledger journal entries.
• Customization of Oracle Purchase requisition account generator workflow.
• Customized PO approval workflows and configured approvals using Oracle Approvals Management.

Environment: Oracle Applications 11.5.8 (OM, PO, AP, AR, TCA and PA), Work Flow, AME, Oracle 8i, Reports 6i, XML Publisher, Forms 6i, PL/SQL, SQL*Loader, Toad, UNIX

Confidential

Oracle Developer/Analyst

Responsibilities:

• Development of Forms based on Procedures/Views etc.
• Usage of Dynamic Execute Immediate statements to fetch data as needed.
• Performance Tuning of the entire Application to the best throughput.
• Loading Data into Multiple Database environments using PL/SQL Packages.
• Wrote Stored Procedures/Functions and Packages to meet the Rate Structure.
• Developed a lot of Tree Screens like Object Navigator to display hierarchical data representation dynamically for easy use by the Underwriters.
• Developed a Common Screen, which includes 100 sub-screens to minimize the user navigation process.
• Developed screens for enrolling the Groups and Dropping existing Groups.
• Developed Complex screens for Renewal of Groups from year to year and their claims history.
• Wrote number of Packages and Procedures to support the Rate Screens such as Rate Packages, Prospective/Renewal Packages.
• Wrote Database Triggers as needed to meet business functionalities.
• Extensive use of Oracle Advanced Queues to communicate data between Multiple Applications.
• Used Database Level Triggers such as LOGON/LOGOFF/DATABASE STARTUP, and DDL Triggers to track Schema activities.
• Developed various Reports to meet the customer needs.
• Used SQL * Loader to populate Oracle Tables from data flat files.
• Web based Development using 9iAS, Forms 4.5 and Reports 2.5.

Environment: PL/SQL, Oracle Forms 4.5, Reports 2.5, UNIX, SQL Navigator, SQL* Loader