Team Lead - Finance

Job Description:

Position : Team Leader Finance
Vertical : Finance
Job Function /Sub Function : Commercial Finance
Job Objective : Preparing MIS to help management in decision making. Maintenance of pricing and value chains
Reporting : Commercial Finance Manager GT TN
Supervises : None

Job Responsibilities:

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

Job Requirement

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:3-4 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

Geographical scope: Bangalore

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
1.    Data Analytics /Data Mining /Data warehousing 
2.   Ability to analyze multiple sources of data from multiple systems
3.   Strong understanding of Finance and Accounting concepts
4.   FMCG and Retail Domain Knowledge

•  Proficiency in MS office (excel Data Mining Techniques / macros)
• Good understanding of SAP
• Good understanding of FMCG business and Key function
• Knowledge and exposure to Predictive analytics  and BIG Data
  Exposure

Travel : 10-20%