Financial Project

Albert Tsen

Linkedin: https://www.linkedin.com/in/albert-tsen-a05720147/

Address: SF Bay area

Phone number: 408-***-****

Email address: ******************@*****.***

FP&A Analyst 04/2019 – 08/2019

Analog Devices, Santa Clara, US

Utilized Qlikview and Excel to generate financial

reports, forecast, analyses for CFO of Power

Product BU with total revenue of 1.5B

Prepared 10+ weekly booking reports and 2

quarterly revenue scorecards and analyzed

fluctuations

Collaborated with 10 R&D members to build

expense plan to improve forecasting

Input headcount plan into Anaplan and provided

high level insights

Conducted Ad-hoc analysis and executed special

project as assigned ex: created database by

consolidating 2M+ data in excel using powerpivot

Worked with manufacturing accountants on

budgeting and capital spending

Company Valuation Project-

The Easter Company(EML) 07/2018 – 08/2018

Haas School of Business

Led 4 analysts to analyze macro economy,

hardware component industry, EML’s competitors

and product mix

Utilized Bloomberg Terminal to gather company's

historical financial data

Conducted 3 analysis including DCF, DDM and

financial ratio analysis

Compared the target price $31.5 with current

trading price $29.5 and finally made a "Hold"

recommendation

Project Lead of

Entrepreneurship Class 01/2018 – 02/2018

Haas School of Business

Headed a team of 5 to develop an idea of creating

an app. to connect grocery shopping partners

Established membership fee profit model and

estimated target market size of 2.2M in 0-2 years

Conducted market research by Interviewing more

than 50+ students on campus

Co-Founder 05/2016 – 01/2017

A-dian (online clothing Shop)

Attracted more than 1000 followers on social

media in the 1st month with promotions events

Achieved $8000 revenue in three month by selling

big variety of clothes with lower price

Formed our business strategies by comparing

price difference in two regions and profit models

such as large selections and customer loyalty

program

Co-founder and Vice President

of Badminton Club 04/2016 – 01/2017

De anza College

Utilized excel to set budget, increase revenue and save cost

Expanded the club from 10 to 60 members in

second quarter by running promotional campaigns

Organized a two days campus-wide tournament

for more than 50 students and earned $500 in

profit

Coordinated between club councils, officers and

students

Bachelor of Science (B.S.),

Economics 08/2017 – 12/2018

University of California, Berkeley, Berkeley, US

Berkeley Investment Group

Business Administration 01/2015 – 06/2017

De Anza College, Cupertino, US

Software

-MS

Excel/PowerPoint/Outlook

-SQL

-Qlikview / Tableau

-Anaplan

-SAP / Oracle

CourseWork

-Financial/Managerial

Accounting

-Financial Economics

-Econometric

-Probability and Statistics

-Investment

-Entrepreneurship

Volunteer 10/2016 – 12/2016

Seeds Non-profit Organization, Reykjavik, Iceland

Held free photo exhibition for 1000+ visitors to

promote tourism in Iceland

Introduced top 20 best local businesses to tourists through Facebook and promotional campaigns

Travel and

Social

/

Jazz and Lo-fi

music

Outdoor

Activities

Work and Leadership experience Work and Leadership experience

Education

Skills

Volunteering

Hobbies

Contact this candidate