SUMMARY

• Software Test Engineer with over 8 years of experience in Software Testing, IT support, Test Automation development and testing ETL, Data warehouse, Client/Server and web applications.
• Expertise lies in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• Extensively used HP Quality Center and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate - wide-ETL solution using OLTP, OLAP
• Experience in Testing BI applications using OBIEE, SSRS.
• Diversified experience in Manual and Automated testing; extensively used automated Testing Tools such as Mercury Interactive Test suite in both Windows and UNIX environment (Win Runner, QTP and Test Director).
• Worked with continuous components and XML components in Ab Initio.
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center(QC )11,/ALM, Test Director, JIRA, Clear Quest
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Manage assigned risks and monitor potential impacts as part of the data migration plan.
• Analyzed trading partner specifications and created EDI mapping guidelines
• Experienced in dealing with clients to gather requirements, understanding the Business Requirements, product demonstrations and providing product support.
• Experience in implementing SDLC Methodologies like Agile, RAD, Waterfall and V Model
• Writing and executing SQL queries to ensure data integrity to meet user requirements exposure in Database testing.
• Created automation scripts with Win Runner for all the components of application.
• Experience in data analysis and problem solving with large amounts of data
• Extensively used ETL methodology for supporting data extraction, transformations and loading Processing, in a corporate-wide-ETL Solution using Informatica.
• Work across multiple functional projects to understand data usage and implications for data Migration.
• Proficient in automating the QA process using various automation tools QTP, Load Runner, & Quality Center.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Experience with managing/tracking defects using defect tracking/reporting tools - Quality Center,JIRA, Rational Clear Quest.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Experienced in web and client/server applications QA testing.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

QA Analyst

Environment: Teradata Database, ALM, Datastage

Responsibilities:

• Requirements analysis and understanding to draft Test cases and prepare test data
• Performed Application checkout, Sanity Testing, Regression testing including functional and non-functional testing in SIT environment.
• Different type of claims I used to validate from different vendors
• Prepared Daily Status Report and Test Summary Reports.

Confidential, Strongsville,OH

Sr.QA Tester

Environment: Informatica 9.1 (Power Center, Power Exchange), Agile, Dat Files, Flat Files, Teradata, ALM, Mainframe

Responsibilities:

• Reviewed Business Requirements, System Specs and Training Material for accuracy. Planned, developed and executed test plans, including detailed test scripts.
• Implemented and Executed SQL queries weekly to populate tables on Teradata from legacy Mainframe database
• Responsible for analyzing requirements, Prepared and wrote test plans and test cases
• Worked under development method Agile (Methodology) and SDLC.
• Used InformaticaETLtool for Extraction, Transformation and Loading the data into
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• 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
• Test input/output on Unix operating system to check the Data integrity
• Retest the Defect fixes. Used Clear Quest for the Defect Management process
• Developed test reports and participated in testing prioritization and archived test results and user signoff.

Confidential, Mooresville, NC

ETL Tester

Environment: Informatica 9.1 (Power Center, Power Exchange), Dat Files, Flat Files, Oracle 10g, SQL Server, Teradata, WINSCP 3, ALM Quality Center 12.1, Windows 7

Responsibilities:

• It's a self-drivenecommercePOS retail systems. Possesses strong testing script creation skills on Verification and validating the features functionality in agile and Waterfall methodology.
• Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
• Involved in developing the Test Cases, Test Plans and Test Scripts using the Business Requirement
• Involved in writing the Test Cases, Test Plans and Test Scripts using the Business Requirement
• Involved in Manual Testing of the Application.
• Involved in Positive and Negative Testing.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Completely involved in developing Test Plans and developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
• Used various SQL queries to validate the test case results for back-end test cases.
• Extensively used ALM Quality Center and created Test Cases in the Test Plan according to the specifications.
• Extensively used Clear quest for the Defect management process

Confidential, Herndon,VA

ETL Tester

Environment: Informatica 9.1 (Power Center, Power Exchange), Agile, Toad for Oracle 10.5, Toad for Data Analysts 2.6, WINSCP 3, Hive, Control-M, Quality Center 9.2,Ksh Scripts, UNIX

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes and attending user review meetings and documenting User Acceptance Criteria.
• Used agile methodology and was involved in the entire software development Life Cycle of the project from Initiation to Implementation.
• Performed Structural and Functional Back-End testing so as to check validity of data on the databases. Setting up the Back-End Testing environment and strategies for the project.
• Used Inner and Outer Joins in order to retrieve and validate the Various Transaction Details from multiple tables.
• Created sql queries for automated data verification framework.
• Planned, designed and executed test cases based on Requirement Specifications Document and developed manual test cases for Positive, Negative, Functional and Performance testing.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Tested loading of data into Data Warehouse, which is in Star schema model.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Ran Control-M jobs to load the data in to various tables
• Ran automated data verification framework jobs to perform Regression Testing.
• Extensively used Clearquest for the Defect management process
• Worked with Business Users to develop Test cases for user acceptance testing.
• Performed Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).

