SUMMARY:

• Senior Data Warehouse QA Engineer with over 8 years of experience in Software Analysis and Testing, focusing on Software Quality Assurance (SQA) of Data Warehouse, Web - based, Client/Server applications.
• Worked as a Test lead and managed 6 QA resources on the on-shore offshore model.
• Worked in an IT environment for various domains including Financial, Banking, and Insurance, Supply Chain.
• Excellent understanding of Software Development Life Cycle and Methodology (Waterfall, Spiral, V-Model, Agile Methodology).
• Hands on experience in reviewing of functional Requirements, Technical Specifications.
• Hands on experience in developing Strategic Test Plans, Test Approach, Requirement Tractability Matrix, Test data set, Defect tracking and reporting documents.
• Experienced in Testing Methodologies, Designing Test Scenarios, Test Cases.
• Good understanding of entire Data Warehouse Architecture, ETL testing Workflow process, data models such as Star Flake, Snow Flake Schema, and Data Marts.
• Extensive experience in analyzing Data Model, Source to Target mapping, ETL Design document, Business Requirement, Functional and Technical Specifications.
• Hands on experience in Data warehouse testing including ETL testing using ETL tool Oracle Data Integrator (ODI), Informatica Power Center and Data Stage.
• Hands on experience in BI testing using OBIEE, Enterprise Performance Management (EPM 11), SAP Business Object, Cognos.
• Hands on experience in testing Reports, Dashboards, Filters, Selections, Prompts and Data.
• Good understanding of Data Modeling in Star Schema/Snowflake schema design, Fact and Dimensions tables,
• Strong experience in writing complex SQL Queries for different Databases such as DB2, Oracle, Sybase, and SQL server.
• Debugged failed SSIS package after verifying server and flat file availability and SQL connectivity
• Experience working in agile environment, analyzed and reviewed Product backlogs, Task boards, User Stories for different Sprints in Microsoft Test Manager (MTM).
• Well experienced in using ALM, Quality Center for Requirement, Test management, Defect management, Release and Cycle management.
• Hands on experience in preparation of Test Data for positive, negative and boundary testing scenarios.
• Excellent communication, documentation and problem-solving skills with a strong technical background.
• Quick learner, proven ability to work excellently and efficiently in both independent and team work environments.
• Built a dynamic relationship with the client, development, and other teams to ensure the highest quality deliverable possible and to deliver them on time.

TECHNICAL SKILLS:

Language: VB.NET | VBScript | ASP JAVA | .NET Framework | .Net 4.5 | Visual Basic | SQL | PL/SQLSoftware: JIRA | Confluence | Microsoft Office 2003/2007/2010 | MS Project |

Data Warehousing: DataStage 9.1/8.1 | ODI 11.1.1/10.0 | Informatica Power Center | Neteeza | Aginity Workbench| Master Data Management (MDM) | IBM Initiate Master Data Engine | IBM Workbench & Initiate Inspector

Reporting: OBIEE | BI Publisher | EPM 11 | SAP BO | COGNOS | Business Object

Tools: ALM | Quality Center | JIRA| Zephyr |Subversion |Microsoft Test Manager (MTM) | TFS | MS Visual Studio | HP UFT (QTP) | TOAD |Oracle SQL Developer

Databases: Oracle | MS Access | DBMS | DB2 | Informix | SQL Server

Methodologies: Waterfall | V model |Agile |Validation and Verification

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Sr. Data Warehouse Tester

Responsibilities:

