SUMMARY

• 7 years of professional experience in test cases, test scripts and defect management.
• Excellent experience with ALM/Quality Center modules Test Plan, Test Lab and Defects.
• Excellent experience with SQL queries involving DDL, DML, Join and Set Operators.
• Experience with relational databases Oracle, Teradata and SQL Server and DB2.
• Experience with data warehouse concepts like Normalization, De - normalization, ETL and data models.
• Excellent experience with ETL tools Informatica Power Center and IBM Data Stage.
• Experience with BI report tools Cognos, Business Objects and Micro Strategy.
• Experience with database tool like TOAD, SQL Assistant, SQL Server Management Studio, CDBS Studio, SQL Developer, SQL Plus, SQL Developer, WinSQL
• Experience with test and defect execution reports and defect life cycle in Quality Center.
• Experience with ETL job execution, monitoring and job logs.
• Experience with testing BI dashboards and reports Drill Down and Cross-Tab.
• Experience with UNIX basic commands and advanced tools like grep, cut and awk.
• Experience with creating and manipulating files in UNIX vi editor.
• Experience with validating database tables against delimited flat files.
• Experience with data marts and data models Star and Snow-Flake schemas.
• Experience with Teradata utilities bteq, fastload, multiload, fastexport and SQL Assistant.
• Experienced with testing Hadoop and big data using Hive SQL queries.
• Experience with Requirement Traceability Matrix (RTM) in Quality Center.
• Experience with PL/SQL functions, procedures, cursors, variables and parameters.
• Experience with Microsoft Office tools Excel, Access, PPT, Word Outlook and Project.
• Excellent experience with Smoke, System, Integration, Regression and User Acceptance Testing.
• Self-motivated with strong interpersonal, written/oral communication skills and capable of working independently as well as in a team

TECHNICAL SKILLS

Operating Systems: Window XP/Vista, Linux, UNIX

Languages: SQL, PL/SQL, T-SQL, C

Databases: Oracle, Teradata, SQL Server, DB2

Utility tools: Toad, SQL Assistant, SQL Server Management Studio, CDBS StudioBteq, Multiload, Fastload, SQL Plus, WinSQL, SQL Loader, SQL Developer

ETL Tools: Informatica Power Center, Data Stage

Reporting Tools: Cognos, Business Objects, Micro Strategy

Defect Tracking Tools: ALM, Quality Center, Jira, Clear Quest

MS Office: Excel, Outlook, Access, Word, PPT, Project

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. QA Analyst

Responsibilities:

• Attended regular meetings with the team on Overview, Architecture and project plans.
• Developed test cases for validating Business Objects reports.
• Developed test cases, test scripts and validated data for different test cases.
• Worked on projects with source and target data in different databases and environments.
• Worked with BA for change requests and enhancements.
• Prepared test cases and SQL queries for validating ETL mappings.
• Worked with Informatica Power Center Workflow Manager to run the sessions and workflows.
• Worked with Informatica Power Center Workflow Monitor to monitor workflow status.
• Reviewed session log files in Informatica workflow monitor.
• Compared Teradata targets against Oracle source using CDBS Studio.
• Experienced with Teradata utilities SQL Assistant and Bteq.
• Used Toad for Oracle to prepare test scripts and execute them.
• Worked with complex SQL queries involving JOINS, Sub Queries and Set Operators.
• Validated Business Objects reports like Drilldown and Cross-Tab reports.
• Tested cosmetics in Business Objects reports like font, color and headers.
• Tested Business Objects reports like Summary, Detailed reports and dashboards.
• Executed test cases in Quality Center and created test execution reports.
• Created, managed and closed defects in Quality Center.
• Experienced with testing Hadoop big data using Hive SQL queries.
• Used Hive SQL queries to pull list of partitions and data from Hadoop table.
• Used CDBS Studio tool for connecting different databases systems and comparing data.
• Experienced with NoSQL database Mark Logic.
• Validated Hadoop tables against source files using HiveQL.
• Used PL/SQL functions in SQL queries for validation of test cases.
• Experienced with complex SQL queries and PL/SQL functions and procedures.
• Experienced with requirement Traceability matrix (RTM) in Quality Center.
• Automated test cases in Quick Test Professional (QTP).
• Executed test cases from QTP for several iterations.
• Used Jira for creating defects and managing defect life cycle.
• Created weekly defect reports from Jira tracking tool.
• Tested Golden Gates replication from Oracle to Teradata tables.
• Used fastload and multiload for loading data from flat files to Teradata database.
• Worked with ETL developers and Data Architects to resolve the defects in QA environment.
• Used Rally tool for agile methodology and user story mapping.
• Created User Stories and estimated story points for QA user stories in Rally.
• Submitted Weekly defect reports from ALM to project management.
• Attended and represented the QA team in test review sessions.
• Assisted in validating production initial and incremental loads.
• Worked in an agile environment attending daily scrums and weekly meetings.
• Actively participated in agile daily scrums and sending out weekly status updates.