Confidential, Boston, MA

Automation Tester

Environment: Informatica Power Center 9.1, Quality Center, Ab Initio GDE 1.15.7, Windows NT,Oracle11i/10g, MYSQL Server, SQL, PL/SQL, SQL*Plus, Toad, OBIEE, VSAM Files, XML, XSD,HP Quality center.

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation .
• Tested complex mappings using Mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Developed Informatica Mappings using various Transformations and MYSQL Packages to extract, transformation and loading of data.
• Extensively Used HP Quality Center (QC)/ALM as test management tool and Created and maintained the defects in HP Quality Center/ALM.
• Extensively used Informatics power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Confidential, Buffalo, NY

QA Analyst/ Abinitio Tester

Environment: Test Director 8.0, SQL server 2005( SSIS, SSRS ), SSAS, Informatica 8.x, SQLServer, DTS Packages, Remedy, Windows NT, UNIX, MS Excel, VSS(Visual SourceSafe), Quality Center 8.2, QTP 8.2,AbInitio GDE1.12,TFS,Jira.

Responsibilities:

• Projects were in different methodologies like Waterfall and AGILE, well versed with both Methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Gathered UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
• Extracted data from various sources like Oracle, flat files andSQLServer.
• Installing, Configuring and maintaining of QTP Tools.
• Utilize various AbInitio components like Lookup, Join, Rollup and Reformat to process data.
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Assigned users in TD administration, Created Test folders in Test Directors users in Project Customization.
• Experienced in writing complex SQL queries for testing data in oracle targets. Prepared test data to validate ETL rules wherever necessary
• Analyzed test cases for automation and created scripts for regression testing using QTP Automated Test cases for the purpose of regression testing.
• PerformedIBMCuramSoftwareTesting on both Citizen and Casework portals
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next Version.
• QTP was used to generate automated Test scripts for functionality and GUI Testing.
• Communicated with Developers regarding technical issues.
• Used Remedy in trouble ticketing and moving projects from testing to pre-production Environments. VSS to upload track and manage scripts and documents.

Confidential, Stamford, CT

Database Tester

Environment: IBM Web sphere, Data Stage 9.1/8.5/ 8.0.1/8.0/7.5/7.1 , HP Quality center9.2, QTP 9.2 Oracle 9i/10g, MYSQL, OBIEE 10.1.3, SQL server SSIS (2005), SQL server SSRS (2005), SSAS, Teradata V2R6, Windows 2000, SQL, SQL Plus, UNIX, Rational Clear Case, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL,HP,ALM,AbInitio GDE1.14,TFS,PL/SQL,Load runner.

Responsibilities:

• Verified the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.
• Create Data Stage Parallel Jobs to extract, transformation and loading of the data using Data Stage Design toll in the parallel processing mode.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster Moment of data.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Performed the Unit and functional testing which validate the data is mapped correctly which Provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Expertise in Cube designing in Business Intelligence Development Studio (SSAS ) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension Relationships, calculations.
• Created complicated reports using SSRS, SSAS to display key performance indicators and upload to Teradata tables using Teradata utilities FASTLOAD. Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data Transformation, data quality, integration testing, UAT & regression testing.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs.
• Developed and tested transformation functions and record formats for various input data files.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Written complexMYSQLqueries for validating the data against different kinds of reports generated by Business Objects
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted weekly batch testing to in corporate changes in new builds.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Confidential

BI ETL/Quality Engineer

Environment: Informatica 8.1,Test Director 8.0, Win Runner 5.0, Load Runner, Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005, SSIS, SSAS, SSRS, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP,AbInitio GDE1.13,TFS

Responsibilities:

• Involved to create Business Risk Levels to determine Test Priorities.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, Involved in both Manual and Automation Testing.
• Performed Regression testing using Test Director.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Used Test Director a workflow automation tool for defect tracking and product automation.
• Created User Defined Functions and procedures in Test Director Library to re-use them in Different tests.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems Including Oracle and Teradata.
• Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services
• Created variety of reports from SSAS cubes
• Defining and performing the Test strategies and associated scripts for the verification and Validation of the application and ensuring that it meets all defined business requirements and Associated functionality.
• Designed the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Working as Technical for QA on three different projects. One of the most important project was evaluating Automation Test Tool for QA. Evaluated Win Runner
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down.
• Tested OLAP cubes and SSRS reports for various business needs. level test cases and test procedures for Unit Testing on reinsurance and documented them.
• Created User scripts using Load Runner by recording, incorporating Transactions, and think time.
• Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.