Data Analyst Power Bi

Mahesh Konduri

Mail: *****************@*****.*** Contact: +1-234-***-****

Professional Summary:

● Results-driven Senior Data Analyst with 4+ years of experience in data extraction, transformation, and analysis, with a focus on healthcare provider and network data.

● Proficient in SQL, Python, Tableau, and Power BI, with a strong background in database management and business intelligence reporting.

● Experienced in healthcare data analytics, including claims processing, provider network configuration, reimbursement validation, and Facets system analysis.

● Skilled in writing complex SQL queries to extract and validate healthcare provider agreements, claims adjudication, and payment accuracy.

● Strong expertise in network and agreement configuration in Facets, ensuring accurate provider reimbursements and claims adjudication.

● Ability to validate agreement setups using claims testing, SQL queries, and Excel to ensure compliance with managed care policies.

● Experienced in data validation, process improvement, and troubleshooting issues related to healthcare configurations and provider agreements.

● Strong communication skills, adept at collaborating with cross-functional teams including business configuration, claims processing, and IT teams.

Technical Skills:

Database & Querying: SQL (MySQL, MS SQL Server, PostgreSQL) Healthcare Data & Systems: Facets, Claims Processing, Provider Network Data, Managed Care Systems BI & Data Visualization: Power BI, Tableau, MS Excel (Pivot Tables, Power Query) Programming & Data Processing: Python (Pandas, NumPy, Matplotlib), R Data Management: ETL, Data Cleaning, Data Transformation, Data Validation Testing & Quality Assurance: Unit Testing, Regression Testing, Data Quality Audits Tools & Collaboration: Jira, Confluence, Git, Slack Work Experience:

State Farm Agu 2023 - May 2024

Role: Data Analyst

Responsibilities:

● Developed and optimized SQL queries to extract, clean, and analyze complex insurance and claims-related datasets.

● Built Power BI and Tableau dashboards, enabling real-time monitoring of claim trends, provider payments, and agreement compliance.

● Ensured data accuracy and validation for insurance claims, improving claims adjudication efficiency.

● Collaborated with business teams to design data models and reports for provider network management.

● Conducted exploratory data analysis (EDA) to identify discrepancies in claims processing, leading to 20% faster resolution times.

● Integrated large datasets from multiple sources, ensuring seamless ETL processes and data pipelines.

● Implemented data quality frameworks, reducing errors in claims processing and provider agreements by 25%.

● Led unit testing and UAT validation of claim adjudication systems, ensuring system integrity.

● Supported cross-functional teams in improving business intelligence capabilities and healthcare data reporting.

● Recognized with the "Data Excellence Award" for optimizing SQL query efficiency and data pipeline automation.

HSBC Feb 2019 - Oct 2022

Role:Junior Data Analyst

Responsibilities:

● Analyzed provider network data to identify patterns in claims processing and reimbursement trends.

● Optimized SQL scripts for data extraction, reducing execution time by 30%.

● Automated recurring reports for provider contract validation, saving 15+ hours per month.

● Developed Python scripts for data cleaning, improving data accuracy in healthcare risk analysis projects.

● Conducted network and provider agreement audits, ensuring compliance with managed care policies.

● Created data-driven insights to reduce operational inefficiencies in claims processing by 15%.

● Tested provider agreement configurations, ensuring proper adjudication of claims using SQL.

● Implemented predictive analytics models to detect potential payment anomalies in provider reimbursements.

● Assisted in data migration projects, moving legacy reports to modern BI tools like Power BI and Tableau.

● Collaborated with IT teams to enhance database performance and SQL query optimization for large datasets.

Education:

● Master's in Business Analytics, Kent State University, Kent, Ohio, USA

● MBA in Marketing, Gems B School, Bangalore, India

● Bachelor's in Mechanical Engineering, JNTUH University, Hyderabad, India Key Achievement:

● Optimized SQL queries for provider network validation, reducing claims processing errors by 30%.

● Led a Facets configuration audit, identifying and resolving 95% of discrepancies in provider agreements.

● Automated agreement validation reports using SQL and Python, reducing manual processing time by 40%.

● Improved data governance processes, increasing provider contract accuracy by 99%.

● Migrated 50+ legacy reports to Power BI, enhancing data-driven decision-making and improving efficiency by 25%.

● Designed claims testing framework that ensured 100% compliance with reimbursement policies.

Contact this candidate