Shivam Birmole
All work

Four years of data work

Pipelines, dashboards and reporting at TresVista, across investment data, banking and fund performance.

Title
Associate, TresVista Analytics LLP
When
June 2022 to April 2026
Where
Pune
Certified
Databricks Data Engineer Associate, earned May 2025

Investment data

Analysts evaluating a deal need data from several vendors to agree with each other. I built the PySpark and Airflow pipelines that brought vendor data in, and the Databricks workflows that ingested and transformed it. I also benchmarked data quality, so people knew how far to trust a number before they used it.

Fraud and marketing analytics

A fraud team needs to see a pattern early, and a marketing team needs to know whether a campaign worked. I built Power BI dashboards for both, automated early-stage fraud-detection workflows, analysed campaigns and surveys, and presented the recommendations to stakeholders.

Fund performance

Fund reporting depends on numbers collected from many people in many formats. I built data-collection templates wired into SQL Server, the backend behind them, and Power BI dashboards on projections, shortfalls and performance, using Python, Azure and SQL.

What carried over

The products on this site are the same job in a different place. Take a messy input, give it a structure, and make sure a person can check the result. MedDraft does that with a doctor’s dictation.

What is known, and what is not.

What I did

  • Built PySpark and Airflow pipelines.
  • Integrated vendor data for investment analysis.
  • Built Databricks ingestion and transformation workflows.
  • Built Power BI dashboards for fraud, marketing and fund teams.
  • Automated early-stage fraud-detection workflows.
  • Presented recommendations to stakeholders.

What the work covered

  • Investment data for analysis and deal evaluation.
  • Fraud and marketing analytics for a banking team.
  • Fund performance reporting on projections and shortfalls.

What has been measured

  • Client results are confidential, so none are quoted.

nextMedDraft

Shivam Birmole