SUMMARY

• Over 6 years of experience as Quality Analyst, vast knowledge of Software Development Life Cycle & its methodologies, expert in QA testing of Web Based, client/Server, ETL and BI applications.
• Expert in using the Agile, Scrum and Waterfall testing lifecycle Methodologies
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Experience in both manual and automation testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and HP ALM/Quality Center.
• Expertise in test strategy design based on the various types of testing including integration, function, system, End to End, load, stress and performance testing, Backend(Database) Testing.
• Worked on Web - services applications, using SOAP UI tool, to create a Web Service Test from SOAP request and validate the response against the database.
• Interact with clients for Quality discussions and responsible for the QA deliverables.
• Experienced with ETL tools like Informatica, SSIS, Ab Initio and Data stage.
• Proficient in SQL query and testing RDBMS such as SQL Server, Oracle, MySQL for data validation.
• Expertise in Microsoft office (Word, Excel, Power Point, Outlook & Visio).
• Proficient in using SQL Queries using TOAD & SQL developer to ensure data consistency of front-end and raw feed by developing and executed complex SQL queries for data base.
• Strong experience in testing ETL applications and BI reports including Business Object and Microstrategy.
• Developed and tested dependent test cases through Batch Testing using scheduling tools like Autosys and control m.
• Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Clear QUEST, Bugzilla, and Email (outlook).
• Excellent Communication and interpersonal skills with clear understanding of business processes and ability to work as part of team or individually.

TECHNICAL SKILLS

Defect Tracking Tools: HP Quality Center/ALM, IBM Clear Quest 9.0, QTP, Bugzilla and Jira

ETL Tools: Informatica 9.0, Data Stage, Ab Initio 1.15, SSIS

BI/Reporting Tools: Business Objects, Microstrategy, SSRS, SSAS, Crystal Reports, Cognos 8.4

Operating System: Windows 98/XP/2000, UNIX, Linux

Methodologies: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages: SQL, PL/SQL, XML, java, C, Perl scripting, VB

RDBMS/ Database: SQL Server, Oracle, IBM DB2, Teradata 12.0GUI Tools: TOAD, Oracle SQL Developer, SQL* Plus, SQL server

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

QA Analyst/ETL Tester

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Extensively ran the Informatica workflows and mappings through workflow monitor, monitored the log files and involved in finding the root cause of the failures.
• Responsible in testing Initial and daily loads of ETL jobs.
• Extensively used Quality Center (ALM) 11.0 for executing test scripts, Storing Test Results and Test Cases.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Tested Informatica workflows for various ETL data mapping requirements.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports andSQAReport.
• Involved in validating the data profiling and data analysis performed using data flux.
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Extensively usedRational Clear Questto track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Microstrategy Reports for data quality, fonts, headers, footers, and cosmetics.
• Validated SSIS ETL Packages as per the data mapping requirements.
• Involved in testing SSRS Reports according to report specification documents.
• Extensively involved in testing theETLprocess of data sources, SQL Server, Oracle, flat files into the target file, Oracle database as per the data models.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future references.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Informatica 9.0, Microstrategy, HPQC (ALM) 11.0,Rational Clear Case, Rational Clear Quest, TOAD, Putty, Oracle 10g, SSIS, SSRS, SQL Server 2005, SQL, Linux

Confidential, Columbus, OH

ETL Tester/Data Analyst

Responsibilities:

• Tested the data warehouse with the help of data mapping document for various data feeds.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Defects were tracked and prioritized using HP ALM/Quality Center and analyzed the variation between expected result and actual result.
• Coordinated between offshore and onsite team and managed the entire project for testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive data validations against Data Warehouse.
• Logging and tracking defects on a release basis using HP ALM/Quality Center.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Performed Web Services Testing and XML validation by creating test suite using SOAP UI for Security Application communication.
• Did extensive work with ETL testing including strategies like Data Completeness, Data Transformation & Data Quality for various data feeds coming from different source systems.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
• Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Used my web service expertise in testing web services via SOAP, using the open source testing tool SoapUI.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested Business Objects reports and written test cases using HP Quality Center.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating with the Business Team.
• Tested several reports developed in Business Objects.

Environment: DWH ETL Informatica 8.6.1, XML, XSLT, PERL, Business Objects XIR3, SQL Server 2008, XML, QTP, HP ALM/Quality Center 11.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 10g, PL/SQL, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Philadelphia, PA

ETL QA Tester/BI Tester

Responsibilities:

• Analyzed the existing system and process gaps in context of new conversion of Flagstar and bank changes.
• Conducted JAD sessions with management, SME’s, Business users and other stakeholders for open and pending issues to develop specifications.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Written cases to test application manually in HP ALM/Quality Center and automated using QTP
• Written SQL queries manually and also built SQL queries using TOAD to validate the data.
• Tested the Business Objects report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master, Detail and Ad hoc, Dashboards etc.
• Used Quality Center/ALM as repository for maintaining test cases, UAT test plans and tracking the defects.
• Tested web services by generating XML SOAPUI Requests and validated the corresponding XML SOAPUI Responses.
• Extracted data from various sources like flat files and SQL Server.
• Ensured that migrated data is complete, accurate and correct from Oracle database.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Written Test Cases for ETL to compare Source and Target database systems.
• Involved in developing UNIX Shell wrappers to run various SQL Scripts.

Environment: DWH ETL, BI, SQL Server, SQL, TOAD, ALM/Quality Center, MS Office 2007, Oracle 10g, Windows XP/2003, UAT, QTP, Agile, Ration Tools, Clear Quest, VB Script, Excel.

Confidential, NYC, NY

ETL QA Analyst

Responsibilities:

• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Constructed context diagrams and data-flow diagrams based on the description of a business process. Analyzed the data model to code efficiently in SQL.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Used web service description language (WSDL) to provide a model for describing web services.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Involved in debugging of the scripts according to the modifications made to the build using QTP
• Defined and executed test cases across a number of internally developed Front and Middle office applications through Clear Quest.

Environment: SQL, PL/SQL, Quality Center, ETL Informatica power mart 5.1, Toad, Test Director, Rational Functional, Tester, Rational Clear Quest, Rational RequisitePro Oracle 8i, QTP, UNIX.