Aparna Dubhakula

EXPERIENCE SUMMARY:

Over * years of Professional experience in Information Technology with extensive experience in performing manual, Data warehouse and automated testing of client- server and web applications for major companies worldwide.

Experienced in Design, Development and System Testing & Implementing product with zero defects.

Experience in working in white box, black box and gray box testing.

Excellent team player to work in conjunction with team of testers, developers and BA members in testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

Expertise in analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.

Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System Testing.

Experience in writing Test Cases for ETL to compare Source and Target database systems.

Proficient in Manual, Database Testing and exposure to Automation Testing with ability to manage, record and play functions based on the automation needs.

Experienced in different phases of Software development Life cycle including Strategic Systems Planning Designing, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support

Good expertise in the review and documentation of system test plans, creating and executing test scripts, test cases and data sets on the basis of product release features requirements and technical documents

Experience in using Automation testing Tools Quick Test Professional (QTP), and Microsoft Visual Studio and TFS.

Ability to interact with developers and product analysts regarding Testing Status and Defect & Change Tracking using Quality Center.

Extensive experience in bug tracking tools like Rational Clear Quest and Quality Center.

Excellent logical and analytical abilities for understanding and developing system workflows, computing and verifying Software Metrics and well suited for communicating with both technical and non-technical professionals

Expert in Manual Testing and Automated Testing applications developed on windows Environment.

Good knowledge of identifying various test scenarios. Holds strong ability to handle multiple tasks and prioritize it.

Experienced in working with software development team in resolving defects, presenting the defect status reports, resolving requirement.

Execution of Manual Test Scripts and responsible to track and log the defects using Quality Center.

Strong analytical, communication & documentation skills.

Exceptional ability to quickly master new concepts, very co-operative team player, fluent communicational skills, and interpersonal skills, innovative and self-motivated.

TECHNICAL SKILLS:

Operating Systems : Windows 7, 98, 2000, XP, VISTA, UNIX

Testing Tools : Application Lifecycle Management, Quick Test Professional 10.0, Quality Center

Databases : MS-SQL Server, Teradata, oracel

ETL Tools : Cognos 10, Informatica 9.1,

Languages : C, SQL, PL/SQL, SAS, XML, VB, Mainframes

Applications : Web Based, Client/Server

Miscellaneous : MS Outlook, MS-Office Suite and Visio.

Methodologies : Waterfall, Software Development Life Cycle (SDLC), Agile

Defect Tracking Tools : Bugzilla, Test Director, Quality Center

EDUCATION:

Bachelors of Engineering, Osmania University, India.

PROFESSIONAL EXPERIENCE:

Client: UNITED HEALTH GROUP, Eden Prairie, MN Jun’14 – Till Date

Role: ETL QA Analyst

United Health Care is the leading single largest health care provider in the US. STARS Management program is aimed at improving Medicare Star Ratings. Medicare Star Ratings is a government pay –for-performance program for Medicare Advantage and Part D prescription drug plans. The centers for Medicare & Medicaid Services ( CMS ) uses Star Ratings as an indicator of how well we serve Medicare beneficiaries, especially by improving health outcomes and closing gaps in care. Higher Star Ratings provide greater reimbursement from CMS, which allows United Health Care to offer innovative solutions and better benefits for consumers who purchase Medicare health and prescription drug plans.

Responsibilities:

Setup Testing Suite for the project.

Create and maintain folder structure in ALM ( Application Lifecycle Management ).

Participated in talent acquisition and resource management on the QA team

Created Test Plan and Test Strategy documents for the project.

Written Test Cases for ETL to compare Source and Target database systems.

Responsible for training the project team and Users on required tools.

Worked with the Subject Matter Experts to understand and analyze impacts of various data acquisitions.

Responsible for reviewing Use cases with the Business Analysts and align the test scenarios accordingly.

Reviewed Test Cases prepared by other QA team members.

Created the reporting module in ALM to reflect test progress, defect tracking etc.

Created test scripts for database and report testing.

Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.

Performed cubes validation for reporting based on the technical specifications document.

Reviewed test scripts ( SQL ) and assisted the team on test script tuning.

Co-ordinated testing activities between onsite and offshore teams for handshakes on a day to day basis.

Conducted Defect Triage calls to review and track down defects for each release.

Responsible for leading efforts on UAT and to coordinate between the Users and the Design / Development teams on issues during UAT.

Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.

Worked with the project teams on process improvements.

Responsible for reporting status of various testing activities to the Management.

Responsible for creating and maintaining QA documents on SharePoint for the project.

Facilitate QA meetings with the business and source owners to mitigate risks and resolve issues.

Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.

Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Provided Testing sign off documents for various deployments on the project on an as needed basis.

Environment: Informatica 9.1, SSIS, Teradata TD 12, SQL Server 2008, Cognos 10, Flat Files, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management ( ALM 11 ), QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Ascent Technologies, Hyderabad INDIA July 11 – August 2013

Client: Citibank, USA

QA Analyst

Citi Private Bank provides banking and investment services to high net worth individuals, private institutions, and law firms. Acting as a gateway to all of Citigroup's products, Citi Private Bank offer traditional investment products and alternative choices, with all clients assigned a Private Banker to personally deal with their portfolio. Project One Provide Private bank customers with a consolidated view of their portfolio across product lines, regions and accounts, Allow relationship managers, product managers and management to get a unified view of their clients,Lead the market in information aggregation and client reporting.

Responsibilities:

Analyzing and Understand the software Requirement Specifications and development of Test Scenarios.

Involved in Test Case Preparation and Test Case Execution Manually.

Successfully implemented HP ALM ( Quality Center 11 ) for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.

Performed white box testing on various front end applications.

Analyzed application to find out which part can be automated and which can be manually tested.

Performed black box on application while making sure all functionality got implemented as written in the functional specifications.

Created Test Cases and scenarios for Unit, Regression, Integration as well as Back –end and System testing.

Performed Positive and Negative testing using valid and Invalid data on Development, Test Database Environments on MS Access and SQL Server.

Performed web services testing manually.

Validated web applications against XMLs as part of testing.

Interacted with developers, users and management to speed up the defect resolution.

Wrote SQL statements to extract data from Tables.

Performed front end and back end validations using SQL.

Defect tracking and reporting using Quality Center.

Determining the Entry and Exit Criteria for different phases in testing cycle of the application.

Database Validation (SQL) to check the updated data in the Database using Toad (Data Query Tool).

Performed User Acceptance Testing on behalf of End Users at client’s environment.

Participated in Project Meetings, Conducted Knowledge Sharing Sessions and Training to End Users

Environment: Quick Test Professional 10.0, Oracle database, Quality Center 9.2, Windows 2000,SQL, VB Script, HTML, MS Excel, XML, MS SQL SERVER.

Contact this candidate