Portfolio | Vaishnavi

About Me

I'm Vaishnavi Avinash

A data professional with over four years of in software engineering, data analysis, and project management. I specialize in building ETL pipelines and excel in extracting, cleaning, analyzing, and visualizing data to derive actionable insights.
My expertise lies in delivering both technical and business solutions driven by data, effectively transforming requirements into production-ready outcomes.

email : vaishnavi.gawali29@gmail.com

place : United States

Experience

JerseySTEM | Oct 2024 - Present

Data Analyst | United States

Company Overview:

JerseySTEM promotes education of Science, Technology, Engineering and Math for middle school students.

My Role:

Developed complex MySQL queries by integrating data from various sources
Built Looker Studio reports to flag inconsistencies, missing values in the database

Tech Stack:

Looker Studio, Google Sheets, MySQL, ETL

National Voices for Equality, Education and Enlightenment (NVEEE) | Jul 2024 - Oct 2024

Data Analyst Intern | United States | Internship

Company Overview:

NVEEE conducts leadership programs - PALS and PALP for high school students.

My Role:

Analyzed post-workshop surveys using Google Sheets
Provided insights on workshop alignment with PALP and PALS objectives
Developed Looker Reports to present findings for grant writing

Tech Stack:

Looker Studio, Google Sheets

The University of Texas at Dallas (UTD) | Jan 2024 - May 2024

Data Analyst | United States | Apprenticeship

Company Overview:

At UTD, I worked for an investment firm client looking to enter the EV market.

My Role:

Collaborated with a cross-functional team to analyze the Canadian EV sector
Identified critical sales drivers and performed a SWOT analysis to guide investment decisions
Utilized machine learning models to forecast sales trends

Tech Stack:

Cross-functional collaboration, Market Analysis, Machine Learning, Statistics

Tata Consultancy Services (TCS) | Jun 2020 - Aug 2022

System Engineer Analyst | India | Full-Time

Company Overview:

I worked on internal projects at TCS, concentrating on employee, financial, PI data, and data related to the TCS website.

My Role:

Participated in all stages of the SDLC, from requirements gathering to deployment, managing user stories
Developed ETL pipelines using Informatica to automate batch processing and replace manual data transfer
Executed SQL queries and procedures for data validation, utilizing test cases in target and staging tables
Created Power BI reports to present the weekly status of ETL pipelines

Tech Stack:

MySQL, Oracle, PostgreSQL, ETL, SDLC, Kafka, Power BI

Tata Consultancy Services (TCS) | Sep 2018 - May 2020

Software Engineer| India | Full-Time

Company Overview:

I was responsible for developing key functionalities for a U.S.-based car rental client.

My Role:

Implemented a payment blocking feature for high-risk prepaid cards using Python and SQL, reducing bad debts.
Led the migration of a multi-payment method on-premise modules to AWS cloud
Designed architecture, developed code modules, and created unit tests, ensuring defect-free production implementation
Developed an Excel project tracking system using pivot tables and VBAto streamline timelines and team status.