Muhammad Zubair

Payroll Officer

Jun 2021 - Present • 5 yrs 2 mos

As a Payroll Officer in the Finance Department, I am responsible for managing payroll operations for more than 20,000 government employees while ensuring compliance with financial policies, payroll regulations, and organizational procedures. My role involves processing payroll accurately and on time using SAP HCM, SAP Payroll, and SAP FI modules, verifying employee records, calculating salary adjustments, allowances, deductions, taxes, and preparing payroll-related financial reports for senior management and government officials. Alongside payroll administration, I develop Excel-based automation solutions using VBA to streamline repetitive tasks, reduce manual effort, and improve reporting accuracy. I design automated payroll templates, reconciliation tools, reporting systems, and custom Excel utilities that significantly improve operational efficiency. I regularly use advanced Excel features including VBA Macros, Power Query, Pivot Tables, Dynamic Arrays, Lookup Functions, Conditional Formatting, and advanced formulas to analyze payroll and financial data. I prepare monthly payroll reports, management summaries, reconciliation statements, and analytical reports that support decision-making. My responsibilities also include identifying process improvements, validating payroll data, resolving discrepancies, documenting procedures, and supporting users in payroll-related activities. I collaborate with finance teams and supervise a team of four staff members to ensure timely completion of payroll operations while maintaining data accuracy, confidentiality, and compliance. My focus is on improving productivity through automation, accurate reporting, and efficient business processes.

Deputy Accountant

May 2016 - Jun 2021 • 5 yrs 1 mo

As a Deputy Accountant, I was responsible for maintaining government financial records, processing accounting transactions, reconciling payments and receipts, preparing journal entries, maintaining the general ledger, and supporting the preparation of monthly financial statements. I worked extensively with SAP FI/CO and SAP HCM to process financial transactions, verify accounting records, reconcile government accounts, and ensure compliance with public financial management procedures. A significant part of my role involved preparing and compiling Monthly Civil Accounts, reviewing accounting records, identifying discrepancies, and implementing corrective measures to improve the overall accounting process. I collaborated with a team of 7–10 finance professionals to ensure timely financial reporting, accurate reconciliations, and compliance with accounting standards and government regulations. To improve operational efficiency, I developed Excel-based reporting tools and VBA automation solutions for recurring accounting tasks, report generation, reconciliation, and data analysis. I regularly utilized advanced Excel functions, Pivot Tables, Power Query, VBA Macros, Lookup Functions, Conditional Formatting, and dynamic reporting techniques to transform complex financial data into meaningful management reports. I also participated in gathering business requirements, preparing analytical reports, supporting end users, documenting processes, and providing training on automated Excel solutions. My experience strengthened my expertise in accounting, financial reporting, SAP systems, business process improvement, and Excel automation, enabling departments to reduce manual work, improve reporting accuracy, and make informed financial decisions.