Data Analyst: SQL, Snowflake, Power BI, Tableau

MODEST KAMGANG

Data Analyst SQL Snowflake Power BI Tableau

Fort Washington, MD 20744 **********@*****.*** 240-***-****

PROFESSIONAL SUMMARY

Data Analyst with 6+ years of experience transforming complex data into actionable insights that improve reporting, operations, and decision making. Strong background in SQL, Snowflake, Power BI, Tableau, Python, and ETL development, with proven experience building dashboards, optimizing queries, automating recurring reports, and developing scalable data models. Known for translating business needs into clear reporting solutions that improve efficiency, increase visibility, and support leadership with reliable, data driven insights.

TECHNICAL SKILLS

Languages: SQL, Python, R

BI & Visualization: Power BI, Tableau, QlikView

Data Platforms: Snowflake, BigQuery, SQL Server, PostgreSQL, MySQL, Oracle

ETL & Data Engineering: Azure Data Factory, Dataform, Power Query, Stored Procedures, Scheduled Tasks, ETL Pipeline Development

Cloud & Tools: GCP, Databricks, Excel, SharePoint, Teams, Jira, Confluence, Postman API

Analytics: Dashboard Development, KPI Reporting, Data Modeling, Data Validation, Data Cleaning, Predictive Analysis, Query Optimization

PROFESSIONAL EXPERIENCE

MEDSTAR HEALTH (Dunamis Infotech), MD, USA

Data Analyst

June 2021 to February 2026

• Built and optimized complex SQL queries in Snowflake to support KPI reporting on admissions, discharges, active cases, overdue follow ups, and patient flow trends.

• Developed and maintained semantic tables and reporting models by integrating staging, core, and dimensional data layers to improve consistency and reliability across operational reporting.

• Automated recurring data loads and reporting workflows using stored procedures, scheduled tasks, and ETL pipelines, reducing manual effort by 30%.

• Designed interactive Power BI and Tableau dashboards to track operational and clinical performance, giving leadership visibility into patient wait times, bed occupancy, readmissions, and other key business metrics.

• Improved reporting performance by refining joins, filters, and partitioning strategies, helping reduce query latency and scan cost by 30 to 60% in BigQuery based analytics environments.

• Implemented partitioning, indexing, and query optimization techniques in Azure Synapse, reducing reporting query runtime by 40%.

• Partnered with clinical, finance, and operations stakeholders to gather requirements, validate outputs, and translate business questions into actionable insights.

• Supported Epic reporting through ad hoc and recurring reports using Clarity Reports, Reporting Workbench, and SlicerDicer for clinical leadership and operations teams.

• Built SQL and Python based ETL pipelines to automate transformations and streamline reporting workflows across multiple healthcare and operational data sources.

• Created technical documentation for reporting workflows, data models, and dashboard logic to improve process transparency and continuity across teams.

Environment: Tableau, Power BI, Snowflake, SQL, T SQL, Excel, Azure Data Factory, Python, SharePoint 365, Teams, Postman API

ASSURANCE HEALTHCARE, MD, USA

Data Analyst / Tableau and Power BI Developer / Data Scientist

February 2020 to June 2021

• Developed interactive Power BI and Tableau dashboards to visualize patient admissions, readmissions, demographics, treatment outcomes, and financial metrics for clinical and administrative teams.

• Leveraged Epic EHR and hospital data to support reporting, trend analysis, and operational decision making across healthcare teams.

• Optimized Power BI reports by improving data models, report interactivity, and backend query performance for a more efficient user experience.

• Used Python and R for data analysis, automation, and predictive modeling to support hospital operations and patient care planning.

• Conducted data integrity checks between Epic and external systems to validate patient demographics, encounter data, and billing records.

• Integrated data from multiple internal and external sources to build comprehensive reporting solutions for business and clinical stakeholders.

• Collaborated with healthcare teams to identify reporting needs, improve workflows, and deliver accurate, timely insights.

Environment: Databricks, Power BI, Snowflake, Tableau, SQL, T SQL, Excel, AWS, SharePoint 365, Python, JSON, Epic EHR

PF TECHNOLOGY, INC, MD, USA

Junior Data Scientist / Power BI Developer / QlikView Developer

April 2017 to January 2020

• Supported source to target mapping, business rules definition, and data alignment for healthcare reporting and analytics initiatives.

• Performed data validation and reconciliation across multiple systems to improve the accuracy and reliability of reporting data.

• Used SSIS for ETL, data migration, and data modeling to support reporting and analytical workflows.

• Developed reports and visualizations in Power BI, QlikView, and R to communicate healthcare performance metrics and trends to stakeholders.

• Applied statistical and machine learning techniques in R and Python to support predictive modeling and healthcare outcome analysis.

• Optimized dashboard performance through incremental data loads and reusable measures, reducing dashboard load time by 40%.

• Wrote T SQL queries to extract, transform, and analyze healthcare data from multiple systems and warehouses.

Environment: Python, R, ETL, SharePoint 365, QlikView, Power BI, T SQL, SQL, Excel, Stata

EDUCATION & CERTIFICATIONS

Education

Bachelor of Science in Computer Science

Certifications

Power BI Data Analyst Certification

Tableau Desktop Certification

Contact this candidate