Senior Financial Analyst

Merrill McHenry, MBA, CFA

Senior Financial & FP&A Analyst

469-***-**** **********@*****.*** Merrill’s LinkedIn Profile

Accounting Financial Analysis & Modeling In-Depth KPI & Variance Analysis

Strategic FP&A Manager with 18+ years of global experience as a Financial/Business Analyst and Project Manager across multiple industries. Seasoned SME in Finance, Business, Treasury/Capital Markets, and IT (including SQL, Power BI, MSFT Stack & Power Apps automation). Specialized in optimizing free cash flow and working capital solutions. Skilled in advanced financial all advanced metrics (including IRR, NPV, DCF, ROIC) and excel functions (SUMIF, INDEX MATCH, OFFSET, MACROs/Hotkey) striving to remain current in best practices modeling, VBA, and automation. Extensive credit (CECL scoring) and modeling analysis depth and breadth experience with numerous industries and companies through all stages (IB IPO to M&A). (Led Analyst Special Projects Team at #1 Canadian Research Ranked BMO for major Global Integrated Company Financial Modeling.)

Result-oriented self-starter problem-solving mindset rooted in an innate contextual ability to pragmatically “read” and seek key data details and accounting variables and distil effective conclusions. SAP Crystal Reports, SAS, SQL, Excel, Power BI, and Access to perform C-suite insightful report development and reporting from data extraction and reporting. Adept in Interest Rate Risk (IRR) Bank Consulting (over 200 banks) with ALM, and Liquidity Risk leveraging measures such as Net Interest Income (NII), Earnings at Risk (EAR), Economic Value of Equity (EVE), various Fed Reg and Basel Reg Capital Stacks. Underwriting, IB, CDFI and SBIC experience. Broad knowledge & experience in Flux & Secular vs. Cyclical trends as a consistent leader in macro (Econ) to micro (Corp & RE/Asset) analysis (published in leading industry publications – Economist, Barrons, etc.).

Expertise

Budgeting & Forecasting Treasury & CF FCST & Mgmt Hedging Advanced Modeling Regulatory Compliance Financial Reporting M&A KPI & KRI Analytics Risk Mitigation Data Analysis & Visualization / Power BI Statistical Analysis & FRM Ledger Strategic Planning Process Improvement/Reengineering Consolidated P&L GAAP FRM Level 1 Tax Equity Modeled Solar Projects Root Cause Drilldown Variance Analysis SAP S/4Hana & TM1 Planning JIRA Oracle Hyperion, ESSBASE, SmartView & CPG

C-Suite Reporting Advanced Valuation, Investment Analysis & Underwriting AI & Machine Learning Team Lead IRR RWA

Professional Experience

Avery Dennison, Dallas, TX Jul 2023 – Current

Financial Planning & Analysis Manager – Global Ops

Provide strategic financial insights, enhance financial reporting, and drive the financial planning process for (CPG & Manufacturing goods) at a global manufacturing company. Ensure GAAP compliance by implementing best practices in financial modeling and reporting. ASC 842 Lease Compliance.

Improve financial reporting accuracy by adding C-Suite analytics and preparing advanced monthly reports, including consolidated P&Ls, Flash, Variance Analysis, and projections using Oracle Hyperion and Excel. Identified and quantified industry sources destocking the company’s inventory.

Boosted global working capital by ~3%, Q1 EBITDA +40bp through optimized free cash flow solutions and best practices in modeling and reporting.

Increased reporting efficiency using advanced Oracle Analytics Cloud & Hyperion, Excel, and Google Sheets. Streamlined financial planning processes by contributing to ERP system development and implementation. Supported Solutions Group & E-Commerce Dept & AI/ML platforms.

Gigapower (AT&T/Blackrock JV spinoff), Dallas, TX Feb 2023 – Jun 2023

Lead Financial Analyst (FP&A Jr) – Project Management, Contractor

Led forecast modeling for regional projects at a company that builds, owns, and operates a state-of-the-art fiber network serving internet service providers and other businesses across the U.S. Oversaw detailed GAAP financial planning, capex management, and vendor credit risk reviews.

Managed treasury cash flow forecasting and hedging, utilizing revenue recognition and forecasting methods with statistical analysis/adaptations.

Developed advanced proforma models using Oracle and Excel for tight capex and opex management during a $1B syndicated financing project.

Conducted nationwide forecasting and budget modeling with detailed incremental tight milestone budgets and revenue penetration targets.

Guardian Mortgage, Plano, TX Oct 2021 –Jan 2023

Senior Financial Analyst

Facilitated FP&A endeavors at a residential mortgage lending company by managing the redesign and deployment of financial forecasting systems and risk management models during a cross-functional project. Macro and Regional Housing Market secular and trend ID, estimations and variance.

Improved financial forecasting accuracy by 9% by redesigning the forecasting system using RPA, Power BI, and Power Automate.

Raised financial close process efficiency by 12% by simplifying journal entries and account reconciliations during Oracle G/L monthly closes.

Augmented risk management using Value at Risk (VaR) modeling and risk metrics (RWA, Basel Cap stacks) with back testing for hedging reviews.

Slashed reporting time by 14% by automating reporting and data scraping with MSFT Hotkey and Power Automate. Argus RE modeling.

Independent Contractor, Dallas, TX Sep 2016 – Oct 2021

Senior Financial Analyst

Performed as a Lead Financial Analyst & FP&A Manager for multiple corporations on a contract basis.

Clientele Portfolio: CTI Foods, Wells Fargo, NextEra Energy, and Toyota

CTI Foods: Amplified product mix efficiency by 9% by designing optimization models for manufacturing plants using Excel Solver modeling.

Wells Fargo: 2 Engagements. 1.) Led a LIBOR transition project, managing risk and data mapping to ensure regulatory compliance. 2.) Led team development of KRIs for detecting Operational Fraud (as leading detection as possible optimized for each KRI variable) for Comptroller compliance.

