Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Marriottsville, MD, 21104
Posted:
June 23, 2017

Contact this candidate

Resume:

Padmaja Charasala

PHONE: 240-***-****

Status: US Citizen

ac0y78@r.postjobfree.com

Summary:

10+ years of industry experience in the area of software Testing (Manual/Automation) with a solid understanding of the Test Planning, Test Design, Test Execution and Defect Reporting & Tracking on Web, Client-Server and GUI Applications. Over 2 years of Experience in ETL Testing, using Informatica.

PROFESSIONAL EXPERIENCE

Expertise in Understanding and Analyzing Test Requirements, Tracking changes and maintenance of Test Requirements.

Well acquainted with all phases of SDLC and STLC.

Proficient in Test Automation using Selenium WebDriver with TestNG framework.

Strong Experience in Java programming, Selenium WebDriver, Junit and TestNG.

Well versed with Handing Elements in Selenium WebDriver.

Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations.

Executing Selenium Test Cases and reporting defects.

Experience in data driven Testing, Cross browser testing and parallel test execution using Selenium WebDriver, and TestNG.

Knowledge on LoadRunner Automation tool

Expertise in implementation of Automation framework using TestNG.

Performed Integration Testing, System Testing, Functional Testing, Sanity Testing, Smoke Testing, Regression Testing, User Acceptance Testing(UAT), and 508 Compliance.

Used manual and automated scripts for testing the Application.

Involvement in Test Estimations and Test strategy implementation.

Proficient in testing database of applications developed with SQL Server, Oracle and DB2.

Good understanding of procedures, joins, unions using SQL.

Proficient in devising all the artifacts of testing such as Test Scenarios Test cases, Defect Reports and Test Summary Reports.

Experience in automated using Quick Test Professional (QTP/UFT) and Quality Center/ ALM tools.

Proficient in Functional Testing tool Quick Test Professional (QTP/UFT) and the various frameworks in QTP/UFT.

Working experience on Data driven and Keyword driven frameworks in QTP.

Participated on JMeter to create Thread Groups and test Web Application for various loads on key business scenarios.

Participated Design/Develop Load Testing Test Plan & Tested Performance Testing using Load Runner.

Good understanding of the Agile/SCRUM, Waterfall SDLC (Software Development Life Cycle), methodologies and analysis of business, functional and technical requirements.

Good understanding of views, procedures, joins, unions using SQL.

Excellent analytical and logical programming skills with a good understanding at conceptual level.

Highly motivated with excellent communication skills.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP/7/10, MS Dos, UNIX

Languages: VB, SQL, PL/SQL, DB2, UNIX Shell Scripting

Automation Testing Tools: Selenium, JMeter, QTP, UFT, Load Runner

Framework Tools: Junit and TestNG

Test management Tools: QC, ALM, JIRA

Bug Reporting: BugZilla, Rational ClearQuest, Rally

Methodologies: Agile / Scrum, Waterfall, V-Model testing

Version Control tools: TFS, CVS, VSS, SVN, Git

Databases: SQL Server 2005/2008, Oracle, IBM DB2 11

Data Warehouse Tools: Informatica 9.x, BI

Database Tools: SQL Server Management Studio, TOAD

Web Design: Java, C#, .Net, ASP.NET, JavaScript and VB Script, Eclipse IDE

App Servers: BEA Web logic, IIS

MS Office: MS Word, Excel and PowerPoint

EDUCATION

Master of Science Major: Mathematics, Nagarjuna University, AP, India

Diploma in Computer Applications, AP, India

SECURITY CLEARNCE

SF 85 Public Trust Clearance.

PROFESSIONAL EXPERIENCE

DOL (Department of Labor, Washington D.C. /ETA) Jan’14 – Present

Sr. Automation Test Engineer

Industry: Government

The mission of the Employment and Training Administration (ETA) is to contribute to the more efficient functioning of the U.S. labor market by providing high quality job training, employment, labor market information, and income maintenance services primarily through state and local workforce development systems.

