SUMMARY

• Experience of 7 years in design, development and maintenance of Oracle E - Business application as a Technical consultant.
• Good Knowledge on Oracle Applications 11i/R12 Technical and Functional in Finance modules.
• Managed successful ERP end-to-end Implementation, Upgradation, Development and production support.
• Experience includes developing Interface/Conversion Programs for migrating data from non-oracle and oracle systems to Oracle 11i/R12 EBS Applications, development and customization of Reports, Procedures, Functions and Packages using PL/SQL.
• Familiar with Oracle Financial modules and their interplay in overall accounting structure of an organization.
• Enthusiastic to learn new skills with a shorter learning curve.
• Excellent Communication, Good Work Ethics, good Team Player and work independently
• Good Leadership skills with managing different offshore teams.
• Worked on strong distributed code methods inOracle cursor management, exception handling problem, databases collections and various logical tools etc
• Thorough functional knowledge on Oracle Cash Management, Oracle Treasury, General Ledger, Oracle Payroll, Oracle Purchasing, Accounts Payable and Accounts Receivables.
• Expertise in client server, Internet architecture applications development using Oracle10g/9i/8i, PL/SQL, SQL*Plus, SQL *Loader, and PL/SQL's UTL file, Stored Procedures, Triggers, Functions, Packages and Developer 2000 (Forms 6i/10g, Reports 6i/10g).
• Experience in system analysis, design, development, documentation, testing, technical support and maintenance of information systems.
• Designed MD50 for all the enhancements and new features implemented.
• Experienced in Full software development life cycle implementation (SDLC).
• Developed database scheduler scripts and applications usingUnix shell scripts, PL/SQL, SQL *Plus script
• Expert on extracting data from Legacy Systems to Oracle Applications modules.
• Expert on XML Publisher, BI Publisher and Oracle Discoverer Reports.
• Experience in developing R.I.C.E components across different modules in oracle EBS R12.
• Expert on Forms Personalization and Oracle Workflow.

TECHNICAL SKILLS

ERP: Oracle Applications EBSR12 (12.0.6, 12.1.1, 12.1.212.1.3 , 12.2)

Modules: Accounts Payables (AP), General Ledger (GL)Accounts Receivable (AR), Oracle Purchasing (PO)Oracle Inventory (INV), Oracle Cash Management (CE) AND Oracle Treasury (XTR)

Others: Oracle Application Object Library (AOL)

Databases: Oracle 10g, 9i, 8.x/7.x/6.x

Development Tools: Oracle Developer- Forms10g/6.x/5.0, Reports10g/6.x BI Publisher ( XML Publisher) 10g, Oracle Work Flow Builder.

Operating Systems: Windows 2000, Windows NT, Windows 98/95, Unix

Version Control Tool: CVS, HP Quality Center

Tools: TOAD, SQL-Developer, and SQL Loader.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Oracle EBS Apps Technical Consultant

Responsibilities:

• Managed various Projects related to Oracle E-Business (EBS) Suite- Implementations, Conversions and Upgrade.
• Implementation and up gradation of Oracle financials Suite (AP, GL, AR).
• Written a Segment extraction program to extract the Chart of Accounts segment values and related information. This program Written in PL/SQL and made it as concurrent program.
• Wrote PL/SQL subprogramsPackages, Procedure, functions and DB triggers.
• Involved in Conversion of the existing sales transactions in the AR module of legacy system to AR module in the instance.
• Used SQL developer tool for faster and efficient application design and development.
• Trained new employees in using the existing system.
• Worked on creating XML Publisher reports.
• Extensively used backend procedures, SQL queries, standard modules and database triggers to view and pay insurance premium and fee invoices.
• Developed SQL*Loader scripts to load data from legacy system into Payables, Receivables and GL interface tables after validating data through a custom built Concurrent Programs.
• Developed supplier invoice interface program Conversion using the Inventory Open Interface program.
• Created and customized Reports in AP, AR, FA and Credit & Collections & GL using Reports 10g.
• Created UNIX shell scripts to automate the process of loading the external data.
• Used FND LOAD utility to migrate responsibility, request sets, concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.

Environment: Oracle Applications R12 (AP, AR, PO, INV, OM, SCM), Oracle 11g, SQL, PL/SQL, Reports 10g/6i, SQL * Loader, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting.

Confidential, Milpitas, CA

Oracle EBS Apps Technical Consultant

Responsibilities:

• Involved with the study of existing system, preparing the Technical design document to extract data from legacy system into Oracle Applications e-Business Suite open interface tables.
• Used CONCSUB to call the Concurrent Process and execute the job in Unix Shell Script
• Developed new custom processes, functions, defined new events, subscriptions in OEOH and OEOL Workflows to update the shipping method and carrier information after order has been BOOKED. Also modified the transaction type set ups to route the workflow through custom process.
• Took part in development, Testing, Implementation and Documentation of PO, AP, AR, BOM, OM Oracle EBS Modules.
• Worked extensively on TCA Customer Conversion in loading the new Customer details from Legacy System to Oracle AR Tables.
• Converted GL Balances, Purchase orders, Sales Orders, Pricing Discounts from Legacy System to Oracle.
• Worked inOracle Cash Management modules to load, import and auto-reconcile bank statement transaction against payments in Accounts Payable (AP)/AR.
• Developed the PL/SQL API to populate the Defaulting Rules in Order Management OM.
• Written shell scripts and used them as Concurrent programs for data extraction from Inventory.
• Created different Template for Payment Process Request (PPR).
• Designed and developed the following custom reports in OM and INV modules as per the client requirement
• Quote report
• Part Ticket Report
• Purchase Order Report
• AR Invoice Report
• Worked on Discoverer Administration and Desktop Editions. In Administration Edition, Created Business areas, Custom folders, Item classes, user views and joins for reporting. In desktop edition created workbooks and worksheets.
• Designed a technical document MD-70 based on functional document MD-50.

Environment: Oracle Applications R12 (GL, AR, AP, OM, INV, PO, DR, FS SCM), Oracle 11g, TOAD, UNIX, PL/SQL, Reports 10g/6i,Workflow Builder, XML/BI Publisher.

Confidential, Maumee, OH

Oracle EBS Apps Technical Consultant

Responsibilities:

• Confidential has launched an initiative to upgrade its Oracle E-Business Suite environment from 11.5.10.2 to Release 12. This effort is divided into two phases beginning with the first phase to perform analysis of Confidential business processes and identify gaps with respect to Oracle EBS. Second phase is upgrade 11.5.10.2 to R12 1.3 for Financials, Projects and iExpenses.
• R12 upgradation/implementation responsible for the preparing required docs and reviewing the code.
• Involved in Finance Modules (GL, AP, AR), SCM Modules (OM, PO, BOM, INV) and HRMS to define Organization/job/people.
• Upgrade of Oracle EBS Application from 11i to R12 project for all objects like Forms & Reports (6i to 10g) conversion.
• Responsible for production support delivery of P1, P2, P3 and P4 Incidents and Requests as per the SLA.
• Working with the DBA team for the instance availability/implementations and escalations.
• Developed/Customized XML and Oracle Reports and as per the client requirement.
• Developed/Customized Interfaces as per the client requirement.

Environment: Oracle Applications 11i/R12 (GL, AP, AR, PO, BOM, INV, OM, SCM, HRMS), Oracle 11g, SQL, PL/SQL, Reports 10g/6i,SQL * Loader, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting.

Confidential

Oracle EBS Apps Technical Consultant

Responsibilities:

• Developed GL interface to Import the Journals into General Ledger application.
• Converted SQL Queries into PL/SQL Stored procedure for Outbound.
• Preparing MD70, TE30 and Client Quality Documents.
• Involved in Conference calls for faster resolution on some problems.
• Preparing migration document and test script for the given object.
• Converted MS Access Queries into PL/SQL Stored procedures and sent the data files to specified server as per business requirement.
• Developed & Customization of Interfaces (Inbound, Outbound).
• Developed Customer Shipped Report in Sql*Plus.
• Developed Customer Outbound Interface.
• Preparing MD70, TE30 and Client Quality Documents.

Environment: Oracle Applications 11i: Finance and Distribution Modules (GL, AP and AR), Oracle 9i, Reports 6i, Toad and WS FTP32

Confidential

Software Developer

Responsibilities:

• Developed & Customization of Reports (Oracle Reports, SQL*Plus).
• Written Procedures, Functions, Packages, Triggers, Cursors and Involving Modules GL, AP and AR.
• Revisiting of existing objects code to support for multi organizations.

Environment: Oracle Applications Release 12.1.3 (AP, AR, PO, INV, OM, SCM), Oracle 11g, SQL, PL/SQL, Reports 10g/6i,SQL * Loader, Workflow Builder, XML/BI Publisher, UNIX Shell Scripting.

Confidential

Oracle Developer

Responsibilities:

• Worked with the team to design, develop, test and implement system.
• Creation of database objects like tables, PL/SQL procedures using Toad.
• Supported separate logical and physical models using Erwin.
• Used Erwin to easily define and maintain naming standards, attributes and data types.
• Proficient in TuningSQL Queries and Procedures for enhancing the load Performance in various Schemas across databases.
• Designed and developed Custom Invoice Reports in Oracle Accounts Receivables using XML/BI publisher.
• Worked on Error Checking procedure which identifies various error checking conditions given by the Business and applied on the data to clean up the data, for the data to be processed in the mart.
• Written Stored Procedures using PL/SQL.
• Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions / enhancement on oracle Application.
• Defined and Used Cursors wherever applicable to process the data from the query.
• Used SQL Loader (Oracle tool for loading data from a file into Oracle database) for the ETL (Extract, transformation and load) process for the data warehouse.
• Documented the design and Testing of developed modules.
• Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation and Maintenance.

Environment: Oracle Applications 11i, OM, AP, AR, GL, Developer 6i, Oracle 9i, SQL, PL/SQL, TOAD 7.0