Data and Analytics - DWH Testing

An effective leader with success in leading teams during the project phase and enabling knowledge sharing among them.Leading a team of ETL and BI testers. Supervising a team, allocating work and ensuring capacity utilization of all resources during the sprint planning and execution.Gained experience in ETL testing, Data Warehouse, BI reports (QlikView, Power BI) using SQL in Microsoft Azure.Conducted testing in Microsoft Azure platform.Performed ETL testing like Meta… Show more An effective leader with success in leading teams during the project phase and enabling knowledge sharing among them.Leading a team of ETL and BI testers. Supervising a team, allocating work and ensuring capacity utilization of all resources during the sprint planning and execution.Gained experience in ETL testing, Data Warehouse, BI reports (QlikView, Power BI) using SQL in Microsoft Azure.Conducted testing in Microsoft Azure platform.Performed ETL testing like Meta data testing, Data Integration, Data transformation logic testing & Data Quality testing.Engaged in writing complex SQL scripts based on technical documents and even without technical specs.Examined data in developed BI reports and in Data Marts using SQL.Ensured the content displayed in BI reports meets the clinical and business requirements.Testing product specific Data Marts using SQL.Testing Data Warehouse framework. Having good knowledge of DWH system, OLTP and OLAP systems, Star schema & Snowflake schema, Facts & Dimensions, Microsoft Power BI/Azure, Data Warehouse and Data Marts.Working alongside engineering team, resolving Power BI report issues(tickets) raised by client.Documenting & tracking test plans, test results, analysis, & unresolved problems in Azure DevOps.Skilled in preparing test artifacts – Test Estimations, Requirement Traceability Matrix, Dashboards, Test cases, Test execution reports and MoM.Practiced testing program in Agile (Scrum framework) & DevOps Methodology. Facilitating features delivery in Agile teams, liaising with Product Owners & Scrum Masters, attending to scrum calls and proposing improvement during Sprint review ceremonies. Helping team members in resolving challenges/impediments during planning and execution phase. Show less

General Insurance domain:Hands on experience in System Integration projects.Knowledge of SDLC and Software Testing Life cycle.Experience in all phases of software testing.Good experience in writing test cases, reviewing test cases and executing the test cases.Defect Analysis.Post Mortem reviewsPreparing Test Plans, Requirement Traceability Matrix, Test Closure Report.In-depth experience in Black Box Testing, Regression Testing, Functional testing, Bug… Show more General Insurance domain:Hands on experience in System Integration projects.Knowledge of SDLC and Software Testing Life cycle.Experience in all phases of software testing.Good experience in writing test cases, reviewing test cases and executing the test cases.Defect Analysis.Post Mortem reviewsPreparing Test Plans, Requirement Traceability Matrix, Test Closure Report.In-depth experience in Black Box Testing, Regression Testing, Functional testing, Bug tracking and reporting.Ability to understand the Functional Specifications and extracting high level scenarios.Experience in Client Interfacing, Escalations,Hot-Fixes and giving innovative solutions and adding value to the Process. Show less

Worked in ROHINI INDUSTRIAL ELECTRICALS LTD. (A Voltas Subsidiary-TATA Enterprises) as a Project Engineer (Projects-Execution). Project - EURO-IV with 11KV Sub station(Completed), Indian Oil Corporation,Mathura Task - Installation & Commissioning of Sub-station & De-sulpurification plant (EURO-IV Unit)