Sunny Pan Email & Phone Number

Warren, Michigan, United States

- Data Warehousing: Designed a new data warehouse using Microsoft Fabric, resulting in a 30% improvement in service delivery unitefficiency metrics and automated 10,000+ entries in revenue data extraction, reporting, and reconciliation tasks- Automation: Implemented SQL queries to automate data extraction, and implemented ETL processes within Azure Data Factory totransform raw data into structured formats suitable for analysis, enhancing data quality and consistency, reducing process time by 40%

Ann Arbor, Michigan, United States

- Worked with a team of 9 to assist 2314 newly-admitted international students in creating unique introductory videos and blogs, and held office hours as needed- Created presentations and workshops for 1500+ attendees

- Directed social media channels(1000+ followers), and increased followers, engagement, and click-through rates- Improved advertising strategies with data-centric insights, enhancing channel influence- Hosted events to inform students about their rights and responsibilities, improving off-campus communication education.

Ann Arbor, Michigan, United States

- Design and develop an Augmented Reality (AR) application using Unity and Vuforia to provide a virtual walkthrough of vehicle crash simulation in real physical space and better assist in visualizing and understanding human motion in a crash- Add options of play speed, back/forward, and play/pause buttons on UI to demonstrate models in detail, complementing traditional classroom teaching- Build an interactive user interface allowing for different specifications and operating intuitively and efficiently

Ann Arbor, Michigan, United States

- Worked with DEVIATE research team to develop strategies for automating data element extraction from video to record vehicle occupant behavior and analyze motion sickness in autonomous vehicles- Performed statistical analysis and utilized algorithms such as sequential sampling for reducing manual labeling and focusing on finding subsets of large datasets that preserve model accuracy using Python- Searched for existing algorithms for human postures, emotions, or gazes detections in autonomous vehicles

Fairfax, Virginia, United States

- Worked to develop signature charity events, promote events to communities and schools, and seek donations from local artists, together fundraised over $86,000 for "Artful Living". - Identified and recruited new donors through community events, cultivated existing community partnerships, and initiate new relationships with corporations and individuals. - Worked to assist volunteers in the development and maintenance of the record-keeping system for donor files and acknowledgments.

Qingdao, Shandong

- Worked with a fellow intern to enable Java database access for user login, community news report, and photo upload by connecting the front end interface to API. - Customized Android OS UI and animations; Extended the Android Framework and extend the API support- Detected software defects and inconsistencies, debugged

Qingdao, Shandong

- Studied effects of exposing 2,2'-Dithiodipyridine(PS)₂, a degradation product of metal pyrithione, to sexually mature guppies at different concentration levels to investigate its reproductive toxicity.- Investigated and confirmed that environmentally relevant concentration of (PS)₂ could induce toxicity in guppies, reduce egg fertilization rate and delay embryo development, eventually posing a threat to population growth.

Bachelor Of Engineering - Be, Computer Science

High School

Activities and Societies: Varsity Tennis (Captain), Engineering Club (President), FTC Team 16482 (Founder & Captain), TED-Ed Club.

Computer Science

- Programmed in Swift, C++, HTML - Led a team to build and program a final project in Swift and pitched project to mentors