SUMMARY

• Around 7+ years of experience testing Web, Client - Server Systems and Applications, Data Warehouse, Database, for various Industries
• Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete
• Extensively strong on databases including Oracle, MS SQL Server 2008, Teradata and DB2
• Performed Backend Database testing on Oracle and MS SQL Server databases, used SQL, PL/SQL queries, triggers & procedures
• Extensive experience in Data centric testing.
• 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)
• Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall, RUP
• 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.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing 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.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Responsible for execution of Batch jobs and population test data for other teams
• Good experience in checking the logs in Informatica
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Worked with Functional /Testing tools as QTP, Quality Center, Test Director, Rational ClearQuest
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

Database: Oracle, sybase12.5, SQL Server 2005/2008/7.0 , IBM DB2, Teradata V2R6

Change Mgt Tools: Quality Center 10/9.2

Data Warehouse Tools: Informatica, Ab Initio

Languages: PL/SQL, T-SQL, SQL, Shell Scripting

Operating System: Windows, MS-DOS

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, Bugzilla, JIRA, XML Spy 2010

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.ETL SQL-QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Executed the Batch job in Autosys and validated the data.
• Worked on the Functional and Integration testing
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Performed testing, debugging of the jobs and migrated different projects from one environment to the other.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Used SQL for Querying the DB2 database.
• Prepared the guides for UAT
• Performed data centric backend testing of applications using UNIX and SQL scripts.
• Extensively worked in creating and integrating MicroStrategy Reports and objects
• Involved in Unit testing, Functional and Integration testing of Informatica mappings.
• Logged the defects in the Quality center
• 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
• Involved in coordinating and preparing Validation Test Plans, Test Methodology and Test cases as per Functional and Business requirement for System/Functional Test Specification and Unit/Integration Test specification set by the SOP's, Best practices, policies, and procedures of the company and FDA regulations
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Tested data migration to ensure that integrity of data was not compromised.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Performed the data validation once the Batch Job execution is completed
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Developed test scripts using QTP for Functionality and Regression Testing.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop
• Involved in testing the UI applications.
• Identify business rules for data migration and Perform data validations.
• Involved in writing and execution of test cases for data centric testing.
• Extensively involved with backend testing by writing complex SQL queries.
• 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
• Testing of records with logical delete using flags.

Environment: Informatica 9.1, Sybase, Oracle 11g,QTP, MS SQL Server 2008, MicroStrategy, Query Studio, Autosys 11, MS Excel, MS Access, Oracle 10g, DB2, MySQL, Windows 2007,UNIX, Quality Center 10, T-SQL, SQL, MOSS, TOAD, Flat Files

Confidential, NYC, NY

ETL/QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Loaded the data into the Teradata database using Load utilities like (Fast Export, FastLoad, MultiLoad)
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• 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.
• Prepared reusable function in QTP to use across the automation scripts
• Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues
• Extensively worked with defect tracking software as Bugzilla, JIRA
• Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improves the performance
• Worked on issues with migration from development to testing for different data loading jobs
• Performed Datacentric testing using advanced SQL skills.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Executing test scripts to verify actual results against expected results by using Informatica Power Connect for source (DB2) validation and Oracle for target validations.
• Data Integration testing for products, Reference Data and Customer master data management (MDM)
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Involved in testing MicroStrategy reports including conditional formatting testing and threshold testing.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Extensively involved with backend testing by writing complex SQL queries.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• 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.
• Performed Pre Migration Assessment, Migration and Post Migration.
• Wrote and ran UNIX Scripts for batch jobs.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/200
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.6.1,PL/SQL, SQL,UNIX, Teradata V2R6, MicroStrategy, TOAD 9.2, Oracle 10g, DB2 UDB, DB Artisan 8.5.2, MS Access, MS Excel, MS PowerPoint, QTP, Microsoft Share Point, XML, XSD, XQuery, XPath, XSLT, XML Spy 2010, QTP 9.5, HP Quality Centre 10, Windows NT/XP//2003.

Confidential, Baltimore, MD

QA Analyst

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 documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, and UI & 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.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in testing the Cognos reports by writing complex SQL queries
• 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.
• Extensively used Ab Initio tool to extract, transform and load the data from Oracle to DB2.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of 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.
• Scheduling and automating jobs to be run in a batch process.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Developed and documented data Mappings/Transformations, and Ab Initio testing as per the business requirement. Involved in the development of Ab Initio graphs and also tuned them for better performance.
• 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.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Ab Initio GDE 1.14, Co-Op 2.14, EME, Autosys, SQL, PL/SQL, Shell Scripting, PERL, CognosT-SQL, SQL Server 2000, Teradata V2R6, Clear Quest, MS Office Suite, IE, ASP, HTML, JAVA, JSP, JavaScript, UNIX, Windows NT/XP/2000

Confidential

Tester

Responsibilities:

• Wrote SQL queries to perform database testing and verify data integrity.
• Extract data from source data sets to compare against Target Values.
• Reported bugs and tracked defects using Test Director
• Worked on extensive data validation by writing several complex SQL queries and worked with data quality issues.
• Worked on testing of different data sources like Oracle/SQL Server.
• Tested Cognos reports based on the requirements; written complex SQL queries for validating the data against different kinds of reports generated by Cognos
• Performed Unit, Integration, functional, Load, performance, Regression testing.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Review the test cases and bug reports.
• Expertise in code reviews. Expertise in security issues of client/server technologies.

Environment: J2EE, JSP, PL/SQL, Oracle 8.x, Mysql 4.2.0, Linux RHEL 3.1, Python and QTP, Web Servers: Apache 1.3.3 and Tomcat 1.5.