Team Member - IB Finance

Location: Sun House, Mumbai

Job Description:

Financial Reporting and consolidation of Financial Statements

1. Calculation of Physician Sample, Trade Offer, Non Moving Promotional Inputs (NMI) , Training expenses for preparation of monthly profitability.
2. Consolidation and preparation of discount summary report at division level.
3. Preparing therapy wise consolidated discount summary report for SPIL and SPLL for current financial year and also previous financial year so that comparison can be developed for the last year and current year.
4. Convert Business data into Corporate Format for Global Consolidation.
5. Convert Business data for various Analytical reports.
6. Updating of Budget YTD & Last year figures, division wise of SPLL.

Financial Planning and Budgeting

1. Downloading of India Business expenses dump from SAP HANA & preparing GL head wise summary for updating in Profitability statements of SPIL and SPLL.
2. To review the expenses General Ledger on monthly basis to check whether correct entries are passed in system.
3. Extracting breakage and expiry data from SAP HANA and consolidating the same to prepare Monthly Breakage & Expiry report.
4. Preparing of expenses dump for circulating to all SPIL & SPLL divisions.

Capex Report and WBS

1. Initiating Asset Request on GCS for raising capex. Also ensuring approvals for all the required assets.
2. Preparation of capex report to submit to business finance team.
3. Creation of WBS and Allocation of WBS amount in SAP HANA.

Budgeting

1. Updating and checking of HO and SBU salary
2. Preparing monthly phasing summary budget expense format file to circulate to divisional heads.
3. Consolidating month wise budget phasing files received from divisions & ensuring all controls are in place.
4. Reviewing the monthly phasing data at division level & business level as required in budget deck.

Automation of Reporting Systems

1. Uploading of Annual Budget Division wise monthly phasing of Revenue Expense and Overhead Template in SPMS System.
2. Uploading template on monthly basis, expenses, revenue & overheads templates at division level, Support functions in SPMS System.

Support to Support Function Team & Business Finance Team.

1. Providing support to Business Support team to prepare the Budget.
2. Preparation & circulation of support functions details and track variances against budget.