SUMMARY:

• As Sr. ETL 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
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Involved in the error checking and testing of the 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 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 Analyzer, Win 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 the Test cases based on mapping document.
• Used Agile Test Methods to provide rapid feedback to the 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 the behavior of a specific service.
• Tested ad hoc and canned reports for Business objects
• Tested the 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 that the mappings are correct and Conducted data validation testing
• Worked with business analyst and developers in setting up test data
• Used T-SQL for Querying the 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 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)
• 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 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
• 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 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,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 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 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.
• 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 the data loaded to the SQL Server 2008
• Worked with T-SQL for validating the SQL Server 2005 data
• Involved in rigorous meetings with testing team and DWH Lead to plan and implement the testing
• Tested SOA application interface and communication paths.
• Tested SOA security with limited access to communicate between the 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 the 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 the target database including SQL Server and used the data for Reporting purposes.
• Managed and executed the 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 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.
• Testing all types of WEDI testing for HIPAA including Integrity testing using the 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 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.
• Extensively worked on the Console application and to bring the output of the console application to incorporate in to the web application.
• Tested the outgoing links from all the web pages from specific domain.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the 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 the 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 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.
• 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 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: 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

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