Oracle Project

Vagdevi Akella S

Email: ********@*****.***

Phone: 510-***-****

Experience Summary

Around 7 years of experience in Application Developmentusing Oracle SQL,

PL/SQL, and Developer Forms and Reports.

Experienced in interacting with Business Users, Business Analyst, IT Leads,

Developers and System Analysts to gather and analyze business requirements and translating

requirements to functional and technical design specifications.

Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.

Experience in Database design using Normalization and E/R Diagrams.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL

procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor

variables, System reference cursor, Dynamic SQL.

Experience in developing External Tables, Joins, Indexes and sequences.

Experience in query optimization, performance and tuning (PL/SQL) using SQL

Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global

temporary tables and table partitioning.

Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures

and packages.

Extreme Use of exception handling methods along with Pragma

Exception_init in order to associate our own created exception names.

Experience in using several built in database packages such as DBMS_JOB,

DBMS_OUTPUT, UTL_FILE, and DBMS_SQL to name a few.

Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time

constrained performance.

Expertise in loading data from legacy systems using SQL*Loader.

Good knowledge in front end development using oracle forms/reports6i/9i/10g.

Experience in creating master detail forms and adding alerts.

Experience in deploying forms and reports on the web.

Experience in developing forms based on views, tables and procedures in

tabular and form layouts.

Experience in developing both web layout and paper lay out reports in various

styles based on the user requirements.

Extensively worked with third party database tools like TOAD & PL/SQL

Developer.

Strong knowledge of Extraction Transformation and Loading (ETL)

processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

Good in creating users and maintaining their roles and responsibilities.

Experience in writing Technical design documents and developing unit test

documents.

Experience with coding in Core Java, JSP & Servlets and HTML.

Strong interpersonal skills, ability to interact with people at all levels. Good

communication and presentation skills.

• Having 7+ years of work experience in Oracle Applications in different areas like analysis, design,

development and implementation of business requirements through direct interaction with customers.

• Worked in Oracle technologies SQL, PL/SQL, Forms 6i, Reports 6i both development and support.

• Experience in working with Oracle Utilities like SQL*Loader, UTL_FILE Package and Interfaces.

• Having work experience in Financial (AP, GL, AR), Distribution (PO, OM) and Manufacturing (INV, PIM)

modules in oracle R12 and Oracle Applications 11i.

• Development and Customization of Reports, Interfaces, Conversions as per client requirements.

• Having ample knowledge in Procure to Pay & Order to Cash life cycles.

• Good team player and strong technical and program solving skills.

Professional Experience

• Working as IT Analyst for Tata Consultancy Services, America from Oct 2012 to till date.

• Worked as IT Analyst in Tata Consultancy Services, Chennai from 2007 to 2011.

• Worked as Technical Consultant in Spike Software Solutions, Hyderabad from 2005 to 2007.

Education Qualification

• Master of Science (Electronics and Communication) from Andhra University, Viskhapatnam, Andhra

Pradesh in April 2005.

Technical Skills

ERP Tool :Oracle R12(12.1.1),Oracle Apps 11i (11.5.10.2, 11.5.9,11.5.3)

Modules : PO, OM, INV,PIM,AP, AR and GL

Database : Oracle 9i

Languages : SQL, PL/SQL

Tools/Utilities : TOAD, FTP, SQL *Plus, SQL *Loader, Putty,Fnd Loader,Perforce,VSS,ADI

GUI Tools : Developer 2000 (Reports 6i),Oracle forms.

Operating Systems : Windows, UNIX

Knowledge on : XML Publisher,Oracle BPEL,B2B

Assignments

Project 1: Item Hub Foundation (eGenie) Production Support.

Customer: Cisco Systems. Milpitas, California, Oct 2012 – till date.

Organization: Tata Consultancy Services Limited.

Cisco Systems, Inc. is the worldwide Leader in Networking for the Internet. Cisco has its applications

currently running on Oracle Applications Release 10.7/11.5.9/R12.The support operations are spread

across the globe. We are supporting Oracle Inventory and Oracle PIM modules in Oracle ERP which

includes Item creation and Mapping with Several attributes and data flows to several Upstream and

Downstream applications. The Job required strong Functional product knowledge and good analytical

skills.

Environment: Oracle R12, Oracle apps 11.5.10.2 (Inventory and PIM),Oracle BPEL and B2B.

