Yin Yu Lam Email & Phone Number

• Designed interactive Tableau dashboards to communicate findings on complex clinical and operational data gathered from multiple health organizations
• Optimized data collection, cleaning, manipulation and analysis of complex healthcare data, ensuring data quality and accuracy for reporting on project Key Performance Indicators
• Improved existing data collection tools by standardizing charts audit workflow and utilizing Excel formula and VBA programming to minimize user errors
• Developed quantitative data management and quality assurance strategy for the team to support data driven decision-making
• Achieved more than 50% increase in resource efficiency by automating data upload to MS SQL Server using an SSIS package in MS Visual Studio
• Trained and supervised new staff and students on data collection and analysis

Southfield, Michigan

• Managed projects timeline and communication with clients to ensure timely delivery of quality analytic products
• Delivered healthcare revenue cycle data visualizations in Tableau and Excel, providing insights for operational improvements, establishing best practices and driving revenue lift for clients
• Collected requirements, designed and developed performance tracking reports that serve as effective staff management tools

Southfield, Michigan

• Performed ad-hoc analyses such as staffing and productivity analyses, providing actionable insights to partners on-site
• Performed data extraction, transformation, cleaning and loading to Aurora MySQL databases using Alteryx
• Utilized VBA programming to improve and redesign existing Excel dashboards, replacing manual processes to reduce user errors

Ann Arbor, Michigan

• Improved enterprise metadata resources by developing an Information Management Glossary, contributing to the realization of the Enterprise Data Analytics program
• Developed a Semantic MediaWiki site to enable content collaborations on the Information Management Glossary
• Enhanced the Glossary’s user interface by constantly researching for extensions that can help ease processes, and create user manual to guide users through the processes
• Interacted with stakeholders from different functional areas to understand core concepts and terminology used within organization, promoting effective communication across enterprise

Shanghai City, China

• Interviewed physicians and employees from various departments to learn their views on the hospital information system, and to understand how the information system was designed to incorporate their workflows
• Gained insights into factors that need to be accounted for when designing an information system for a hospital, and how integration between systems was done to ensure seamless data transfer
• Shadowed IT department members to observe how they resolve users’ problems, understand the IT department roles and how it is supporting the hospital operations

Dearborn, Michigan

• Audited pension benefit calculations with strong understanding in provisions and governing rules of various retirement plans
• Conducted training on interpreting retirement documents, understanding survivorship options, and auditing benefit calculations
• Analyzed retiree data of a major automotive company and identified trend from data to assist with project scoping

Bachelor Of Science (B.S.), Actuarial Mathematics, Minor In Computer Science

Master'S Degree, Health Informatics

Activities and Societies: Ann Arbor Data Dive