Sr. Team Member - FP&A
Division
Finance
Department
Commercial Finance
Sub Department 1
NA Finance
Job Purpose
Enable North America BU team in timely Management Reporting & effectively partner with B2B Business, additionally handle competition benchmarking, CMO contracts for North America, provide various cuts for revenue and board requirements, Invagen opex analysis as Invagen controllership is re-assigned to India.
Key Accountabilities (1/4)
1) Support in Month end closing activities & preparation of Consolidated BU P&L
- Consolidate Sales across entities to present overview of Revenue & Margins for North America Business
- Liaise with cross functional & corporate teams to reconcile Sales numbers
- Undertake Price Volume Variance Analysis & identify exceptional performance products
- Undertake Quarterly Cost Analysis of Standard Costing files to identify outliers
- Update Masters in Power BI & support in automation activities
- Undertake Analysis & Calculation of B2B spends, Freight & Inventory for timely closure of P&L
- Submission of Profit Share Payout & Other Expense Provisions
- Analysing Invagen opex and analysis of spends, its variance vs budget
Key Accountabilities (2/4)
2) Prepare annual budget plant exercise for North America BU
- Prepare template for Budgeting exercise to share with Business teams
- Variance analysis vs previous years to understand the outliers and investments
- Analysis of revenue and EBITDA for budgeting, building bridges for different management views
- Competition benchmark data for various companies
Key Accountabilities (3/4)
3) Active business partnering to achieve performance targets
- Roll out Sales Flash for B2B & Pvt Label Business
- Undertake Ageing Analysis of receivables outstanding to ensure compliance as per DOA
- Prepare DSO Quarterly Comparative statements for Corporate
- Prepare Pvt Label deck monthly to discuss with Marketing Head
- Monthly compute FTS & Other Penalties in Pvt Label
- Review CMO contracts for North America finance under development and post development projects
Key Accountabilities (4/4)
4) Support North America team in complying with internal and external controls to ensure smooth and transparent operations
- Ensure monthly tracking of Debit Note & Credit Notes
- Monitor Profit Share Receivable statements from partners are received timely & Validate the same
- Support in payment mechanism of foreign payments, checking such DN/ CNs are in adherence to contractual terms
- Identifying negative, low GM / profit product, initiating conversation with business
- Preparation of product P&L for key products to see end to end profitability
- Ensure compliance of Payment Terms & Prices as per Agreement Tracker
Major Challenges
- High Dependency on SAP requires IT support for resolving data & access queries.
- Co-ordination with cross functionalâ Corporate, FSS, BU. Ensuring establishment of a single communication base with different teams helps alignment of information
Key Interactions
Internal :
- B2B team â BD team, SCM team, NA Finance teams
- Corporate teams â FP&A
Dimensions
- Support $900mn of North America business for margin improvement and cost controls
- Ensure proper accounting of revenue & expenses as per specified timelines.
- Ensure the DSO for B2B stays within guidance limits
Key Decisions
Decisions :
- Time Management to ensure closure of month end activities accurately & timely.
Recommendations :
- Automation Initiatives
- Profit Share Receivable/ Payable Statements
Comments:
The incumbent would be actively interacting with cross functional teams to provide inputs on Queries raised & in timely closure of P&L, month end activities.Listed above are just a few activities, the incumbent would be expected to work on many adhoc projects and provide necessary inputs to enable leadership in efficient decision making
Education Qualification
Qualified Chartered Accountant / MBA â Finance
Relevant Work Experience
4 - 8 years of work experience in business/ corporate finance in Pharma/FMCG companies. Prior experience in a cross-functional (multi-geographic) environment will be added advantage