Data Warehouse Quality Assurance

Sundeep Mavillapalli

Sr. ETL / Data Warehouse Testing Consultant

Phone: 913-***-****

E-mail: *******.**@*****.***

SUMMARY

ETL / Data Warehouse Tester with around 14 Plus years of experience in software testing and quality assurance on client/server and web based applications.

Comprehensive Experience in Business Process of Health care, Pharma (FDA Regulated), Logistics and Manufacturing.

Proficient in Software Development Life Cycle (SDLC) with strong experience in both waterfall and agile methodologies.

Expertise in analyzing business requirements, technical requirements and high level design documents for all the projects.

Experienced in performing the GUI, functional, Automation and database testing.

Developed and Maintained Automation Test Scripts for Functional and Regression Testing for Web Based and Client server applications.

Worked on validations for different FACETS modules such as Providers, Claims and membership.

Good knowledge in writing Test Plan, Test Cases, Test Scenarios, Executing Test cases and Documenting Test Results and creating Traceability Matrices.

Created the test cases per the requirements/client change requests and experience in conducting and managing Smoke, Functional, Integration, System, and Regression, Data base on the testing applications and Involved in the client User acceptance testing.

Developed and executed various test scripts using Selenium IDE, Web Driver, and JUnit by using Data driven, Keyword driven and Hybrid framework for automated testing of various functionalities.

Experienced on writing the SQL Queries to extract the data from various source tables to perform database testing.

Involvement in Cross-Browser testing of applications on Internet explorer, Safari, Fire fox and

Google chrome.

Ability to identify problems, analyze test results, and investigating their cause and suggesting remedies.

Hands on expertise on Bug Tracking Tools such as Quality Center, JIRA and TFS.

TECHNICAL SKILLS

Databases

Query Surge, SQL Server (2014), MS access (2013), Data studio (Ver 4.1.2)

Operating systems

Windows XP, 7, 8, Mac

Web Technologies

HTML,CSS,XML

Browsers

Mozilla Firefox, Opera, IE 7.0,8.0,Chrome,Safari

Testing Tools

VSTS, HP Quality Center, Selinium, Winruner, QTP

Testing frame works

JUnit, TestNG and Soap UI

QA Methodology

Agile & Waterfall

Testing Skills

Unit Testing, Integration Testing, System Testing, Regression Testing,User Acceptance Testing, Sanity Testing, Performance Testing.

Project Tools

MS (Word, Excel, Visio, PowerPoint, Outlook)

EDUCATION

Bachelor’s degree in Computer Science & Engineering from JNTU University – India – 2008

Masters in (Managing Information Technology) – University of Salford (UK) – (2008-2010)

BCBS, Kansas City, MO Mar 2019 – Till Date

Leading Health Insurance Company

Role: ETL / Automation Testing Consultant

Responsibilities

Identifies appropriate sources of data for testing that meets the BCBS business requirements.

Performed End to End testing for the ETL Load process including testing incoming file format, Loading Staging tables, Business rules implementation, Matching Criteria, Data Cleansing, Data Load to final tables and Reports generation.

Prepared and implemented detailed test plan for the complex health care reports which included Quantitative (Data Testing) and Qualitative (Business Rules Implementation) testing.

Tested the BCBS application for web functionality, and verified the online modules for broken links.

Performed SQL validation to verify the data extracts and record counts in the database tables.

Developed the test scenarios in visual Studio Team Services (VSTS) related to the Health care and claims processing.

Worked on Microsoft SQL Server (2014) and MS Access (2013) to run the queries and accessing the database.

Responsible for full testing life cycle, system testing and validating the Data mappings.

Wrote SQL Queries to verify the data is extracted correctly according to the mapping documents.

Worked on creating the test cases to cover the data movement between source to target.

Extensively worked on the user interface (UI) testing to ensure validate the system upgrades in BCBS portal.

Responsible for testing EDI transactions such as claims (837), claim payments (835), membership enrollment (834) and billing.