• Participated in requirements definition reviews and functional specification reviews to ensure that critical information is included and testability requirements are met
• Participated in gap analysis for the given requirement, Mock up reports and dashboards for review by the business users
• Analyzed the Technical design specification documents, business rules, data validation specifications to identify deficiencies in test plans and procedures, and enhance test coverage accordingly
• Responsible for developing test cases to validate the ETL process, business rules, Data transformation rules and data quality.
• Responsible for developing and executing test cases to validate the Tables/View structure, Data conversion, Data Mapping between source to staging, Staging to EDW and EDW to Data Mart
• Responsible for writing and executing the test cases to validate the Transformation rules, Records counts, Logical and physical deletes, exceptions and errors for different stages of ETL
• Created requirements and Test matrix for ETL and Reporting Test cases in ALM
• Develop test cases using standard test case template in Excel sheet and upload in ALM
• Validated all the prompts from the summary reports are getting applied to the detail report
• Validated if the summary report is working from charts, tables, table headings, counts are matching between the summary and detail report where appropriate
• Created and executed regression test cases for 100+ reports and Dashboards during OBIEE upgrade from version 10.x to 11.x
• Performed the regression testing after upgrade from OBIEE 10G to 11G and tested functionality and Security
• Document software defects in defect tracking system ALM and keep defects up to date
• Prepared test progress and defect report and communicate to the management
• Facilitate defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status
• Developed and generated test progress and defect reports from ALM
• Responsible for validating the files availability, format and data on UNIX server
• Utilize defect tracking tool ALM to trace, assign, verify and close defects
• Facilitated defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.

Environment: ALM 12.1, JIRA 6.3.7, IBM MDM, WebSphere, IBM Initiate MDM Engine, IBM Initiate Inspector, IBM initiate work bench Oracle 11i, OBIEE 10.1.3, EPM 11, DataStage, TOAD, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion.

Sr. Quality Assurance Engineer

Responsibilities:

• Reviewed the Requirements documents, Design documents, Data design/flow, Data mapping documents and used test cases.
• Participated in requirements, Design and functional specification review meetings.
• Develop and maintain Functional, Integration, Security and UAT Test plans.
• Works closely with the Architect and CM Team by actively engaging with identifying environmental needs for the testing team and the initial set-up of the environments
• Attended Walkthrough Meetings
• Developed Test Plans and Test Cases, positive, negative and boundary testing as well as ad hoc testing to support FSA.
• Tested RESTful service with Biztalk orchestration to submit JSON reports with 4 Inputs and 11 Services
• Tested and validated data on Microsoft SQL Server in support of FSA file submission, identifying errors and communicated those errors back to FSA testers.
• Alerted Development to system failures on a real time basis and called attention to breaks in the system.
• Attended joint meetings RMA and FSA and presented progression and areas of concern for both parties.
• Consulted Management when issues arose which could hinder the Project to success.
• Helped team member’s with accessing the database, applications in different QA environments.
• Researched live data from FSA tables to support JSON submission through ACRSI process in Production.
• Developed and maintained Traceability between requirements and test cases to ensure that testability requirements are met.
• Responsible for conducting QA entrance and exit criteria meetings with project stakeholders
• Worked on Agile Methodology framework with respect to the change in application requirements so as to achieve the target in stipulated time.
• Actively participated in smoke, functional, regression, integration and ad-hoc testing during QA and STG phase of SDLC.
• Developed system test scenarios and test scripts using modular approach of scenarios development, prepared test data set and uploaded in MTM for execution
• Created various test data sets to check for boundary conditions, positive and negative test data.
• Used MTM for logging & tracking defects and the resolution of the defects.
• Developed and Executed Test Scripts using Selenium WebDriver and analyzed Test Results.
• Involved in preparing test cases using Selenium Web driver to validate all UI components, Pop-ups, Browser navigations, Mouse Movements.
• Developed Selenium Web Driver Scripts for Desktop browsers.
• Performed Functional testing as per user stories and also performed Integration Testing & System Testing using Selenium WebDriver automation scripts.
• Developed Perfecto Selenium Web Driver Scripts and executing test scripts in Parallel Mobile Devices and Parallel Tablet Devices.
• Performed Data driven testing to validate the components displayed on the website using Selenium.
• Performed Browser testing on different browsers like Internet Explorer, Chrome, Safari and Firefox where tests were run.
• Implemented mobile automation frameworks Perfecto using Web Driver.
• Expertise in using UI Automator viewer in Perfecto to inspect elements in mobile applications.
• Implemented Automated execution of tests (nightly and need based) using Maven

Environment: MS Office 2013, Microsoft Project, Microsoft Test Manager 2013, Microsoft Team Foundation Server 2013, Visual Studio 2013, Microsoft SQL Server 2012, SharePoint 2013, JIRA, Agile, Scrum, MS Visio, Selenium Web Driver, SVN, Maven, SOAP UI, XML, Trac, STS, Lotus Notes, JAVA, RESTful API, Agile, GitHub.

