Oracle Sql

Mohan Yalamanchili

901-***-**** *******@*****.***

SUMMARY

Around 7 years of experience as Oracle Application’s consultant in Implementing, Setting

up, Customizing and Providing post production support of Oracle Applications

12i/11i/11.0.3 (GL, AR,AP, FA,CM,PO, iprocurement, INV, OM,QP,WSH,AOL,

SYSADMIN, BOM).

Designed legacy data conversion systems for various modules (GL, AR, AP, PO, INV, QP

and OM) through interface programs using PL/SQL (Utl_File, File_IO) and SQL*Loader.

Proficient in Data Conversion and Data Migration using SQL*Loader, Interfaces, APIs of

various modules.

Experience with Data Analysis tools like TOAD, PL/SQL Developer and Rapid SQL access

data for querying and reporting.

Experience with creation of Database objects like Tables, Views, Synonyms, Sequences,

Index, Constraints, Partitions, Clusters, Stored Procedures, Functions, Packages, Cursors,

Ref Cursors, TKPROF, EXP/IMP, Exceptions, Complex Joins, Triggers and Autonomous

Transactions.

Developed ETL Data Extraction, Data Mapping, Data Conversion and Data Loading using

SQL, PL/SQL, SQL*Loader and various UNIX Shell Scripting.

Worked on Customizing standard oracle forms to meet the client’s extension and creating

new oracle forms based on TEMPLETE.fmb.

Experience with business process/requirements analysis, module set up and configuration,

documentation, ability to spec customizations and reports, and knowledge transfer

experience.

Have Good understanding of Reconciling, Period Close Processes, Global Accounting

Engine, Billing and pricing Engine across various Modules.

Experience in customizing standard Oracle forms with the use of TEMPLETE.fmb,

custom.pll.

Strong knowledge of relational databases and Oracle E-Business Suite back-end design,

proficient with Oracle tools (Forms & Reports, PL/SQL, SQL*Loader).

Extensive experience in integrating custom applications with Oracle E-Business Suite,

analysis and database programming.

Strong emphasis and proven experience with the Financials and Manufacturing and CRM.

Designed and customized reports using BI Publisher in OM, PO, INV and AR modules.

Significant Performance Tuning capabilities and experience related to the Oracle E-Business

Suite.

Experience in writing design documents (AIMS) MD50s and MD70s.

Strong technical writing and communications skills.

Result oriented & committed to meet the goal. Experienced in working in tight schedules.

SKILLS

RDBMS Oracle 10g/9i/ 8i

