Rahul Ratusaria

As a Senior Data Analyst, I am driven by an ambition to transform complex data into clear, actionable insights. My approach is rooted in pragmatic problem-solving, balanced with a collaborative spirit and empathetic understanding of diverse perspectives. I leverage my organized nature and insatiable curiosity to deliver impactful, data-driven strategies.

Experience

I

Senior Analyst

I-PAC (Indian Political Action Committee) · Sep 2022 – Present

Not yet confirmed

I

Senior Data Analyst

Indian Political Action Committee (I-PAC) · Sep 2022 – Present

Not yet confirmed

• Built and automated Python-based survey analytics dashboards, Power BI/Excel reports, QGIS maps, and Dash applications for multi-level voter analysis across 8 states, reducing project timelines by 33% and manual reporting effort by 80%.
• Built a cross-profile segmentation framework across 17+ survey profiles to analyze demographic, behavioral, and political dependencies, improving voter targeting and vote share prediction.
• Created a target-group identification model using cross-profile analysis and voter behavior segmentation, contributing to a 12-13% vote share gain and 30-40 seat improvement.
• Developed statistical simulations and alliance impact models to forecast vote share, seat share, and alliance scenarios within a 2.5% margin of error, supporting data-driven seat distribution decisions.
• Implemented BERT-based topic modeling and NLP text classification to categorize subjective survey responses into predefined buckets, reducing manual dependency by 4 resources and cutting analysis timelines from 3-4 days to a few hours.
• Built a LangGraph-powered automated insights generation system to extract key findings from reports, reducing manual analysis effort and enabling faster delivery of stakeholder-ready insights.

Business Intelligence Engineer

Amazon · Jan 2022 – Jun 2022

Not yet confirmed

Business Intelligence Engineer Intern

Amazon · Jan 2022 – Jun 2022

Not yet confirmed

• Optimized maintenance scheduling and labor allocation by analyzing 3-year historical equipment maintenance big data, improving scheduled maintenance planning and contributing to a $300M reduction in operating costs and lower maintenance labor hours.
• Wrote and optimized complex SQL queries and automated ETL pipelines using Python to create clean, reliable, and analysis-ready operational datasets.
• Fetched and transformed data from Amazon S3 buckets and Amazon Redshift tables using SQL, and designed Amazon QuickSight dashboards to track cost reduction KPIs and operational performance metrics.
• Created structured technical documentation for data pipelines, dashboard logic, reporting workflows, and reusable analytics processes to support long-term adoption.

M

Placement Cell Coordinator

Maharaja Agrasen Institute Of Technology · Jul 2019 – Jun 2022

Not yet confirmed

Web Developer

Abbloo · Jun 2020 – Jul 2020

Not yet confirmed