Ajit Gaikwad

Handelling MIS & CRM for KDMC Zone.

• Daily Sales & Collection updates to management. • Keeping track of daily numbers capture by system. Internal AD-HOC reports required. • Automation on the internal reports • Comparison AOP Vs Actual Nos. for all the major business KPI’s • Activity & Minutes of Meetings lists on various points discussed in review meetings • Presentation for the weekly review meeting & Project review meetings • Tracking Cash Flow, Outstanding, Billing, Collections for all projects • Highlighting the collection aging areas to regions. • Handling the MIS Implementation programme, ensure the 100% accurate MIS reports generate from System. • Developing the Reports based on the Regional & Management requirements. • Part of SAP Core team to look after the regional issues in terms of SAP or BI. • MIS data testing, coordination with the development consultant. • Checking of MIS accuracy on daily & weekly basis. • Coordinating with the regional teams for various system & data related issues. • Monthly Presentation on the MIS Progress.

• Daily Sales & Collection Report for all the projects. • Co-ordination with customer care Team for Collection, Booking forms details, Cancellation details, Bank Details, Brokerage bills status etc • Co-ordinate with various teams like Accounts, Strategy, Sales for new launch & process implementation. • Monthly Analysis on the Revenue, Achievements, Low collection areas • Monthly Presentation on Revenue & Collection with various parameters like interest, new Bookings, Cancellations & waivers. • Monthly calculation of CRM ranking and Score Card to map scores of the Executives for the Employee of the month Awards. • Ad-Hoc Request by the various teams & the Management. • Track the Interest and the Waiver Trend.

• Making Reports for Modern Trade Stores Activations and Primary, coordinating with circles for the various offers to Modern Trade Stores • Monthly Ranking for Retail Lead & Exe PAN India, Circle wise. • Score Card of Circles of various Parameters • Maintaining Retail Stores Database PAN India. Update Resigned, terminated & newly appointed franchisee records • Maintaining Handset stock availability report PAN India. Maintaining the handset stock as per the Standard stock norms • Coordinate with Technical Teams for Designing & implementation of new systems & Portals. • Performing the role of National Coordinator for Store Connectivity, Retail. Providing VPN (Intranet) Connectivity to the Retail Stores to access the basic intranet portals which requires for daily store operations & handling the issues regarding the same • Maintain the Daily Rollout report of the new stores, check all the necessary things as per the process note, and the Connectivity of the new stores • Ranking of franchisees. • Profitability of the Franchisees. • Daily MIS Reports for Management & Prepare individual Circle Reports. • Coordinate with circles with for various issues. • Presentations preparation for various reviews & meetings as per requirement. • Providing the Mail IDs to Retail Stores. • Updating the Commercial Date Part in System for quarterly Interest Calculation