ROSHAN RATH

• Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
• Built 6 Power BI dashboards (Appointment 360, Wellness Plans 360, Digital Booking Insights, DVM Utilization, Wellness Plan Performance, Customer Referral Insights) to support clinical operations and executive decision-making.
• Designed and developed STAR-schema-based fact tables in Redshift, including: Wellness Plan Fact Table, DVM Utilization Fact Table.
• Created aggregated datasets at the MSA, DVM, city, hospital, and appointment levels, ensuring flexible slicing for analytics.
• Developed data transformation pipelines using Python, PySpark, and SQLAlchemy, storing outputs as Parquet for optimized query performance.
• Conducted data validation by reconciling metrics against the GoodVets website and source booking systems to ensure accuracy and consistency.
• Automated recurring performance reporting reduces manual effort and enables faster insights for leadership.
• Identified revenue leakage in wellness plans and provided data-backed recommendations that supported revenue protection.
• Coordinated with the Product, Operations, and Finance teams to define KPIs, dashboard requirements, and ensure alignment with business goals.

Analyze data, and apply appropriate statistical techniques to generate insights.

Collaborate with cross-functional teams to identify and solve business problems using data-driven initiatives.

Develop data visualizations using Power BI to communicate insights.

• Completed a comprehensive 9-hour SQL bootcamp on Udemy, covering fundamental to advanced SQL topics.
• Completed a 22-hour comprehensive Python bootcamp on Udemy, covering the fundamentals of Python programming.
• Successfully passed the HackerRank skill certification test(Python-Basic).
• Successfully passed the HackerRank skill certification test(SQL-Intermediate).