SQL & data analysis
T-SQL for querying, combining, and analyzing data, with attention to accuracy and query performance.
Hany Elgayar · Healthcare Analyst · Developer · Programmer
Healthcare data.
Clearer decisions.
I’m a healthcare data analyst, developer, and programmer. I build SQL reporting, Power BI dashboards, and repeatable workflows that help teams understand quality, utilization, and operations.
Based in California · Focused on healthcare analytics & BI
T-SQLPower BI & DAXSAS Enterprise GuidePythonHealthcare reporting
01 / About me
An analyst’s curiosity.
A builder’s mindset.
I’m Hany Elgayar, a healthcare analyst with experience at Inland Empire Health Plan and Care1st Health Plan. My professional focus is translating complex health plan data into validated datasets, useful dashboards, and clear reporting for clinical and operational teams. Outside healthcare, I explore entrepreneurship, publishing, and digital experiences through my own projects.
02 / Areas of focus
From raw data
to a clearer picture.
My toolkit connects data preparation, analysis, and visualization to support practical business conversations.
Business intelligence
Power BI and DAX for dashboards, reporting logic, and accessible visual explanations.
Healthcare reporting
Health plan analytics experience and an interest in quality, population health, and operational insight.
Analytical workflows
SAS Enterprise Guide and Python for data preparation, exploration, and repeatable analysis.
03 / Professional journey
Experience in healthcare.
April 2019 — July 2026
Full-time
Full-time
Inland Empire Health Plan
Healthcare AnalystDeveloped SQL, SAS, Power BI, SSRS, and SSIS reporting for clinical quality, care management, provider operations, and regulatory readiness. Led work from requirements through validation, UAT, documentation, and production support.
November 2018 — March 2019
Contract
Contract
RCM Technologies · IEHP assignment
Healthcare AnalystSupported health plan analytics on contract before joining IEHP full-time.
April 2017 — May 2018
Full-time
Full-time
Care1st Health Plan
Healthcare AnalystProduced utilization, claims, authorization, and operational reports; translated business questions into SQL analyses and repeatable reports.
04 / Selected healthcare work
Examples from practice.
Project summaries from my professional experience. Source data and employer dashboards are confidential, so these descriptions explain the analytical approach without displaying member records.
Health equity dashboard
Question: Where do emergency-department utilization patterns differ by region, race, and ethnicity?
Approach: Validated per-1,000 utilization rates and built dashboard-ready views to communicate geographic disparities.
Use: Supported discussions about trends and possible quality-improvement priorities.
HRA / DSNP monitoring
Question: Which members need outreach or assessment follow-up?
Approach: Automated Day 46 and Day 89 outreach and completion reporting with repeatable business rules and validation.
Use: Improved follow-up visibility, consistency, and audit readiness.
Provider directory reporting
Question: How can regulatory directory reporting be accurate and repeatable?
Approach: Enhanced stored procedures and paginated reports, reconciled source data, and investigated exceptions.
Use: Supported timely provider-directory workflows.
05 / Beyond the dashboard
Ideas made tangible.
Outside my healthcare work, I build digital products and explore cultural storytelling through independent projects.
Pharaohs Pride USA
An Egyptian-inspired brand exploring heritage through apparel, gifts, artwork, and creative products.
Explore the store ↗Pharaoh Sudoku
A Sudoku app project combining an interest in puzzles with digital product creation.
View on the App Store ↗Looking ahead
Better questions.
More useful answers.
I’m interested in remote healthcare analytics, business intelligence, and analytical development opportunities. Explore my work, download a concise résumé, or connect with me on LinkedIn.
What I bring to the work
- Experience in health plan environments
- A practical SQL and BI toolkit
- Curiosity across data and digital products
- A focus on clarity and useful reporting