PAVITHRA KATHIRAVAN

Data Analyst

5+ yrs exp 90 · Outstanding

About

Results-driven Data Analyst with 2.8 years of experience transforming complex datasets into actionable business insights. Proven expertise in Power BI Desktop, Power BI Service, Oracle, and SQL, with a strong track record of designing interactive dashboards, building scalable data models, and delivering data visualizations that drive strategic decision-making across cross-functional teams through the complete BI lifecycle — data preparation, data modeling, visualization, and report maintenance.

Skills & Expertise (47)

Power BI Advanced

8.5/10

2.8

Years Exp

SQL Advanced

8.0/10

2.8

Years Exp

DAX Advanced

8.0/10

2.8

Years Exp

Tableau Intermediate

7.5/10

2.8

Years Exp

Data Modeling Intermediate

7.5/10

2.8

Years Exp

ETL Pipelines Intermediate

7.5/10

2.8

Years Exp

Agile Methodology Intermediate

7.0/10

2.8

Years Exp

Statistical Analysis Intermediate

6.5/10

2.8

Years Exp

Python Intermediate

6.5/10

2.8

Years Exp

Cross-Functional Collaboration Anomaly Detection Data Profiling Fraud Detection Root Cause Analysis Data Validation Data Reconciliation Data Governance Row-Level Security Data Quality Assurance Advanced Excel Jira Azure DevOps Git GitHub Scrum Stakeholder Collaboration Requirements Gathering Subqueries Power BI Desktop Tableau Server Power Query Interactive Dashboards KPI Reporting SQL Server MySql Stored Procedures Window Functions Forecasting Joins Query Optimization Data Warehousing Star Schema Snowflake Schema Data Transformation Automated Reporting Exploratory data analysis Predictive Analytics

Work Experience

Data Analyst

Prudential Financial

Jun 2025 - Present

Designed and developed Power BI dashboards to identify fraudulent insurance claims, monitor suspicious transactions, and support fraud detection operations for Prudential Financial's life insurance division. Performed end-to-end data modeling, ETL processing, and statistical analysis to uncover anomalous claim patterns and deliver actionable fraud intelligence to compliance and risk management teams. Built automated data pipelines and DAX-based calculated measures to enable 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 visualizations, improving fraud detection accuracy and supporting audit-ready reporting aligned with insurance industry regulatory standards.

Data Analyst

Pyramidion Solutions

Nov 2023 - Present

Developed interactive Power BI dashboards with advanced DAX measures, calculated columns, and Power Query transformations 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. Performed end-to-end data modeling using star schema and snowflake schema design to structure life insurance claims data for efficient reporting, and built optimized ETL pipelines to extract, transform, and load claims data from multiple source systems into a centralized data warehouse, ensuring data consistency, accuracy, and traceability. Conducted exploratory data analysis (EDA) and statistical profiling on large-scale insurance claims datasets to detect outliers, duplicate records, and anomalous claim patterns, improving fraud detection accuracy by 25%. Implemented row-level security (RLS) and role-based data access controls in Power BI to ensure HIPAA-compliant access to sensitive claims data. Collaborated with fraud analysts, compliance officers, and cross-functional business stakeholders in Agile and Scrum environments to gather requirements, define fraud detection KPIs, and deliver self-service Power BI reports supporting data governance and regulatory compliance frameworks.

Data Analyst

Warehouse Operations

Nov 2023 - Jun 2025

Developed an end-to-end Warehouse Operations Analytics System to monitor and optimize supply chain performance across distribution centers. Designed interactive Tableau dashboards and automated SQL-based ETL workflows to track warehouse productivity, inventory movement, and order fulfillment efficiency, enabling data-driven operational decisions for logistics stakeholders. Engineered complex SQL queries using multi-table joins, window functions, and stored procedures to extract, transform, and aggregate large-scale logistics datasets from relational databases, ensuring accurate and timely data availability for reporting. Built and maintained automated ETL workflows to ingest, cleanse, validate, and load structured data from multiple warehouse source systems into a centralized data warehouse, ensuring data integrity, consistency, and traceability across the reporting environment. Performed exploratory data analysis (EDA), trend analysis, and variance analysis on inventory movement, shipment delays, and fulfillment cycle times to identify operational bottlenecks and deliver actionable insights to warehouse and supply chain stakeholders. Collaborated with logistics operations, warehouse management, and business stakeholder teams in Agile and Scrum environments to gather reporting requirements, conduct UAT and manage end-to-end dashboard deployment using Jira and Azure DevOps.