SQL & data analysis
T-SQL for querying, combining, and analyzing data, with attention to accuracy and query performance.
I turn complex healthcare data into validated SQL reporting, Power BI dashboards, and decision tools for quality, utilization, care management, and operations.
Based in California · Seeking fully remote healthcare analytics & BI opportunities

I’m Hany Elgayar, a healthcare analyst with experience at Inland Empire Health Plan and Care1st Health Plan. I translate complex health plan data into validated datasets, dashboards, and reporting for clinical, operational, and regulatory teams, including California Medi-Cal and Medicare programs. Earlier, I spent more than seven years at Southern California Edison in business and project analysis for a California utility. Outside work, I explore entrepreneurship, publishing, and digital experiences.
My toolkit connects data preparation, analysis, and visualization to support practical business conversations.
T-SQL for querying, combining, and analyzing data, with attention to accuracy and query performance.
Power BI and DAX for dashboards, reporting logic, and accessible visual explanations.
California Medi-Cal, Medicare Advantage, and Medicare-Medicaid program analytics, with attention to regulatory requirements, quality, utilization, and operational insight.
SAS Enterprise Guide and Python for data preparation, exploration, and repeatable analysis.
I use generative AI to prototype digital products, improve content and documentation workflows, and explore practical automation. I check outputs for accuracy, refine the process, and protect sensitive information.
University of California, Irvine — University Extension
Completed February 2010 · 175 hours of evaluated learning
Developed SQL, SAS, Power BI, SSRS, and SSIS reporting for clinical quality, care management, provider operations, and California Medi-Cal and Medicare program requirements. Led work from requirements through validation, UAT, documentation, and production support.
Supported health plan analytics on contract before joining IEHP full-time.
Produced utilization, claims, authorization, and operational reporting for Medicare Advantage and Medicare-Medicaid product lines, including Cal MediConnect. Translated program and regulatory questions into SQL analyses and repeatable reports.
Across more than seven years, tracked state-mandated initiatives, energy efficiency and usage, and California Public Utilities Commission (CPUC) related utility reporting requirements. Built dashboards and analyses, supported regulatory data requests, documented Tableau reports, and reconciled CRM data to improve reporting quality.
Project management coursework through the University of California, Irvine Division of Continuing Education.
Three examples from my work at Inland Empire Health Plan: making member information easier to find, monitoring assessment follow-up, and validating a reporting transition. These summaries describe my contribution without displaying confidential records or internal systems.
Problem: Intake and screening teams needed a comprehensive view of member health, but information was spread across multiple systems.
My contribution: Created and maintained a daily refreshed Power BI member-search tool that brought together ACG scores, medications, emergency room visits, Total Cost of Care, and other health and utilization information.
Use: Gave regional Behavioral Health and Care Management teams an accessible member snapshot with supporting details for intake, screening, and further review. My 2022 project record documented use by approximately 30 organizational groups.
Focus: Bringing fragmented information together so operational users could understand the member’s overall health picture, identify relevant concerns, and examine the details needed for their work.
Problem: Member Services and Care Management needed consistent reporting to identify members requiring Health Risk Assessment follow-up.
My contribution: Led Day 46 and Day 89 monitoring from January 2020 through January 2025, combining eligibility, outreach, and assessment information with repeatable reporting rules.
Validation: Reconciled reporting discrepancies, checked assessment and outreach status, and supported QA, user acceptance testing, and recurring production reporting.
Use: Gave teams visibility into follow-up exceptions and completion status for operations and regulatory oversight.
Problem: A change in medical and pharmacy reporting files required checks that replacement datasets were comparable to the previous sources.
My contribution: Compared older and replacement datasets, identified an incorrect claims-file selection, and investigated differences in the reporting inputs.
Validation: Checked source selection and completeness to assess whether the new process omitted data.
Use: Supported a more reliable transition through documented comparisons and issue resolution.
Selected experience also includes behavioral-health equity analysis and validation of emergency-department utilization rates per 1,000 by region, race, and ethnicity. Employer reports and member-level data remain confidential.
Owner and Independent Projects
Alongside my professional analytics work, I manage an independent e-commerce business across Shopify, Etsy, and Printify, applying data analysis to storefront consistency and the customer purchase journey.
Professional recommendations
Colleagues, managers, and professional contacts describe my analytical work, integrity, teamwork, and leadership during my Edison-era career. These historical endorsements complement the healthcare analytics projects and technical skills presented elsewhere on this site.
Hany is professional, dedicated and exhibits a strong sense of integrity. He is passionate about his work as a business analyst and takes pride in what he does. Hany consistently demonstrates an excellent work ethic and is an expert in handling complex, technical and confidential information. He is personable, a great team player, and a person of great integrity. I highly recommend Hany for an information management position.
I had an opportunity to work with Hany as part of the Partnership Data Team in which he not only utilized his superior analytical skills but also set the bar in his responses to Local Governments. Hany's enthusiasm created an infectuous spirit of teamwork which carried the team through various challenges.
Hany has assisted me on several projects providing critical data that cities would need to meet federal requirements. His interest in compiling, formatting and timeliness resulted in the information being packaged so minimal time was spent by the cities, integrating it into their projects.He followed up to ensure customers were satisfied with his work. Without reservation, I recommend his skills as an Analyst.
Not found in the current LinkedIn received-recommendations list. Attribution and relationship are from the saved document; not independently confirmed.
Hany is a person of great integrity and work ethic. He is resilient, and has strong self-confidence. I had the pleasure to work with Hany as his manager in Community Involvement department. He is action oriented, intelligent, and ambitious; an ideal employee to manage. He is well-respected by many within SCE. I highly recommend him with any project or planning endeavor.
Saved document name: Monica Estrada, MPA
Hany is collaborative, very responsive and demonstrates a strong commitment to follow-through and seeing assignments to a successful conclusion. In addition, Hany has worked tirelessly with my team to create, lead, expand and sustain the Cultural Exchange diversity group, an employee Resource group, within the Southern California Edison company fostering a better understanding of various cultural ethnicity and
backgrounds as well as promoting personal and professional growth among the team members. He performs his organizational duties with a high degree of excellence and professionalism.
Saved document name: Kaz Yeghiazarian
I strongly recommend my colleague Hany for employment. I have had the pleasure of working alongside him for 3 years at SCE, where he has been entrusted with a great deal of responsibility. I have had the opportunity to observe Hany's professional skills as well as interpersonal style. He is consistently pleasant, and takes on all assignments with enthusiasm and dedication. I wish that all my co-workers had his attitude. Regardless of deadlines or other pressure, Hany always delivers. His superior organizational skills make him the consummate multi-tasker.
Hany has a strong reputation as a team player who interacts well with others and produces good work product. He is well-respected by many individuals within the company.
Saved document name: Russell Lieu
I met Hany through the UCI Project Management program offered at Southern California Edison. During the program period I got to know Hany very well. I strongly recommend my colleague, Hany, for employment.
I have had the opportunity to observe Hany's professional skills as well as interpersonal style. He is consistently pleasant, dedicated, intelligent, and most of all the ability to relate with others effortlessly. He is a true team player and a leader to be reckon with. -LDA
I've known Hany for over 10 years.. he is a conscientious, dedicated worker with the highest level of ethics. He's great with people and he is results oriented. I'd recommend him with any project or planning endeavor.
I know Hany Elgayar for many years and I always found him to be professional, courteous and dedicated in whatever he is working on. He is creative, honest leader, and an excellent advisor. Hany always achieves and exceeds the goals requested of him. I do not hesitate to recommend him very highly to anyone.
Saved document name: Nader Mansour
I've known Hany for over 7 years and I know that Hany is a hardworking and smart person. He always tries to overcome any obstacles to achieve the desired results.
Hany is a diligent, loyal, hard worker who is a pleasure to be around. I highly recommend him as a contract worker or employee. He is somebody you can trust.
Hany is a very dedicated employee. While I was his SES3 in BCD, Hany was always eager to talk about safety for his group and be an example of safe work behaviors. I am fortunate to have worked with him in that department.
2014 recommendation · LinkedIn checked Nov 14, 2026
I know Hany El Gayar for more than 25 years and I always found him to be professional, courteous and dedicated in whatever he is working on. He is creative, honest leader, and an excellent advisor. Hany always achieves and exceeds the goals requested of him. I do not hesitate to recommend him very highly to anyone.
Retained from your current website and verified on LinkedIn. This is a distinct second text from the same person, not another recommender, and does not appear in the saved document.
Outside my healthcare work, I build digital products and explore cultural storytelling through independent projects.
An Egyptian-inspired brand exploring heritage through apparel, gifts, artwork, and creative products.
Explore the storeA Sudoku app project combining an interest in puzzles with digital product creation.
View on the App StoreI’m seeking fully remote healthcare analytics, business intelligence, and analytical development opportunities open to California residents. Explore my work, view my résumé, or contact me to discuss a role.