SAGAR MHATRE
BSC (Mathematics) || PMO || Data Analyst
Key Expertise
8 Years’ experience as PMO in Operations with proven ability to develop and
implement BI solutions with strong data analysis ability.
Experience Summary
Assist the PMO processes, Time Tracking, Task Tracking, Resource Management,
Utilization, Margins, Timesheets, Invoicing and billing of North America and
Global Projects.
Good understanding of DAX, Data modeling, Data visualization and presentation
to cross functional teams.
SPOC for customer for Invoices and Purchase Order
Experience in stakeholder management, data gathering from cross functional
teams.
Playing Business development role to help pipeline revenue
Experience in developing Proposals, RFQ
Managing entire operations data on SharePoint
Building reports and dashboards to provide crucial performance data to support
the organization to achieve key strategic goal
Experience in creating Dashboard using Microsoft Power BI
Experience on Power BI (Desktop and Service) along with DAX.
Worked on the Power BI reports & dashboards
Expertise in writing complex DAX functions in Power BI and Power Pivot
Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
Key Skills
Project Management
Data Analysis
Well versed in Ms office tools Excel (Pivot, VLOOKUP, Charts), PowerPoint, Visio
BI Reporting Tool: MS Power BI, DAX
DataBase: MS Access, MySQL
Tools/Methodology: MS Project, Sharepoint
Work Summary
L&T Technology Services, Bangalore, India (Feb 2011 to Till Date, 7 Years)
Page 1 of 1
SAGAR MHATRE
BSC (Mathematics) || PMO || Data Analyst
Project Operations Management
Monitoring of the Project Budget, Actual Cost and Profitability
Revenue Forecast
Identification of risks and bottle-necks faced by the project
Raising project Invoices and Accruals
Tracking of Project Timesheet Compliance
Tracking and managing project cost, schedule, effort
PBIT and utilization management.
Preparing proposal, Bid management, Estimations, RFQ
Responsible to take initiative to achieve QoQ growth of the account, connecting
with Global Sales Manager (North America, Japan, Europe)
End to End Resource Management (onboarding/off boarding, tracking,
reporting, roll off visibility, Revenue Leakage)
Maintaining a resource skill set database
Identifying and coordinating training requirements for internal and client
resources
Driving recruitment funnel with resource coordinates and delivery along with
onsite sales team
Connected directly with onsite and offshore talent acquision team
Managing resource allocation and de-allocation for all projects of the global
account.
Coordination with Immigration Team for H1B, L1 onsite deployment.
Operations Data Analyst using Power BI
Responsible for maintaining project operational data on Share point and creating
live dashboards using Power BI.
Publishing, sharing and exploring revenue, resource, utilization data using Share
Point and Power BI
Developed Power BI model used for financial reporting of P & L and Headcount.
Created web pages on share point to view the developed reports
Worked on On-Premises Data Gateway to refresh the data sources/creating a live
connection scheduling the reports and also implementing Row Level based
security in Power Bi
Responsible for building reports and dashboards to provide crucial performance
data to support the organization to achieve key strategic goal
To assist project managers to consolidate multiple data source into single
dashboard
project portfolio reporting and analysis, annual resource performance analysis
and tools management
Page 2 of 2
SAGAR MHATRE
BSC (Mathematics) || PMO || Data Analyst
Personal Details
Name : Sagar Mhatre
Education : B.sc in mathematics from M.S. University of Baroda
Date of Birth : 11th June 1987
Mob : 9998002074, 8320514972
Email :
[email protected],
[email protected] Marital status : Male, Married
Present City : Bangalore
Passport No : K6027351
Passport Validity: 26-06-2022
Notice Period : 3 Months
LinkedIn URL : www.linkedin.com/in/sagar-mhatre-1154913a
I hereby declare that above mentioned information is true to the best of my knowledge and
belief
Page 3 of 3
