SHIVANI BAPUJI VHATKAR

Data Analyst

USA.
2nd

About

2+ years of experience in data analytics and enterprise IT systems across a global technology firm (300,000+ employees, ~$22B annual revenue) and a high-growth startup environment, building SQL-driven reporting, ETL/automation pipelines, and dashboard development. Experience in designing executive-ready presentations, charts, and visual dashboards translating complex analytics into concise strategic insights using SQL, Python, PowerPoint, Tableau, and Excel for cross-functional and stakeholder audiences.

See more

Work

·

Heartland Community Network (HCN)

Senior Consultant - Data Analyst (Volunteer)

·

Bloom AI

Data Analyst Intern

·

Cognizant

Programmer Analyst - Data Analyst

See more

Education

·

Computer Science

Purdue University

·

Computer Engineering

University of Pune

See more

Skills

Data Analysis & Visualization

Tableau, Power BI, Looker, Excel, A/B Testing, BigQuery

Office Productivity

MS Office, Git/Github

Programming & Scripting

Python, R programming, PySpark, C++, HTML/CSS, Git/GitHub, SQL

Databases & Data Warehousing

MongoDB, Snowflake, BigQuery, Hive

ETL & Workflow Orchestration

Airflow, dbt, ETL Pipelines

Cloud & Enterprise Platforms

AWS Certified Cloud Practitioner, ServiceNow Certified System Administrator, ServiceNow Certified Application Developer, DataCamp - Google Cloud Platform (GCP), DataCamp - NoSQL, ServiceNow

See more

Projects

Supply chain analysis

This PowerBI dashboard helps stakeholders move from overall supply chain performance to product-level demand issues and finally to supplier and logistics decisions, all using consistent, SKU-level data.

·

Indiana Food Access Data Library – Food Security Analytics

Built an automated BigQuery + Tableau data pipeline consolidating 150+ food service providers across 11 Indiana counties (87 ZIP codes), identifying 69% service coverage gaps and improving data completeness to 77%, directly influencing funding allocation and operational outreach strategy.

·

Medical Insurance Cost Prediction

Developed a medical insurance cost prediction model (R2 = 0.89) using LightGBM, explained cost variance with SHAP values, and ensured fairness using Fairlearn.

·

Digital Performance & Engagement Analytics

Analyzed 3,000+ interaction records to uncover engagement patterns and performance drivers, built KPI dashboards, and developed a SARIMA model to forecast short-term activity trends.

·

Customer Segmentation & Marketing Analytics (RFM)

Performed Recency, Frequency, and Monetary (RFM) analysis in Python to segment customers into groups (e.g., Champions, At-Risk) and visualized results with Plotly.

See more

Publications

·

Human Computer Interface for Physically Impaired

International Journal of Science and Research (IJSR)

See more