[pic] Lalitha Kambhammettu [pic]

Ph: 913-***-****

E-mail:

abl2ph@r.postjobfree.com

Professional Summary:

. Over 5 years of experience in IT industry including Requirement study,

Analysis, Design, Development, Testing, Debugging, Implementation,

Customization and Support of software applications in Oracle Applications

architecture.

. Working in Oracle Applications (11i & R12) as a Techno-Functional

Consultant performing functional and technical work:

o 2.5 years of experience in Project Accounting Costing and

Billing, OTL and iTime modules.

o 2.5 years of experience in Oracle Learning Management module -

Belongs to family of HRMS, mainly customizing & supporting the

OTA/OLM module with exposure to OM, AR, Inventory & QP Modules

of Oracle Applications11i and R12, along with Oracle 9i/10g db.

. Well versed with the products in the Oracle Applications technology layer

like: Oracle Applications Object Library (AOL/FND), Oracle Workflow (WF)

and Oracle Alert (ALR).

. Having domain knowledge in Distribution modules like Order

Management,Purchasing, Pricing, Inventory and Shipping.

. Worked with Order to Cash and Procure to Pay life cycles in Oracle

Applications-11i, Oracle Applications-R12 & well versed with RDBMS like

Oracle (10g & 9i).

. Well versed with forms and framework personalization and creating custom

pages in Oracle Application Framework (OAF).

. Having good knowledge in WinRunner.

Work Summary:

. Working with Oracle India Private Ltd. as an IT Consultant, Applications

IT from Feb-2006 to till date.

. Worked with Metaminds Software Solutions Ltd, Hyderabad, as QA Engineer

from Aug, 2005 - Jan, 2006

Certifications & Awards:

. 1Z0 - 007: Oracle Certified SQL developer

. 1Z0 - 147: Oracle Certified PL/SQL developer

. Sun Certified Java Programmer (1.5)

. Received 'Award of Excellence' and 'The Unsung Hero' award for

committed work in Oracle R12 implementation.

Technical Skills:

. Operating Systems MS Windows, Unix

. Languages SQL, PL/SQL, C, C++ & Java.

. Databases Oracle9i/10g

. ERP Oracle Applications11i (11.5.10) & R12

. Framework Oracle Applications Framework

. BI/Publishing Tools Oracle XML Publisher

. Testing Tools WinRrunner, Oracle Applications Testing

Suite

. Web Tools XML, DHTML & HTML

. Tools & Utilities ARCS, Putty & SSH Client.

. Oracle Tools SRVAP, Oracle Workflow Builder, SQL

Developer &

JDeveloper, SQL Loader, Oracle Discoverer

Education:

Degree Institution/University Period Score

M.C.A (Master of Acharaya Nagarjuna 2002-2005 85%

Computer University, Vijayawada -

Applications) India

B.C.A. (Bachelor of Acharaya Nagarjuna 1999-2002 79%

Computer University, Vijayawada -

Applications) India

Board of Intermediate Board of Intermediate 1997-1999 81%

Education. (10+2) Education, Andhra Pradesh

- India.

AISSE (10th Standard) Central Board of 1996-1997 66%

Secondary Education,

Andhra Pradesh - India.

Trainings from Oracle University:

. Oracle Applications 11i & AOL Coding standards.

. Oracle 10g: Advanced PL/SQL.

. Introduction to XML publisher.

. Oracle Application Framework for Developers.

. OAF Customization.

. Oracle R12 Order Management Fundamentals.

Work Experience:

Project: Legacy data Migration into Oracle Projects

Client: ORACLE CORPORATION

Role: Senior Developer (Techno-Functional)

Duration: Jun 2009 - May 2010

Environment: PL/SQL, Oracle Apps, Oracle APIs.

Whenever Oracle acquires companies, their legacy data is migrated to Oracle

database. We used to migrate this by using WinRunner scripts, which was

time consuming and lengthy process. To simplify the migration, I have

created PL/SQL API's to automate this process, which was robust and much

