PROFESSIONAL SUMMARY: 

• Over 10 years of extensive experience in Manual and Automated Testing of Client/Server, Multi - tier web based applications, Data Warehousing Tools - ETL/BI testing in Banking, Health, Insurance and Pharmaceutical domains following Waterfall methodologies, Agile/SCRUM Iterative models.
• Expertise in analysis of User Requirement, Functional Specifications, Use Cases, Business Requirements and design of Test Cases, Test Scripts, Test Data.
• Expertise and good knowledge in Data Warehousing projects on ETL testing or DW testing with Informatica, SSIS, Datastage and AbInitio tools
• Good knowledge of Data warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Strong technical Knowledge of UNIX commands.
• Good Knowledge on OLAP tools like Cognos, Business Objects, Microstrategy, and Siebel Analytics/OBIEE.
• Specialized in GUI Testing, Functional Testing, System Testing, Integration Testing, Regression, Performance Testing and User Acceptance Testing, Back End Testing.
• Experience in generating Automated Tests for Functional testing using tools like QuickTestPro, WinRunner and LoadRunner.
• Expertise in logging and tracking Defect using Mercury -Defect Tracking Tools like HP Quality Center, Clear Quest, TrackWise, Test Director and in house tools.
• Extensive experience in writing complex queries in SQL (DML, Joins, Subqueries, etc), stored procedures, Performance Tuning of SQL, DTS package for Back End testing in Oracle, SQL Server databases.
• Using SQl Queries, validated data for different Test scenarios on ETL Mappings, Structure Validation, Constraint Validation, Data Consistency issues, Data completenesss issues and data quality quality issues.
• Good knowledge on Webservices and XML based testing on Service Oriented Architecture(SOA).
• Strong experience in testing applications on Windows and Unix platform.
• Excellent logical skills for understanding and developing system workflows and well suited for communicating with both Technical and Functional professionals.
• Possess Problem-Solving Skills, Ability to Follow Industry standards and procedures, Quickly Master new concepts and Applications. Ability to work independently or within a team
• Highly self motivated and goal oriented professional with excellent communication and Interpersonal Skills.

TECHNICAL SKILLS:

BI/Reporting Tools: Tableau, IBM Cognos BI, PowerPlay Transformers, Impromptu, Visualiser, Business Objects, Siebel Analytics/OBIEE and MicroStrategy.

ETL Tools: Informatica Power Center, Confidential - SSIS and DataStage.

Automated/UI Testing Tools: Selenium, SOAP UI, QuickTestPro 9, Win Runner, LoadRunner 8.1

Defect Tracking Tools: VSTF, HP ALM, Quality Centre 9, Test Director, Clear Quest and Trackwise.

RDBMS: SQL Server, Oracle 9i/10g, Teradata, DB2, Netezza and Access.

Languages: C, C++, C#, VB, SQL, PL/SQL, Java

Web Technologies: HTML, XML, ASP.NET, Java Script, VB Script.

Version Tools: IBM Rational Clear Case, Confidential -VSS, Subversion.

Operating System: Windows 7/XP, UNIX

Others: Toad, Win SQL, Confidential Visio and Rational Requisite Pro

EXPERIENCE:

Confidential, San Francisco, CA

Responsibilities:

• Designed test plans and test cases from Functional requirements / Mapping documents of Wealth Management, MDM and BSA AML/RCM/Actimize teams.
• Validated new User Stories/Change Requests using SQL server/Oracle databases.
• Ran Informatica jobs to validate workflows across multiple layers (Source tables - Target tables).
• Validated test cases, regression suites and closed the defects in VSTF(Kanban process).
• Validated Batch process for Full loads, daily Incremental/Monthly loads and automated regression suites etc.
• Validated automated Alerts, ETL log tables for each batch via server monitor/ SQL server.
• Validated frontend UI reports for various banking tracks/sites (CDD, SAM, RCM, etc.)

Environment/Tools: Windows 10, Unix, Informatica, SSIS, VSTF, Banking tools(Actimize, RCM etc), sharepoint, Confidential office tools etc.

Confidential, Fremont, CA

Responsibilities:

