SUMMARY

• As Sr. ETL QA with 7 + years of IT experience in teh Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server Applications .
• Reported software mismatches (from teh test planning), to teh development team using Quality Center
• Good experience in teh Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Involved in teh error checking and testing of teh ETL procedures and programs Informatica session log.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Strong working experience in teh 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 teh development and maintenance of conceptual, logical, and physical entity/data models, in teh development and deployment of modeling standards, governance of Metadata
• Strong experience in generating reports according to teh 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, NY

QA Analyst

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool
• Prepared Execution procedure document format to prepare teh Test cases based on mapping document.
• Used Agile Test Methods to provide rapid feedback to teh developers significantly helping them uncover important risks.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Used Quality Center for defect tracking.
• Did testing of SOA end to end, Service by service and Interface by Interface
• Created several SOA test cases for validations which were based on teh behavior of a specific service.
• Tested ad hoc and canned reports for Business objects
• Tested teh Front-End Web Applications developed in J2EE for data portal for matching
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Ensured dat teh mappings are correct and Conducted data validation testing
• Worked with business analyst and developers in setting up test data
• Used T-SQL for Querying teh SQL Server database for data validation and data conditioning.
• Worked with various EDI transactions like 834,835,837,276,277in accordance with HIPAA standards
• Tested XML feeds loaded into Data Warehousing.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Tested several dashboards and deployed them across teh organization to monitor teh performance
• Used SQL tools to run SQL queries and validate teh data loaded in to teh 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)
• 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
• Worked in an agile technology.
• Developed Test Plans, Test Cases and Test Scripts for Data Validation testing.
• Implemented SDLC, QA methodologies and concepts in teh Project
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying teh tables and columns from which data is extracted
• Coordinating with DBA team for DB trace and workflow system
• Tested Functionality Testing, Usability testing and Interface testing for mulitiple Web Applications created in Java
• Tested Business Objects reports and Web Intelligence reports
• Extensively used Informatica power center for extraction, transformation and loading process.
• Performed end-to-end testing of applications and coordinated with other teams.
• Experienced Batch Scheduling in theControl-M / Autosystool.
• 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,SOA Test, Business Objects XIR3, TOAD, HIPAA standards, Oracle 10g / 11g, J2EE, XML, HTML, XSD, Java Script, IBM DB2, Agile, Microsoft Visio 2003, MS Access, Flat Files, Korn Shell Scripting

Confidential, Buffalo, New York

QA Analyst

Responsibilities:

• Created Test Plan and developed test strategy
• Understanding teh specifications for Data Warehouse ETL Processes and interacting with teh data analysts and teh 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 client tools. Teh objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Worked in an Agile technology with Scrum
• Experienced in data analysis using SQL, T-SQL and many other queries based applications.
• Extensively used T-SQL to verify and validate teh data loaded to teh SQL Server 2008
• Worked with T-SQL for validating teh SQL Server 2005 data
• Involved in rigorous meetings with testing team and DWH Lead to plan and implement teh testing
• Tested SOA application interface and communication paths.
• Tested SOA security with limited access to communicate between teh services.
• Implemented black box testing for SOA
• Responsible for testing Business Reports developed by Business Objects XIR2
• As a Test Lead Created Test plan, Test scenarios and test cases
• Used import and export facilities of teh application to download/upload XMLs of failed test cases so as to re-verify
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to teh target database including SQL Server and used teh data for Reporting purposes.
• Managed and executed teh test process, using Agile Methodology
• 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 teh 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.
• Testing all types of WEDI testing for HIPAA including Integrity testing using teh web tools
• 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 teh test results using HP Quality Center
• Performed teh tests in both teh SIT, QA and contingency/backup environments
• Used T-SQL for Querying teh SQL Server database for data validation and data conditioning.
• Writing teh test scripts for manual testing.
• Extensively worked on teh Console application and to bring teh output of teh console application to in corporate in to teh web application.
• Tested teh outgoing links from all teh web pages from specific domain.
• Submitted weekly bug or issue report updates to teh Project Manager in teh form of teh QA Error Log.
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Involving in Functional testing, End to End testing and Regression Testing
• Preparing and supporting teh QA and UAT test environments

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

Confidential, Providence RI

QA Tester

Responsibilities:

• Extensively used T-SQL to verify and validate teh data loaded to teh SQL Server 2005
• Worked with T-SQL for validating teh SQL Server 2000 data.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• 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 teh development as well as teh 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 teh flat, Mainframe IMS and xml data using Ab Initio Data Profiler.
• Different Ab Initio components especially are used effectively to develop and maintain teh 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.
• Teh reports dat were created in Business Objects were testing by running teh SQL statements against teh tables in teh Oracle Database
• Involved in creating teh design and technical specifications for teh ETL process of teh project.
• Prepared extensive set of validation test cases to verify teh data
• Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring teh 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 teh 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 teh QA and UAT test environments

Environment: Teradata V2R5, J2EE 1.4, HP Quality Center9.2, SSIS, SSRS, XML, SQL, Oracle 9i/10g, IBM AIX 5.1, Agile, Sql Server, Business Objects XIR2/6.5, UNIX, Korn Shell Scripting, Windows, Influx and Test Director 8

Confidential, Chicago, IL

Sr. ETL QA Tester

Responsibilities:

• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.
• Developed Test Plans and developed Test Cases/Test Strategy with input from teh assigned business analysts and data architect.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Reviewed Business Requirements, System Specs and Training Material for accuracy. Planned, developed and executed test plans, including detailed test scripts.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Developed Test Plans and Developed Test Cases/Test Strategy with input from teh assigned Business Analysts and data architect.
• Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Center based on teh Business Requirements, Functional Requirements, Business Workflows, A&D documents and ICD documents.
• Used TOAD, DB Artisan tools to connect to Oracle database to validate teh data dat was populated by ETL applications.
• Validated teh data of reports by writing SQL queries in PL/SQL Developer against ODS
• Used SQL Assistant to connect to Teradata to write my SQL scripts
• Involved in testing UNIX shell scripts to run various ETL scripts to load teh data into Target Database (Teradata)
• Responsible to design, develop and test teh software to maintain teh data marts (Load data, Analyze using OLAP tools).
• Tested teh messages published by data stage and data loaded into various databases
• Clearly communicated defects with developers and updated comments in HP Quality center.
• Determine level of testing required to validate new or revised system capabilities.
• Report accurate testing status and create test summary reports.
• Continuously improve test models, test data, and test processes based on lessons learned.
• Tested ETL Packages, Scripts from development to QA environment.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Used Quality Center and Test Director for defect tracking and reporting
• Tested both conditional formatting and threshold level testing for several reports developed in Business Objects XIR3.
• Executed Data stage ETL jobs using UNIX to load teh data into target tables
• Tested whether teh reports developed in Business Objects are as per company standards.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Involved in extensive data validation using SQL queries and back-end testing
• Written complex SQL queries to validate teh data against teh target based on ETL mapping specifications.
• Used Tidal scheduler for composing and executing teh jobs to simulate teh production environment in QA.

Environment: Data stage, UNIX, IBM AIX 5.5, IBM Rational Manual TesterV7.0, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Assistant, HP Quality center, Oracle 10g, TOAD, WinSQL, XML Spy 2010, XM L Files, PL/SQL, Tidal Enterprise Scheduler V5.3, SSRS V9.0, Business Objects XIR3