MIS Analyst - Mutual Fuds

Job Description

FUND PERFORMANCE REPORTING- Daily comparison data of fund house all scheme performance vs competition and share the same internally to all stakeholders by base data from ACE MF. SALES PERFORMANCE REPORTING – Daily Sales vs target reporting of all branches, sales team members on various parameters, like gross & net sales, asset class wise sales, target vs achievement on month and annual basis. Daily SIP business reporting and AUM change reporting along with folio growth tracking. Manage the monthly sales preview process of reporting on MTD and YTD performance on various parameters like asset class, regional achievement and other parameters. All ad hoc requirements of sales team and branch wise MIS which need attention like empanelment, activation and productivity. Tracking sales achievement from the different channel segments like MFD, Banks, national distributors, digital and website. AUM tracking all branch and each team member level and determine the quality of business being sourced. Same for the SIP business tracking. Brokerage tracking to evaluate cost of acquisition of existing sales. Activation and empanelment tracking for the distribution tie ups of the organization. Combine sales field process data into sales tracking MIS. Master Maintenance and Streamlining the process- Distributor to RM mapping, Corporate Folio’s Mapping TARGET SETTING FUNCTIONS – Combine internal achievement data and industry AUM targets to create the annual target break up exercise based on various factors. Own and execute the whole process of facilitating of target break up to each team member’s target setting up, uploading on the sales system, tracking achievements and report all data at the end of year to assess sales team performance. INDUSTRY DATA BASED MARKET SHARE REPORTING – Develop management dashboard presentation and improve them for all important CEO/CBO/ Board and trustee reporting. This is a mix of monthly and quarterly reporting on business achievements, growth vs past, landmarks achieved, fund performance vs benchmarks and organization growth in relation to market & segment growth. Manage & create data warehouse for the MF Industry data based on the CAMS MF Dex data. Evaluating ITI schemes in relation to benchmark performance monthly presented to heads and fund management teams. Provide ad hoc analysis to facilitate management decision making. All types of Industry reports based on AMFI & SEBI numbers. Tracking performance of competitors & MF industry by collating data from various sources. Providing interpretation of the findings & implementing strategies to help increase our Market share. PROCESS AUTOMATION & DEVELOPMENT - Automated CEO dashboard in Power BI that allows HOD’s to visualize and analyse data in a way that can help the organization succeed. Prepared Tree Diagram in Power BI tool. New Platform for the sales users where they can generate dynamic report based on their requirement. Analysis of Productivity for the sales team on a micro regional level. Issue resolution & RCA. Managing Sales Force Automation (SFA activities) and defining various logics for the RMs in close coordination with the IT Team. Development of new modules and documentation of changes made in the modules. Enhancing & automating MIS dashboards and productivity metrics in support of strategic decision making and Sales Force management. JOB REQUIREMENTS – Deep knowledge and proficient in excel. Understanding and experience in Power BI tools. Exposure to ACE MF or ICRA MFI Explorer software. Has worked with CAMs MF Dex data and convert to management dashboards. Minimum 6-7 years of mutual fund working in a middle level role with knowledge of industry database management, internal target tracking modules and automation tools. Knows to work on time based and ad hoc requirements for different teams and stakeholders. Job Types: Full-time, Permanent Pay: ₹300,000.00 - ₹900,000.00 per year Benefits: Paid sick time Provident Fund Schedule: Day shift Work Location: In person