// Business & Data Analyst

Nikhil

Turning messy data into clear recommendations.

19 months as a full-time Business Analyst at Upride Networks, a Master of Business Analytics from Deakin, and a donor risk model built on 60,942 World Vision Australia records.

Melbourne, VICOpen to analyst rolesSQL · Python · Tableau · Power BI · Excel

01 — About

Hi, I'm Nikhil.

Business and Data Analyst with 19 months of full-time Business Analyst experience at Upride Networks and a completed Master of Business Analytics from Deakin University. Uses SQL, Python, Power BI and Tableau to turn stakeholder requirements and messy data into models, dashboards and clear recommendations. Built a donor risk model and scoring app on 60,942 World Vision Australia records, selected for presentation to the client, and launched an artist booking marketplace that reached 30 sign-ups in its first two days.

Student visa, applying for Temporary Graduate visa (subclass 485)

ANALYST ID
Photo of Nikhil Gupta

Nikhil Gupta

Junior Business Analyst / Data Analyst

ID No.NG-2026
Dept.Business Analytics
Valid tillOct 2026

What I am

  • Business & Data Analyst
  • Master of Business Analytics, Deakin · B.E. ECE, RVCE
  • 19 months full-time BA at Upride Networks
  • Built Crackerjack, JARVIS & a 60,942-donor risk model
  • Robotics Division Head, Deakin Engineering Society
If found, say hello · nikhilgupta.au@gmail.com

Quick facts

Location
Melbourne, VIC
Education
Master of Business Analytics, Deakin University
Latest role
Data Analyst, World Vision Australia industry project
Email
nikhilgupta.au@gmail.com

“Turning stakeholder requirements and messy data into models, dashboards and clear recommendations.”

02 — Skills

The periodic table of my stack.

03 — Selected work

Things I've built.

01 — Artist booking marketplace · Personal project

Crackerjack

Built and launched crackerjack.live in my spare time: a marketplace where event organisers in India find, book and pay live performers (DJs, bands, singers, photographers), with artist profiles, booking requests, quotes and contracts.

  • 30 sign-ups in the first two days
  • 20 artists, 10 organisers
  • Held-payment flow
  • Tiered cancellation refunds
  • Bill-splitting across up to 8 people
  • “Jack”, an AI event planner
Next.jsSupabase

02 — Multi-agent AI assistant · Personal project

JARVIS

A voice-driven system of 7 AI agents: a daily job-data pipeline that scrapes Seek, LinkedIn and Indeed, a resume checker modelled on a 7-reviewer hiring panel, an application assistant that drafts fact-checked cover letters, and a finance agent that turns bank statements into weekly reports.

  • 7 cooperating agents
  • Scam & expired-post filter
  • Never submits without approval
  • Shared conversation memory
  • Wake words + local TTS
  • Next: Gmail & Telegram updates
PythonClaude APIApify

03 — Enterprise data warehouse · Academic project

ICE Entertainment

Reconciled disconnected sales and ERP systems into a dimensional data warehouse for a global retailer (500 stores, 10 countries), loading 50,000+ records through a 5-layer Pentaho ETL pipeline.

  • 500 stores, 10 countries
  • 50,000+ records loaded
  • 5-layer ETL pipeline
  • Star-schema model
  • 5 management questions answered
  • Revenue, cost & margin by market
MySQLPentahoSQL

04 — Demand forecasting · Machine learning

EcoMoveUS

Built a regression workflow to forecast bike-rental demand from weather, calendar, and temporal features, supporting fleet and staffing decisions.

  • R² 0.941 vs 0.415 baseline
  • RMSE 50.24
  • Hour of day: 68.5% importance
  • Interaction features
  • 80/20 held-out test
  • Feature-importance review
PythonPandasScikit-learn

05 — Network & transportation modelling

VicGoods Logistics

Built a linear-programming transhipment model to minimise weekly freight cost across a 3-tier network of plants, distribution centres, and retail outlets in Victoria, then stress-tested it against route disruption.

  • 27 candidate routes
  • 10 active in the optimum
  • 5 plants · 2 DCs · 6 outlets
  • 2-route disruption test
  • +9.0% cost under disruption
  • Sensitivity analysis
Excel SolverLinear Programming

06 — Interactive Tableau dashboard · Academic project

GoodNews Bookstore

Designed and published a live, interactive dashboard (KPIs, maps, comparisons) linking sales, customer behaviour, membership, promotions and financials for a national bookstore chain.

  • KPI overview
  • Maps
  • Comparisons
  • Membership & promotions
  • Customer behaviour
  • Financials
Tableau

07 — Decision modelling · LP / ILP / NLP

Portfolio Optimisation

Built three Excel Solver optimisation models (linear, integer, and nonlinear) to construct an ASX equity portfolio under real sector, risk, and allocation constraints.

  • 10 ASX stocks, 5 sectors
  • LP: 1.37% monthly return
  • ILP: best 7-stock portfolio
  • NLP: minimum variance
  • 13 constraints
  • Sensitivity analysis
Excel SolverOptimisation

08 — Monte Carlo simulation

Alpine Peak Resort

Built a 1,000-trial Monte Carlo simulation to test room-rate and overbooking strategy for a 50-room alpine resort, weighing expected profit against downside risk.

  • 1,000 trials per scenario
  • 4 calibrated random inputs
  • +47.9% mean daily profit
  • Non-overlapping 95% CIs
  • 0.6% vs 10.5% bad-day risk
  • ~$561K season uplift
ExcelSimulation

04 — Education & experience

One continuous path.

  1. 2018 – 2022 · Education

    B.E. Electronics & Communications Engineering

    RV College of Engineering

    Aug 2018 – Aug 2022

  2. 2022 – 2024 · Work

    Business Analyst

    Upride Networks Pvt Ltd · Bangalore

    Forecast fleet requirements from booking trends; managed ~100 bookings a month (~AUD 10,000 monthly revenue); converted 70–80% of enquiries across 50 gated communities.

  3. 2024 – 2025 · Work

    Career break

    Prepared applications to study in Australia

    Jun 2024 – Feb 2025

  4. 2025 – 2026 · Education

    Master of Business Analytics

    Deakin University · Melbourne

    Feb 2025 – Oct 2026

  5. 2026 · Work

    Founder & Business Analyst

    TapCraft Studio · side business

    9 months of 3D-printed merchandise for college clubs; channel and pricing analysis won about 20 clients and AUD 1,500+ in revenue.

  6. 2026 · Work

    Robotics Division Head

    Deakin Engineering Society

    Coordinated project teams, ran technical workshops, secured sponsorships and delivered prototypes for campus demos.

  7. 2026 · Work

    Data Analyst Intern (part-time)

    Headstart · Melbourne

    Analysed 71 sales consultations (39% close rate) in Python; delivered a sales listening checklist and two CRM requirements.

  8. 2026 · Work

    Data Analyst, Industry Project

    World Vision Australia · Deakin

    Joined six source tables into 60,942 donors, built an explainable 0.850 ROC-AUC risk model and a scoring app presented to World Vision.

  9. Next

    Your team?

    Graduating Oct 2026 · Melbourne, VIC

05 — Achievements

Impact in numbers.

01 / 07

World Vision Australia

Donor records

Six inconsistent tables joined into one validated dataset

0
02 / 07

Explainable risk model

ROC-AUC

Logistic regression, chosen so fundraisers can read the scores

0.000
03 / 07

Crackerjack launch

Sign-ups in 2 days

20 artists and 10 organisers

0
04 / 07

Upride Networks

Months as a BA

Full-time Business Analyst, Nov 2022 – Jun 2024

0
05 / 07

Upride Networks

Enquiry conversion

Across 50 gated communities via WhatsApp

70–0%
06 / 07

ICE Entertainment

Records via ETL

5-layer Pentaho pipeline, 500 stores in 10 countries

0+
07 / 07

TapCraft Studio

Revenue

About 20 clients from Instagram & Facebook ads

AUD 0+
and counting →

06 — Contact

Let's build something together.