• Created Test plans and Test cases and Mapping documents(BI/ETL) from EBR requirements through Jira tickets.
• Validated the Tableau Dashboards (Summary KPI’s and Readership and Activity Graphs).
• Validated Dashboards - UI and Dashboard (source) - Database(target) for all the tableau reports.
• Validated the ETL part of the dashboards (Source to target) per the Jira tickets and mapping doc.
• Performed retesting and regression suites of the defects/Dashboards and resolved the tickets with updates.
• Manage all the defects through Jira and link them to the associated tickets for tracking.
• Communicate/manage offshore QA team to perform Integration testing of the UI/Dashbords
• Updated QA status on the daily stand up meeting (Ajile) and discussed testing progress/issues/road blocks with QA lead/Dev leads.

Environment/Tools: Windows 7,Unix, MySQL workbench, Tableau, Pentaho, Jira, Amazon Redshift, MongoDB, wiki, sharepoint, Google docs, Confidential office tools.

Confidential, San Ramon, CA

ETL QA Tester

Responsibilities:

• Created Test plans and Test cases by understanding the BRD specifications and Mapping documents.
• Validated the data across different layers (Source/file to Stage, Stage to ODS, ODS to Target) based on the mapping document.
• Validated SRC to TGT data for Bulk and Incremental loads from various front end cross BU applications.
• Most of the source data will be in the form of flat files and are acceced via unix dev box location and some source db’s accessed via citrix server.
• Validated the (Inbound - Outbound) stages, Stage to ODS and ODS to Target data and captured counts, validated all the direct and derived columns(per ETL logic) using Toad for Oracle.
• All stages are validated for data discrepancy, record counts, completeness, table counts and column counts, duplicates, unique value, referential integrity, end to end business scenarios and initial and incremental load testing, negative and positive test scenarios. etc.
• Validated data from Stage to Datastore for each cycle date and verified the stage rolling window for each project.
• All the defects are logged as per the LOB’s in ALM/QC and then will be triaged in the daily defect tracking meeting.
• All test artifacts(test cases, test results, test scripts, defect analysis,defect reports) are uploaded into sharepoint portal to after the official QA sign off to production.

Environment/Tools: Windows 7,Unix, Toad for Oracle, Informatica, HP QC ALM, WinSCP, Sharepoint, Confidential Office tools.

Confidential - Redmond, WA

SQL BI Tester

Responsibilities:

• Created Test plans and Test scenarios by understanding the business requirements/Impact Analysis documents.
• Worked on restoring the production data backup to SIT and then captured the counts of data before and after the deployment.
• Ran the Simulate scripts and jobs via SQL server agent to generate the test data and verified the test scenarios in SIT.
• Verified the Config files, User access permissions for accessing views, running and testing of SSIS jobs.
• Validated the Source to Target data and captured counts(accumulated table and aggregated table) for all the incremental builds.
• Worked on Stored Procedures, Views to analyse the code and performed DML operations on the Source and Target to validate the data changes.
• Verified the performance tuning of exception traking stored procedures on multiple scenarios.
• Logged bugs in VSTF, involved in Bug Triage meetings and then retested the fixed bugs in the next released incremental build.
• Reviewed the test cases with concerned partners and signed off and uploaded them in Confidential Test Manager.
• Worked on SIT/UAT to repro the test cases and then verified the Change requests/Bugs.
• Validated the different database objects in different environments whenever new builds are deployed.
• Coordinated with different stake holders during SIT/UAT.

Environment/Tools : Windows 8, SQL Server Integration Services (SSIS), SSRS, MTM, VSTF-2012, MPP, SSMS 2008R2 - 2014.

Confidential,Horsham, PA

Sr.ETL/DW QA

Responsibilities:

