Sam Bhattacharya Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

Successfully delivered projects within timelines, developed decision making tools using statistical and mathematical analysis, developed interactive dashboard, carbon emission calculation tools, conducted client interviews, KPI measurement and tracking, performed user testing, data visualization, storytelling, budgeting tools, variance analysis of budget vs actual spend, financial and non-financial forecasting and stakeholder management.

Brisbane, Queensland, Australia

Successfully developed automated tools to extract data from multiple sources, achieved data cleansing and error removal from extracted data for developing reports, developed and maintained databases, used statistical tools to identify, analyse, and interpret patterns and trends, created automated user forms and automated project tracker form reflecting multiple projects with auto update features, designed and developed dashboards in Python, Power BI, MSBI, Power Query and Excel.

Brisbane, Queensland, Australia

Successfully designed and created new budget development process achieving better budget management and efficient monthly management reporting for all departments in the organisation, incorporated visual charts showing tracking of revenue vs expenditure, initiated meetings with directors providing training and support resulting in efficient budget build, formulated extensive financial modelling and financial forecasting using advanced Excel and Power Business Intelligence (BI) skills for both revenue and expenditure items reflecting monthly and full year position, developed dynamic pricing model for member subscription prices incorporating what if analysis for multiple scenarios ensuing improved management decision process during volatile economic situations, calculated membership growth showing visual charts for the growth over the past few years, analysis of price vs membership relationship used for future membership price changes, variance analysis explaining differences between forecast projection vs actual results, actively participated in developing strategies for the workforce team.

Brisbane, Queensland, Australia

Effectively completed general ledger reconciliations for balance sheet and profit & loss accounts resulting in accuracy of financial reporting, successfully prepared end of financial year statements and writing notes to financial statements required by the state audit office, analysing variances between two financial years articulating changes in individual business areas, successfully performed data mining and analysis of revenue as per Australian Accounting Standards Board AASB 15 Revenue from contracts and AASB 16 Leases resulting in effective financial reporting, performed business partnering with business managers across Queensland for timely reporting.

Brisbane, Queensland, Australia

Efficaciously prepared various management reporting including land and building valuation, loans, cash funding certificate, and plant & equipment report to be used by the board members, prepared monthly income statement from SAP data extracted, accurately executed budget adjustment schedules for the current and future budget rounds, performed financial forecasting & budget preparation, processed adjustments in budget journals, created finance and infrastructure reports, prepared non-financial reports such as full-time equivalent FTE and accrual reports.

Darwin, Australia

Prepared budget templates for all functional areas in the department, provided training to managers in operational areas for budget calculation by conducting meetings and workshops, produced financial forecasting and modelling using advanced Excel, SAP Business Intelligence and Business Objects skills, building strategies for maximizing revenue from various streams, preparing and distributing variance analysis reports to all the business managers showing actual results vs forecasted projections, implemented strategies in workforce planning at the hospital operational areas by calculating medical staff vs patient ratio resulting in reduction of patient wait times in the hospitals.

Darwin, Australia

Prepared zero based budgets in consultation with divisional managers, organised meetings with area managers to build activity vs cost relationship in working out personnel positions and staffing budget requirements resulting in efficient performance of the business area, oversee credit card reconciliation following the Financial Management Act, advise staff on financial and HR delegations for workflow approval.

Postgraduate Degree, Data Science

Currently studying Postgraduate course in Data Science from The University of New South Wales (UNSW). Having exposed to the miraculous.

Accounting And Finance