Professional 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.
• 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, 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.0,
• GUI Tools : TOAD, Oracle SQL Developer, SQL Plus, SQL server

Professional Experiences

CONFIDENTIAL

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, SOAP UI, 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

ETL QA Tester/BI Tester N19th st Race st

CONFIDENTIAL

• is an independent licensee of the CONFIDENTIAL
• Association, serving the health insurance needs of CONFIDENTIAL
• and southeastern Pennsylvania. Changing the Game by finding innovative solutions to enhance the health and wellness of the people and communities we serve while delivering competitively priced health care products

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, SOAP UI, Oracle 10g ,Windows XP/2003, UAT , QTP, Agile, Ration Tools, Clear Quest, VB Script, Excel.

CONFIDENTIAL

ETL QA Tester

CONFIDENTIAL

• price comparison service that uses CONFIDENTIAL
• price comparison service to provide customers with the available commodities for sale on the Web. CONFIDENTIAL
• Shopping team was implementing a recommendation algorithm to its customers based on the ratings of the products bought by customers and features of the products by learning the user- browsing trends.

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Perform manual testing and created various test results to track the testing results.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle STLC to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports TAR and stored them into the Quality Center.
• Tested Multi-dimensional Objects Cubes, Dimensions using SQL Server Analysis Services SSAS .
• Responsible for testing packages using SSIS ETL to verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
• Worked in a team adopting Agile software development methodology
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment: ETL, BI, SQL Server, Quality Center 9.2, Web Services/Web methods, XML, SOAP UI, HTML, Oracle, SQL,ALM, TOAD, Agile, Windows 2003/2007, UNIX.

CONFIDENTIAL

ETL QA Analyst

• one of the life insurers, is a joint venture CONFIDENTIAL
• offers comprehensive life insurance and retirement solutions for long-term savings and protection to customers.

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, SOAP UI, Rational Functional , Tester, Rational Clear Quest, Rational RequisitePro Oracle 8i, QTP, UNIX.