Engineer Sql Server

[pic]

Bavani Soma

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

***- ***- ****

Visa Status: US Citizen

SUMMARY

13+ years of experience in designing and managing complex, high

value IT projects focusing on delivering within quality standards,

deadlines and budgets.

Wide variety of hands-on experience with Test/QA and Development

Methodologies

Test/QA Project work includes Scoping and Estimation, Risk

analysis, design, Development & Build management, testing (Automated &

Manual).

Proficient in Defect tracking and managing defect lifecycle

using Quality Center.

Coordinated different teams for different projects on offshore-

onsite model.

EDUCATION & CERTIFICATION

. Masters Degree in Computer Science from Madurai Kamaraj University,

TN, India

. Training in Mercury QTP9.0, WinRunner8.2,

LoadRunner8.0,TestDirector5.0, Quality Center9.0

. Oracle certified PL/SQL developer associate 10 G.

. Certification in Introduction to SOA, Overview of Data Warehouse

Testing, Basics about Usability, Accessibility, Exploratory and

compatibility testing

. Certification in Banking Fundamentals II

. Agile Training - Agile Requirements and Story Writing Workshop

TECHNICAL EXPERTISE

Testing Tools

Functional : QTP 9.0, WinRunner 8.2, SilkTest 6.0,

HP Unified Functional Testing 11.50, Selenium 2.8.0

Performance : LoadRunner8.0

Defect Tracking : TestDirector5.0, Quality Center11 (ALM)

Agile Tool : Rally

Operating Systems : Windows 7, Windows Vista, Windows 2000,

Windows XP, MS-DOS 6.22, Sun Solaris 10

Languages : SQL, PL/SQL, Visual Basic 6.0, C, C++

Databases : Oracle 10g/9i/8i, SQL Server 2008, FoxPro, MS-Access, Sybase,

Teradata

Oracle Tools : Reports 2.5/6i, Forms 4.5 / 6i, SQL* Plus

Oracle Utilities : SQL* Loader, Export and Import

Other Tools : TOAD for Oracle 11.6 and SQL Server 5.7, HTML, MS-Office

2000/2007, Sybase Central 6.01, IBM Cognos Reports

8,Teradata SQL Assistant 13.11, Informatica

PowerCenter 8.6.1, Microsoft Project Standard(MPP),

OpenProj, PARASOFT SOAtest, Oracle SQL Developer

1.5.5, SQL Query Analyzer 8.00, IBM System

iNavigator 6, IBM InfoSphere Data Stage 8.5, WinSCP,

Beyond Compare 3.

Professional Experience

Name of the Company Designation From To Duration

(Months)

Bank of America Senior QA Lead 2012 Till 34 months

Date

Infosys Technical Test Lead 200*-****-** months

GSSR Inc. QA Analyst 200*-****-** months

Impecc Consulting Test Engineer 200*-****-** months

Services

Checktronix India Pvt Quality assurance 200*-****-** months

Limited Engineer

Uniitech Programmer 199*-****-** months

Project profiles

. Sr.QA Lead - Bank of America USA

Mar 2012-Till Date

As a Data warehouse Sr.QA Lead for the BOFA my projects and

responsibilities include

Projects:

1. Fulfillment Data Store (Agile Testing)

2. Default Management Reporting System (FNMA reporting)

3. Single Family Default Monitoring Systems (HUD reporting),

4. Deceased Customer Notification Reporting Systems

5. Home Equity Appeals

Responsibilities:

. Working with the team in Agile Grooming sessions, actively involved

in QA estimates proposals and resource allocations for new

initiatives and small enhancements, attending Daily stand up calls

and update the SIT Test deliverables and testing status.

. Worked on Risk Based Testing.

. Preparing Test plan, Test Scenarios and review them with the

team,Test Data requirement analysis, prepare Test data

document and coordinate with data seeding team, Traceability

Matrix preparation.

. Performing functional testing Schema Validations, Record

count validations, Data validations with the Data

transformation logics for fact tables and dimension tables.

. Running the ETL iShare (Infosphere Data Stage) jobs to load

the data in the target environments

. Meeting the team (SA/DEV/UAT/Offshore) every day to touch

base about the clarifications on requirements and defects.

. Review on SIT deliverables and SIT status.

. File validations on Linux backend system using WinSCP tool,

Infosphere Data Stage jobs validations, Scheduling AutoSys

jobs, run the jobs to load the data from source (Text files,

tables) to Target.

. Executing test cases, preparing defect reports using QC,

conducting defect status meetings, send out the Defect status

report to the team every other day.

. Providing Sign off for SIT.

Environment: Toad for Oracle 11.6,SQL Server 2008, Teradata

(Teradata SQL Assitant), iSeries servers (IBM System i Navigator),Linux, Win SCP, Beyond Compare 3, HP Quality Center 11, Rally,

IBM InfoSphere Data Stage 8.5, Beyond Compare 3, HP Quality Center

11(ALM), OpenProj 1.4, PDWARE iTeam 6.2.

. Technical Test Lead (TTL) - Infosys Ltd

Nov 2009- Mar 2012

As a Technical Test Lead for the Infy my projects and

responsibilities include

Projects:

CapitalOne, Plano, TX