Developed Automation Test Scripts using Selenium IDE, Selenium web driver and TestNG

Involved in Execution of Test Scripts using Selenium web driver, TestNG Framework

Functions.

Worked on various types of testing: Functional, regression, performance, integrated and production validation.

Used VSTS (Visual Studio Team Services) as the Defect Tracking tool to log the defects while testing is in progress.

Daily participation in meetings (Agile Methodology) to discuss for testing status updates, project test estimates and test cases review.

Interacted with developers & project team members to discuss and resolve defects and their priorities.

Performed Data validation to verify the data extracts and record counts in the database tables.

Supporting and coordinating with offshore team to work with any open defects.

TTI, Anderson, SC Jan 2017 – Feb 2019

TTI is a distributor of passive, interconnect and electromechanical components.

Role: ETL / Automation Testing Consultant

Responsibilities

Review business requirements, functional specifications and gathering application knowledge from business analysts, designers and developers to identify and understand the project needs.

Extensively involved in interfacing and communicating with the business analysts to come up with efficient test plans and test cases.

Participation in the requirements discussion with the client and analyzed the BRD and preparation of Query logs.

Reviewing and modifying the test cases as per the changes and participated in Test Environment Setup.

Responsible for Smoke, Functional, Integration, System, Regression and User Acceptance testing and escalate bugs discovered during testing into the defect tracking system and track them until they are closed.

Regression tested the application to make sure that existing functionalities are not impacted by the changes on the Staging Server.

Worked closely with software developers to help the troubleshoot defects and Communicating client on daily basis regarding bugs clarification and enhancements.

Responsible for Automation Feasibility Analysis of the Test Cases suitable for automation and analysis of Service orders, Quote Processing.

Participated in Defect related meetings with developers to validate the severity of the defect and responsible for tracking of the Defect.

Developed Automation Test Scripts using Selenium IDE, Selenium web driver and TestNG.

Involved in Execution of Test Scripts using Selenium web driver, TestNG Framework functions when needed.

Review posted Defects by team members and Help developers in creating scenarios in QA environment.

Involved in preparation of Functional Requirement Traceability Matrix documents required for the project standards

Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.

Act as single point of contact between development team and testing team for iterations, testing and development activities.

Sanofi Genzyme, MA Aug 2015 – Dec 2016

World’s leading Biotechnology Company

Role: ETL / QA Testing Consultant

Responsibilities:

Actively participated in User Story Review meetings and identified the key Test Scenarios.

Attended Daily Scrum meetings to assess the testing progress and review the accomplishments, targets and understand the issues.

Designed Comprehensive Test Plans, Detailed Test Cases & Test Scenarios to test the applications from an end to end perspective and collected the required test data.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.

Executed tests and documented the test results and reported the encountered issues and tracked them until they were resolved.

Following the Release Notes delivered with the build validated the implemented requirements, re-tested the resolved defects and performed extensive regression testing.

Reported defects and played active role in defects triage and discussed issues with cross functional teams.

Used extensively Quality Center for comprehensive Test Management and automated functional regression.

Responsible for testing claims and billing process in the facets application.

Conducted various tests like Business Functionality, Integration, Browser Compatibility, Database, System, End to End and Regression Testing.

Worked with both onsite and offshore teams and also had the responsibility of updating the management about the day-to-day status.

UPS, Atlanta, GA Nov 2013 - Jul 2015

World’s largest transportation and Logistics services

Role: Sr. QA ETL Testing Consultant

Responsibilities:

Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases.

Participated in system walkthrough and inspection meetings to understand the business rules and system operation flows.

Created and updated test scenarios, test plans, and test cases according to use case and design.

Used Agile methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards

Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.

Developed SQL Queries/test scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.

Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.

Validated ETL reports based on Functional Requirements.

Extracted data from various sources like Oracle, flat files and SQL Server.

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security

Written test cases to test the application manually in HP Quality Center

