Ritesh Ramakant Mhatre

About Candidate

To be a part of an organization which offers me the platform to excel to my
potential and showcase my talent and abilities, thereby attaining, mutual growth for me as
well as the organization.
If hired by you I will be responsible to complete the task within the stipulated time frame and
with utmost confidence.

Skills
● Microsoft applications (Excel, Word, PowerPoint, & others) ● Advanced Excel formulas (pivot table, vlookup, hlookup, Index Match, Sumproduct, Countif, Countifs, sumif, sumifs, averageif, averageifs, if, and, not, mod, offset, sum , average, count, choose, concatenate, counta, month, eomonth, datedif, edate, left, right, trim, round, roundup, rounddown, row, column, etc.) ● Power Query (To link online data with excel sheet) to keep data up to date. ● Google sheet (Dashboard, summary, advanced formulas) ● Typing speed : 30 WPM+ ● Chimpanzee (Tracker)

Location

Education

S
SSC March 2010
Maharashtra State Board
H
HSC March 2012
Maharashtra State Board
B
B.COM march 2018
Madhuri kamraj University

Work & Experience

M
MIS Executive 7th March 2022
illusion reality Studioz Pvt. Ltd

Staffing – As per the requirement of the project and within budget allocated to the project. Pointing out resource availability. For show production we prepare project target vs actual report and timely advise them with new target to delivered project within budget and timeline. Department output report – Preparing weekly department output report. Artist productivity report – the report will compare actual output vs expected output and can highlight the variance between two figures. Planed vs Actual – Check what was planned in last week and what is delivered. This process will reduce the shortfall in weekly delivery and give control on production management. Planning of studio capacity vs Current utilization, which help to do strategic planning in future projects allocation. Company operation file – Consolidate sales, salary, rent, electricity, other Opex and Capex data to analyse the monthly/quarterly/yearly revenue vs expense trend. Comparison of weekly plan vs actual, this process reduces the shortfall in weekly delivery and give control on production management. Advanced level of management review Dashboards/Reports. Studio Staffing, Project accounting, Studio headcount Project Dashboard, etc. It covers project timeline, quantum, cost, Human Resources, and infrastructure requirement for the project. Analysis on project staffing, actual utilization. Analysis on headcount to make sure resources not seat idle, overstaffed. Working closely with the sales head on project delivery planning, scheduling, and project extensions (start to end project management). Setting up new MIS team and Handling HR Department File and company mapping sitting structure And salyer fil

R
Resource Management 5th February 2021 - 28 February 2022
Maya Digital Studio Pvt. Ltd.

As a Production coordinator I am responsible for Meeting client’s Requirement, we need to deliver project according to its deadline, I am responsible for Scheduling and assigning Tasks to the artists. After Looking my good management skills my producer gives me Independent Show to handle after that I used to Handle 2 Shows in Maya Digital Studios. Shows In which I worked: Doctor Tenali Rama, Lambuji Tinguji, Motu Patlu

M
MIS Executive 1st June 2017 - 31st March 2020
Maya Digital Studio Pvt. Ltd.

Staffing – As per the requirement of the project and within budget allocated to the project. Pointing out resource availability. Production requirement – Helping production by automating department related template(Production status summary) this will help production to see episode level summary(Approved, WIP, YTS, YTR etc), tracking artist wise task assigned vs completed summary. For show production we prepare project target vs actual report and timely advise them with new target to delivered project within budget and timeline. Management Reports- ● Project Completion status – as per plan what should be the project completion vs actual completion status and highlight the variance. ● Project Overage – It is important to highlight the overage (additional work) in the project. ● OOP assets/Shots – Sometimes client cancelled assets/shots but before cancelling this how much resource is spend on the assets/shot (This issue we highlight to the management). ● Inhouse/Outhouse -In a Project, percentage of work we are doing inhouse and outhouse. Department output report – Preparing weekly department output report. Artist productivity report – the report will compare actual output vs expected output and can highlight the variance between two figures. Planed vs Actual – Check what was planned in last week and what is delivered. This process will reduce the shortfall in weekly delivery and give control on production management. Planning of studio capacity vs Current utilization, which help to do strategic planning in future projects allocation. Company operation file – Consolidate sales, salary, rent, electricity, other Opex and Capex data to analyse the monthly/quarterly/yearly revenue vs expense trend. Comparison of weekly plan vs actual, this process reduces the shortfall in weekly delivery and give control on production management. Advanced level of management review Dashboards/Reports. Studio Staffing, Project accounting, Studio headcount Project Dashboard, etc. Project Bidding as per scope of work. It covers project timeline, quantum, cost, Human Resources, and infrastructure requirement for the project. Analysis on project staffing, actual utilization. Analysis on headcount to make sure resources not seat idle, overstaffed. Working closely with the sales head on project delivery planning, scheduling, and project extensions (start to end project management). Setting up new MIS team.

Be the first to review “Ritesh Ramakant Mhatre”

Your Rating for this listing