Power Bi Data Analyst

Ravindra Reddy vtukuru

Email:- *****************@*****.*** Ph: +1-475-***-****

Professional Summary:

Over 9 years of experience in Software Design, Database Design, Development, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms.

As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advance Data Analysis, Business Research and Quantitative Analysis

Experience in SQL 2017/ 2016/2014/2012 /2008 R2 with an emphasis on design, development, automation, tuning. optimization, Performance and Security.

Smartsheet Expertise Advanced automation, reporting, permissions, and form creation.

Experienced in Electronic Health Records (EHR) integration, aligning clinical data with insurance systems for comprehensive reporting and compliance.

Served as a Data Integration Specialist, enabling secure and efficient data exchange between healthcare providers, public agencies, and private insurers.

Built and maintained data pipelines to support interoperability across EHR platforms using standards like HL7 and FHIR.

Developed AI-driven Power BI dashboards and predictive models to enhance claims processing, fraud detection, and risk scoring.

Leveraged machine learning techniques within Power BI and Azure ML for pattern detection in policy lapses, chronic care trends, and underwriting assessments.

Power BI Proficiency Data modeling, DAX, Power Query, and visualizations

Extensive experience in Property & Casualty (P&C) Insurance domain, working with claims processing, policy management, and risk analysis.

Hands-on experience developing HANA Calculation Views (graphical and SQL-based), optimizing Attribute and Analytical Views to enable high-performance reporting.

Strong expertise in Power BI dashboards, DAX measures, Power Query transformations, and integrating sources like Azure Data Lake, SQL Server, Databricks, and SAP HANA.

Skilled in creating and optimizing stored procedures, SQL functions, and scripting for advanced data processing within SAP HANA.

Smartsheet Expertise Advanced automation, reporting, permissions, and form creation.

Power BI Proficiency Data modeling, DAX, Power Query, and visualizations.

JIRA Administration Custom workflows, automation, board configuration, and reporting.

Confluence Documentation Creating structured documentation and knowledge management systems.

