SUMMARY:

• 7+ years of experience in RDBMS technologies like Oracle 8.x/9.x/10g/11i/11g, DB2, SAS, MS SQL Server 2012/2008/2005 and Teradata.
• Around 7 years of experience in data warehouse concepts and technologies like OLTP, Normalization/Denormalization, ETL, OLAP, Data Models (Star/ Snow Flake Schemas), Datamarts (Dimensions and Facts) and Reporting.
• Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Good Experience in HIPAA /EDI Transactions and mainly focused on 835/837 and 277/276 Transactions.
• Strong Understanding of Healthcare Business and have good knowledge of Members, Provider, Enrollment and Pharmacy claims.
• Extensive experience in ETL/ Data warehouse backend testing and BI reports testing.
• Extensive experience with Functional, GUI, Database testing, Web testing.
• Experience in Business Intelligence testing in various reports using Cognos, SSRS.
• Strong background in QA/ETL with development and execution of Test Cases and Test Scripts.
• Extensive Experience with the Utility Tools like TOAD, AQT, Teradata SQL Assistant, DB2 client, SQL Server Management Studio, SQL Developer, SQL* Plus, SQL*Loader, SQL Query Analyzer and Rapid SQL.
• Experienced with ETL tools like Informatica, DataStage and Ab Initio GDE.
• Experienced with Test Plan, Test Case, Test Script, Change Request and Defect Request.
• Extensive experience with Unix commands and VI Editor, Bash Scripting.
• Extensive experience with Reporting Tools like Cognos, Micro Strategy, SSRS, OBIEE, and Business Objects.
• Expertise level knowledge in entire software development lifecycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM design methodologies.
• Familiar with Excel for developing Requirements Traceability Matrix (RTM) and Capturing and Updating Change Requests.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Familiar with managing the defects and change requests through Testing Tools like Quality Center/Test Director, Clear Quest and StarTeam.
• Excellent experience with SQL concepts like DDL, DML, Sub queries, Joins, Set operators and Conditional expressions, Temporary Tables.
• Experienced in querying the databases by developing and running SQL and PL/SQL queries using utilities like DB2 client, Toad and SQL Query Analyzer.
• Documentation of Test Case, Test Scripts and Results using Excel.
• Experienced with Transformations like Filter, Joiner, Union, Router, Look up and Sorter.
• Experienced with System, Integration, Regression and User Acceptance Testing.
• Excellent problem solving, interpersonal, and communication skills.
• Experienced with data load into EDW tables in QA environment and Production.
• Ability to effectively and professionally communicate, both orally and in writing, while also articulating and translating technical language to non-technical customers

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.2/8.0, Test Director, Clear Quest, HP ALM 12.00/11.52/11.00, JIRA 7.1.9/7.3.4, Polarion ALM 17.1

Databases: Oracle 8i/9i/10g/11i/11g, SQL Server 2012/2008/2005, MS Access, DB 2 9.7/8.0/7.0/6.0, Teradata 14.0/V2R5/V2R6/15.10, Netezza 7.0.2/3.0.5, SAS 9.4

Utility Tools: Agility Workbench 4.3, TOAD 8.5, Teradata SQL Assistant, DB2 client, SQL Server Management Studio, SQL*Plus, SQL*Loader, SQL Developer and SQL Query Analyzer, Advanced Query Tool, WRQ Reflection, Ultra Edit, Win merge, SAS Enterprise Guide 4.3.5

ETL Tools: SSIS, Informatica 9.5/9.0, DataStage 8.7/8.0/7.1, Ab Initio 3.0.4

Reporting Tools: Cognos 10.2.2, SSRS, Business Objects, Micro Strategy, OBIEE

Operating Systems: Windows 95/98/2000/XP, Vista, 7, Linux and UNIX.

Microsoft Office: Excel, Access, Outlook and Power Point, MS Visio, Word, Lotus Notes

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, Java, Unix Bash Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. ETL/Manual QA Analyst

Responsibilities:

• Worked closely with Actuarials and Developers to gather Application Requirements and Business Processes in order to formulate the test plan.
• Developed and maintained innovative, repeatable QA test plans based on functional requirements, use cases, user interface designs, system design documents and domain knowledge.
• Good understanding of Life Insurance applications and concepts.
• Worked in both waterfall and agile environments.
• Created high level strategy documentation and detailed test documents.
• Collaborate with System Architect, Developers, Business analysts and SME’S to identify and prioritize areas requiring testing as well as areas requiring code review and design review.
• Analyzed and translated business requirements into Test Cases.
• Used JIRA to create Defects and Quality Center to document steps for manual implementation of test cases.
• Performed User Acceptance Testing and System Integration Testing manually.
• Performed Front-End UI (User Interface Testing) to check if the application is user friendly to access by users and also as per the requirements.
• Wrote SQL queries for each test case to validate the data between Source system, Data Warehouse, Data Marts and Reports.
• Conducted the Functional, System, Integration, Regression and performance testing of the Web application.
• Developed data quality test cases for ETL user stories and manually executed test cases by writing complex SQL queries using Sql Server Management Studio.
• Performed the Back-End testing to ensure data consistency on Front-End by writing and executing SQL queries on the database.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Involved in Setting up the Data for Integration and End-to-End Testing.
• Involved in Preparing the Status Reports every week which includes Revision History, Test Case status, Metrics and QA Defects.
• Tested the ETL transformations using complex SQL queries.
• Used HP ALM and Polarion to document user stories and test cases and link them to requirements.
• Performed Backend Testing for the SQL Server database related applications.
• Attended daily sprints calls and updated the project team on the progress of the testing and defects identified.
• Attended Weekly Status Meetings with QA Manager to report the QA Team work progress.

Environment:: SQL Server 2012, JIRA 7.1.9, Confluence 5.10.1, HP ALM 11.52, Polarion ALM 17.1, SQL

Confidential, Minneapolis, MN

Sr. ETL QA /Data Analyst

Responsibilities:

• Reviewed the Business Requirement Documents, High Level Design Documents and project artifacts for understand the process.
• Performed data analysis and presented findings to architect and team to improve strategies and develop design.
• Used advanced Microsoft Excel functions like VLOOKUP, IFERROR and other Excel macros to perform data analysis
• Performed data profiling to understand the data behavior and document the scenarios.
• Performed production validation on high volume of data (4 billion rows)
• Experience working in multiple projects with different business lines like Confidential claims, payment changes.
• Prepared Master Test Plan from the Business Requirements, Functional Specifications and High-Level Design Document.
• Strong Experience in writing Test cases, Test scripts, Test plans and execution of test cases
• Good understanding of Confidential, banking, financial, credit card, servicing domain process and terminology.
• Worked on the large number of JIRA tickets and also emergency production fixes.
• Performed System testing, Regression testing, Production validation and assisted in UAT testing.
• Worked with different databases and validated the data from Flat files to Teradata tables and Oracle tables to Teradata tables.
• Extensively used Ultra Edit for file transfer, data profiling and validation of flat files (CSV, XML,.TBL).
• Used SQL Developer to create and execute the queries for Oracle database tables.
• Worked in Agile Methodology and participated in weekly sprint planning sessions.
• Worked with Rollup logics and Very large amount of data of the Confidential claims.
• Experience in Agile methodologies and Participated in daily scrum meetings.
• Writing the test cases covering the complete programming logic.
• Experience in using Teradata SQL Assistant for writing SQL Queries and executed them for Backend Testing.
• Experience in using analytical function like RANK, ROW NUMBER, ORDER BY in sql.
• Experience in using Unix basic commands like Grep, Awk, Sed and Diff.
• Created Bteq, Fload, Multi-Load scripts to load the data into the Teradata tables.
• Worked with different types of Slowly Changing Dimensions (SCD).
• Used Joins, Set operators, Case statements, aggregate functions and various analytical functions in SQL scripts.
• Validated Flat files by writing Unix Shell and bash Scripts.
• Used SAS enterprise guide to load the flat files extracts and created proc sql scripts to validate data.
• Experienced in creating test cases, test scripts and documenting the test results using JIRA.
• Wrote the complex SQL queries to validate the initial and incremental ETL loads.
• Used Teradata SQL Assistant to write SQL and query the Teradata database tables.
• Participated in Daily QA touchpoint meetings with QA manager to discuss the QA tasks.
• Prepared the defect status report and reviewed with the team in the project status meetings.
• Assisted developers in performance tuning and creating Teradata merge queries.
• Interacted with developers to resolve the ETL defects.