1. Auto finance IVR(interactive voice response) Services

2. Treasury Management Applications

Bank of America, Addison, TX & Broadway, NY

Sep 2010 - May2011

3. Central Services Mortgage Application

4. Marketing Event Measurement (MEM)

5. Campaign History Database (CHDB) and Promo History Database

(PHDB)

6. Marketing Infrastructure (MI)

Citigroup, Long Island City, NY

Feb 2010- August 2010

7. Global Risk Reporting (GRR)

8. Shared National Credits (SNC)

Aetna Global Benefits, Hartford, CT

Nov 2009- Feb 2010

9. Clinical Desktop Application (CDA)

Responsibilities:

. Requirement Analysis.

. Estimate the testing efforts.

. Preparing Test strategy and Data Strategy documents.

. Test Data preparation for various environments.

. Divide the functionality to prepare the Test Scenarios.

. Review the Test Scenarios and Test cases.

. Review the defects and prepare the defect reports.

. Conduct a meeting for testing status and defect status.

. Support Performance testing.

. Creating test file for test the data loading process.

. Writing Traceability Matrix against the requirement

specification.

. Preparing WBS for testing timelines.

. Support the UAT team for testing.

. Providing KT to the offshore team about the BRD and assisting

offshore team for creation of Test Scenarios and Test Scripts

and load them in to QC.

. Assisting offshore team for test execution and defects

logging in QC.

. Running the ETL jobs in Informatica and UNIX.

. Provide sign-off to testing

Environment: HP Quality Center 9.2, MS Excel, Windows XP, S1 online

Business Banking Application PARASOFT SOAtest, Oracle SQL

Developer 1.5.5, SQL Query Analyzer 8.00,

SQL Server 2008, TOAD, SQL, QuickBase, MS Excel, Windows XP, TOAD for

Oracle 10.0, Teradata SQL Assistant 7.1 for Teradata, Informatica

PowerCenter 8.6.1, Microsoft Project Standard (MPP), Mercury Quality

Center 9.0, MS Excel, Windows XP, Sun Solaris 10, HP Quality Center

9.2, MS Excel, Windows XP, Mortgage applications(Visual FoxPro and Dot

net technology), Sybase Central 6.01, TOAD for Oracle 10.0, IBM Cognos

8,Mercury Quality Center 9.0, MS Excel, Windows Vista.

. QA Analyst - GSSR Inc. Mar 2006

- Jun 2009

Projects:

1. Dental Insurance, Boston, MA

2. Health Care System Boston, MA

Responsibilities:

. Involved on testing the new functionalities based on test

cases and coordinated with development team in fixing the

issues.

. After successful release of projects, developed automation

scripts using QTP and integrated the script with master

script.

. Involved in Integration testing for release of updated

modules.

. Involved as part of automation team using QTP, developed test

scripts.

. Tested critical bug fixes including critical fixes and

coordinated with developers in release of bug fixes meeting

tight timeline.

. Involved in Performance testing QA using Loadrunner 8.0.

. Involved in Backend Database testing in Oracle using SQL.

. In the web page testing to finding providers details using

geographical location which stored in the SQL server 2008

Database.

. Capturing customers information whoever requested online

quotes for dental plans for individual or small companies

which stored in the SQL Server 2008 Database.

. Defects were tracked, reviewed, analyzed and compared using

TestDirector.

Environment: TestDirector 8.0, QTP 8.2, Oracle Server, Windows XP,

UNIX, MS Access, MS Office, MS word, Excel, Power Point, QTP9.0,

Oracle9i/10g, SQL Server 2008, TOAD, SQL, Loadrunner8.0, Test

Director, Windows XP.

. Test Engineer - Impecc Consulting Services

July 2004-Feb 2006

Pharmaceutical Formulation Inc., NJ USA

Project:

1. Purchase Information System

Responsibilities:

. Performed Manual Testing on Web Based Application.

. Involved in designing of Test Plans, Test Procedures, Test

Cases, Test Scenarios and Executed Design Steps.

. Developed the Test Cases from the Testing Requirements.

. Worked on tools with TestDirector, GUI Testing, Context

Sensitive and Analog Recording.

Environment: TestDirector 8.0, LoadRunner 8.0, SQL, PL/SQL, UNIX,

Oracle Server, Windows XP, MS Access, MS Office, MS word,

Excel, Power Point

. Quality assurance Engineer - Checktronix India Pvt Limited

Mar 2003- Jun 2004

Project:

1. LENS

Responsibilities:

. Writing Test cases using MS excel for manual testing.

. Writing scripts to filter the input resume which are having

missing details

. The resume, which misses the key details are separated and

made readable format to the system.

. Write manual testing scripts to check the hyperlinks are

working in the aperture system.

. Checking the web page at different browsers

. Writing manual and automating scripts to check employer

credentials and privileges

. Did Regression testing to the different versions of Aperture.

. Writing manual and automating scripts to find the duplicate

candidates.

Environment: SilkTest 6.0, Windows XP, Oracle9i/10g,

TOAD, SQL, MS Excel.

. Programmer - Uniitech

Aug 1999-Aug 2004

Project:

Worked on multiple projects for college student's curriculum using

Visual Basic and Oracle.

Contact this candidate