• Designed Test plans, Test strategies and Test Cases/scenarios for Enterprise testing and End to End testing as per the business and functional requirements.
• Tested data warehouse extraction, transformation and load (ETL) process. Worked with UNIX and DB2 databases. Generated test data using SQL statements. Developed and executed SQL queries in support of Data warehouse data migration and retrieval.
• Created test cases to cover the Change Data Capture(CDC) for incremental data loads for ISDW Target for the New Inserts, Updates and deleted rows.
• Validated the ICD-10-CM codes against ICD-9 codes using Backward Crosswalk mapping.
• Validated the UCPS(Claims data) diagnosis lookup table against the ISDW target system and all the data is in sync with CMS Diagnosis code file.
• Validated the Member, Claim and Pharmacy data related to Medsupp and Rider Datasets which were extracted from ISDW for all active members and delivered to Optum health(Ingenix) on monthly basis.
• Validated the data integrity and accuracy, Count, Error handling, email notifications and scheduled jobs of loaded data in the target database system.
• Analyzed and created test data using SQL queries to Insert and Update the data from the source to target databases.
• Exexuted SQL queries for Comparing record counts, Boundary value analysis, Duplicate values, Unique values of key fields, Number check, Date check and null check after loading target tables.
• Using SQL queries, validated scenario testing and data mapping testing between the source system and target systems.
• Automated regression test suites using Selenium.
• Provided traceability matrix. Mapped the requirements to tests, tests for defects. Collected Test Metrics. Managed test case development, execution and bug tracking using Quality Center.
• Updated the Confidential Project Plan for the identified tasks for all testing activities.
• Provided weekly status reports, escalated quality concerns during team/1-1 meetings with the project manager.

Environment: Windows 7, Unix, Microstrategy, Quality Center, Selenium, TrackWise, MPP, SQL SERVER 2012, Oracle, Toad for DB2 and Netezza .

 Confidential, Audubon, PA

Sr. DWH Tester

Responsibilities:

• Performed functional, regression testing of Almac's projects (AIR Reports and NPS projects) including writing test plans, test cases and trace matrix as applicable.
• Tested NPS Products and applications like Prompt Manager, Clincard/AMS, Web IXR, Almac aXcess Reports and World Time Service Update project, Core Cognos reports and AIR reports.
• Tested Almac’s Interactive Reports (AIR) developed on Cognos and Confidential SQL Server Analysis services and Integration services (SSAS & SSIS).
• Creation of Test Data Using IXRS, Test Data Creation Tool, Gateway and SQL server 2008.
• Extensively worked on business requirements, system requirements, data mapping requirement specifications, and responsible for documenting Test cases in Quality Center.
• As part of the Agile testing methodology, Involved in all sprint reviews and retrospectives, contributed to the process improvement.
• Testing for various mappings and verified field by field data and data integrity among various sources and targets.
• Customized SQL queries to check the source/target data and verified the total record count.
• Testing/Validation of Data Extraction Logic, Data Transformation Logic (including testing of Dimensional Model - Facts, Dimensions, Views etc)
• Data Loading, Tested end to end data flow from source to mart to reports (including calculation logics and business rules), Checked for accuracy, completeness (missing data, invalid data) and inconsistencies.
• Tested Webservies for Alamc Messaging System (AMS) and Clincard projects.
• Verified Almac sending patients an SMS or Email indicating their Clincard has been assigned or replaced
• Verified and tested Integration with the AMS system to provide the ability to send patients Clincard related communications via SMS(On Almac’s Blackberry Mobile) or email.
• Created Quick Reference Cards (QRC) for the queries that help with the data validation.
• Validating the reports like Dashboards, List, Crosstab and charts, Ad-Hoc Reports.
• Wrote SQL Queries to test the reports for number of Filters, Prompts, Calculated expressions, Drill Throughs, Master Detail Relationships.
• Responsible for running SQL scripts to create the database structure and populating tables with relevant test data.
• Running the ETL Job for refreshing the data in Cognos reports. Running the IQ for every new or sub release for the defects fixed in Dev.
• Logged defects against the application in Rational Clear Quest and participate, assist in client audits as required.

Environment: Windows 7/ XP, Unix, Cognos 8.4.1, SQL Server Integration Services, HP Quality Center, Rational Clear Quest, Rational Clear Case, Unix, SQL SERVER 2000 and 2008 , Gateway, Master Control, IQ Assistant, Test Data Creation Tool, Altova XMlSpy.

Confidential, Atlanta,

GA DWH Tester

Responsibilities:

