PROFESSIONAL SUMMARY:

• Senior QA Analyst with 7 years of experience developing and executing test plans, test strategies, test cases, test scripts, test labs along with change requests test management and defect management.
• Strong SQL skills with extensive experience using Utility Tools like TOAD for Oracle, Advanced Query Tool (AQT), SQL Server Management Studio (SSMS), SQL Developer, SQL Assistant, and Aginity for querying the databases.
• Well experienced in White box testing, Black box testing, Grey box testing, Load testing, Application testing, Web Services testing, Performance testing, and Regression testing for Data Integration and Data Migration to different environments.
• Adept in creating and maintaining System, Functional, Regression and Integration test cases and verifying accurate test, change and defect documentation to ensure quality and completion and Web Services Testing using SoapUI & Rest in both testing and production support environment.
• Well experienced in managing defects and creating requests through documenting tools like HP ALM/Quality Center/Test Director, Microsoft Test Manager/TFS, Test Track Pro, Quip and JIRA.
• Good Expertise in creating complex SQL scripts for Data Validation, for complex business rules based on ETL mapping documents.
• Created SSIS packages for database migration.
• Experienced in designing and implementing advanced and interactive Business Intelligence Reporting Solutions with Microsoft SQL Server Reporting Services ( SSRS) .
• Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in OBIEE using prompts, filters, and variables
• Good analytical skills to analyze the User/Business requirements and functional specific documents and come up with a working test plan.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Transformation and Loading (ETL).
• Participated in identifying the Test scenarios and designing the Test cases in Selenium IDE.
• Involved in developing and maintaining Test Matrix and Traceability Matrix, and performing Gap Analysis.
• Good experience and understanding of Data warehouse concepts and technologies like ETL, OLTP, OLAP, Normalization/Denormalization, Data Models, Schemas, Data marts, Dashboards and Reporting.
• Good understanding of business models, Entity - Relation Diagrams, and process flows based on UML methodology.
• Good experience working in different industry domains such as Mortgage, Insurance, Healthcare, and Banking.
• Good understanding of all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience using various automated testing tools like HP UFT (HP UFT (QTP)), HP UFT 12.0, Selenium, Load runner, Quality Center (QC)/ALM.
• Experience working in AGILE/Scrum and Waterfall environments for different projects and domains.
• Good experience with Client server and web application testing and highly detail-oriented and analytical in providing recommendations and changes to process improvements as needed.
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills, with Ability to quickly comprehend complex business requirements.
• Good experience handling large amount of data and large databases.

TECHNICAL SKILLS:

Documenting/Testing Tools: HP Quality Center, Rally, Version One, Test Track Pro, JIRA, Quip, Confluence

Databases: Oracle, DB2, SQL Server, SAP BI, Teradata, Netezza, Amazon Redshift

Utility Tools: TOAD, AQT v8, SQL Server Management Studio, SQL Developer, SQL Assistant, QTP, FTP Pro, SOAP UI, Query Surge

ETL Tools: Informatica, DataStage, Ab Initio, SSIS

Reporting Tools: OBIEE, Crystal Reports, Micro Strategy, SAP BO.

Operating Systems: Windows, Linux and UNIX

Microsoft Office: Excel, Access, Outlook, Word, and PowerPoint

Programming Languages: SQL, C, and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

ETL/QA Tester

• Working on big scale data migration project in the entertainment domain.
• Responsible for implementation of QA testing processes in Software development lifecycle model.
• Facilitate test design and test case review sessions with SME’s.
• Create complex SQL scripts to validate the data.
• Migrate all data, applications and reports from IBM Netezza to Amazon Redshift cloud database.
• Perform System Integration testing (SIT) and regression testing.
• Perform multiple validation such as Checksum, Stratification, Data integrity and Duplication using query surge.
• Designed and documented QA workflow in Confluence.
• Created Soap UI and Rest using WSDL files given by third party to test the web-services .
• Create and automate web (Selenium), API, and backend application test scripts.
• Create and schedule test suites to validate data in query surge.
• Compare/validate data using Query Surge, an automation tool.
• Analyze and validate BI reports generated in Micro Strategy.
• Document all testing tasks and testing status in Quip.
• Log defects and fix defects using Microsoft Team Foundation Server (TFS ).
• Document defects, perform defect tracking and defect management using Jira.
• Export test case results from Query Surge in excel format and document in Fox box.
• Perform end to end testing on front end applications and reports.
• Created test cases for white box testing for ETL Data flows and Mappings in Informatica.
• Performed performance testing where required.
• Coordinate with offshore team and delegate tasks to expedite QA efforts.

Environment: Aginity for Netezza, Aginity for Amazon Redshift, SOAP UI and rest, Query Surge, Informatica, Microstrategy, Jira, Quip, Confluence.

ETL/QA Tester

