08/26/2024 updated
100 % available
Accountant & Data Analyst, Senior Accounts Officer, Manager Finance
Islamabad, Pakistan
Worldwide
Chartered Management Accountant - PakistanAccountingData AnalysisData CleansingFinancesExcel FormulasExcel MacrosExcel Pivot TablesVisual Basic .NET (Programming Language)Peachtree (Accounting Software)Pivot ChartsPivot TablePowerpivotVisualizationQuickBooks (Software)Microsoft Power BI
I am an experienced Chartered Management Accountant skilled in Microsoft Excel, specializing in VBA macros, Power Query, and data analysis. With a strong accounting background, I deliver efficient, tailored Excel solutions. Expertise includes data cleaning, entry, merging, splitting, and creating interactive dashboards using Power BI for clear visualization. My solutions are organized, formatted for actionable insights, and compatible with Google Sheets for flexible, cloud-based management. I help businesses achieve their analytical goals and make informed decisions.
Experience
Professional experience10+ years
Freelancer since2018
Languages
EnglishFluent
Project history
Besides leading the whole Accounts Staff, I was responsible for:
* Preparation and submission of Tariff Petitions, Fuel Price Adjustments, Indexation
of Tariff, and Motions for review to the National Electric Power Regulatory Authority
(NEPRA).
* Oversight of revenue management, including invoicing for the sale of electricity
and handling liquidated damages.
Page 1 of 4
* Management of financial accounting, monitoring, and reporting systems, along
with maintaining effective liaison with auditors.
* Preparation of regulatory accounts for submission to NEPRA.
* Execution of budgeting, forecasting, and investment activities.
* Supervision of receivables, reconciliation with power purchasers, and resolution of
disputes.
* Conducted negotiations and finalized financial clauses within loan agreements
with lenders and power purchase agreements with power purchasers.
* Handling the drawing and disbursing of funds.
* Preparation and submission of Tariff Petitions, Fuel Price Adjustments, Indexation
of Tariff, and Motions for review to the National Electric Power Regulatory Authority
(NEPRA).
* Oversight of revenue management, including invoicing for the sale of electricity
and handling liquidated damages.
Page 1 of 4
* Management of financial accounting, monitoring, and reporting systems, along
with maintaining effective liaison with auditors.
* Preparation of regulatory accounts for submission to NEPRA.
* Execution of budgeting, forecasting, and investment activities.
* Supervision of receivables, reconciliation with power purchasers, and resolution of
disputes.
* Conducted negotiations and finalized financial clauses within loan agreements
with lenders and power purchase agreements with power purchasers.
* Handling the drawing and disbursing of funds.
Consultancy for Developing polices & procedures, Internal controls, risk mitigation etc.
Certificates
Chartered Management Accounting
Institute of Cost and Management Accountants of Pakistan2011