Taeyang You
www.linkedin.com/in/taeyangyou
taeyang.you@outlook.com | www.taeyangyou.com | 607-220-3326 | Permanent Resident
Skills
- Financial Modeling – Business Case, Metrics, CapIQ, Comparable Companies Analysis, DCF Analysis
- Data Analysis – Excel (PowerPivot, Dashboard), Access (Queries, Reports), Tableau (Dashboard, Visualization)
- Creative – Squarespace, Adobe Premiere, Illustrator, Photoshop
- Language – English (Fluent), Korean (Fluent), Japanese (Elementary)
Experience
Intelsat
Corporate Strategy
Tysons Corner, VA
Jan, 2016 – Present
New Satellite Investment Project
- Built a bottoms-up revenue model incorporating key financial metrics of a major customer by sourcing information from financial statements (10Q, 10K, Investor Presentations) to estimate future revenue growth
- Conducted a research on a customer in order to better understand its business model (new technology, growth driver, sector trend) and to assess financial health by referring to trade magazines and online resources
- Generated a dashboard that tracks Intelsat satellite fleet’s KPIs by building a pro forma model to assist management evaluating future satellite investment decisions
Satellite Deployment
- Constructed and maintained a model for the FCC mandated C-band project to estimate each operator’s share in the C-band domain by referring to financial statements to gauge the amount capacity and the number of satellites
- Developed a 5 year satellite deployment plan that protects orbital slots and generates $6M revenue per year per asset by collaborating with key stakeholders (Sales/Business Development/Asset Management/Finance/Legal)
Intelsat
Innovation Intern
Tysons Corner, VA
May, 2015 – Aug, 2015
- Developed a business plan (~$3 million in budget) that will provide Intelsat with flexible and convenient service to customers in developing markets
- Learned how to efficiently brainstorm and pitch ideas as a team, write a business plan and present the idea to the broad audience
LZ Dark Matter Experiment @ UW-Madison
Research Assistant
Madison, WI
Jan, 2015 – May, 2015
- Assisted in data analysis for the LZ Dark Matter Experiment by using C++ and ROOT to interpret data set.
- Studied basic C++ and ROOT and learned to use Google to find answers for programming questions independently.
Activities
Bucky Radio
Creator/DJ
Madison, WI
Jan, 2015 – Dec, 2015
- Independently created a weekly radio program that targeted undergraduate audience by assembling a platform by combining Squarespace.com, Mixlr.com and 3rd party plugins. Recruited 2 more team members and invited weekly guests (mixlr.com/buckyradio).
- Produced 27 episodes, generated about 80 weekly audiences and scored total 2,811 listens.
- Developed program planning insights, speaking (MC'ing) skills and multitasking abilities in fast paced situations.
Education
University of Wisconsin - Madison (GPA 3.71)
- Physics, B.S
- Communication Arts, B.A
Madison, WI
Sep, 2011 – Dec, 2015
Courses
Jun, 2015 - Current
Coursera
- Excel to MySQL: Analytic Techniques for Business
- Business Metrics for Data-Driven Companies
- Mastering Data Analysis in Excel
- Data Visualization and Communication with Tableau
- Managing Big Data with MySQL
- Data Analysis and Presentation Skills: the PwC Approach
- Data Driving Decision Making
- Problem Solving with Excel
- Data Visualization with Advanced Excel
- Effective Business Presentation with PowerPoint
Udemy
- Microsoft Excel - From Beginner to Expert in 6 hours
Others
- W3Schools- MySQL
- SQLzoo- MySQL
- Youtube - Excel, MySQL, Tableau
Contact
LinkedIn: https://www.linkedin.com/in/taeyangyou/
Email: taeyang.you@outlook.com
Work: taeyang.you@intelsat.com