SUMMARY:

• Experienced Quality Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
• Close to 7 years of IT experience in the Analysis, Design, development, testing and Implementation of Quality Analyst/Data Quality Analyst solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back - end testing.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting and AutoSys.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load of data from Legacy systems using Informatica.
• Well versed using UNIX commands for shell scripting.
• Planned, developed and conducted unit, function, integration, data quality and UAT tests
• Extensively executed SQL queries on Teradata, Oracle, DB2, and Hadoop, SQL server tables in order to view successful transactions of data and for validating data.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• Experienced in working with HP Quality Center/ALM and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.
• Excellent experience in developing Business Intelligence Applications using Business Objects and Crystal Reports.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Developing and Delivering System Documentation and UAT Test scripts and auditing documentation for maintaining ITIL.
• Excellent problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9/8.1/7.1, Data Stage, SSIS

Testing Tools: Quality Center, Load Runner, QTP, Win Runner, Manual Testing

Database: Oracle 8i/9i/10g, SQL Server 2000/2005, MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6

Reporting Tools: Business Objects 5.1/XIR2, Cognos 8.0, Crystal Reports

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX).

Version control: Visual Source safe, WINCVS,PVC

Languages: HTML, XML,PL/SQL, VB 6.0, VB script, Java

PROFESSIONAL EXPERIENCE:

Confidential, Newark, DE

Sr. QA Analyst

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Wrote Test cases and SQL and PL/SQL queries to validate the data pulled in from the Data Marts and populated.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Performed data quality analysis using advanced SQL skills.
• Logged defects using HP ALM/Quality Center, linked defects with requirements and generated Defect Reports in QC.
• Working on a integration project with the SQL server data services to maintain the data quality by creating new look ups
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Responsible for handling critical tickets for HP ALM/QC Issues
• Participated in change review meetings and suggested on the testability of the CRs.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• System was implemented using Informatica and the Warehouse in Teradata. Fast-Load, MultiLoad, BTEQ & Fast-Export were the Teradata utilities used
• Used Quality Center/ALM for execution, tracking and reporting for Internal High Level access and also to create reports and update bug status
• Performed Report Testing using Crystal Reports by writing SQL queries to validate the data on the report and compare with the DWH data.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries and PL/SQL Stored procedures to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
• Retesting the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: HP ALM/Quality Center, MVS, Informatica 9.0, Oracle, AutoSys, QTP, Teradata V2R5 Teradata SQL Assistant, Data Quality Analyst, PL/SQL, TOAD 8.0, SQL, UNIX,, Crystal Reports 12.0

Confidential, Wilmington, DE

Sr. QA Test Engineer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Logging in UNIX server for checking logs in UNIX in Production & Development environment.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Identified the Test Cases to be automated and lead the effort for automating the product.
• Used Quality Center to run the test scripts and to log and track defects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tested User Interface inconsistency and application functionality.
• Developed SQL scripts and PL/SQL Stored procedures to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Used Quality Center for Test Management, Defect Management and save/manage the automation scripts created using QTP
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• Preparation of test data for various levels of testing
• Load new or modified data into back-end SQL server database.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.

Environment: ALM/Quality Center, SQL, PL/SQL, DB2, QTP, SQL Server Import Export Wizard, Oracle10g, C#, SQL Server 2005, Erwin 7.1, Windows XP, TOAD for Oracle 9.5.

Confidential, Foster City, CA

QA Test Analyst

Responsibilities:

• Involved in Business analysis and Requirements gathering.
• Data migration - Includes migration of data from legacy environment to Oracle System.
• Involved in Data Validation using SQL and PL/SQL queries.
• Used to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database. Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work.
• Utilized Access database to collect data from multiple database sources using ODBC methods. Developed procedures for exporting information in Excel format in development server.
• Consolidated numerous scripts and revised validation logic to conform to data jobs and client data integrity requirements. Created user defined functions to dynamically validate data specific to clients.
• Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Worked with UNIX shell scripts for scheduling and running the required jobs.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Reported bugs and tracked defects using Rational Clear Quest.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE and Used Win SQL for Querying DB2.
• Created critical scenarios for each change request and defect request.

Environment: UNIX Shell Scripting, IBM AIX, QTP, Control-M, Oracle8i, SQL, PL/SQL, SQL*Loader, Rational Clear Quest, IBM DB2

Confidential, Caledonia MI

QA Tester

Responsibilities:

• Involved in Data Analysis and Database Designing.
• Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.
• Used MS Visio to develop the database design.
• Extensively involved in developing Data Dictionary. Created tables and various database objects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality. Executed SQL queries for Data Migration and Data testing.
• Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
• Performed Data Profiling to improve search abilities by using tags and aliases.
• Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
• Performed Regression testing with QTP by executing the automation test scripts
• Wrote SQL and PL/SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Involved in creation of tables, writing stored procedures and Triggers.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Handling user defined exceptions.
• Involved in testing, implementation & maintenance.

Environment: MS Visio, Metadata Repository, Visual Basic 6.0, QTP, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT