Hi, I'm
Sunny Pan

 Computer Science · University of Michigan · 2020–2024

Innovator. Thinker. Builder.
I turn complex requirements into scalable data systems and shipped products — from enterprise analytics pipelines to consumer iOS apps. Currently a Project Analyst at Paslin, driving digital transformation across engineering and operations.

Sunny Pan
Data-Driven Power BI SQL ETL / Azure AWS Python Dashboard Design
Program Mgmt Governance Roadmapping Risk Tracking Stakeholder Mgmt PMO
Systems Builder Product Strategy Figma Unity / C# Usability Testing ML Models
30%
Reduction in data service response time
500+
Students reached with AR simulation
6+
Years of technical experience
20+
Projects completed
01

Experience

Work
Jul 2024 – Present · Warren, MI Current
Project Analyst (Digital Transformation Lead)
Paslin
Power BISQLAWS Executive DashboardsGate Process GovernanceKPI Tracking
↑ Collapse
  • Spearheaded the business strategy and end-to-end product lifecycle of an enterprise gate process platform (internal CRM/ERP tool); successfully integrated complex workflows and led global product training across 11 cross-functional teams and 2 international subsidiaries (China & Mexico) to unify fragmented operations.
  • Prepared and delivered technical presentations directly to the CEO and senior executive leadership; aligned product roadmaps with corporate strategic goals, transforming the monthly Strategic Counsel review into a real-time data-driven framework that accelerated executive decision-making.
  • Co-developed an AWS cloud-native Enterprise Data Warehouse and Data Lake infrastructure; scaled storage and data modeling capabilities utilizing SQL to seamlessly support $400M+ in global project volume.
  • Launched and maintained a suite of executive-level Power BI products across PM, Supply Chain, Finance, HR, and Sales departments; integrated financial variance and cross-departmental KPIs to reduce reporting latency by 45%.
May 2023 – Aug 2023 · New York, NY
Business Intelligence Analyst Intern
ReSource Pro
Azure Data FactoryPython SQLETL CI/CDMicroservices
↓ See details
  • Designed scalable ETL workflows using Azure Data Factory + Python-based SQL scripts — reduced data service response time by 30%.
  • Partnered with engineering to optimize data platform microservices and CI/CD workflows, improving data accessibility org-wide.
Jun 2023 – Apr 2024 · Ann Arbor, MI Research
Software Developer
Vehicle Safety Laboratory · University of Michigan
Unity / C#ARFigma Product RoadmapUX Testing3D Simulation
↓ See details
  • Translated educator requirements into a product roadmap (Figma prototyping), prioritizing real-time interactivity, AR stability & data visualization.
  • Led development of an interactive 3D simulation engine in Unity/C# with AR algorithms to visualize motion data for hands-on learning.
  • Drove iterative UI/UX improvements based on student testing; improved usability for 500+ students.
Aug 2022 – Oct 2023 · Ann Arbor, MI Research
Software Developer
DEVIATE Lab · Transportation Research Institute, University of Michigan
PythonTensorFlowOpenCV CNN / RNNScikit-LearnAutonomous Vehicles
↓ See details
  • Built CNN & RNN models using Python, TensorFlow & OpenCV to detect driver posture, emotion & gaze from video data for autonomous-vehicle research.
  • Optimized data labeling & classification workflows, improving model accuracy with Python-based ML libraries (Scikit-Learn, Pandas).
Aug 2020 – May 2024 · Ann Arbor, MI
Bachelor of Engineering, Computer Science
University of Michigan
PythonC++ SQLJavaScript AWSReact Data StructuresML
↓ See details
Languages: Python (Pandas, NumPy), SQL, C++, JavaScript
Technologies: AWS, Azure, Power BI, Tableau, React, ETL, Git, Figma
Campus Involvement
Sep 2020 – Present
Student Program Manager
Dean of Students · University of Michigan
Event Management Social Media 600+ Attendees
↓ See details
  • Led two major annual Student Housing Fairs with 600+ attendees and 20 vendors each.
  • Managed 3 social media accounts, growing followers by 1,000+ on each platform.
Jul – Sep 2021
Peer Advisor
International Center · University of Michigan
2,314 Students CSSA 2,000+ Participants
↓ See details
  • Collaborated with a team of 9 to support 2,314 newly-admitted international students via videos, blogs, office hours, and 50+ group consultations.
  • Led a team of 20 to execute 10 alumni forums and 4 social events on FinTech, VC, Film & MCN with 2,000+ participants in CSSA.
02

Projects

PawMap app
Product · iOS App
PawMap
Consumer iOS app for pet-friendly location discovery — from product strategy to data-driven experimentation.
SwiftUI · MapKit · Firebase See more →
AR simulation
Research · AR / Simulation
AR Vehicle Crash Simulation App
Interactive 3D AR simulation engine for vehicle safety education, used by 500+ students at University of Michigan.
Unity · C# · AR · Figma See more →
📊
Analytics · Governance
PMO Analytics Platform
Enterprise Power BI dashboards + gate tracking system adopted org-wide at Paslin for real-time program visibility.
Power BI · SQL · AWS See more →
🤖
ML · Autonomous Vehicles
Driver State Detection
CNN + RNN models detecting driver posture, emotion & gaze from video for UMich autonomous vehicle research.
Python · TensorFlow · OpenCV See more →
Home Bar app
Product · iOS App
Home Bar
iOS cocktail app — pick your pantry, set your vibe, get a recipe shortlist ready to make tonight.
SwiftUI · Claude API See more →
03

Skills

Data & Analytics
Python
Power BI
SQL
Azure / AWS
ETL Pipelines
Program Management
Governance
Roadmapping
Risk Tracking
Stakeholder Mgmt
Collaboration
Product & Dev
Figma
Product Strategy
Unity / C#
TensorFlow / ML
Usability Testing
CS & Engineering
C++
Swift / SwiftUI
React
REST APIs
UI / UX
Let's connect

Open to roles in analytics, program management, and product.
Always happy to chat about data systems, governance, or side projects.

✉ jxpan@umich.edu in LinkedIn ⌥ GitHub ↓ Resume PDF