Consultant Data Analyst
Omnino Solutions Private Limited · Jan 2023 – Present
- Analyzed BRDs and collaborated with stakeholders to understand business requirements and functional specifications.
- Developed interactive Power BI dashboards to monitor key insurance KPIs, including Premium Collection, Claims, Policy Issuance, Customer Retention, and Business Performance, enabling data-driven decision-making.
- Designed and implemented Star Schema data models by creating relationships between fact and dimension tables, improving data organization, query performance, and report scalability.
- Extracted, analyzed, and validated insurance data using SQL, ensuring accuracy and consistency across policy, claims, and transaction datasets.
- Performed data cleaning, profiling, and validation using Advanced Excel and SQL to identify missing values, duplicates, and data inconsistencies before reporting.
- Built and maintained Power BI data models and developed DAX measures for KPIs, trend analysis, and executive reporting.
- Created automated dashboards and recurring MIS reports using Power BI and Excel, reducing manual reporting efforts and improving reporting efficiency.
- Analyzed policy lifecycle data, including New Business, Premium Collection, Lapse, Paid-up, Surrender, Maturity, and Claims, to identify business trends and operational insights.
- Gathered business requirements from stakeholders and documented them into BRDs and FRDs, ensuring alignment between business objectives and technical implementation.
- Utilized Advanced Excel functions, including Pivot Tables, XLOOKUP/VLOOKUP, IF, Conditional Formatting, and Data Validation, to prepare analysis-ready datasets.
- Supported business teams with actionable insights through dashboard reporting, KPI tracking, and operational performance analysis.

