Suraksha Dhakal

ac7a4t@r.postjobfree.com

Ph:218-***-****

SUMMARY

7+ years of experience as ETL Tester

Experience in Various domains like Healthcare, Banking and Retail

Well versed in Software Testing Life cycle (STLC) and in-depth knowledge of Software Development Life cycle (SDLC)

Have work Experience in Waterfall and Agile development methodologies

Expertise in creating Test Cases and Test Scripts based on Requirements

Expertise in Smoke Testing, Back end Testing, Black-Box Testing, User Acceptance Testing (UAT), Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, GUI Software Testing, Ad-hoc Testing, Boundary Value Testing.

Expertise on various testing types like System testing, Regression testing, Functional testing, Integration testing.

Experience in testing both Initial and Incremental Load

Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.

Knowledge of different data models like star schema and snowflake schema

In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL, and ETL process

Experience in Data Warehousing/ ETL Testing within the environment of Oracle, and SQL Server

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

Familiar in using different Test management tools such as JIRA & HP Quality Center /ALM

Experience in validating source data coming from various database using SQL queries

Experience in Web Services Testing Using Soap UI

Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting

Hands on experience in writing SQL queries, Joins, Functions in Oracle and SQL Server databases.

Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports

Able to work independently under minimum supervision as well as in a team environment.

Strong problem solving, troubleshooting and efficient to handle multiple tasks easily

Excellent Communication, Analytical and Interpersonal skills

TECHNICAL SKILLS

Operating Systems

Windows, UNIX

Languages:

SQL, PL/SQL, XML

Test Management

HP ALM, JIRA

ETL Tools:

Informatica 9.5, DataStage 8.7/8.1, SSIS, Informatica

Web Services

Soap UI

RDBMS/ Databases:

Oracle 11g/10g, SQL Server 2008/2005

BI Tools:

Cognos, Tableau

PROFESSIONAL EXPERIENCE

ETL Tester

Wells Fargo, Fremont CA

April 2017 -Till date

Wells Fargo as various types of savings, Mortgage, current, and recurring deposit accounts for the bank's account holders. The project will facilitate the integration of multi-sourced data into a DWH and expose the data to standard and ad hoc reporting and visualization as well as analytical tools. This data will support the Marketing Science, Marketing Planning, and Industry Analytics and BA groups to derive Insights across all products.

Responsibilities

Extensively involved in developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.

Performed integration testing in traditional ETL, extraction, transformation, and loading of massive structured and unstructured data.

Written customized SQL queries for business needs.

Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL.

Raised and tracked defects in JIRA and shared defect reports to my manager and all the key stake holders.

Tested reports developed Cognos as per company standards.

Actively participated in defect calls and followed up to its closure. Involved in UAT support activities.

Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica

Worked on SQL queries with many joins and conditions for finding matching and non-matching data, to generate new columns, estimate shipping quantities and similar requirements.

Responsible for re-testing defects which was fixed by Dev team.

Involved in preparing Test Environment. Follow Peer Review Process for Test cases. Mentoring and nurturing of new team members

Environment: Oracle 11g, SQL, Unix, Windows 8, HP ALM, JIRA, Cognos, Informatica 10.0

ETL Tester

Healthcare Partners, El Segundo, CA

Sep 2016 - March 2017

Healthcare Partners is a leading healthcare organization in USA. The project is to create the DataMart claims based on payee type for the existing members and providers based on in network and out network the sources of the data consist of feeds from applications residing on the mainframe to applications residing on SQL server and Oracle. The data is extracted from the various sources and is loaded into the staging tables from where it is consolidated, and several measures are calculated and is finally loaded into the data mart. Reports were generated for the various business needs accordingly

Responsibilities

Involved in developing test plan, created test cases for testing DataMart based on the BRD

Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)

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

Extensively used Informatica power center for extraction, transformation and loading process.

Tracked the defects using HP ALM tool and generated defect summary reports.

Used HPALM to track and report system defects.

Have used multiple advance SQL queries function such as join, union, alter, create, distinct and some other function to join different database in single query while executing the script

Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse according to Business Rules.

Worked with Informatica PowerCenter for the ETL Process

Involved in both initial and Incremental Load testing

Performed various testing like Regression testing- testing, system testing, performance testing

Performing extensive Back-end database validation by executing advanced SQL Queries in SQL developer for Oracle Database.

Escalation performance issues by understanding the bottles necks at various levels and tuning them for better performance.

Tested the reports generated by Tableau, validated the data against Datawarehouse/Datamart

Read and verify the session log to verify data loads summary, data verification purposes like data truncation, data overflow, rejected errors, row counts etc.

Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability

Environment: Informatica Power Center 9.5, Oracle, MS SQL Server, Tableau, Teradata, Quest Toad 12, HP ALM, PL SQL, UNIX

ETL Tester

Envision Pharma Group, Glastonbury, CT

Jan 2013 – June 2016

Envision Pharma Group a leading pharmaceutical company. Project involved in Data Warehouse development for sales division, which contains the sales data for pharmaceuticals and medical products of the company. This Data Warehouse project will enable management to better leverage information collected within current operational systems to help in their decision-making process.

Responsibilities

Involved in Data Validation using SQL queries.

Performed negative and positive testing, to make sure validations are done properly.

Provide update to management on testing status and defect summary reports

Carried out and oversee test execution for Business scenario, back end testing and Regression testing

Involved in Data Validation with Business Team.

Used Informatica as an ETL Tool for Developing the Data Warehouse.

Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.

Extensively involved in Extracting, Transformation and Loading of data to target oracle warehouse database.

Raised defects in HP ALM and follow up with the development team to avoid slippage.

Tested Cognos Reports which would facilitate decision-making. The Cognos Reports designed were complex and used formulas, parameters, selection criteria etc.

Worked with Data Warehousing developers who extensively used Informatica, to design mapping to move data from source to target database using Stages to do the functionality.

Prepared defect summary and test case summary reports

Written multiple complex SQL queries to verify the Datawarehouse

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

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

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

Preparation of System Test Results after Test case execution.

Used DataStage Director to Run and Monitor the Jobs performed

Used Test Director, to manage the entire process and log in defects

Effectively coordinated with the development team.

Created critical scenarios for each change request and defect request.

Environment: IBM Infosphere DataStage 11.3/9.1/8.7, BI Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, HPALM.

Manual tester

Feb 2011 – Dec 2012

Hyatt Hotels Corporation is an American multinational hospitality company that manages and franchises luxury hotels, resorts, and vacation properties

Responsibilities

Created Test Plan, Test Cases by analyzing Business Requirement Document

Documented and executed Test plans, Test cases and Test scripts based on business requirement document

Implemented agile methodology throughout the process.

Experienced in functionality testing, black box testing, system testing, integration testing, regression testing, backend testing, compatibility and user acceptance testing.

Possess good judgment skills while reporting and prioritizing software bugs in conjunction with the development and QA Managers.

Involved in executing the basic SQL Queries for Data Validation, Record Counting and Non-Duplication Testing.

Developed SQL scripts, to implement business rules. Manually performed integration and Regression testing, documented bugs and worked with development team to resolve issues.

Used JIRA to log bugs

Exported test cases into the Quality Center, ran manual test cases from test lab and logged defects from defect module.

Performed Ad-hoc, Smoke, Functional, and Regression testing by executing test cases maintained in Quality Center.

Performed Smoke testing in the UAT environment to ensure successful migration prior to notifying the customer to start performing UAT testing.

Generated Test Status Reports, Defect Reports.

Actively participated in the test plan review meetings, Walk through, Weekly meetings.

Environment: HP Quality Center 10.0, Microsoft office, UNIX, Windows OS, Mac OS, Firefox, Chrome, Safari, Internet Explorer

Education

Master of Science in University of Minnesota Duluth

Bachelor of Science in Tribhuvan University

Contact this candidate