Hanish Nallagotla Reddy

Reduced ETL pipeline failures by 35% on 15M+ daily IoT energy sensor records by engineering SQL Server and Snowflake pipelines with dbt transformations, ensuring data validation and audit reporting aligned with data governance standards. Delivered 18% energy efficiency gains by automating Python scripts and SQL queries to clean and analyze 20TB+ IoT and ERP datasets, detecting consumption anomalies that flagged inefficient energy operations across 10 regions. Partnered with business stakeholders to analyze contractor acquisition costs vs. revenue, building self-serve Tableau dashboards that uncovered underperforming vendors and enabled $500K in savings reinvested into high-ROI contractors.

Spearheaded inventory optimization, cutting $200K in 2024 expenses by using PostgreSQL and Tableau dashboards on 3M+ transaction records, tracking KPIs such as turnover ratios and VPR with trend analysis to reduce waste and minimize stockouts. Lifted purchase frequency by 25% by automating Python time-series forecasting models integrated with AWS, uncovering customer buying trends across UMass retail outlets that guided targeted promotional campaigns. Collaborated with product and engineering teams to deploy self-serve analytics dashboards, empowering 15+ stakeholders with independent analysis capabilities, reducing ad-hoc reporting requests by 35%, and enabling decisions 40% faster.

Boosted revenue by 12.6% across 350M users by using SQL to extract and aggregate financing transaction data and Python to run statistical analysis and A/B tests, identifying creditworthy cohorts that guided product teams to design targeted offers. Enabled a 13% increase in customer retention by building Power BI dashboards to monitor approval rates and repayment patterns, and delivering weekly stakeholder BI reports with actionable insights that informed product improvements. Automated data cleaning workflows using Excel macros and built scalable data models, thereby improving reporting reliability.