Financial Planning Analyst

Role & responsibilities

Job Description:

Objective:

1. Responsible for commercial finance related MIS reports, like Daily, weekly and monthly updates on volume, NR and OI.
2. Preparation of monthly standardized value chains for all packs at Unit/Channel level
3. Preparation of customer, ASM and SM wise profitability reports
4. Maintenance of price master for both direct and indirect. Review of trade margins and Net pricing model in line with commercial policy / Trade Margin Policy.
5. Timely raising SPAF & ensuring approvals as per COA and then sending price master upload template to MDM team & periodic review for accuracy
6. Upload primary discount schemes of all distributors and ensure discount is captured on invoice. Monthly review of sales register and processing of credit notes for rate differences.
7. Preparation of AR/COL report and sending dunning letters as per policy.
8. Review & follow up for AR/COL of customers and send dunning letter, if AR > 15 days.
9. Preparation of monthly provision workings like BBD, AR & COL.
10. Preparation of monthly balance sheet schedules like AR, GOD, COL & prepaid advertisement schedules.
11. Maintenance of distributor agreements and security cheques.
12. Discount planning and tracking of discount spends on weekly basis.
13. Tracking of distributor incentives and preparations of distributor incentive workings and processing
14. Monthly Physical stock counting and reconciliations

Title: Team Leader- Finance

Function: Finance

Work Location: Mumbai (Corporate Office)

Job Responsibilities:

Minimum Education: Graduate of Commerce / Post Graduate qualification from a reputed Institute /University Specialization in statistics; Certification in Analytics Areas ,Certification in Business Intelligence and Data Mining
Minimum Work Experience:8-12 years of Reporting & Analysis experience, data mining, etc. Should also have strong functional knowledge in Commercial and Operations functions, hands on experience of handling operations and commercial reporting for zone with 2-3 yrs in working capital
Competencies/Skills/Abilities:
Behavioral Competencies

1. Proficient Analytics skills and High Speed of Execution
2. Driving new initiatives /innovation by leveraging external & internal ideas
3. Inquisitive/ability to question /what if analysis oriented
4. Drive collaboration among stake-holders & managing change effectively
5. Highly Collaborative and Result Oriented
   Functional Competencies
6. Data Analytics /Data Mining /Data warehousing
7. Ability to analyze multiple sources of data from multiple systems
8. Strong understanding of Finance and Accounting concepts
9. FMCG and Retail Domain Knowledge
10. Proficiency in MS office (excel Data Mining Techniques / macros)
11. Good understanding of SAP
12. Good understanding of FMCG business and Key functions
13. Knowledge and exposure to Predictive analytics and BIG Data
    Exposure : 1. Proficiency in MS office (excel Data Mining Techniques / macros)
14. Good understanding of SAP
15. Good understanding of FMCG business and Key functions
16. Knowledge and exposure to Predictive analytics and BIG Data
    Travel : 10-20%