Ravi Kumar P

• Leading the month-end activities, including inter-branch and intercompany account reconciliations, Recurring, Accrual, Amortization Journal entries, Review of the Trial balances, PL and Balance sheet to confirm the completeness of the Journal entries.
• Reconciliation between the interest receivables and interest amounts actually received, thereby enabling the month-end interest accruals across different loan portfolios, i.e., to ensure the completeness and accuracy of interest incomes recorded after considering the exception for NPAs and stressed assets.
• Preparation of the monthly MIS report, graphical and dashboard formats using Power BI, along with the statement of profitability, cash flow, and balance sheet, finalized loan disbursement reports, collections reports, interest accrual reports, loan classification reports, gross NPA, and net NPA reports.
• Preparing and monitoring the yearly and quarterly forecasts for the long-term financial planning.
• Preparing and rolling out the monthly budgets derived from the forecasts, past data, and expected trends, activity-based, and flexible budgets for the most accurate resource allocation and assignment.
• Analyzing the variances between the budgeted plan and actuals for each line item of the financial statements PL, Interest Incomes, Processing fee, Documentation fees , Insurance fees, Guarantee fees, direct Interest costs, and Opex analysis, to identify and take steps regarding Under run Incomes and overrun costs, while providing actionable insights at the activity level and reporting the adverse deviations. .
• Identifying the scope for automating the processes, report generation, and their input to ERP through API keys that help in eliminating errors and omissions.
• Preparing the net interest margin reports, portfolio-wise that helps in decision making with respect to the minimum Rate of Interest on the New loans.

1. Preparation of the Forecasts with emphasis on the Revenue Forecast using the Bottom-up financial statements model and using the regression statistical techniques for most scientific forecast, setting the Budgets using the ABB (Activity Based Budgeting) concepts on Quarterly basis and rolling over them on monthly basis with estimated revenue and cost drivers. Budgetary variance analysis in the Opex area and identifying the reasons for the adverse variances and reporting the same to the respective functional Heads for proper action.

2. Preparation of Monthly MIS reports, along with the Subscribers count and Content cost analysis, ROI and per subscriber cost and revenue analysis for different territories, Calculating the subscribers churn rate, Subscriber category wise profitability analysis.

3. Managing the Subscription Revenue of the OTT platform, analyzing the plan wise subscription each day to ensure that all payments are received duly from the payment aggregators and Payment gateways through reconciliation with the dump receipts.

4. Capital Budgeting for Investment in the new technology platforms, Cricket World Cup and IPL streaming rights using the MIRR, NPV concepts and substantiating the decisions, Scenario simulations using the Goal Seek and Scenario Analysis tools in MS Excel.

5. Month end closures processes, specifically Content cost accruals, Subscription Revenue Accruals and recognition of amount relating to unserved period to Unearned revenues, MGP agreements accruals, License fee amortizations and other provisions for expenses.

6. Preparing the reports to determine the Maximum ‘Minimum guarantee amount’’ and ‘’Per subscriber’’ cost that is feasible, for discussion on streaming licensing agreements with the ICC and BCCI, and other sporting events with the Star sports Networks.

7. Foreign Currency Hedging to protect against the foreign depreciating currencies against the USD.

8. Preparing the Going Concern analysis reports for the Auditors, and co ordinating the audit process through thorough explanation and establishing the audit trials through previously established processes.

1. Preparation of the Accounting Journal entries, Adjusting entries, Month end closings, reconciliations, Recurring entries like prepaid expenses, amortizations of the intangible assets, Borrowing cost capitalizations, Forex differences adjustment.

2. Planning and Risk assessment procedures of the audit includes financial analysis, Ratio analysis, Going Concern analysis, product wise, Geographical area wise analysis, Capital Structure analysis, Credit Concentration, Customer and Vendor Concentration analysis to identify the significant unusual areas or risks.

3. Preparation of the Standalone and Consolidated Financial statements and notes forming part.

4. Preparation of the financial forecasts and planning reports, including the budgeting, and variance analysis and carrying out a detailed line by line analysis of the profit and Loss and Balance sheet items for providing the actionable insights.

5. Reviewing the Financial reporting processes as per the SOX and providing the process improvements.