Sr. Data Test Engineer

.Responsibilities:

• Involved in gathering business requirement, studying the application and collecting the information from developers, and Drafted Master Test Plan for the project, made revisions and presented to Client.
• Conducted requirements analysis, drafted User Stories to assist BA.
• Analyzed the Technical design specification documents, business rules, data validation specifications to identify deficiencies in test plans and procedures, and enhance test coverage accordingly.
• Participated in Project meetings with EVCH Principles and Sogeti Management Team in project overview, progress, and Budget.
• Participated in Team Lead Meetings for all Teams, provided questions and insight from QA Test perspective.
• Responsible for Test Management in JIRA, providing Test Team with Test Strategy, Test Execution Schedule, reviewing and authorizing test cases.
• Guided the development of the test cases to validate the ETL process, business rules, Data transformation rules, Reports layouts and data.
• Responsible for developing and executing test cases to validate the Tables/View structure, Data conversion, Data Mapping between source to staging, Staging to MDM, and MDM to EDW and EDW to Data Mart.
• Directed the Test Team in writing and executing the test cases to validate the Transformation rules, Records counts, Logical and physical deletes, exceptions and errors for different stages of ETL.
• Created requirements and Test matrix for ETL and Reporting Test cases in Zephyr.
• Validated the access - Security, navigation to a particular screen, dashboard, page, and report for COGNOS.
• Tested right data, screens, dashboards, pages, and reports, response time to access the application, particular dashboard, page and report, capability and ease of using prompts to select data on a report with specific attributes, use of drill down and navigation on Reports for COGNOS.
• Validated all the prompts from the summary reports are getting applied to the detail report.
• Validated if the summary reports are working from charts, tables, table headings, counts are matching between the summary and detail report where appropriate.
• Created and executed regression test cases for 16 reports and Dashboards during COGNOS upgrade from version 10.2 to 11.0.
• Performed the regression testing after upgrade from COGNOS 10.2 to 11.0 and tested functionality and Security testing to making sure the all the COGNOS Security that has been completely upgraded from the previous versions 10.2 to the newer version of COGNOS 11.0.
• Documented software defects in defect tracking system in Zephyr, created tasks in JIRA and kept defects up to date.
• Prepared test progress and defect report and communicate to the management.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.
• Developed and generated test progress and defect reports from Zephyr.
• Responsible for validating the tests documents availability in Confluence.
• Utilized JIRA for time estimation, logging time to tasks, Sprint management.
• Assisted Project Manager in training Team Leads on time reporting in JIRA.

Environment: JIRA 6.3.7, IBM MDM, WebSphere, IBM Initiate MDM Engine, IBM Initiate Inspector, IBM initiate work bench Oracle 11i, OBIEE 10.1.3, EPM 11, DataStage, TOAD, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion.

Sr. Data Warehouse Test Engineer

Responsibilities:

• Involved in gathering business requirement, studying the application and collecting the information from developers, and business.
• Review and analyze the Requirements documents, Design documents, Data design/flow, Data mapping documents and used test cases.
• Participate in requirements, Design and functional specification review meetings.
• Developed and maintain Functional, Integration, Security and UAT Test plans.
• Developed and maintained Positive, Negative and Boundary condition Test Scenarios, Test cases, and Test data for Functional, Integration, and Security Testing.
• Developed and maintained Traceability between requirements and test cases to ensure that testability requirements are met.
• Responsible for conducting QA entrance and exit criteria meetings with project stakeholders
• Worked on Agile Methodology framework with respect to the change in application requirements so as to achieve the target in stipulated time.
• Worked in an agile environment and developed Test suites and Test cases.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tested all OBIEE Dashboards according to the requirement.
• Validated the Security, navigation to a particular screen, dashboard, page, and report for OBIEE.
• Validated access for data, screens, dashboards, pages, and reports, response time to access the application, particular dashboard, page and report, capability on Reports for OBIEE.
• Validated if the summary reports are working from charts, tables, table headings, counts are matching between the summary and detail report where appropriate.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Tested all OBIEE Dashboards according to the requirement.
• Written several complex SQL queries for validating OBIEE Reports.
• Testing has been done based on Change Requests and Defect Requests.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used Quality Center for bug reporting. Tracked and reported the bugs with Quality center

