SUMMARY

• 8+ years of IT experience as Data Quality Assurance (QA) Analyst - Big data/ETL technologies and Manual testing techniques.
• Expertise in Snowflake data validation and ETL using Snowflake SQL, implementing complex queries and best practices with data warehouse and ETL concepts.
• Performed project management activities including project documentation, business requirements and project tracking.
• In depth noledge of Testing methodologies, concepts, phases, and types of testing, developing Test Scenarios, Test Cases, Test Procedures, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS).
• Exclusive experience in all aspects of Software Test Life Cycle including System Analysis, Design, Development, Execution, Reporting and Closure Documentation.
• Experience in writing and executing Test Plans and Test Cases from Requirements and Design documents.
• Experience in working with Test management tool like Jira and HP ALM.
• Good domain noledge of web, E commerce, mobile, software testing, banking, healthcare.
• Expert in writing SQL Queries to check the integrity of data to perform database testing.
• Well versed in Hadoop ecosystem - Pig, Hive, HBase and Sqoop.
• Good understanding of Selenium automation testing tool.
• 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 queries for analyzing data.
• Experience in validating and analyzing Hadoop log files.
• Experience in loading multiple larger data sets into HDFS and processing the data sets by using the Hive.
• 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 validating connectivity products that allow efficient exchange of data between core database engine and Hadoop ecosystem.
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
• Experience in report data validations and cosmetic data validations which are developed in Tableau
• Experience on UNIX commands and Shell Scripting
• Experienced in Functional or System testing, Integration testing, Regression testing, UAT, GUI or Web-based Testing.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Extensive experience in working with Tableau Desktop, Tableau Server and Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Understanding of Data Models, Data Schema, ETL and created SQL queries to perform back-end data warehousing testing.
• Experienced in Bug Reporting and Defect tracking using tools like HPALM HP Quality Center and Test Director to log and defect management.
• Experienced in interacting with Clients, Business Analysts, leads, and UAT Users.

TECHNICAL SKILLS

Big Data Technology: HDFS, Map Reduce, Hive, Pig, HBase, Sqoop

Databases: Oracle 11g, SQL Server,Hadoop

Methodologies: Waterfall, Agile/Scrum

Project management tool: JIRA, HP ALM 12.0/11.0

ETL Tools: Informatica Power Center 10.2/10.1/9.6 , Data stage

Reporting Tools: Tableau 10.0

Testing Tools: Selenium, Quality Center 10.x, 9.x

Test management Tool: SAS Enterprise Guide, q test

Languages and OS: SQL, PL/SQL, Win 98/2000/XP/Win-7, UNIX

PROFESSIONAL EXPERIENCE

Data Analyst - ETL & Data Quality

Confidential

Responsibilities:

• Expertise in data validations in Snowflake and regular Database environments
• Understand the business logic with approved Data Requirements Specification document thoroughly.
• Involve in the business meetings to understand the requirement well and participate in the technical discussions with the developers to make sure the design meets the organization standards.
• Discuss about the anticipated bugs that are about to happen and warn the Development team on time, avoid possible negligence or make it easy to write test scenarios or to add additional test cases for testing the code.
• Perform Data validation in support of all data delivery agile teams and Snowflake team as per the mapping document.
• Performed Regression testing to make sure that previously developed and tested software still performs after a change.
• Documenting test cases in QTest, creating test cases in the preferred programming language (Python or SQL), executing test cases.
• Extensive use of Jira software to communicate with agile teams to provide feedback/comments on a new story, task or on a feature.
• Integrating Jira with QTest to provide more clarity to the agile team, hence assuring quality.
• Trouble shooting test scripts/code, reviewing and remediating test findings and communicating to IT teams on how issues can be resolved as well as avoiding them in future development.
• Coordinated with all the teams, representatives, and downstream users involved in testing for sign off approvals.
• Involved in end-to-end defect management of assigned projects. Identified defects, assess root cause, and prepared detailed information for developers and business stakeholders.

