SUMMARY

• Over 9 years of Software Quality Assurance (QA) experience testing Data Warehouse, Big data, Database (ETL).
• Proficient knowledge in Hadoop eco system components HDFS and Hive for scalability, distributed computing and high - performance computing.
• Completed agile foundational training provided by Henry Madison.
• Agile SAFE Certified.
• Expertise in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• As a QA Analyst - Worked on various industry verticals - Healthcare and Retail.
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Extensive experience in strategizing, designing and implementing solutions for Data Warehouse Testing / Database Migration Testing / BI Reports Testing projects.
• Providing exact progress and intimating risk and issues at right time to leadership for risk mitigation.
• Coordinating with various teams to achieve the common goal of ‘project release’ on ‘time and quality’.
• Skilled in Data Warehouse testing with Databases like Mark logic (Bigdata NoSQL DB), HDP Cloud, Teradata, DB2, SQL Server and Oracle.
• Hands-on experience in validating XML files of greater volumes using XQuery feature of Oracle.
• Extensive experience in BI Report testing tools Cognos, Sap BO
• Proficient in writing complex and efficient SQLs on huge volumes of data along with performance tuning and query optimization skills.
• Expertise in creating Pyspark scripts to automate the Regression test cases.
• Extensive experience working with various Test & Defect management tools- CA-Rally, Test Director, HP ALM/QC, IBM Rational ClearQuest and JIRA.
• Expertise in System Integration Testing, Regression Testing and Performance Testing of the ETL code and has strong defect analysis and problem-solving skills.
• Self-motivated and has ability to go to the core of the problem, having good work ethics with good communication & interpersonal skills.

TECHNICAL SKILLS

Database: Hadoop Data Lake, Big data Mark logic(XQuery), IBMDB2, Teradata V 12.0, SQL Server 2005, Oracle 10g

ETL Tools/Utilities: DBeaver, Ambari, TEZ, Hue editor for HIVE, Data Studio, Command Editor, Toad, Teradata SQL Assistant 12.0, Oracle Sql Developer, SQL Server Management Studio, Informatica Power Center, Abinitio

Reporting Tools/Utilities: SAP Business Object BI, Congo’s, Crystal reports, Tableau

Scripting Languages: XQuery, SQL, HiveQL, UNIX Shell scripting Basics, Python C

Test Management Tools and Utilities: CA-Rally, Mercury Test Director, Rational Quality manager, Rational Clear Quest, HP ALM, JIRA, MINGLE, Confluence, Google Drive. WinSCP V3.7.5, Putty R0.8, Mainframe Rumba Expertise with Microsoft Excel Formulas

Operating Systems: Windows 2000/XP/Vista/7/8 and UNIX

PROFESSIONAL EXPERIENCE

Confidential

Software Quality Assurance

Responsibilities:

• Working as ETL Test lead responsible for the requirements / ETL Analysis, ETL Testing.
• Coordinating with developers and prepared and implemented Test Strategy & Test plans.
• Coordinated with Tech lead and helped him in developing the Interim tables needed for integration of Auto LOB with other LOB’s.
• Involved in estimation of work to be done for every sprint.
• Attending daily standup to discuss about day to day assignments, status and roadblocks if any.
• Attending all Scrum ceremonies (Sprint Planning, Sprint Retro, Sprint Review, Program Increment planning e.t.c)
• Prepared and executed Hive queries to validate the data in Hadoop environment.
• Created Test Execution summary and provided walkthrough to the stakeholders in sprint review meeting.
• Created bug report to log all defects in rally encountered during manual validation.
• Automated most of my testing using Pyspark executor.

Environment: & Tools: Oracle is being used as a Source and Target database. Hadoop is used to process the data. Pyspark is used to Sqoop the data from Oracle to Hadoop. Autosys is used to schedule and execute the jobs. TOAD, Hive, Tableau, Ambari Views, Quality Centre & Rally are the other tools used.

Confidential

Software Quality Assurance

• Understand and clarify requirements for servers in scope of migration.
• Gather details of source, target, interfaces, access and dependencies for each application.
• Coordinate activities for environment set up - Raise and follow up access for all applications in different environments.
• Prepare and walkthrough of test plan with stakeholders for review and approval.
• Prepared UNIX automation script to perform Informatica connectivity test.
• Perform hard coded IP analysis and coordinate remediation activities.
• Identify, prepare and review test scenarios and test cases.
• Perform pre-migration testing - Execute smoke, integration and performance test cases.
• Coordinate with application and steady state teams for integration testing.
• Walkthrough of pre-migration test results to application owners.
• Perform and coordinate cutover/migration testing.
• Raise any deviations from pre-migration results as an issue and drive it to closure through hyper care process.
• Communicate to stakeholders on execution status, progress, risks and issues.

Confidential

Software Quality Assurance

• Coordinated with developers and prepared and implemented test plans.
• Evaluated all requirements of business, systems and developed test plans according to needs.
• Performed Metadata analysis between existing DW and Hadoop data lake tables and raised clarification.
• Performed data analysis, writing SQL queries for testing and troubleshooting against the Data Warehouse.
• Prepared, reviewed and optimized technically complex SQL queries in DB2.
• Performed extensive report validations between data base tables and the SAP BO report which includes data validations, grid format checks, grid data alignment check, chart format check, chart data alignment check, Header and footer check, report layout check.
• Created bug report to log all defects encountered during manual validation.
• Driven the scrum calls from offshore, which involves daily stand-ups to discuss about day to day assignments and EOD status and clear the roadblocks if any.
• Attended Bi-Weekly QA status meetings with QA team, Developers & Project managers to discuss critical defects, deadlines and milestones for the tasks identified.

Environment: & Tools: DB2, HDP Cloud, Abinitio, Nifi, DBeaver, TOAD, Hive, TEZ views, Ambari Views, Tableau, SAP BO & SAP Lumira, JIRA, Confluence, Google Drive & Platinum.