SUMMARY

• Over 11.10 years of experience in ETL Testing/Data Warehouse backend Testing and BI Intelligence reports testing of which 8 months with Confidential Software Group and 11.2 years with Confidential Limited and TEMPhas worked extensively on various ETL Testing/Data Warehouse Testing engagements for different clients like Farm credit services of Confidential, Confidential Family Insurance, Prime Therapeutics, Confidential, Westpac, Bank of Confidential and Fidelity Projects.
• As a QA Analyst worked on various industry domains like Insurance, Banking and Financial services and Health Care
• Very good experience in all the Testing Phases and Testing Life Cycle Activities.
• TEMPHas very good experience in Agile Testing process (Planview Leankit and MTM) and Risk based Testing.
• Expertise in framing and executing automation scripts for regression and test data creation using CADevTest tool and IDTW Tool.
• Hands on experience in creating Data quality rules in Ataccama tool to validate data quality scenarios
• Expertise in framing SQL Queries as per business requirements.
• Hands on experience in creating and executing workflows in Confidential which is a product platform provided by Confidential Software Inc.
• Requirements Gathering, Testability analysis of requirements, Coordination with business stakeholders, business analysts and developers, Test Plan and scenario creation, Preparation and Review of Test cases, Test Execution, Test Result Reporting, Defects tracking and reporting.
• TEMPHas very good experience working on SQL Developer, WinSQL, Teradata SQL Assistant, Oracle, Greeplum, Toad, Data stage, Python, Advanced query tool, DB2, Microsoft SQL server management studio 2018(SSMS), HP ALM, Jira, MTM/TFS, Confidential applications, UNIX, Mainframes, SAP Business objects, Power BI Reports, control M, informatica Planview Leankit, Microsoft SQL server Integration Services with Microsoft Visual Studio professional 2019, Red Gate Data compare 14, Red Gate SQL Compare 14, Active Batch, Ataccama Data quality tool, One Note and Microsoft Teams
• TEMPHas Onsite experience of 11 Months (Confidential client) and was leading a Team of 6 Members at offshore and 4.7 Years in USA leading a team of 5 Members.
• Offshore Team Management, Issue resolution, co - ordination with multiple stakeholders.

TECHNICAL SKILLS

Domain : Insurance, Banking and Financial services

Technical: Data Warehouse Testing - Greenplum, Oracle, Teradata, DB2, Microsoft SQL server management studio 2018(SSMS), UNIX, Mainframes, SQL Developer, WinSQL, Teradata SQL Assistant, Toad, Data stage, Python, Advanced query tool, UNIX, Mainframes, SAP Business objects, Power BI Reports, control M, informatica, Planview Leankit, Microsoft SQL server Integration Services with Microsoft Visual Studio professional 2019, Red Gate Data compare 14, Red Gate SQL Compare 14, Active Batch, Ataccama Data quality tool, One Note and Microsoft Teams

Test Management Tool: HP ALM and MTM/TFS

Total Work Experience:

Confidential, Omaha Nebraska

Responsibilities:

• Work closely with business users to gather requirements and define project specifications
• Interact with business stakeholders to identify high risk modules and plan risk based testing approach to deliver quality product with reduced cost
• Test Plan and Test Strategy preparation and review with business stakeholders
• Participate in Agile - Scrum sprint planning meetings and Daily scrum meetings to discuss the execution status of QA Cards
• Track QA cards status through Planview Leankit Agile board.
• Responsible for Functional Testing, System Integration Testing, Regression Testing and Post production validation
• Create test cases and review with business stakeholders
• Create and maintain business Requirement Traceability Matrix (RTM)
• Create SQL scripts as per the business requirements
• Validate the data in EDW(EDW FCSA) against different sources like loan accounting system(LAS), LoanIQ system, DNA system etc on daily basis
• Validation of data transformation from EDW FCSA to EDW reporting against the business rules
• Validation of data in various SSAS Cubes (Performance, Growth, financial, portfolio performance etc) through MDX (Multidimensional Expressions) queries and DMV (Dynamic Management View) queries against EDW Reporting data
• Create MDX and DMV scripts to validate the SSAS Cubes
• Data comparison between different environments through Red Gate SQL Data compare tool and SQL Compare through Red Gate SQL Compare tool
• Perform Power BI Reports Test execution against SSAS cubes per business requirements.
• Monitoring the daily batches through Active Batch
• Create and execute Data quality check Automation rules in Ataccama tool to ensure data in EDW TEMPhas no data quality issues like NULL’s, Spaces, incorrect formats (email, phone, SSN), Duplicates, valid Data of Birth’s, Addresses etc on daily basis. All the data quality errors are reported automatically on timely basis with the Development team.
• Test defects tracking and reporting
• Test Status reporting on Daily and Weekly basis to all the stakeholders
• Test Evidence walkthrough and coordination with business stakeholders for User Acceptance Testing
• Create Test closure report and receive signoff from the business stakeholders
• Perform post-production Testing activities

