Engineer Sql Server

Daniel Kondamudi

Phone: 603-***-**** / 603-***-****

Email: ab838g@r.postjobfree.com

SUMMARY

Accomplished Software Quality Assurance professional with 13 years

experience. Responsibilities range from hands on testing to leading

projects and implementing QA process across the organization. Experience in

Enterprise Resource Planning modules, Data warehouse / ETL systems and

Service Oriented Architecture. Domain experience in Health Benefits

management, Insurance, Finance and Human Resource Management. Proficient in

Waterfall, Agile, White box and Black box methodologies. Detail oriented,

excellent interpersonal and time management skills.

TECHNICAL ACCOMPLISHMENTS

I. Developed Test Strategies:

Involved in developing Test Strategies for the projects under test cycle.

Defined the approach and various key factors that would have impact on the

deliverables.

II. Implemented Test Plans:

Developed detailed Test plans, Test Scripts, Traceability Matrix and

expected results. Done Test Plan walkthroughs with Client / business

teams. Implemented Test plans and achieved project goals.

III. Characterized Defects:

Captured and recorded detailed description of defects into defect tracking

tools. Tracked defects, reported trends and followed through resolution

IV. Described Process:

Wrote user guide for defect logging. Also advocated the users for

documentation standards as part of Implementing QA process across the

organization.

V. Managed Projects:

Successfully led projects with implementing test strategies and plans and

worked with on-shore and off-shore teams. Facilitated Triage and Status

meetings and updated senior management with Test matrix.

TECHNICAL SKILLS

Operating Systems Windows 95, 98, 2000, XP, NT4.0 and UNIX

Database Oracle 7.x, 8i, 9i, 10g, SQL Server 2000 and MS

Access 2000

Languages C, SQL, PL/SQL, XML

Tools SQLNavigator3.0/4.0, Toad 8.4, Quality Center 9.0

and RQM.2.0

Automation Test Tools Win Runner 6.0, 7i w/Web Test /QTP 9.1,

Load Runner 6.5

Bug Tracking Tools Rational C Q, Bugzilla, Quality Center 9.0,

10.0 and JIRA 4.0

ERP Oracle HRMS 11.0.2, 11i OAB 9i, 11i, HR

Access

WORK EXPERIENCE

Consultant QA Engineer, Hobbs Madison, Needham, MA

Jan 2012 - Dec 2012

Client: Fidelity Investments, Merrimack, NH

QA Lead, C3 NEXTGEN A&D REPORTING - PWI

QA Lead for the new initiative A&D (Acquisition and Development) Reports

rewrite. Developed Test plan and scenarios and done walkthrough with

business and development teams. Involved in setting up of the test

environment and worked with the development and DBA teams. Conducted defect

Triage meetings with the stakeholders of the project. Provided and updated

management with QA matrix and risk analysis. Worked with Development,

Business and Project management teams in achieving project milestones.

Environment: Oracle 10g, Rapid SQL 8.0, Control M 6.4, Quality Center 10.0

Sr. SQA Consultant, Alexander Technologies, Bedford, NH May

2011 - Dec2011

Client: Long Term Care Partners, Portsmouth, NH

. Analyzed and prepared test plans for pre-open season, open season

functionality for the Long Term Care Insurance business rule changes.

. Done walkthrough of test plans with business team. .

Environment: J2EE, DB2

Lead QA Engineer, New England Carpenters Benefits Funds, Wilmington, MA Oct

2009 - Aug 2010

Wrote test plan for a critical and highly visible project of Phase- I go

live and coordinated data validation of new benefits management system.

Helped end users in using the new defect tracking system and familiarize

them with documentation standards. Took lead in defect resolution process.

Responsible for legacy system (AS/400) tables maintenance.

Environment: AS/400, RQM v.2.0, JIRA 4.0, J2EE

. Developed QA strategy for the new benefits administration system.

Implement QA process across the organization

. Implemented and administered defect management system JIRA 4.0 and helped

the company to stream line the defect resolution process. Wrote JIRA user

guide for users.