Role: Production Support Executive (developer)

Work History and Responsibilities:

• Worked on R12 for Oracle Inventory and Oracle Product Information

Management Modules to support Production instances

• Coordination with the client to analyse and understand the issues.

• Worked on custom package which loads the data of items and its attributes from

mtl_systems_items_interface and ego_itm_usr_attr_intrfc into apps.mtl_system_items_b msib,

apps.ego_mtl_sy_items_ext_b using Item Import and Import Item Catalog program.

• Worked on Outbound custom interface package which extract data from base

tables and populates data in custom tables for B2B partners.

• Worked on custom reports to which populates data of items and its pricing

information.

• Writing adhoc queries to extract data based on client requirement.

• Providing technical solutions for client issues.

• Worked Daily Process monitoring involved in the production.

• Prepared documents for Support issues.

• Involved in Daily and Weekly status calls.

• Responsible for sending Daily Incident status to the team.

• Coordinating with Cross functional teams to assist in troubleshooting/issue

identification and fixing them.

Project 2: EA EU AMS Offshore Support.

Customer: Electronic Arts, Inc., Redwood city, California, Oct 2010 – Nov 2011.

Organization: Tata Consultancy Services Limited.

Electronic Arts, Inc. is a major American developer, marketer, publisher and distributor of video games.

Founded and incorporated on May 28, 1982 by Trip Hawkins, the company was a pioneer of the early

home computer games industry and was notable for promoting the designers and programmers

responsible for its games. It is one of the largest video game publishers in the world.

Environment: Oracle R12, Oracle apps 11.5.10.2(PO, AP, AR, GL, OM, INV), ADI and Oracle 9i

Role: Module Lead

Work History and Responsibilities:

• Worked to support 11.5.10.2 production Instance for Oracle Financials.

• Worked on enhancements on custom objects in AR, AP and PO modules in

oracle apps 11i and oracle R12.

• Involved in testing activity by writing and executing the Test cases and deploy the

same to migrate to other instances.

• Involved in Month End Closure (MEC) for financials for cleaning of interfaces

and closing the periods.

• Attending MEC calls for critical issues of financials.

• Representing Problem Management calls to prioritise the enhancements and

developments.

• Involved in doing setups of VAT changes across organizations at year end.

• Coordination with the client to analyse and understand the issues.

• Worked on few performance issues along with DBA.

• Writing adhoc queries to extract data based on client requirement.

• Raised Tar’s and prepared patch analysis reports.

• Worked on Form Personalization of AP Invoice Workbench form GL Validation on R12

environment.

• Developed EA Credit Limit Check Alert to notify users when credit limit check has exceeded 85%

of their credit limit in R12 environment.

• Developed EA PO Accrual Receipt on Flag Alert to notify users who have created PO saying that

receipt on flag is not checked on Oracle 11i environment.

• Enhanced custom package in Custom.pll which will populate Tax code on purchase order form

based on the Ship to location country on oracle 11i environment and worked with DBA to move the

modify form to server using UNIX.

• Developed Purchase order and Account Payables Invoice Report to display the PO and

corresponding Invoice details.

• Developed an adhoc queries to modify the tax codes which are incorrectly populated after the

changes are done during the year end closer and executed the scripts in Unix server.

• Modified EA Supplier Payments Report by adding additional field freight terms,compiled unit tested

and moved to production using Unix server.

Project 3: MDM Phase II Development and ERP Impact Analysis.

Customer: Electronic Arts, Inc., Redwood city, California, Jul 2010 to Sep 2010

Organization: Tata Consultancy Services Limited.

EA implemented Product MDM (Phase 1) for packaged goods in March 2009 as part of strategic

initiative to centralize and harmonize Product reference entity. Phase 1 implementation clearly

established MDM as the sole master reference for all analytic product and the definition and use of

project and project attribution. This project is an enhancement to incorporate operational product

mastering for digital products in existing Product MDM solution and governance model. It includes

refining the definition and usage for Item so that it is applicable to both packaged goods and digital

products. This project will also address updates to project attribution as needed as well as MDM tool &

usability enhancements.

Environment: Oracle apps 11.5.10.2(Order Management),and Oracle 9i

Role: Developer

Responsibilities and Work History:

• Worked on analysis and impact on ERP objects.

• Enhanced the ERP custom packages which are impacted because of the

