Kapil Badmal

India

@kapilbadmaal

Data Analyst

Badges

Python
Sql

Certifications

Work Experience

  • Data Analyst

    Neolytix India Private Limited•  January 2024 - Present•  Remote

    • Transformed complex healthcare data into actionable insights. • Created dynamic dashboards and reports, empowering healthcare organizations with informed decision-making capabilities, resulted in a 10% improvement in overall operational efficiency. • Developed Performance Dashboard, facilitating better allocation of workload by showcasing individual Biller’s performance, resulting in a 12% increase in billing accuracy and a 20% reduction in billing errors. • Developed Workforce Management Dashboard, offering insights into employee efficiency and enabling targeted performance enhancements, resulting in a 10% increase in employee productivity and a 5% decrease in absenteeism rates.

  • Data Analyst

    Austere Systems Pvt Ltd•  October 2022 - October 2023•  Gurgaon

    • Collaborated with EY, a Big 4 firm, on a strategic project for one of India's largest cement manufacturers. • Developed Sales and Logistics Control Tower (SLCT) for an Indian cement manufacturing client. • Design & development of 5+ SLCT dashboards across Sales & Logistics functions. • Designed and implemented descriptive dashboards and diagnostics Root Cause Analysis (RCA) for performance improvement, addressing 20+ Key Performance Indicators (KPIs). • Crafted an advanced RCA model for quantitative and qualitative in-depth data analysis, enhancing the overall analytical capabilities. • Collaborated with cross-functional teams to develop data-driven solutions for business problems, contributed to a 15% increase in productivity and cost savings. • Identified key trends in customer behavior through data analysis, leading to a 10% increase in repeat business and improved customer retention.

  • Business Intelligence Developer

    Infinity Assurance Solutions•  August 2021 - March 2022•  Delhi

    • Leveraged Power BI to develop dynamic dashboards for analyzing mobile insurance claim data. • Collaborated with cross-functional teams to identify key metrics and KPIs for performance tracking. • Contributed to improving customer experience by identifying trends and patterns. • Played a key role in optimizing claim settlement procedures through data-driven insights.

Education

  • Indira Gandhi National Open University

    Business Administration, BCOM

Skills

Microsoft Power BI
Power BI Service
Power Query
ETL
Advanced Excel
Pivot Table
Spreadsheet
DAX Studio
SSAS
SQL
PostgreSQL
PL-SQL
DBeaver
pg admin
Snowflake/Star Schema
Python
DAX