AVP/ Senior Manager - EIMA - Gurugram

I. The role holder is responsible to manage various reporting requirements like Business performance, KPIs, Performance Management, Incentives, CPP & PIP etc To provide insights within organisation across all hierarchy levels right from ExCO to ground level staff and to distribution spread across Bank Staff, Business partners. This role requires maintenance of existing reporting application Saral which is built on SQL & Pentaho. Also person is required to build / automate new dashboards on this reporting application, hence extensive knowledge of various databases & ETL tool is required. Objective of the role is to reduce execution time and associated risk, by automating existing manual reports and to create process and control over various aspects of business intelligence framework, Reporting automation platforms, data dictionary, requirement documents and traceability documents.

III.

IV. Use Powerpoint, MS Excel, MS Access, PL/SQL, ETL, OLTP System, Macro scripting, BI tools, data warehouse, and all available resources to create / automate reports and its presentation to stakeholders

V. Monitoring various sales KPI such as issuance target achievement, login, pipeline cases, commission earned, new business and renewal business, branch & people activation and productivity, etc to the distribution partners and business development teams

VI. Creation of Sales force management policy for each and every level of hierarchy for one or more distribution channels

VII. Creation of incentive structure for each and every level of hierarchy for one or more distribution channels and management of budgets and opex

VIII. Creation of CPP / PIP for each and every level of hierarchy for one or more distribution channels

IX.

Gather requirements from in-house teams by understanding existing reporting process and creating automated reports for same

I.

II.

III. Knowledge of insurance industry is MUST to have quick hand holding.

IV. Providing qualitative and timely information to decision makers on all of the aforesaid parameters in form of various dashboards, such as HO business update (automated), early claims dashboard, surrender payout monitoring, etc

V. responsible for publishing sales metrics in terms of timely and accurate incentive calculation for 5000+ sales staff on monthly basis approved sales incentive scheme as a part of SFM (Sales Force Management)

I. Develop and implement BI strategies aligned with business objectives to leverage the automation in organisation.

II. Ensure that automated outputs match with the existing manual reports. However, with an objective of reducing manual efforts & execution time for reports streamlining and efficiency.

III. Provide training, guidance and support to ensure team performance and development.

IV. Identification of potential risk items, which may lead to data inconsistency & suggest mitigation plan. Define & revise key measures used across organization and collaborate for documentation

V. Manage and maintain BI in-house tools and systems for seamless delivery of multiple dashboards.

VI. Develop and implement automated workflows for data ingestion, transformation, loading (ETL) and maintenance of data sanity.

VII. Manage the projects of design & deploy new reports and tracking dashboards, within least possible turn around and should have hands on experience in all or most of below mentioned tools:-