Environment: ALM/Quality Center, Power Center 8.6.1, OBIEE 10.1, PL/SQL, BO, SQL, SQL Server Analytical Server, SQL Server Reporting Server, Oracle, Agile, Scrum, SQL, Oracle.

Sr. Automation Tester

Responsibilities:

• Identifying the feasible automation test scenarios from the manual test cases.
• Participated in peer review with team and developers to review test cases/test scripts.
• Involved in the migration of Selenium RC Scripts in to Selenium Web Driver Scripts.
• Performed System, Integration, Smoke, Sanity, Functional, Back-end, Positive and Negative and monitored the behavior of the applications during different phases of testing using testing methodologies.
• Regression testing was performed after each build release of the application and updated the Scripts by executing the Regression suites built using Selenium and approve for regression suit.
• Used Hybrid Framework of Selenium to get data from Excel.
• Created Selenium Test cases for automation using Selenium Web Driver and Java.
• Interacted and worked with the development team to analyze the defects and reported them in Quality Center and tracked them for closure.
• Parallel, Cross - Browser Testing using Selenium Grid and TestNG.
• Participated in weekly QA status and project status meetings to report any defects and issues encountered in application.
• Creating and updating automation scripts for Regression Testing.
• Prepared Test Execution Reports and Reviews.
• Designing the test cases based on test scenarios and executing test cases.
• Created and executed detailed test cases with step by step procedure and expected results and maintained the test logs, test reports, test issues, defect tracking using Trac.
• Supported UAT testing and created defect guidelines documents for users using Quality Center.
• Facilitated defect review meetings and improved existing defect management process, driven team to work in the faster manner by reporting defects status.
• Utilized defect tracking tool HP Quality Center to trace, assign, verify and close defects.

Environment: Selenium WebDriver, Selenium RC, Java/J2EE, JavaScript, Eclipse, SVN, Java, Lotus Notes, Trac, SVN, Maven.

Programmer Analyst/QA Analyst

Responsibilities:

• Reviewed and analyzed the user stories, Design documents, Data design/flow and Data mapping documents.
• Coordinate with cross-project teams on business and unit functional requirements and drive integration and non-functional test requirements.
• Developed Test Scenarios and Test cases for Data Conversion, Functional, Integration, Security and UAT testing using Quality Center.
• Created web forms using ASP.NET for developing interactive pages.
• Implemented MVC framework and Developed Views, controllers and business logic models using C#.
• Designed and Developed SSIS packages to load the data from various trading subsystems in flat file format and
• Loaded in to the databases.
• Documented the report with ERD tables.
• Interacted with end users and investigated issues related to the QA.
• Responsible for maintaining versions of source code using GIT
• Supported UAT testing and created defect guidelines documents for users using Quality Center.
• Involved working with the agile team in SCRUM framework.
• Involved in understanding, creating and updating Specification Requirement Document (SRD) and Report Specification Document (RSD) to write test cases in different Sprints.
• Worked with cross functional team including business analyst, Product Owner and agile team to discuss the requirements, design, backlogs, and used cases.
• Created test cases and test data for different Sprints in Agile Testing following.
• Responsible for developing and execute the test cases for System and Integration testing.
• Tested XML transmission and verified inbound-outbound XML using a SOAP UI.
• Developed and customized XML scripts to access and execute embedded in the WSDL file.
• Identified and replaced actual value and Aut and selected the correct outgoing WSS while running the XML script in SOAPUI.
• Modified end points when we worked on different servers and different versions of Web Services.
• Performed web specific testing like Link checking, Browser page testing, Application Testing, and Security Testing.
• Verified the database using SQL queries to make sure right data was created in the application.
• Facilitated as UAT (User Acceptance Testing) lead and worked closely with users and supported in test execution and defect management during UAT.
• Involved in sending weekly/Sprint Status report that cover defects, test coverage and test results.
• Worked closely with development team in defect review and kept track of the defects.

Environment: C#, ASP.NET MVC 4.0, AJAX, HTML, CSS, JavaScript, Visual Studio 2010, Quality Centre 9.0, SOAPUI, Webservices, .NET, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion, XML.