SUMMARY:

• 14 years of experience in Software Testing (3 years Big Data, 10 years ETL) using Agile and Waterfall methodologies.
• 8 years of experience as Test Lead and handled testing teams up to 12 members (onshore and offshore).
• Expert in Data Migration Testing. Handled 4 large data migration projects testing.
• Experience in ETL/Big Data Testing Automation using QuerySurge.
• Expert in writing HQL (Hive) and SQL queries to validate data between different layers.
• Expertise in extended validation of reports developed using Microstrategy and Business Objects by writing HQL/SQL queries at the backend.
• Knowledge of NoSQL (HBase & MongoDB), Pig, MapReduce, Spark, Scala, Zookeeper, Sqoop, Flume, Kafka
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using HQLs/SQLs.
• Experience in preparing & execution of Test Plan & Strategy documents and communication of Test Results (Test Summary Reports, Test Metrics and Bug Documentation) to the Scrum team.
• Experience in Test estimation, Resource estimation & allocation for project testing, preparing and executing the test schedules for different releases of the projects.
• Strong experience of MTM (Microsoft Test Manager), TFS (Team Foundation Server), JIRA and Quality Center; extensively used as Test Management Tools.

TECHNICAL SKILLS:

Big Data: Hadoop - HDFS, Hive, HBase, Pig, MapReduce, Spark, Scala, Zookeeper, Sqoop, Flume, Kafka; Oracle Exadata

RDBMS: Teradata, Netezza, Oracle, SQL Server, MySQL, DB2, Informix

NoSQL: HBase, MongoDB

Programming/Scripting Languages: JSON, XML, Python

Version Control Systems: TFS (Team Foundation Server), SVN, CVS, VSS, Team City

Tools & Software: QuerySurge (for ETL Automation), DataStage, Informatica PowerCenter, Microstrategy, Business Objects, CAWA, SQL Developer, Teradata SQL Assistant, TOAD, Rapid SQL, MS Office, WinSCP, Putty

Operating Systems: Linux, UNIX, Windows

Bug Tracking Tools: Microsoft Test Manager, JIRA, Quality Center, JAMA, Mantis, Bugzilla

Domains: Retail, Banking & Financial

PROFESSIONAL EXPERIENCE

Confidential, San Francisco - CA

Big Data and ETL Test Lead

Responsibilities:

• Test Planning & Strategy, test script preparation, test execution & documentation to include: Big Data Testing, ETL testing, Functional and Regression testing, UAT testing/co-ordination with market representatives, Environment and data management, System Integration, Retesting.
• Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using HQLs/SQLs.
• Develop Test Cases (Big Data - Hive, ETL, MSTR Reports, UAT) for the project using data mapping sheets & BRD.
• Prioritizing test requirements and test cases, executing test plans, and the evaluating test results.
• Develop complex HQLs/SQLs queries to validate data between different layers (Source to Staging to Target databases) for FACT and Dimension tables data and MSTR reports.
• Preparing Test Data using HQL/SQL (insert/update/create/delete), XML, Text Files for testing.
• Analyzing the Bteq/Pig scripts for source systems analysis, running CAWA jobs to load data into Teradata, Oracle and Big Data layers.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.

Environment: Big Data (Hadoop: HDFS, MapReduce, Pig, Hive), Teradata, Oracle, JIRA, XML, CAWA, TOAD, SQL Developer, Teradata SQL Assistant, Microstrategy, MS Office, UNIX

Confidential, Libertyville - IL

Test Lead - Big Data & ETL

Responsibilities:

• Worked on a very large Data Migration/Conversion project testing - RDBMS to Hadoop.
• RDBMS to Big Data Migration Project - Test Planning & Strategy, test script preparation, test execution & documentation to include: Big Data Testing, ETL testing, Functional and Regression testing, UAT testing/co-ordination with market representatives, Environment and data management, System Integration, Retesting.
• Worked on ETL/Big Data Testing Automation (QuerySurge).
• Develop Test Cases (Hive, ETL, Business Objects Reports, Functional, and UAT) for the project.
• Develop complex HQLs/SQLs queries to validate data between RDBMS and Hadoop.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.

Environment: Big Data (Hadoop: HDFS, MapReduce, Pig, Hive), Oracle 11G, SQL Server 2012, .Net, MTM, TFS, Visual Studio, Java Script, HTML, XML, JSON, MS Office

Confidential

BI Test Lead

Responsibilities:

