INTRODUCTION OF AZFAR SHAHZAD
I am an accountant by qualification and a management consultant by profession, I have worked on all kinds of consultancies/ advisories/ audits/ BPO’s since 1998 (21 years). I have experience of working extensively on spreadsheet (both Microsoft Excel and Google Sheets) and data analysis. I can work with formulas, pivots, macros and limited Visual Based Editing. I have acquired these skills by working on various jobs/ projects, I have highlighted two for your perusal:
1. Dewan Salman Fiber Limited: My work entailed import of Trial Balance from ERP to excel, making of costing accounts including manufacturing account, using complex formulas of linking sheets to ascertain Profit and Loss a/c, Balance Sheet, Cash Flow Statement and adjoining notes/ descriptions.
2. PriceWaterHouseCoopers (Medium Term Budgetary Framework): I was Financial Analyst there. MTBF had to redo the budgets of MoH to present medium term budgets linked to outputs and outputs and outcomes. I had to do the whole budget book in excel.
METHODOLOGY OF ASSIGNMENT
1. Understanding the data structure to be compiled in spreadsheet to make a methodology of entering data on it.
2. Data entry/ import of the data on spreadsheet according to methodology identified on first step.
3. Applying gaming variables with mathematics to analyze the data.
4. Review and discuss with you, the results of data analysis.
5. Making changes to the data/ its analysis, if any.
Regards, Azfar Shahzad