Looking for a job

ABHISHEK GORAIN

@abhishekgorain

Data Analyst building Python ETL pipelines and PostgreSQL star schemas, with Power BI audits uncovering MRR recovery opportunities.

India

Message

I built a SaaS subscription analytics pipeline that ingested 825K+ records into an indexed PostgreSQL star schema and calculated normalized Monthly Recurring Revenue. Its Power BI suite audited $108.5M in MRR and identified a $2.85M recovery opportunity.

For an enterprise automotive audit, I modeled $389M in retail transactions across 48 dealership nodes and identified an opportunity to capture $1.2M in recurring billing. I also developed time-series profit forecasts with back-tested variance under 2.1%.

I built a Brazilian e-commerce pipeline for 100K+ marketplace records and segmented 93K+ customers into five RFM tiers. The accompanying Power BI analysis examined repeat purchasing and regional fulfillment times.

As a Data Analytics Intern at MedTourEasy, I developed clinical Power BI dashboards and Python and Excel validation routines. At Future Interns, I analyzed e-commerce and campaign data and created performance scorecards and inventory reorder briefs.

Experience

Work history, roles, and key accomplishments

Data Science & Analytics Intern

Future Interns

Cleaned, transformed, and evaluated transaction datasets for retail initiatives using Python (Pandas) and Power BI, building performance tracking scorecards and delivering structured briefs on inventory reorder recommendations.

Python Pandas Power BI Data Cleaning data transformation Performance Monitoring

Data Analytics Intern

MedTourEasy

Developed interactive Power BI dashboards evaluating complex clinical datasets, standardizing reporting views that accelerated internal research workflows by 25%. Executed Python and Excel validation routines ensuring 100% data integrity.

Power BI Python Excel Data Validation Dashboarding

Education

Degrees, certifications, and relevant coursework

Future Institute of Engineering and Management

B.Tech, Computer Science & Engineering (Data Science)

2021 - 2025

Pursued a B.Tech in Computer Science & Engineering with a focus on Data Science, covering database management, data modeling, and machine learning foundations.