Andrew Lutz

Senior Strategic Analyst at Greater Minnesota Housing Fund
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Afton, Minnesota, United States, US
Languages
  • English -
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Web Development Professional Certificate
    Minneapolis Community and Technical College
    Jan, 2016
    - Nov, 2024
  • Microsoft Excel III
    Minneapolis Community and Technical College
    Jan, 2014
    - Nov, 2024

Experience

  • Greater Minnesota Housing Fund
    • United States
    • Financial Services
    • 1 - 100 Employee
    • Senior Strategic Analyst
      • Feb 2022 - Present

      Provide analysis and key metrics to effectively plan new strategic initiatives, evaluate past performance, and support staff and board discussions, including the preparation of financial projections and models, scenario planning, and other analysis. • Financial Leadership: Led application, review and closing of $100M+ in Bond Guarantee Funds• Financial Analysis & Risk: Created a comprehensive cash projection for budgeting and making strategic financial decisions for the organization while mitigating risk to GMHF• Compliance: Responsible for applying for and maintaining compliance on 6 CDFI Fund Programs ($30M) and GMHF’s 10+ Debt Covenants (Foundations, Banks, Government)• Project Management: Led AERIS Rating review to maintain GMHF’s AA+ Policy Plus Rating Show less

    • Loan Portfolio and Financial Data Analyst
      • Apr 2018 - Feb 2022

      • System Integration: Responsible for implementing new programs and automating reports to maintain efficiency and ensure accuracy • Process and Controls: Led process optimization to automate reports for efficiency and address audit finding• Data Integrity: Optimize efficient utilization of GMHF’s existing management information systems

  • BI WORLDWIDE
    • United States
    • Business Consulting and Services
    • 700 & Above Employee
    • Data Analyst
      • Sep 2016 - Mar 2018

      • Define, develop and deliver reports and dashboards through Tableau, Watson, Excel and other analytic tools • Forecast payouts and sales for large automotive client programs to aid in implementing their multi-million dollar budget • Communicate with our sales force, client services, business analysts, and technical teams on program status, issues, and changes • Define, develop and deliver reports and dashboards through Tableau, Watson, Excel and other analytic tools • Forecast payouts and sales for large automotive client programs to aid in implementing their multi-million dollar budget • Communicate with our sales force, client services, business analysts, and technical teams on program status, issues, and changes

  • brightpeak financial
    • Greater Minneapolis-St. Paul Area
    • Operations Analyst
      • Feb 2015 - Feb 2016

      • Specialized in Hubspot, Google Analytics, and Tableau to communicate key insights about success and risk for marketing campaigns, company growth, and quality control • Diagnosed gaps and initiated collaboration leading to more efficient data collection and analysis • Collaborated with IT department to diagnose data gaps and determine solutions to create a more efficient data collection and analysis process • Created an automatic tracking mechanism in Excel to administer a complex reward system Show less

  • Center for Energy and Environment
    • Greater Minneapolis-St. Paul Area
    • Research Analyst
      • Oct 2012 - Feb 2015

      • Developed instrumentation, testing, and data analysis procedures for the Large Building Air Sealing and HVAC System Pressure Effects and Retrofitting Combined Space and Water Heating Systems projects • Executed complex experimental tests independently and effectively • Utilized Excel, Tableau, and CONTAM to analyze data and create visualizations for various audiences • Developed instrumentation, testing, and data analysis procedures for the Large Building Air Sealing and HVAC System Pressure Effects and Retrofitting Combined Space and Water Heating Systems projects • Executed complex experimental tests independently and effectively • Utilized Excel, Tableau, and CONTAM to analyze data and create visualizations for various audiences

  • Hamline University
    • United States
    • Higher Education
    • 500 - 600 Employee
    • Summer Research at Hamline University
      • Jun 2011 - Sep 2011

      • Collaborative Research with Hamline Professor Andy Rundquist, Physics chair • Created Ruben Flame Tube to analyze harmonic frequencies in order to compare with known harmonic frequencies of a closed tube of similar length. • Identified a shift of the harmonic frequencies in a Ruben’s Flame Tube compared to a closed tube and designed a Ruben’s Tube with thicker walls that eliminated this shift. • Modeled harmonic frequencies in Mathematica from laboratory data sets. Show less

Education

  • Hamline University
    Bachelor of Science (B.S.), Physics with Education Minor
    2008 - 2012

Community

You need to have a working account to view this content. Click here to join now