Ronak Mandliya
Pune
Summary
Dynamic BI Test Lead with a proven track record at Systems Plus Pvt LTD, showcasing expertise in ETL testing and data warehousing. Excelled in leading a team of 10+ to enhance testing strategies, leveraging skills in SQL Server and fostering team collaboration. Achieved significant improvements in testing efficiency and coverage, demonstrating strong leadership and technical acumen. Specialize in BI report testing, defect tracking systems, and test case management, ensuring thoroughness in identifying and solving issues. Excel at problem-solving, communication, and teamwork, utilizing these soft skills to collaborate effectively with developers and stakeholders for quality product delivery.
Overview
12
12
years of professional experience
1
1
Certification
Work History
BI Test Lead
Systems Plus Pvt LTD (Captive - Bright Horizons)
07.2023 - Current
- Project: MyBH, Marketing, Growth, Client, and Center Reporting, DAM Migration.
- Technology used: SSIS, Qlik SaaS, Snowflake, Python, SQL Server, and Azure DevOps.
- Leading a team of 10 or more members and developing the overall testing strategy for ETL processes, scope, resources, timelines, risk management, and providing estimations.
- Collaborating with stakeholders to understand business requirements, and translate them into testable scenarios.
- Creating detailed test plans, test cases, and test scripts for ETL processes based on business requirements, functional specifications, and technical designs.
- Overseeing the test execution and scripts, ensuring adherence to testing standards and procedures, and assisting the team in the creation of complex SQL queries to perform data quality checks.
- Generating test reports and metrics to communicate the status of testing activities, including defects found, test coverage, and test execution progress.
- Facilitating meetings and discussions to review test results, concerns, and make decisions regarding testing priorities and strategies.
- Participating in retrospectives and lessons-learned sessions to identify areas for improvement in testing processes, tools, and methodologies.
- Providing guidance, leadership, and an overview about the system to a team of ETL testers and new members, including assigning tasks, monitoring progress, and resolving conflicts.
- Active participation in the daily Scrum call, fostering a collaborative and supportive work environment to maximize team productivity and effectiveness.
Senior BI Test Engineer
Jet2.com and Jet2holidays.com
02.2021 - 07.2023
- Project: EROS (Electronic Resort Operating System), Contact Centre
- Technology used: Snowflake, DBT, Amazon Connect, SSIS/SSRS, Tableau, SQL SERVER, Azure DevOps
Deputy Manager
Vodafone
03.2020 - 02.2021
- Project: EDSP (Enterprise Digital Services Platform)
- Technology used: Oracle Golden Gate, Oracle 12C, Xray for Confluence, JIRA
Data Architect Analyst
Fiserv India Pvt LTD
08.2016 - 03.2020
- Project: AIM (Administrator interface management)
- Technology used: SSIS, SQL Server, Quip, JIRA, SSRS Reports, Tableau Dashboards
- Project: INAV (Indicative net asset value)
- Technology used: Pentaho, MIG21, Oracle, Rally
Senior System Executive
Cognizant Technology Solutions
06.2013 - 08.2016
- Project: Repo (Repurchasing Agreement)
- Technology used: Oracle, Informatica, Control-M, HP ALM 12.0, Tableau Dashboards
Education
Bachelor of Engineering - Computer Science
BAMU University
Skills
- Requirements Analysis
- Quality management
- Test/Defect Management
- Agile methodology
- Stakeholder relations
- ETL, data warehouse, data migration
- Tableau, QlikView, and Power BI
- Smoke and Regression testing
- Python
- SQL Server
- Snowflake
- Azure DevOps
- DBT
- Amazon Connect
- Scheduling -> Control-M
- GIT
Certification
- ISTQB Certified Tester - Foundation Level
- ISTQB Certified Tester - Foundation Level, Agile Tester
- Scrum Master Certified - PSM1
Accomplishments
- Traveled onsite as a part of POC for new cloud-based project and develop cross-cultural communication skills through collaboration with UK colleagues.
- Ideathon winner - for presenting best ideas for boosting business.
- Appreciation Award for best Customer Satisfaction/ Business Stakeholders.
- Appreciation for providing better solutions & improving processes across teams.
- Active participation in technical and non-technical events.
Personal Information
- Passport Number: V8619641
- Date of Birth: 05/26/91
- Gender: Female
Timeline
BI Test Lead
Systems Plus Pvt LTD (Captive - Bright Horizons)
07.2023 - Current
Senior BI Test Engineer
Jet2.com and Jet2holidays.com
02.2021 - 07.2023
Deputy Manager
Vodafone
03.2020 - 02.2021
Data Architect Analyst
Fiserv India Pvt LTD
08.2016 - 03.2020
Senior System Executive
Cognizant Technology Solutions
06.2013 - 08.2016
Bachelor of Engineering - Computer Science
BAMU University
Similar Profiles
Abhimanyu MishraAbhimanyu Mishra
Team Lead & Incident Manager at Systems Plus Pvt LtdTeam Lead & Incident Manager at Systems Plus Pvt Ltd
Lauren PerryLauren Perry
Brand Ambassador at CaptiveBrand Ambassador at Captive
KANIKA RANAKANIKA RANA
Project Coordinator at CaptiveProject Coordinator at Captive