Environment: Oracle 11g, Teradata, Informatica 9.1, SQL, TOAD 10.5/11.0, HP Quality Center 10.0/HP ALM 11.0, QTP, Jira, Golden Gate, Business Objects, SQL Assistant, Hadoop, Hive, Rally, PL/SQL, CDBS Studio, big data, Mark Logic, MS Office, Unix, Windows, Putty, WinSCP, Share Point.

Confidential, Denver, CO

ETL QA Analyst

Responsibilities:

• Represented the QA team by providing all QA progress/updates to the project team.
• Created complex SQL scripts from scratch for testing ETL tables and Reports.
• Worked on Reporting Projects using Cognos and validated them against the Teradata database data.
• Analyzed and understood functional specifications and business rules associated with different projects.
• Developed test plans and test cases for functional testing based on the functional requirement documents.
• Used Data stage Director for executing ETL jobs.
• Used Data stage Director for monitoring ETL job status and reviewing log files.
• Written complex SQL queries to test fact and dimension tables.
• Performed smoke testing to ensure the stability of different QA environments.
• Performed regression testing, negative testing and assisted in UAT testing.
• Used Clear Quest for bug tracking and reporting, also followed up with development team to verify bug fixes and update bug status.
• Developed and executed SQL queries in WinSQL for testing DB2 database tables.
• Validated data quality in DB2 source tables using SQL queries.
• Written and executed complex SQL queries for validating ETL and BI test cases.
• Documented all Test cases, test scripts and test execution results in Quality Center.
• Raised defects in Quality Center and assigned to Developer for fixing and retested them after being fixed.
• Worked in an AGILE Environment with daily status updates and bi-weekly sprints.
• Tested Cognos reports using complex SQL queries.
• Tested cosmetics in Cognos reports like font, size and color.
• Used Quality Center for documenting test cases and test scripts.
• Executed test cases and created defect in Quality Center.
• Submitted Weekly test execution and defect reports to project team.

Environment: Teradata, SQL Server, DB2, Clear Quest, Windows 7, SQL PL, Putty, Data stage 8.7, Cognos, SQL Assistant, WinSQL, MS Office

Confidential, Dallas, TX

ETL / BI Tester

Responsibilities:

• Worked on multiple projects each running parallel with the other and with tight deadlines.
• Worked on both Data Migration and Data Integration projects.
• Worked in an AGILE environment attending daily scrums and weekly QA meetings.
• Provided status updates to the QA Manager and Project Managers on a daily basis.
• Worked with huge databases and different types of input data including data coming from different databases, reports and flat files.
• Performed System, Integration, Regression and UAT testing for various ETL jobs.
• Worked with testing tools like TOAD for Oracle in an Oracle environment.
• Worked individually along with an ETL Developer for defect management and data migration.
• Created Test Plan, Test Cases and Test Scripts for all the projects I worked on.
• Used SQL to build all queries to test databases, dashboards and reports in Cognos.
• Raised and managed defects and Issues in Quality Center.
• Worked on projects with hardly any documentation to projects with extensive documentation.
• Used Informatica Power Center Workflow Manager to run the workflows.
• Used Informatica Power Center Workflow Monitor to monitor workflow status.
• Tested and ran Informatica Batch processes prior to data validation.
• Used UNIX commands in Putty to access flat files and test them.
• Used TOAD for Data Analysts to compare flat file data to data in the database.
• Used AQT to compare results of 2 different queries in the same database.
• Used indexes and hints to fasten query run time for large data.
• Created DB Links to connect 2 different databases and query them.

Environment: Oracle 10g/11g, TOAD 9.0, AQT, Quality Center, IE 8, Windows 7, SQL, Putty, Informatica 9.0, MS Excel, MS Word, MS Outlook, MS Lync.

Confidential, Irving, TX

ETL/QA SQL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Created test data for testing specific Membership functionality.
• Used Informatica Power Center Workflow Manager for executing sessions and workflows.
• Used Informatica Workflow Monitor for monitoring the status of sessions and workflows.
• Reviewed session and workflow log files in Informatica Power Center Workflow Monitor.
• Extraction of test data from tables and loading of data into SQL tables.
• Compared data between Oracle and Teradata for validating ETL jobs.
• Validated Drilldown and Crosstab reports developed by Micro Strategy.
• Tested the Micro Strategy report data by querying backend database using SQL queries.
• Used Micro Strategy Integrity Manager for comparing reports between heterogeneous databases.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Developed automated Test Scripts using QTP.
• Used data conversion to protect the data and prevent data loss.
• Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access.
• Created macros to automate the process of refreshing the data in MS Access.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.

Environment: Informatica 8.1/7.1, Informix, DB2, Java, Micro Strategy, SQL, SQL Server 2000/2005, Teradata V2R6, Teradata SQL Assistant 7.0, XML, XSLT, XML Spy 2008, UNIX, Shell Scripting, Unix, Quality Center 8.2

Confidential

QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• 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 Quality Center and automated using Quick Test Pro.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Creating test cases for ETL mappings and design documents for production support.
• Effectively communicate testing activities and findings in oral and written formats.

Environment: UNIX Shell Scripting, Oracle, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Mercury Test Director 6.5, QTP 7.2, SQL *Loader, Cognos 7.0 Series,Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, PL/SQL