Vidhya Shanker Goel

Data Analyst @Rugby Canada

Toronto, ON, CA

During my internship at Rugby Canada, I contributed to building a modern, data-driven analytics platform that transformed how the organization understood membership engagement and retention. Working across data engineering, analytics, and DevOps, I combined automation, scalability, and visualization to deliver actionable insights for executives and non-technical staff alike.Key Achievements & Impact• Engineered robust ETL pipelines in Python (Pandas, NumPy, SQLAlchemy) to process 200 K+ membership records; implemented validation and reconciliation logic ensuring 100 % data integrity for BI dashboards.• Developed interactive Streamlit dashboards and contributed to a ReactJS front-end enabling self-service exploration of KPIs, trends, and retention cohorts.• Supported ML model development (scikit-learn, XGBoost) for churn and engagement prediction; improved forecast accuracy by 35 % through optimized feature views and training pipelines.• Prototyped an LLM-powered Q&A chatbot (Ollama) allowing staff to query the database in natural language with auto-generated visual responses.• Containerized the entire analytics stack with Docker and automated deployment using Jenkins, Kubernetes, and ArgoCD, ensuring consistent, scalable environments for data science workloads.• Delivered Power BI and R/Plotly executive reports highlighting membership growth, retention, and demographic patterns to inform strategic planning.Tech Stack: Python | Pandas | SQLAlchemy | Power BI | Streamlit | React | Docker | Jenkins | Kubernetes | ArgoCD | Scikit-learn | XGBoost | LLMs (Ollama)| DevOps Automation