Data Analyst

Rico Chen

**** **** ***, *** *********, CA ***** 415-***-**** *********@****.***

EDUCATION

University of California, Los Angeles Los Angeles, CA Bachelor of Arts in Economics; Emphasis in Accounting Graduated March 2015

GPA: 3.5 / 4.0

PROFESSIONAL EXPERIENCE

Ethos Lending San Francisco, CA

Mortgage Analyst March 2015 – October 2015

Independently research market conditions of mortgage industry; did further due diligence on prospective investments using income based approach to analyze cash flows

Performed analysis of key financial information such as borrower assets, equity holdings, and financial statements to determine whether to originate or sell a mortgage loan

Analyze large datasets in Excel to identify trends and outdated procedures, made recommendations to senior management to improve process efficiency and add automation to operation processes

Conduct daily monitoring methods to find potential risks and tolerance breaks that may impact loan assets; collaborated with compliance team members to resolve individual issues

Maintain relationships with investors by processing requests and validating investment payments through consultation 24Hr HomeCare Encino, CA

Corporate Finance Intern July 2014 – August 2014

Streamlined billings procedures by reviewing market data of products and services, leading to an automation in operations process and reducing future expenses

Benchmarked salary budget of multiple offices across Southern California, found that the San Diego region was under- funded by 7%; used findings to prepare a presentation and submitted proposal for additional $70,000 in funding

Held meetings with 25+ clients to determine the best payment options and caregiver plan that addressed their needs Anderson School of Business Los Angeles, CA

Work Study June 2013 – May 2014

Maintained CRM product Salesforce through biweekly database information updates and ongoing software management

Recreated an Excel spreadsheet of UCLA Anderson’s financial goals of reaching 5% higher proceeds through investors

Collaborated with a 7 member team to plan and achieve six successful quarterly Board of Directors meetings Jozu San Francisco, CA

Accountant June 2012 – September 2012

Responsible for accurate reporting and analysis of the region’s performance against forecasted and historical results

Improved office workflow by 20% by updating log sheets, sorting invoices, and compiling journal entries

Provided a solution to decrease the discrepancy between employee pay statements and actual earnings Undergraduate Business Society Los Angeles, CA

Director of Investment Committee September 2013 – March 2015

Researched 36 companies in oil & gas, biotech, and technology sectors selecting only 4 to invest in through value investing techniques such as DCF modeling, P/E ratios, and past revenue growth

Presented stock pitch for Halliburton (NYSE: HAL) based on EV; recommended in favor of investment, company was trading at 28% discount matched against other major oil companies SKILLS, CERTIFICATIONS & INTERESTS

Languages: Fluent in conversational Chinese

Certifications & Training: Learning SQL and Excel VBA, pursuing CFA level 1

Interests: Competed in a half marathon, investing in the stock market, and TV series Suits

Contact this candidate