SUMMARY

• Around 9 years of core expertise in Manual and Automation testing in Agile Scrum (Platinum certified).
• Excellent knowledge in managing projects and product testing using Kanban and Waterfall methodologies.
• Experience asQuality Assurance (QA) AnalystinHadoop, Big data Technologies, ETL, Python, Quantexa tool.
• Expertise in QA testing & methodologies, test plans, test cases, requirement scripts, test evidence walkthroughs, business checkout scripts, defect management, getting the sign off from business.
• Well versed inHadoopecosystem - Map Reduce, Hive, HBase, Spark sql and Sqoop.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in importing and exporting data from relational database intoHadoopcluster using Sqoop, stream sets, swagger.
• Experience in validating and analyzing Hadooplog files.
• Experience in loading multiple larger datasets into HDFS and processing the datasets by using the Hive.
• Experience writing Hive Queries for analyzing data in Hive warehouse usingHive Query Language (HQL).
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using apache stream sets.
• Performed etl/big data testing on cloud platform like Cloudera,Azure.
• Expert in writing complex SQL/Postgres Queriesto check the integrity of data to perform database testing.
• Have solid experience on database query tools such as TOAD, sql developer and sql plus.
• Expert in writing complex SQL Queriesto check the integrity of data to perform database testing.
• Experienced with open-source tools likeSeleniumWebDriver, Firebug, Fire Path, Eclipse Editor, and creation of automation framework with Test NG.
• Performedcontinuousintegrationand source control using Jenkins and Git.
• Lead a team of 4 QA members (Offshore) as a QA Lead.
• Experience with Web services testing REST API using postman.
• Excellent team player with good inters personal communication.
• Extremely dedicated, self - motivated, pro-active, and willing to assume responsibility.

TECHNICAL SKILLS

Test Management Tools: HP ALM (QC), JIRA, SharePoint, MS Project, Confluence

Big Data Technologies: Hadoop (Hive, Impala) SQL, Sqoop, Spark SQL, Stream sets, BVD, Cloudera, Azure

Automation Tools: Selenium Web Driver, Http poster, Soap UI, POSTMAN, Jenkins, Apache Griffin

Methodology: Agile/Scrum, Kanban, Waterfall

Programming Languages: Java, HTML, Python basic

Operating Systems Utility Tools: Unix/Linux, Windows, XP, Mac, MS Office, MS PowerPoint, MS excel

Bug Tracking Tools: HP ALM (QC), JIRA, Bugzilla

Database: MS Access, SQL server 2000, MySQL, Squirrel, Postgres

Development and other Tools: Intellij, Eclipse 5.x/6.x, Putty, WinSCP, Build Forge, RTC

PROFESSIONAL EXPERIENCE

Confidential, MA

Software QA Officer

Responsibilities:

• Experienced in importing and exporting data from relational database into Hadoop cluster using Sqoop and experience in validating and analyzing Hadoop log files.
• Tested Hadoop jobs for processing and analyzing millions of records of data.
• Performed Data Analysis for all incoming feeds to ETL.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing for different sources.
• Using IBM cloudera as cloud platform and having different clusters to query in spark sql.
• Performed testing on downstream Data marts/Data models, which were created on top of different ETL sources.
• Performed end to end testing from Data ingestion, ETL sources, Data marts, Data models, Quantexa UI.
• Used SPARK SQL to query directly on the Spark Streaming data.
• Successfully led two Testing projects as Project Leader and met the deadline.
• Managed an off-shore QA team (India and China) TEMPeffectively to meet testing goals on target.
• Used Quality Center/ALM for all defect logging and defect management. Performed production testing during the monthly release and logged defects into HP ALM and assign back to the dev team with their priorities.
• Worked on Autosys, Unix, Hadoop, Hive, Impala for big data testing, leading the team for the same.
• Performing and leading the testing activity on data lineage.
• Performed and lead the testing effort on multi data base testing like SQL server, spark sql and Hadoop.
• Coordinated and led the reporting and tracking of defects in the application thru Application Lifecycle Management tool and tracking the defect till closure.
• Strong experience in defect root cause analysis and present defect metric to the client for improvement.

Confidential, MA

Software QA Engineer

Responsibilities:

