Modest Kamgang

Data Analyst Bi Developer @MedStar Health

US

Responsibilities: Created and deployed dynamic Tableau and Power BI dashboards using stack bars, scorecards, bar graphs, scatter plots, geographical maps, heat maps, bullet charts, and Gantt charts to present key insights for strategic decision-making. Designed interactive dashboards showcasing critical KPIs such as patient wait times, bed occupancy rates, and readmission rates, enabling healthcare organizations to optimize operational performance. Developed engaging Tableau and Power BI demos that highlighted the platforms\' capabilities and potential use cases to stakeholders and clients. Utilized Power BI’s DAX functions to create complex calculations, measures, and calculated columns, enhancing the depth and accuracy of business intelligence reports. Integrated multiple data sources into Power BI, including SQL databases, Excel files, and cloud-based data, creating comprehensive and unified reports. Created custom visuals in Power BI using Python scripts to meet specific business needs, extending the platform’s native capabilities. Authored complex SQL queries using advanced concepts like Joins, stored procedures, CTEs, subqueries, and window functions to extract, transform, and analyze data with precision. Leveraged Snowflake to extract, correlate, and analyze electronic health records (EHR) for population health management, significantly improving healthcare delivery. Conducted rigorous testing of SQL queries to validate the accuracy of clinical trial data, ensuring compliance with regulatory standards. Monitored query performance in real-time, proactively resolving issues to ensure the timely retrieval of critical healthcare information. Developed stored procedures and functions in SQL for automating repetitive tasks, reducing manual effort and increasing efficiency. Created complex ETL pipelines using Python, integrating data from various sources, and ensuring smooth data flow into analytical environments.

University of Buea

Bachelor's degree