Aishwarya Khinvasara | Looking for full time opportunities | Business Intelligence | Data Analyst |Business Analyst

Aishwarya Khinvasara

Looking for full time opportunities | Business Intelligence | Data Analyst |Business Analyst

Based in California

About

Experienced Business Analyst with hands-on experience in SQL, Python, advance excel and visualization tools such as Tableau and PowerBI. Proven track record in analyzing and centralizing data and delivering data-driven recommendations and valuable insights. Recent graduate from CSU, East Bay in Business Analytics. Actively looking new opportunities to contribute analytical skills and drive business success.

Skills

Projects

Price Analysis of Real Estate in SF bay area

Collected property information from realtor.com using web scraping techniques. Developed a Python script to thoroughly clean the data. Performed data analysis, revealing insights such as Heat maps, hotspots, price comparisons based on multiple attributes.

Automation of employee expense processing.

The automated solution simplifies the processing of employee expense reports, improving efficiency and decreasing manual workload.

Forecast Monthly Cases for Chicken Pox

Identifying the most efficient forecasting method for predicting monthly chickenpox cases in Hungary for 2015. This involves investigating methods such as Two-level forecasting, Regression with trend and seasonality, and Auto ARIMA, in addition to baseline models.

Customer Response prediction for banks

Identifying likely subscriber groups is pivotal to overcome these challenges. Utilizing data from a Portuguese bank's 2008-2010 phone campaign to predict customer responses and enhance targeting precision .Goal is to boost campaign success by identifying the most receptive customers

Pizza Sales Insights

Explore my PowerBI dashboard showcasing one year of pizza sales data. Uncover insights on the best-selling pizza, preferred pizza sizes, and track daily/monthly sales trends. The dashboard incorporates DAX functions for KPIs and Power Query for dynamic chart visuals

Experience

2018-2019

Business Analyst At ZS Associates

Performed SQL-based analytics to identify hospitals/physicians, improving sales targeting by 25%. Used data analysis and machine learning to predict cancer patient conditions with 80% accuracy. Additionally, defined drug performance metrics, analyzed sales/pricing trends, and presented findings through Tableau reports, aiding strategic marketing planning. Examined Patient data using SQL to identify drug consumption patterns and develop PowerBi dashboard.

2020-2021

Data Analyst At Gridlogics/Patseer Technologies

Extracted data from multiple vendors, creating a unified database through SQL queries. Automation of data pipelines with a Python script resulted in an 18% reduction in manual workload. I implemented validation methods for quality checks. Utilizing advanced Excel functions, analyzed trends, extracted valuable insights, and presented recommendations to top-tier management via Tableau dashboard. Collaborated with cross-functional teams, utilizing the PatSeer tool for in-depth data analysis. Monthly PowerPoint decks were streamlined using key performance indicators (KPIs) to provide tailored solutions for specific problems.

Education

2022-2023

MS in Business Analytics from CSU, East Bay