Enterprise performance dashboard
- Worked on developing an enterprise capacity product to analyze business performance by tracking KPIs
- Collaborate with heads of different lines of business for requirement gathering, presenting solutions / proposals, feedback sessions and trainings
- Identify metrics and define methodologies that translate data into key business trends and enable faster decision making among state managers
- Convert business requirement and rules into mathematical formulas and implement the logic in SQL queries
- Compile data from multiple enterprise platforms like Hive, OLAP cubes and create efficient data models to feed into Tableau dashboard
- Partner with design team to create user friendly visualizations on Tableau dashboard
Reporting Automation
- Developed a highly sophisticated validation process that saved more than 90% of the operation team’s time spent on validations and enabled efficient reconciliation of data across various data information systems
Rating tool for premium calculations
- Worked with the pricing team of US Insurance major on all modules of rate change processes including off balancing for auto and home insurance
- Responsible for data analysis for rate change process, build rating tools to price policies, work closely with actuaries and product management team and assist them derive new rates for policy holders on renewals.