PROFESSIONAL SUMMARY:

• 8 years of extensive experience as a QA Test Engineer (Manual and Automation Testing) involving in the entire SDLC and working with Client Server, DWH ETL/BI Reports, Web, Backend, Database applications.
• Extensive experience in the Information Technology industry, involving analysis, ETL and BI testing of Data warehouse applications and reporting applications.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios. Proficient in Rational Clear Quest, Jira and Quality Center/ALM for Defect Tracking
• Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
• Extensive Experience in Agile, Scrum Methodology and waterfall methodologies of SDLC.
• Well experienced in writing complex SQL queries for extracting data from multiple sources. Experience in Performance Tuning of SQL and Stored Procedures.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Proficient in HP s Quality Center/ALM for Test Designing, Requirement Mapping, Reports and Defect Tracking . Hands on expertise in Data ware housing concepts and tools.
• Extensive experience working with ETL tools like Datastage, Informatica, Abinitio, SSIS,and Autosys tools.
• Good experience in SSRS, Cognos, Hyperion, SAS, Microstrategy and Business Objects Reports testing.
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and working with slowly changing dimensions Type I II and III.
• 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:

Testing Methodologies: Object Oriented, Keyword Driven and Data Driven testing, Requirement based, Risk based, Priority based test methodology

Mercury Interactive: Quick Test Pro, Business Process Testing,, Test Director, Quality Center

ETL Tools: Informatica 7.1/8.x, SSIS 2008

Bug Reporting: Rational Clear Quest, Test Director

Version Control: Rational Clear Case 7.1/7.0.1/7.0.0Scripting languages: VB Script, HTML, Shell Scripting

Operating Systems: Windows XP/NT/2000/Vista/7, DOS, UNIX

Databases: NoSQL, Oracle 10g/9i, MS SQL Server, IBM DB2, Teradata, MS Access

MS Suite: MS Office 2007 (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Richfield, MN

Sr. QA Tester

Responsibilities:

• Participate in the analysis of business requirement, functional and technical design.
• Involve in developing detailed test plan, test cases and test scripts for functional, system and regression testing.
• Test 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.
• Tested data from various sources like Oracle, DB2, flat files, XML’s, and SQL Server
• Review test plan, test cases, test results for functional, system with the development, BA’s and SA’s.
• Involve in data mapping specifications to create and execute detailed system test plans.
• Demonstrated experience in QA, SIT and UAT testing for a large data warehouse
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• 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.
• Performed extensive DATA validation using SQL queries and back-end testing. Used SQL for Querying the SQL server database in IT and UAT environment.
• Used Teradata SQL Assistant for Querying Teradata and Advanced query tool for querying DB2. Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Worked with the DW Architecture team in Testing complex Delta processing Loads. Performed performance tuning by optimizing Target, Source, Mapping and Session.
• Involved in migration of mappings / workflows from Development to Testing and to production.
• Worked on validating REST API services using SOAP UI.

Environment: BI Cognos, Salesforce lightening, HP Quality Center/ALM, DB2, SQL, PL/SQL, Oracle, SOAP UI, XML, IBM, QTP, Teradata, XML, web services.

Confidential, Whitewater drive, MN

Sr. QA Tester

Responsibilities:

• Participate in the analysis of business requirement, functional and technical design.
• Involve in developing detailed test plan, test cases and test scripts for functional, system and regression testing.
• Provide test documentation and reports to test and project management.
• Test 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.
• Tested data from various sources like Oracle, DB2, flat files and SQL Server
• Review test plan, test cases, test results for functional, system with the development, BA’s and SA’s.
• Involve in data mapping specifications to create and execute detailed system test plans.
• Run jobs using IBM Tivoli Workload Scheduler in stage, development and in production environment.
• Demonstrated experience in QA, SIT and UAT testing for a large data warehouse
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• 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.
• Performed extensive DATA validation using SQL queries and back-end testing. Used SQL for Querying the Oracle database in UNIX environment
• Used Teradata SQL Assistant for Querying Teradata and Advanced query tool for querying DB2. Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Worked with the DW Architecture team in Testing complex Delta processing Loads. Performed performance tuning by optimizing Target, Source, Mapping and Session.
• Involved in migration of mappings / workflows from Development to Testing and to production.

Environment: ETL Datastage, BI Cognos, HP Quality Center/ALM, DB2, SQL, PL/SQL, Oracle, Shell Scripting, SOAP UI, XML, UAT, IBM,QTP, Teradata, XML, web services and UNIX.

Confidential, NYC, NY

Sr. QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center/ALM.
• Worked with ETL group for understating mappings for dimensions and facts.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center/ALM for Functional and Regression Testing .
• 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.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) Written several complex SQL queries for validating Cognos Reports.
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables.
• Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI Managed and executed the test process, using Agile Methodology.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Coordinate very closely with the developers regarding functionalities and defects.
• 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.
• Raised defects in HP Quality Center/ALM defect tracking system.
• Provided the Test status to the Tech lead, Project lead and the team mates. Effectively communicated testing activities and findings in oral and written formats.

Environment: DWH ETL Informatica, BI Cognos 8.0 Series, Oracle 11g, SQL, PL/SQL, UNIX, Teradata, SQL Server 2008, Quality Center/ALM, UAT, SOAP UI, XML, Webservices, QTP, Java, HTML and ClearQuest, .

Confidential, PA

QA Tester

Responsibilities:

• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Involved in migration of ETL Informatica mappings / workflows from Development to Testing and to production.
• 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.
• Written test scripts to compare OLTP vs OLAP for ETL testing
• Involved in gathering and analyzing the user requirements in coordination with Business.
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Performed Quality Center reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Worked with the DW Architecture team in Testing complex Delta processing Loads. Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Performed performance tuning by optimizing Target, Source, Mapping and Session.

Environment: ETL Informatica Power Center 8.6, BI Business Objects, Teradata V2R6, SQL, PL/SQL, Oracle 10g, Shell Scripting, Quality Center, Oracle 9i, UAT, QTP, SOAP UI, XML, web services and UNIX.

Confidential, Nashville, TN

QA Tester

Responsibilities:

• Worked on data profiling for multiple compliance feeds.
• Did lot of ETL testing based on ETL mapping document for data movement from source to target.
• Used Mercury Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.
• Extensively used Clear Quest for tracking and reporting bugs.
• Developed the ETL process to automate the testing process and also load the test data into the testing tables.
• Categorized bugs based on the severity and interfaced with developers to resolve them. Maintained Test Logs, Test Summary reports and participated in defect review meetings.
• Made Change Requests for failed test cases and assigned them to responsible developers
• Developed complex SQL scripts/queries for data verification to compare the expected results with database and analyzed the data and the calculations in the mapping for its correctness.
• Executed camp Confidential n based on customer requirements and followed company code standardization rule
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Performed extensive data validations against Data Warehouse
• Loading Flat File Data into Teradata tables using Unix Shell scripts. Preventing occurrences of multiple runs by flagging processed dates

Environment: ETL Informatica, SQL, PL/SQL, QTP, Excel Pivot, SSIS, Oracle, Cognos 8, DB2 UDB, WinSQL, UNIX and Quality Center.