Aug 2014 - Present
HKR Roadways Pvt. Ltd
- Receiving and downloading data from 3 Toll plazas, Cleaning and formatting data using by EXCEL.
- Cleaning and uploading data in CRM on date and priority basis. Sharing all data disposition with toll heads.
- Creating and updating Executives Financial report in Dashboard and Share MIS Dashboard to the seniors.
- Handling multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data.
- Updating Data Tracker and MIS Dashboard on daily and weekly basis.
- Creating Executives log in / log out and break report
- Updating attendance dashboard and sending the executives allocating report to GM.
- Excellent in MS Access, MS Excel (Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, Charts, Macro, Forms, data validation)
- Keep the Operation & Finance manager informed of task accomplishment, issues and status.
- Prepared Proactive checklist for database & important work to avoid future downtime.