Scripting & Automation Ability to write custom scripts (Python, JavaScript, VBA, SQL, or similar API & Data Integration Experience Familiarity with JIRA REST API, Smartsheet API, Power BI connectors, and other integration tools.

Strong experience with Azure DevOps, Azure Cloud Services, and backend system integration.

Proven expertise in designing scalable applications using Power Apps, Power Automate, Power BI, and Dataverse

Extensive experience in SQL Server, data modeling, and technical documentation.

Extensive experience supporting Home Site Insurance and Casualty Insurance domains through end-to-end data solutions, including underwriting, policy, billing, and claims analytics.

Designed and delivered end-to-end Power BI dashboards for actuarial, underwriting, and claims teams, significantly improving data-driven decision-making across Property & Casualty (P&C) Insurance operations.

Developed interactive and self-service Power BI reports using DAX and Power Query, empowering business users with real-time insights and reducing dependency on IT.

Integrated multiple data sources including Azure Data Lake (ADLS), SQL Server, and third-party platforms (ISO, LexisNexis) to enrich Power BI reports with comprehensive datasets.

Created optimized data models using star schema and tabular formats to support scalable and high-performance Power BI reporting.

Built advanced DAX calculations and measures for dynamic KPI tracking, trend analysis, and risk modeling in insurance domains.

Published and managed Power BI reports and dashboards on Power BI Service, enabling secure access and version control for various departments.

Converted legacy reports to modern, dynamic Power BI dashboards, streamlining reporting workflows and enhancing visualization capabilities.

Utilized Power BI Gateway and Power BI Embedded to support on-premises data refresh and integrate analytics into internal applications.

Collaborated with cross-functional teams (actuaries, underwriters, claims analysts) to gather requirements and translate them into impactful Power BI solutions.

Implemented row-level security (RLS) in Power BI reports to ensure data governance and role-based access controls.

Developed and maintained Power BI dataflows and shared datasets, enabling centralized and reusable data logic across multiple reports.

Used Power BI tools like Power View, Power Query, Power Pivot, and Power Maps to explore and visualize complex insurance datasets.

Integrated SSAS Tabular Models with Power BI for high-speed in-memory analytics and multidimensional querying using DAX and MDX.

Technical skills

Database: MS-SQL Server

Reporting Tools: Power BI Desktop, Power Bl Report Builder, SSRS, PowerPivot for Excel Analysis Tools: SQL Server Analysis Services (SSAS)

Data Integration&ETL: Informatica PowerCenter, Informatica Data Quality (IDQ),Informatica Axon (for governance), Informatica Enterprise Data Catalog (EDC),Azure Data Factory,SSIS (SQL Server Integration Services)

Languages: SQL, DAX, M-Query, PowerShell Scripting

Automation: Power Automate/Flow, PowerShell

Cloud & Big Data: Azure Data Lake Storage (ADLS)

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MSFT suite

Operating System: Windows

Performance Tuning: DAX studio

Development: Visual Studio, PowerShell ISE, Power GUI, Power Bl Helper, Notepad++

Administration: Active Directory for Users and Computers, PowerBI Admin Portal, Office 365 Admin Portal, Power Platform

Professional Experience

Tango health, Austin, TX August 2023 –till date

Power BI SQL Developer

Responsibilities:

Developed and deployed interactive Power BI dashboards to monitor key P&C Insurance metrics such as claims frequency, policy renewals, quote conversions, and underwriting performance.

Integrated Power BI reports into applications using embedded analytics via Power BI Service (SaaS) and API automation for seamless access.

Created complex DAX calculations, measures, and calculated columns to support dynamic visualizations and deep analytical insights.

Developed and maintained SAP HANA Calculation Views (graphical and SQL script-based) to support advanced analytics in P&C insurance reporting.

Led EHR data integration efforts, ensuring accurate and compliant exchange between client systems, healthcare providers, and insurance networks.

Worked as a Data Integration Specialist facilitating interoperability between Power BI solutions and external public/private healthcare agencies using APIs and secure transfer protocols.

Designed AI-powered Power BI dashboards for predictive analytics in healthcare claims and policy data, identifying fraud risks and improving underwriting accuracy.

Integrated electronic patient records and insurance data to deliver unified reports for health plan assessments.

Implemented AI-driven anomaly detection in Power BI dashboards to flag unusual claim trends and assist in pre-authorizations.

Developed Power Apps/Automate flows to streamline EHR processing workflows and automate claim eligibility checks.

Built and optimized Attribute and Analytical Views in HANA to enable fast, flexible data consumption by Power BI dashboards.

Created SQL procedures and functions in HANA for complex business logic and data transformation workflows.

Ensured efficient data modeling practices to meet scalability and performance requirements for both internal and client-facing reporting.

Designed and deployed Power Platform solutions including Power Apps and Power Automate flows for claims, policy, and underwriting workflows in the P&C Insurance domain.

Developed custom connectors to integrate with Azure Data Lake, Databricks, and third-party services.

Supported integration of Power Apps with SQL Server and SharePoint for enterprise applications.

Developed interactive Power BI dashboards that provided real-time insights, leveraging DAX, Power Query, and data modeling for optimized performance.

Integrated Azure Data Lake and Databricks to automate data pipelines, reducing manual reporting efforts by 40%.

Implemented Power BI Embedded to provide external clients with secure, scalable reporting solutions.

Optimized Power BI performance tuning by implementing aggregations and reducing data model size.

Designed custom security roles in Power BI to ensure access control and compliance.

Property & Casualty (P&C) Insurance metrics, including claims frequency, loss ratios, policy renewals, quote conversions, underwriting performance, and premium trends.

Designed analytical models for home site insurance, assessing risk factors such as property location, weather patterns, and historical claims data to improve underwriting decisions.

Integrated Power BI with actuarial models to assess loss reserves, catastrophe exposure, and policyholder trends in P&C Insurance.

Built predictive analytics models leveraging Power BI and Azure Machine Learning to identify high-risk policies, fraud detection, and potential claim outliers in P&C Insurance.

Built Office 365 solutions using Power BI, Power Automate, and Power Apps to streamline reporting and workflow automation.

Designed self-service BI dashboards using tabular models, enabling users to explore data with hierarchies, slicers, and drill-down capabilities.

Environment: MS SQL Server, Azure, SQL Server Reporting Services, T-SQL., POWER BI, SQL, SSIS, SSAS,

Smartsheet, DAX, Tableau

Client: : Homesite Insurance, Boston, MA

Role: Power BI Developer June2022 - Aug2023

At HomeSite Insurance Company, I developed dynamic dashboards using the Customer Communication Management tool, implementing age and category filters, and applying display rules for individual paragraphs.

Responsibilities:

Designed and implemented SSIS Packages to support P&C insurance data pipelines, enabling seamless data import/export between MS Excel, Flat Files, and SQL Server for claims processing, policy administration, and underwriting data integration.

Designed and automated Smartsheet workflows to streamline project tracking, approvals, and reporting across multiple teams.

Collaborated on EHR data integration to merge clinical data with insurance claim records for comprehensive risk modeling and coverage decisions.

Automated secure data pipelines to process large volumes of healthcare records from external hospital systems using HL7/FHIR-compliant standards.

Integrated AI models for risk scoring of policies based on patient histories, demographics, and prior claims data.

Built dashboards analyzing correlations between chronic condition data from EHRs and long-term policy costs.

Supported end-to-end integration with third-party AI services for eligibility scoring and patient claims predictions.

Implemented Smartsheet API integrations with Power BI and JIRA to enhance data visibility and reduce manual data entry by 60%.

Designed and managed HANA Calculation Views to support claims analytics, risk modeling, and policy insights in Power BI.

Created reusable Attribute and Analytical Views in SAP HANA to standardize business logic across underwriting and actuarial teams.

Developed SQL-based procedures and logic within SAP HANA for claims data processing, loss reserve calculations, and regulatory reporting.

Collaborated with enterprise data teams to ensure HANA data models were aligned with performance benchmarks and scalable for enterprise reporting.

Configured advanced permissions and forms to standardize data collection and improve governance.

Developed automated alert systems using Smartsheet to enhance project deadline tracking.

Created custom Smartsheet dashboards for real-time executive reporting.

Applied a robust understanding of data modeling in data warehouse environments, utilizing star schema and snowflake schema principles to structure P&C insurance data marts, improving analytics for claims, policies, and premium calculations.

Proficiently conducted data analysis on P&C insurance datasets, querying databases to extract insights on claims reserves, policy retention trends, underwriting loss ratios, and premium growth.

Created stored procedures, functions, indexes, and views to process and cleanse insurance policy, claims, and financial transactions data, ensuring regulatory compliance (NAIC) and reporting accuracy.

Developed and optimized DAX and tabular models using SQL Analysis Services (SSAS) to enhance P&C insurance reporting in Power BI, integrating key performance indicators such as loss frequency, combined ratio, and premium-to-loss trends.

Leveraged Power BI for real-time P&C insurance data analytics, collaborating with underwriters, claims adjusters, and actuaries to improve decision-making based on live claims processing, fraud detection, and catastrophe modeling.

Owned and supported operational and business performance dashboards, providing insights into home site insurance claims trends, catastrophe impact assessments (hurricanes, floods, wildfires), and policyholder behavior analytics.

Generated and published Power BI reports for P&C insurers, tracking incurred losses, claims settlement efficiency, premium adjustments, and reinsurance recoverables.

Conducted training sessions with business users in P&C insurance teams, ensuring proper understanding and utilization of Power BI dashboards for claims forecasting, policy renewals, and fraud detection.

Implemented end-to-end pipelines using Databricks, reducing processing time by 30% and improving data accuracy for P&C insurance reporting on catastrophe exposure, claim reserves, and underwriting risk segmentation.

Tools and Technologies used: SQL Server 2012, Visual Studio, SSIS, MS Office 365, Power BI Desktop, DAX, Jira, Confluence, SharePoint, MS Excel, MS Word, Agile (Scrum).

Client: Droisys, CA

Role: BI Developer Oct 2020- June2022

At Droisys, spearheaded the development of intricate reports using Microsoft Power BI, connecting seamlessly with SAP HANA, Snowflake, Teradata, Oracle, and MS-SQL as diverse data sources.

Responsibilities:

Extracted and synthesized data from various platforms such as SQL Server, SQL Server Analysis Service, Azure SQL Database, Azure SQL Data Warehouse, and Salesforce for comprehensive reporting.

Collaborated closely with Stakeholders, Business Users, System Architects, and Developers to comprehend data models and structural hierarchy for effective report design.

Served as EHR Data Integration Specialist to support reporting from multi-source healthcare and insurance datasets, including Snowflake, SAP HANA, and Oracle.

Designed Power BI reports for clinical operations, integrating medical billing, patient histories, and coverage decisions.

Utilized AI and ML models within Power BI for predicting high-risk claims and estimating treatment costs.

Worked with healthcare providers to integrate EHR data into Power BI dashboards, enabling cross-domain analysis of patient satisfaction, provider quality, and claims volume.

Built advanced Power BI reports integrated with Snowflake, SAP HANA, and Salesforce.

Used Azure DevOps for source control, CI/CD pipelines, and work tracking.

Led the customization of JIRA workflows to enhance Agile processes, integrating automation rules to minimize manual task assignments.

Developed Python scripts using JIRA REST API for bulk data updates and reporting automation, reducing admin effort by 50%.

Created structured Confluence knowledge bases for standardized documentation and long-term process sustainability.

Designed JIRA dashboards and reports for tracking sprint progress and issue resolution.

Implemented automated JIRA ticket assignments based on predefined logic to enhance efficiency.

Applied Data Analysis Expressions (DAX) to craft custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

Developed PowerPivot models and reports, publishing them on SharePoint and deploying models into SQL Server SSAS instances.

Contributed to SQL database maintenance logs, identifying issues, and presenting them to database architects for resolution.

Designed interactive Power BI reports using diverse visualizations like line charts, doughnut charts, tables, matrix, KPI, scatter plots, and box plots.

Enhanced Power BI reports through storytelling features like bookmarks, selection panes, and drill-through filters, ensuring a more engaging user experience.

Managed customer relationships developed communication processes to keep stakeholders updated on project results, and actively participated in bug analysis, error resolution, UAT, and post-production support.

Facilitated Requirements clarification using the ticketing tool "Service Now" and conducted Root Cause Analysis (RCA) for missed SLA tickets, presenting findings to management for effective communication and resolution.

Utilized Azure DevOps/Team Foundation Server (TFS) for organizational requests, progress tracking, and maintaining version control of reports and code.

Tools and Technologies: Microsoft SQL Server 2012/2014, Visual Studio, DAX, SQL, Excel, Azure, GIT, Jira, Power BI.

Client: FedEx, Memphis, TN

Role: BI Developer July 2019 - Sep2020

At Grant Thornton, I led Power BI initiatives, collaborating on project scopes, implementing data processing enhancements, and designing advanced dashboards. Utilized DAX and Power Query for accurate insights, ensuring effective decision-making and streamlined reporting.

Responsibilities:

Collaborated with stakeholders and business analysts to define Power BI project scope and deliver solutions that supported data-driven decision-making in Property & Casualty (P&C) Insurance, focusing on claims, underwriting, and policy analytics.

Created executive-level KPI dashboards to track critical P&C insurance metrics such as loss ratios, claim settlement times, premium trends, and combined ratios for C-suite stakeholders, improving strategic decision-making.

Created P&C insurance analytics dashboards using Power BI, Power Query, and DAX.

Developed Power BI solutions for insurance claims and underwriting, providing deeper insights into claim frequency, severity trends, policy retention rates, and underwriting performance for homeowners, auto, and commercial property insurance.

Built a unified claims data mart enabling faster cross-line analysis (Auto, Property, Liability, Catastrophe Claims), improving adjuster efficiency, fraud detection, and loss reserve accuracy.

Utilized DAX for complex calculations to generate dynamic insurance metrics, such as earned vs. unearned premium calculations, risk exposure scoring, and policy lapse rates, enhancing analytical accuracy and reporting flexibility.

Leveraged Power Query for advanced data transformations, ensuring clean, standardized datasets for P&C insurance reporting, including policy underwriting, reinsurance claims, and regulatory compliance (NAIC, DOI filings).

Designed narrative-driven Power BI dashboards with storytelling capabilities to communicate P&C insurance trends, loss ratios, catastrophe exposure, and underwriting profitability.

Developed paginated reports using Report Builder, focusing on key P&C insurance performance metrics such as Loss Ratio, Policy Retention Rate, Expense Ratio, and Customer Satisfaction (CSAT) to support compliance and operational reviews.

Partnered with underwriters and actuaries to perform segmentation analysis that helped refine pricing strategies based on risk factors, geographic exposure, and claim history trends.

Handled large-scale data ingestion from Azure Data Lake Storage (ADLS) to integrate diverse P&C insurance data sources, including policyholder demographics, catastrophe models, claims reserves, and third-party property risk scores.

Integrated external sources into Power BI dashboards (e.g., SQL Server, Excel, XML, third-party property risk data) to enhance underwriting and risk modeling insights for home site and commercial P&C insurance policies.

Created interactive Power BI dashboards with visuals such as scatter plots, trend lines, and stacked bars to analyze home site claims, reinsurance trends, premium adjustments, and policyholder behavior analytics.

Applied role-based security and set up alerts/subscriptions in Power BI to ensure data governance and compliance with P&C insurance regulations, securing access based on business functions (e.g., underwriters, claims adjusters, actuaries, and finance teams).

Built financial dashboards for budgeting, LOE tracking, and accounts payable, enabling P&C insurers to monitor financial performance, reserve adequacy, and reinsurance recoverables.

Automated insurance payment file processing using SSMS and Power BI, ensuring real-time financial tracking of claim payments, commissions, and premium collections.

Communicated BI migration plans and timelines to P&C insurance stakeholders, ensuring a seamless transition to Power BI platforms for policy administration, claims processing, and underwriting analysis.

Published Power BI models to the Power BI Service, managing collaborative workspaces and apps for P&C insurance professionals, including underwriters, actuaries, and claims managers.

Led user training and support during the rollout of P&C insurance BI solutions, improving adoption among claims, underwriting, and finance teams for better operational insights.

Participated in Agile/Scrum ceremonies, contributing to product backlog discussions and sprint planning for P&C insurance analytics solutions, presenting updates on claims loss forecasting, risk assessment, and fraud detection initiatives.

Implemented end-to-end pipelines using Databricks, reducing processing time by 30% and improving data accuracy for P&C insurance reporting on catastrophe exposure, claim reserves, and underwriting risk segmentation.

Tools and Technologies: Microsoft SQL Server 2012/2014, Visual Studio, SSRS, SAP-Hybris, MuleSoft, .Net, GIT, Jira, Power BI.

Client: Genems Systems, India

Role: Analyst May 2014- Feb2018

At Genems Systems, I spearheaded successful project outcomes by innovatively leading requirements gathering, analysis, and design phases. My active client engagement and meticulous approach to feasibility studies contributed to streamlined collaboration. From orchestrating scrum events to creating HTML presentations, my commitment to excellence aligns with Genems Systems' focus on delivering high-quality solutions through agile methodologies.

Responsibilities:

•Led requirements gathering, analysis, and design phases, contributing innovative ideas for optimized project outcomes.

•Actively engaged with clients daily to understand evolving business needs and foster effective communication channels.

•Prepared compelling feasibility study documents, showcasing a meticulous approach to understanding and addressing project requirements.

•Orchestrated scrum events, ensuring efficient project management and fostering collaboration within the team.

•Utilized MS Office tools for project tracking, documentation, and presentation, developing robust test scenarios and cases.

•Crafted comprehensive BRD and FRS documents, providing a clear roadmap for end-to-end project requirements.

•Developed HTML presentations using CSS & XSLT, enhancing user interfaces for improved user experiences.

•Maintained UML diagrams, meeting notes, and prototypes, ensuring thorough documentation and streamlined communication.

•Formulated Use Cases for each business requirement, optimizing them to align precisely with project objectives.

•Championed agile methodologies, applying Scrum practices, and contributing to continuous process improvement.

•Utilized tools like Jira, Confluence, and SharePoint for streamlined collaboration and documentation within the project team.

•Demonstrated adaptability by working with diverse technologies, including AWS, Mainframe, Java, SQL Server, and Angular JS.

•Proactively contributed to a holistic project approach, emphasizing communication, adaptability, and a commitment to delivering high-quality solutions.

•Crafted comprehensive BRD and FRS documents, providing a clear roadmap for end-to-end project requirements.

•Contributed to the design and development of HTML presentations using CSS & XSLT, enhancing user interfaces.

•Developed and maintained UML diagrams, meeting notes, and prototypes, ensuring thorough documentation and streamlined communication.

•Formulated Use Cases for each business requirement, optimizing them to precisely align with project objectives.

Tools and Technologies Used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012, Angular JS, HTML 5, jQuery.

Contact this candidate