Pakistan

Data Analysis

Master of Business Administration (M.B.A.)

Waqar Ahmed Shaikh

Unit Head MIS & HR Analytics

Problem-solving

Presentation skills

Analytical skills

Advanced data analytics

Tableau

PowerBI

Working in Administration Division of Operations Group, NBP Head Office, Karachi. 
- Responsible for preparing monthly staff strength of Operations Group posted all across Pakistan. 
- Preparation of Dashboard for senior management overview.
- Analysis of staff strength in various branches.
- Preparation of miscellaneous MIS reports pertaining to staff
- Visualization using Excel and Power BI Dashboard.

- To act as FBR Coordinator i.e. Govt. Payment / Receipt
- To act as Regional Coordinator of Western Union / E-Remittance
- To monitor FBR collection and ensure its settlement with SBP by Main Branch Karachi on every month end
- To ensure implementation of Govt. Receipt System (GRS) and maintain daily progress report of the implementation status of GRS.
- To ensure meticulous compliance by Branches regarding unlawful retention of the amount in Govt. Collection Accounts and submission of monthly zero outstanding certificate of Govt. Collection Accounts.
- To ensure implementation of centralized Govt. Pension System (GPS) and monitor and maintain daily progress reports of the implementation status of GPS.
To process all types of Pension – Civil (Provincial / Central), Armed, Railway related matter and its correspondence.
- To prepare and maintain a record of General Insurance (Cash, Dead Stock, Gold Ornaments, ATMs, Lockers etc.)
- To settle entries outstanding in Protested Bills Account / Suspense Account / Sundry Deposit / DDP
- To maintain MIS of non – Balancing of Books as per Head Office Inst. Cir No. 03/2016 dated: 05.01.2016
- To maintain record of EOBI Payment / Collection and submission to Main Branch Karachi 
- Miscellaneous Data Cleansing Exercise.

I have been working as Microsoft Excel Trainer at NBP, Staff College, Karachi and often teach Excel at various institutes. My core expertise are:
- Advanced formula based solution to complex Excel queries
- Working on BIG Data and transforming it into meaningful information
- Dashboard Reporting in Excel and Power BI

Worked under the supervision of Incharge Returns in Operations Department, NBP Regional Office, Karachi.  I was responsible for preparing monthly business performance reports, ALCO, Depositors and Borrowers Data etc.

Credit Card Reconciliation
IPP - IQ Reconciliation
Datascape - IQ Reconciliation

Waqar Ahmed Shaikh🇵🇰

About Waqar Ahmed Shaikh

Expertise

Sessions with Waqar Ahmed Shaikh

What mentees say