SUMMARY:

7+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, Client - Server Systems and Applications and got 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). In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.

TECHNICAL SKILLS:

Database: Oracle 10g/9i/8i, SQL Server 2000/2005/7.0 , IBM DB2, Teradata V2R6

Change Management Tools: Test Director 8.0, Quality Center 9.2/8.2

Data Warehouse Tools: IBM Datastage 8.0,7.X/6.X (Manager, Designer, Director, Administrator),

Parallel Extender, Informatica 9.5/9.1/8.1, SSIS:

Functional Test Tools: WinRunner, Quick Test Pro (QTP), Load Runner

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

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

Operating System : IBM AIX, UNIX, LINUX, Windows, MS-DOS

Rational Tools : Requisite Pro, Clear Case, Clear Quest, Manual Tester

Standards : VSTF 2008, METAL, SQL Server Analysis Server

Tools : TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, FL

Sr. ETL/SQL/Backend Tester

Responsibilities:

• Interacted with clients to determine User requirements and goals.
• Participated in analysis of Business and functional requirements
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for this application.
• Extensively used SQL queries to check storage and accuracy of data in database table
• Performed basic testing of security features using manual testing
• Responsible for creating Test Strategy for the Data Warehouse
• Responsible for identifying and defining the Key Performance Indicators in SSAS.
• Involved in creating the design and technical specifications for the ETL process of the project.
• Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR to avoid the cross join and removing multiple passes.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe Structure to ensure that tables are properly uploaded.
• 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
• Good understanding of agile software development lifecycle (iterative and incremental)
• Worked with Object repositories, functions, data tables and descriptive programming in QTP.
• Used Erwin to reverse engineer the existing database design in SQL Server.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Developed Regular Expressions using PERL for parsing needs.
• Tested Business Objects reports and Web Intelligence reports
• Performed Positive and Negative Testing for application.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005/2008
• Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLC
• Strong Windows operating-system background, with understanding of the key drivers and influences on performance
• Involved in testing Web Services Using SOAPUI
• Performed tests on various features of agile development process. 
• Used Clear Quest for repository, reporting bugs, tracking bugs and updates on resolved bugs.
• Developed SQL Stored Procedures and Queries for Back end testing.
• Involved in automation of test cases using QTP.
• Reported bugs and tracked defects using Rational Clear Quest.
• Tested web forms from test to production using Export and Import.
• Tested various business rule and data load rule files.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Involved in the production support team for planning cycle after production implementation
• 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
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• Used SQL for Querying the Oracle database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Extensively used Informatica Power Center for extraction, transformation and loading process
• Created and maintained test scripts in Rational Clear Quest and co-ordinate with the ETL group and other developers.
• Interacting with the Offshore Team members about the project status through Conference calls and need to prepare a Teams of Memorandum for the same.
• Involved in offshore and onsite Coordination activities
• Synchronized the dimensions of development planning with production planning
• Troubleshooting the planning web forms with user testing
• Involved in integration/system testing and backup/restore testing for all components
• Involved in the production support team for planning cycle after production implementation.

ENVIRONMENT: Informatica Power Center 9.5, (Power Center/ Power Mart,) Rational Clear Quest, VB Script, Erwin 9.3, SQL Server2005/2008,IBM DB2, SQL Plus, Rational Clear Quest, Agile(Scrum), Teradata V2R6, Business Objects XIR3, SSRS, SSIS, SSAS, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX Shell Scripting

Confidential, NC

ETL QA - EDWH Analyst

Responsibilities:

• Created test plans from the Business Requirement document, Analysis and Design Documents for building the MDM.
• Created Test Strategy and Test cases for the testing effort.
• Responsible for finding the indicators and writing the test scripts for testing the test cases.
• Conducted Smoke, Non Functional, Functional, System, Regression and Integration testing.
• Developed SQL to achieve the data transformations.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel,
• Worked with SSIS system variable, passing variables between packages.
• Used T-SQL for Querying the SQL Server2000 database for data validation and data conditioning.
• Performed back-end testing on the Oracle, DB2 and Teradata databases by writing SQL queries
• Conducted backend testing using SQL Assistant.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports.
• Experience working on PowerMHS screens.
• Created and executed automated test Scripts using QTP for Functional, Integration, and Regression testing
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Testing (that includes integrated and regression) an application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology.
• Experienced testing Web Services using SOA, SOAP UI, and REST & Custom Based Approach.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Responsible for testing all four entities Group Batch, Group Real-time, Member Batch and Member Real-time.
• Participated in daily stand-up meetings with the management team
• Created test cases for both Batch and Real-time Processes.
• Responsible for testing the CDC for both Member and Group Real-time process.
• Used Trillium for Data cleansing and data matching purpose.
• Also responsible for testing the staging tables and Look-up spreadsheet.
• Used Control-M for scheduling the jobs.
• Conducted Weekly Onsite-Offshore Status Meetings.
• Responsible for testing the XML’s which are sent to the MDM.
• Used Axis tool for comparing the XML’s.
• Worked on UNIX commands and shell scripting for scheduling the jobs from command line.
• Developed shell scripts for finding the XML’s for each member from the files.
• Responsible for testing the responses coming out of the MDM(Response Handler) and also tested the Error Handling for the MDM.
• Worked with clients to demonstrate agile techniques for software development, explained and implemented unit testing, created coding standards based on IBM recommendations.
• Performed Quality Analysis on problem reports against software and the production system in order to confirm that problems truly exists and can be recreated for testing
• Responsible for executing the test cases for Batch and Real-time that included both Member and Group data.
• Executed the scenarios and analyzed the results through monitors and graphs.
• Actively communicated with the end users and business users to create realistic test cases.
• Tracked bugs using Quality Centre and generate the defect reports from the Dashboard module for review by the development team
• Batch testing development and execution and done analysis of batch works.
• Participated in various meetings and discussed Enhancement Request issues.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Conducted Regression testing after the bugs have been fixed by the development team
• Generated reports from Quality Center.
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Actively participated in various meetings like defect resolution meeting, QA status, Knowledge transfer meeting.

ENVIRONMENT: Informatica 9.5/9.1, SQL, PL/SQL, Teradata 12.0,DB2, Agile(Scrum), TOAD 9.2, Oracle 10g,Teradata V2R6, SQL Assistant, XML, XML Spy 2008, Business Objects XIR2, HP Quality Center 10.0, IBM DB2, Axis Tool, Control-M, PowerMHS Application, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2003
Confidential,CT

Sr. Data Warehouse Tester

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.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Tested the universes and reports in Business Objects
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Developing Test cases for System testing, UAT and documentation.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Handled batch and the online projects.
• Interaction with Client and Offshore team members on daily basis.
• Provided Autosys expertise for batch processes running in the QA environment within the Enterprise Business Intelligence group.
• Wrote documentation detailing the custom reporting processes and created diagrams documenting Autosys job changes.
• 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.
• Experience in Writing Scenarios and Cases during UAT sessions.
• 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.
• Responsible for Creating and maintaining the development of excel, Access and power point
• 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.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Tested stored procedures & views in MS SQL 2000/2005.
• Tested OLAP Cubes by writing MDX.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

ENVIRONMENT: Informatica 8.1/7.1, SQL, PL/SQL, Teradata V2R6, SQL Server Analytical Server, SQL Server Reporting Server, TOAD 9.2, Oracle 9.2, XML, XML Spy 2008, HP Quality Centre 9.2, IBM DB2, Autosys, Metal (Meta Data Driven ETL), BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2003

Confidential,OH

Data Warehouse Tester (Customer Data Integration)

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.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Worked with T-SQL for validating the SQL Server 2000 data.
• Wrote and implemented test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, and GUI & Regression testing of web-based applications.
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• 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.
• Tested several reports and automated using Quick Test Pro.
• Wrote several Stored Procedures and modified existing stored procedures.
• Was 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.
• Tested stored procedures & views in MS SQL Server 2000/2005
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Analyzed business requirements, use case documents, functional specs & assisted QA team lead in writing the test plans.
• As a Test Lead Created Test plan, Test scenarios and test cases.
• 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.
• Was involved in the whole testing life cycle covering the entire project from initiation to completion
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• 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.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Designed and directed the preparation of test data; prepared test data, documented detailed results, provided regular and ad-hoc test reports.
• Experienced in data analysis and data testing. Verified fields present in the reports are as agreed in the ETL specifications.
• Was extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

ENVIRONMENT: Oracle 10g/9i, SQL Server 2000/2005,, PL/SQL, Stored Procedures, HTML, Java Script, Quick Test Pro 8.0, Quality Center 8.2, Points Portal, Autosys, MS Office Suite, Informatica, IBM Mainframe, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX.