Power Bi Developer

Sai Charan SQL BI Developer Franklin TN 937-***-**** LinkedIn

Professional Summary

Highly skilled and results-oriented SQL/BI Developer with over 5 years of experience designing, developing, and supporting enterprise data solutions in healthcare and financial domains. Expert in building scalable ETL/ELT pipelines, dimensional data models (Star, Snowflake), and modern data architectures using Microsoft SQL Server and Azure cloud services (Azure Synapse, ADF). Proficient in end-to-end data integration, visualization, and analytics with Power BI, Tableau, SSIS, and T-SQL, with a proven track record of creating secure, high-performance, and HIPAA-compliant BI solutions.

Technical Skills

Databases: MS SQL Server (2008R2-2019), PostgreSQL, Oracle, MySQL, DB2

Cloud Platforms: Azure Synapse Analytics, Azure Data Factory (ADF), Azure SQL Database, Azure Blob Storage, Power BI Embedded

BI & Visualization: Power BI, Tableau, SSRS, SSAS (Tabular, Multi-dimensional)

Data Integration: SSIS, DTS, REST APIs

Languages: T-SQL, Python, DAX, MDX, .NET, HTML, XML

Tools: Visual Studio, SQL Server Management Studio (SSMS), GitHub, PowerShell, ER/Studio, DBeaver

Professional Experience

Molina Health Care CA, USA

SQL / Power BI Developer Mar 2023 - Present

Led the migration of a legacy on-premises data warehouse to Azure, implementing automated ETL pipelines with Azure Data Factory that reduced data processing time and infrastructure costs.

Designed and developed optimized Star and Snowflake Schema data models to support dimensional reporting and analytics across healthcare claims (EDI 837/835) and clinical data.

Engineered and maintained robust T-SQL and Python-based data pipelines to transform large datasets, enabling real-time Power BI dashboards for operational performance and patient outcome analysis.

Utilized advanced query tuning techniques with SQL Server Profiler to resolve performance bottlenecks, significantly reducing query execution time for critical reports.

Implemented a hybrid cloud architecture using Azure Synapse Analytics and Azure Data Lake to enhance data retrieval scalability and reporting performance.

Developed advanced SSIS packages and Python scripts for automated data ingestion from FTP servers, incorporating error handling and logging to ensure data integrity.

Ensured HIPAA compliance by implementing advanced security measures, including role-based access control (RBAC) and data masking in BI solutions.

Worked in Agile/Scrum teams to translate business requirements into secure and performance-tuned BI deliverables, managing source control and CI/CD pipelines with GitHub and Azure DevOps.

UnitedHealthCare NJ, USA

Business Intelligence Developer Sep 2022 - Feb 2023

Designed and implemented a data warehouse solution to aggregate data from multiple healthcare systems (EHR, medical imaging, billing) using SSIS, enabling unified reporting across departments.

Developed advanced SSRS and Power BI dashboards for clinical operations, tracking patient outcomes, treatment efficacy, and readmission rates to improve patient care and reduce costs.

Integrated predictive analytics into Power BI dashboards using Python machine learning models to forecast patient readmission risk and support proactive healthcare intervention.

Ensured HIPAA compliance by implementing encryption, data masking, and RBAC across all BI processes and reporting systems.

Standardized healthcare data using HL7 and FHIR formats and analyzed diagnosis/procedure patterns with ICD-10 and CPT codes, enabling cross-system reporting and population health analytics.

Created cost-effectiveness models in SQL Server to identify more affordable care pathways and implemented validation rules to reduce billing discrepancies and improve reimbursement rates.

Developed a real-time Power BI solution to monitor patient metrics and detect abnormal trends, reducing risk through proactive clinical response.

Genpact HYD, India

SQL Server Developer Jun 2018 - Jul 2021

Designed and deployed interactive Power BI dashboards for financial risk analysis, integrating advanced DAX, R scripts, and SAP data sources for predictive analytics.

Led the development of highly optimized SSIS-based ETL workflows, efficiently processing large financial datasets (up to 1TB) with minimal downtime.

Tuned complex SQL queries using advanced techniques like CTEs and window functions, improving report performance by 65% and reducing execution times.

Implemented SSAS data models using Star and Snowflake schemas, enhancing reporting efficiency and analytical flexibility for financial KPIs.

Automated data validation in SSIS and implemented row-level security (RLS) in SSRS to ensure data accuracy, consistency, and controlled access for sensitive financial information.

Conducted performance audits on large databases, optimizing indexing and partitioning strategies to improve system reliability.

Developed customized SSRS reports and custom visualizations in Power BI to meet specific financial reporting needs.

Collaborated with data science teams to integrate predictive models into Power BI dashboards, helping to forecast financial trends.

Education

Masters in Computer Science – University of Dayton 2022

Bachelors in Electronics and Communication Engineering – JNTU Hyderabad 2018

Contact this candidate