Alok Agrawal
Project Lead-Honeywell | IIM | NIT Gold Medalist | PDP- IIM A | National Finalist TIE Entrepreneurship Challenge 2010
Alok Agrawal is a highly accomplished Project Lead at Honeywell, with expertise in financial analysis, business modeling, project management, and business analysis. He has a strong entrepreneurial mindset and a deep understanding of operational, marketing, and financial aspects of business
Show more
13.7
Years of Experience
Education
indian institute of management shillong, nit bhopal maulana azad national institute of technology bhopal
Companies
honeywell, ford, etoe transportation infrastructure private limited, lt, indian institute of management shillong, indian institute of management shillong, hindustan petroleum corporation limited, national aluminium corporation
Reach out to Alok Agrawal via Email, InMail and SMS drip
by installing Chrome extension
Alok's contact details
Email (Verified)
binXXXXXXXXXXXXXXXXXXXom
Mobile Number
+91XXXXXXXX53
Experience
2016 - Present
honeywell
Project Lead
 Streamline Materials procurement process by developing single database using MPN triggering saving through IOS reductions for E&ES EMEA regions  Lead team of associates and analysts to set Standard costing estimation process for Integrated supply chain Finance functions in Honeywell  Lead team of associates and analysts to set IOS Accrual process for Integrated supply chain Finance E&ES EMEA Region using Access Data Base and Excel  Lead team of associates and analysts to develop MOQ model to improve procurement decision making for Integrate supply chain Finance Honeywell  Help in development of IOS Salvage process to reduce IOS hit by around a Millions compare to AOP  Lead team of associates and analysts to develop and streamline Capex process for various supply chain projects as per Global standards to track spending  Lead team to collaborate with various project team to close CIPs and ensuring decrease of CIP balance for EMEA region by 25%  Helping Team in doing ISC projects analysis using various capital budgeting tools to check its efficacy and return for the Honeywell
2014 - 2016
ford
Financial Analyst
 Lead a team of associates and analysts to Prepare and develop Cost exposures Forecast for Asia pacific Emerging Market, Malaysia and Ford Trading Company every month to hedge different cost currencies  Lead a team to develop Robust Cash Flow Models using inputs from FVA reports, accounting team reports and Forecast models to explain the physicals behind cash flow variances. For the first time actual inputs are used from FVA reports and accounting team reports to explain the variances. Prior to this all the explanations are just based on forecast which in turn was creating lot of open ended questions.  Build and developed new PF3 model for Asia Pacific so as to split actuals into EP Material costs and Uplifts  Build and developed PF1 model for Malaysia so as to calculate variances at Series Level  Ensure timely delivery of profit forecast for Asia Pacific region as per different Ford profit system and requirements of different regional team  Responsible for doing variance analysis for Asia pacific Emerging Market, Malaysia and Ford Trading company  Ensure timely submission of Budget and Business plan for Asia Pacific region with timely resolution of queries pertaining to these submissions  Preparation and development of Revenue, cost and net exposures forecast of Asia pacific region to hedge different functional currencies as risk management diversification strategy  Preparation and development of VAR analysis for entire Asia Pacific region using net exposures for the entire region  Doing detailed cash flow, sensitivity and scenario analysis for Asia Pacific region using available information and applicable metrics  Design and development for Budgeting, Business plan, Cash Flow & profit Model using advanced Excel & financial Skills
2012 - 2014
etoe transportation infrastructure private limited
Young Vice President
 Responsible for financial planning and analysis for entire EtoE and help in streamlining the entire Operation through budgeting and variance analysis.  Helping the project department in maintaining the cost to complete file in daily basis   Played Key role in developing relationship with Key clients like ACC, Adani, GVK, L & T in last 1 year  Design and develop master data base for all important clients for marketing and research purpose  Prepared detail and exhaustive business plan for Etoe rail with special focus on business expansion and development  Builds market position by locating, developing, defining, negotiating, and closing business relationships  Screens potential business deals by analysing market strategies, deal requirements, potential, and financials; evaluating options; resolving internal priorities etc.  Actively involved in formulating business / growth / diversification strategy of the companies
2011 - 2011
lt
Summer Intern
1) Prepare an Sectoral research report on Power sector with special emphasis on Tariff Modelling, State attractiveness and Future power and Demand. 2) Develop a Financial Model to find out the value of a company by using DCFF. 3) Develop an Eco- Friendly strategic opportunity for L&T to explore.
2010 - 2012
indian institute of management shillong
Office Bearer, Finance Club
2010 - 2012
indian institute of management shillong
Student
A great Learning Experience in the field of Finace, Marketing & Operation.
2008 - 2010
hindustan petroleum corporation limited
Operation Officer, Production and Planning
Designed Automatic on - off switch to decrease energy consumption in the plant and Pneumatic Water Leveler to increase operational efficiency. Selected in top 10% officers in 2008 batch for showing exemplary performance and attended MDP at IIM A
2007 - 2007
national aluminium corporation
Engineering Internship
Experience
40 Skills
Accounting
analytics
Budgeting
Business Analysis
business analysis
Business Strategy
Data Analysis
Decision Making
Design
Entrepreneurship
Equity Derivatives
Equity Research
Equity Trading
Equity Valuation
Excel
finance
Financial Accounting
Financial Analysis
financial analysis
Financial Modeling
Financial Planning
Financial Statement Analysis
Financial Variance Analysis
Forecasting
Green Belt
iOS
marketing
Planning Budgeting & Forecasting
procurement
Project Finance
Project Management
Project Management
Research
Research Scientist
Risk Management
Strategy
strategy
Team Management
Trading
Valuation
Education
2010 - 2012
indian institute of management shillong
PGDM
Finance
2004 - 2008
nit bhopal maulana azad national institute of technology bhopal
B.E
Mechanical Engineering
