OBJECTIVE

• Prime focus on delivering quality assurance services and working in conjunction with other teams towards organizational objectives. Highly adaptive, technically sound along with efficient communication skills.

SUMMARY

• 8 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Possess specific experience in the Insurance, Banking, and Financial Domains.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Experienced in testing both ETL and BI applications.
• Experienced in both Manual and Automation testing. Extensively used automation-testing tools such as Win Runner, Load Runner and QuickTestPro.
• Experience in Business Intelligence in generating various reports using Cognos, Micro Strategy, Business Objects and SSRS
• Experience in bug reporting and bug tracking using management tools such as Test Director and communicated recorded problems to the responsible QA or development personnel.
• Adept in using testing tools like Test Director, HP Quality Center, Quick Test Professional (QTP) to write and maintain automated Test scripts
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Strong Skills in using Integration, Functionality, Regression, Performance, Stress and Configuration Testing.
• Extensive experience with Functional, GUI, Database, Stress, Volume, Regression, Load and Performance Testing.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

TECHNICAL SKILLS

Data warehousing Tools: Informatica Power Center 8.x/7.x/6.x, Power Exchange, Informatica Data Quality, IBM Data Stage 7x, SSIS, Ab Initio

Databases: SQL Server 2008, Oracle 10g/9i/8i, Teradata v2r6, DB2, Sybase, Oracle CRM Package

Languages: SQL, PL/SQL, C, C++, HTML, COBOL, Core Java, JCL.

Database Utilities: BTEQ, Fast Load, Multiload, Fast Export, TPump, TOAD 8.0/7.1, SQL*Plus, SQL*Loader, SQL Navigator

Reporting Tools: Business Objects 6.5, XIR3, Cognos 8 Suite, Micro Strategy

Operating System: UNIX (Sun Solaris 8.0, AIX5.1) and Windows NT/2000, XP.

Scripting Languages: Shell Scripting, Shell, C Shell, Bourne Shell, Bash

Other Tools: Erwin Data Modeler, SmartFTP, WinScp, Putty, emacs, pico, XML Spy 2010

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr ETL/SQL/BI Backend/Database Tester

Responsibilities:

• Extensively written several Test Scripts to compare source and target database.
• Analyzed the requirements and wrote simple to complex queries to test the requirements.
• Performed Dry Run on the test scripts before System Integration Testing.
• Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing
• Validated data from source to stage and stage to target database.
• Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.
• Worked on Informatica workflow monitor to create and execute workflows
• Performed record count from source to target database
• Created Test script for QTP using VB Script
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Extensively worked with flat files and Excel sheet data sources. Wrote scripts to convert Excel to flat files.
• In the process of data migration, migrated data from an Oracle data source to Teradata.
• Prepared test/Seed data for various positive and negative testing scenarios.
• Performed tests to check whether there is any loss of data during data loads
• Tested reports daily, weekly, monthly based reports
• Involved in RDBMS Programming Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming.
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Designed and developed automation framework using custom function / subroutine libraries to support functional / regression automated testing solutions using QTP 10
• Extensively worked on Quality center to execute a bunch of test scripts.
• Logged the defects found in quality center while execution of test scripts
• Tracked the bad records present in the table.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries.
• Validated the data present from flat files to database
• Prepared Test Scripts and test Plan for automated testing using QTP
• Wrote complex sql queries using Teradata sql assistant and toad for various testing purpose
• Developed test/QA environment using Informatica.
• Created mappings and executed workflows using Informatica power center
• Tested Daily, Weekly, Biweekly and Monthly data loads.
• Tested the layout of the table from the database to the data model.

Environment: Teradata SQL assistant 13.0, Micro Strategy, Toad for Oracle10g, Informatica Power Center 8.6.1, MS Excel, Erwin Data Modeler, SQL loader, Quality Center, QTP, Cobol Files, SAM Files, UNIX, Business Rules Repository GUI(BRR), Business Process Application GUI(BPA), Data Quality Monitor GUI (DQM)

Confidential, Bloomington, IL

Sr. ETL Tester

Responsibilities:

• Involved in gathering requirements and analysis for applications.
• Developed Test Plans, Test Cases, Test Scripts for UAT tests.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in Req Pro.
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Execute batch processing and verify the jobs status and data in database tables
• Responsible for designing Framework and executing automation scripts using QTP.
• Tracked the defects using Clear Quest and Quality Center and generated defect summary reports.
• Modified Configuration file according to space constraints.
• Created checkpoints and synchronization points for functional testing using Quick Test Pro (QTP).
• Wrote shell scripts to run PL/SQL programs and job scheduling.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business & Management Teams and End Users.
• Participated in regular project status meetings related to testing.

Environment: Rational Test Manager, Rational Clear Quest, QTP, Quality Center, Java, J2EE, XML Flex, Oracle 10G, TOAD, PL/SQL, DB2, Unix Shell scripting MS-Project, SQL Navigator, Windows XP, Ascential, INFORMATICA

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Did a thorough walkthrough of business requirements and prototypes with Business Analysts, Code reviews with development team and got a good grasp of requirements, functionality of the airline system.
• Developed Test plans by coordinating with other team members on the road map
• Developed test cases by reviewing the requirement documents
• Map-ed the test scripts to the functional requirements in Quality Center 10.0
• Identified Test Data by querying and created Test scripts for SIT, Regression and UAT
• Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application
• Execution of Manual Test scripts and responsible to track and log the defects using QC
• Responsible for data analysis, report validation and functional testing.
• Automation test with QTP record and playback, data driven the scripts.
• Worked closely with Technical Project Managers and Development Team in defect tracking, re-testing and validation.
• Verified bug fixes and tested all impacted modules in application.
• Coordinating with other team members and providing status to project manager.
• Created UAT documentation to be used by users.
• Ensure Requirements Coverage with Traceability Matrices.

Environment: UNIX, SQL, Oracle, J2EE, Java, JSP, Web Services, SOAP UI, Oracle Quality Center, QTP, MS Office.

Confidential

QA Tester

Responsibilities:

• Involved in reviewing Business Requirement Documents and the Technical Specification.
• Used black box testing for working throughout SDLC & test environment.
• Worked with team members in making impact assessment and feasibility analysis
• Assisted with planning, tracking and reporting the team’s progress against schedule and reported status to upper management using Test Director
• Wrote and executed test cases for functional, integration and regression testing.
• Actively participated in Status report meetings and interacted with Development to discuss the technical issues.
• Ran SQL Queries and stored procedures for Database testing.
• Wrote all documentation related to the product testing, managing the bug database and coordinating configuration testing.

Environment: SQL, Test Director, MS Office, ASP

Confidential

QA Tester/ Junior Business Analyst

Responsibilities:

• Reported to the Test Team lead and responsible for the testing of the application with minimal supervision
• Defined test requirements, test scenarios, performed manual tests, and reported the results back to the QA Team Lead
• Analyzed Business Requirements and System Specifications to understand the application.
• Identified and analyzed gaps between current processes and the existing system.
• Performed regression testing for fixes and closed the defects in Test Director.
• Created Requirement Traceability Metrics.
• Created Script Status Reports and Defect status reports.

Environment: Oracle, MS Project, Visio, UML, Test Director