• Performed web services testing, RESTAPIs using SOAP UI and data quality testing using griffin.
• Performed end to end testing from Data ingestion, ETL sources, Data marts, Features.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Understanding of Data Models, Data Schema,ETLand created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL.
• Experience writing Hive Queries for analyzing data in Hive warehouse usingHive Query Language (HQL).
• Performed end to end testing across all the different stages of the ETL including case class, cleansed case class and compounds.
• Used Azure, for cloud, performed testing on it.
• Created tables in Hadoop by sqoop and validated the historical data and latest data with Rdbms.
• Took a leading role in testing including automation, actively involved in the creation of detailed Test Plans, Test Metrics, Test cases and Test Scenarios for different application modules according to functional requirements and business specifications.
• Spearheaded the rewrite of TM module regression test cases. The Team surpassed goal and reduced total regression test case count 15% to 20% and execution time by 20-25%.
• Develop automated test scripts using the TestNG framework for Data-Driven Test and functional/Regression testing based on the Business rules, using back end automated scripts, and committed changes through SVN.
• Utilized SQL/postgres queries to verify data conformity stored in the server and Performed database verification with SQL queries to verify and modify test data.
• Coordinate work with other developers and designers on the team which may be cross-location. This may involve off-hour conference calls. Identifying the technical cause and potential impact of errors and implement coding or configuration changes.
• Driving the Defect status calls to represent the testing issues and initiate escalations on time.
• Mentor and guide offshore team and provide clarification for the queries.
• Create and drive proficiency tests for the application and domain knowledge.
• Create and report the release metrics to the client with details analysis of the defects logged during the release.
• Suggest the development team for the missed requirements or enhancements.

QA Engineer

Confidential, MD

Responsibilities:

• Involved in analyzing Business Requirements (BRS) and based on the business requirements finalized the test plan and defined the test cases and written the test scripts automation using Selenium WebDriver.
• Followed the agile methodology throughout the SDLC and analyzing and understanding the business requirements and convert it to test cases and test scripts.
• In-depth knowledge on different modules of Service Now, wrote 500+ test cases on Service Now.
• Tested web service using SOAP UI and data layer for data validity.
• Manage and TrackedJiraticketsvia triage calls with offshore development team
• Conducted Functionality testing, GUI testing, Integration testing and Regression testing during the various phases and releases of the application using Selenium automation
• Contributed to theContinuousIntegrationpipeline running component builds, creating, and running Deployment jobs on individual stages on Jenkins, and running automated and manual functional tests.
• Performed functional, non-functional, regression, smoke, black box and white box testing, exploratory testing on different modules of Service Now.
• Performed mobile app iOS testing for the internal and external application of company.
• Involved in writing SQL queries to run inoracledatabaseto test data integrity.
• Involved in Design, Analysis, Implementation, Testing and Support of ETL process.
• Experience with Web services testing REST API using postman.
• Performed mobile app iOS testing for the internal and external applications of a company.
• Used JIRA for all defect logging and defect management. Performed production testing during the monthly release and logged defects into JIRA and assign back to the dev team with their priorities.

QA Analyst

Confidential, MD

Responsibilities:

• Created test scripts, test cases, test evidence and performed manual as well as automated testing.
• Performed Smoke, Functional, Integration, Regression, Performance, UAT and End to end testing.
• Documented test results inJIRAbug tracking tool to resolve ambiguities with local/offshore developers and product managers. Recreated the issues to them as it was needed. Coordinated with them on pendingJIRAticketsuntil closure.
• Carried out browser tests in IE, Chrome, and Firefox to ensure a cross-usability environment.
• Involved in all phases of testing life cycle (analysis, design, and execution). Iteration kick-off and design meetings and participated in QA test case reviews.
• Written SQL queries in Oracle SQL developer to extract data from various oracle database tables for testing members and providers details are correctly saved in the database.
• Analyzed business requirements, functional specifications, and minor development documents.
• Worked with the business users for requirements gathering and created system process flow chart &functional specification documents for developing new software application.
• Created test scripts, test cases, test evidence and performed manual as well as automated testing.
• Writing, maintaining, executing test plans, test cases and test Scripts, analyzing bugs and interacting with team members in fixing the errors.
• Written SQL queries in Oracle SQL developer to extract data from various oracle database tables for testing members and providers details are correctly save in database.

QA Engineer

Confidential

Responsibilities:

• Created test scripts, test cases, test evidence and performed manual testing.
• Performed Smoke, Functional, Integration, Regression, Performance, UAT and End to end testing.
• Executed two product releases by requirement gathering and analysis from clients and ensuring the compliance of requirements with business objectives.
• Actively participated in the meetings with onshore team.
• Understanding the project specifications.
• Developed manual test cases for company’s different applications.
• Wrote SQL queries by using MySQL to test the application for data integrity and verified the contents of the data table.
• Testing the application with various Test Procedures such as Manual Testing.
• Coordinating the Testing Team to ensure the Quality Software.
• Having experience in software System testing.
• Documented test results inJIRAbug tracking tool to resolve ambiguities with local/offshore developers and product managers. Recreated the issues to them as it was needed. Coordinated with them on pendingJIRAticketsuntil closure.
• Carried out browser tests in IE, Chrome, and Firefox to ensure a cross-usability environment.