Kewei Zhang

Internship Overview

During my internship at EMRTS, I gained hands-on experience in the healthcare technology industry. I worked on multiple projects involving software development, data analytics, database design, and enterprise system development. Through these projects, I learned how healthcare information systems support operational excellence and decision-making.

Initial Internship Experience

In my initial internship experience, I completed several small projects, such as the State Capitals project where I wrote a program that retrieves data from an external API and generates a clean JSON file. I also implemented a BFS solution to the gallon-bucket problem, modeling states and using a queue to explore all valid configurations. In parallel, I gained a deeper understanding of the domain of healthcare data systems. I learned how improper payments arise in claims processing and how fraud, waste, and abuse detection relies on finding ways to effectively identify anomalies across structured claim fields.  This realization helped me understand the importance of accuracy in real-world information and data systems, especially those that handle sensitive data.

Second Internship Experience

During my second internship term, my experience expanded to healthcare data systems. I worked on several larger-scale projects. One major project involved designing a healthcare provider exclusion database using Prisma and PostgreSQL. I also developed a healthcare provider lookup system using NPPES NPI data and NUCC taxonomy data. Another significant project focused on Medicaid enrollment and expenditure forecasting, where I built and compared different forecasting models for enrollment and expenditure projections.

Recent Work

My most recent work focused on healthcare claim processing and EDI generation. I developed a CMS-1500 to X12 837P conversion workflow that extracts claim information from Django models, transforms the data into standardized formats, validates required fields, and generates X12 EDI transactions.

Conclusion

Overall, this internship transformed my approach to programming. I moved from writing isolated programs to designing dynamic systems composed of interconnected components. I also strengthened my skills in Python, Django, PostgreSQL, Prisma, database modeling, ETL pipelines, data analysis, forecasting, and healthcare interoperability standards. The skills that I acquired throughout this internship will directly inform my future work in computing and information systems.