Resume

Sign in

Test Cases Sql Server

Location:
Elk Grove Village, Illinois, 60007, United States
Salary:
100000
Posted:
May 31, 2017

Contact this candidate

Professional Summary

* ***** ** ** ********** in Analysis, Design, development, testing and Implementation of ETL & Business Intelligence solutions using DWH, ETL, OLAP, Client/Server applications in domains like Banking, Insurance.

Experienced in RDBMS technologies like Oracle, DB2, MS SQL Server, Excel and MYSQL.

Involved in every aspect of SDLC and extensively followed AGILE (scrum) and WATER FALL methodologies.

Experienced in developing Business Intelligence Applications using Business Objects and Crystal Reports.

Well experienced in Functional testing, UI testing, testing Lifecycle and test architecture

Worked with ETL tools like Informatica Power Center 8.x/9.x, Ab Initio 3X.

Have solid experience on database query tools such as TOAD, Teradata SQL Assistant and SQL Plus.

Experienced in writing design specific and supporting documents for QA projects.

Experienced in testing Enterprise wide apps resided on multiple databases like ORACLE, DB2, and MS ACCESS.

Experienced in conducting walkthrough meetings with the Business Leaders, Analysts, SMEs and DEV team to get a clear understanding of the business and the applications being used in house.

Experienced in business requirements analysis, reviewing test Plans & preparation of test Cases.

Experienced in working with HP Quality Center/ALM 11.0, CLM, JIRA and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.

EDUCATION

Master of Science in Management Information Systems - May 2012 (Eastern Michigan University, Ypsilanti, MI)

Bachelor of Technology - May 2009 (Acharya Nagarjuna University, India)

Technical Skills

ETL Tools : Informatica 9.x/8.x, Abinitio3.x

Testing Tools : ALM11.0, Quality Center, QTP, JIRA, Selenium, Cucumber, Jenkins, GIT, Git Hub, Soap UI

Databases : Oracle /10g/11g, SQL Server 2005, MySQL, DB2, TOAD 8.5, MS Access, Teradata

Reporting Tools : Business Objects 5.1/XIR2, Cognos 8.0

Operating Systems : Windows XP, Linux and UNIX (AIX).

Languages : HTML, SQL, Java, python, VB script, C++, PHP

Scheduling tools : AutoSys, ESP, Control-M, Oozie, Cisco Tidal

Hadoop ecosystem : sqoop, Solr, Hive

Professional Experience

Senior ETL QA Analyst (Volkswagen Group of America, Inc.) Feb 2017 - Current

Environment: Informatica, DB2, SQL developer, Selenium WebDriver, QTP, OBIEE, ALM, SQL, UNIX, ALM QC, Git, Github, Jenkins, Business Objects

Duties:

Involved in gathering, documenting and verifying business requirements.

Developed/Maintained Automation Test Scripts in GIT.

Developed Jenkins jobs using Maven/Ant build tools for maintaining regression test suits.

Involved in defect discussions and root cause analysis, to provide more information to development team.

Performed User Acceptance Test on the application by interacting with the end-users.

Extensively used SQL scripts, Developed CI/CD for ETL related code migrations

Responsible for testing all new and existing ETL Data Warehouse components

Create the reports in SAP Business Intelligence systems by using measures and dimensions in Web intelligence tool and validate the data present in the report against the underlying database.

Involved in writing Test scenarios, positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and documenting the test results

Automated manual test cases using Apex and Selenium.

Coordinate, analyze and resolution of technical issues with scrum master, developer and reporting manager in a timely manner.

Reviewed extensive SQL Queries with complex multi-table joins and nested queries.

Involved in Unit testing, and debugging. Used Jira as defect-tracking tool to keep track of defects during the testing process.

IT QA Analyst (Bank of the West) Feb 2014 – Jan 2017

Environment: ALM/HP QC, Informatica, SQL, QTP, TOAD, UNIX, Oracle, Tidal scheduler, SQL server,

Duties:

