Dinesh Gupta, Manager MIS and Budgetary Control

Dinesh Gupta

Manager MIS and Budgetary Control

Lodha Group of companies

Location
India - Mumbai
Education
Master's degree, Finance
Experience
19 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :19 years, 1 Months

Manager MIS and Budgetary Control at Lodha Group of companies
  • India
  • My current job since September 2014

Job profile - Responsibilities Cost budgeting, reporting, Controlling and analysis.

•Preparing Monthly Corporate Dept. MIS on Month on Month and YTD basis.
•Analysis and ensuring cost is going in correct Cost Centre, WBS, GL according to nature of expenditure and period.
•Preparing Weekly, Monthly and Forecasting Cash flow of Lodha Group which is around 3000 Cr.
•Preparation of Annual Operating Plans (AOP) for Sales, Marketing, HR, IT and Admin Cost both Capex and Opex.
•Budgetary Control of Sales, Marketing, IT, HR and Admin Costs.
•Providing Decision Support on Commercial Contract to various Vendors.
•Creation of New WBS (Work Break down Structure) and budget uploading and releasing in SAP.
•Variance analysis, Actual v/s AOP of Cost on Month on Month and YTD basis.
•Preparing of Annual Sales Plan, Demand and Collection Tracking Project wise/Segment Sales.
•Preparing Monthly Board, MD, CFO, Dashboard.
•Working Cost Saving Project initiative
•Clarifying and Closing Audit query during Financial Audit of the company

Cost Analyst at Areva Solar India Pvt Ltd
  • India
  • October 2013 to June 2014

Reason of leaving early-Closing Down of Solar Business)

Job profile - Responsibilities Cost budgeting, reporting, Controlling and analysis.

•Reporting Project Cost and Corporate MIS of Areva Solar India.
•Controlling of Cost w.r.t. to Budget
•Analysis and ensuring cost is going in correct CC, GL according to nature of expenditure and period
•Preparation of Annual and Quarterly project and function budget.
•Prepare monthly MIS and Present to Management on time on Month on Month and YTD basis.
•Variance analysis, Actual v/s AOP of Cost on Month on Month and YTD basis
•SAP Control for costs, ensure proper controls for PR / PO release as per guideline
•Clarifying and Closing Audit query during Financial Audit of the company

Deputy Manager at Vodafone India Ltd
  • India
  • December 2012 to August 2013

Job profile - Responsibilities Cost budgeting, reporting and analysis.
•Reporting Cost MIS around Rs1000 crore of 23 Circles and Corporate Customer Service (CS) Cost MIS of Vodafone India.
•Cost Benchmarking analysis of All 23 Circles of india
•Analysis and ensuring cost is going in correct CC, GL according to nature of expenditure and period
•Worked on Cost Reduction project OE (Organisational Effectiveness)
•Variance analysis, Actual v/s AOP of Cost on Month on Month and YTD basis
•Reporting various customer analytics like by segments, circles etc.
•Detailed Budgeting and Forecasting 5+7, 9+15, DB Guidance
•Feedback and Follow up with Corp finance, Regional Head of Finance and circles
•Circle CS and Corporate reviews on cost
•Ensuring Standardization of Process and Method of costing
•Tracking Actual Cost in Hyperion and SAP

at Tata communications Ltd
  • India
  • March 2008 to December 2012

Job profile - Responsibilities Revenue and Cost reporting and analysis
•Reporting Global revenue and Cost MIS of Global Network Services (GNS) LOB.
•Variance analysis, Actual v/s AOP of Cost and Revenue on Month on Month and YTD basis.
•SAP Control for costs, ensure proper controls for PR / PO release as per guidelines
•Analysis of Top revenue Contributor customer wise and product wise.
•Reporting various customer analytics like by segments, region, services, credit notes, etc,
•Capex Tracking and Setting up of process & guidelines.
•Analysis and ensuring cost is going in correct CC, GL according to nature of expenditure and period
•Reporting and Forecasting of Capex, Opex and Revenue Month on Month and YTD basis,
•Preparation and Monitoring of Capex and Opex AOP.
•Preparing and analyzing Product Profit &Loss account


Job profile -Responsibilities Capex budgeting and controlling

•Reporting Global Capex MIS with respect to LOB/SSU wise of around 500 million USD with over 1500 projects.
•Planning, Budgeting and Controlling for entire Tata communications capex of more than
•US$ 500 mn.
•Forecasting of capex cash out-flow, depreciation, gross block and net block of fixed assets.
•Investigating and Analyzing monthly capital expenses and providing variance against AOP
•Preparing financial models of Capex approved spent product wise.
•To ensure proper response and closure of audit points

•Special Project : Automization of Capital Expenditure Requisition Process through web based portal

•Transformed manual process of CER approval into real time web based workflow system
•I was part of the who executed entire life cycle of the project starting from project
conceptualization, planning, implementation, testing, deployment and training end users
•Integrated manual processes and established uniform process for Capex approvals
•Reduced turnaround time from 2 days to 6 hours.
•Improved capex reporting and tracking accuracy from 80% to 95%.


Achievements:
•First Ranker MBA Finance Specialistion in Class.
•Received appreciation letter award from fixed assets team Tata communication for Stream lining the capitalization process of fixed Assets.
•Received Award for NLD 6 Project for outstanding contribution for successful implementation for FY.

Finance Functional Consultant at World it consulting pvt Ltd
  • India
  • September 2007 to January 2008

Corporate Performance Management)

Senior Consultant at Savoir Faire Management Consultancy Pvt. Ltd
  • India
  • May 2006 to August 2007

Major Contributions
•Have successfully completed projects like;
•Project cost management at Zoom Developers.
•Worked as Cost Auditor for Bridge construction Project.
•Find the reason of cost and time overrun
•Carry out Variance analysis.
•Designed cost control strategies.
•Given inputs on Budgeting.
•.
•Cost Information System for pricing at Blue Star.
•Developed an Excel based system for reporting of product wise cost and conceptualized resource drivers for a Resource based product costing.
•Developing Cost information system through Finance and Costing Module in BAAN.
•Improving Bottom line improvement by guiding them with tools of 5S.
•Developed Material Accounting system and aligned physical material through through BAAN.
•Performed Customer Account Profitability analysis
•Worked on Activity Based Costing System for overhead allocation.
•Prepared Bill of Material Updation Policy
•Prepared value stream map for product

• Gurudev co op credit society Kurla Mumbai

Assistant accountant
  • December 2002 to March 2004

Education

Master's degree, Finance
  • at Vivekananda Education Society Institute of Management Studies and Research
  • January 2006

Full Time

Bachelor's degree, Accounting And Audit
  • at S.K Somaiya College
  • March 2002

Specialties & Skills