Karvy - Team Lead - MIS Reporting

About Karvy

Karvy is a premier integrated financial services company, ranked amongst the top-5 in the country across all the business segments that it has presence in. The Group services over 70 million individual investors in various capacities, and provides investor services to 600 of the best of Corporate India. Karvy covers the entire spectrum of financial services, such as stock broking, registry services, depository services, distribution (of financial products including mutual funds, bonds and fixed deposits), commodities broking, currencies broking, personal finance advisory services, merchant banking & corporate finance, wealth management, NBFC, insurance repository, equity placement, and IPOs among others. The Group is professionally managed with combined staff strength of nearly 8500 employees across the length and breadth of the country and ranks among the best in technology, operations and research.

Purpose of role

Lead the team for MIS reporting

Key Responsibilities

- MIS reporting by using Advance Excel, MS access & VBA (Macro) at Operational

- Strong knowledge on MS Office, Excel and Report preparations

- Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.

- Implement and analysis data to create daily, weekly, monthly, and quarterly reports

- Design/develop the agreed upon solution in MS Excel/ MS Access with VBA Programming.

- Deliver end products maintaining quick turnaround times and highest quality standards execute quick turnaround work in MS Excel/MS Access which involves VBA

- Managing the Monthly, Weekly & Daily Report Creating in MS-Excel and MS-Access through in depth analysis and producing the actionable information.

- Implement practices and metrics to improve operational efficiencies

- Generating & maintaining day to day MIS Data and updating the management.

- Determined required data by analyzing MS-Access databases and created customized reports.

- Extensive usage of MS Excel (Aggegate function, Vlookup, Pivot table)