Skip to main content
Pashang Vaid

Pashang Vaid

Data Analyst

Talent
SydneyMember since July 23, 2026
SQLPythonSegmentationRegressionPower BIAdvanced ExcelDashboard DesignData StorytellingRelational Data ModellingSQL Joins and AggregationsETLData-Quality ControlsSalesforce Health CloudZoho CRMTally ERP 9Git
·

Hire this person

Send a job offer directly to this candidate

SQLPythonSegmentationRegressionPower BI

About

Data Analyst with 5+ years of combined experience across operations, reporting and analytics, including hands-on analysis of retail, financial-services and customer datasets. Uses SQL, Python, Power BI and advanced Excel to clean, validate, reconcile and model data, automate recurring reporting and translate findings into practical decisions. Experienced in KPI dashboards, customer segmentation, data-quality controls, transaction analysis and relational data modelling.

Experience

Allocation Analyst at TK Maxx (2026-02 – 2026-07)

  • Turned sales and inventory data across 92 stores, nine subclasses and approximately 31,000 weekly units into allocation and replenishment recommendations by analysing sales velocity, inventory turn, stock cover and store-level demand through STAR reports, ladder plans and advanced Excel.
  • Improved visibility of stockout, excess-stock and sell-through risks by reconciling sales-versus-inventory results, investigating transaction and allocation exceptions and identifying high- and low-demand locations.
  • Created a repeatable validation process used by the allocation team before weekly stock decisions were finalised, standardising KPI checks and translating store and subclass trends into stock-rebalancing actions.

Data Analyst - Capstone Internship at World Vision Australia (2025-02 – 2025-06)

  • Identified a 30% segmentation misclassification rate across 9,790+ donor records by profiling, cleaning and validating behavioural, channel and stream-assignment data using Python and Power BI.
  • Diagnosed campaign-performance gaps by tracing incorrect stream placement and donation-tier mismatches to weaknesses in data logic and segmentation rules.
  • Developed revised segmentation logic, validation controls and dashboard KPIs for a Smart Engagement Engine, testing the rules against representative records before stakeholder review.
  • Converted complex findings into Power BI visualisations and recommendations projected to improve digital engagement by 13%, enabling senior stakeholders to compare options and expected value.

Team Member - Fuel & Inventory at EG Ampol (2024-03 – 2025-03)

  • Protected daily operational-data accuracy by reconciling fuel, inventory, cash and POS records across Ampol BOS, Verifone POS and Excel, investigating anomalies and closing exceptions within SLA deadlines.

Business Process Analyst at Tata Consultancy Services (Citi Bank Contract) (2022-04 – 2022-11)

  • Improved visibility of SLA, ageing and operational risk across 76+ daily credit-card dispute and fraud cases by analysing status, exception categories, root causes and turnaround performance.
  • Reduced manual reporting effort and improved data consistency by defining KPI fields with Finance and Quality Assurance, building automated Excel trackers and applying validation rules for case classification and exception monitoring.
  • Produced weekly KPI, performance and variance reports that enabled Finance, Quality Assurance and Operations teams to identify ageing cases, prioritise corrective action and monitor workflow performance.
  • Strengthened report reliability by validating tracker logic against operational records and documenting data fields, definitions and exception-handling procedures in Jira and supporting documentation.

Data Entry & Operations Support Analyst at Sitel Group (2021-09 – 2022-03)

  • Improved accuracy and completeness across 89+ daily Salesforce Health Cloud records by applying Excel validation rules, resolving missing and inconsistent values and reporting workload and SLA trends.

Business & Recruitment Analyst at WhiteHat Jr (2020-09 – 2021-01)

  • Improved recruitment-funnel decisions by analysing candidate stages, conversion and drop-off data in Zoho CRM, correcting incomplete records and producing weekly KPI reports.

Business Operations & Inventory Analyst at Jer Bar (2019-05 – 2020-07)

  • Maintained 98.70% inventory-data accuracy by reconciling Tally ERP 9 records with physical stock and sales data, investigating variances and reporting shortages, excess holdings and recurring discrepancies.

Education

Master of Business Analytics in Supply Chain Management & Information Systems – Deakin University (2023-11 – 2025-06)

Master of Commerce in Business Management – St. Andrews College (2019-08)

Bachelor of Management Studies in Marketing Management – MVM Degree College (2017-04)

Skills

Data Analyst

Reviews

Related