Participated in knowledge transfer/ Issue Resolution sessions with Business/Dev leads

Developed test plans, test scenarios, test cases, test data and test scripts for different types of testing activities

Performed execution of test cases, test scripts, captures test results, test metrics and reports them.

Identified and tracking of system defects, performed root cause analysis of the defects and works with the development team to resolve them.

Created automation scripts using QTP, Executed and Analyzed test results.

Interacted with test leads and architects to develop and establish Quality Assurance standards and best practices

Performed Black Box testing of different applications and products for multiple projects

Provided guidance for Test Planning and Test Execution along with defect root cause Analysis and reporting

Build and execute data masking algorithms to ensure data privacy in reference data

Performed test automation utilizing testing tools such as HP Quality Center/Application Lifecycle Management, HP Quick Test Professional

Prepared the Test Plan and Testing Strategies for Data Warehousing Application.

Performed white box, grey box testing of applications and products for multiple projects.

Developed procedures, templates and work instructions for implementing Quality Assurance best practices and testing standards.

Extensively used UNIX environment to mock the data files, and execute ETL mappings from the backend

Executed data refresh routines, on need basis, prepare and share periodic status reports

Overall monitoring of the testing progress, reporting test results and defects detected

Validated the source data coming from various databases using complex SQL queries.

Once the QA life cycle is completed, prepared Test Results and Test finding documents and uploaded them to SharePoint

Scheduled and ran multiple test jobs through UNIX, Tidal scheduler

Software Engineer (IT America, Inc.) Sep 2013 – Dec 2013

Environment: Ab-initio, DB2, SQL developer, Selenium WebDriver, QTP, OBIEE, ALM, SQL, UNIX, JIRA

Duties:

Developed and Designed Test Cases based on the Business Rules and Mapping Documents.

Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.

Testing internal file transfer applications, also tested Web Services graphs using Soap UI to make sure whether proper response is being generated to the incoming requests or not.

Identifying the test Cases that can automate and used Selenium Grid to perform the same.

Validated the data transformation from XML/dat files are being loaded into the testing area as expected.

Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE

Aggregated the data at source and compared with the Target to validate Transformations.

Documented and reported various bugs during the Testing process.

Test automation for web application using Cucumber.

Attended daily status call with Offshore/Onshore leads to review assigned tasks and solve any impediments.

Resolving performance related issues by fixing/modifying unwanted joins/clauses in complex SQL queries.

Updating status of the testing to QA managers and updating assigned work status to the Project Management team regularly thru applications like JIRA.

Data Architect/ Analyst (State Farm) Aug 2012 – Sep 2013

Environment: ETL, Quality Center, Oracle, QTP, SQL Server, Windows XP, TOAD

Duties:

Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)

As part of Agile process, involved in daily stand-ups, sprint reviews, sprint-planning sessions, Story grooming sessions and assisted Scrum Master in producing burn down charts.

Analyze business, and all other data processing problems for electronic data processing systems app

Performed Integration Testing of different modules. Tested user interface inconsistency and apps functionality.

Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases

Running test scripts, logging and tracking defects using Quality Center.

Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.

Generate complex reports using Cognos application.

Preparation of test data for various levels of testing, loading new/modified data into back-end databases.

Validated the source data coming from various databases like oracle, db2 etc using complex SQL queries.

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Designed and developed UNIX shell scripts as part of the ETL process.

Graduate Assistant (EASTERN MICHIGAN UNIVERISTY) Aug 2010 –Apr 2012

Environment: MS Visio, HMTL, JavaScript, python, SQL Server 2000, T-SQL, UNIX and Windows NT

Duties:

Developed a web-based project for EMU Community College Relations using Java, JSP, XML, XSL, and Java Script.

Used MS Visio to develop and design test databases, involved in creation of test tables, writing stored procedures and Triggers, Performed Data Profiling to improve search abilities by using tags and aliases.

Maintenance of database for office records on students.

Extensively involved in developing data dictionaries also created test tables and various database objects.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.



Contact this candidate