Responsibilities:

Preparation of the Test Strategy and guiding the team.

Involvement in the System test Plan preparation and Requirements Streamlining.

Involvement in preparation of Test Procedures, Test Scenarios, Cases and test data.

Responsible for GUI and Functional Testing, using Black box testing Techniques.

Involvement in Test Execution, Results Analyzing and Defect Reporting.

Involvement in RTM preparation.

Developed automation scripts for new enhancements using Selenium and TestNG.

Designed Automation Test cases using Selenium WebDriver, Java, TestNG.

Used Java language and TestNG framework for scripting. Used Maven for building the WebDriver project.

Integrated with Continuous Integration tools TestNG for running test on time basis automatically.

Responsible for implementation of Hybrid Test Automation Framework, Page Object Model using Selenium.

Extensively used Selenium locators like ( Fire Bug, Fire path locator) and WebDriver.

Participated scenario based testing for the JMeter scripts.

Participated schedule and run the scenarios using JMeter and generate necessary graphs.

Participated on JMeter to create Thread Groups and test Web Application for various loads on key business scenarios.

Connected to database to Query the database using SQL for data verification and validation.

Reported software defects in JIRA and interacted with the developers to resolve technical issues.

Validated the customer account records and their order details with Databases using SQL Queries.

Extensively used Page Objects design and page navigation framework for readable test script and easy.

Performed back end testing on Oracle Database by writing SQL queries.

Used JIRA to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developed developers to track and resolve the problems.

Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT.

Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues. Involved in Test Reporting on daily/ weekly basis through company prescribed format.

Environment: Java, Selenium WebDriver, JMeter, Test NG, Maven, Eclipse, Jenkins, Fire path, Firebug, HTML, Agile, JIRA, Oracle.

DOL (Department of Labor, Washington D.C./Energy) Jun’12 – Jan’14

Sr. ETL Tester

Industry: Government

ECS is a Web based case management application used by staff in the OWCP Division of Energy Employees Occupational Illness Compensation (DEEOIC) to process claims submitted by employees of the Department of Energy (DOE), its contractors and subcontractors, and their survivors. The main goal of ECS is to provide DEEOIC users the ability to enter claim forms, determine claimant eligibility, and make payments to eligible claimants.

Responsibilities:

SCRUM testing team lead responsible for creating release test plan.

Developed test plans and build scenarios work flows according to the user requirements.

Provide the testing Estimations for the User stories for the Release.

Created and executed test cases based on test strategy and test plans based on ETL mapping.

Involved in conducting the Functional, Regression and Integration testing.

Extensive experience in testing DB2 and SQL server databases, involved in testing back end jobs using SQL queries.

Created test cases for testing the project, ensures that the components of the system successfully integrate and function together.

Executed manual test scripts analyzed the results & reported bugs using JIRA.

Performed regression testing- backend programs, Data warehouse ETL Informatica Mappings and update processes.

Helped the System test lead in developing the Test Plan and Testing Strategy for DWH ETL/BI.

Validated BI Reports and Universes against Data Warehouse database by writing SQL Queries.

Preparation of the test data scenario/request for the functional testing.

Validations are done to Data Extraction logic, validate data loading

Test end to end data flow from source to target.

Involved in SCD Type 1 and SCD Type 2 testing.

Check for accuracy, completeness (missing data, invalid data) and inconsistencies.

Back-end testing using SQL queries to validate the data in the back-end SQL server database.

Identified bugs and interacted with team lead and developers to resolve the bugs.

Environment: ETL Informatica 9, BI reports, SQL server 2008, DB2, Java, UNIX, JIRA, Windows XP.

CNCS (Corporation for National Community Services, D.C.) Feb’10 – Jun’12

Automation Tester

Industry: Government

My AmeriCorps is an online system designed to automate the enrollment process of AmeriCorps members. It allows applicants search for AmeriCorps opportunity, apply for AC program, become a member, education award tracking. Staff users and sponsors can access the portal, view member information, approve the applicants/members and track slots.

