Mario Enrique Mercado
Professional Experience
Trade Analyst
Natixis Investment Managers
San Francisco, CA
Jan 2025 – Dec 2025
- Performed daily financial controls across hundreds of equity and fixed income models for SMA/UMA accounts, model reconciliation for pricing and allocations to reduce risk and large variances using Vestmark and Bloomberg.
- Managed a ~2,400-request tax-loss harvesting pipeline, resolving execution discrepancies and ensuring accurate trade completion during peak cycles.
- Executed drift monitoring, and cash controls for multi-strategy portfolios, enabling tax-efficient transitions.
Consultant
Inspection Engineers, Inc.
Miami, FL
Dec 2023 – Dec 2024
- Consulted analytical services for land acquisition. Provided financial underwriting, conducted leasing income analysis for commercial and residential purchases, and reported disposition strategies to investors.
Loan Analyst
First Republic Bank
San Francisco, CA
Aug 2021 – Jul 2023
- Presented ~50 financial profiles per quarter and closed $40M+ in refinancing transactions, leading the full loan lifecycle from origination through post-close while preparing credit narratives, verifying KYC/BSA/AML requirements, and assessing liquidity, LTV, DTI, credit history, tax considerations, and market risk using NetOxygen.
- Managed a high-volume lending pipeline through weekly portfolio reviews, analyzing datasets and visualizing risk metrics to optimize pipeline flow and exposure using Pipeline CRM, Excel, and Tableau.
- Partnered with Relationship Managers and the Executive Loan Committee to evaluate credit risk and support prospecting for active deals across technology, venture capital, private equity, entrepreneur, and BMR/LMI clients.
Compliance Analyst
Universal Service Administrative Co. (USAC)
Washington, D.C.
Mar 2020 – Aug 2021
- Conducted FCC compliance audits and PQA assessments for Universal Service Fund programs, ensuring accurate allocation of $2.1B+ in approved funding for rural schools and healthcare facilities.
- Managed rate deviation filings, maintained rate matrices and product documentation, and prepared audit reports for Internal Audit and FCC stakeholders using Excel and Tableau.
Accounting Assistant
MC, Inc.
Ashton, MD
May 2019 – Mar 2020
- Provided staff accounting support for the Washington Metro Silver Line by managing invoicing and financial records for a $1B+ Design-Build infrastructure project, supporting project execution, utility coordination, and compliance with GAAP/FASB standards using Excel and BQE Core CRM.
- Processed invoices, DBE compliance documentation, progress reports, and payroll using BillQuick and QuickBooks.
Education
High Point University
B.S.B.A: Finance with minor in Accounting
High Point, NC
2015 – 2019
- Investment Club: Managed an endowment fund, conducted stock valuation, and prepared reports for stakeholders.
- Club Soccer: Club soccer member for 4 years.
Certificates & Achievements
- Advanced Valuation and Strategy - M&A, Private Equity, and Venture Capital, Erasmus University Rotterdam (2024)
- Finance & Quantitative Modeling for Analysts, The Wharton School of the University of Pennsylvania (2024)
Additional Skills & Interests
Software Skills: Bloomberg, Vestmark, Factset, Tableau, NetOxygen, BQE Core CRM, and Salesforce.
Technical Skills: Equity Trading, Model Reconciliation, Tax-Efficient Harvesting, Underwriting, FNMA Certified, Credit Risk, Pipeline Management, Tax Analysis, Financial and Data Analysis, Lending Compliance, Market Research, Internal Audit, Financial Modeling (DCF, Lease-vs-Buy Analysis, P&L, Occupancy Cost, Amortization Tables), Large-Scale Data Analysis, and Data Visualization.
Languages: Spanish (Fluent) & English (Native).