Rayyan Aamir Shekhani
  • Home
  • CV
  • Projects

On this page

  • Education
  • Professional Accreditations
  • Skills
  • Projects
  • Awards
  • Experience

CV

Education

Master of Business Analytics 2024 – 2025
Grade (CGPA): 3.83 / 4.00
Monash University – Melbourne, Australia
Bachelor of Business and Commerce 2020 – 2023
Major: Business Analytics
Monash University – Kuala Lumpur, Malaysia

Professional Accreditations

  • Statistical Society of Australia (SSA) - Graduate Statistician (GStat)

Skills

Programming & Data Analysis
SQL, Python, R, DAX, Bash, VBA
Statistical Analysis, A/B Testing, Regression, Market Basket Analysis
User & Market Research, Segmentation, ETL Pipeline Development, Time Series Forecasting
Visualisation & BI
Power BI, RShiny, Tableau, Microsoft Excel
Advanced Excel (Formulas, Audits, Reconciliation, Validation, Lookups)
Data Management & Governance
KPI Documentation, Data Quality Checks, Validation Controls
Privacy, Security, Governance Compliance, Report Testing & Stakeholder Sign-off
Cloud & Data Platforms
Google Cloud, AWS, SQL Server, MySQL, Snowflake (Analytics Consumption)
DuckDB, Git, CI/CD
Project Management & Methodologies
Agile (Scrum/Kanban), Project Management, People Management
JIRA, Confluence, Microsoft Office Suite

Projects

Australian Migration & Labour Market Dashboard (RShiny)
  • Developed a multi-tab interactive RShiny dashboard integrating multiple ABS datasets to analyse Australian labour force dynamics across migration, employment, and education dimensions.
  • Performed extensive data cleaning, transformation, and alignment in R to support cross-variable analysis, building interactive visualizations including geospatial maps, Sankey flows, time-series comparisons, and distribution plots.
  • Applied statistical techniques such as linear regression within the dashboard to explore relationships (e.g. education and income), presenting results directly for user interpretation.
Applied Retail Forecasting & Model Evaluation (ABS Data)
  • Conducted an end-to-end forecasting analysis on Australian retail turnover data, examining long-term trends, seasonality, and structural disruption around COVID-19 using variance stabilization, decomposition, and stationarity diagnostics.
  • Developed and compared ETS and ARIMA models based on data characteristics, theoretical suitability, and information criteria, evaluating trade-offs between forecast stability and responsiveness using rolling test sets and multiple accuracy metrics.
  • Validated forecasts against newly released ABS data beyond the original sample period and outlined a repeatable operational workflow for annual model review, refitting, and performance monitoring.
Service Flow Simulation Tool
  • Developing a simulation tool to explore service-flow dynamics, modelling customer arrivals, service times, and queue selection behaviour using probabilistic distributions to reflect real-world uncertainty.
  • Implemented logic where customers dynamically join the shortest available queue, enabling analysis of congestion, waiting-time behaviour, and system performance under varying arrival and service conditions.
  • Designed the tool to support scenario testing across different parameter settings; the current version demonstrates core simulation logic, with additional distributions and controls in progress.
YouTube Analytics ETL Pipeline & Power BI Dashboard (Ongoing)
  • Building an end-to-end ETL pipeline extracting YouTube channel and video metadata via the YouTube Data API, persisting time-stamped raw snapshots to support reproducibility and trend analysis.
  • Implementing transformation and data modelling logic in DuckDB using SQL to produce analytics-ready dimension and fact tables, alongside derived KPIs such as subscriber growth, view growth, and upload cadence.
  • Designing a refreshable Power BI dashboard to visualise channel growth, content performance, and portfolio-level insights using curated datasets.

Awards

  • Monash Faculty of IT, Award of Excellence - Honoured for exceptional project in FIT5057 – Project Management, selected from over 250 groups.

Experience

Data Analyst - Government Relations
SEEK Australia July 2025 – December 2025
  • SEEK is a leading employment marketplace, providing job search, hiring, and market insights across Australia and Asia-Pacific.
  • Analysed labour market trends using ABS, JSA, and internal datasets, combining SQL (AWS Athena) and R Programming to generate insights across different geographies.
  • Developed scalable and automated reporting ETL pipelines, producing refreshable labour market insight reports used by Government Relations, Growth, and Commercial teams
  • Queried and integrated large internal datasets with external government sources, improving consistency and depth of analysis across multiple stakeholder use cases.
  • Collaborated with cross-functional stakeholders to translate technical findings into clear, actionable insights for non-technical audiences.
  • Contributed to a data integration initiative mapping SEEK and Jora datasets through structured ontology and data modelling concepts.
  • Delivered analytical outputs supporting high-impact strategic initiatives, with project work linked to an estimated ~$10M revenue opportunity.
Product Data Analyst
SynergySphere Enterprises September 2024 – April 2025
  • SynergySphere is a small-scale 3D printing business that delivers customized products to clients across retail and hospitality.
  • Analysed sales and cost datasets to identify high-margin products and optimise pricing insights, improving average product profit margins.
  • Designed and managed an SQL database linking customer, order, and backlog data, supporting visibility across 100+ active and completed jobs.
  • Conducted product and demand analysis on order patterns, increasing repeat customer rate by 30% through refined product offerings.
  • Evaluated material, print time, and labour costs using Power BI (DAX), reducing per-unit production costs over 6 months.
  • Tracked and reported order pipeline and delivery timelines, reducing average turnaround time and improving scheduling efficiency.
Data Analyst - Supply Chain
MyTree August 2023 – August 2024
  • MyTree was a platform redistributing surplus food from suppliers to businesses, helping reduce waste and lower procurement costs.
  • Analysed fulfilment, delivery, and inventory insights data across 1,000+ orders to identify inefficiencies and cost drivers.
  • Built Power BI dashboards to track core KPIs, leading to an improvement in on-time delivery performance.
  • Performed statistical route analysis to identify inefficient delivery zones, improving route planning.
  • Queried operational datasets in SQL to support reporting on demand, delivery performance, and warehouse activity across multiple regions.
  • Assessed unit economics by order and region, identifying low-margin segments and contributing to 2 cost optimisation initiatives.