SUMMARY

• 6 years of IT experience in various phases of IT projects such as Development, Testing, deployment and application support.
• Strong experience with ETL systems and having expertise with tools Informatica and Data stage.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Experienced in Defect Management using ALM, HP Quality Center
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Good exposure with databases like Oracle 10g, DB2, SQL Server 2012
• Good expertise in using TOAD, SQL*Plus and Query Analyzer.
• Worked with different data sources ranging from VSAM files, flat files, and DB2, oracle and SQL Server databases.
• Experience in debugging the issues by analyzing the SQL queries.
• Hands on experience with all phases of Software Testing Life Cycle (STLC)
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
• Extensively tested several Tableau reports for data quality, fonts, headers & cosmetic
• Involved in testing the Tableau reports by writing complex SQL queries.
• Expertise in creating Test plan documents and Test strategy documents.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Expertise in QA process and different levels of testing like Functional, Regression, and Integration testing with business scenarios.
• Proficient in quality assurance testing by manually and using Automation tools (QTP, ALM/Quality Center)
• Extensive experience with ETL tools Informatica Power Center, IBM Data stage, Querysurge and Ab Initio
• Supporting presales activity for Data centric warehouse testing projects.
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts
• Experienced in coordinating resources within Onsite - Offshore model
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Experience with testing reporting tools (Micro Strategy /Business Objects).
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

ETL Tools: Ab Initio, informatica power center, Querysurge

BI Tools: Micro Strategy Business Objects XIR4, Cognos 8.0 Series, Tableau, OBIEE

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Bugzilla, Selenium,QTP/UTP

Data Modeling Tools: Erwin 3.x/4.x

Utilities: Toad, Citrix server, Oracle SQL Developer, SQL Advantage, Putty

Databases: SQL Server 2005/2008, Oracle 11i/10g/9i, Teradata V2R6, DB2, Sybase 12.5, Netezza, AQT

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating System: MS - Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

PROFESSIONAL EXPERIENCE

Confidential, North Carolina, NC

QA Tester

Responsibilities:

• Highly Proficient in resource capacity planning as per the Band-width available per Sprint, worked in multiple teams at same time
• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases
• Expertise with System Testing, Functional Testing, End to end testing, Regression Testing
• Participated in sprint retrospective meetings to inspect the team behavior, and backlog refinement meeting to refine backlog items
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements and performed gap analysis
• Interacted with developers, business analysts and discussed technical problems and reported bugs
• Responsible for testing data completeness, data transformation, data quality, integration testing
• Checked the data flow from front end to backend and used SQL queries to extract the data from the database
• Involved in organizing weekly status meetings to make sure the all team members are on the same page
• Created SDLC documents, observation list and maintained them in both confluence and jira
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Facilitated Defect/Bug review sessions and touch points meetings on a daily basis with Developers, Data Analysts, Business System Analyst and Data Architect for resolving the escalated issues
• Responsible for extensive data validations on Data warehouse and reports
• Participated in reviews, high level design walk-through and evaluations of the application at all stages of SDLC
• Served as testing point of Contact for the project for Business and Technical Teams
• Tested several Micro Strategy reports for data quality, fonts, headers & cosmetic
• Performed extensively UI Testing for various critical projects

Confidential, Kansas City, KS

BI Tester

Responsibilities:

• Developed data quality test plans and manually executed ETL and BI test cases.
• Worked in AGILE Methodology.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Written several complex SQL queries for validating Micro Strategy Reports.
• Created different user defined functions for applying appropriate business rules
• Created and Developed Reports and Graphs using ALM
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• 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
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Testing the reports and maintenance of daily, monthly and yearly.
• Extensively tested several Micro Strategy reports for data quality, fonts, headers & cosmetic
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Involved in data warehouse testing by checking ETL procedures/mappings
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the FIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Tested several complex reports generated by Micro Strategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Proficient in quality assurance testing by manually and using Automation tools (QTP, ALM/Quality Center)
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Used Control-M for job scheduling.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: Informatica 9.1, Teradata, Quality Center & ALM 11.0,SQL, PL/SQL, Micro Strategy, MainFrame Flat Files, Agile, COBOL II, UNIX, Control-M, Korn Shell Scripting, Oracle 10G, DB2, TOAD9.7

