Developer Sql

VIJAYALAKSHMI R Dubai E-mail:

*****.******@*****.***

Phone: 971-*********

Seeking challenging, rewarding position in the field of Software-IT/Oracle

Certified with a growth oriented organization of repute

Work Experience

Around 8 Years of experience in Software-IT in different domains mostly in

Telecommunications, Retail etc. Main responsibilities include development,

test and support in the mentioned areas: DWH, CRM(SIEBEL), Billing Systems,

Data Migration, Oracle Deployments, Test Lead, CTI/IVR, Integration

testing, ICS.

Synopsis

o 8 Years of experience in Oracle SQL, PL/SQL.

o 4 years of experience on Requirement Analysis, Design, Development in

Oracle (Oracle D2k forms 6i, Reports 6i), Testing & UAT support in

Hyderabad, India.

o 2 Years in Data Cleansing and Data Migration from In-house Systems to

Target Systems(like BSCS, SIEBEL, Staging/Intermediate).

o 1.5 years of experience as Test Lead/ Test Consultant and also involved

in System integration Testing (SIT), Factory Acceptance Testing (FAT),

Site Acceptance Testing (SAT), production support and Oracle deployment

in Retail domain in Minneapolis, USA.

o 1.5 years of Experience in White box Testing, Black Box Testing, System

Integration Testing (SIT) using Agile Methodology in Telecom domain on

different applications like BSCS, CTI/IVR Testing, Web testing, DWH

(Informatica and business objects), IN, ICS, SIEBEL CRM and QTP tool in

Dubai, UAE.

o 2 years of experience in DWH: ETL testing (Informatica) and Business

Objects (BO) desktop Intelligence testing.

o Extensive experience in end-to-end execution of projects.

o Possess excellent communication, interpersonal, analytical, problem-

solving and organisational skills.

Educational Credentials

o B.E. (Information Technology) from Bellary Engineering College,

Vishweswaraiah Technological University (VTU), India, 2004.

Skill set

o Software Packages: SQL, PL/SQL, Forms 6i, Oracle 8i database, Oracle 9i

database, Oracle 10g database, Data Migration Methodologies, UNIX shell

scripting, Reports 6i, MySQL, Telecom Order Management - Wireless,

DWH(Data Warehousing in Informatica), Business Objects.

o Domains worked on: Telecom (Telecom Order/fulfilment Management, BSCS,

ICS, CRM, IN, DWH), Retails- Distribution, CBCM(Etisalat Inhouse system)

o Tools: SQL*Loader, TOAD, Form Builder (Oracle 6i), Reports 6i, CR Tool,

Test Director, PL/SQL Developer, SQL Developer, QTP (Quick Test

Professional), Load runner, Informatica, Business Objects, Knowledge on

Selenium.

Certifications & Honours

o Oracle Certified Associate (OCA) in Jan 2007

o Entitled as Star of the Month for may 2006 in Tata Consultancy Services

for the efforts put in delivering crucial projects

Key Result Areas

Oracle Developer/ Oracle Consultant

> Involved in Requirements gathering for projects and Change requests

> Estimating timelines for huge projects and Change requests.

> Carrying out impact analysis and design for the business requirements.

> Development of the code to meet customer requirements

> Unit Testing of the code

> Deployment and data migration.

> Initial Operations support till the system is stabilized.

Tester

> Test various applications on different domains like Telecom and

Retail.

> Identifying Defects/bugs during the System integration Testing (SIT),

Factory Acceptance Testing (FAT), Site Acceptance Testing (SAT) and

take steps to follow up with the relevant teams for bug fix.

Test Lead

> Estimate timelines for test execution of various Projects/Change

Requests

> Follow up on the testing progress from the team members.

> Prepare Build Verification Test (BVT) and Check list

> Bug tracking and reporting using Defect Management Tools

> Send status of testing of various projects to clients

> Attend client meetings and co-ordinate with internal team members

Production Support

> Operations support in retail domain for different distribution centres

involving automation

Deployments/Release Management

> Involved in Oracle deployments which includes oracle, Unix and Java

scripts.

Organisational Experience

Jan'12 - Ongoing Etisalat Telecom, Dubai, UAE Data Migration

Engineer/Oracle Developer

Key Contributions

> Analysing the data in source systems to be migrated.

> Involving in Data Cleansing activities in CBCM to ensure data to be

migrated will meet the Data Quality requirements.

> Development of the extraction & migration scripts from In-house built

source system to Staging Systems, SIEBEL CRM and BSCS systems.

> Unit testing of the migrated data.

> Performance tuning of the migration scripts to meet the required

timelines.

> Design & development on the database for the transition period over

the different phases of the project. This database basically will

keep the status of the subscribers and will be used to route to the

correct system where the ownership of the subscriber is.

Main Project handled

Etisalat is the leading Telecom operator in UAE. Working in Data Migration

project which involves Data Cleansing and migrating/Extracting the data

from In-house source System (CBCM) to the SIEBEL CRM & BSCS systems.

