PROFESSIONAL SUMMARY:

• Over 7 years of experience in Software Quality Assurance, Quality Control, and Quick Test Professional.
• Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Experience using query tools for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experienced in writing complex SQL queries for data validation for both ETL and BI testing.
• Extensive experience in data mining, analytics, and business intelligence.
• Actively involved in analysis, design and Quality Assurance of web, client - server applications on UNIX and Windows 98/NT/2000 Platforms in Banking, Financial, Brokerage, Investments, Insurance and Retail sectors.
• Excellent business writing skills through preparing Business Requirements Document (BRD), Functional Requirements Document, Use Case Specifications, Systems Design Specification (SDS), Systems Requirements Specification (SRS), Data Dictionary, Workflows
• Expertise in creating Unified Modeling Language (UML) diagrams including Use Case diagrams, Class diagrams, Sequence diagrams and Activity diagrams
• Proficient in Rational tools including Rational Rose and Rational Requisite Pro
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements
• Experienced in writing SQL queries to validate input data submitted through GUI with the actual data in the Database Analyzed Test results to meet the end user needs.
• Extensive Experience using Multi-Tire Applications and Client Server Applications.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in writing Test cases based on Business Requirements and Technical Specifications.
• Worked on User Acceptance Testing (UAT), System testing, Integration testing, Regression Testing, Black Box Testing and Backend or Database Testing.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Excellent knowledge and working experience in test planning, test execution and test result analysis.
• Excellent analytical, problem-solving and trouble-shooting skills.
• Capacity to work- meeting deadlines.
• Strong Communication, Self Starter, Quick Learner Multilingual and Interpersonal skills.
• Expert in implementing / suggesting best practices and Understanding the complexity of the application, collecting the client’s requirements and providing the software solution to achieve his quality standards. Vast experience in entire software development process from concept definition of system specification and requirement analysis
• Good interpersonal skills, committed, result oriented and hard working.
• Experience with Mentoring and Coordinating a team of QA resources, Identifying and Managing Risks, Estimating Work, Resource sharing between the projects, tracking project progress, Delivering projects as per the deadlines.

TECHNICAL SKILLS:

Languages: HTML, XML, XSLT, VB Script, Java2.0, SQL T-SQL and PL/SQL

Testing Tools: Quick TestPro9.5/9.2/8.0,WinRunner 9.2/9.0/8.0/7.5, LoadRunner9.2/9.0/8.0, TestDirector9.0/8.0/7.5, Quality Center 9.2/8.2

Databases: My SQL, SQL Server 2005, Oracle, Ms Access, Teradata V2R6, IBM DB2

Web Technologies: C#.NET, VB.NET, ASP.Net, XML, HTML, DHTML, XSLT, CSS, PHP, AJAX.

Software Applications: Microsoft Suite (Word, Excel, Power Point Access), Adobe Photoshop FrontPage Dreamweaver

Reporting Tools: MS Windows 2000/XP/Vista, Windows 95/98UNIX.

Business Objects XIR2, Cognos Series 8.0, Crystal Reports, OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Data Warehouse Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Load new or modified data into back-end Oracle database.
• Set-up of Test Environment for GUI testing and Back-end testing
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Extraction of test data from tables and loading of data into SQL tables.
• Developed the test cases for Screen UI testing for all the Screen Labels.
• Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment.
• Managing SSIS packages, Migrating DTS packages from SQL 2000 to SQL 2005
• Support SSAS, SSRS of SQL 2005 with the cube builds and report management.
• Managed and executed the test process, using Agile Methodology.
• Evaluates data mining request requirements and help develop the queries for the requests.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Installed, Administered, Customized and Maintained the Quality Center Environment.
• Manually tested the whole application before going onto automated testing.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Used Message -Oriented Middleware infrastructure for sending and receiving messages and increasing the portability, and flexibility of an application.
• Actively involved in the daily testing status meeting in which the defects identified were discussed.
• Verify development of rule-set test scenarios, test cases, expected results and test scripts using mercury Quality center.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Developed and executed test cases and verified actual results with expected results.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.

Environment: QTP 9.0, Quality Center 10.0, SQL, PL/SQL, PERL, Shell Scripting, SQL Server 2000/2005,SSIS,SSRS, SSAS. Visual Studio, .NET 2008, Teradata V2R6, Cognos 8.0 Series, Informatica 8.5.1, IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, ADO.Net, C#, XML, COM, JavaScript, Visual Source Safe 6.0

