Power Bi Data Analyst

Phone No.: +91-937*******

Location: Pune

E-mail : **************@*****.***

PROFILE

Vaishnavi Kagde

Data Analyst

Linkedin_link

Results-driven Data Analyst with 3 years of experience in transforming data into actionable insights through Power BI, SQL, and Python. Adept at building interactive dashboards, analyzing trends, and supporting data-driven decision-making across HR and insurance domains. Skilled in data modeling, DAX calculations, and cross-functional collaboration. Passionate about solving business problems with data.

TECHNICAL SKILLS

Tools &Technologies Microsoft Power Bi, Power Bi Desktop, Excel, Figma, Jira, SharePoint Programming Languages Python, SQL

Database Platforms SQL server, MySQL

Cloud Computing Azure

PROFESSIONAL EXPERIENCE

MhTechine: May 2025 — Present

(Data Analyst) Pune, India

Workforce Insights Dashboard:

- Collected and transformed employee data (attendance, check-in/out times, leaves, overtime, late entry, location details) using Power Query.

-Created DAX measures for KPIs such as Average Login Time, Total Working Hours, Late-in %, and Absenteeism Rate.

-Built interactive Power BI dashboards to monitor attendance trends, login hours, late entries, and work location distribution.

-Implemented location-based visuals (map with office/site locations) to track employee presence across different regions.

LTIMINDTREE: July 2022—Nov. 2024

(Software Engineer) Pune, India.

HI Analytics (Mercer Reporting Team): -

-Created Power BI dashboards to analyze policy sales, claims, and premium revenue.

- Implemented DAX measures for KPIs like Average Premium per Policy, Total Claims Amounted, etc.

- Built data models (Star Schema) with Fact tables (Claims, Policies) and Dimension tables

(Customer, Agent, Time) ensuring correct relationships and cardinalities.

-Developed stored procedures, views, and functions in SQL server to optimize data extract, transform and load (ETL) processes.

-Transformed raw insurance data (policies, claims, customer, and agent details) using Power Query

(cleaning, merging, and creating calculated columns). PROJECTS

IMocha (Data Analyst) Pune, India

Designed a Power BI dashboard to visualize HR analytics and workforce trends.

Developed visualizations for better improvement. Store E-commerce Report:

Designed a dynamic Power BI dashboard for E-commerce analytics, integrating sales, customer, and product data to provide actionable insights.

EDUCATION

BE (Computer) July 2018 — May 2022

CGPA- 8.77/10 Kopargaon, Maharashtra

CERTIFICATIONS

Certificate of Completion on "Introduction Python: A Practical Perspective".

Microsoft Certified: Azure Fundamentals AZ-900.

Contact this candidate