• Facilitated test design and test case review sessions with project team members.
• Developed and execute functional, regression and system test cases and scripts.
• Created complex SQL scripts to validate the various database tables and reports.
• Analyzed and validate BI reports generated in Cognos and Micro Strategy.
• Validated AD-hoc reports both in cognos and micro strategy.
• Identify reports that need to decommissioned and validate the reports migrated from one platform to the other.
• Also created SSIS packages for database migration.
• Create Automation Suite for all report related test cases, where required.
• Scheduled and execute test cycles, track results and assist with test repository management.
• Stored and maintained all QA work products in the appropriate SharePoint repositories.
• Created and executed test cases in HP ALM.
• Updated strings in SSIS packages prior to migration.
• Collaborate with all QA Analysts, Project Leads, Business Analysts and Project Managers for gathering metrics and status reporting.
• Perform defect tracking, Test management and defect resolution management using Rally/Kanban
• Communicate defect issues to the development team.
• Actively participate in daily stand-up meetings with the project team for daily status updates.
• Escalate and complete all assigned QA processes and deliverables.
• Participate in peer reviews of project documentation as required.
• The work generally involves all areas of quality assurance testing during a project’s lifecycle.

Environment: SQL, SQL Server Management Studio, HP ALM, Rally, Visual studios, Microstrategy, Cognos, Sharepoint, Unix, Windows.

ETL Tester

• Responsible for implementation of QA testing processes on assigned projects in Waterfall model following Nationwide’s methodologies and standards.
• Facilitated test design and test case review sessions with project team members.
• Developed and executed functional, regression, and system test cases and scripts.
• Tested and validated Data Stage ETL jobs using Data Stage Designer and Director.
• Created test cases and SQL test scripts for validating ODS, STG and EDW tables including dimension and fact tables.
• Analyze business requirements, Software requirement specifications to create test plan and test cases for manual and Automation testing using Selenium Web Driver .
• Used Selenium WebDriver and generate automated test scripts for functional testing, GUI testing and enhancing the existing scripts. Contributed in developing Automation Framework, Selenium WebDriver . Regular expressions are used to perform pattern matching on various set of data by using HP UFT (QTP) utility objects.
• Performed Report testing in a couple of projects using Crystal Reports and TOAD for Oracle.
• Performed ad-hoc data analysis to support BI reporting needs.
• Worked with developers and architects to create testable requirements and functional, system specs.
• Created QA project documentation and deliverables including test plan, test strategy, test design specifications, test cases and automated test scripts using Selenium WebDriver .
• Executed test cases manually in Netezza environment and documented them in HP ALM.
• Scheduled and executed test cycles, track results, test management and assist with test repository management.
• Assist dealers in underwriting contracts by reviewing financial aspect of the application and insuring compliance with Confidential Auto finance policies and procedures.
• Stored and maintained all QA work products in the appropriate repositories in SharePoint.
• Worked with very little to no-documentation to come up with test cases and build SQL test scripts.
• Maintain best practices to ensure data are appropriately secured from security breaches.
• Used Microsoft Test Manager to create test cases for mobile and web testing and create related defects.
• Collaborated with all QA analysts, developers and project managers for gathering metrics and status reporting.
• Performed defect creation, defect tracking and defect resolution management.
• Performed GAP Analysis and interacted with the Business to bring up possible roadblocks and issues relating to the project.
• Communicated defect issues to the development team after performing root cause analysis.
• Signed-off on QA work for production releases in the DW/ETL team.
• Participated in peer reviews of project documentation as required.

Environment: HP UFT(QTP), IBM DataStage, HP ALM, Selenium, SOAPUI, SharePoint, MTM/TFS.

Sr. QA Analyst

• Worked on data migration and reporting projects in the Mortgage domain.
• Created QA project documentation and deliverables including test design specifications, test cases, test labs and automated test scripts, facilitated test design and test case review sessions with project team members.
• Created complex SQL queries involving calculations for YTD Principal Balance, YTD Interest, taxes and fees etc to perform data validation based on the source to target mappings.
• Created SQL scripts for complex FACT and Dimension tables with tight deadlines.
• Developed and executed functional, regression and system test cases and scripts.
• Performed loan level testing as well as group level testing for different kind of loans.
• Used Teradata SQL Assistant to execute all SQL test scripts.
• Liaison between credit and auto finance managers. Responsible for contract agreements and funding process.
• As QA primary responsibility was to review customer accounts and perform remediation actions on projects of high complexity with cross functional impacts for the Auto Finance /Student Lending/Outside Service Provider (OSP) .
• Used conditional formatting to change the behavior of SSRS report depending on the requirements.
• Deployed SSRS reports on report server and assign roles for business users .
• Compared data from Oracle EBS with the OBIEE for data validation.
• Migrated reports from Excel to Reporting Services (SSRS).
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Executed test cases manually, performed regression and recorded all the results.
• Used Informatica Power Designer to check the mappings and the data flow.
• Designing business models, Entity-Relation Diagrams, and process flows based on UML methodology.
• Tested and ran Informatica batch processes prior to data validation.
• Worked on a system which fully supported ARM, GPM, GEM, Interest-Only, deferred payment, home equity, reverse mortgage, second mortgage loan program etc.
• Scheduled and executed test cycles, track results and assisted with test repository management.
• Stored and maintained all QA work products in the appropriate SharePoint repositories.
• Collaborated with all QA analysts, project leads and project managers for gathering metrics and status reporting.
• Created Source-to-Target documents for projects with no proper documentation.
• Documented defects, performed defect tracking, and defect resolution management using Jira.
• Worked with an offshore team to coordinate tasks and for defect tracking and resolution.
• Actively participated in all Agile scrum meetings.
• Escalated issues, had them resolved and completed all assigned QA processes and deliverables in time.

