City Sales Support_RMD

Job Description

Create and manage Excel spreadsheets, including complex formulas, pivot tables, and data analysis. Develop professional PowerPoint presentations with compelling visuals and structured content. Handle day-to-day tasks involving Word, Outlook, and other MS Office applications. Collaborate with teams to generate reports, analyze data, and improve efficiency using MS Office tools. Assist in documentation, meeting coordination, and other administrative support activities Proficiency in the latest MS Office Suite (Excel, PowerPoint, Word, Outlook). Advanced Excel skills (VLOOKUP, PivotTables, Macros, etc.). Strong PowerPoint skills, including animations and data visualization. Excellent communication and organizational abilities. Compilation of MIS :Should handle the MIS of BCCL publications & Competition dallies for Mumbai City ( 60 depots). Will be the point of contact for smooth coordination of collating the data for Mumbai City. Should compile the entire sales data from Distributor . Compilation of sales figures and other data in co-ordination with the Regional Managers, Area Managers in time. Also updating of competitor figures. Maintaining pagination & unsold trends. Clearing of Bills : He needs to clear in time the bills of vendors who are delivering complimentary copies to BCCL for onward distribution to various departments. Clearing of bills of any events conducted by RMD city sales as well as vendor pooja expenses bill etc., In addition to this he has taken the responsibility of clearing the bills of the vendors of upcountry also. Also clearing of transporters bills etc., he supports the RMD accounts team in clearing their bills. Prepare Purchase Order for any procurement pertaining to Mumbai (for transport contract and vendors and other procurements of RMD) Good teamwork and understanding with sales team and coordination with other departments for smooth functioning of RMD city sales team is requisite . In the current scenario where city sales team is working from various locations ( CST - Kandivali & Airoli ), he helps the team in getting their administrative work done for their respective place of work. Also coordinate with other departments like Administration, Finance, Business to clear RMD city sales requirement if any. On a regular basis creating vendor code for new RRE, DSA etc., for DSP team. Maintaining the agreements and other relevant details which is required by RMD accounts for audit purpose and also maintaining the record of RRE / DSA. Processing their code and submit the same to DSP team for payment of RRE/DSA salary. Coordinates with Two distributors KB & OML in Mumbai for timely release of Dalies vendor wise figure .