Majeeduddin Ahmed

MIS Executive –- Four US Clients – Boost Mobile

Skills 

Working on V-lookup, Pivot Table, Dashboards, Slicers, data validation, Filter, Sort, Conditional Formatting, If, If error, Sum If, Average, Sum, Subtotal Functions in Excel

Working on Google Sheets, Google Forms also as per requirement

Responsibilities

Reporting****Department

Prepare Annual Data Analysis report (Data Cleaning and Data Processing) of all stores in excel

Cash & Card Reconciliation of 50 stores (four US Clients) daily in Google Sheet

Prepare Daily Sales reports (Location wise and Employee wise) for (four US Clients) thrice a day in Excel

Prepare Monthly Sales reports (Location wise and Employee wise) for (four US Clients) on bi-weekly basis in Excel

Prepare Employee Competition Report if needed in Excel

Check out Deposit amount shortages from the store employee on daily basis

Prepare Device wise sales report for each store.

Prepare Gp report for 50 stores on daily basis in Excel

Check reporting emails

Admin & Hr Department

Daily Employee Timesheet & Attendance Check and prepare Late login sheet in Google Sheet

Prepare Employees Payroll (monthly) and Commission (bi-weekly)

Prepare Employee performance reports on daily basis in Excel

Prepare New Employee Contracts

Check Admin emails

Inventory Department

Need to do daily inventory Audit of all 50 stores

Need to compare the inventory received at stores with the purchase order

Process defective devices back to vendor

Check inventory emails