BT

Bobak Tabatabaian

Financial Analyst, FP&A · loanDepot, LLC

Scottsdale, AZ

Work Experience

Financial Analyst, FP&A

loanDepot, LLC

2020 – Present

• Streamline ad-hoc financial reports to various joint venture clients, operational leaders, and executives by utilizing Tableau, SQL, Oracle Hyperion and Excel • Overhaul and present robust monthly business reviews to executive management under stringent deadlines • Conduct market research and construct pro formas to support the assessment of new business opportunities • Establish and sustain a detailed monthly channel forecast model to facilitate evaluation of performance • Engineer reports using raw loan production and accounting data to identify areas for process improvements by evaluating key company metrics

Government Consulting Analyst

Mercer, LLC

2018 – 2020

• Built and analyzed rate setting models consulting the California Department of Health Care Services (DHCS) • Collaborated among numerous projects teams to develop and smooth financial data into capitation rates • Led diverse project teams, which included coordinating meetings among informatics, analysts, and actuaries colleagues • Mentored analysts in statistical analysis, communication among project managers, and organized model building • Joined the Mercer hire & interview committees, as well as becoming a counselor to a new colleague

Financial Modeling Intern

Long Realty Company

2017 – 2017

• Developed an excel workbook to simplify data entry throughout office, which automatically pulled sales data to produce performance reports for individual agents, now applied as a platform • Interpreted sales data to create profit and loss statements, as well as developing firm summary statistics

Financial Reporting Intern

Larsen Baker, LLC

2017 – 2017

• Produced pro-forma cash flow statements for various commercial properties to assist in loan refinancing for various entities • Analyzed lease agreements to facilitate the financial planning of multiple commercial property entities

Financial Representative Intern

Northwestern Mutual Financial Network

2016 – 2016

• Earned Insurance Producer license for the State of Arizona, while networking through warm leads to build a client base • Coordinated client meetings with licensed financial advisors, as part of a mentorship program

Financial Services Intern

Raymond James Financial Services, Inc

2016 – 2016

• Re-created and updated bond ladder maturities workbook using Microsoft Excel, streamlining and standardizing client data • Prepared financial reports and verified documents to facilitate client meetings, as well as directing and instructing a new hire

Merchandiser

Berilian Fine Jewelers

2014 – 2015

Maintained inventory records by implementing an Excel workbook which assisted in item search and detail

Education

Master of Science in Finance

Eller College of Management

2018

Master of Science in Finance

The University of Arizona

2001 – 2008