Defects identified in testing environment where communicated to the developers for quick fix.

Shire Pharma, PA Jan 2013 – Oct 2013

Leader in research-based biopharmaceutical company.

Role: ETL / Automation testing consultant

Responsibilities:

Involved in quality assurance phase planning, coordination and implementation of QA

Strategy for overall project.

Developed complex SQL queries for data validation to verify the ETL Mapping rules.

Extensively tested the reports for data accuracy and universe related errors.

Experience developing test automation frameworks and test suites using tools such as Junit,

SOAP UI.

Execution of SOAP UI Test Cases and reporting defects.

Performed unit testing using JUnit to help development to reduce their bandwidth.

Experience in developing, Implementing Test Strategies, Test Plans, Test Cases, Test Scripts,

Test Configurations, Test Schedules and Test Documentation.

Worked in a fast paced agile environment with highly collaborative and dynamic work env.

Creating and logging the defects in JIRA.

Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.

Extensively used LeanKit, Jira, Rally Dev and TeamForge for tracking the User Stories and

Defects.

Involved in identifying the automation test cases.

Developed automation test scripts using Java.

Executed the test cases using Selenium Web Driver.

Defect reporting and tracking with JIRA.

Used firebug to locate web elements using XPath, ID, Name and CSS.

Test Case execution using TestNG/Junit and Maven which is a build tool.

Used Maven Sure-fire report plug-in to generate HTML page to store results.

Attended the standup meetings to discuss on bug fixes and to know the functionality and flow of the new applications.

Federal Mogul Inc., South Bend, Indiana Nov 2011 – Dec 2012

Federal-Mogul Corporation is a global manufacturer and supplier of powertrain components and vehicle safety products.

Role: Sr. QA Testing Consultant

Responsibilities:

Understand business requirements and functional design documents related to new enhancements.

Worked closely with Business Analysts and Developers to fill the gaps in the requirements.

Reviewed Business Requirement Documents and the Technical Specification and Stream lined all testing activities, Requirements, Test Plans, Test Suites, Traceability and defect tracking using Quality Center.

Wrote the manual test cases for testing the functionality of the applications initial builds.

Prepared test plan and test cases using HP Quality Center based on the function specifications.

Enhanced the test scripts by parameterization, adding user-defined functions, conditional statements and comments.

Wrote SQL queries to perform Data Validation followed by the manual testing of database.

Prepared daily/weekly and final testing report of the whole application.

Participated in the bug review meetings, updated requirement document as per business user feedback and change in functionality of the application.

Coordinated meetings and walkthroughs with the management team to ensure steady progress.

Cardinal Health, OH Jan 2011 – Oct 2011

Cardinal Health is a Health care Services company and a distributor for pharmacy and medical products.

Role: ETL/SQL QA Testing Consultant

Responsibilities:

Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases.

Participated in system walkthrough and inspection meetings to understand the business rules and system operation flows

Created and updated test scenarios, test plans, and test cases according to use case and design.

Used Agile methodology (Scrum) to ensure the new features meet the customer requirements and acceptable quality assurance standards

Participated in standup meetings, prepared reports and other supportive documentation to contribute to establishment of standards and procedures for software testing.

Developed Manual test scripts for different test scenarios covering all aspects of project functionality. Involved in performing GUI, Functional, System and Regression Testing

Performed Root Cause Analysis for all the assigned issues for existing functionality such as (Corrupted Data, Code Error)

Executed test cases, recorded results and documented defects, questionable functions, as well as inconsistencies in software program functions, outputs, online screens and content

Executed test cases using HP Quality center tool.

Wrote SQL Query to extract data from various database tables for testing purpose

Validated tests by crosschecking data in backend on SQL server using SQL Queries

Assisted client in User Acceptance Test (UAT) including creating Test Plan, generating test data, designing test cases, preparing test environment and executing test

Worked closely with users and program developers to ensure application development meets the user expectations.

References: Provided upon request

Contact this candidate