Manager Sql Server
Resume:
**********@*****.***
Aruna Makala
QA Analyst
PROFESSIONAL SUMMARY
Over 8 years of IT experience as a Quality Analyst in Manual, Automation and backend
Testing. IT experience ranges Health Insurance, Telecom and Auto Insurance with strong
functional knowledge. Experience in the Software Development Life Cycle (SDLC) using
the Waterfall Model and Agile Methodology.
Experienced in preparing Test Strategy, Test Planning, creating test data and building
automation framework using soapUI and QTP.
Expertise in creation and execution test cases using Quality Center, Rational Manual
Tester.
Implemented Agile and Waterfall methodologies and participated in sprint planning and
daily scrum meetings and defect Triage meetings.
Performed various kinds of Black-Box/White Box testing like User Interface testing,
Functional Testing, Integration, Regression testing, Security, compatibility, web services
and backend testing.
Experienced in analyzing the requirements and communicating the testability of the
requirements to the Business Analysts, thus helping them in providing testable
requirements to the project team.
Performed Back end Testing-using SQL queries, generating reports to ensure data
integrity and validate the inserted and updated data.
Experienced in developing test cases by understanding and working with Use Cases.
Implemented test Scripts and ran the test cases in UAT environment.
Used HP Quality Center and Rational Manual Tester for writing and executing test cases.
Experienced in data base testing using MS SQL Server and Oracle.
Experienced in understanding WSDL, schemas and Testing Web Services.
Created Test Suites, Test Cases, Data Driven tests and prepared text execution results
reports using soapUI.
Participated in various reviews and meetings with the development team.
Strong experience in documenting existing process, analyzing business requirements,
working with requirements traceability matrix, re-engineering business processes and
designing.
Experienced in testing application in Windows, MAC OSX and UNIX environments.
Experienced in compatibility testing using IE, Mozilla Firefox, Google Chrome and Safari.
Experienced in testing web based applications based on Java and .NET frameworks.
Experienced in planning, executing, monitoring, analyzing and documenting of all testing
related activities.
Ability to handle multiple tasks and work independently as well as in a team.
Ability to meet deadlines and handle pressure coordinating multiple tasks in project.
Team player and self-starter with excellent communication, coordination, documentation
practices which proven to coordinate with team to get efficient results and also capable to
adopt and learn new tools, techniques and approaches.
TECHNICAL SKILLS
Automation Tools : Win Runner, QTP 11, Test Director, Rational Clear Quest,
Rational
Clear Case, Transact-SQL, Quality Center 11, soapUI 4.5
Defect Tracking Tools : JIRA, Rational Clear Quest, HP Quality Center, Rational Team
Concert, Bugzilla
Agile Tool : Rally, TFS
Databases/Tools : MS SQL Server, Oracle, Transact-SQL, TOAD and SQL Developer
Languages : Java, SQL, PL/SQL
Web Technologies : HTML, XML, Java, VB Script, Java Script, ASP, .Net, Visual
Studio.
Operating Systems : Windows, Sun-Solaris, UNIX, Linux, MAC OSX
Utility Tools : MS Project, MS Office, MS Visio
PROFESSIONAL EXPERIENCE:
Interstate Batteries, Dallas TX May14 to Nov14
To Purpose of this project is to give the Distributors the ability to view, sort, edit and print their
recommendations by sales parts, Dealers and various other filters to give the distributors a way to
capture the RSM assignment and activity. And Tracking Master Specification is to be able to measure
the success of the different recommendations and execution of those recommendations.
Environment/Technologies: Windows XP, Micro Strategy, Integrity manager, Informatica, Oracle,
SQL Developer, Microsoft .Net, XML, Test Case Migrator, Microsoft Test Manager, Microsoft Outlook,
Visual Studio, WebEx live meeting, Microsoft Scheduler, SharePoint 2010, Quality Center 11.0, TFS
and Web Services.
Environment/Technologies: Windows XP, Micro Strategy, Informatica, Oracle, SQL Developer,Test
Case Migrator, Microsoft Test Manager, Visual Studio, Microsoft Scheduler, SharePoint 2010, Quality
Center 11.0, TFS and Web Services.
Responsibilities:
Sprint planning, Backlog review, Sprint Review, Sprint Retrospect, Daily Scrum.
Created Manual Test Plans and Test Cases for testing of windows desktop, Web, and
mobile .Net applications.
Created SQL queries and SQL stored procedures to test the ETL Process in the target
database against the source tables.
Worked with TFS to create the Test plans and Test cases and logged defects to management
life cycle of testing.
Worked with Business users to gather requirements for developing reports and dashboards
using Microstrategy BI tool.
Assisted users on running the dashboards and helped with understand the functionality of the
reports.
Co-ordinated with development team to understand the datasets and the reports to write the
test cases and SQL queries to testing the reports.
Blue Cross Blue Shield of Texas (HCSC), Richardson TX Oct 11 to April 14
HCSC Blue Cross Blue Shield is a health insurance company. Healthcare ON/OFF exchange 2014
implementation for IL, TX, NM, OK and MT divisions.
Environment: QTP, SoapUI, VB Script, MS SQL Server 2008, XML, Quality Center 11, Rational Clear
Quest 8.0, Rational Team Concert, web services
Responsibilities:
Implemented Agile/Scrum methodology.
Worked closely with Actuaries to understand the semantics as how to come up with factors after
analyzing the hundreds of claims data containing billions of records.
Configured different types of factors for generating rates.
Designed and developed Test scripts using soapUI and validated rates for different plans.
Used Quality Center for creating Test Plans, Requirements, Test Cases, Reporting defects and
generated reports.
Performed Functional, Smoke, Usability, System Testing, Regression Testing of FMA, RFRF and
RVA web applications.
Prepared the traceability matrix and mapped the requirements to the test cases.
Prepared soapUI test suite, test cases and validated soapUI responses using assertions.
Responsible for identifying testing risks, dependencies by elaborating the testing assumptions,
and developing mitigation procedures, contingencies.
Performed database validation using Toad for Oracle database.
Extensively wrote SQL Queries to verify that the data is populated from the Database matches
with the front end screens.
**********@*****.***
Involved in compatibility testing using different browsers and operating systems.
Involved in testing mobile web applications and apps testing in apple (IPhones and Tablets) and
android (Touch screen) devices.
Involved in set of activities from monitoring and troubleshooting mobile application, content and
services on real handsets.
Involved in verification and validation of hardware devices and software applications.
Generated performance comparison charts and documents with each build release.
Executing daily automation scripts and generating defect reports using RTC and Quality Center.
Involved in defect Triage meetings and daily testing touch point meetings.
Chase, Chicago IL Jan 08 to Aug 11
The purpose of the project is to consolidate all warehouses into a unified warehouse. Data is reported
differently, with varying levels of accuracy, and with significant duplication of effort. The goal of this
initiative is to create a unified repository of data for all applications that require warehouse and
tracking data spanning multiple systems. The consolidation will reduce inconsistencies in reporting,
better define sources for specific data sources, and improve data quality. The environment consists of
.NET applications along with java script. Applications are Web based TCP/IP and UDP running in a
custom framework. The architecture consists of Windows 2000 Server, IIS6.0, and Actuate Reporting
Server; People soft, SQL Server, and ORACLE.
Environment: JAVA, J2EE, Web Sphere, Visual studio, VB Script, MS SQL Server 2000, DB2, VC++,
Oracle, .NET, HTML, DHTML, Unix, XML, Quality Center.
Responsibilities:
Analyzed wireframes and stories and performed sanity testing.
Implemented Agile/Scrum methodology.
Extensively involved in developing use cases for UAT.
Developed scripts based test cases and use cases to automate the execution process for running
the reports and cubes.
Proactively communicating ideas and process and being productive within a complex project.
Test Result evaluation, documentation, and reporting in UAT environment.
Testing status reporting.
Defining entrance and exit criteria.
Determining test resource needs and needs to Build Test Environment.
Identifying risks, dependencies, mitigations and contingencies.
Identifying test tools and/or automation techniques.
Involved in preparing System and Acceptance Test plan.
Involved in writing various test cases for System, Implementation and Acceptance Tests.
Reviewed test cases, test data prepared by the testing team.
Involved in documenting the test log and test defects.
Involved in creating requirements for environmental set up for various types of testing.
Identified Automation and manual test scenarios.
Extensively used SQL queries for validating data using SQL Server.
Prepared test execution reports and defect reports.
Interacted with team members to identify and resolve technical issues.
Aetna Health Insurance Co, Hartford CT Feb 07 to Dec 07
Claims Management System (CMS) is an enterprise wide system to process and disburse payments
to healthcare professionals/providers and also manage the clients claim history. The system allows
healthcare providers to submit claims via a multitude of options like manually by mail, or electronically
from their billing systems and also by fax/email services.
Environment: FACETS, Rational Manual Tester, Test Manager, Clear Quest, HIPAA.
Responsibilities:
Responsible for reviewing the Business Requirements and Design specifications
for clarity and testability.
Responsible for communicating the need of testing resources to project managers and requested
dedicated environments/data for testing.
Responsible for designing the Test strategy in UAT.
Responsible for developing Test Inventory Coverage Matrix to ensure that the test cases
encompass all the business/functional requirements.
Responsible for developing test scripts for automation using Rational Robot/Rational Functional
Tester.
Responsible for execution of Test Cases.
Responsible for capturing the test metrics and develop status reports on test execution coverage
for the management.
Responsible for tracking of defects using Rational Clear Quest.
Responsible for the defect management by following up with the concerned parties on the
resolution and implementing the fixes based on priority and severity.
Analyzed and translated the business requirement documents into test scenarios.
Created Test Cases and modified existing test cases in Rational Manual Tester.
Created extensive Data Driven Test scripts for reading data from Data Pool.
Interfaced with developers to resolve technical issues and investigated software faults.
Cablevision, long island NY Mar 06 to Dec 07
The Enterprise Data warehouse project(HR and Billing) for cablevision will focus on the design,
construction and implementation of an enterprise data warehouse (EDW) that will include a data
warehouse environment consisting of a populated staging area, an enterprise data repository, subject
area data marts, enterprise metadata repository and design of appropriate governance processes and
organizational changes. The enterprise reporting tool of this data ware house is Cognos tool.
Environment: JAVA, Mainframes, J2EE, Web Sphere, VB Script, MS SQL Server 2000, DB2, VC++,
Oracle, .NET, HTML, DHTML, Unix, XML, Jira.
Responsibilities:
Analyzed business requirements and system specifications to understand the application.
Participated in requirements gathering meetings.
Prepared Test Strategy, Test plan, Test Scenarios and Test Cases as per the requirements.
Responsible for execution of Test Cases.
Responsible for capturing the test metrics and develop status reports on test execution coverage
for the management.
Responsible for tracking of defects using Rational Clear Quest.
Responsible for the defect management by following up with the concerned parties on the
resolution and implementing the fixes based on priority and severity.
Responsible for documentation of the results by updating the test logs.
As the test lead, responsible for monitoring of all testing related tasks and coordinating the testing
team activities.
Used Clear Case tool for revision controlling by working on snapshot views.
Responsible for identifying testing risks, dependencies by elaborating the testing assumptions,
and developing mitigation procedures, contingencies.
Prepared test execution and defect analysis reports.
Perform backend testing using SQL Server.
Involved in Integration testing of various different modules.
Attending meetings with QA Team, Development Team and Project Management Team.
Responsible for documentation of the results by updating the test logs.
As the test lead, responsible for monitoring of all testing related tasks and coordinating the testing
team activities
Contact this candidate