Test Cases Sql

Himaja Chowdary Jampani *********@*****.***

QA Analyst 248-***-****

PROFESSIONAL SUMMARY:

Around 1 year of IT experience in Quality Assurance and Manual testing, worked as ETL Tester and QA Analyst.

Extensive experience in Analysing Functional Specifications and developing Test plans, Test cases, Test estimation, execution of Test scenarios, analysing the Test results and Defect Management.

Experience in all stages of software development life cycle.

Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.

Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.

Expertise in designing the test scenarios and scripting the test cases to test the application.

Good understanding in the concepts of Data modelling, slowly changing dimensions, Star schema & snow flake schema and Business process testing, Data analysis and experience in testing the reports.

Extensively used SQL, PL/SQL to create complex queries, SQL override, Stored Procedures, Triggers, and Autosys.

Performed risk analysis, monitored testing progress and ensured the timely completion of testing consistent with corporation requirements and update management about the status of all assigned tasks.

Experience in using SQL Queries to make sure that data was entered properly in the right tables, when the data was entered from front end screen

Database Testing on Oracle Database- including creating SQL queries, manipulating test data.

Defect Tracking and Reporting Using Jira.

Good at multi-tasking and working well under tight deadlines with high efficiency

Good analytical and problem-solving skills. Able to quickly adapt to new environments and learn new technologies

Educational Summary:

Governors State University, Chicago GPA: 3.9/4

Master of Science in Computer Science May 2017

Related course work: Information Security, Advance Java, Advance Database Concepts, Internet Programming, Advance Operating Systems, Planning Management

St. Mary’s group of institution, Guntur, India GPA: 3.3/4

Bachelor of Technology in Computer Science and Engineering April 2015

Related course work: Java, Operating Systems, Web Technologies, Data Structures, Database Management System, Unix, Computer Organization, Software Engineering

Technical Skills:

Testing Tools : Jira

ETL Tools : Informatic

Databases : Oracle, SQL Server, My Sql, Hive

Other Tools : Toad, WinSCP, Sql workbench, pl/sql developer

Automation Tools : Autosys, Cucumber

Version Control : SVN

Platforms : Windows, Mac, Unix

PROFESSIONAL EXPERIENCE:

Fannie-Mae Jun’17– Till date

12000 Sunrise Valley Drive, Reston, Va

QA Analyst

Responsibilities:

Create detailed, comprehensive and well-structured test plans, test cases and test Strategy based on the detailed Business requirements and supporting technical specifications.

Estimate, prioritize, plan and coordinate testing activities.

Created Feature File Scenario Outline with Cucumber framework and wrote Acceptance test using BDD.

Design, develop and execute ruby automation specs using cucumber.

Create team specific agile process flow in JIRA to move tasks from one activity to another.

Writing and execution of complex SQL queries for back end data validation.

Using Toad to interact with Oracle Database for SQL execution.

Using autosys jobs to run Informatica ETL jobs on UNIX operating system and monitor the same.

Configuring, using, and managing test environments and test data.

Find defects and log them on to defect tracking tool Jira with appropriate details.

Work directly with the developer to fix the defects and validate it.

Create Jobs in Jenkins for Sanity, Regression test suites.

Ensuring the appropriate testing tasks is scheduled during release and iteration planning.

Actively collaborating with developers and business stakeholders to clarify requirements, especially in terms of testability, consistency, and completeness.

Participating proactively in daily standup meetings, story grooming sessions, team retrospectives, suggesting and implementing improvements.

Coaching other team members in relevant aspects of testing.

Environment: Informatica Power center 10, TOAD, Cucumber, Oracle PL/SQL, Jira, SQL, MS Outlook, MYSQL, MS Office, Windows 10, Autosys, Teradata, Unix, WinSCP, Putty.

Icore Infotech, India Jul 2015- Dec 2015

Manual Tester

Responsibilities:

• Involved in testing effort estimation of the task allocation.

• Developed Test Plan, Test Cases, Test Scripts based on the Functional Requirements specification and prepared the Validation Progress Reports.

• Written complex SQL queries for validating the data.

• Reviewed the test cases, test scripts and prepared test data for test scripts.

• Analysed the results and reported the issues using Mantis.

• Performed web service testing using SOAP UI.

• Performed XML schema validation using XML editor.

• Verified the back-end processing of batch jobs & data using SQL Server.

• Reporting bugs and Follow up with the development team for bug resolution using Mantis.

• Preparation of Load Testing Scripts using VUGen.

• Execution of scripts for different scenarios Controller.

• Analysis of load test results using LR analysis & Preparation of Load test report.

• Trained the team members on the functional aspects of the project.

• Provided Testing Status to management and conduct follow up calls with concerned departments to resolve any outstanding bug resolution related issues.

Environment: TOAD, SQL, Linux, Load Runner, XML Editor, SQL Server, T-SQL, Ms Excel, XML, Soap UI.

Contact this candidate