GAURAV SHAKYA | Portfolio

Summary

Senior Claims Executive with 3+ years of experience in claims adjudication, internal audit, and compliance, now transitioning into data analysis. Proficient in SQL, Power BI, Excel and VBA Automation to extract insights, build dashboards, and streamline reporting processed. Demonstrated success in reducing discrepancies, automating manual workflows, and improving decision-making through data-driven reporting. Seeking to leverage analytical and technical skills in a Data Analyst role to deliver actionable business insights and process optimization.

Projects

Automated Reporting System | VBA, MS Access, SQL, Excel

Built a fully automated reporting system, eliminating manual data processing workflows
Developed ETL pipeline using Excel, MS Access, Power Query, and VBA automation
Achieved ~95% reduction in reporting time (2–3 hours → <2 minutes)
Designed a single-click solution adopted as the standard team workflow
Enhanced data accuracy, consistency, and operational efficiency

Dashboard - Power BI + SQL + PandasCustomer Behavior Analysis Dashboard | Power BI

Developed an interactive dashboard to analyze customer behavior and purchasing patterns.
Performed data cleaning and transformation using Power Query.
Identified key trends in customer segments, frequency, and spending habits.
Created KPIs and visualizations to support business decision-making.
Enabled stakeholders to track performance through dynamic filters and reports.

Experience

Jun 2024 — Present

Senior Claims Executive

EXL Services Pvt. Ltd., Noida

Designed and deployed automated KPI dashboards using Power BI and Advanced Excel with Power Query, enabling real-time tracking of claims trends, fraud detection signals, and team performance metrics.
Implemented VBA automation solutions reducing manual reporting workload by 30% per week, freeing analyst capacity for higher-value tasks.
Conducted internal audits of claims data workflows using SQL queries and Excel-based validation, reducing data discrepancies by 15% and ensuring HIPAA compliance.
Performed end-to-end ETL operations — extracting, transforming, and loading data into reporting models for daily and monthly production reports.
Mentored and trained 10+ junior staff on claims adjudication and data tools including Excel and Power Query.

Jun 2022 — Jun 2024

Claims Executive

EXL Services Pvt. Ltd., Noida

Processed and adjudicated complex insurance claims with 98% accuracy, ensuring strict compliance with policy guidelines and HIPAA requirements.
Designed Excel-based MIS reporting templates using Power Query and pivot tables, reducing turnaround time by 25%.
Performed data analysis on claims patterns to identify root causes of escalations and drive corrective actions.
Maintained detailed audit trails and data documentation to support internal audits, compliance reviews, and process optimization.

Certifications

📊 Management Information System(MIS) - Advanced Excel, VBA, Power Query, Pivot Tables, Data Modelling - Completed

🗄️ SQL for Data Analysis — Structured Query Language for Reporting - Completed

📈 Power BI — Data Visualization and Dashboard Development - Completed

🐍 Python for Data Analysis — Pandas, NumPy, Data Manipulation - Completed

🎯 Data Science - Code With Harry - In Progress

Skills & Tools

Programming & Query

SQL | Python | VBA | M Language | Power Query

BI & Data Tools

Power BI | Advanced Excel | MS Access | Pandas | NumPy

Analytics & Reporting

ETL | EDA | KPI Dashboards | MIS Reporting | Data Modelling | RCA

Automation

VBA Automation | Reporting Automation | Web Scraping | Selenium |

Domain Knowledge

Claims Adjudication | HIPAA Compliance | Internal Audit | Policy Interpretation

Soft Skills

Team Mentorship | Training & Dev | Query Resolution

Summary ▶