PRANJAY GULERIA
"Transforming raw data into actionable insights and robust ML systems."
Aspiring Data Scientist pursuing a Master of Data Science at RMIT University, Melbourne. I have hands-on project experience spanning data cleaning, EDA, statistical analysis, machine learning, cloud data engineering, and dashboard development.
Proficient in Python, SQL, AWS, and Power BI/Tableau, with practical exposure to real-world fintech and property datasets through independent projects and job simulations with BCG and Deloitte Australia.
Job Simulations & Projects
Data for Decision Makers Job Simulation
BCG- Analysed customer conversion trends using simulated data to assess multi-channel ad campaign effectiveness.
- Synthesised insights into a clear, data-backed recommendation tailored to the client's marketing goals.
Data Analytics Job Simulation
Deloitte Australia- Covered data analysis and forensic technology; built a data dashboard using Tableau to surface key findings.
- Used Excel to classify data and draw business conclusions.
Featured Projects
Melbourne Housing Analytics AWS Pipeline
End-to-end, event-driven data pipeline on AWS. Processes housing data from raw CSVs through an automated ETL pipeline (Bronze/Silver/Gold) and exposes analytics through an API to a React dashboard.
Melbourne Housing & Rental Affordability Index
Identified low-cost, CBD-proximate suburbs for international students from 18,500+ scraped listings after a PII privacy audit. Normalised data into a 3-table relational schema and visualised suburb-level rent-vs-distance trends using Matplotlib & Seaborn.
Real-Time Credit Card Fraud Detection Engine
Built a fraud classifier for 284,807 transactions with extreme class imbalance (0.172% fraud) using SMOTE + Random Forest. Deployed a containerised FastAPI + Streamlit microservice via Docker Compose.
Skills & Technologies
Data Analytics & ML
Cloud Engineering & Tools
Tech Stack Core
Academic Background
Master of Data Science
RMIT University
Melbourne, AustraliaB.Tech — Artificial Intelligence
Bennett University
Greater Noida, IndiaCertifications
| Certificate Name | Issuer |
|---|---|
| AWS Academy Graduate — ML Foundations | Amazon Web Services |
| Cybersecurity Essentials | Cisco |
| Python for Data Science and AI | IBM / Coursera |