MAYANK PRAKASH

• Prepare Annual Operating Plans (Budgets) including Capital Budgets and quarterly business performance
• Provide detailed monthly MIS to help monitor all aspects of business performance [e.g., actual versus budget/PY, product wise profitability analysis, working capital analysis.
• cash flow and working capital management, Own, oversee and manage cash flow planning of our organization and ensure sufficient funding
• Statutory compliance, system and process improvement, building a high performing finance team .
• Strengthening controls and improving efficiencies through automation, Maintain appropriate internal controls and financial procedures
• To manage all Financial Audits in the company – Statutory Audit, Internal Audit and Taxation Audit. Provide Audited Annual Financial Reports in accordance with local GAAP and the laws of the land
• Responsible to our Board of Directors for all financial and planning matters
• Establish organization wide objectives, policies, procedures, programs & processes that which will assure long-term sound financial health of the organization
• As a Key member of the Executive Management team, partnering with business to leverage finance as pillar of growth
• Create and assist in formulation of organization’s direction & supporting financial initiatives
• System and process improvement, strengthening controls and improving efficiencies through automation and building a high performing finance team

• Managing 2000+ stores by effectively building financial perspective at the front end of the business by supporting operations in all its endeavor's, exercising controls, defining and implementing policies and process and adherence
• Evaluation of store profitability and non-profitable stores and necessary actionable
• Tracking of stores planned for opening vs actual, tracking of delays, dead rent etc. for new stores and renovations
• Ensuring adherence for all account receivables and payables w.r.t retail stores
• New business alliances, commercial negotiations and agreement sign off
• Business risk analysis and sharing recommendations with management on periodic basis like Franchisee deposit vs stock, LL SD deposited vs books entry for company owned stores
• Evaluation of the capex/IRR and approval of the new store and renovations
• Negotiation of the rates with the vendors and ensuring the L1 are awarded the contracts. Financial evaluation of the contractors to ensure best deals for the business
• Monthly Provision for expense and Review of P&L and variance analysis
• Driving automations for process improvement and improving productivity
• Ensure to motivate the team by giving proper guidance and ensure one team approach

• Managing 1200+ stores by giving resolution to store Issues and ensuring commercial control over stores through process adherence
• Facilitation & co-ordination for smooth opening of New stores from commercial and compliance perspective
• Monthly Incentive validation and payout for stores amounting to Rs.1cr plus
• Monthly Provision for expenses, inter format entries, Review of P&L and variance analysis
• Ensuring all entries are passed Books of accounts before the closure of SAP and also ensuring each store
• P&L represent fair and accurate financial position
• Processing of Marketing PO's and accounting of SOH income.
• Detailed analysis of Store wise Sales and work with operation team to ensure AOP is met.
• Process modulation and close monitoring for mandatory adherence
• Cost control measures for optimization store opex cost
• Work with operation team on loss making stores and ensure they are either turned around or closed
• Build a strong team in Operation Commercial to reduce stress levels
• Ensure to motivate the team by giving proper guidance and ensure one team approach Interaction with IT team for automation of reports and processes

Role : Head-Group CRM Finance and Lead-Corporate FPNA

• Set up systems for “campaign performance tracking” and “Promotion effectiveness” reporting
• Preparation of regular Dashboards having analysis and summary of campaign performance for presentation to the business users
• Preparation of “Cost Benefit Analysis” of various campaigns proposed.
• Preparation of the Group CRM budgets in discussion with the business finance and marketing heads
• Preparation and presenting of Monthly budget Vs Actual performance for respective companies of Landmark Group
• Prepared campaign execution process for all formats of Landmark group to standardize the business processes
• Ensuring and coordinating in internal audits
• Vendor agreements and commercial negotiations
• Financial Planning and Analysis
• Monthly P& L at regional, division and pan India level for Lifestyle, Home center and Distribution channel Month wise variance analysis of expenses with respect to budget, forecast and previous year in coordination regional team
• Consolidation of P & L for all the landmark Group companies for management reporting
• Monthly forecasting and planning of financials for lifestyle and Home Centre
• Preparing 5-year business Plan for lifestyle and Home Centre
• Industry tracking and preparing competition benchmark
• Controlling and tracking of marketing spends, IT spends and Capex for Group
• Preparation of new store profitability report, business model, paybacks and performance analytics
• Driving transformational improvement across business and automation process for regular MIS
• Identify and drive cost efficiency projects along with the territory commercial and operations team

Role : Business planning & analysis DSS (Decision support)

• DTH
• Analysis on ZRC (zero recharge customers), Suspension movement and churn
• Acquisition quality analysis of new acquisition and winback of suspended customers
• Monitoring of stock movement from active partner & recovery of stock from inactive partner within due timeline along with monitoring full and final settlement of inactive partners
• Validation and approval of distributor claims
• Pre-& Post launch of market products related to DTH, Airtel Money & Airtel DATA
• Verification and authentication of monthly & quarterly sales target/plans
• Driving DTH revenue in close co-ordination with sales
• Help in developing and maintaining relevant methods and tools/ frameworks to be used in effective analysis, project execution and follow up
• DATA
• Site wise & usage wise analysis of data users month on month
• Analysis of 2G & 3G data (own base, acquisition and devices), 3G ICR analysis, data infra development, dongle acquisition
• Product approvals and post launch analysis
• Developing adhoc business analysis and recommendations to top management on strategic decisions and planned future action and initiatives
• Analysis of low revenue sites for revenue enhancement, closure in case of non-performance & also exploring new opportunities for revenue enhancement
• Driving data revenue in co-ordination with sales and marketing for network capex productivity enhancement Data usage, users and Revenue projection
• Identification of revenue opportunities on 2G sites

AIRTEL MONEY

• U & R of airtel money

Analysis on airtel money cash-in, spending (OTC/remote), power/super wallets etc

Helping business in implementing new products and decision support through data analysis and business insight

Role : Business planning & analysis for WEB, ASSAM & NESA

• Budgeting, forecasting & reporting for mobility business in form of P & L & key business indicators Design, development & delivery of management reports to corporate & circle leadership team in conformance with the prescribed reporting standards, timelines &output quality standards Actual/forecast Vs budget root cause analysis for EBIDTA & PBT variance
• Preparation and analysis of budget, AOP and implementing cost control measures to reduce variance between budget and actual management cost.
• Process automation with quality control to eliminate/minimize manual intervention on repetitive activities

Role: MIS Reporting & Business support for KOL, WEB, ASSAM & NESA

• Taking cost optimization initiatives through various analysis & benchmarking
• Opex circle level business approvals
• SAP GL scrutiny for booking of revenue, expenses, provisions, reversals
• Passing necessary rectification entries in ERP to ensure accounting compliance & clean audit Preparing statutory audit schedules for kol, web, assam & nesa.

Role :MIS Reporting & Business support- KOL

• From Oct 08- Oct 11
• Prepared monthly flash reporting (P &L) to higher managerial personnel in predefined format & timelines
• Preparation of detailed MIS for various Direct costs & Indirect costs
• Handled Cost Review in monthly closing to in line with Flash & Forecast with MAPA & Trial.
• SAP GL scrutiny for booking of revenue, expenses, provisions, reversals
• Apportionment of common cost to BU/products for reporting BU/Product profitability
• Establishing budgetary & Cost control measures through AOP Vs Actual analysis
• Trial Balance review for all expenses heads, current assets & current liabilities
• Liaison with circles to obtain provision inputs, showing actual against provision, comparison, accounting & reversals
• Passing necessary rectification entries in ERP to ensure accounting compliance & clean audit