SUMMARY:

• Ten years plus Software Quality Assurance Analyst with extensive Data Driven testing experience in various business applications of Client/Server and Multi - tier web environment.

TECHNICAL SKILLS:

Hardware: SunSparc/Ultra, HP 9000, IBM Compatibles x86 PCs and Mac 9.x, AWS EC2.

Operating System: UNIX, SunOS, Linux, WINDOWs

Languages and Softwares: SQL, PL/SQL, Shell Scripting, Python, Java-Script, Spark, PySpark, AWS S3, Athena, RedShift Spectrum, AWS CLI, AWS Glue, AWS EMR, Tableau, and Domo.

Database: Oracle 11gR2 RAC, SQL Server 5.0 and MySql, MongoDB, AWS Redshift.

Project Management: Waterfall, Agile and SCRUM methodology, Certified Scrum Master.

PROFESSIONAL EXPERIENCE:

Senior QA Engineer

Confidential, New York

Responsibilities:

• Responsible for developing and executing detailed, comprehensive and well-structured test plans and test cases for Healthcare Management and Reporting Softwares, ETL and Reporting applications..
• Analyze Business Requirements of ETL structural mapping of source and target towards creating test cases to perform data integrity, functional and regression for Reporting and ETL testing.
• Construct complex SQL queries, database scripts, Bash scripts to perform verification of Relational and NoSQL data migration, ETL and Reporting processes.
• Responsible to maintain a continuous Data Extract Repository where tableau reports data are stored.
• Responsible for scheduling and running Data Conversion job using AWS EMR, S3 buckets and AWS Redshift.
• Provide limited database administration tasks of MySql, Mongodb and Redshift Databases.
• Manage a offshore team of five members where distribute testing tasks and verify their bug reports.
• Identify software errors and interact with development team to resolve technical issues..
• Manage and provide training to newly hired Quality Analyst.

Environment: MySql, MongoDB, AWS S3, Athena, RedShift Spectrum, AWS CLI, AWS Glue, AWS EMR,Tableau, Pentaho, Java, JavaScript, HTML & DHTML, CSS, Windows/Macintosh, Linux, XML, TCP/IP.

Senior Data Management Quality Assurance Analyst

Confidential, New York

Responsibilities:

• Developed and executed detailed, comprehensive and well-structured test plans and test cases for Content Management System (CMS), Data Lake and Web Applications.
• Defined testing strategies for system, software, regression, user-acceptance and load testing.
• Performed manual, automated, functionality and Integration testing for Data Driven Content Management Application and web sites.
• Analyzed ETL structural mapping of source and target towards creating test cases to perform data integrity, functional and regression, Database and ETL testing.
• Developed SQL database scripts, Bash scripts, PySpark scripts to perform verification of Relational and NoSQL data migration or ETL processes.
• Maintained a continuous Data warehouse Data Lake project where web analytics data are stored.
• Responsible for maintaining quality of Data Conversion running AWS EMR, verifying data developing query on AWS Athena and Glue Catalogs, and finally create corresponding tables using AWS Redshift Spectrum.
• Performed data migration from production to test environment using Oracle Data Pump, SQL Loader and Export / Import utilities.
• Provide limited database administration tasks of Oracle databases, MySql, Mongodb and Redshift Databases.
• Identify software errors and interact with development team to resolve technical issues.
• Involved in weekly status updates showing progress of testing on various Operating systems and browsers.
• Manage and provide training to newly hired Quality Analyst.

Environment: Oracle 11gR2, MySql, MongoDB, AWS S3, Athena, RedShift Spectrum, AWS CLI, AWS Glue, AWS EMR, Adobe Analytics, Informatica,Domo, Java, JavaScript, HTML & DHTML, CSS, Windows/Macintosh, Linux, XML, TCP/IP.

Senior Quality Assurance Analyst

Confidential, New York

Responsibilities:

• Developed the high-level Test Plan, Use Case, test conditions for most of the above mentioned applications.
• Performed System, Software, Regression, User Acceptance and Load testing.
• Performed Manual and Automated GUI, Functionality and Integration testing for Content Management Application and web sites.
• Identified software errors and interacted with developers to resolve technical issues.
• Involved in analysis, design, development and execution of testing modules and phases in CRM application.
• Involved in weekly status updates showing progress of testing on various Operating systems and browsers.
• Worked with SQL and Unix Shell Scripts to test database integrity.
• Validated the back-end data by using SQL and PL/SQL extensively.
• Developed the test case scenarios for functional testing of web application developed in HTML and XML.
• Developed Test Cases, Test Plans and produced Bug Reports using TestDirector.
• Extensively used SQL to gather the data required for Data Driven Testing and Load Testing.
• Managed and provided training to newly hired Quality Analyst.

Environment: Oracle8i, Oracle 10g, Oracle 11gR2, MySql, MS SQL, Java, JavaScript, HTML & DHTML, CSS, WinRunner, Windows/Macintosh, Linux, XML, TCP/IP.