SUMMARY

• ISTQB Certified tester with 9+ years of experience in IT Industry working as Data Quality Analyst, ETL/Data Warehouse and Business Intelligence and Analytics QA.
• Focused experience in Testing / QA for ETL, Data Warehouse, Data Migration, Database, Data Virtualization, and writing complex SQL for data transformation business logic validation.
• Extensive experience in testing BI Reports and Analytics tools viz. Cognos, QlikView & Tableau tools.
• Excellent knowledge and experience in Waterfall & Agile SDLC Methodologies, STLC and V - Life Cycle Model.
• Manual Testing:
• Prepared test cases for functional, non-functional and regression testing.
• Proficient in writing test cases by using test case design technique
• Experience in Test Execution Process, Defect Life Cycle, and Test Plan.
• Performed both Manual and Automated Testing on Client-Server and Web-based applications by using reporting and data analytics tools.
• Expertise in Test Strategy, Test Plan, Efforts Estimation, Test Scenarios, Test Cases Design, Review, Execution, Traceability Matrix, Defects finding, Defect Triage, and Defects Matrix, Reviews, Risks-Issue Identification/Mitigation, and QA Team lead activities.
• Expertise in Business Process Testing, Integration, System, Functional, Website/wireframes, Regression, Acceptance, Smoke/Sanity, Risk Based Testing, and Prototype models testing, Impact analysis.
• UI/UX, Website Testing, Cross Browser/Platform Testing, Mobile testing
• Experience in database testing to verify data integrity by using SQL tools like Toad, SQL*Plus, SQL Developer
• Excellent knowledge of Automation Frameworks and automation scripts using ETL tools and SSIS.
• Extensive experience in testing QlikView (Version 11) dashboards
• Experience in testing different extensions viz. QlikMaps, GeoCluster, Auto Refresh, CustomFont in QlikView dashboards
• Extensive experience in testing Tableau dashboards
• Intermediate experience in creating ETL script in QlikView for pulling data from different ODBC, OLE DB data sources and flat files to create the basic components of QlikView
• Involved in Load/Performance testing for QlikView dashboards.
• Extensively tested advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems
• Well acquainted with HP Quality Center 10 and ALM 11.5 for defect tracking and RTM.
• Involved in Automation testing by using tools like Quick Test Pro and Selenium.
• Extensive experience in GUI, Functional, Integration, Regression, User Acceptance, System, Performance, Load, Stress, Black Box testing
• Conversant in analyzing information system needs, evaluating end-user requirements.
• Proficient in BusinessRequirements Document (BRD), Functional Requirements Document (FRD), User Interface documents, and business process modelling and analysis using various tools such as Power designer, Calibre RM, and Rational RequisitePro.
• Extensive experience in defect management, defect coordination, coordination between onsite-offshore team, interaction among developers, architects and management.
• Effective in working independently and collaboratively in teams.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Willingness to work in a highly dynamic environment and ready to take up challenges

TECHNICAL SKILLS

Testing Skills: Test strategy, Test scripts, Test data preparation, Test execution, Defect management, Test reporting, Test Automation script writing

Test Tools: HP Quality Center 11.5, ALM11.52, Bugzilla, QTP 10.0, Selenium, Test Director 8.0, Jira, Clear Quest

Databases and ETL Technologies: Cisco Information Server studio 7.0, MS SQL Server 2000/2005, Oracle 9i/10g, MS Access 2000, TSQL, Oracle PL/SQL, SQL*Plus, TOAD 9.0, SQL*Plus, SQL*Loader, Datastage 8.7

BI tools: Congos 10.1.1, QlikView 11, Tableau 8.1

Environment: Client/Server, Windows Based, Web based, Mobile

Methodologies: Agile and Waterfall SDLC Development, UML Design

Configuration Mgmt. & Version Control: VSS, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Quality Analyst

Responsibilities:

• Involved in Business Requirement gathering, to understand dashboard requirement and for the estimation of Quality processes to be followed as per organization
• Created and defined Test Strategy, Test Plan for QlikView dashboards and data virtualization platform.
• Extensive experience in project Test planning, scope defining, estimating and executing testing efforts
• Working as QA team lead to guide, manage, track testing team efforts, and achieving quality goals within specified timelines. Working as QA lead for global test team located in New York and Bangalore.
• Reviewed test cases written by offshore team and support them on daily scrum call meetings.
• Finding defects by analyzing and reviewing of ETL Mapping, ETL architecture, ETL design, ETL technical specifications and QlikView business model mapping documents.
• Created complex queries in CIS studio to validate data from Metadata layer to target layer which point to QlikView. Created complex SQL test scripts for reconciliation of control numbers between summary and detailed dashboards for submission and premium count.
• Validated data on QlikView summary and detailed dashboards against the composite data by executing the queries on each layers of CIS. Monitoring data in Composite Studio from Meta data layer till Application layer for data count and aggregation of data and transformation logic
• Supported QA team for User Interface, User Experience, and GUI testing on KPI Summary and detailed QlikView dashboards.
• Extensive testing on summary and detailed dashboards to test KPI’s using different charts viz. Bar chart, Line chart, Trend chart, Heatmap, Block chart.
• Tested section access that enables users to access the section of the QlikView document depending upon their access privileges
• Provide QA support and actively interacted with multiple PM’S, BA, Development teams and Business user’s whenever needed.
• Used QC extensively for test management and generated various metrics to track the test execution, test results, defect reports.
• Effectively coordinated between teams (Offshore, Dev, and QA) and reported the work status through meetings.
• Reviewed all defects, participate in scope change discussions and issue resolution, and created the exit report when for each iteration.

Environment: Quality Center11.5, Oracle 10g, TOAD for Oracle 9.0, CIS studio7.0, QlikView 11, Agile, MS Project, Query Studio, SnagIt 7,.NET, ETL - Datastage