• Developed Test Plan, Test Cases based on Functional Requirement Specifications (FRS) and System Requirement Specifications (SRS).
• Developed Test specifications and test plans for ETL and BI Reporting.
• Tested and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Utilized INFORMATICA Power Center designer to analyze mapping, sources, source transformations, expressions, sequencers, normalizes, filters and targets
• Tested several Informatica Mappings which will populate the data into dimensions and Fact tables.
• Validated workflows, sessions and WORKLET to check in and check out and verifying the data loaded into the Data Warehouse.
• Validating the reports like List, Crosstab and charts. Testing the reports for number of Filters, Prompts, Calculated expressions, Drill Throughs, Master Detail Relationships.
• Checking for the sorting order and Grouping applied on the columns. Running the SQL queries against the database using Toad and checking the data integrity.
• Responsible for Testing, Defect Tracking, Logging and Regression activities
• Checking the formatting and standard fonts through all the report pages.
• Wrote SQL Queries using TOAD to ensure data quality and data integrity for Back-end testing.
• Tested Stored Procedures for the application using SQL Server 2005.
• Logged and tracked defects using Mercury Quality Center.
• Worked extensively with Business Analysts, Developers and Project Managers in resolving issues critical to the business.
• Tracked and reported upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
• Prepared and submitted various metrics for the project

Environment: Windows 2000, Quality Center 9.2, Impromptu v7.4, Cognos 8.4BI, Cognos v8.1BI, PowerPlay Transformers, Informatica 8.1.1, SSIS & SSRS, Unix, Teradata, SQL Server 2000 & 2008, MS Office Tools.

Confidential ,Dixfield, ME

DWH Tester

Responsibilities:

• Reviewed the Software requirements specification and detailed design documents.
• Created Test Plan, Test cases, Test scripts for testing the application.
• Created Requirements traceability matrix by mapping requirements to test cases using QualityCenter.
• Performed Functional and Regression testing of application using.
• Extensively worked on complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures of the data between various applications.
• Thoroughly tested huge volumes of Data extraction and uploading into Oracle using WinSQL and troubleshooted mappings and workflows
• Testing of Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Checking for prompts, Filters, Calculated expressions, sorting order and grouping used in the report for any errors. Checking the fonts, alignment of the report.
• Wrote SQL Joins and Nested Queries on various data tables for Data validation.
• Validated data integrity of the tables by testing Stored Procedures, Functions.
• Performed Compatibility Testing, Installation Testing, UAT Testing
• Used Quality Center for Defect tracking and reporting.
• Participated in test case review, defects review meetings and requirements walkthroughs.
• Interacted with developers, Business analyst to resolve technical issues.
• Maintained Test Logs, Test Summary reports and participated in defect review meetings, walkthroughs.

Environment: Windows 2000, UNIX, Quality Center 9.0, Informatica 8.1.1, Cognos 8.2/8.1,Win SQL, Impromptu, Framework Manager, Oracle 9i, SQL Server 2005.

Confidential,St. Louis, MO

QA Analyst

Responsibilities:

• Developed test cases for the Quick Quote and Lead Management System applications, user account management and bill payment modules.
• Involved in System Testing, Regression Testing and Functional Testing, Integration testing
• Wrote test scripts using QTP VBScripts for data driven, functionality and regression testing.
• Developed VB Scripts using reusable actions, Shared Object Repository, descriptive programming, worked with data tables, Environment Variables etc.
• Assisted in setting up the Test environment. Tested role based authorizations in the application.
• Developed, maintained and executed test cases and test scripts using Quality Center
• Conducted back end tests on database server using complex SQL queries to validate the data.
• Generated VU scripts, scenarios using LoadRunner for load and stress testing.
• Analyzed application response time, throughput using Analyzer.
• Tested web services returning drivers and vehicles history using QTP.
• Identified, analyzed, and documented defects in Quality Center
• Prepared defect reports & test metrics for walkthrough sessions

Environment: QTP 8.2, Quality Center 8, LoadRunner 8.1,C#, VB, ASP.Net, XML, HTML, DHTML, VBScript, Oracle 9i, Windows XP