changes on MDM.

• Worked on preparation of test cases.

• Involved in end end integration testing and preparation of test results.

• Involved in preparation Migration scripts and Go live documentation.

• Analysed all ERP custom packages using UNIX grep commands for finding the usage of columns

which are modified on MDM side.

• Found few packages which need to be modified and enhanced with the new column name

executed and unit tested.

• Prepared test cases for the changes and involved in integration testing.

• Developed migration scripts using Unix commands and executed in production.

Project 4: EU VMI Phase II Implementation.

Customer: Electronic Arts, Inc., Redwood city, California, Mar 2010 to Jun 2010

Organization: Tata Consultancy Services Limited.

The VMI (Vendor Managed Inventory) project has an overall objective of the global alignment and

enhancement of VMI services and functionality within Electronic Arts. This project is known as the

Chamber of Secrets project.

Electronic Arts currently works in partnership with an external service provider (Vision in North

America/Europe, and V Net in the Asia Pacific region) to manage and analyse sales and inventory data

for selected retailers; and to assist in the generation of product purchase orders and allocations down to

a store level. The purpose of this activity is to collaboratively engage with retailers to ensure they have

the right product in the right place at the right time. In turn, this enables revenue growth for both the

retailer and EA.

Environment: Oracle apps 11.5.10.2(Order Management), MDM (Master data Management) and Oracle

9i.

Role: Senior Technical Analyst

Work History and Responsibilities:

• Worked on development of custom packages.

• Creation of Alerts and Distribution lists.

• Registering of concurrent programs and request sets.

• Involved in Unit and UAT testing activity.

• Involved in preparation Migration scripts and Go live documentation.

● Developed custom interface for MTL_Reservations which makes to reserve quantity for

kee customers.

• Developed different custom packages for checking the quantity in inventory and based the

conditions the quantity should be reserved for the customers and created cancellation

reservation custom package to cancel the orders.

• MTL_RESERVATIONS_INTERFACE is the interface table and used Inv_reservation_pub API

to populate MTL_DEMAND and MTL_RESERVATIONS are the base tables.

• Registered the concurrent programs for the packages and scheduled to run on each day.

• Developed a Error report to fetch the data from interface and notify the users and the

support team.

Project 5: KLC Oracle Support offshore.

Customer: Knowledge Learning Corporation. Portland, Oregon,May 2008 to Mar 2010

Organization: Tata Consultancy Services Limited.

Knowledge Learning Corporation (KLC) began as Children's Discovery Centers in 1983 and expanded to

more than 700 community centers and 450 onsite school programs following its acquisition of Children's

World Learning Centers in 2003.

In 2005, KLC joined forces with KinderCare Learning Centers, Inc. (KinderCare). KinderCare was

founded in 1969 and in 2005 operated over 1,250 centers. The KinderCare merger made KLC a leading

national child care and education provider.

Environment: Oracle apps 11.5.10.9(AP, AR, GL, PA and FA) and Oracle 9i.

Role: Team member

Work History and Responsibilities:

• Worked to support 11.5.10.2 production Instance for Oracle Financials.

• Worked on enhancements on custom objects in AP, PA and PO modules.

• Involved in testing activity by writing and executing the Test cases and

deploy the same to migrate to other instances.

• Responsible for Daily activities like Ultra Main which interfaces requisition

data to oracle.

• Responsible for sending Daily and Weekly Status to Onsite.

• Supported for other Vanilla production instance (11.5.10.2) on financials.

• Coordination with the client to analyse and understand the issues.

• Worked on few performance issues along with DBA.

• Raised Tar’s and prepared patch analysis reports.

• Prepared SOP’s (Standard Operational Procedures) for Support issues.

• Modified KLC Project Expenditure Detail Report to fetch the correct data as the data was

incorrect.

• Modified Oracle Assets Reports as the report is unable to view full Description column by

increasing the length of the column.

• Worked on form personalization for the responsibility KLC PCARD SIT Updates to restrict for

modify the special information only P Card Holder.

• Worked on KLC Add on cost report to pick the correct as the report is not showing correct

data.

• Developed AP Invoice interface to populate data from staging table to invoice base table

AP_INVOICE_ALL and AP_INVOICE_DISTRIBUTIONS_ALL table.

• Worked on Ultra main (custom PO package) to load data from legacy system into PO base

