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
• 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
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• 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

Data Warehouse Tool: 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, New York

Sr. ETL QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Responsible for leading team and co-coordinating with offshore team.
• 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.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Used Quality Center for defect tracking.
• 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
• 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 Cognos 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.
• 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.
• 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 Cognos 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 Cognos Reports.
• Created different user defined functions for applying appropriate business rules

Environment: Informatica 8.6.1/8.1,Quality Center 10.0, SQL, PL/SQL, Cognos 8.0 Series, MainFrame Flat Files, Agile, COBOL II, UNIX, Korn Shell Scripting, Oracle 10G, DB2, TOAD9.7

Confidential, Cleveland OH

ETL QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Involved in testing the Cognos reports by writing complex SQL queries
• Attending Client calls for Business understanding and Clarifications.
• 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.
• Worked in an Agile technology with Scrum
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• 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.
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• 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.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center (Test Director)
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Managed and executed the test process, using Agile Methodology
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system 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
• Reported bugs and tracked defects using Quality Center
• Worked with business team to test the reports developed in Cognos
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• 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.
• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Created different user defined functions for applying appropriate business rules
• Worked with business team to test the reports developed in Cognos
• 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 Power Center 7.2,SQL,PL/SQL, HP Quality Center 10, Cognos 7 Series, Rational Clear Quest, MS Excel, Teradata 12.0 Agile,Teradata SQL Assistant, Korn Shell Scripting, XML, XSLT, XSD, XPath, XML Spy 2010, MVS, COBOL II, JCL, VSAM Files, Copy Books, TSO, Putty

Confidential, Foster City CA

ETL 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.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• 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, PL/SQL, Business Objects XIR2/6.5, UNIX, Korn Shell Scripting, Windows, Influx and Test Director 8

Confidential

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,