Confidential, Atlanta, GA

BI Tester

Responsibilities:

• Tested SOA security with limited access to communicate between the servic
• Developed test cases and scripts for ETL rules in Quality Center Test Plan.
• Interacted with DBA for setting up QA environment.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Executed SQL queries using SQL Assistant to validate data mart tables.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Extensively tested several Micro Strategy reports for data quality, fonts, headers & cosmetic
• Involved in testing the Micro Strategy reports by writing complex SQL queries.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Developed Requirement Traceability Metrics (RTM) using Quality Center.
• Used Toad for Data Analysts to compare Oracle and Teradata databases
• Used Putty to access files and directories in UNIX environment.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Written several complex SQL queries for validating Cognos Reports.
• Validated target table after extracting the data from source tables by running SQL queries using TOAD.
• Opened and Updated defect status in Quality Center.
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Participated in workflow migration from development to QA and to UAT environments as required.
• Worked in an agile technology.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle
• Tested several complex reports generated by Micro Strategy including Dashboard, Summary Reports, Master Detailed, Drilldown and Crosstab reports.
• Tested SOA application interface and communication paths.
• Attended daily QA status and defect meetings.

Environment: Informatica 9.1,, Oracle 11i, TOAD for Data Analysts, MLOAD, SQL Assistant 6.0, SQL Server 2005, HP Quality Center 9.2, SQL/PLSQL, SOA Test, Control-M, Micro Strategy, UNIX, Agile, Windows XP

Confidential, Atlanta GA

BI Tester

Responsibilities:

• Writing the test scripts for manual testing.
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and target warehouse
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.
• Performed Interface and Integration(SIT) Testing
• Extensively use SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
• Worked with UNIX scripts in executing and validating logs for the issues.
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Preparing and supporting the QA and UAT test environments
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created Test Plan and developed test strategies.
• Created Manual Test Suites for various modules.
• Tested stored procedures & views.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Written SQL queries in order to data validation in migration as part of backend testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively used SQL to verify and validate the data load.
• Worked with 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
• Performed the tests in both the SIT, QA and contingency/backup environments
• Responsible for ETL batch jobs execution using UNIX shell scripting to load data from core database to Staging and Data mart tables.
• Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data.
• Assisted business users to execute UAT test scenarios and test data as part of Validation Testing
• Preparing the SQL queries to fetch the data from databases

Environment: Informatica Power center 8.6, Oracle 9i/10g, Teradata SQL Assistant, Tableau (Desktop, Server), Teradata V2R6, TOAD for Oracle, Quality Center, Windows XP, UNIX

Confidential, Woonsocket, Rhode Island

Backend QA Tester

Responsibilities:

• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Assisted in System Test and UAT testing scenarios as required.
• Created user defined functions to test the specific test cases for windows applications using QTP.
• Extraction of test data from tables and loading of data into SQL tables.
• Design and build efficient SQL queries, analyze query cost comparison, use indexes efficiently.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Created test data for testing specific membership functionality.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Conducted Load testing using SOAPUI tool.
• Responsible for testing packages using SSIS (ETL) to verify Data Completeness, Data Transformation, Data Quality, Integration Testing, UAT & Regression Testing.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Used Quality Center for Bug reporting, tracking & generation of Test Metrics.
• Tested the ETL process for both before data validation and after data validation process.
• Tested the messages published by ETL tool and data loaded into various databases.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica 7.x, MVS, UNIX (K-Shell Script), SOAPUI, Agile, Quality Center, QTP, Oracle, SQL Server 2008, DB2, Business Objects