Sr. SQA Consultant, Alexander Technologies, Bedford, NH Aug

2008 - Dec 2008

Client: Long Term Care Partners, Portsmouth, NH

Responsible for functional Testing for Pre Open season, Open Season and

post open season Enrollments for Dental and Vision plans. Validated rates

for different plans and programs. Tested different Qualified Life Events

and business rules.

Environment: J2EE, db2,

QA Engineer, SQA Associates

Jan 2008 - Mar 2008

Client: Health Dialog, Bedford, NH

This was an ETL project of Oracle data warehouse with data validation

responsibility in the data warehouse at various points during the data

migration.

Environment: Oracle 10g, Toad 8.4, SQL Server 2000

. Tested PL/SQL procedures, functions and validation of data at different

points in the database and staging the data in staging tables.

. Done analysis and trouble shooting for the missing rows of data.

Responsible for white box testing of the code in the packages on the

Oracle database.

. Wrote complex SQL queries for data validation of data warehouse.

QA Engineer, Veritude, Merrimack, MA

Feb 2003 - Dec 2007

Fixed Income Technology, FMR Co, Merrimack, NH

Designed test plan for functional testing of the MSM (Market Surveillance

Monitor), a Trading systems utility with the new added features in

iterations. Regression tested the builds with QTP scripts.

Environment: .Net, Oracle 9i, QTP 9.1, Squirrel, SQL Server 2005, QC 9.1

Fidelity Brokerage Company Technology (FBCT), Merrimack, NH

Reported the status and conducted triage meetings to track the progress of

the project under test. Oracle data warehouse data validation and compared

FACTS database mapping with the data warehouse data tables.

Environment: .Net, Oracle 9i, Toad 8.4, Rational Clear Quest, SQL Server

2000

Fidelity Investments FESCO Health & Insurance, Merrimack, NH

Net Benefits test for the functionality of Annual Enrollment changes for 5

clients. Responsibility Involves setup of test data in the back end and

also in Net Benefits for AE testing. Prompt Data mining and trouble

shooting for client teams.

Environment: OAB 11.0.2, SQL Navigator 4.0, J2EE, Rational Clear Quest

Fidelity H& I Configuration / Implementation: Done testing of various

components of HOBS (Health and Other Benefits System) like Eligibility,

Electability, Rates, and Life Events etc. Done analysis for defects and

configured quick codes for pension files.

Environment: Quality Center 9.0, Oracle 9i, QC 9.1

Fidelity FESCO H&I Ongoing QA: Worked on the following Projects

Oracle Family Pack H Upgrade

COBRA Regulations changes

Annual Enrollment and

Oracle 9i upgrade.

. Tested various bug fixes, concurrent manager processes, extract

testing, Form validation and Life events testing.

. Tested life events that trigger a COBRA Election Notice, Notice of

Unavailability of Continuation Coverage.

. Test lead for the 2003 H&I (Health and Insurance) Annual Enrollment

for two clients. Designed test plans and test populations to cover

different test scenarios.

. Tested various life events in HOBS (Health and Other Benefits System).

Tested various Single client feed batch processes such as Power mart

Process, Data Load Process, IDB Daily Export Process, IDB Import

process to evaluate the performance.

QA Engineer, PSD Inc., Needham, MA.

Oct 1999 - Dec2002

Client: Fidelity Investments (FESCO, HR/Payroll), Merrimack, NH.

. Responsible for testing client functionality enhancements requests,

bug fixes. Ran Full Payrolls, Assignment set Payrolls for various

clients.

. Tested various payroll processes, roll back of processes, Interfaces

and Reports.

Education

MS, Osmania University, India

Training

Programming in C., University of Massachusetts Lowell, MA

Advanced SQL, New Hampshire Community Technical College, Manchester, NH

Awards

. Veritude: Associate of the Quarter Nominee for Q3, 2006

. FESCO QA Process Excellence - Certificate of Appreciation - Oct 2006

. Fidelity BQA Team: FHRS Annual Enrollment Spot Award - Dec 2006

. Fidelity Investment Management Technology Spot Award - Oct 2007

Contact this candidate