Ahana Bhowmick

Worked on claim data quality and performance for Auto Liability in IBM Cognos by identifying issues and recommending resolutions. Built and maintained Tableau dashboards for claims monitoring and created Power BI dashboards translating large claim datasets into KPIs. Extracted datasets from Snowflake using optimized SQL and supported daily reporting with ad-hoc query troubleshooting. Automated recurring reports, improving efficiency and reducing manual effort while also improving Power BI dataset performance.

Designed interactive dashboards and reports to deliver actionable insights for catastrophic insurance outcomes. Built datasets by extracting, transforming, and loading data from multiple sources including SSMS, Excel, and Microsoft Access. Optimized dataset size and KPI responsiveness to improve user experience. Created DAX measures and calculated columns for underwriting and claims analysis, collaborating with cross-functional stakeholders to drive data-driven decisions.

Developed Power BI datasets using data transformation and data modeling to support batch processing workflows. Implemented row-level security and role-based access to protect data across business roles. Used DAX functions and Power BI Desktop features for reporting and analytics. Resolved SQL issues in Excel-integrated datasets using SQL commands such as joins and schema/data changes.