tables PO_HEADERS_ALL and PO_LINES_ALL.

• Register concurrent programs and distribution list to notify the errors.

• Developed KLC User Audit Report using XML Publisher.

• Worked on Performance tuning of KLC reports using HINTS.

Project 6: 304 OF Server Tech Upgrade.

Customer: Tata Communications (VSNL), Chennai, India,May 2007 to April 2008

Organization: Tata Consultancy Services Limited.

Work History and Responsibilities:

• Migrating the Dynix OS and Sequent server into Sun server with Solaris

Operating System.

• Upgrading the External applications GBOS and GDSS from 10.7 into Oracle11i

applications (11.0.3) with the Oracle database as 8i version.

• Migrating the External system from 10.7 into 11.0.3.version by moving all the

PL/SQL Procedures, Packages, Forms, Customized codes, Reports and Triggers into the new

environment.

• Responsible in successful migration of Oracle financial customizations done at

VSNL International.

• Responsible for ensuring that Oracle Financials functions well with all interfacing

applications namely billing applications, provisioning applications.

• Created and executed the test cases and deploy the same with migrated

instances and Database Applications maintained as per earlier.

• Analyzed the Customized Applications as per the Business Requirements

• Worked on preparing the Design documents along with DBA.

• Co ordinate the development activities in setting up the development, test and

production environments on the new servers.

• Analyzed programs (Reports and PL/SQL program units) to identify data model

changes & performance issues.

• Coordination with the client, consultants & multiple project teams simultaneously.

Project 7: AC Implementation.

Customer: Americhem Cleveland,Ohio, Mar 2006 to May 2007

Organization: Spike Software Solutions.

Americhem is a world class manufacturer of custom color concentrates, additive concentrates, and

specialty dispersions. As the largest privately owned custom. Color concentrates manufacturer in the

world. The objective of this project is to implement (Oracle 11i E business suite) and to rollout to

remaining areas of Americhem. The various oracle modules implemented are Accounts Payables, Cash

Management, General Ledger, and Purchasing.

Environment: Oracle Applications E Business Suite 11.5.8 (ERP),Developer/2000 Forms 6i & Reports

6i,SQL & PL/SQL using TOAD,SQL Loader, Oracle 9i

Role: Technical Consultant

Work History and Responsibilities:

• Developed a program for converting journals from legacy system to Oracle

through open Interface. Loaded data from flat file to the temporary table and then transfer to the

GL_INTERFACE table after validating data is then transferred to the base tables using journal

import program.

• The program will export the GL balance information, to company as a data file.

UTL file handling was used to create a file in the Custom Standard outbound Directory and write

data to it. A generic Host Concurrent Program wills JAVAFTP the file to the external system.

• Developed open interface program for importing purchase orders from legacy

system to Oracle. Data is loaded into staging table using SQL * loader and then validating, the

data is transfer to the interface tables like PO_HEADERS_INTERFACE and

PO_LINES_INTERFACE and then to the base tables using Standard Import Purchase Order

program.

• Objective was to develop custom form, which will display assignment of an

organization and the vendor. This is a tabular form is used as a reference form for suppliers.

• Customizing journal approval workflow by creating a profile and Assigning

value for the profile.

Project 8: WI implementation.

Customer: Waters Inc, Carson California, USA, Apr 2005 to Feb 2006

Organization: Spike Software Solutions.

Water Corporation is world leader in high performance liquid chromatography, mass spectrometry,

thermal analysis and rheometry products and services. Our technologies provide these customers with

fundamental data on chemical mixtures and materials. This project is considered to be the ERP

Implementation for WI. The objective of this project is to implement Oracle 11i E business suite to derive

the fullest benefits of this modern technology for efficiently carrying out different functionalities.

Environment: Oracle Applications E Business Suite 11.5.8 (ERP),Developer/2000 Forms 6i & Reports

6i,SQL & PL/SQL using TOAD,SQL Loader, Oracle 9i

Role: Technical Consultant.

Work History and Responsibilities:

• Developed Outbound interface for Positive Payment using UTL_FILE package.

• Customizing AP Customization interface workflow by adding validations. It

validated the data in AP_INVOICES_INTERFACE before running the standard import program

Payables Open Interface Import.

• I had developed a conversion program for natural accounting segment using

API.This API is used to import data from legacy to oracle system.

Contact this candidate