Environment: Planview Leankit, microsoft sql server management studio 2018, Microsoft SQL server Integration Services with Microsoft Visual Studio professional 2019, Power BI Reports, Red Gate Data compare 14, Red Gate SQL Compare 14, Active Batch, Ataccama Data quality tool, One Note and Microsoft Teams

Ranch Business Analytics

Confidential, Madison Wisconsin

Responsibilities:

• Thorough Requirement Analysis.
• Schedule meetings with Business partners and Business analysts for clear understanding of requirements.
• Interact with business stakeholders to identify high risk modules and plan risk based testing approach to deliver quality product with reduced cost
• Participate in Incremental Agile - Scrum sprint planning meetings and allocation of tasks for each sprint per project schedule
• Test Efforts estimation
• Test Plan and Test Strategy preparation and review with business stakeholders
• Responsible for Smoke Testing, Functional Testing, System Integration Testing, Regression Testing and Post production validation
• Create test cases for complex modules and review with business stakeholders
• Create and maintain business Requirement Traceability Matrix (RTM)
• Test Data creation (Policy and claims Creations) as per the requirements in policy center and claims center which is a product platform provided by Confidential Software Inc.
• Create SQL scripts as per the business requirements
• Perform BI Test execution in Oracle and Greenplum, BI Reports Validation as per business requirements.
• Create and execute excel macros for Daily smoke Test validations
• Validation of data flow from Confidential DB to Analytical data warehouse through Operational Data Store (ODS) and conformed storage area (CSA)
• Validation of business intelligence reports, financial reports, state-specific reports and external regulatory reports per business requirements
• Validation of data for all the policy Transaction types (Submission, Issuances, policy change, cancellation, rewrite, reinstatement, renewal) and all the claims Transaction types(payments, Reserves, recoveries, recode, Transfer, Bulk payment, partial payment, Bulk invoice payment)
• Perform reconciliation validation for premiums amounts, exposure amounts, Reserve amounts, recovery amounts, claim transaction amounts between Confidential operational data store and Business intelligence center (BIC) data marts to ensure no data loss due to ETL transformations
• Participate in E2E system Test case execution with multiple teams to ensure their is no data loss or data discrepancies in the data warehouse.
• Create and execute automation scripts for regression and test data creation using CADevTest tool and IDTW Tool.
• Preparation of Automation tools using Python scripts
• Test defects tracking and analysis in Microsoft Test Manager (MTM) tool
• Test Status reporting on Daily and Weekly basis to all the stakeholders
• Test Evidence walkthrough and coordination with business stakeholders for User Acceptance Testing
• Create Test closure report and receive signoff from the business stakeholders
• Perform post-production Testing activities
• Mentoring team members in various technical and process related aspects
• Offshore Team Management/Coordination, Issue resolution, co-ordination with project stakeholders.

Environment: Greenplum, Oracle, Informatica, TFS/MTM, SAP BO Reports, Unix, Python, IDTW, SQL Developer, WINSQL, Confidential policy center and Confidential claims center

Confidential, Madison Wisconsin

Responsibilities:

• Thorough requirement Analysis
• Initiate meetings with business stake holders for clear understanding of the requirements.
• Identify, collect and validate the data requirements from a range of legacy sources system in order to ensure the completeness and accuracy of the required data in the Confidential Policy center and claims center.
• Review of Test Strategy and test cases with business stakeholders.
• Validation of Data acquisition from Confidential PC and CC into ODS, ODS to staging layer and from staging layer to Analytical layer and then to BI reports.
• Validation of converted data from legacy systems with that of data from Confidential systems
• Performing Reconciliation checks for premiums amounts, exposure amounts, Reserve amounts, recovery amounts, claim transaction amounts etc. between Confidential data and legacy data to ensure data is not lost as part of conversion.
• Create SQL scripts as per the business requirements
• Create and execute automation scripts for regression and test data creation using CADevTest tool and IDTW Tool. Execution of daily smoke tests by creating excel macros
• Reconciliation validation at each staging’s from legacy to Policy center and claim center tables using SQL scripts
• Validation of converted Policy center and claims center tables data with Confidential Policy center and claims center application.
• Validation of Policy functionality in Confidential policy center by creating various policy transactions like policy change, cancellation, rewrite, reinstatement, renewal on converted policies to ensure Confidential application is functioning as intended.
• Validation of claims functionality in Confidential claims center by creating various claims transactions like payments, Reserves, recoveries, recode, Transfer, Bulk payment, partial payment, Bulk invoice payment on converted claims to ensure Confidential application is functioning as intended.
• Perform Functional, System, Negative, Smoke & Regression tests as per business requirements.
• Implemented Iterative and Incremental Agile - Scrum Methodology for rapidly changing or highly emergent requirements and following parallel development and testing.
• Test defects tracking and Test status reporting.
• Test Evidence walkthrough with the business before UAT
• Coordinate with business stakeholders during UAT.
• Offshore Team Management/Coordination, Issue resolution, co-ordination with multiple stakeholders.

Environment: Confidential policy center and Confidential claims center, Informatica, Greenplum, Oracle, TFS/MTM, SAP BO Reports, Unix, SQL Developer, WINSQL

Confidential, Eagan Minnesota

Responsibilities:

• Thorough Requirement Analysis.
• Attend meetings with clients and Development team for clear understanding of requirements
• Test Plan and Test Case Preparation
• Test Data creation as per the requirements
• Execution of Jobs and get the warehouse tables loaded with required data for performing Test execution
• Perform test execution, Test defects tracking and Test status reporting.

Environment: Oracle, Toad, Unix, control M, Jira

Confidential

Responsibilities:

• Thorough Requirement Analysis.
• Attend and Initiate meetings with clients and Development team for clear understanding of requirements
• Test strategy and Test Plan Preparation
• Test case Review and preparation
• Coordinate with Batch team and get the warehouse tables loaded with required data for performing Test execution
• Offshore Team Management/Coordination, Issue resolution, co-ordination with multiple stakeholders.
• Perform test execution and review test results of offshore team.
• Provide estimates for the change requests that come through as part of Test execution.
• Test defects tracking and Test status reporting.

Environment: Oracle Banking platform, Oracle, Mainframes, Unix, HP ALM, Toad

Confidential

Responsibilities:

• Understanding Functional Requirements.
• Test Plan, Test Case Preparation
• Test Execution and Defect Tracking.
• Escalate issues and risks to Test Leads / Test Managers

Environment: Oracle, Datastage,SQL Developer, Mainframes, Unix, QC

Confidential

Responsibilities:

• Thorough Requirement Analysis
• Test Case Preparation
• Writing FXP, ML, Fastload Scripts and Mloading or Fast loading data between database’s
• Validating Data in tables and views against the requirements
• Test Execution and Defect Tracking.
• Escalate issues and risks to Test Leads / Test Managers

Environment: Teradata, SQL Assistant, Unix, HP QC, Informatica

Confidential

Responsibilities:

• Thorough Requirement Analysis
• Test Case Preparation
• Test data preparation (Includes Data Mining and Data Creation)
• Functional and Regression Testing
• Test Execution and Defect Tracking.
• Escalate issues and risks to Test Leads / Test Managers
• Mentoring New Joinees and assisting on complex functionalities

Environment: Oracle, Advanced query tool, DB2, HP QC