Environment:: Teradata 15.1 0, SQL, Teradata SQL Assistant 15.1 0.1.4, Ultra Edit 18.0, Unix bash Scripts, BTEQ, FLOAD, MS Office, SAS 9.4, JIRA 7.3.4, SAS Enterprise Guide, Oracle 11G, SQL Developer 3.2.09

Confidential, Loveland, CO

Sr. ETL/BI Tester

Responsibilities:

• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from ETL and BI teams.
• Responsible for validation of target data in Data Warehouse and Data Marts which are Transformed and Loaded using Datastage .
• Executed and managed test cases and reported bugs in HP ALM.
• Participated in User Acceptance testing (UAT) and involved in creating test cases, executed test cases, Documenting Defects, resolved defects and Signed Off from Application.
• Developed Complex SQL queries according to the ETL mapping and Reporting requirements.
• Validated Cognos Reports, which would facilitate decision-making. The reports designed were complex and used formulas, parameters, selection criteria etc.
• Extensively tested several Cognos Reports - Cognos reports and Dashboards to validate the data and cosmetics of the report.
• Extensively worked on validating various types of Cognos reports like drilldown, drill through, burst reports, cascading, prompted reports etc.
• Developed SQL scripts to validate the data between database tables and reports data for backend database testing.
• Validated data in between source and target after running Mappings by the Datastage developer team.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration/Cognos Server upgrade.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Conducted Functional, Regression, System testing and End-to-End testing.
• Worked on issues with migration from development to testing.
• Validated data between cross database tables from SQL Server to Netezza using SQL server management studio and Agility workbench.
• Validated data transformations, aggregations, cosmetics changes in the reports and ensured they are as per the requirements and reports specifications document.
• Worked extensively on Service Now tickets and participated in meeting with business and developers for updating the status and issues.
• Verified the performance of the burst reports.
• Involved in validating the aggregate reports based on the rollup process documented in the data mapping.

Environment:: SQL Server Management Studio 2008, Netezza 7.0.2, Cognos 10.2.2, Agility Workbench 4.3, HP ALM 12.0, SQL, DataStage, PeopleSoft

Confidential, Eagan, MN

Sr. ETL QA Analyst

Responsibilities:

• Worked with SME's to understand the business process, identify gap in requirements, identify bottlenecks and work on improvements followed the AGILE methodology.
• Did testing on SAS datawarehouse by writing complex SAS Programs.
• Used SAS Enterprise Guide for Writing the Proc Sql Programs and Testing the claims data.
• Did Functional Testing, Regression testing, Back-end testing.
• Created and exec uted test cases using HP ALM.
• Used AQT for writing SQL queries and executed them to test the data in DB2 tables.
• Developed the Test Scripts and reviewed Test Cases with the Systems Analyst.
• Generated manual scripts for functionality and regression testing and executed them.
• Expertise in Using Quality Center for maintaining the Requirements, Test Plan, Test Cases, Test Lab, Defects and generated graphs and reports based on the user needs or test metrics.
• Created the test data and executed the test cases for the application.
• Developed Requirement Traceability Metrics (RTM) using Quality Center.
• Ran the ETL jobs and reviewed the session log files using Datastage Director.
• Tested Pre-Engine, Post Engine and ETL load files Created using Datastage.
• Involved in UAT to satisfy business needs.
• Preparation of Test Data for Regression testing.
• Analysis of requirements and participating in Technical and Functional Requirement review meetings.
• Developed complex SQL queries.
• Performing Back-End Testing and executed SQL Queries for validations
• Developed and implemented a well-defined testing methodology.
• Actively participated in the daily scrum calls and maintenance issues with the development team.
• Identified defects during test executions, logged them into Quality center’s Defect module for bug tracking and generated defect reports.