faster.

The PL/SQL API's are used to migrate the setups like Project & Tasks Setup,

Budget Setup, Agreements, Key Members and Customer contacts from legacy

system into Oracle Project Accounting.

In this process, Web ADI would take initial care of loading projects data

into temporary tables, later on, the APIs would take care of validating and

migrating data into the respective PA tables through a couple of concurrent

processes.

Responsibilities:

. Responsible for understanding the Business requirements and plan

for application migration.

. Responsible for the delivery of the solution on Oracle Apps R12.

. Extensively used Oracle public APIs (AMG APIs).

. Created concurrent programs for carrying out the data migration

from the Legacy system (Oracle acquired companies) to Oracle Apps.

. Involved in Co-ordination with the UAT team (Business).

. Work breakdown, deciding on Timelines, Estimations and Tracking.

. Conducted training sessions for the team to understand the Requirements

and Performance requirements of the system.

Project: Learning Credits Auto-creation Enhancement Bundle

Client: ORACLE CORPORATION

Role: Senior Developer (Techno-Functional)

Duration: Sep 2009 - Dec 2009

Environment: Oracle Forms 6i, PL/SQL, Oracle Apps R12.

Learning Credits Auto Creation is one of the custom solutions created for

OLM which closely integrates with Pricing and AR modules. Learning Credits

is a way where in the customer pays a certain amount of money ahead to the

Oracle University. With this the user enters into an agreement with Oracle

University to get a certain % of discounts on all education products that

they buy for some duration of time.

Responsibilities:

. Implemented Learning Credits Auto-Creation solution for 5 countries

with localizations.

1. I modified the form at various stages like added a salesrep LOV,

which in-turn will reflect in 'Pricing Agreements' form of

Pricing module & 'Transactions' form of AR.

2. Added a few fields to handle Argentina, Brazil and Columbia

localizations.

. Coordinated with AR team to get the solution live on time.

. Coordinated with business to get the UAT finished.

Project: XML based Education letters solution

Client: ORACLE CORPORATION

Role: Senior Technical developer

Duration: Jun 2009 - Sep 2009

Environment: PL/SQL, AOL, XML Publisher, Java.

One of the biggest custom solutions implemented for OLM is the Education

Letters solution. Every letter would gather the required data in the first

step and build an XML in the second step which would be placed into middle

tier. The main java program would then merge the generated XML file with

the RTF file to generate an HTML page which would be sent to the customers

through emails.

Responsibilities:

. I developed a few new letters for the Oracle University's demanding

needs like Enrollment Cancellation letter, eKit Activation Letter,

Setup Direction Letter. It includes development of a new package

that fits into the existing suite and designing/modification of an

rtf.

. Fixed bugs during UAT and handled post go-live.

. Active participation in code review activities.

Project: Framework Pages for Education Business

Client: ORACLE CORPORATION

Role: Senior Technical developer

Duration: Dec 2008 - Jun 2009

Environment: Oracle Apps R12, Oracle Applications Framework, java.

Customers of Oracle University receive various letters right from placing

the order till attending the class, which include various details like

Oracle Policies, Terms & Conditions, Oracle customer service phone and fax

numbers, etc. These details are maintained in custom tables. They need

update often, requiring approvals for the change and AIT involvement since

updates made directly from backend are critical.

Responsibilities:

. Developed framework pages to maintain the custom tables. Later the

pages were given restricted access to the respective country

representatives based on their access privileges.

. Students place orders to take classes and they receive eKits (Soft

copy of study material). Oracle iLearning facilitates the ability

for every student to download the material using a unique

key/password which is student/enrollment specific. I developed a

framework page to search and send data from Order Management to

iLearning.

Project: Oracle Learning Management - iLearning, Webreg Support

Client: ORACLE CORPORATION

Role: Functional Consultant

Duration: May 2008 - Oct 2008

Environment: OLM, iLearning, Webreg, Teleservices.

This support project was an on going one. The project aims at resolving

