SUMMARY

• Around 9 years of core expertise in Manual and Automation testing in Agile Scrum (Platinum certified).
• Excellent noledge 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 teh 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 teh datasets by using teh 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 teh integrity of data to perform database testing.
• Has solid experience on database query tools such as TOAD, sql developer and sql plus.
• Expert in writing complex SQL Queriesto check teh integrity of data to perform database testing.
• Experienced wif open-source tools likeSeleniumWebDriver, Firebug, Fire Path, Eclipse Editor, and creation of automation framework wif Test NG.
• Performedcontinuousintegrationand source control using Jenkins and Git.
• Lead a team of 4 QA members (Offshore) as a QA Lead.
• Experience wif Web services testing REST API using postman.
• Excellent team player wif 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 teh Spark Streaming data.
• Successfully led two Testing projects as Project Leader and met teh 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 teh monthly release and logged defects into HP ALM and assign back to teh dev team wif their priorities.
• Worked on Autosys, Unix, Hadoop, Hive, Impala for big data testing, leading teh team for teh same.
• Performing and leading teh testing activity on data lineage.
• Performed and lead teh testing effort on multi data base testing like SQL server, spark sql and Hadoop.
• Coordinated and led teh reporting and tracking of defects in teh application thru Application Lifecycle Management tool and tracking teh defect till closure.
• Strong experience in defect root cause analysis and present defect metric to teh 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 teh different stages of teh 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 teh historical data and latest data wif Rdbms.
• Took a leading role in testing including automation, actively involved in teh creation of detailed Test Plans, Test Metrics, Test cases and Test Scenarios for different application modules according to functional requirements and business specifications.
• Spearheaded teh rewrite of TM module regression test cases. Teh Team surpassed goal and reduced total regression test case count 15% to 20% and execution time by 20-25%.
• Develop automated test scripts using teh TestNG framework for Data-Driven Test and functional/Regression testing based on teh Business rules, using back end automated scripts, and committed changes through SVN.
• Utilized SQL/postgres queries to verify data conformity stored in teh server and Performed database verification wif SQL queries to verify and modify test data.
• Coordinate work wif other developers and designers on teh team which may be cross-location. This may involve off-hour conference calls. Identifying teh technical cause and potential impact of errors and implement coding or configuration changes.
• Driving teh Defect status calls to represent teh testing issues and initiate escalations on time.
• Mentor and guide offshore team and provide clarification for teh queries.
• Create and drive proficiency tests for teh application and domain noledge.
• Create and report teh release metrics to teh client wif details analysis of teh defects logged during teh release.
• Suggest teh development team for teh missed requirements or enhancements.

QA Engineer

Confidential, MD

Responsibilities:

• Involved in analyzing Business Requirements (BRS) and based on teh business requirements finalized teh test plan and defined teh test cases and written teh test scripts automation using Selenium WebDriver.
• Followed teh agile methodology throughout teh SDLC and analyzing and understanding teh business requirements and convert it to test cases and test scripts.
• In-depth noledge 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 wif offshore development team
• Conducted Functionality testing, GUI testing, Integration testing and Regression testing during teh various phases and releases of teh 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 teh 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 wif Web services testing REST API using postman.
• Performed mobile app iOS testing for teh internal and external applications of a company.
• Used JIRA for all defect logging and defect management. Performed production testing during teh monthly release and logged defects into JIRA and assign back to teh dev team wif 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 wif local/offshore developers and product managers. Recreated teh issues to them as it was needed. Coordinated wif 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 teh database.
• Analyzed business requirements, functional specifications, and minor development documents.
• Worked wif teh 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 wif team members in fixing teh 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 teh compliance of requirements wif business objectives.
• Actively participated in teh meetings wif onshore team.
• Understanding teh project specifications.
• Developed manual test cases for company’s different applications.
• Wrote SQL queries by using MySQL to test teh application for data integrity and verified teh contents of teh data table.
• Testing teh application wif various Test Procedures such as Manual Testing.
• Coordinating teh Testing Team to ensure teh Quality Software.
• Having experience in software System testing.
• Documented test results inJIRAbug tracking tool to resolve ambiguities wif local/offshore developers and product managers. Recreated teh issues to them as it was needed. Coordinated wif them on pendingJIRAticketsuntil closure.
• Carried out browser tests in IE, Chrome, and Firefox to ensure a cross-usability environment.