SUMMARY

• QA Test Lead with 4+ years of experience in Quality Assurance - Waterfall and Agile Methodology in Big data testing(Hadoop, Hive, Hbase, Spark), Data Warehousing, Data Migration, and ETL for Health Care.
• Excellent ability to multi-task and prioritize difficult projects to maintain highest quality while adhering to the timeline. Proactive team player with ability to lead and motivate team members.
• Strong Knowledge of Software Development lifecycle (SDLC), Software testing lifecycle (STLC) and Defect Life Cycle.
• Profcient in performing GAP analysis, and coming up with Automation ideas, building POCs and presenting Dash Board for ROI due to Automation of repetitive and complex tasks.
• Identifying the risks due to (Process,Planning,People,Techonolgy) and submitting of with Risk Mitigation plans to higher managment.
• 4+ years of experience in building Automation framework to validate Sources (Database, flat files, XML, JSON) To Target (HBase, Hive and Phoenix tables) testing using Pig and Hive Scripts for Ingestion and Consumption. Used tools like Data Meer to validated HBase tables.
• Excellent written, communication, interpersonal, multi - task skills, proven QA Team Lead/Test Lead and team player with an analytical bent to problem solving and delivering under high stress environment.
• In depth technical knowledge and understanding of Hadoop, Data Warehousing, Data Validations, SQL Server, Oracle,DB2 and ETL.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in importing and exporting data from relational database into Hadoop cluster using sqoop.
• Experienced in creating Hive, Pig and custom map reduce programs for analyzing data.
• Experience in loading multiple larger datasets into HDFS and processing the datasets by using the Hive and Pig.
• Experience in validating tables with Partitions, bucketing and Loading data into HIVE tables.
• Experience writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL).
• Experience in handling offshore and handling teams.
• Experience in leading multiple teams at a time.
• Experience in creating test strategy, test plans, Test Cases and Scenarios.
• Experience in Software QA and Testing Methodologies, verification, and validations in all phases of the SDLC.
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Performed functional testing using databases such as Oracle SQL Developer, Teradata SQL Assistant, IBM DB2, and Big data tools such as Hortonworks hBase, hive, Pig, Spark, Kafka, HDFS.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task using Rally and JIRA task management system.
• Ability to develop complicated SQL query for Data validation testing by running SQL query.
• Extensively Used qTest, ALM (QC) and Rally for defect tracking management.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Participated extensively in Functional Testing, Integration Testing, System Testing, Regression Testing, Database Testing, Web services, Performance Testing, Application/UI and Smoke/Sanity Testing.
• Interview new candidates and hire them for my team.
• Conduct knowledge transition within the team to get acquainted with existing applications and also provided training sessions on Big data Technology tools
• Encourage/Recommend team to identify new methodologies/approaches to test the data without any manual intervention.
• Implement effective ideas to bring in savings for various projects/initiatives using automation.

TECHNICAL SKILLS

Test Managment tools: HP ALM, qTest, RTC Jazz

Languages: SQL., Scala

Big Data Technologies: HDFS, HBase, Sqoop, Hive, Pig, Kafka, spark.

RDBMS: Oracle, MS SQL Server, Teradata, and MySQL, DB2.

ETL Tool: Data Stage, Talend

Data Visualization: Datameer

Operating System: Windows, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential

Sr Test Engineer/ Test Lead

Responsibilities:

• Managed the testing resources (team size: 6) in onshore and offshore locations
• Worked on validating the conversion of outbound batch process for a customer application from Mainframe to Teradata, Hive to Teradata, Db2 to Teradata, Files to Hive, Files to HBase, Hive to files, and Teradata to files.
• Responsible for creating complete test plans, test cases, test data and do Requirement Traceability Matrix in HP ALM ensuring accurate coverage of business requirements.
• Worked with different sources like flat files, XML, JSON files.
• Lead the preparation and execution of test plans for multiple projects/releases.
• Performed and lead the testing effort on multi database testing like SQL server, Tera data, and Hadoop.
• Performed data validation testing writing SQL And Hive queries.
• Involved in ETL process testing using the Data stage ETL tool.
• Wrote complex queries in Hadoop, Teradata, and DB2 to check the data from Source and Target.
• Involved in writing SQL queries and Database Checkpoints to verify data quality.
• Estimated the Testing Effort required and revised estimates when there is a change in effort.
• Collaborated with Project Managers, Business Analysts, SME's, Development teams, and organized early sync-up meetings with the QA team as a part of Test preparedness and Defect prevention process.
• Involved in Functional Testing & Regression Testing.
• Participate in Daily Standup calls and update the progress to all stakeholders.
• Working on qTest, HP Quality Center/ALM for creating and documenting Test Plans and Test Cases and register the expected results.
• Performing End to End testing, Business Testing (UAT), Regression and Sanity Testing.
• Performing the Data Quality checks and Data Quality threshold checks on the Terdata, Hadoop, Db2 files which we get from the source.
• Leading the test data preparation activities using various tools for testing purpose.
• Involved in Functional Testing & Regression Testing.
• Developed Regression Suite and SQL Queries to aid the automation team in building the automation scripts
• Created Defect Reports, Daily/Weekly Status Reports and Communicated these reports effectively with project team members, stakeholders and made recommendations to the management on process and test approach.

Confidential

PROGRAMMER ANALYST / GRADUATE ASSISTANT

Responsibilities:

• Worked in HTML, CSS, HTML5, XML, DHTML, Ajax, JavaScript, jQuery, Angularjs.
• Worked on Cross-Browser Compatibility and tested each and every web application on popular web browsers such as Internet Explorer, Firefox, Safari, Opera and Chrome.
• Responsible for transforming designed mockups into web pages.
• Developed Web applications that are cross-browser compatible.
• Performing new - website support research in the areas of Latest Web Technologies, Usability, Accessibility, and User Experience.
• Coordinated with the quality group for testing activities and Production Support team to resolve the solution.