Rohan Matta - Data Analyst & Software Engineer

June 2025 - August 2025

Cambridge, MA

Led A/B testing initiatives to evaluate feature impact on user behavior, causing a 1.2% increase in monthly retention
Designed and implemented a company-wide scalable analytics framework using Databricks in order for internal product teams to analyze event patterns using Foursquare open-source geolocation data
Wrote and executed SQL queries in Amazon Athena on large-scale datasets, determining that 60% of user trip uploads occur in the top 3 locations, enabling targeted engagement strategies
Developed Tableau dashboards to visualize user behavior trends and internal tool usage metrics for senior leadership
Led and managed a cross-functional team and came in 2nd place out of 45 teams at a company-wide hackathon
Designed an alert system in Python, retrieving historical geolocation data from previous customer trips with SQL queries to identify and warn users upon entering high-risk event prone zones (e.g., crash, hard braking)

June 2024 - August 2024

Cambridge, MA

Implemented group user retrieval and authorization using Python for request consolidation and SQL to optimize data queries, achieving improved API efficiency by consolidating multiple (n+1) requests into a single call
Enhanced performance of user lookup by unique field indexing in SQL, resulting in a 60% reduction in response times
Improved the driver status API by adding trip count fields using Python, enhancing visibility into driver activity
Collaborated with the data team to export backend API metrics for visualization in Tableau, highlighting trends in driver behavior and API response efficiency