Data management Dashboards create various kind of report Data analysis Cordination

Key Skills

Advance excel
VBA
Google sheet
SQL

Professional Experience

Jan 2020
Present
Sr. MIS Executive (HR & Admin)
Interglobe Aviation Ltd (IndiGo Airlines) Mumbai, IN
Responsibilities:

✓ Cabin crew Data management with zero errors for (DGCA & internal Audit compliance)
✓ Timely updating of all crew Data (check forms / DGCA letters / Medical / Disciplinary letters) on 
employee
✓ Diary and filing of the hard copies.
✓ Integrity to ensure critical and base related information are maintained with confidentiality.
✓ Uniform & stationery inventory Management.
✓ Ensure all employee records of base are up-to-date for compliance
✓ Aep(Airport entry Pass) manage for In-flight service Department
✓ PEP(per employee performance) count of all employees
✓ Leave manage of all crew staff
✓ Medical Document of IFS Department Maintain in excel daily wise
✓ Dashboard Create for various report
✓ Making Flight Brief for Cabin Crew
✓ Letter Drafting
✓ Making Presentation on Power Point for IFS Department 
✓ Coordinate with DGCA for Various kind of information of Crew Or Flight Related Report
✓ Manage Log Sheets for Crew
✓ Attendance Management of IFS Department
✓ Coordinate with HR(IFS) for Attendance Related Issue
May 2019
Sep 2019
MIS Executive
Pricol Ltd Gurgaon, IN
Making inspection report of speedometer(Dial) Daily and monthly wise.
✓ Plan vrs actual report.
✓ KPI report.
✓ Making report for Different type of NG part of Speedometer.
✓ Daily production report of Speedometer
✓ Coordinate With Production Department for Production Report
✓ Coordinate with Plant Head Permission 
May 2016
Oct 2019
MIS Executive
Vijay Logistics Pvt Ltd Gurgaon, IN
Daily preparation of Goods Dispatch differences (if any) on a daily basis On time generation & 
reporting of MIS reports.
✓ Making Trip log/Challan.
✓ Docket entry in ERP.
✓ E way Bill Generate of Good .
✓ Vehicle Tracking & Making Tracking Report.
✓ Coordinate with Marketing Member & taking report
✓ Vendor Management
✓ Answers of Customer Query on Call
✓ check all unloading related documentation and sign off
✓ Supervise daily stock taking of empties / shells & identify shortages Daily updating Breakage 
register
✓ Controlling & reducing breakages during empty loading & unloading
✓ Carry out inventory control of empty glasses inventory
✓ Working With V-Lookup, H-Lookup And Pivot Tables ,and other Knowledge of Advance Excel

Education

May 2014
Jun 2017
B.sc in ROURKELA MUNICIPAL COLLEGE
Sambalpur University
May 2010
Jun 2012
12th in SBIC
UPBHSIE
May 2008
Jun 2009
10th in PMIC
UPBHSIE

Certifications

2014
GNIIT SOFTWARE ENGINEERING
NIIT TECHNOLOGIES
2013
Bridge module IT & ITES
NIIT YUVA jyoti

Achievements

2020
6 E Rewards Indigo
Best report  management  Inflight Service 

Hobbies & Interests

  • Cricket
  • Listening Music
  • Reading book

Languages

Hindi
(Fluent)
English
(Native)
Odia (Oriya)
(Fluent)

Get in touch with Mukesh