Earth from space

Toronto, Canada

Ansh Rai —
developer &
builder.

CS student at TMU · Full-stack · Data & databases

See my work →Get in touch
Scroll

Core Tools

PostgreSQLPythonSQLBigQuerypandasSQLAlchemyTableauETL PipelinesStar SchemaData WarehousingPostgreSQLPythonSQLBigQuerypandasSQLAlchemyTableauETL PipelinesStar SchemaData WarehousingPostgreSQLPythonSQLBigQuerypandasSQLAlchemyTableauETL PipelinesStar SchemaData Warehousing
Framer MotionNext.jsReactMongoDBFlaskREST APIsGitGoogle Analyticsscikit-learnGoogle SheetsFramer MotionNext.jsReactMongoDBFlaskREST APIsGitGoogle Analyticsscikit-learnGoogle SheetsFramer MotionNext.jsReactMongoDBFlaskREST APIsGitGoogle Analyticsscikit-learnGoogle Sheets

Featured Work

A selection of projects
that create impact.

4 projects

Sales Data Warehouse & Analytics Pipeline

Completed

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 Schema
View project →

Customer Churn Analysis Dashboard

Completed

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.

PythonSQLTableaupandas

E-Commerce Sales & Inventory Analytics

Completed

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 Design
View project →

Predictive Sports Analytics Engine

Planned

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-learnFlask

For Tech Recruiters

CS student. Builder.

Computer Science student at Toronto Metropolitan University (TMU) with hands-on experience building production web applications and data-driven systems for real clients. Currently seeking opportunities as a Database Developer or Data Analyst.

I don't just study computer science — I apply it. From managing PostgreSQL databases to building full-stack platforms with authentication and dashboards, every project here is something a real business paid for and uses today.

Target Roles

Database Developer
Data Analyst
Junior Full-Stack Developer
GitHub Profile ↗Contact me

Core Skills

SQL / PostgreSQL90%
Python82%
React / Next.js95%
Database Design88%
Data Analysis80%
Node.js / REST APIs85%

Technologies

PostgreSQLMySQLSQLitePythonPandasNumPyReactNext.jsTypeScriptNode.jsREST APIsGraphQLGitLinuxVercelTailwind CSSFramer Motion

Skills & Tools

Built with the right tools
for every job.

Frontend

Next.js
React
Tailwind CSS
HTML & CSS
Framer Motion
GSAP

Backend

Python
Node.js
Flask
REST APIs
Authentication

Databases

PostgreSQL
MongoDB
BigQuery
SQL
SQLAlchemy
Schema Design

Data & Analytics

pandas
scikit-learn
Tableau
Google Sheets
ETL Pipelines
Data Visualization

Tools & Cloud

Git & GitHub
Vercel
Google Cloud
VS Code
Figma

Business

Web Design
SEO
UX Thinking
Client Communication
Project Management

About Me

I turn ideas into
scalable solutions
with clean code
and smart data.

I'm a Computer Science student at Toronto Metropolitan University targeting database developer and data analyst roles. I also run arweb Solutions — a web development studio for local businesses.

I got into tech because I saw local businesses losing customers to competitors with better websites — and realized I could fix that. Now I build the kind of digital experiences that actually move the needle.

Whether it's a performant web app, a normalized PostgreSQL schema, or a Tableau dashboard that reveals hidden patterns — I build technology that solves real business problems.

Clean Code & Modern Design

Fast, responsive websites built with best practices.

Data That Drives Growth

From databases to dashboards, I help turn data into action.

Reliable & Collaborative

Clear communication, on-time delivery, and long-term support.

10+

Projects Delivered

5+

Happy Clients

2+

Years Building

Let's Work Together

Let's build something
meaningful.

Whether you need a developer for your team or a website for your business — let's build something great. I reply within 24 hours.

Work TogetherLinkedInGitHubarweb Solutions ↗

Based in Toronto, ON · Open to remote