Environment: OBIEE 11g, Oracle, SQL Assistant, JIRA, Informatica, SharePoint, MS Office, Reporting services (SSRS)

DW QA Analyst

• Worked on Reporting Projects developed using OBIEE and which needs to be validated by querying the FACT and DIM Tables associated with it.
• Participated in daily scrum meetings and coordinating QA efforts.
• Represented the QA team by providing all QA progress/updates to the project team.
• Created complex SQL scripts from scratch for testing ETL tables and Reports.
• Worked with OBIEE Reports and validated them against the DB2 database data.
• Analyzed and understood functional and non-functional requirements, business rules associated with different projects.
• Developed test plans and test case strategy for functional testing based on the functional requirement documents.
• Customized OBIEE to improve the screen reader mode for the users and also to enhance certain in built OBIEE feature .
• Used MS Visio to develop test approach and view dataflow designs.
• Used Advanced Query Tool (AQT) to query the DB2 database.
• Wrote complex SQL queries to test FACT and DIM tables.
• Performed smoke testing to ensure the stability of different QA environments.
• Performed regression testing, negative testing and assisted in UAT testing.
• Used HP Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes and update bug status.
• Performed production support for the project, restarted and maintained the OBIEE Servers.
• Documented all test cases, test scripts, test labs and test execution results in Quality Center.
• Raised defects in Quality Center and assigned to developer for fixing and retested them after being fixed.
• Worked in an Agile environment with daily status updates and bi-weekly sprints.
• Worked in an ERP system environment.
• Worked with sensitive data involving PHI, Rx info and customer demographics.
• With Informatica as the ETL tool, validated several tables built using ETL.
• Worked with transformations like filter, joiner, router, look up, aggregator, expression and functions like CASE, IFNULL, SUBSTR(), MAX(), SUM(), JOIN, PARTITION BY, etc.
• Used SAS EG to query the tables and store the datasets.
• Used PuTTY to setup database connections and passwords.
• Created schemas to store huge datasets for retrieving data efficiently while querying.

Environment: DB2, AQT, HP Quality Center, Informatica, Windows, SQL PL, Putty, OBIEE, SAS Enterprise Guide, MS Excel, MS Word.

ETL Tester

• Designed and created test cases based on the business requirements. Also referred Source to Target Detailed mapping document and transformation rules document.
• Worked on extensive data validation using SQL queries and back-end testing.
• Developed test cases for ETL process and reporting.
• Designed and developed team to implement the requirements.
• Developed and performed execution of test scripts manually to verify the expected results.
• Conducted gap analysis, functional testing, user acceptance testing, and system integration testing.
• Prepared test data for executing the test cases.
• Performed UI, Web Services (API) and database application testing.
• Analyzed web services/API functional and design documents and prepared test cases based on user requirements.
• Analyzed the data from other systems and creating the test cases based on it also creating the test data for services testing.
• Conducted black box testing - functional, regression and data driven.
• Opened defects and tracked defect status using Quality Center.
• Worked with an offshore team to coordinate tasks and for defect tracking and resolution.
• Defined the scope for system and integration testing.
• Worked on test scheduling and milestones with the dependencies.
• Used Toad to write SQL and query Oracle database.
• Used SQL Server Management Studio to query SQL Server database.
• Validated prompts, filters, and other features in Cognos reports.
• Tested functionality and non-functionality of reports developed by Cognos.
• Optimized and tuned several complex SQL queries for better performance.
• Performed functionality testing of email notification in ETL job failures, abort or data issue problems.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Tested and ran Informatica batch processes prior to data validation.
• Responsible to understand and train others on the enhancements or new features developed.
• Created and executed test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.

Environment: SQL, Informatica Power Center, SQL Server Management Studio, SOAP UI, Rest, Quality Center, Oracle, Cognos, Toad, Unix, Windows XP.