Confidential

Responsibilities:

• Established the hive connection from QlikView to validate the data on dashboard
• Tested section access in QlikView offline for each levels of manager’s hierarchy because of the user credential settings on servers.

Analyzer

Casualty

Responsibilities:

• Tested iPAC portal access point to navigate from one dashboard to another with single sign on among limits and attachment, Leading indicators and Profitability dashboards
• Responsible for testing Loss triangles for 25 years of reserve data by using the actuaries’ statistic calculation against excel provided by actuaries.
• Created complex SQL queries in Oracle to test the three dimensions bar charts with set of retention range for Excess and Primary business lines. Validated data from Staging to Fact layers.
• Expertise in testing QlikView charts viz. Pie chart, Triangles, Summary chart, Report view charts, three dimensional bar charts. .
• Analyzed user requirements and had done data analysis on minor factor to calculate the major factors by using Z-score from dashboard prospects
• Reorganized the calculated data and mapped according the columns needed to create a dashboard
• Worked closely with developer team to developed user interface design process that included user profiles, user scenario and use cases. usability testing, site maps and process flows, wireframes and interaction specifications
• Created test plans, test cases and testing strategy for the planning and execution of test scripts
• Written multiple Test scenarios on Factor Heatmap, Country rankings and Factor Spider chart for writing different Test scenarios and by doing pivot on spreadsheet for same scenarios.
• Proficient in Excel for data analysis using Pivot, formulas (v-lookup and others), Z-score, conditional formatting, graph and chart manipulation against the Tableau dashboard to test different charts.
• Created positive and negative Test cases for each test scenario to test the market attractiveness, growth rate and micro-economic trend.
• Created Micros to lined data in excel for all 60 countries to compare the spider chart values on Tableau dashboard.
• Handled various phases of Testing Cycle such as Functionality testing, Retesting, Regression testing, Integration testing, System testing and User Acceptance testing
• Defect Logging/Retesting/Reporting in Quality Center.

Confidential: Hoboken, NJ

QA Analyst

Responsibilities:

• Analyzed user requirements and documented test requirements using HP’s Quality Center requirement module
• Created test plans, test cases and testing strategy for the planning and execution of test scripts
• Handled various phases of Testing Cycle such as Functionality testing, Retesting, Regression testing, Integration testing, System testing and User Acceptance testing (as demanded by client)
• Validation of machine data loaded into Raw, Staging, Presentation layers of Data warehouse and DataMart.
• Tested all standard Congos reports for reserve losses against the existing macro reports.
• Designed SQL for validating data logged as per user actions. Designed SQL for verifying business rules, Foreign, Primary Key concepts, data constraints.
• Writing complex SQL queries for Data Reconciliation, validation, Accuracy, completeness, Transformation logic, Data Standards, Metadata, Column, Table level constraints, Data Integrity, Referential Integrity testing.
• Involved in testing of feed import from insurance company systems and sponsor systems.
• Monitoring ETL Shell Scripts execution, checking logs in UNIX, Validating and analyzing Shell Scripts if error occurred. Taking corrective steps to fix the errors.
• Involved in testing of exports extracts for insurance company systems and sponsor systems.
• Executing ETL Shell Scripts in UNIX system for data loading. Loading of Unadjusted data, adjusted data, Intraday, Near Real time data, Validating Perl Script for specific ETL jobs execution program, Source Feed files. Verifying/validating Data control flow step by step.
• Involved in Business Process Testing using tool QTP

Environment: Rational Unified Process (RUP) Methodology, Sybase Power Designer, Quality Center, Data Stage, Selenium Web driver, Toad, Oracle 10g, Java, smart draw, VS

Confidential

QA Analyst

Responsibilities:

• Coordinated with Client on call for requirement gathering.
• Designed the Test plan according to the given specification document from the client.
• Wrote Test case design, Test flows documents, using Quality Center
• Designed and tested various modules of the system.
• Retested the defect after fixing from developer and closed defects.
• Involved in end-to end workflow testing
• Conducted client meetings regarding test case reviews
• Actively participated in System Testing, production support and maintenance/patch deployments.
• Used SOAP UI to test the Web Services.
• Involved in testing XSLT generated Reports using selenium.

Confidential

QA Analyst

Responsibilities:

• Involved in gathering, analyzing and documentation of requirements.
• Creation of Test Plan from Requirements.
• Wrote Test Case Design, Test flows documents, using Quality Center
• Conducted Data Base Testing (Back End Testing) by creating SQL statements.
• Executed ETL data testing of Life Asia data by using data stage tools.
• Involved in Regression Testing using Selenium
• Analyzed test records and defect reporting by logging defects in Defect tracking system.
• Experienced in handling various phases of Testing Cycle such as Functionality testing, Retesting, Regression testing, Integration testing, System testing and User Acceptance testing(as demanded by client).

Confidential

Test Lead

Responsibilities:

• Responsibilities include analyzing, design, coding, testing and documentation.
• Extensive experience in Backend testing and Oracle Database Validation using Toad
• Written and executed extensive database queries using Inner, Outer, Left, Right and Self Joins
• Written SQL queries for hierarchical relationship using “Start With”, “Connect by”, “Prior”, and “Order Siblings By” clauses to obtain data at different tree levels for parent-child relationships
• Experience using Sql query builder and schema browser in Toad
• Extensive testing on Flash applications for all e-learning projects
• Tested the .Net based Tata motors application by using the C# language.
• Developed and executed manual/automated scripts for Functional, Integration, End-to-End and Regression testing
• Conducted Performance, Load and Stress testing using WebLoad
• Worked with business users to implement their functional knowledge into business workflow and processes.