Ram

ac6exs@r.postjobfree.com

631-***-****)

PROFESSIONAL SUMMARY

Over 10+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, and Client-Server Systems and Applications for Banking, Insurance, Financial, Hospitality, and Retail Industries. In depth technical knowledge and understanding of Data Warehousing, Data Validations, Test data creation, OLAP, SQL Server, Informatica, Abinitio, Hadoop, Oracle, ETL and BI Reports. Experience in Defining Testing Methodologies, creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).

PROFESSIONAL EXPERTISE

Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

Good experience in Data Modeling using Star Schema and Snow Flake Schema

Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality. Provide technical know-how, support, mentoring & coaching team members on technology,business & other project specific aspects

Well-versed in ETL processes, performance based systems, and ETL process flow and standards

Having good experience on Banking (BFS), Insurance and Health Insurance domain

Extensively Involved in testing the claims and membership validations in the datawarehouse

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

In-depth knowledge of Enterprise Data warehousing ETL, Data warehousing requirements, and Enterprise level data warehousing

Familiar with UNIX, SQL, BI tools, agile methodologies, and oracle data base

Comprehensive knowledge of Functional using Test Management Tools and Defect Management Process

Extensively used ETL methodology test for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools

Good experience in data sources, data profiling, data validation, Source to Target validations, developing low level design patterns based on the business and functional requirements.

Good experience in Data Modeling using Star Schema and Snow Flake Schema

Good exposure to Data subset and Masking techniques

Experienced in creating/mocking Test Data

Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server

Involved in Training on Hadoop concepts and eco systems

Excellent programming and problem solving skills having worked on C, C++, VB, SQL, PL/SQL

Extensive knowledge in regression testing and design documentation.

Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.

Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

Excellent communication, analytical and interpersonal skills

TECHNICAL SKILLS:

Database: Hadoop 2.0, Teradata V12.0, Oracle, SQL Server.

Change Mgt Tools: Test Director, Quality Center, VSTF 2008

Data Warehouse Tool: Informatica Power Center, Informatica ILM,SQL SERVER 2005/2008,

Business Objects XI R2 / 6.5, MS DTS Packages

Functional Test Tools: Selenium, UFT,WinRunner, Quick Test Pro, JIRA,BugZilla

Languages: PL/SQL, T-SQL, SQL, XML, Visual Basic

Office Tools: MS Office Suite, MS Project, Microsoft Share Point.

Operating System: UNIX, Windows

Rational Tools: Requisite Pro, Clear Quest, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server.

Tools: TOAD, SQL SERVER 2005/2008

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL PROJECTS

Ally Financial, MI Jan 2016 – Till Date

DWH Lead Analyst

Responsibilities:

Reviewed the Business Requirement Documents and the Functional Specification

Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.

Involved in Data Masking and Scrubbing for Test Management Process.

Experience with Test data creation or Test Data Management.

Involved in implementation of the Test plans, Test cases and Test Scripts.

Tested the data and data integrity among various sources and targets.

Involved in entire SDLC of the projects from Initiation to Implementation

Identify the Test data from source systems to satisfy all testing scenarios for System Testing

Conducted Defect walk through with the development team for clear understanding for defects

and to make it to closure

Plan, Organize, Direct and Execute the test process and releases.

Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.

Working closely with Quality Assurance Senior Management and Operations Counterparts to manage the Data Automation and Data Testing effort.

Tested the modified STMs due to source system updates.

Testing ETL sessions for multiple feeds and multiple LOB’s.

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Worked with Business analysis team to prepare a detailed Business Requirement document

Involved in Hadoop testing with HDFS File systems.

Involved in Rebuilt of critical source systems and proposed many code changes.

Preparation of ETL mapping specifications.

Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.

Involved in Automation testing using HP UFT Tool.

Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).

Experienced in writing complex SQL queries for extracting data from multiple tables.

Reviewed test scenarios and test cases on a regular basis to ensure that the test cases are most current and in accordance with changes in requirements.

Analyzed and communicated the impact of requirements changes on testing deliverables.

