Pranita Tashildar

-- data analyst · troy, michigan

Pranita
Tashildar

I turn messy operational data into reporting that leaders trust, with SQL, Python, Power BI and Tableau. 5+ years across automotive, consulting and construction.

PT
MS Data Analytics
Walsh College, 2025
Open to work
~$200Kyearly rework removed by fixing data-quality issues at the sourceMethodica
~85%of recurring data corruption eliminatedMethodica
78%of support tickets auto-routed after classifier tuningMethodica
~40%less time producing weekly leadership reportsStellantis
~22%better forecast accuracy for Fortune 500 clientsBright Consultancy

Experience

Five roles, three industries, one habit: check every number back to source.

Jan – Jul 2026Auburn Hills, MI

Business Intelligence & Data Analyst

Stellantis (Contract via Methodica Technologies)

  • Built the executive dashboards behind weekly Propulsion Systems leadership reviews, joining SAP, Excel and Teams data.
  • Automated hand-built recurring reports, cutting about 40% of production time.

Jan – Apr 2025Troy, MI

Data Analyst

Methodica Technologies

  • Built Power BI and Grafana dashboards on BigQuery and InfluxDB for product health and incidents.
  • Fixed data-quality issues at the source: about 85% less recurring corruption and roughly $200K a year in rework removed.

Oct 2024 – Feb 2025Troy, MI

Graduate Teaching Assistant, Data Analytics

Walsh College

  • Coached 25+ graduate students in SQL, Python, Power BI and Tableau.

Jan – Aug 2024Pune, India

Data Analyst

Bright Consultancy Services

  • Built Python and SQL forecasting models for Fortune 500 clients, improving accuracy about 22%.
  • Designed star-schema Power BI dashboards that took three weeks out of the planning cycle.

Jan 2020 – Dec 2023Belagavi, India

Data Analyst, Construction Operations

Shree Samarth Constructions

  • Built the analytics function for $15M+ in concurrent projects: MySQL databases, Power BI dashboards and automated reporting.

Case studies

The question, the method, and what the numbers said.

Office vs remote, mean score
OfficeRemote

QM 600 · Walsh College · 2025 · team of 3

Remote work and productivity

NSW remote-work surveys (3,019 responses) plus a 1,000-worker dataset. Remote workers scored higher on productivity and well-being (p < 0.0001), but remote share alone explained little (R² ≈ 0.02), so the call was a structured hybrid model.

PythonExcelt-testsRegression
Run live demo
Order-taking errors by type890 errors · 3,000 orders

QM 602 Lean Six Sigma · Walsh College · 2025

Six Sigma on a pizza line

X̄–R charts showed crust thickness in control, so the defects were in order-taking: two error types made up 78% of errors at 49,444 DPMO. Fix: address validation and time-stamping at the POS.

SPCParetoDPMODMAIC
Run live demo
Monthly sales per store, $K
BeforeAfter

QM 601 Research Methods · Walsh College · 2025 · team of 3

Do loyalty programs lift retail sales?

Designed the study (survey, n = 384 via Cochran's formula, paired t-test and regression) and tested it on simulated store data: +20.7% mean monthly sales, p < 0.01.

Research designSamplingPaired t-test
Run live demo
Held-out accuracy by model983 test samples

BE final-year project · Gogte Institute of Technology · 2022 · team of 5

Predicting drinking-water potability

Compared eight scikit-learn classifiers on 3,276 samples. Best model (SVM) reached 67% against a 61% baseline; features barely correlate with potability (|r| ≤ 0.04), which caps any model. GitHub

Pythonscikit-learnXGBoost
Run live demo

Client work

Strategy, websites and proposals for a Bloomfield Hills sign company and its owner's music label.

Dempster Designs website homepage

Dempster Designs · Bloomfield Hills, MI · 2026

Website for a 60-year sign company

Five-page site (HTML, CSS, vanilla JS) with services, story, a 36-photo gallery and contact, built from the client's own copy and project photos.

HTML/CSS/JSNetlify
CodeVisit site ↗
The Blue Guitar website homepage

The Blue Guitar · Dolphin Bay Records · 2026

Artist site for The Blue Guitar

Music catalogue with 30-second previews, "listen on" links to the major streaming platforms and a licensing section for film and TV supervisors.

Web designAudio previews
Visit site ↗

Strategy & Operations Lead · 2026

Growth plan for both brands

  • Two business proposals (18 and 20 pages) and two 18-slide decks, presented to the owner.
  • Streaming-first music plan built on researched 2026 platform pay rates, payout timing and rights registration.
  • Local search, social and paid-media plan for the sign business, with tiered budgets, an ROI model and break-even analysis.
  • One shared social media operating system for both brands, with separate strategies and voices.

More projects

Work, internship and coursework.

Methodica Technologies · 2025

Test-results monitoring in Grafana

Wrote the dashboard requirements and built Grafana views on InfluxDB test-run data: execution summary by test bench, errors by exception type, and system utilization.

GrafanaInfluxDBPython
Run live demo

Enerzi Microwave Systems · internship · 2022

IoT sensor data logger

ESP8266 and DHT11 readings streamed to Google Sheets for remote monitoring.

IoTArduino C++
Run live demo

IT 599 Capstone · 2025

Explainable fraud detection for digital payments

Hybrid Random Forest, XGBoost and autoencoder framework on 5,000 synthetic transactions, with SMOTE for imbalance and SHAP and LIME for explainability.

PythonXGBoostSHAP
Run live demo

QM 505 · 2025

SBA 7(a) loans and job creation

Pivoted 5,000 loan records and showed loan attributes do not predict jobs created.

PythonRegression
Run live demo

IT 547 · 2025

Fitness & nutrition database

ERD-to-SQL relational design with associative tables and indexed analytical queries.

QM 504 · 2024

Equine ulcer treatment analysis

Cost vs efficacy from cited veterinary sources: ranitidine had the lowest cost per efficacy point; omeprazole reached 85% at 7.8x the cost.

IT 545 · 2025

House price prediction

Linear, Ridge and Lasso regression on the Kaggle House Prices dataset.

Pythonscikit-learn
Run live demo

IT 544 · 2025

U.S. air quality analysis

Choosing the right chart for each audience: trends, seasonality and pollutant drivers.

PythonData viz
Run live demo

IT 546 · 2024

Text analytics: War and Peace

Word frequency and dictionary sentiment, first built in Excel, now running on the full novel.

ExcelText analytics
Run live demo

AWS Academy · 2022

AWS cloud labs

EC2 web servers behind an Elastic Load Balancer with health checks.

Toolkit

Skills, education and certifications.

Query & code
SQLPythonRBigQueryMySQLPostgreSQLInfluxDB
BI & reporting
Power BI (DAX)TableauGrafanaExcel (Power Pivot, VBA)
Methods
ForecastingHypothesis testingRegressionA/B evaluationSPC & Six Sigma toolsETL & validation
Working style
Stakeholder requirementsRoot-cause analysisData storytelling
MS, Data AnalyticsWalsh College, Troy, MI · 2025
BE, Electronics & CommunicationKLS Gogte Institute of Technology, India · 2023
  • Advanced Google Analyticsvalid to Jan 2027
  • Google Analytics & GA4 (Skillshop)2024–2025
  • AWS Academy Cloud Foundations2022
  • Applied Python (Udemy)2023
  • Cambridge Business English B1completed

-- let's talk

Open to Data Analyst and BI roles.

On-site, hybrid or remote. Scan to save my contact or reopen this portfolio.

Save contactvCard
View portfoliothis page