Lavanya

d3c0es@r.postjobfree.com

Contact No: +91-829*******

Professional Summary

A self motivated professional with strong analytical, communication skills. Having good understanding of time value, cost and quality of work. Highly committed and you can be rest assured of the best of commitment & productivity.

High level Roles and responsibilities

Having 3+ years of professional experience in Development and maintenance environment of applications in Oracle, Oracle Forms and Oracle Reports.

Having Knowledge in Reports development and Customization.

Having Hands on experience in Development and Enhancement of PL/SQL Coding.

Experience in developing, implementing and maintaining customized applications using Oracle and Developer 2000.

Good working experience in Forms6i, Reports 6i , PL/SQL, & Oracle databases concepts.

Experience in writing Cursors, Functions, Procedures, Database Triggers and Pl/sql Packages.

Having good idea in Forms and Reports development and customization based on Requirement.

Technical Skills

Operating System used : Windows 95, NT, 2000, Windows 2003

RDBMS : Oracle 9i, Oracle 10g.

Front End : Developer Suite 10G (Form and Reports)

Tools : TOAD, PL/SQL DEVELOPER.

Version Control : VCRA (Version Control Request Automation)

Reporting Tools : Oracle Reports.

Companies Served

Currently working as a Software Engineer in JDA Software India Pvt. Ltd., Hyderabad from August-2009 to till date.

Worked as Technical Consultant in iPass India Pvt Ltd, Bangalore from February-2008 to July-2009.

Educational:-

B.sc : From Sri Krishnadevaraya University

Project Profile:-

#Project Title:- Sony Sunrise

Client: SONY

Role: Developer.

Environment: Oracle 10g, PL/SQL, Oracle Forms and Reports.

Platform: Windows 2003.

Team Size: 25

Duration: Aug-2009 to Till Date.

Tools: PL/SQL DEVELOPER.

Description:-

The data will be transferred from the Sony file system (DMZ) to the i2 file system using FTP. Data from the blue files from the different source systems (SAP, Oracle ….) needs to be loaded in the data interface consolidate hub tables. One blue file format can have multiple interface files from different source systems. All data provided to i2 planning applications are stored, enriched and distributed to the various applications. The data comes in from the external systems or is generated in ABPP and then this data flows to the other systems. Data is provided as Full load, then the Inbound tables need to be truncated first then the new data needs to be loaded in the Inbound table. Transaction data will always be latest snapshot or Last week actual based on entity.

Roles and Responsibilities:-

• Design and Developed the Forms and Reports.

• Create PL/SQL Code to Manipulate the Data.

• Develop New Reports for Data Analyze.

• Customize Reports and Forms Based on Requirement.

• Create New Procedures and Functions and Triggers to achieve the Goal.

#Project Title Settlement

Client: iPass Communications, USA.

Role: Developer

Environment: Oracle 9i, PL/SQL, Oracle Tools, D2K.

Platform: Windows 2000.

Team Size: 14

Duration: Oct- 2009 to July- 2009.

Description:-

Settlement is the framework which helps in evaluating the usage of the network access by the end users and to make the financial settlement between the Providers, Go Remote and the Consumers .The basic functionalities of this framework includes validating the Remote Authentication.

Responsibilities:-

• Involved in Design& Development, Coding and various PLSQL validations.

• Development of Re-usable objects like General Procedures, Functions, Packages.

• Create the objects like tables, synonyms, sequences.

• Prepared Unit Test plan.

• Develop Reports for Data Analyze Purpose.

#Project Title: Banking Information System.

Role: PL/SQL Developer.

Environment: Oracle 9i, PL/SQL, Oracle Tools, D2K.

Platform: Windows 2000.

Team Size: 10.

Duration: Feb-2008 to Sep-2009.

Description:-

This project has been designed for fully atomization of Banking Information system. This project mainly deals with managing there types of account such as Saving Account, Current Account and Recurring Deposits. In this project bank is seeking to manage these account through computer based system. Tasks involved in this project are opening the user accounts, recording the account holders transactions, modify, the user records and generating the reports. This project is having three modules. 1. Bank Master Module, 2.Transaction Module, 3.Reports module.

Responsibilities:-

• Designed and developed new packages with Transformation Logic.

• Create the Triggers, Packages. Procedures and Functions.

• Load the data from flat files into oracle using SQL*LOADER.

• Involved in Synonyms and partitions creation.

• Involved in unit testing.

Personal Information:-

Name : LAVANYA

Date of birth : 16-may-1986

Nationality : Indian

Languages Known : English, Hindi and Telugu

Marital Status : Married

Permanent Address : H.No:2-2-6-51, balaji Nagar, santhoosh nagar,

Kurnool (Dist).

Andhra Pradesh -518004.

Mobile No.:+91-829*******.

Contact this candidate