Developed Tractability Matrix and Test Coverage reports

Testing has been done based on Change Requests and Defect Requests.

Involved in preparation of System Test Results after Test case execution.

Effectively coordinated with the development team.

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Created critical scenarios for each change request and defect request.

Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.

Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.

Used various SQL queries to validate the test case results for back-end test cases.

Prepared weekly status reports showing the issues to be resolved in MS excel.

Environment: Quality center, Oracle 11i,JAVA,Windows NT,Hadoop,Hive,Netezza,Informatica Power Center ETL,Informatica ILM,XML, HP UFT,HTML Script, VB Script, ASP, MS Access, MS Excel.

Liberty Mutual Insurance, NH Oct 2014 – Jan 2016

DWH Lead Analyst

Responsibilities:

Involved in Business analysis and requirements gathering.

Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.

Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.

Involved in implementation of the Test plans, Test cases and Test Scripts.

Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.

Tested the data and data integrity among various sources and targets.

Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.

Tested the entire data reconciliation process for multiple source and target systems.

Design and document Data warehouse (EDW) testing strategy covering the test cases for validating the data completeness and correctness, system performances of the ETL processes etc.

Scheduling triage meetings to keep track and level of severity defects and communicating it

Project Managers with Execution Score Card with defect Status .

Preparation of ETL mapping specifications.

Managed and conducted System testing, Integration testing and Functional testing

Reviewed Informatica mappings and test cases before delivering to Client.

Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.

Expertise working with Off-shore team and assigning testing responsibilities and follow up till test completion and reporting the status to Project Manager. Responsible for updating the weekly reports.

Coordinates test environment configurations and maintenance

Expertise with testing XML web services in SOAP UI

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).

Involved in ETL Mapping Design and Performance tuning to Load mapping process.

Experienced in writing complex SQL queries for extracting data from multiple tables.

Reviewed the test cases written based on the Change Request document.

Testing has been done based on Change Requests and Defect Requests.

Involved in preparation of System Test Results after Test case execution.

Effectively coordinated with the development team.

Created critical scenarios for each change request and defect request.

Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.

Managed all phases of testing (unit, regression, system and user acceptance testing) to ensure the test deliverables are met on time

Used various SQL queries to validate the test case results for back-end test cases.

Well exposed to Software Development Life Cycle and Test methodologies.

Environment: Quality center, Oracle 11i,JAVA,Windows NT,Hadoop,Hive,Netezza,Informatica Power Center ETL,XML, HTML Script, VB Script, ASP, MS Access, MS Excel.

Auto Trader, Atlanta, GA July 2012 – Oct 2014

DWH QA Analyst

Responsibilities:

Analyzed the system requirement specifications and developed Test Plan, Test

Scenarios and Test cases to cover the functionality of the application.

Understanding the Requirements and Functional Specifications of the application.

Developed detailed Testing Methodologies, Test Matrices, Test cases and Test

Scripts

Analyzed the file system in HDFS and data in Hive.

Validated the data aggregation and data integrity in targeting system.

Participation in peer review sessions to baseline Technical Requirements, High

Level Design, Detail Design, Test Scenarios, and Test Scripts that involves Project

Manager, Business Analyst, Developers and Testing Team

Involved in Testing, Debugging, and Bug Reporting & Documentation

Documented test execution results, test reports, and gathered and evaluated test metrics for reporting.

Involved in Training on Hadoop concepts

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Written several shell scripts using UNIX Korn shell for file transfers and cleanup process.

Tuned ETL jobs/procedures/scripts,SQL queries, PL/SQL procedures to improve the system performance

Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.

Worked with Business analysis team to prepare a detailed Business Requirement document

Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing

Involved in writing SQL queries to check data integrity.

Implementation and using custom automated tools from cognizant like Platinum

Performed validation of ETL data in Hadoop

Tested reports developed by Microstrategy reporting tool for both Adhoc & Canned Reporting users

Prepared a UAT Plan and set up UAT environment.

