Power Bi Data Analyst

Keval Patel

Power BI Developer Data Analyst Business Intelligence Professional

Email: **********@*****.*** Phone: 662-***-**** Location: Murfreesboro, TN

PROFESSIONAL SUMMARY

* ***** ** ******ence as a Power BI Developer and Data Analyst, specializing in healthcare data analytics, reporting, and business intelligence.

Proficient in data visualization, DAX, Power Query, and data modeling, with a deep understanding of healthcare metrics and claims processing.

Experienced in collaborating with stakeholders to identify reporting needs and deliver actionable insights for improved healthcare decision-making.

Proven track record of transforming complex data into clear, impactful reports that drive strategic business decisions.

Expertise in integrating Power BI with diverse data sources, including SQL Server, Excel, Azure, and cloud-based data lakes.

Skilled in creating dynamic dashboards, custom visualizations, and KPI reports to support business growth and operational efficiency.

Strong knowledge of HIPAA compliance and PHI data handling in healthcare environments.

Experienced in data cleansing, ETL processes, and optimizing data flows for high-performance analytics.

Effective communicator with a talent for translating technical insights into business language for non-technical stakeholders.

Certified in Power BI, SQL, and Data Analysis with a focus on continuous learning and professional growth.

TECHNICAL SKILLS

Business Intelligence Tools

Data Analysis & Modeling

Database & ETL Tools

Programming Languages

Cloud Platforms

Other Tools

Power BI, SSRS, Tableau

DAX, Power Query, M

SQL Server, SSIS, SSAS

Python, R, T-SQL

Azure, AWS

Excel, SharePoint, Jira

Data Studio, Domo

Data Warehousing, OLAP

MySQL, Oracle, Snowflake

VBA, JSON, REST APIs

Google Cloud

Git, Power Automate

PROFESSIONAL EXPERIENCE

Power BI Developer

Guardian Life Insurance Spokane, WA (09/2023 - Present)

Developed a comprehensive claims analytics platform to improve claims processing efficiency and reduce operational costs. This platform included real-time dashboards for claim status tracking, automated data integration from multiple sources, and customized visualizations for executive reporting.

Key Responsibilities:

Designed and developed interactive Power BI dashboards, including claims cost analysis, patient risk scores, and reimbursement trends, reducing claims processing time by 30%.

Created a centralized data model integrating SQL Server, Excel, and Azure Data Lake sources, improving data consistency and reducing manual data handling by 40%.

Developed DAX measures for complex financial calculations, including cost-per-member, claims utilization rates, and provider performance metrics.

Implemented Power BI Paginated Reports for detailed financial reporting, supporting regulatory and audit requirements.

Integrated Power BI with Power Automate for real-time claim alerts, enhancing response times and customer satisfaction.

Conducted data quality assessments, identifying data anomalies and implementing corrective measures to ensure accurate reporting.

Collaborated with data engineering teams to optimize data pipelines, reducing report refresh times by 50%.

Led stakeholder workshops to gather reporting requirements, aligning business goals with data analytics strategies.

Implemented Row-Level Security (RLS) for HIPAA-compliant data access, ensuring secure, role-based data visibility.

Automated data refresh schedules and report distribution, reducing manual reporting efforts and improving data availability.

Environment: Power BI, SQL Server, DAX, Power Query, Azure Data Lake, Power Automate, Excel, SharePoint

Power BI Developer

Allianz (Miami, FL) 12/2021 – 08/2023)

The project aimed to build a comprehensive financial analytics platform for Allianz, one of the world's largest financial services and insurance companies. The platform provided real-time insights into investment portfolio performance, risk assessment, client profitability, and operational cost control. It supported the finance and investment teams in making data-driven decisions to optimize asset allocation and improve financial returns.

Key Responsibilities:

Developed interactive Power BI dashboards to monitor portfolio performance across asset classes, including equities, fixed income, and alternative investments, providing real-time insights into asset growth and risk exposure.

Implemented complex DAX formulas to calculate Value-at-Risk (VaR), Sharpe ratios, and standard deviations, enhancing the company's risk management capabilities.

Created reports to identify high-value clients and segments, optimizing marketing and sales strategies based on profitability metrics.

Automated financial projections for cash flow and capital adequacy, supporting regulatory compliance and financial planning.

Integrated financial data from multiple sources, including SAP, SQL Server, and Excel, reducing financial reconciliation time by 40%.

Conducted data cleansing and transformation using Power Query to ensure accurate financial reporting.

Developed Power BI Paginated Reports for quarterly and annual compliance submissions, aligning with SOX and IFRS standards.

Created interactive financial dashboards for senior management, providing key insights into financial performance, asset allocation, and risk exposure.

Worked closely with financial analysts and portfolio managers to gather requirements, ensuring the dashboards met strategic business needs.

Automated data refresh schedules and integrated Power Automate workflows for real-time alerts, reducing manual intervention and improving data availability.

Environment: Power BI, SQL Server, SAP, DAX, Power Query, Power Automate, Excel, Azure

Power BI Developer

MetLife (Charlotte, NC) (04/2019 – 11/2021)

Developed a centralized reporting system for MetLife's life insurance division, focusing on claims processing efficiency, agent performance, customer retention, and operational analytics. The project aimed to reduce operational costs, improve customer satisfaction, and enhance the overall claims experience.

Key Responsibilities:

Created Power BI dashboards to track claims processing times, cost-per-claim, and settlement ratios, reducing average processing time by 30%.

Developed interactive dashboards for agent performance metrics, including premium revenue, policy sales, and retention rates, improving agent productivity.

Built predictive models using DAX for customer churn analysis, identifying at-risk policyholders and optimizing retention strategies.

Implemented anomaly detection algorithms to identify potentially fraudulent claims, reducing financial losses.

Integrated Power BI with live data sources, including SQL Server and internal claims databases, providing real-time operational insights.

Automated data extraction, transformation, and loading (ETL) processes using Power Query, improving data consistency and reducing manual data preparation.

Created custom KPIs for financial health, policy renewals, and claims efficiency, supporting executive decision-making.

Implemented Row-Level Security (RLS) to ensure compliance with industry regulations, including HIPAA and state insurance laws.

Automated financial reporting processes, reducing manual data entry errors and improving financial transparency.

Conducted requirements gathering sessions with business leaders to align Power BI dashboards with strategic business goals.

Provided Power BI training to business users, improving data literacy and adoption across departments.

Environment: Power BI, SQL Server, Excel, DAX, Power Query, Power Automate

EDUCATION

Bachelors of Engineering in Computer Science ( Shir Sitarambhai Naranji Patel Institute of Technology)

Contact this candidate