Technical Test Lead - ETL & Data Quality

Confidential, Gladstone, NJ

Responsibilities:

• Understand the application / Business logic with Business Requirements Specification documents and functionality of application with Functional Requirements specification documents as a part of the initial Analysis of the Change Request (CR).
• Prepared the gap analysis document by analyzing both the requirement specification document and design specification document.
• Extensively involved with the Testing team to review the Informatica mappings to analyze the CR.
• Analyze the Impact Analysis (IA) document and the corresponding mapping document to understand the scope of the Testing.
• Involved in preparing the high -level Test Plan and reviewed the developed Test Cases in accordance with the IA document/ as per the mapping document.
• Performed Dry run / manual testing to check the functionality of the application.
• Review the test cases /executions done by the team.
• Preparing Weekly Status Reports/Daily Status reports.
• Used HPALM for executing test sets, collecting test results, and analyzing the data.
• Tracked and logged defects in ALM and coordinated meetings with developers and business analysts to prioritize the bugs, bug fixes and problem resolution.
• Written several SQL Queries to validate the data between the source and target
• Participated in Involved in Bug Review meetings and participated in weekly meetings with management team.
• Established Traceability between the Requirements and the Tests in Traceability Matrix using ALM.
• Worked closely with build integration team, business analysts and developers to perform testing activities as per schedules.
• Organized and managed all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Worked with the business users on User Acceptance Testing by mentoring them on various aspects of testing.

ETL Tester

Confidential, Dayton, OH

Responsibilities:

• Understand the application business logic with Business Requirements Specification documents and functionality of application with Functional Requirements specification documents.
• Prepared the gap analysis document by analyzing both the requirement specification document and design specification document
• Involved in preparing the high -level Test Plan and developed Test Cases in accordance with the functional specifications.
• Analyzed Functional specification document and tested the 837 claims data (which involves checking status of claims)
• Performed manual testing to check the functionality of the application.
• Performed SIT and shared the corresponding test results with the business and stakeholders.
• Review the test cases /executions done by the team.
• Preparing Weekly Status Reports/Daily Status reports.
• Used HPALM for executing test sets, collecting test results, and analyzing the data.
• Tracked and logged defects in ALM and coordinated meetings with developers and business analysts to prioritize the bugs, bug fixes and problem resolution.
• Written several SQL Queries to validate the data between the source and target
• Participated in Involved in Bug Review meetings and participated in weekly meetings with management team.
• Established Traceability between the Requirements and the Tests in Traceability Matrix using ALM.
• Worked closely with build integration team, business analysts and developers to perform testing activities as per schedules.
• Generated Bug Reports and Test case coverage reports for status meeting and involved in resource planning for test cases coverage.
• Organized and managed all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Worked with the business users on User Acceptance Testing by mentoring them on various aspects of testing.

Big Data / ETL Tester

Confidential, Rolling Meadows, IL

Responsibilities:

• Tested Map Reduce programs to parse the raw data, populate staging tables and store the data in HDFS.
• Created Hive queries which halped analysts spot emerging trends by comparing fresh data with historical claim metrics.
• Used sqoop to move data from individual data sources to Hadoop system.
• Validated the Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Involved in all over the quality controls (Hadoop & Teradata), data validations, Key business checks implementation of Hadoop ETL flow
• Coordinated various project specific access requests related to Hadoop components like HDFS directories, Hive tables
• Performed various Hadoop controls like date checks, record checks, balance checks, threshold limits for records and balances etc.
• Performed data validations between summary files and extract files after ETL flow.
• Performed various comparisons between Landing zone tables and tracing tables generated during the ETL process.
• Created the data extract by connecting to oracle to place the files on Tableau server.
• Performed Defect Reporting, Analyzing, Tracking and Report Generation using HP Quality Center 11.52 ALM.
• Attended the daily Bug review meetings, weekly status meetings and walkthroughs and interacted with Business Analysts and Developers for resolving Defects.
• Performance testing metrics were captured for all test phases before migration of components like validation scripts ETL jobs etc. to Production.
• Coordinated with all the teams, representatives, and downstream users involved in testing for sign off approvals.
• Involved in end-to-end defect management of assigned projects. Identified defects, assess root cause, and prepared detailed information for developers and business stakeholders.
• Experienced in Data Validation and Back end testing of databases to check the integrity of data

