Mis Resume

1. CURRICULUM VITAE

AMIT KUMAR SAHU


Present Address: Mobile No: [phone]
H. No: - 2347/5, Rajiv Nagar, Email Id: [email protected]
Gurgaon, Haryana-122001
PROFESSIONA SYNOPSIS _____________________________________________________________________
¨MIS Professional with more than 3 years’ experience specializing in preparing MIS, dashboard, Store attrition
,Cost of Labour attrition, Manager/Team Member turn over, New joining, Exit data and HR budgets(all Brand).
¨Well versed in excel with formula, V-lookup, H-lookup, Conditional Formatting, If, Formulas Nesting, Pivot Table,
Functions, Macro, Data Validation, Data Consolidation, Charts ,Sort & Filter Data etc.
¨Presently designated as Sr. Executive – HR at Devyani International Ltd (Operates F&B brands like Pizza Hut, KFC,
Costa Coffee, Vaango, FRB)
EDUCATIONAL QUALIFICATION ___________________________________________________________
¨F M University (B.Com) from Gopalpur College, Gopalpur, Odisha in 2011
¨C.H.S.E (12th) from Khaira College, Khaira, Odisha in 2008
¨B.S.E. (10th) from Fatepur High School, Fatepur, Odisha in 2006
PROFESSIONAL QUALIFICATION__________________________________________________________
¨One year Post Graduate Diploma in Computer Application from JVVC Institute, Odisha.
¨Six Months Training For “Tally 9.0” Course from SSC institute, Chennai.
¨Five Months Training For “Excel VBA” Course Form Catalyst Financial Analytics Institute, Gurgaon.
PROFICIENCY______________________________________________________________________________
¨Software : Advanced Excel, MS Word, Power Point, Outlook, Macros & VBA
¨Database : MS Access ( Tables, Relationships, Joining, Forms etc.)
¨OS : Windows 8, Windows 7, XP
PROFESSIONAL EXPERIENCE _______________________________________________________________
¨Currently working at Devyani International Ltd. as “Sr. MIS Executive (HR)” from Oct 2014 to till date.
Job Responsibility:-
Preparing Dashboard for all Brands (Yum, Costa Coffee, Vanngo, FRB brands)
Preparing COL report for all brands (i.e. Store & Area Manager wise)
Preparing Left & New Joining Employees report (Weekly & Monthly)
Preparing HR Expenses Report for all brands (Monthly)
Preparing various types of report (i.e. Area Manager, Region & Store wise Report.)
·Managers, Training Manager & Team member turn over
·Store wise turn over
1 | P a g e

2. ·Male-Female & Full timer-Part timer ratio
·Store wise Manager/Team member ratio
Handling vendor management
·Invoice’s process & Payment sent
·Maintain vendor tracker
·Co-ordination with regional HR, vendors and finance dept.
Working on HRIS, fetching data from HRIS & analyzing. Creating reports with help of MS-Excel.
Maintaining employee databases of all brands
Preparing reports as per the requirement or demands from top management.
Preparing various types reports for different brands
Maintaining Matrix / CCA report
Plan, organize, and conduct induction program for the new joiner.
Complete the joining formalities i.e. collect the required documents, creation of emp. id for attendance.
Use worksheet formulas through VBA code and using Excel-based VBA to automate the reports
¨1 years of experience in Monark India LTD (Previously MONARK FURNITURE LTD.) as “MIS Executive” from
Oct 2013 to Oct 2014.
Job Responsibility:-
Making MIS Report, HO Report ,Productivity, Expenses Report (Daily, Weekly & Monthly), FTD & MTD
Report, Tower Wise, Site Issue Report, Billing Report, Attendance & Manpower Report
Analysis the Channel Sales Data, summer interns Data, Preparing Forms & Format for Respect Dept. &
Project Sites.
¨1.8 years of experience in Maruti Suzuki India under Tirupati Associate as “MIS Executive” from January,
2012 To September, 2013.
Job Responsibility:-
Making Daily Report, Vendor Lin Rejection, STK & PPM Report, Vendor item Rejection Summary,
DC/NDC updating, Defect, QPCR Report, SRV Receipt & Department code updating, CARV, MIS-P &
PCS entry in Software, Responsible for Dept. Shift roster plan
HOBBIES___________________________________________________________________________________
¨Listening music
¨Watching movies
¨Surfing internet
PERSONAL DETAILS_______________________________________________________________________
¨Languages known : English, Hindi and Oriya
¨Date of Birth : 1st September, 1990
¨Sex : Male
¨Marital Status : Single

Date: [AMIT KUMAR SAHU]
2 | P a g e