Summary
Overview
Work History
Education
Skills
Certification
Project 1 -EMERGING MARKET PRIORITIZATION
Project 2 -BD Oncology & Pharma Model Automation
Project 3 -CMV PREVYMIS FORECAST MODEL
Project 4 -Chronic cough deck automation MODEL
Project 5 -BD Consolidator
Accomplishments
Languages
Timeline
Generic

Vidya Shinde

Pune

Summary

Transformational Data Analytics Leader with 9+ years of expertise in architecting and delivering high-impact ETL solutions that drive business outcomes. A strategic thinker with a proactive and adaptable mindset, renowned for exceptional work ethic, compelling communication, and team leadership prowess. Excelled in timeline management, process optimization, and data storytelling. Passionate about harnessing data insights to propel organizational excellence and fuel collaborative success.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior QA Engineer

UST Global
Pune
09.2021 - Current
  • Collaborated extensively with cross-functional stakeholders to ensure exceptional customer satisfaction with product quality.
  • Designed and developed data-driven testing frameworks leveraging SQL queries against Oracle and Databrick databases.
  • Analyzed failed tests to pinpoint areas for process enhancement, driving growth and improvement.
  • Streamlined development processes using JIRA, Jenkins, and GitLab for efficient defect tracking, CI/CD pipelines, and source code management.
  • Ensured application excellence through rigorous ETL testing, covering the full spectrum of functional, regression, integration, and system testing.
  • Provided guidance and mentorship for junior QA engineers on best practices for software testing processes.

ETL Analyst

TCS
Pune
08.2015 - 08.2021
  • Validate daily and monthly Business Intelligence reports and LRM ratios, ensuring accuracy and reliability.
  • Validate T2T tables and trace defects to their source, ensuring data integrity and process improvement.
  • Generate daily reports and manage defects leveraging ALM, ensuring timely issue resolution and process transparency.
  • Collaborate with DBA to identify and resolve defects, providing clear explanations and root cause analysis for effective issue closure.
  • Integrated data flows, validated SQL queries, and ensured database integrity for downstream applications using business insight and transformation expertise
  • Ensured seamless compatibility across browsers, successfully validating IE 11 and cross-browser testing for optimal performance

Testing Engineer

Syntel Pvt. Ltd.
Pune
08.2013 - 03.2015
  • Tested system integration in a Waterfall framework, delivering seamless end-to-end functionality across:

    - Multiple components and interfaces
    - Complex workflows and business logic
    - User interface and user experience
    - Data integrity and consistency
    - Third-party integrations and APIs

    Ensured flawless system performance, identifying and resolving defects and errors to deliver a high-quality, fully integrated solution

Education

Bachelor of Computer Applications - Computers

Marathawada Mitra Mandal College
Pune
04-2013

Skills

  • Data Quality Management
  • POWER BI (BEGINNER)
  • PYTHON(BEGINNER)
  • SQL , BIG DATA
  • INFORMATICA,
  • CLOUD DATA FUSION(CDF)
  • GOOGLE CLOUD PLATFORM(GCP)
  • MATILLION USING AWS S3
  • Airflow dags, Databricks
  • Strategic Planning
  • Requirements Analysis
  • Adaptability/Flexibility
  • Process Efficiency And Automation
  • Clear And Effective Communication

Certification

  • ISTQB certified for -
  • Demonstrated knowledge of software testing fundamentals.
  • Understanding of testing techniques and methodologies - Ability to apply testing principles in real-world scenarios.
  • Committed to staying up-to-date with industry best practices

Project 1 -EMERGING MARKET PRIORITIZATION

This was high visibility critical project for stakeholder to optimize and take informed decision on launch excellence in APAC region. Task was to create a model with UI and functionalities for user inputs with advanced excel and VBA as a backbone. The model was created to account calculations for up to 200 countries in Phase I and delivered the model with quality and timely delivery for business review. With the success of Phase I post feedback from various clients, the next Phase of the project is ongoing

Project 2 -BD Oncology & Pharma Model Automation

  • BDnL team was looking for automated standard model each for Oncology and Pharma forecasting which could help then in delivering the project in short TAT. In line with business requirements, two separate model was created using advanced excel and VBA which are capable of developing up to 150 scenarios for various indications along with functionality to visualize data by region and portfolio and aid in slice and dice the data to crate custom reports. BDnL team has been using the model for ongoing product and portfolio level ongoing deals and is satisfied the way final model turned out

Project 3 -CMV PREVYMIS FORECAST MODEL

  • Stakeholders want to shift from current monthly forecast to yearly forecast model with user friendly UI to resolve complexities and speed related issue with current model. Team developed a new UI and created a yearly forecast model in short period of time which was more efficient and also handled critical changes as per some of the country SPOC’s requirements.

Project 4 -Chronic cough deck automation MODEL

  • Stakeholder was looking for a consolidated slide-deck for Global and key markets for Chronic cough indications. It was large deck with approximately 100+ slides which required 2-3 business days to update and QC the deck. Team created a VBA based slide-deck automation tool with which user can create required dynamic slide-deck with just one click of button. The run time was reduced from 2/3 days to 2/3 hours.

Project 5 -BD Consolidator

  • BDNL team was looking for an automated tool which can consolidate all the outputs from various forecast models when team evaluate a portfolio or a company altogether. Team created a forecast consolidator with VBA as backbone which was capable of extracting data from all the created forecast models and also create various dashboard in the consolidator to slice and dice the data by Region, Indication and by Scenario. The additional waterfall charts to compare and view the forecast changes at product, indication and portfolio level between two forecast updates was highly appreciated by the team. The tool in total led to elimination of manual effort of consolidating the data, creating charts and comparing two forecast updates manually.

Accomplishments

Quality Assurance Leadership Award

Excellence in Software Testing Award

Best Tester Award for Year

Quality Tester of the Year

Languages

English
First Language
Hindi
Proficient (C2)
C2
Marathi
Proficient (C2)
C2

Timeline

Senior QA Engineer

UST Global
09.2021 - Current

ETL Analyst

TCS
08.2015 - 08.2021

Testing Engineer

Syntel Pvt. Ltd.
08.2013 - 03.2015

Bachelor of Computer Applications - Computers

Marathawada Mitra Mandal College
Vidya Shinde