Confidential, Phoenix, AZ

QA/ETL/SQL Tester

Responsibilities:

• Analyzed the Business and User requirements and Participated in the creation, preparation, and conduct of quality assurance reviews and Functional/Regression testing.
• Reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Performed Data mining and worked on Business Intelligence tools.
• Responsible for different Data mapping activities from Source systems to Teradata
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Drafted Test Plan for flow of data from front end to back end legacy applications In a team environment, planned testing strategy for end to end flow through the system to link the front end functionality to the back end
• Wrote test procedures for back end validation via functional specifications
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Involved in other test planning meetings and submitted test metrics daily to the management
• Participated in defining and executing test strategies using agile methodology.
• Written and executed the functional and regression test script using Test Script Quick Test Professional.
• Worked on data mining of genomics data using and developing multidimensional analytic and visualization techniques.
• Used Quality Center as a Defect tracking tool to report the defects encountered while testing.
• Recorded and programmed quick test scripts through the expert view, by adding conditional statements, loops and other user-defined functions.
• Involved in Performance testing, Regression testing, Unit Testing, System Testing and User Acceptance Testing.
• Ran SQL queries and store procedures for data base testing for the verification of results retrieved.
• Document problem tickets and ensure appropriate follow through to resolution. Develop test automation scripts using Quick Test Professional (data driven) for regression testing.

Environment: Ab Initio (GDE 1.13, Co>Op 2.13), Windows 2000, Windows XP, Quality Center, Business Objects XIR2, SQL, PL/SQL, PERL, UNIX Shell Scripting, QTP, MS Excel, Teradata V2R5, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, Teradata SQL Assistant

Confidential, St Louis, Missouri

QA Tester - Customer Billing Data Mart

Responsibilities:

• Coordinating in the preparation of Test Plan/ Test Strategy for the application after careful analysis of requirements and specifications.
• Used DTS/SSIS to populate data from various data sources, creating packages for different data loading operations for application
• Contributed to the initial data mining work and development of tools and technology.
• Created and executed detail function test script and test cases based on the business requirements.
• Worked with ETL testing for Data Completeness, Data Transformation & Data Quality.
• Written complex SQL queries including joins, minus, case statements, etc.
• Performed Load testing, Stress testing, Performance testing and Regression testing.
• Performed Security testing for unauthorized access of the application with valid and invalid data.
• Conducted Regression testing on each new build of the application under test.
• Tested the performance of the application using Load Runner.
• Developed the Silk Performer scripts and created different scenarios as per the requirements.
• Performed Track Record defect process flow in Quality Center.
• Used Quality Center as a repository for Test Cases and for Defect Tracking.
• Mapped the original loan data to XML script data in the file.
• Performed Ad-hoc testing, Integration testing, End-to-End testing, Function testing, Performance testing, System testing, User Acceptance testing, Black box testing and White box testing.
• Executed SQL Queries to check the data table updates after test execution.

Environment: T-SQL, SQL, PL/SQL, DTS, SSRS, SSAS, Manual testing, Visual Basic, SQL Server, Windows NT/2000

Confidential, San Francisco, CA

Test Engineer - Online Banking System

Responsibilities:

• Perform and schedule administration tasks like Backup and Restore Database.
• Database space management, Monitoring Performance and Alert Management.
• Creation of New user Logins and grant privileges to users/Groups and objects.
• Installing software upgrades for SQL Server.
• Involved in reviewing and designing table additions, changes, deletes according to the Database Change Request form.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Involved in Data/package Migration from MS SQL Server 2000 instances to 2005.
• Designed various DTS packages to import/export data from heterogeneous files.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Involved in generating reconciliation reports using SSRS.
• Implemented and maintained snapshot and transactional replication.
• Working in active 24x7 on call support.
• Monitoring various Jobs for Program Completion Tasks, Task Management and Reconciliation Process running at specified Schedules.
• Trouble shooting the issues incurred while executing the Jobs.

Environment: Java, XML, HTML, DHTML, Web Sphere, Test Director, Toad, Oracle 9i, SQL, PL/SQL, UNIX, Shell and Win NT