Environment:: DB2 9.7, SAS, Datastage, AQT 9.1.3, HP ALM 11.0.5, SQL, UNIX, Windows 7, Office 2013

Confidential, Minnetonka, MN

Sr. ETL/DWH QA Analyst

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Reviewed the Project flow Documents, Data model, BRD’s and functional specification documents.
• Experience in writing Test cases, Test scripts, execution of test cases in HP ALM.
• Experience in wiring the Complex SQL queries for SQL Server database.
• Experience in converting the SQL Server queries to Oracle queries.
• Experience in Agile methodologies and Participated in QA scrum meetings.
• Writing the test cases covering the complete programming logic.
• Experience in using TOAD for Writing SQL Queries for Oracle database and executed them for Backend Testing.
• Extensively used SQL Tuning to improve performance.
• Used With statement for creating temporary tables in the queries to improve the query performance.
• Wrote complex SQL queries using SQL Server Management Studio .
• Validated Prompts, filters, calendars and Cosmetics in reports.
• Experience is using the Informatica Power center Designer for checking the Mappings, Mapplets, understand the logic.
• Used various Sql commands like charindex, instring, convert, datetime for validating data between Oracle and SQL server.
• Used Informatica Powercenter Designer to verify the transformation logics with mapping specs.
• Worked with developers in finding out the issues in the code and STM document.
• Used Informatica Workflow Monitor for reviewing session log files.
• Written test cases to validate the ETL Informatica mappings and mapplets.
• Experienced in using Informatica Power Center Workflow Manager for running workflows.
• Used Inner join, Outer Join, Self-join, Set operators, Case and with statements in SQL scripts.
• Wrote SQL Queries for different types of slowly changing dimension transformations.
• Used PL/SQL function to validate some test scenarios.
• Experience working with tables having large amount of data.
• Experienced in creating test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center/HP ALM.
• Written the complex SQL queries to validate the History and incremental ETL loads.
• Preparing the QA status report and updating the report in the project status meetings with project managers.
• Experience in using HP ALM for creating the defects and creating the defect reports, dashboards for analyzing defect percentage and status of project.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Develop test scripts and test cases for financial dashboards and reports being developed in OBIEE
• Participated in daily status meetings to discuss the defects and project updates.
• Worked with developers to analyze and fix the ETL issues.
• Enthusiastic team player, with excellent communication and interpersonal skills.

Environment:: Oracle 11 g, SQL Server 2012, Informatica 9.5, OBIEE, Quest TOAD 11.0, HP ALM 11.0, SQL, UNIX, Windows 7, Office 2013

Confidential, Minneapolis, MN

Sr. ETL/Manual QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Experience working in multiple projects.
• Prepared Master Test Plan from the Business Requirements and Functional Specifications.
• Strong Experience in writing Test cases, Test scripts, Test plans and execution of test cases
• Good understanding of healthcare business process and terminology.
• Worked with Rollup logics and Very large amount of data of the claims.
• Experienced in defining, creating and implementing testing process and methodology for onsite/off-shore team.
• Highly Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
• Experienced in working with Members, Provider, enrollment and Pharmacy claims.
• Experienced in creating test plan documents and also assisted in writing the test plan that includes Scope, risk, assumptions and test methodologies.
• Experience in Agile methodologies and Participated in QA scrum meetings.
• Experience in using Teradata SQL Assistant for Writing SQL Queries and executed them for Backend Testing
• Created complex SQL queries using Teradata SQL Assistant.
• Creating and executing SQL queries to validate test data using Advanced Query tool.
• Created and Ran Unix Bash Scripts to validate the flat files.
• Reviewed the HIPAA EDI transaction based on the implementation guide
• Validated Prompts, filters, calendars and Cosmetics in reports.
• Experienced with Unix basic commands like Grep, Awk, Sed and Diff.
• Experienced with Informatica Workflow Monitor for reviewing session log files.
• Written test cases to validate the ETL Informatica mappings and map lets.
• Experienced with Informatica Power Center Workflow Manager for running workflows.
• Written SQL Scripts to query the Teradata and DB2 database tables.
• Worked with various EDI transactions like 834,835,837,276,277 in accordance with HIPAA standards.
• Validated Flat input source extract files by writing Unix Shell Scripts.
• Responsible for testing Business Reports developed by Business Objects XIR2
• Tested Business Objects reports and Web Intelligence reports
• Implemented the HIPAA privacy and security regulations to enhance the capabilities of the systems
• Experienced in creating test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center/HP ALM.
• Written the complex SQL queries to validate the initial and incremental ETL loads.
• Used Ultra Edit to sftp the files and editing the flat files such as CSV, XML and other delimited flat files.
• Used Advanced Query tool for Data Analysts to compare DB2 and Teradata result sets.
• Used Teradata SQL Assistant to write SQL and query the Teradata database tables.
• Participated in Daily QA Scrum with QA manager to discuss the QA updates.
• Preparing the QA and defect status report and updating the report in the project status meetings with project managers.
• Experienced with HP Quality center and HP ALM for managing the defects and querying the Quality center for pulling Defect status reports.
• Interacted with developers to resolve the ETL and reports defects.

Environment:: DB2 9.7, Teradata 14.0, SQL, Datastage 8.7, Teradata SQL Assistant 13.0, Advanced Query Tool, Ultra Edit, FTP Client WRQ Reflection, Unix bash Scripts, Quality Center 9.2, HP ALM, BI Reports, Business Objects XIR3.

Confidential, Atlanta, GA

Sr. ETL/DWH QA Analyst/Data load specialist

Responsibilities:

• Working in DW - ETL Testing project, responsible for understanding the Business Requirements/Project Specifications.
• As a Test member involved in the requirement gathering, effort estimation, planning, execution and implementation.
• Worked with slowly changing dimensions (SCD), Change data capture (CDC) and Relation database systems.
• Worked in mainframe environment and actively participated in analyzing the source data.
• Manually executed the jobs and scripts in UNIX to load the historical data into EDW.
• Prepared test cases for source to staging and staging to target based on the source to target mapping document.
• Involved in Validating Slowly Changing Dimension type 1, type2 and type 3 based on the requirement.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Assisted team lead in developing the Test plan as per the business requirements document.
• Performed test execution by writing and executing complex SQL queries in TOAD, DB2 client.
• Prepared test cases related to Data load testing based on different complex scenarios provided by Development team.
• As per the requirement of the testing team created files in UNIX using VI editor based on the scenarios and loaded them into tables to test the scenarios.
• Actively involved in analyzing the data load issues and job failures by checking the logs, Source files, clean and Integration files.
• Actively participated in Daily status meetings with Development team, DBA’s and business users to understand the requirements and discuss the issues and concerns.
• Involved in verifying the logs on server and checking the Graphs and logic conditions applied in Ainitio GDE.
• Executed the graphs from Ab initio GDE and command line.
• Created number of defects in Clear Quest tool and coordinated with development team for defect fixes.
• Tested Cognos reports by comparing it with legacy systems reports for data validation.
• Validated prompts, filters and other features in Cognos reports.
• Tested functionality and non-functionality of reports developed by Cognos.
• Coordinated the defect tracking process in Clear Quest tool and provide the test metrics.
• Reviewing the Test Cases & Execution Logs to ensure the test coverage.
• Involved in preparing daily and weekly status reports and discussing it in the daily and weekly status calls.
• Worked in Onsite-Offshore model.
• Prepared Data load and Job failure analysis KT document and explained offshore team members.

Environment:: Oracle 10g, DB2, Ab intito GDE 3.0.4, Cognos, Quest TOAD, Clear Quest, SQL, UNIX, Windows XP.