Product Experience

TOAD, Test Director, PL/SQL Developer, SQL Developer, UNIX, EIM tool.

Nov'09 - Mar'11 Du Telecom, Dubai, UAE Test Engineer/ Test

Consultant

Key Contributions

> Involved in Writing Test Scenarios, Test Cases and loading the same in

Quality Center.

> Involved in System Integration Testing (SIT) of various applications

on different applications like Billing system (BSCS), Collection

Management, IN, DWH, Reports using Business Objects, web testing, CRM

in Telecom domain.

> Identifying Defects/bugs during the System integration testing and

take steps to follow up with the relevant teams for bug fix.

Main Project handled

o Du Telecom, Dubai: Du is one of the leading Telecoms in UAE. Working

in different applications like BSCS, DWH, ICS, SIEBEL CRM, CTI/IVR etc

Product Experience

o Billing system BSCS

o SIEBEL CRM used for customer management and landline services

o DWH Informatica for data loading

o CTI/IVR testing

o Reports using Business Objects

o IN - Intelligent network used for Prepaid systems

o ICS- Collection management for credit control and fraud management

o QTP tool for regression and sanity testing.

o Involved in functional testing.

o TOAD, CR Tool, Test Director, PL/SQL Developer, SQL Developer, QTP

(Quick Test Professional), UNIX.

Aug'09 - Oct'09 Tata Tele Services (TTSL), Hyderabad, India Oracle

Consultant/ Developer

Key Contributions

> Involved in Requirements gathering for projects and Change requests

> Estimating timelines for huge projects and Change requests.

> Carrying out impact analysis and design for the business requirements.

> Development of the code to meet customer requirements

> Unit Testing of the code.

> Review code written by Developers.

> Performance tuning of the existing code by rewriting and tuning of

the queries.

> Initial Operations support till the system is stabilized.

Main Projects handled

o IN Prepaid: Involved in Writing new code for IN Prepaid systems using

SQL, PL/SQL, Unix

o Performance tuning of the existing code by rewriting and tuning the

queries.

Product Experience

o TOAD, CR Tool, Test Director, PL/SQL Developer, SQL Developer, QTP

(Quick Test Professional), UNIX.

May'08 - Jul'09 Target, Minneapolis, USA Test Lead/Production Support/

Oracle Deployments

Key Contributions

> Estimate timelines for test execution of various Projects/Change Requests

> Follow up on the testing progress from the team members.

> Send status of testing of various projects to clients

> Attend client meetings and co-ordinate with internal team members

> Involved in real time SIT (System Integration Testing) & also provided

UAT (User Acceptance Testing), FAT (Factory Acceptance Testing, SAT (Site

Acceptance Testing) support.

> Operations support in retail domain for different distribution centres

involving automation in receiving, Warehousing and Shipping

> Involved in Oracle patch deployments which includes oracle, UNIX and Java

scripts.

> SQL, PL/SQL coding.

Main Project handled

o Target, Minneapolis, USA- Involved in automation of Receiving,

Warehousing and Shipping of the cartons or totes. Worked as a Test

Lead as well as involved in Patch deployments. Often interact with

clients and co ordinate between clients and team for testing related

tasks.

o Involved in Unix shell scripting & writing SQL, PL/SQL code.

Product Experience

o Retail Distribution in automation in Receiving, Warehousing and

Shipping

May'05-May'08 Tata Tele Services (TTSL), Hyderabad, India

Oracle Consultant/ Developer

Key Contributions

> Involved in Requirements gathering for projects and Change requests

> Estimating timelines for huge projects and Change requests.

> Carrying out impact analysis and design for the business requirements.

> Development of the code to meet customer requirements

> Unit Testing of the code

> Deployment and data migration.

> Initial Operations support till the system is stabilized.

Main Projects handled

o POS (Point Of Sale) to EPOS(Electronic Point Of Sale) Data Migration:

Includes Data Migration of It includes:

o 140+ Screens/Forms

o 2000+ Program Units & Data Blocks

o 510 Stored Procedures

o 1200+ Tables & 120+ DB Triggers

o 30+ Data Interfaces to 10+ Systems (Online & Batch)

o Business validations extracted in Order Entry alone - 840+

o POS Application Development & Operations Support: Point Of Sale (POS)

is an in house developed Order Management Solution for Tata Tele

Services Limited. The modules involved are as follows:

o Telephone Number Inventory

o Deposit Collection Management

o Credit Rating System

o Order Fulfillment

o Installation Management

Product Experience

o TOAD, Form Builder (Oracle 6i), Reports 6i, CR Tool, Test Director,

PL/SQL Developer, SQL Developer, MYSQL, QTP (Quick Test Professional),

Informatica, Business Objects.

Personal Details

Date of Birth : 4th May, 1982

Languages : English, Hindi, Telugu, Tamil, Kannada, Urdu (Manageable),

Malayalam (Manageable)

Passport No. : G7456034

Visa Status : Dependent Residence Visa (Husband Sponsorship)

Contact this candidate