SUMMARY:

• As Sr. QA with 7 + years of IT experience in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server Applications
• Reported software mismatches (from the test planning), to the development team using Quality Center
• Extensive experience in Black box/White box, manual and Automation (QTP) testing.
• Good experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications
• Experience with Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Extensive experience in Business analysis, data Quality Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, MS Access, Flat files into a staging area
• Extensively worked on Dimensional modeling, Data cleansing and Data staging of operational sources using ETL processes
• Experienced in testing Web applications and client/server applications
• Strong skills in database programming using SQL, PL/SQL, T - SQL, Stored Procedures
• Worked with Teradata stored procedures, standard tables and ETL processes.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts
• Participated in the development and maintenance of conceptual, logical, and physical entity/data models, in the development and deployment of modeling standards, governance of Metadata
• Strong experience in generating reports according to the business needs
• Used Quality Center to track and report system defects
• Experience in Web and Object Oriented Technologies
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming and stored procedures
• Excellent communication, analytical and interpersonal skills

TECHNICAL SKILLS:

Business Modeling Tools: MS Visio, Power Designer

Database Management: DB2, Oracle 9i/10g, SQL Server 2000/2005, Erwin 4.0/3.5 Teradata V2R6/V2R5

Informatica: Power Center, MS DTS Packages & Fast Load

Functional Test Tools: Win Runner 8.0, QTP 9.x

Languages: C, C++, PL/SQL, T-SQL, SQL, Visual Basic 6.0, SAS 9.1

Office Tools: MS Office Suite, MS Project

Operating System: IBM AIX, UNIX, Windows

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

Reporting Tools: Cognos, Business Objects, Crystal Reports

Standards: RUP, CMM, ISO 9001

Tools: IMS, XMLSpy, TOAD, SQL Enterprise Manager, SQL Query AnalyzerWin SQL, Citrix, Control Center

Data Modeling Tools: ER Studio 8.0, ERWIN 4.0/3.5

Web Technologies: XML, XSL, XHTML, HTML, CSS, JavaScript, VBScript

PROFESSIONAL EXPERIENCE:

Confidential, Rochester NY

QA Analyst

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool
• Prepared the guides for UAT & Production readiness for entire Ab-Initio ETL testing efforts.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Developed test scenarios for testing Enterprise Data warehouse in DB2 environment.
• Used Quality Center for defect tracking.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Executed test cases using QTP Automation tool.
• Followed HIPAA guidelines in preparing the documents for the transactions sets 835, 837,277 & 276.
• Created and executed QTP scripts by using descriptive programming.
• Tested ad hoc and canned reports for Business objects.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
• Tested Functionality Testing, Usability testing and Interface testing for multiple Web Applications created in Java
• Writing complex SQL queries for data validation for verifying the Ab-Initio ETL Mapping Rules
• Tested several dashboards and deployed them across the organization to monitor the performance
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Extensively used Informatica power center for extraction, transformation and loading process.
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job / Graph scheduling
• Preparing manual test cases and test data for Scenarios
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Developed Test Plans, Test Cases and Test Scripts for Data Validation testing.
• Implemented SDLC, QA methodologies and concepts in the Project
• 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
• Used QTP framework functionality in various phases.
• Performed end-to-end testing of applications and coordinated with other teams.
• Experienced Batch Scheduling in the Control-M / Autosys tool.
• Investigate root cause analysis of batch scheduling
• Created Test Plan, Test scripts for system validation and user acceptance testing (UAT)
• Used workflow manager for session management, database connection management and scheduling of jobs / Graph

Environment: Informatica 8.6.1/8.1, XML, Windows NT 4.0, SQL Server 2005, Agile/Scrum, Quality Center 10.0, DTS, Control-M, Autosys 4.5, SQL, Teradata V2R5 (BTEQ, MLOAD, FLOAD, QTP , FEXPORT, TPUMP), TOAD, Teradata SQL Assistant 6.0, Oracle 10g / 11g, J2EE, XML, HTML, XSD, Java Script, IBM DB2, Business Objects XIR3, DB2, Microsoft Visio 2003, MS Access, Flat Files, Korn Shell Scripting

Confidential, Madison WI

QA Analyst

Responsibilities:

• Created Test Plan and developed test strategy
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Submitted Status and Test Evaluation Reports to Test Lead on daily basis and Constantly updated test deliverables
• Extensively used Informatica power center for extraction, transformation and loading process.
• Experienced in working with DB2,Teradata
• Worked with various EDI transactions like 834,835,837,276,277in accordance with HIPAA standards
• Experienced in data analysis using SQL, T-SQL and many other queries based applications.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2008
• Worked with T-SQL for validating the SQL Server 2005 data
• 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.
• Responsible for testing Business Reports developed by Business Objects XIR2
• As a Test Lead Created Test plan, Test scenarios and test cases
• Did testing on different feeds coming from Customer Data Integration and Test Data.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Prepared extensive set of validation test cases to verify the data
• Tested different detail, summary reports and on demand reports.
• Executed QTP Regression suite.
• Involved with ETL test data creation for all the ETL mapping rules.
• Identified all necessary test scripts and have been uploaded into HP Quality Center
• 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
• Responsible for testing Business Reports developed by Business Objects XIR2.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center
• Performed the tests in both the SIT, QA and contingency/backup environments
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Writing the test scripts for manual testing.
• Performed regression testing and validated fixes to the system using QTP.
• Tested the outgoing links from all the web pages from specific domain.
• 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.
• Involving in Functional testing, End to End testing and Regression Testing
• Preparing and supporting the QA and UAT test environments

Environment: Informatica Power Center 7.2,SQL Server 2005/2008, SSIS, Teradata V2R5, HP Quality Center9.2, XML, AutoSys4.0, Flat Files, QTP, Business Objects XIR2/6.5.1/6.0/T-SQL, SSRS, MS Excel, UNIX, Korn Shell Scripting, DB2, Windows, J2EE, XML, HTML, XSD, Java Script, Quality Center 8.2 and Test Director 8.0

Genuine Parts, Atlanta, GA

QA Tester

Responsibilities:

• 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.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• As a Lead, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Analyzed and verified the flat, Mainframe IMS and xml data using Ab Initio Data Profiler.
• Different Ab Initio components especially are used effectively to develop and maintain the database
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Initio to create test data.
• Submitted Status and Test Evaluation Reports to Test Lead on daily basis and constantly updated test deliverables.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Worked on issues with Data migration from development to testing.
• The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database
• Involved in creating the design and technical specifications for the ETL process of the project.
• Prepared extensive set of validation test cases to verify the data
• Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• 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
• Involved in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific and North Atlantic exchanges
• Preparing and supporting the QA and UAT test environments

Environment: Ab Initio, Teradata V2R5, (GDE 1.14, Co>Op 2.14), J2EE 1.4, HP Quality Center9.2, SSIS, SSRS, XML, SQL, Oracle 9i/10g, IBM AIX 5.1, Business Objects XIR2/6.5, UNIX, Korn Shell Scripting, Windows, Influx and Test Director 8

Confidential, Atlanta GA

SQL Tester

Responsibilities:

• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Developed and Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Written several complex PL/SQL statements for various business scenarios.
• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart.
• Did data parsing, text processing and connecting to the database using PERL.
• Developed UNIX Shell scripts to automate repetitive database processes
• Tested several ETL routines and procedures.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, SQL Server 2000, T-SQL, SQL, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, XSD, UNIX, Korn shell scripting, PERL, MVS, JCL, ISPF, VSAM Files, OS/390