Page * *

John Lawler

Financial Analyst

adw4j0@r.postjobfree.com • 707-***-****

Santa Rosa, CA 95403

Versatile professional with extensive experience conducting and directing full spectrum financial analysis and operational review. Analytical and detail-oriented analyst dedicated to delivering accurate, actionable insights in fast-paced environments that require fluid cross-functional teamwork and leadership. Excels at operational planning, strategic evaluation, project execution, and performance reporting. Demonstrable record of operational excellence with a background in investment banking, financial consulting, and risk management, as well as insurance, sales, and education. Specializes in quantitative financial analysis, financial modeling, investment analysis, forecasting, budgeting, valuation, and financial reporting.

Skills & Specializations

Financial Research & Analysis

Forecasting & Projection

Financial Modeling

Financial Reporting

Financial Accounting

Risk Management

Investment Analysis

Budgeting

Valuation

Business Intelligence

Presentation Prep & Delivery

Team Training & Leadership

Work Experience

The Insurance Connection of Deschutes, Bend, OR March 2022 – August 2022 Insurance Broker

Oversaw all aspects of insurance process with a focus on ensuring seamless operational flow while meeting key milestones in a deadline-driven environment. Conducted fact-finding consultations, presented all available coverage options, and recommended package with best combination of rate and coverage based on client’s needs. Proactively managed client relationships by providing services beyond that of standard brokers, including claims assistance, free renewal premium re- quotes, direct deposit escrow, personalized insurance recommendations, and ongoing policy maintenance and change processing.

● Rapidly built insurance book by utilizing client acquisition and business development skills designed to maximize customer satisfaction and retention

● Reinstated and expanded TIC’s marketing campaigns to build a mutually beneficial referral business network reinforced by weekly in-person networking events at major car dealerships, mortgage brokers, and real estate agencies throughout Deschutes County

● Augmented in-person marketing with social media marketing campaigns on major platforms, increasing new client consultations by 30%

● Reduced premium prices while maintaining or improving coverage limits for ~85% of new clients Private Tutor, Hybrid Remote February 2019 – February 2022 Self-Employed

Instructed students in mathematics and English comprehension. Assessed student’s abilities and developed learning plans designed to address knowledge gaps and boost key performance metrics. Communicated with parents regularly and actively coordinated with teachers to ensure student’s mastery and maximum retention of subject material. Specialized in secondary mathematics education, including Algebra I & II, Geometry, Trigonometry, Pre-Calculus, Calculus, and SAT/ACT Prep. Additional specialization in English comprehension, critical analysis, persuasive argument construction, and essay/research paper development.

● Served full-time client pool of 20-30 students, utilizing word-of-mouth referrals to maintain pool and build steady stream of short-term and one-off clientele

● Augmented standard marketing with targeted social media campaigns designed to maximize business exposer and expand client portfolio; increased new client consultation and acquisition rates by ~25%

● Over 80% of full-time clients displayed superb academic improvement within one semester; 94% of short-term and one-off clients achieved desired academic goal Page 2 2

Luther Burbank Savings, Santa Rosa, CA July 2016 – February 2019 Financial Analyst

Managed bank’s interest rate risk (IRR) exposure via EVE, NII, and GAP analyses. Maintained financial models, streamlined business processes, evaluated ongoing projects, and monitored key performance objectives. Analyzed quantitative data regarding bank’s loan, savings, investment, and borrowing portfolios, and reported to senior leadership on both regular and ad hoc basis. Assisted with month-end closing process, conducted pre-purchase analysis on all potential investments, forecasted loan prepayment and non-maturity deposit decay rates, valued month-end mortgage servicing rights (MSR) portfolio, and assembled quarterly Asset & Liability Committee (ALCO) reports for board members and senior executives.

● Overhauled accounting department’s database query system by standardizing front-end architecture, establishing robust data validation techniques, and optimizing reporting framework, reducing time spent on query retrieval, error checking, and report generation by ~75% department-wide

● Assisted Treasurer and CFO with critical duties throughout bank’s successful $131mm IPO with opening day valuation of over $600mm, including generation of models, financial statements, reports, and risk analyses required by regulators and for newly issued quarterly and annual reports

● Served as primary analyst on bank’s first ever FHLMC-sponsored securitization of $6.5bn loan portfolio

(~$600mm sale)

North Bay Perfusion, Santa Rosa, CA June 2014 – June 2016 Financial Consultant

Directed financial operations at NBP including budgeting, payroll, tax, and bookkeeping processes. Evaluated operational data to identify areas of improvement. Originated business and capital expansion opportunities. Oversaw NBP’s creation of financial statements and strategic plans. Assisted with recruitment and interview process for temporary staff and independent contractors. Ensured compliance with all state and federal regulations, as well as NBP’s own established internal controls.

● Renegotiated client’s existing hospital contracts during 1H2015; successfully secured extended three-year terms with aggregate salary increase exceeding desired target of 15% for all staff perfusionists

● Identified expansion opportunities in Northern California and successfully negotiated St. Helena Hospital contract, resulting in 31% bottom line growth YoY

J.P. Morgan, San Francisco, CA May 2013 – May 2014 Investment Banking Analyst – Technology (TMT)

Coordinated with senior bankers to complete critical client deliverables, including detailed research, forecasting, and valuation analyses on M&A, IPO, LBO, debt capital raise, and restructuring deals. Advanced financial modeling expertise in Excel, including financial statement preparation and projection, P&L forecasting, and valuation modeling via public and transaction comps, DCF, Accretion/Dilution, LBO, and Sum of Parts analyses. Assembled pitchbooks and presentations for managing bankers and C-level client executives throughout Silicon Valley.

Oversaw comprehensive valuation analysis of RealD and provided strategic advice regarding company repositioning and long-term stock price improvement

Lead analyst on $500mm King.com IPO with opening day valuation of over $7bn

Lead analyst on Facebook $4bn debt capital raise Additional Experience

Summer Analyst, J.P. Morgan, San Francisco, CA

Summer Analyst, Ameriprise Financial, Santa Rosa, CA Head Researcher/Editor, Mastering the Fundamentals of Finance, San Luis Obispo, CA Education

Bachelor of Science in Business Administration

Concentration: Finance

California Polytechnic State University, San Luis Obispo

Contact this candidate