Interactive Retail Analytics Dashboard
Developed an interactive retail analytics dashboard in Microsoft Excel using Power Query, Pivot Tables, Pivot Charts, and dynamic slicers to analyse 9,900+ retail transactions. Built KPI cards and visualisations for sales, profitability, profit margins, and regional performance.
Financial Accounting & Reporting
Prepared 10+ sets of final accounts, including trial balances, profit and loss statements, and balance sheets, across three academic years using double-entry bookkeeping. Applied bookkeeping across 5+ accounting cycles, handled accounts payable and receivable reconciliation, and assisted in audit-ready documentation.
Business Management & Operations
Analysed 8+ case studies on organisational structures, resource allocation, and workflow optimisation, and prepared three structured reports applying planning and control frameworks.
TallyPrime & MS Excel
Performed 50+ accounting entries in TallyPrime, including contra, payment, receipt, and journal vouchers, and generated GST-compliant financial reports. Built Excel worksheets using VLOOKUP, SUMIF, and Pivot Tables for datasets of 100+ rows, preparing 5+ reports and presentations.