Associate - Agaram technologies
(2020-11)
Associate with 5+ years of experience in Data Analysis, Business Intelligence, and Dashboard Development across Healthcare and Life Insurance domains, delivering actionable insights for clients including Cigna and Prudential Financial in Agile environments.
- Strong hands-on experience in designing and developing interactive Power BI dashboards, automated SQL reporting pipelines, ETL workflows and Tableau to support real-time data-driven decision-making for cross-functional business stakeholders.
- Proficient in SQL query development including joins, subqueries, window functions, and stored procedures, along with DAX measures, Power Query transformations, and data modeling techniques including star schema and snowflake schema design.
- Experienced in statistical analysis, exploratory data analysis, fraud detection analytics, predictive forecasting, and data validation ensuring full compliance with HIPAA, HEDIS, and insurance regulatory and audit reporting standards.
- Skilled in stakeholder collaboration, data governance, and end-to-end reporting lifecycle management, working closely with clinical, compliance, actuarial, and fraud analyst teams using Jira and Azure DevOps in Agile and Scrum environments.
Senior Data Analyst - Prudential Financial
(2021-02 - 2023-03)
Designed and developed Tableau dashboards to identify fraudulent insurance claims, monitor suspicious transactions, and support fraud detection for Prudential Financial's life insurance division, later transitioning key reporting components to Power BI for scalability and enterprise-wide accessibility. Performed end-to-end data modeling, ETL processing, and statistical analysis to detect anomalous claim patterns and deliver actionable fraud insights to compliance and risk teams. Built automated reporting workflows using Tableau calculations (calculated fields, parameters, and LOD expressions) and migrated core logic to Power BI using DAX measures and Power Query transformations.
Developed reusable data pipelines and datasets enabling near real-time fraud monitoring, claims investigation tracking, and regulatory compliance reporting. Collaborated with fraud analysts, actuarial, and compliance stakeholders to translate complex risk data into interactive dashboards, improving fraud detection accuracy and supporting audit-ready reporting aligned with insurance regulatory standards.
- Designed and developed interactive Tableau dashboards to identify fraudulent insurance claims, monitor suspicious transactions, and track claim investigation status, enabling fraud detection teams to prioritize high-risk cases in real time. Later transitioned key fraud analytics dashboards to Power BI to enhance scalability, collaboration, and enterprise reporting capabilities.
- Performed end-to-end data modeling, including star schema and snowflake schema design, to structure life insurance claims data for efficient reporting, improving dashboard performance and analytical query speed by 30%.
- Developed and optimized ETL processes to extract, transform, and load claims data from multiple source systems into a centralized data warehouse, ensuring data consistency, accuracy, and readiness for fraud analytics and compliance reporting.
- Built advanced Tableau calculated fields, parameters, Level of Detail (LOD) expressions, and data transformations to perform statistical analysis on claims patterns, identifying anomalous transactions and supporting fraud detection accuracy improvements by 25%. Later replicated and enhanced key logic in Power BI using DAX measures and Power Query transformations.
- Conducted exploratory data analysis and statistical profiling on insurance claims datasets to detect outliers, duplicate records, and suspicious claim patterns, providing actionable fraud intelligence to risk management and actuarial teams.
- Collaborated with fraud analysts, compliance officers, and business stakeholders to gather requirements, define fraud detection KPIs, and deliver self-service Tableau dashboards aligned with life insurance regulatory and audit standards, later migrating selected reporting solutions to Power BI.
- Implemented row-level security, user filters, and role-based access controls in Tableau Server to ensure secure access to sensitive claims data, supporting data governance and regulatory compliance requirements; also implemented equivalent security controls in Power BI Service.
- Published and maintained Tableau dashboards and reports on Tableau Server, enabling automated data refreshes and enterprise-wide access to fraud analytics insights, later transitioning key dashboards to Power BI Service for improved distribution and governance.
- Prepared audit-ready compliance reports and executive-level fraud summary dashboards, translating complex risk data into intuitive visualizations to support senior leadership decision-making and insurance regulatory reporting requirements across both Tableau and Power BI platforms.
