Pranshoo Jaiswal
Assistant Manager at Cube Highways and Transportation Assets Advisors Pvt. Ltd- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SQL
365 Data ScienceOct, 2022- Oct, 2024 -
Certificate of completion - Statistics
365 Data ScienceJul, 2022- Oct, 2024 -
Certificate of completion - Introduction to Excel
365 Data ScienceJun, 2022- Oct, 2024 -
Certificate of completion - Introduction to Data and Data Science
365 Data ScienceApr, 2022- Oct, 2024
Experience
-
Cube Highways and Transportation Assets Advisors Pvt. Ltd
-
India
-
Truck Transportation
-
1 - 100 Employee
-
Assistant Manager
-
Feb 2018 - Present
DATA ANALYSIS - Analysis including high volume data (18+ projects) such as traffic, revenue, expense, and other critical heads. Extraction of data from NAV & SAP and further analysis of these data. Executed risk analysis and identified risk mitigation strategies. Automated dashboard preparation, data visualization and analytics for monitoring KPIs (using Power Bi/Tableau) and regular reporting to CEO, COO, CFO and other top management stakeholders, finding key anomaly and derive strategies to solve issues. Supported leadership team with reporting, analysis, and business presentation to inform divisional strategies. Creating vendor, item and service master list, vendor performance tracking. Analysing of Procurement KPI (most procured item, YOY/MOM analysis of item and its cost and further derive strategies. COST PLANNING - Preparation of Annual Budget for 18+ project (4614 million), OPEX and CAPEX. Monitoring of Budget for O&M activities through data analysis and developed cost optimization strategies, achieved to control expense by 20%,35% and 22% from Budgeted in FY 20, FY 21 and FY 22 respectively. Prepared costing for O&M activities for acquiring new projects, part of acquisition team and helped in acquiring 6+ projects. PROJECT MANAGEMENT - Project Management of 18+ assets and strategy development through analysis of data. Analysed key aspects of business to evaluate factors driving results and summarized into presentation, dashboard. Leading execution of large-scale projects (150 -200 Cr) from start to end involving planning, vendor identification/finalization, contract management, procurement, resource planning and ensuring timely execution of project and further monitoring its efficiency. Show less
-
-
Education
-
Indian Institute of Management Kashipur
Master of Business Administration - MBA -
Galgotias University
Bachelor's degree, Mechanical Engineering