• Defining the test approach, test strategy and test scope for BI tool migration project
• Extensively using MS excel for data comparison between Microstrategy and Business Objects reports. Used Advanced MS Excel skills.

Environment: Teradata, Microstrategy, Business Objects, Informatica PowerCenter, MS Office, Quality Center, Teradata SQL Assistant

Confidential, Cincinnati - OH

Sr. Bigdata Tester

Responsibilities:

• Perform complex testing tasks, where the items under test include technology components comprised of Big Data (Oracle Exadata), Datawarehouse (Oracle 11g), SharePoint (as a Portal), MicroStrategy (MSTR), and .Net in a multi-tier platform-based architecture.
• Test Planning & Strategy, test script preparation, test execution & documentation to include: Big data and ETL testing, Localization and Configuration testing, Functional and Regression testing, Live support / defect testing, Performance Testing, UAT testing / co-ordination with market representatives
• Develop Test Cases (ETL, MSTR & Flex Reports, Functional, and UAT) for the project.
• Develop complex SQL queries to validate data between different layers.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.

Environment: Big Data (Oracle Exadata), Oracle 11G, .Net, MTM, TFS, Visual Studio, Java Script, HTML, XML, MS Office, Microstrategy

Confidential, Libertyville - IL

ETL Tester

Responsibilities:

• Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs
• Develop Test Cases (ETL, Business Objects Reports, Functional, and UAT) for the project.
• Develop complex SQL queries to validate data between different layers.
• Performing ETL testing, System & Integration, Regression/Re-testing, End-2-End, UAT, Multi browser (Safari, Chrome, Firefox, IE, Opera etc.) and Multi language testing.
• Prepare Test Summary Reports, Test Traceability Matrix and Defect Reports.

Environment: Dot Net, Microsoft Visual Studio, Microsoft Test Manager, JAMA, XML, SQL Server 2012, Oracle 11g, RapidSQL, NetSender, Splunk, Business Objects, Informatica PowerCenter, MS Office, BizTalk

Confidential, Hoffman Estates - IL

Sr. Test Lead - ETL

Responsibilities:

• Responsible for writing the Test Plans & Strategy document, Testing Scope for different releases of the projects
• Developed Test Cases (ETL, Reports, Functional/UI and UAT) for the project.
• Developed Complex SQL queries (Netezza, Teradata, Oracle, SQL Server, Informix) to validate the data between Source to Staging to Target databases to Microstrategy Reports.
• Microstrategy Reports testing, Functional/UI testing for GameOn portal across multiple browsers.
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification, preparing Test Data using SQLs.
• Involved in ETL test process consisting of dimension modeling, data transformation, sourcing, mapping, conversion and loading.
• Managed a team of 2 to 8 testers (onshore & offshore), assigned/verified tasks to all testing team members

Confidential

Data Migration

Responsibilities:

• Defined the test approach, test strategy, test scope for data migration testing, Defect management
• Developed SQL queries to validate the data between Netezza and Teradata, Extensively used MS excel for data comparison between Netezza and Teradata, Microstrategy Reports testing
• Managed a team of 12 testers (onshore & offshore)
• Tested the complete data model between Netezza and Teradata, pre-migration and post-migration testing, smoke testing on daily basis for data load
• Created an automation UNIX tool with the help of team member for table to table comparison

Environment: Netezza, Teradata, SQL Server, DB2, Oracle, Informix, .Net, Microstrategy, UNIX, Control-M, Datastage, .Net, Citrix, Putty, WinSCP

Confidential

Sr. QA Analyst

Responsibilities:

• Prepared Test Plan and Test Cases using BRD, Test Summary Report, Test Traceability Matrix and Defect Report.
• System Testing, Regression/Retesting and Database Testing for different Releases.
• Involved in tracking, reviewing, analyzing and comparing defects using the Quality Center.

Environment: Java/J2EE, Linux, Windows XP/Windows 2K, Unix, XML, Oracle 9i

Confidential

QA Analyst

Responsibilities:

• Prepared Test Cases using BRD, Test Summary Report, Test Traceability Matrix and Defect Report.
• System Testing, Regression/Retesting and Database Testing for different Releases.
• Involved in tracking, reviewing, analyzing and comparing defects using the Quality Center.

Environment: Java/J2EE, LINUX RHES3/ RHFC-3, jdk 1.5 (JSP, Servlets) tomcat 5.18, Oracle 9i, Perl 5.8.0, Bugzilla