Junior Data / BI Analyst and automation developer focused on healthcare operations, dashboards, reporting, workflow automation, and data quality.
I build practical analytics and internal tools that turn spreadsheets, form responses, manual follow-ups, and fragmented operational records into dashboards, reports, validation checks, and workflow systems for teams that need reliable information to make decisions.
Target roles: Junior Data Analyst | BI Analyst | Reporting Analyst | Healthcare Data Analyst | Operations Analyst
Core tools: Power BI | DAX | SQL | Google Sheets | Google Apps Script | JavaScript | HTML/CSS
Domains: Healthcare quality | Patient safety | Clinical operations | Data quality | Process improvement
My portfolio is strongest where business operations, data quality, and practical automation meet. The projects below are built around realistic healthcare and administrative workflows: KPI monitoring, reporting cadence, spreadsheet cleanup, response tracking, audit trails, and privacy-aware documentation.
What I want hiring teams to see:
- I can translate an operational problem into KPIs, data structure, dashboard flows, and usable internal tooling.
- I can work with Google Sheets, Apps Script, SQL concepts, DAX measures, and JavaScript interfaces to support BI/reporting workflows.
- I document projects with synthetic or fictitious data so the portfolio shows the work without exposing patient, employee, or institutional records.
| Project | Hiring signal | Stack / keywords |
|---|---|---|
| Healthcare Quality BI Analytics | End-to-end BI case study with synthetic healthcare data, dimensional modeling, KPI definitions, SQL queries, data quality checks, and Power BI-ready measures. | SQL, Power BI, DAX, dimensional modeling, data quality, healthcare analytics |
| Patient Safety Analytics | Patient safety dashboard for compliance indicators, safety walks, notifications, targets, and PDF-ready report pages. | Google Apps Script, dashboards, KPI reporting, patient safety |
| Clinical Operations Command Center | Operational process management dashboard with KPIs, process boards, snapshots, governance, RBAC, audit trail, tests, and CI. | JavaScript, Apps Script, workflow automation, process management, testing |
| Clinical Reporting Suite | Reporting dashboard with data quality review, administrative configuration, A4 report pages, and export-ready clinical quality reports. | reporting automation, data quality, PDF export, clinical indicators |
| Spreadsheet Intake Automation | CSV/XLS/XLSX intake flow with preview, cleanup options, keyword routing, validation, and Google Sheets import automation. | spreadsheet automation, ETL-style workflow, validation, Google Sheets |
| Patient Experience Analytics | Patient satisfaction and NPS analytics with ratings, sector breakdowns, saved filters, history charts, and manifestation tracking. | NPS, survey analytics, dashboard design, healthcare experience |
| Project | What it demonstrates |
|---|---|
| Rapid Response Triage Platform | Clinical and surgical rapid-response workflow with severity triage, administrative queue, and SLA monitoring. |
| Locker Custody Workflow | Hospital locker custody workflow with terms, audit trail, state monitoring, notifications, and operational controls. |
| Internal Communication Platform | Internal communication portal for announcements, shift notices, extensions, administration, and publication history. |
- BI and reporting: KPI design, dashboard structure, filters, summaries, export-ready views, DAX-ready measures, and decision-support reporting.
- SQL and data modeling: relational structure, joins, aggregations, validation queries, star-schema concepts, and KPI query design.
- Healthcare operations context: patient safety indicators, clinical process tracking, response workflows, reporting cadence, and privacy-aware documentation.
- Workflow automation: Google Apps Script, Google Sheets workflows, CSV/XLSX intake, validation steps, notifications, audit logs, and internal tools.
- Data quality: checks for missing values, duplicates, inconsistent dates, invalid categories, orphan keys, and unreliable operational records.
- Frontend for internal tools: JavaScript, HTML, CSS, responsive dashboards, filters, modals, tables, charts, and practical user interfaces.
Junior Data Analyst | BI Analyst | Reporting Analyst | Healthcare Data Analyst | Operations Analyst | Data Quality Analyst
Target areas:
Healthcare Analytics | Business Intelligence | Operational Reporting | Dashboard Development | Workflow Automation | Process Improvement
Location focus:
Lubbock, Texas | Remote-friendly U.S. teams | Healthcare and operations-driven organizations
Public repositories use synthetic, fictitious, or anonymized sample data. They are intended to demonstrate structure, workflow design, reporting logic, automation patterns, and BI thinking without exposing real patient or operational records.
- LinkedIn: linkedin.com/in/lukyam1
- Email: lukyam.madeira@gmail.com