QA Analyst (Web/E commerce)

Confidential, New York, NY

Responsibilities:

• Performed the testing of various life insurance products to ensure that these products met Confidential 's business standards and the different standards mandated by the applicable states where the products are sold.
• Testing included new products along with existing products being sold in the U.S.A, Puerto Rico and the Virgin Islands.
• Tested IBM AS/400, web e Commerce and desktop based applications for Confidential 's new Sales Management System. The AS/400 maintained the core customer contract application and policy production application.
• Performed manual and automated positive and negative testing using Selenium.
• Developed and maintained Java scripts for testing the web and AS/400 based applications. Fixed broken Java scripts so they could be run for regression testing.
• Developed and maintained the test scenario matrices used for the Confidential "Desktop" and web applications.
• The test matrices contained over 1200 test cases which were based on the business requirements for each product tested and the state where they were to be sold.
• The test matrices were used for functional, regression and UAT testing.
• Lead the effort to automate testing for the different applications.
• Trained co-workers on the "Desktop", web and AS/400 applications
• The Quick Base web-based application is used for defect reporting.

Off-Shore QA Analyst

Confidential

Responsibilities:

• Expert writing manual test cases
• Conducted different types of testing including functional, smoke, regression, UI testing
• Created, reviewed and execute test cases and scenarios to meet the business and functional requirements
• Identified new application defects and reported them via Jira
• Worked with both manual and automation team to create manual and automation scripts.
• Involved in testing fixed application defects for retesting and regression testing by manually and automation
• Involved in the preparation of Test Analysis Reports and defect profile document.
• Gather the relevant test data necessary for the test scripts, based on the Transactions, Test Conditions documents and updated in the property files
• Participated in Scrum meetings with QA team to discuss testing process and suggest improvements
• Successfully coordinated work with offshore QA teams and provided onsite hands on testing in parallel.

Quality Analyst/ Mobile Tester

Confidential

Responsibilities:

• Performed Testing for Retail e-Commerce application on both Web and Mobile.
• Designed and created Test Plans and Test Cases based on business requirements
• Performed System testing and Functionality Testing using Point of Sales on highest scale.
• Participated in price and promotions during the entire SDLC.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Performed manual and Selenium testing of a web based application
• Performed data validation testing using POS system.
• Perform responsibilities of developing test scripts by using SOA test tools.
• Test Mobile application on various Mobile devices like navigation, UI, self-provisioning/campaigns.
• Followed the Agile Methodology to emphasize on real time communication over written Documentation.
• Worked deeply into testing consumer mobile web and apps in different Kinds of Mobile smart phones such as iOS frames and Androids.
• Participated in mobile web and mobile application testing, functional, regression, integration, smoke, UAT adhoc and non-functional testing for all smart phones / iOS framework and Androids after release of each sprint.
• Customizing the scope of various QA activities based on nature of projects.
• Experience in testing applications under .Net & windows.
• Actively participate in Project Core Teams, providing technical direction and insight into Sales Channels and day to day operations.
• Conducted test application and detected bugs including documentation of information useful in the debugging processes.
• Conduct Black Box Testing according to the specifications and requirements of the client.
• As a team member, involved in developing QA test plan covering functional, integration, Regression and end-to-end testing.
• Developed and executed test cases and verified actual results with expected results.
• Developed and Maintained Test Matrix on various dimensions like test status to reflect the test progress.
• Performed multi-user testing, cross browser testing and Ad hoc testing.
• Used Quality Center for bug tracking and reporting and also followed up with the development team to verify bug fixes and update bug status.
• Conducted database testing for the application by writing and executing SQL queries.