SUMMARY

• 7+ years of IT experience asQuality Assurance (QA) Analyst - Big data/ETL technologies and Manual testing techniques.
• In depth knowledge 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 executingTestPlansandTestCasesfrom Requirements and Design documents.
• Experience in working with Test management tool like Jira and HP ALM .
• Good domain knowledge of web, Ecommerce, mobile, software testing, banking, healthcare.
• Expert in writing SQL Queriesto check the integrity of data to perform database testing.
• Well versed inHadoopecosystem - 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 intoHadoopcluster using sqoop.
• Experienced in creating Hive queries for analyzing data.
• Experience in validating and analyzing Hadooplog files.
• Experience in loading multiple larger datasets into HDFS and processing the datasets 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 usingHive 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 PowerCenter.
• 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,ETLand 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, MapReduce, Hive, Pig, HBase, Sqoop

Databases: Oracle 11g, SQL Server

Methodologies: Waterfall, Agile/Scrum

Project management tool: JIRA

ETLTools: InformaticaPower Center 10.2/10.1/9.6

Reporting Tools: Tableau10.0

Testing Tools: Selenium, HP ALM 12.0/11.0, Quality Center 10.x, 9.xTools TOAD, SQL Navigator, Oracle SQL Developer

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

PROFESSIONAL EXPERIENCE

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.
• Performed 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.
• 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/ ETLTester

Capital one, Rolling Meadows, IL

Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans, banking and savings account, In the project Data is ingesting into Hadoop Data Lake from different traditional structured and semi structured source systems, then applying data cleansing and transformation rules to meet the business requirements. Data Analytics team is analyzing these huge volumes of enterprise data and trying to find different patterns to identify the risk.

Responsibilities:

• Tested Map Reduce programs to parse the raw data, populate staging tables and store the data in HDFS.
• Created Hive queries which helped analysts spot emerging trends by comparing fresh data with historical claim metrics.
• Used sqoop to move data from individual data sources toHadoopsystem.
• Validated the Pig, Hive Scripts by pulling the data from theHadoopand 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 ofHadoopETL flow
• Coordinated various project specific access requests related toHadoopcomponents like HDFS directories, Hive tables
• Performed variousHadoopcontrols 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 Backend testing of databases to check the integrity of data

QA Analyst (Web/Ecommerce)

SBLI, New York, NY

Responsibilities:

• Performed the testing of various life insurance products to ensure that these products met SBLI'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,webeCommerceand desktop based applications for SBLI's new Sales Management System. The AS/400 maintained the core customer contract application and policy production application.

• Performedmanualand automated positive and negative testing using Selenium.

• Developed and maintained Java scripts for testing theweband 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 SBLI "Desktop" andwebapplications. 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",weband AS/400 applications

• The QuickBaseweb-based application is used for defect reporting.

Tools: used: Selenium, QuickBase

Off-Shore QA Analyst

21st Century Insurance

Description: 21st Century Insurance is one of the largest Insurance Company in US. Their main goal is to cut out middleman, by selling insurance directly to customers by eliminating brokers, cost of agents and commissions. The project was to redesign the website for Auto-Insurance customer by replacing of web pages to obtain quote and to purchase a policy. The project also introduced Automatic Customer Registration for online access to policy self-service and to interface with new partners .

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/MobileTester

Alphabet Tech Solutions

Bengaluru, India

Responsibilities:

• Performed Testing for Retail e-Commerce application on both Web andMobile.

• 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.

• TestMobileapplication on variousMobiledevices like navigation, UI, self-provisioning/campaigns.

• Followed the Agile Methodology to emphasize on real time communication over written Documentation.

• Worked deeply into testing consumermobileweb and apps in different Kinds ofMobilesmart phones such as iOS frames and Androids.

• Participated inmobileweb andmobileapplication 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