NextEra Energy: Agile/JIRA Atlassian managed SAP shop. Modeled capex spend rates and contributed to PPP and tax equity/ITC modeling. Developed Power BI reports for C-Suite users. Exposure to Six Sigma and Lean manufacturing and inventory management principles.

SAP Crystal Reports on HANA, SAS, SQL, Excel and Access to perform the functions of data extraction and reporting. Amended reporting by integrating Power BI with SAP, ensuring accurate data validation and testing. Control charting and variance analysis and control management.

Revamped FP&A processes with advanced modeling techniques for headcount, OPEX/CAPEX. Applied SME knowledge in financial modeling and accounting across numerous sectors, including Banking, Energy, Utilities, Manufacturing, and Housing. Cross-functional stakeholder management.

Santander Consumer Finance, Dallas/Fort Worth, TX Jun 2014 – Aug 2016

Senior Financial Business Analyst – CCAR – (After Passing Parent Bank assumed our CCAR)

Successfully identified and mitigated a $232M balance sheet risk for a multinational financial services company through in-depth analysis and industry acumen. Passed The Fed’s CCAR Status using Excel (Advanced composite KPIs and KRIs), and SAS.

Enhanced financial forecasting and risk reporting accuracy, ensuring CCAR and SCAP ALM compliance. Monthly calculations of Liquidity and Capital reports FRY9C, FRY14, 2052A/2052B. Monthly Reporting and Presentation to the C - Suite Capital Committee.

Improved KPIs and financial models for the parent bank by leading advanced VBA/Excel/DB/SQL/SSMS modeling. Credit scoring macro analysis.

Conducted CCAR and DFAST stress test modeling, ensuring compliance with regulatory requirements for C-Suite, FRB, and SOX reporting.

Additional Experience Bank of Montreal (BMO), Toronto, Canada

Senior Financial Business Analyst / progressing to Lead Stock Analyst Modeling Support