Worked with Business analysis team to prepare a detailed Business Requirement document

Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team

Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team

Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.

Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings

Prepared weekly status reports showing the issues to be resolved in MS excel.

Environment: Quality center,Platinum,Oracle 11i,JAVA,Windows NT,Hadoop,Hive,Netezza,Informatica Power Center ETL,XML, HTML Script, VB Script, ASP, MS Access, MS Excel.

Independent Health, NY Nov 2010 – June 2012

Data Warehouse Analyst

Responsibilities:

Reviewed the Business Requirement Documents and the Functional Specification.

Developed System Test Plans, Test Cases and Test Scripts based on requirements and business documents

Developed unit test cases, configured environments, and prepared test data for testing.

Extensively worked on delta load process, incremental load and history load

As QA Analyst, involved in Testing, Debugging, and Bug Reporting & Documentation

Documented test execution results, test reports, and gathered and evaluated test metrics for reporting.

Coordinated the Onsite and Offshore teams to resolve issues.

Performed in testing various complex reports

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Clearly communicated and documented test results and defect resolution during all phases of

Testing.

Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings

Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOB’s

Involved in testing the functionality of ETL workflows.

Involved in performing testing of claims and Memberships level data through various datasources.

Performed data Analysis using Abinitio ETL Tool.

Tested Ab Initio graphs and used Ab Initio as an ETL tool to load the final loads.

Performed Validation in BI Modelling Snow Flake or Star Schema model.

Manual execution of Test Cases and verification of actual results against anticipated results.

Performed testing of the various reports in Microstrategy Reporting Tools.

Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.

Performed Validated reports like Drilldown and CrossTab reports

Extensively worked in UNIX and running the scripts.

Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.

Identified appropriate test data in relevant source systems and incorporated this data into test scripts.

Participated in frequently held Defect Meetings which included Project Management, QA, Prepared weekly status reports showing the issues to be resolved in MS excel.

Conducted focused audits (on specific process areas/practices) in as necessary

Documented test execution results, test reports, and gathered and evaluated test metrics for reporting.

Involved in writing SQL queries to check data integrity.

Worked closely with the development teams to replicate end user issues.

Environment:Abinitio,Qualitycenter,Oracle,WindowsNT,TeradataV12.0,Abinitio,Cognos,XML,HTML Script, VB Script, ASP, MS Access, MS Excel.

AETNA, CT Sep 2009 - Nov 2010

Data Warehouse Analyst

Responsibilities:

Reviewed the Business Requirement Documents and the Functional Specification.

Developed System Test Plans, Test Cases and Test Scripts based on requirements and business documents

Developed unit test cases, configured environments, and prepared test data for testing.

As QA Analyst, involved in Testing, Debugging, and Bug Reporting & Documentation

Performed Testing Reports developed for entering the customers.

Documented test execution results, test reports, and gathered and evaluated test metrics for reporting.

Performed in preparing, managing time estimates of testing schedule for a large scale Datawarehouse Projects.

Testing ETL sessions for multiple feeds and multiple LOB’s.

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Worked with Business analysis team to prepare a detailed Business Requirement document

Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing

Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, and Mapping Designer.

Worked with Informatica Power Center Workflow Manager to run workflows.

Reviewed session log files and source target statistics in Informatica Workflow Monitor.

Used Informatica workflow monitor to monitor workflow status.

Verified Informatica sessions, worklets and workflows in QA repository.

Performed testing of BI cube portal using Hyperion essbase excel addin.

Preventing occurrences of multiple runs by flagging processed dates

Written Test Cases for ETL to compare Source and Target database systems.

Testing of records with logical delete using flags

Coordinate between development team and business analysts to ensure developed code meets business needs.

Validate Claims data which is coming from Facets System to Source Systems

Data Validation from Difference Sources to Target data validation from Source (IDS) to Target(EDW)

Manual execution of Test Cases and verification of actual results against anticipated results.

Tracked and reported the bugs with Quality center.

Performed data-driven testing to read test input data from an Excel File so as to test the application with different positive and negative data