issues of the employees of Oracle and customers of Oracle University who

face issues at various stages like enrolling to a class, ordering a CD or a

class and so on.

Responsibilities:

. My role was to resolve the issues that were faced by the users.

Project: Project Accounting - iTime support

Client: ORACLE CORPORATION

Role: Functional Consultant

Duration: Nov 2007 - Apr 2008

Environment: Oracle Project Accounting, iTime, Teleservices.

This support project was an on going one. Users using iTime have issues

like they can't submit time for a certain project; their timecards have got

stuck in workflow and so on.

This also included the resolution of issues that occur during cost

generation like Distributing Labor cost (missing/ incorrect setups) and

Invoice generation process (Auto-accounting issues).

Responsibilities:

. My role was to resolve the issues that were faced by the users.

Project: Developing Regression Testing Scripts for Oracle Learning

Management

Client: ORACLE CORPORATION

Role: Technical Consultant

Duration: Apr 2007 - Sep 2007

Environment: WinRunner, Oracle Apps 11i & R12

The automated test scripts for OLM were developed using the WinRunner tool

for end-to-end testing. These scripts are also used for regression testing

during rollouts of new releases and projects (like, 11.5.10 release, R12.0,

After RUP patches, CRM to GSI merge, implementations of 10G, etc) for the

same.

Responsibilities:

. Developed OLM test plan and test scripts from scratch.

. Took sessions for business to make them use the scripts.

Project: Developing Regression Testing Scripts for Project Accounting

Client: ORACLE CORPORATION

Role: Technical Consultant

Duration: Jun 2006 - Mar 2007

Environment: WinRunner, Oracle Apps 11i & R12

The automated test scripts for Project Accounting were developed using the

WinRunner tool for end-to-end testing. These scripts are also used for

regression testing during rollouts of new releases and projects (like,

11.5.10 release, R12.0, After RUP patches, CRM to GSI merge,

implementations of 10G, etc) for the same.

Responsibilities:

. Converted existing PA regression test-scripts and migration scripts

to R12.

. Took sessions for business to make them use the scripts.

Project: Oracle HRMS - Core HR support

Client: ORACLE CORPORATION

Role: Functional Consultant

Duration: Feb 2006 - May 2006

Environment: Oracle HRMS, SQL, Tele Services.

This was the support project where we resolved the issues faced by

employees while using XX Employee Self service responsibility and some Core

HR related issues.

Responsibilities:

. My role was to resolve the issues that came to HRMS support queue.

Project: Integrated Genesis Selling

Client: EDGE NET

Role: SQA Engineer

Duration: Aug 2005 - Jan 2006

Environment: Manual testing, web-based application

This is an online ordering system which was web-based. The users could do

online shopping and submit their carts. The project was to test the on-line

ordering part of the application i.e. till the shopping cart is submitted.

Responsibilities:

. Created test scenarios for manual testing. Tested the application

based on the scenario documents. Coordinated with AR team to get

the solution live on time.

. Tested the application based on the scenario documents.

. Logged bugs, followed up with development team on getting them

fixed.

Project: ARINC-661 - Cockpit display system

Client: Honeywell

Role: Associate developer

Duration: Jan 2005 - Jun 2005

Environment: C++, Graphics, XML (XPAT)

This project aims at building widgets that get displayed in the cockpit

display of a plane. I used VC++ IDE for coding in C++. The input data would

come from XML files which have to be given to the C++ program. There was a

VB form that would display a mock cockpit display and show the animation.

Responsibilities:

. I was involved in writing the C++ code.

. Developed the VB form for the mock cockpit display.

. Involved in testing the code.

Extra Circullar Activities:

> Worked as Project Leader for two consecutive years during Global

Volunteer Days - 2008, 2009(Oracle)

> Successfully completed Dalhousie Winter Trek organized by YHAI in Dec -

2008

> Successfully completed Goa Sailing Expedition organized by YHAI in Dec -

2009

Contact this candidate