Healthcare Decision Support
Built and maintained reporting products used for organizational planning and Ministry-facing performance communication.
Data Analytics Portfolio
Raphael Bonifacio Dias
Decision Support Analyst II | Sudbury, Ontario
Decision Support Analyst focused on turning complex data data into clear, actionable insight.
I work across SQL, Power BI, and SSRS reporting to support evidence-based decisions in healthcare operations and funding strategy.
About
Applied analytics with operational context
My background combines research training, market and social data analysis, and formal business analytics education. That foundation now supports applied healthcare decision support work where data quality, reporting reliability, and clear communication drive operational and strategic outcomes.
Reporting Efficiency
Reduced reporting timelines in academic and healthcare settings through query optimization and workflow redesign.
Applied Problem Solving
Delivered practical analytics work across competitions, institutional projects, and operational reporting contexts.
Experience
Recent roles and measurable scope
Decision Support Analyst II
Health Sciences North / Horizon Sante-Nord | Sudbury, ON
Jul 2025 - Present
- - Manage quality assurance, data integration, and KPI development using SQL, Power BI, and SSRS paginated reporting.
- - Extract and analyzed complex clinical and operational datasets to improve reporting reliability and process efficiency.
- - Provide analytical guidance for Health System Funding Reform workstreams and aligned indicators with strategy.
Decision Support Analyst I
Health Sciences North / Horizon Sante-Nord | Sudbury, ON
Jul 2024 - Jul 2025
- - Analyzed and presented data to support strategic planning and evidence-based decision-making across departments.
- - Supported data integrity improvements and recurring reporting needs for organizational and Ministry stakeholders.
Student Intern - Planning and Institutional Research
Cambrian College | Sudbury, ON
Nov 2023 - Apr 2025
- - Cut report generation timelines from months to approximately one week by optimizing algorithms and data models.
- - Developed Flask-based reports and Power BI dashboards used in program evaluation by institutional stakeholders.
Market Research Support Executive
iDeas Unlimited | Remote
May 2021 - Jun 2022
- - Led NLP and social media analytics activities to extract qualitative insights and trend signals.
- - Synthesized interview and survey outputs into concise market and product-positioning recommendations.
Selected Projects
Case-study snapshots
Healthcare Performance Reporting Framework
Hospital decision support environment- Problem
- Operational and funding decisions relied on fragmented metrics with inconsistent refresh and validation.
- Approach
- Designed structured reporting layers, aligned metric definitions, and implemented QA-driven refresh routines for recurring dashboards and reports.
- Outcome
- Delivered a stable decision-support reporting cadence and improved trust in recurring performance metrics.
SQLPower BISSRSData Validation
BlastCaptain Analytics Challenge
Applied analytics competition- Problem
- Teams needed a practical way to extract measurable blast insights from field video sources.
- Approach
- Built a Python/OpenCV pipeline to detect and summarize key blast-event observations for analysis.
- Outcome
- Secured 3rd place by delivering a concise analytics pipeline and communicating outcomes clearly.
PythonOpenCVData ProcessingPresentation
Transportation Management Systems Market Analysis
Independent research project- Problem
- Stakeholders needed a structured view of TMS trends, adoption drivers, and vendor landscape signals.
- Approach
- Combined market research synthesis and comparative analysis into a decision-oriented report format.
- Outcome
- Produced an actionable summary used to support technology and strategy discussions.
ResearchData AnalysisReportingVisualization
View artifactClimate Risk and Facility Maintenance Dashboard
Applied academic project- Problem
- Facility planning teams lacked a simple, data-backed view of climate-related maintenance risk.
- Approach
- Developed an interactive dashboard combining forecast and facility context to guide maintenance prioritization.
- Outcome
- Demonstrated a practical framework for translating environmental data into maintenance action.
Power BIPythonPredictive AnalyticsData Modeling
Services
Tiered packages
CAD 500
Reporting Starter
A focused reporting package to answer one clear business question with clean, trusted metrics.
From CAD 1,200
Growth Reporting
A broader reporting setup designed to improve recurring visibility across core operational or business performance areas.
From CAD 2,500
Decision Intelligence
A higher-touch package combining KPI architecture, BI delivery, and implementation guidance for stronger decision support.
Skills / Toolkit
Structured by function
Data Analysis
- SQL
- Python
- Pandas
- Statistical Analysis
BI & Reporting
- Power BI
- SSRS
- KPI Design
- Operational Reporting
Databases
- SQL Server
- PostgreSQL
- Data Modeling
Visualization
- Power BI
- Tableau
- Data Storytelling
Development & Automation
- Git
- Streamlit
- Flask
- Workflow Automation
Education / Certifications
Foundations relevant to current work
Business Analytics - Graduate Certificate
Cambrian College
Applied analytics, BI reporting, and business problem framing for real-world operational settings.
Project Management - Graduate Certificate
Cambrian College
Planning, execution, and stakeholder communication practices that complement analytics delivery.
Post Graduate Diploma in Data Science
International Institute of Information Technology
Core data science methods including machine learning, data preparation, and analytical modeling.
Contact