Venkata Ravi Teja Kolasani

At My Current role as Financial Planner

• Provide overall support for period end results and preparation of Forecasts
• Profitability of new products/change in the configuration on the existing products as part of Innovation
• Assist finance director with development of trade/net targets by channels and accounts
• Analyze trade spends and netsales performance vs Plan and forecast
• Perform post audits on promotional spends to optimize events
• Develop and manage models tools and reporting
• Provide control and oversight of Coordinator to ensure accurate claim accrual processes
• Lead performance analysis and reporting for customer/region/function
• Developing AOP for two successful years which is an extensive work involving coordination of various teams
• Develop powerpoint presentation to communicate business results and insights
• Create an inclusive and collaborative environment

At my Previous Role as Commercial Planner

• Calculation of Monthly concentrate price to be circulated to the bottler using NWSP model which is a key activity handled
• Deep analysyis of Foods channel spends on a month on month basis
• Preparation of Innovation PL's for the new products/change in the configuration on the existing products
• Developing of 5 year PL's and actively involved with CDM to close the new deals which came across in foods channel
• Special focus on Advertisement and marketing spends and monthly tracking of it.
• Work on key region or customer incentives to drive business and region performance
• Planned and budgeted accurately to provide business with resources needed to operate smoothly.

• Worked as transition manager for one of the market of Pepsico
• Traveled to Vietnam to get the knowledge transfer for FP&A process
• Transition involved taking the knowledge of all the FP&A activities and prepare DTP's for the same
• Acted as lead for the transition and made sure that all the activities are transitioned and all the DTP's are signed off within the stipulated time.

• Roles: MEC ( Month End Close )
• Preparation and submission of MIS(Monthly Income Statement) and NIS(Net Investment Statement) along with TB schedule's
• Preparation and submission of Consolidation Report of all business entities to top management (Holding and Subsidiary)
• Looking after the Intercompany and reconciliations
• Deep dive of Trail Balance
• Reviewing and submission of Month end validation report to the Finance Manager and presenting the Actuals vs Budget and Actuals vs Forecast to FM's
• Variance Analysis between Budget and Actuals
• Involved in preparation of budget for 2019 on data basis of 2018
• Preparing recast after year end to provide year end adjustments
• Doing 4+8, 6+6, and 9+3 forecast
• Analyze trends in Sales and expenses and prepare dashboards to support higher management to avoid WIP ageing,aged accruals and overdue debt
• Coordinating with the Payables and receivables teams at the month end for GR/IR clearances and recognition of revenues.

• Worked with Tally system on daily basis and involved in finalization of Accounts
• Involved on TDS filing, VAT and Service tax calculations
• Involved in preparation of reports to be given to bank(monthly and quarterly)
• Responsible for entering vouchers and finalization of Accounts
• Preparation of Bank Reconciliation Statements.