GUI Developer/2000(Forms 9i/6i//4.5& Reports 9i/6i/2.5), Discoverer 4i/3.1

Languages SQL, PL/SQL, Pro *C, C, C++, JAVA,XML,UNIX-Shell Scripts

Tools TOAD, SQL* LOADER, SQL* Plus, Data Load, TAVIZ, Oracle Forms

Builder, Reports Builder, Kintana, CVS, CCC Harvest,, XML Publisher,

Discoverer Administrator 9i/10g, Ultra Edit, WS-FTP, Test Director

8.0,Quality center, Cygwin

Applications Oracle ERP (R12/11i/11.0.3)(Oracle General Ledger, Oracle Payables,

Oracle Receivables, Order Management,CRM, Oracle Purchasing, iexpenses,

Oracle Fixed Assets, Oracle Inventory, iprocurement, Oracle Advanced

Pricing, Oracle Shipping Execution, CFG, Trading Community

Architecture(TCA), Application Object Library, System Administration )

OS UNIX (Sun & HP), Windows *

EXPERIENCE

Oracle Developer

Herbalife, LosAngeles, CA Jan 2009 – Till Date

Herbalife Ltd. USA is a premier nutrition and weight-management company which includes the core

products for energy & fitness, personal care etc.This Project involves development of new custom

forms, reports, conversions, tuning and enhancements as per the requirements.

Responsibilities:

Developed customized forms using Forms 6i and implemented them in Oracle Applications

using AOL

Developed and worked on pack slip report and pick slip report.

Worked on designing various XML Publisher reports by creating data templates and XML

files in PO and OM modules.

Developed Supplier search and creation pages (oa framework) as per requirements.

Create and develop highly complex applications using Oracle as back-end with expertise in

design and development of Oracle PL/SQL Packages and Procedures.

Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes,

Synonyms, Sequences, Exception Handlers, Cursors, Partitions, Stored Procedures,

Functions in PL/SQL, Packages in PL/SQL, and Dynamic SQL.

Work with functional setups to create AP invoice sources, Accounting flex field, Chart of

accounts.

Performed SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints and TKPROF

utility. Participate in testing and the development of performance standards.

Also involved with many Purchasing setups and Order Management interface designs. Setup

Payment Terms, PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction

Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees

Developed Workflow process in procure to pay cycle for Requisition approvals, which

sends notification to appropriate user when requisition is approved.

Worked with functional team to prepare the chart of accounts cross-reference data to load

the chart of accounts, Journals data and Invoices data.

Support the users when loading AP Invoice and other payment activities like printing

payment registers and checks.

Wrote packages and procedures which are useful for troubleshooting the import process

Environment: Oracle Applications Release 11i (OM, AR,GL, INV, FM, AP, PO), Oracle 10g,

Forms 6i and Reports 6i, PL/SQL, Java, JDeveloper, Vault,Optio 7.8, SQL*Loader, Winscp.

Oracle Developer

ON SEMI, Phoenix, AZ Jun 2008 – Dec 2008

ON Semiconductor is a preferred supplier of efficient power solutions to customers in the power

supply, automotive, communication, computer, digital and consumer, medical, industrial, and

military/aerospace markets. Its Global corporate headquarters are located in Phoenix, Arizona. The

project involved the migration of system from Slovakia (SKK) to EURO.

Responsibilities:

The system migration was successfully completed on time with a minimum number of issues

that are being resolved.

Attended Design meetings and technical meetings with Developers from various other

applications

Developed scripts to create tables, views, synonyms, sequences, PL/SQL stored procedures,

functions, packages and database triggers.

Developed and maintained database system and performed general database procedures.

Developed for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL

and Various Shell Scripts.

Written complex SQLs using joins, sub queries and correlated sub queries.

Used features like PL/SQL record inserts updates and worked with ref cursors.

Written complex SQLs using joins, sub queries and correlated sub queries.

Wrote Test cases and performed data validation and process testing for application moving

into production.

Creation of unit test cases, test case review and testing.

Coded well-tuned UNIX Korn Shell scripts, Wrapper scripts for scheduling tasks.

Thorough understanding of the issues involved in development and integration of modules.

Involved in Performance tuning which included creating indexes and modifying tables

using explain plan utility.

Analyze and provided documentation of the new table structure, schemas, reports and

XML publisher modifiable formats in financials.

Worked on converting all the Historical Invoices using Payables Open Interface Import

into Production.

Written an Interface for Account Payables (AP) Invoice Upload, which creates invoices

from a CSV file.

Converted the GL balances and transactions into production.

Involved with support team for Post GO-Live issues and production issues.

Customized the standard reports in AR module like Aging by Account, Dunning History

and Billing History.

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

Worked on designing various BI Publisher reports by creating data templates and XML

files in PO and OM modules.

Registering Concurrent Programs, creating Request Sets, Shell Scripts, Sqlloader

Control files and custom Programs to load the data into interface tables.

Environment: Oracle applications 11.5.10 (AP, GL, AR, PO, CRM, INV, HR), SQL*Plus, Oracle

9i, Forms6i, Reports 6i, BI Publisher, Discoverer, SQL*Loader, UTL Scripts, TOAD, Data Load,

Harvest, PL/SQL, Windows XP, UNIX

Oracle Applications Techno Functional Consultant

ALCOA, Pittsburgh, PA Mar 2008 – May 2008

Implementation of Oracle Applications 11i

This is an implementation of Oracle Applications 11.5.10 with modules ranging from financials to

manufacturing, Alcoa which is the world leader in the production and management of primary

aluminum, fabricated aluminum and alumina combined is affiliated to SAPA which is already

running on oracle 11.5.10. All the customizations were re-implemented/moved from SAPA.

Responsibilities:

Designed legacy data conversion programs for various modules (QP, BOM, AR, AP, PO,

INV and OM) through interface programs using PL/SQL (Utl_File, File_IO) and

SQL*Loader.

Involved in studying the existing system, preparing the technical design to extract data from

legacy system into Oracle Applications open interface tables.

Responsible for the set-ups of relevant HZ profile options and scheduling the standard

concurrent programs.

Developed an interface to load the requisitions into Oracle Purchasing.

Responsible for the creation of custom views for custom address validations via

Descriptive Flex Fields (DFF).

Involved in developing the WEB ADI integrator for Bill of materials upload.

Involved in pricing conversion from Legacy System (Billing) into Oracle pricing by using

Pricing Interface.

Customized various PL/SQL packages and worked on converting these packages and

various Oracle 6i reports into BI Publisher reports by creating data templates

Creation of concurrent programs, executables, value sets and request sets.

General Ledger

Developed several Reports using FSG, and involved in running reports like Journal Entry

report, Account analysis reports, Accounts hierarchy report.

Used open Interface to Import Journals by GL_Interface and Budget Transfer to GL by

using GL-Budget-Interface.

Used Oracle Financial Analyzer to load the interface data and to extract the data by running

the Extract programs.

Involved in checking the status of Extract program thru the Financial Analyzer.

Used PL/SQL for validating the data from legacy system to interface tables.

Environment: Oracle applications 11.5.10 (AR, AP, GL, PO, OM, INV, QP, BOM), SQL*Plus,

Oracle 9i, Forms6i, Reports 6i, SQL*Loader, UTL Scripts, TOAD, PL/SQL, Windows XP, UNIX

Oracle Applications Techno Functional Consultant

Die bold Incorporated, Canton, OH Jun 2007 – Feb 2008

Implementation of Oracle Applications 11i

This is a business transformation project where client moved to Oracle Applications 11i (11.5.10)

from legacy in Financials(GL,AR,AP, CM, FA,PO), SCM(INV, OM, QP, WSH), CRM(OKC,OKX)

modules and performing necessary imports through API’s open interface tables from various legacy

systems, Involved in setting up, Customizations, Extensions and Post Production Support.

Responsibilities:

Worked on various Financial, Manufacturing modules.

Worked in setting up User responsibilities, Menus, Functions, Request Sets that comply with

Sarbine-Soxley.

Worked on customization of OEOL workflow in order management.

Helped in providing data fixes to day-today issue in Resolving Workflows (OEOL, SRR)

which are in error status.

Automated the Entire SRR(Service Repair Return) process which will be used to manage the

return of specific items recovered from Customer’s equipment during a Service call to

Common Depot Repair Center, Using custom WF process leveraged the user from creating

Inter-organization Transfer, Receiving and IR/ISO Process for those defective items.

Automated Receiving of Item’s and creating receipt in the destination organization which

involved Multi-org environment using Receiving Interface.

Worked on Requisition Import interface, creating internal Sales Order, Progress the internal

sales order using Process Order API, Pick Release/Confirm and ship-confirm using WSH

Public API’s.

General Ledger

Designed and developed Journal Import interface to import journals from legacy system.

Designed and developed solutions to automate and schedule processes that could not be

automated otherwise, with Concurrent Manager.

Designed and developed interface to extract and transfer journal information from Oracle

GL to legacy system.

Performed conversion of purchasing category using Using UNSPSC Codes in oracle

iprocurement implementation.

Worked in iSourcing Spreadsheet to PDOI Loader which is designed to load the data from

iSourcing Spreadsheet to PDOI using Concurrent program.

Worked on configuration on iexpense module, also assisted in debugging approval problems

in expense reports created my employees of the company.

Assisted in month end closing process for issues in iexpense and Accounts payable.

Worked on one-time conversion and on-going maintenance of price lists Secondary/

Primary, adding new items under price list, modifying pricing attributes using pricing Public

API qp_price_list_pub.

Re-Implemented iProcurement & all its customizations using Oracle Framework on 11.5.10.

Did the entire iProc upgrade project. Used JDeveloper 9.0.3 to make all extensions/changes

to OAF components.

Worked on migrating the forms customizing logic from custom.pll to Forms personalization

in 11.5.10 enhancement. Performed migration of personalization’s and forms form one

instance to the other.

Developed Custom forms in Receiving responsibility to receive good in receiving form

based of custom table and do inter-organization transfer and receive good automatically with

this process or even perform IR/ISO if required.

Have good understanding of forms architecture, libraries, compilation procedure and

registering forms as functions and assigning then to menus. Also have experience in creating

custom forms as read-only based of oracle standard forms.

Worked on Customizing standard oracle forms to meet the client’s extension and creating

new oracle forms based on TEMPLETE.fmb.

Worked on procure to pay (P2P) cycle like raising RFQ, quoting, created Pos, entering

invoice in accounts payable etc.

Developed interface that would extract approved planned orders from Servigistics and will

then load them as internal requisitions or purchase orders (Purchase Order Requisitions

Open Interface). This eliminated the need to manually enter these orders in Oracle after

planning is completed in Servigistics.

Developed Install base conversion program.

Developed Service contracts Conversion program for moving existing data from legacy

system to Oracle Contracts.

Developed PL/SQL routines so as to facilitate usage of Entitlement API’s available in

Contracts

Environment: Oracle Applications Release 11i, Oracle 9i, GL, AR, AP, PO,CRM, OM, Forms6i,

Reports 6i, Oracle Workflow 2.6/2.x, SQL, SQL*PLUS, SQL*Loader, UTL Scripts, TOAD,

Discoverer4i, PL/SQL, WinNT and UNIX

Oracle Applications Consultant

GE Access Denver, CO Jun 2006 – May 2007

Customization of Oracle Financials

This is an implementation of Oracle Financials Applications 11i (11.5.10) with setting up,

Configuring and Customizing client extensions for various modules GL, AR, AP, FA, PO,

iprocurement, INV,OM. And also performing necessary imports to open interface tables from

legacy systems. Responsibilities:

Customized various transactions in Accounts Receivables like Invoices, Receipts, Credit

Memos and Debit Memos etc. Customer and Invoice conversion from Legacy System

(Billing) into Oracle Account Receivables by using Customer Interface and Auto Invoice.

Developed SQL * Loader Scripts for importing legacy systems data into AR interface tables.

Worked on Customer and Invoice Data Conversion from Legacy System (Billing) into

Oracle

Performed conversion of purchasing category using Using UNSPSC Codes in oracle

iprocurement implementation.

Worked in iSourcing Spreadsheet to PDOI Loader which is designed to load the data from

iSourcing Spreadsheet to PDOI using Concurrent program

Worked on Auto lock Box interface program to interface Cash Receipts from EDI and

Non-EDI customers.

Worked on automating Write-off for Invoices and Debits.

Creation of SQL*Loader control programs and PL/SQL validation procedures to execute

along with Customer Interface (AR), and Order Import Interface (OE) programs to support

the interface requirements. Customized the existing LOV's.

Completed the Receivables Cycle by running the Concurrent Process to transfer transaction

information from Oracle Receivables to Oracle General Ledger.

Modified the Print Statements report and Invoice report as per the formats/layout of the

client

Environment: Oracle Applications Release 11.5.10/11i, Oracle 9i, GL, AR, AP, PO, FA,CRM,

OM, Forms6i, Reports 6i, Oracle Workflow 2.6/2.x, SQL, SQL*PLUS, SQL*Loader, UTL Scripts,

TOAD, Discoverer4i, PL/SQL, WinNT and UNIX

Oracle Applications Consultant

Lexmark. Lexington, KY May 2005 – Apr 2006

Oracle Applications Customization.

This project is an implementation of business flow Order to Cash in Oracle Applications 11i.

Involved in developing conversion programs, interfaces, customizing reports, building custom

reports and writing UNIX shell scripts based on the functional specifications provided.

Responsibilities:

Account Payables/ Purchasing

Defined payment terms, locations, periods, tolerances etc. Integrated Payment reconciliation

information and Purchase Order information with AP.

Performed conversion of purchasing category using Using UNSPSC Codes in oracle

iprocurement implementation.

Validated the data and populated the Payables interface table through a Concurrent program

which in turn submits a standard Payables Interface program.

Designed and developed complete Vendor Interface for import of vendor information into

the system. Used SQL*Loader for import into interface tables, and PL/SQL block for

complete validation of data and inserting into base tables.

Imported Requisition Details (Requisition Import) using SQL * Loader and PL/SQL.

Modified the Reports like Invoice History, Invoice Aging, Prepayment Status, and Invoice

on Hold Reports.

Accounts Receivables

Entered and processing various transactions such as Invoice, Debit Memo, Credit Memo

And Deposit. Worked on Auto Invoice and Customer Interface, Entered Receipts and

Receipt Information.

Creation of SQL*Loader control programs and PL/SQL validation procedures to execute

along with Customer Interface (AR), and Order Import Interface (OE) programs to support

the interface requirements.

Completed the Receivables Cycle by running the Concurrent Process to transfer transaction

information from Oracle Receivables to Oracle General Ledger.

Developed various reports such as Detail Payment reports with reference to Salesperson,

Branch Level Transaction report and Customer’s outstanding report.

Environment: Oracle Applications Release 11i, (GL, AR, AP, PO), Gentran6.0/5.2,Forms6i,

Reports 6i, SQL*Plus, SQL*Loader, Oracle Discoverer, OAD, PL/SQL, WinNT and UNIX

Oracle Applications Consultant

Proc Tor & Gamble, Cincinnati, OH Apr 2004 – Apr. 2005

Implementation of Oracle Applications 11i

This is an implementation of Oracle Financials Applications 11i (11.5.8) with Setting up,

customization and providing post production support for client extensions in AR, AP, FA, CM

modules and performing necessary imports to open interface tables from legacy systems.

Responsibilities:

Worked extensively on setups of AR, AP and FA Modules.

Defined customer profiles, customers, payment terms, payment methods and tax structures,

including tax exemptions and exceptions in Accounts Receivables.

Defined vendors, vendor classification and payment terms to enable the offering of discount

terms with installment payments.

Implemented Trading Community Architecture (TCA) to support complex trading

communities and relationships within a trading community using PL/SQL APIs.

Implemented AUTO LOCK BOX, Auto Invoice in Oracle Applications 11.5.8

Defined Descriptive flex fields necessary for report and form customizations, and

distribution sets and bank related information, and defined accounting rules for revenue

recognition with respect to service and maintenance contracts.

Performed Performance Tuning on various reports and Interface code (SQL) using Explain

Plan for better Performance.

Developed technical documentations of work done complying with AIM Methodologies

Environment: Oracle Applications 11.5.8, Oracle 9i, SQL*Loader, PL/SQL, TOAD, Reports 6i,

HP-UNIX, Test Director 8.0, Cygwin, Siebel Tools 7.5.2, Siebel Applications 7.5.2, Telelogic

DOORS 7.1, CCC Harvest 4.1.2 Client.

Oracle Consultant

Sriven systems Limited, India Nov 2002 – Feb 2004

Implementation of Oracle Applications 11i

The project involved implementation and customization of custom forms and reports suitable for

the client. Forms in GL, AR modules were customized according to the user requirements. Oracle

Applications tables were populated from legacy feeder systems using interfaces and SQL*Loader.

Responsibilities:

Developed customized forms using Forms 6i and implemented them in Oracle Applications

using AOL

Developed custom reports from GL and AR modules using Reports 6i

Developed interfaces using APIs

Imported data from legacy and feeder systems to Oracle Financials using PL/SQL and

SQL*Loader

Implemented budgetary controls using budget journals data imported from feeder systems

Developed concurrent programs using PL/SQL

Customization using Application Object Library (AOL)

Developed concurrent programs using PL/SQL and Shell Scripts these were implemented in

AOL and registered those programs

Wrote packages and procedures which are useful for troubleshooting the import process

Created Journal Entry Interface through SQL*Loader

Worked on Auto Invoice Conversion Program

Environment: Oracle Applications Release 11i (GL, AR, AP, PO), Oracle 9i, Forms 6i/4.5 and

Reports 6i/2.5, PL/SQL, SQL*Loader, SQL*Plus.

Contact this candidate