Led the financial remodeling of key global companies, designing advanced VBA and Excel models for Capital Markets and Global Business Financial analysis. Strengthened financial analysis capabilities by developing Industry Cost and S Curves and Price/Demand Sensitivity models, leading a team of four staff members. Underwriting IB support including Lease Financial Analysis (ASC 842 Operating Vs Financial).

Made progress in financial modeling accuracy with advanced models using ROI, DCF, and FCF, publishing research on multiple industries.

Delivered critical financial GAAP-Compliant insights conducting sensitivity analysis (credit, project & deal structuring) on Municipal, and Corporate Finance: 160+ corporations, specializing in Manufacturing, Banking, Distributed Services/Utilities, Renewable Energy, and Oil & Gas, Mining.

UMB Bank, Kansas City, MO

Director Financial Services Group (Bank ALM Consulting, etc.)

Modeled, analyzed, and presented as a keynote address the largest proprietary U.S. banking industry (~ 630+ banks) ALM stress-test to date (defining the Efficient Frontiers for 10-decile ranking of Duration & Convexity ranges) at 3 State (OK, KS, CO) Banker Annual Conferences. Promoted to run ~$1.2 - $1.8 Billion in As Agent Fed Funds, Treasury, & collateralized securities. Participated in a SAP Conversion Implementation.

Built our ALM Model and Created a Multi-State ALM Consulting Division (“Service Bureau”) with over 200 bank clients with advanced stress-test modelling pre- & post-CCAR. Financial Statements were analyzed under the current “Supervisory Capital Assessment Program” (“SCAP”) regime

Expert level Stress-Testing and Capital and Cash Flow knowledge (duration, convexity, structure, & credit). Modeled and Calculated Liquidity and Capital Reports FRY9C, FRY14, 2052A/2052B for SEC, OCC (Office of the Comptroller of the Currency) & FRB (Federal Reserve) reporting.

Technical Proficiencies

Software & Tools: Ruby, VBA, SQL, R, Python, MATLAB, SAS, HFM, Oracle Hyperion, ALM, Power BI, Confluence, MSFT Power Apps (Power BI Developer, PowerPivot (DAX)),Power Query, Microsoft Azure, NetSuite, NLTK, Oracle, QuickBooks, Tableau, Wireframe, Visio, MySQL, Power Automate, Bloomberg, Essbase, PeopleSoft, Participated in a SAP S/4Hana (and Conversion Implementation), Workday Adaptive Insights, Microsoft Dynamix/Great Plains, Qlik, Planful, SSRS, Trend ID, Sage Intacct, Google Workspace (Sheets), AI & Machine Learning (XGBoost and Random Forest algorithms), FRM Level 1, Microsoft Office 365 (Word, Excel (SME), Access, Power BI, PowerPoint, Power Automate, and Outlook), Project Management (Several ERPs, SAP, Oracle/Essbase/Hyperion, NetSuite, MSFT Dynamix and BI Systems)

Core Tech Skills: ETL Transformations, REST API, Programming, Data Visualization & PowerBI, Data Science, Data Structures & Algorithms, Usability Testing/Engineering, Dashboard Creation, Software Development Life Cycle (SDLC), Agile Methodologies, Regression Analysis

Education Certifications & Professional Development

Master of Business Administration (MBA) Graduate with Distinction in Finance; Emphasis in Accounting & Economics – WSU, Wichita, KS

Bachelor of Business Administration (BBA) Graduate with Distinction in Finance; Emphasis: Accounting & Economics – WSU, Wichita, KS “Agile+SaaS+Cloud – Software as a Service” CS169.1 Certificate – Harvard, MIT, and Berkeley “edX” Online Training, 2014

Power BI & Expert Excel - Microsoft, UDEMY, Chandoo, DataCamp XelPlus, MATLAB, etc. (Spreadsheets since Lotus!)

Chartered Financial Analyst (“CFA”) #219621 – CFA Institute

Contact this candidate