Celina Pan is a Computer Science & Data Science major at the University of Michigan.
-
Big Data Engineer InternUnion Pacific Railroad Jan 2022 - Dec 2022Ann Arbor, Michigan, United States• Implemented an ETL data pipeline capable of automatically processing and augmenting 10 million railcar tracing messages a day using Scala, functional and object-oriented programming, multithreading, and components of Hadoop framework including Hive and Spark SQL, leading to 25% increase in client’s offline data visibility• Engineered a data analytics report on processed railcar tracing data by negotiating with business partners to finalize client requirements and utilizing Tableau to meet them; proved pipelined data’s importance to revenue recovery and auditing, and supplemented team’s understanding of offline railcar events• Employed project management tools JIRA and GitLab to help manage large-team agile development project, resulting in on-track delivery of final deliverable and stretch goals that exceeds client expectations -
Vp Of Development, Web DeveloperVoid Tech Consulting Aug 2021 - May 2022Ann Arbor, Michigan, United States• Developed custom home website complete with contact forms for Anton Anderssen Travel Inc. adhering to client mandated designs by applying HTML, CSS, PHP, and WordPress’s Shortcode API within team of four volunteer programmers, leading to enhancement of web development and project management skills • Pair-programmed solutions to numerous coding problems presented during club-wide technical workshops and team challenges, resulting in ability to effectively communicate and work with a diverse range of individuals -
Portfolio ManagerGlobal Investments Committee Sep 2020 - Aug 2021Ann Arbor, Michigan, United States• Collaborated with team of 4 to analyze data generated by risk management software and conducted market research to provide club with insights on how to optimize our portfolio to reduce risk and increase profits; led to purchase of Lockheed Martin (NYSE: LMT) stock, sale of Weibo (NASDAQ: WB) stock, and other actions that resulted in the portfolio generating 20% returns in a period of 4 months • Contributed to final deliverable of stock pitch on Israeli crop protection company, ADAMA (SHE: 000553), by conducting 5 stock screenings and 15+ hours of industry research in team of 6 on the Global Equities Desk; synthesized relevant information and delivered final results to club of 50+ members -
LifeguardInternational Committee Of The Red Cross - Icrc May 2018 - Aug 2021Taipei, Taipei City, TaiwanVolunteer Red Cross Lifeguard, 180+ hours. -
Financial AnalystTheta Capital Sep 2020 - Jul 2021Ann Arbor, Michigan, United States• Performed qualitative analysis on Taiwan Semiconductor Manufacturing Company’s (NYSE: TSM)financial data, delivering stock pitch in club-wide pitch competition with over 30 participants and tying for first place; resulted in the purchase of $1425 worth of TSM stock for paper portfolio• Produced 5 detailed stock reports on international companies across travel, technology, and energy industries by analyzing company financials, management, and operations as well as those of competitors, leading to prioritized list of stocks used in decision-making by club members for club and personal investments -
Business AnalystCapital Consulting Group - University Of Michigan Sep 2020 - Jun 2021Ann Arbor, Michigan, United States
Celina Pan Education Details
-
Computer Science, Data Science -
Taipei European School
Frequently Asked Questions about Celina Pan
What is Celina Pan's role at the current company?
Celina Pan's current role is Computer Science & Data Science major at the University of Michigan.
What schools did Celina Pan attend?
Celina Pan attended University Of Michigan, Taipei European School.
Not the Celina Pan you were looking for?
-
-
-
Celina Pan
Berkeley, Ca1morganstanley.com -
Celina Pan
Switzerland
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial