Websitesbusinesseslove.
I design and build fast, modern websites for local businesses — and data systems for teams that run on insights.
About
I'm a CS student at TMU with a focus ondatabase architecture and analytics —the kind of work that turns raw datainto decisions that actually matter.
Degree
B.Sc. Computer Science
Toronto Metropolitan University · 2027
Internship
Open to roles
Data analyst · DB developer · Full-stack
Side venture
arweb.co
4 live client sites delivered
Client Work
Selected work
Core Tools
Analytics & Database
Projects
Sales Data Warehouse & Analytics Pipeline
CompletedEnd-to-end data warehouse built in PostgreSQL using a star schema (fact + dimension tables). Python ETL pipeline ingests and transforms raw CSV sales data. Includes 20+ analytical SQL queries — YoY revenue growth, customer cohort retention, and product margin analysis — surfaced via a Tableau KPI dashboard.
Customer Churn Analysis Dashboard
CompletedAnalyzed a 10,000+ row retail dataset to identify churn drivers using Python (pandas, seaborn) and SQL. Built a Tableau dashboard surfacing top churn risk segments with a business-ready retention report.
E-Commerce Sales & Inventory Analytics
CompletedDesigned a normalized relational schema (3NF/BCNF) for an e-commerce business. Wrote 15+ SQL queries to answer business questions and validated results in BigQuery. Built a Google Sheets KPI dashboard for non-technical stakeholders.
Predictive Sports Analytics Engine
PlannedA data pipeline that ingests historical game statistics from public sports APIs into a normalized PostgreSQL database, applies machine learning models (scikit-learn) to forecast game outcomes, and serves live predictions through a Flask dashboard. Designed with data integrity, query performance, and model accuracy in mind.
Let's talk
Open to internships
& new clients.
Whether you need a database developer for a team or a website built for your business — get in touch. I reply within 24 hours.
Based in Toronto, ON · anshrai.com