ansh.dev — README.md

Hi, I'm Ansh Rai.

Database Developer  ·  CS Student  ·  Founder, arweb.co

🎓 TMU · CS · Expected 2027📍 Toronto, ON💼 Open to internships

Client Work

arweb.co ↗

Projects

View all →
Sales Data Warehouse & Analytics PipelineCompleted

End-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.

PostgreSQLPythonETLStar SchemaTableauSQLAlchemypandas
Customer Churn Analysis DashboardCompleted

Analyzed 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.

PythonSQLTableaupandasseaborn
E-Commerce Sales & Inventory AnalyticsCompleted

Designed 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.

SQLBigQueryGoogle SheetsDB DesignCRUD
E-Commerce Sales & Inventory Analytics
Predictive Sports Analytics EnginePlanned

A 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.

PythonPostgreSQLscikit-learnFlaskREST APIspandas

PythonSQLPostgreSQLBigQueryTableaupandasNext.jsMongoDBFlaskGit
Home
Projects
Experience
Skills
Contact