Bobak Tabatabaian
Financial Analyst, FP&A · loanDepot, LLC
Scottsdale, AZWork Experience
Financial Analyst, FP&A
loanDepot, LLC2020 – 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, LLC2018 – 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 Company2017 – 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, LLC2017 – 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 Network2016 – 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, Inc2016 – 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 Jewelers2014 – 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 Management2018
Master of Science in Finance
The University of Arizona
2001 – 2008