Performed regression testing after resolving the bug.

Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.

Performed backend testing using SQL queries.

Performed testing after installing the Product into the production environment

Prepared weekly status reports showing the issues to be resolved in MS excel.

Conducted focused audits (on specific process areas/practices) in as necessary

Documented test execution results, test reports, and gathered and evaluated test metrics for reporting.

Performed testing on FLOAD,MLOAD Teradata Utilities

Involved in writing SQL queries to check data integrity.

Executed multiple test scripts simultaneously using Quality center.

Worked closely with the development teams to replicate end user issues.

Environment:Quality center,Oracle,Windows NT,Teradata V12.0,Informatica Power Center,Hyperion essbase,XML, HTML Script, VB Script, ASP, MS Access, MS Excel.

Liquidnet,NY

Data Warehouse Analyst Oct 2008 – Aug 2009

Responsibilities:

Developed unit test cases, configured environments, and prepared test data for testing.

Wrote PL/SQL /Complex SQL queries for system testing

Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.

Worked with Business analysis team to prepare a detailed Business Requirement document

Involved in writing & implementation of the test plan, various test cases & test scripts.

Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications

As QA Tester, performing responsibilities with both the functionality and back end testing.

Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.

Worked with Production environment to resolve several data issues.

Tested several reports and automated using Quick Test Pro.

Written several Stored Procedures and modified existing stored procedures.

Involved with extraction routines to verify all the required data loaded into target systems.

Extensively executed SQL queries in order to view successful transactions of data and for validating data.

Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.

Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.

Create and Monitor workflows using workflow designer and workflow monitor.

Created test data and mock up data for testing purposes

Designed data flow and mapping design documents and designed ETL process to extract data

from sources and store them to staging tables and also designed ETL process to transform and

Load data into Data Warehouse.

Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports

Created the test data for interpreting positive/negative results during functional testing.

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Used SQL queries and custom programs to perform data validation.

Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.

Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.

Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.

Extensively involved with backend testing by writing complex SQL queries.

Environment: Oracle 9i/10g, SQL, PL/SQL, Teradata NCR,Stored Procedures, HTML, Java Script, SQL Server 2000, Oracle, Quick Test Pro 8.0, Quality Center 8.0, MS Office Suite, Informatica IBM Mainframe, RUP, TOAD, Rational Tools: Requisite Pro, Automation/Manual Testing

Microsoft, WA

Data Warehouse Analyst May 2007 – Sep 2008

Responsibilities:

Prepared Test Plan from the Business Requirements and Functional Specification.

Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.

Validated PDM to PDDM mapping document and PDDM to Report mapping document.

Logged Defects and tracked them to closure using VSTF.

Performed Functional, Regression, Data Integrity, System, Compatibility.

Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.

Used VSTF to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team. Ability to evaluate ETL/BI specification, verify it with ETL and BI systems.

Defined the Scope for System and Integration Testing

Identifying field and data defects with required information in data stage ETL process in various jobs and one to one mapping.

Prepares and submit the summarized audit reports and taking corrective actions

Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.

Performed testing for SCD Type 1,2,3 validations successfully

Document and publish test results, troubleshoot and escalate issues

Prepared Test status reports for each stage and logged any unresolved issues into Issues log.

Used T-SQL for Querying the SQL Server database for data validation.

Writing the test scripts for manual testing.

Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Performed database integrity check using SQL and Unix Shell Scripts

Involved with ETL test data creation for all the ETL mapping rules.

Performed DDL,Null Count and Record count verification sucessfully.

Tested stored procedures & views in MS SQL 2000/2005 .

Preparing and supporting the QA and UAT test environments.

Tested different detail, summary reports and on demand reports.

Performed database integrity check using SQL and Unix Shell Scripts

Worked closely with the development teams to replicate end user issues

Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Sql Server 2008, Metal (Meta Data Driven ETL), Sql Server Analytical Server, Sql Server Reporting Server, Microsoft Office Suite, Microsoft Share Point, Windows XP/NT/2003, BI Reports.

Contact this candidate