I'm a data-driven analyst who loves turning messy data into clear, actionable insights. Over the past few years I've built and maintained ETL pipelines, automated analyses, and crafted self-serve dashboards that empower cross-functional teams to act on data. Based in Boston, I work with stakeholders across energy, retail, and fintech domains to translate business questions into scalable analytics solutions. My work has consistently delivered measurable outcomes, from reducing costs and waste to boosting revenue and operational efficiency.

Hanish Nallagotla Reddy

I'm a data-driven analyst who loves turning messy data into clear, actionable insights. Over the past few years I've built and maintained ETL pipelines, automated analyses, and crafted self-serve dashboards that empower cross-functional teams to act on data. Based in Boston, I work with stakeholders across energy, retail, and fintech domains to translate business questions into scalable analytics solutions. My work has consistently delivered measurable outcomes, from reducing costs and waste to boosting revenue and operational efficiency.

Available to hire

I’m a data-driven analyst who loves turning messy data into clear, actionable insights. Over the past few years I’ve built and maintained ETL pipelines, automated analyses, and crafted self-serve dashboards that empower cross-functional teams to act on data.

Based in Boston, I work with stakeholders across energy, retail, and fintech domains to translate business questions into scalable analytics solutions. My work has consistently delivered measurable outcomes, from reducing costs and waste to boosting revenue and operational efficiency.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Language

English
Fluent

Work Experience

Data Analyst at Community Dreams Foundation
March 1, 2025 - November 6, 2025
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.
Business Data Analyst at University of Massachusetts Amherst
December 1, 2024 - December 1, 2024
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.
Financial Data Analyst at ClearTax
August 31, 2023 - August 31, 2023
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.
Data Analyst Co-op at Analogics Tech India Pvt
February 28, 2023 - February 28, 2023
Built a centralized data warehousing solution in PySpark, BigQuery, and Oracle SQL to process 500K+ weekly shipment records, reducing manual reporting hours by 25 per week and enabling 20+ business users to access real-time insights. Led stakeholder management and requirement gathering, translating needs into Agile user stories in Jira, eliminating 30% of redundant tickets and completing 3 high-priority manufacturing initiatives ahead of schedule. Conducted ad-hoc client analyses in Excel (PivotTables, Power Query) on ROI and operational KPIs like shipment turnaround and distribution costs, and presented findings in PowerPoint to guide investment and resource decisions.

Education

Master of Science in Business Analytics - Data Science at University of Massachusetts Amherst
August 1, 2023 - December 1, 2024

Qualifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300)
January 11, 2030 - November 6, 2025
AWS Cloud Practitioner
January 11, 2030 - November 6, 2025
Google Data Analytics
January 11, 2030 - November 6, 2025

Industry Experience

Software & Internet, Energy & Utilities, Retail, Professional Services