E-Grants is an online system designed to automate the entire grants and project management process from application to closeout. It allows applicants to find funding opportunities, apply for grants and projects, and manage grant reporting online. The system also allows the Corporation to review applications, award grants, and manage those grants and projects efficiently and effectively.

Responsibilities:

Performed System Testing, Functional Testing, Sanity Testing, Regression Testing and Usability Testing. Used manual and automated scripts for testing the Application.

Actively Involved in Software Development Life Cycle and Test Life Cycle, Test strategies, Methodologies and processes.

Used ALM to prepare test cases, procedures, requirement traceability matrix and managing the defects as per the business requirements.

Created recovery files using Recovery Scenario Manager, associated the recovery scenarios to tests to instruct QTP with specified trigger action on unexpected event/popup.

Involved in maintaining and uploading the QTP Scripts to ALM (Application Life Cycle Management).

Involved in performing functional, system, usability, ad-hoc, regression and user acceptance testing.

Working knowledge of using QTP Scripts with Standard, Text, Bitmap, Table Checkpoints and Synchronization points.

Designed and developed automation test scripts using Quick Test Professional and managed testing activities using ALM.

Design and Implementation of the Automation framework, formulating the driver script and the requisites

Designed functions library, functions, subroutines, common functions, utility functions, regular expressions and environmental variables using QTP in VB scripts.

Executed automated test scripts, analyzed the results and reported bugs in ALM.

Modified and executed automated and manual test scripts for different modules using QTP.

Followed a hybrid framework to adopt key word driven, data-driven and script modularity methods.

Created repeatable user defined functions and stored them as function libraries (.vbs files)

Required to use Descriptive Programming at certain situations to complete the scripts.

Created recovery files using Recovery Scenario Manager, associated the recovery scenarios to tests to instruct QTP with specified trigger action on unexpected event/popup.

Involved in maintaining and uploading the QTP Scripts to ALM.

Web service testing using SOAPUI for WSDL and REST

Environment: J2EE, Oracle 10g, XML, Oracle Application Web Server, CVS, Test Director, Windows NT/2000/2003, Java, JavaScript, Quality Center, ALM, Quick Test Pro, Load Runner, MS Office, PL/SQL developer, Bugzilla, 508 Compliance JAWS.

Client:Hospital and Health system Association of Pennsylvania(HAP) Dec’07-Feb’10

Software Quality Assurance Engineer

Industry: Healthcare

The Hospital and Healthsystem Association of Pennsylvania (HAP) is a statewide membership services organization in Harrisburg, Pennsylvania, that advocates for nearly 250 Pennsylvania acute and specialty care, primary care, subacute care, long-term care, home health, and hospice providers, as well as the patients and communities they serve. HAP is part of the Pennsylvania Health Care Quality Alliance.

Responsibilities:

Involved in writing Test plan and wrote Test Cases as per Business Requirements.

Experienced in gathering business requirement, creating functional detail documents, technical detail documents and understanding scope of project.

Applied commonly principles, concepts, and methodologies, operating characteristics and capabilities of systems, media, equipment, and related software systems, processes and procedures.

Used Rational ClearQuest to access the requirements, test cases/use cases for execution of test cases and to maintain defects.

Performed various testing like Sanity, Functional, System test, Integration, Regression, End-to-End, and UAT.

Developed SQL Queries to verify the data inserted from the GUI in database tables.

Experience in reviewing business requirement specifications, software requirement specifications, unit test cases and system test cases.

The tests were created to test for back-end (DB2).

Conducting Test Plan Design Meetings with the Integration QA team, to discuss and analyze the user requirements and tasks and to answer questions on how the Integration team should build their test scripts.

Used Unix commands and scripts to move files into different locations in unix platform.

Performed software installation, upgrades, troubleshooting on UNIX servers.

Executed Unix shell scripts and SQL queries for interface data loads and verification.

Environment: Java, J2EE, DB2 11, UNIX, IBM Rational ClearQuest



Contact this candidate