Himanshi Goswami

I’m a Product Analyst focused on turning messy real-world data into clear product and investment insights. I enjoy building end-to-end pipelines—scraping, modeling, validating, and presenting results in a way teams can act on.

At SaffronAI (Aug 2024–Present), I developed a Python web scraping pipeline to extract NAV data for 36,000+ mutual funds, creating a foundation for predictive analysis and trend forecasting. I built and trained predictive models to uncover key drivers of long-term returns and detect emerging investment trends, and I engineered a backtesting framework using multi-year historical data to evaluate strategies with risk-adjusted performance and stability metrics—identifying alpha-generating strategies that outperformed the Nifty benchmark. I also created a Return Consistency Tracker using rolling-window analysis and decile ranking, and I designed interactive dashboards for DAU and week-over-week retention analytics to support data-informed product decisions.

My project work shows how I connect analytics with automation and visual storytelling. For the Cricket T20 World Cup 2024, I built predictive models based on player statistics using an automated ETL pipeline scraping real-time data from ESPNcricinfo, then delivered a Power BI dashboard with 20+ performance metrics and custom KPIs. For COVID-19 Data Analysis, I created a SQL data warehouse integrating datasets from 190+ countries and processed 1M+ records, using window functions and CTEs to analyze vaccination effectiveness and generate detailed insights.

I work across tools and platforms including Python (Pandas, NumPy, Scikit-learn), SQL, Power BI, Excel, and Microsoft Azure (Data Factory, Databricks), and I apply statistical analysis and machine learning to answer practical questions. I’ve also completed certifications in Power BI Desktop (DAX modeling) and Meta’s Data Analyst Professional (SQL, Python). Beyond analytics, I led a 5-member team to organize three consecutive college fests, managing a ₹50K+ budget with 100% ROI and improving participant engagement by 40% through data-driven promotions and predictive analytics.