Mario Enrique Mercado
Professional Experience
Trade Analyst
Natixis Investment Managers
San Francisco, CA
Jan 2025 – Present
- Optimized portfolio performance by reconciling hundreds of equity and fixed models, leveraging SQL to identify variances and provide data-driven insights for risk-adjusted rebalancing.
- Streamlined the end-to-end execution of a ~2,400-request tax-loss harvesting cycle, implementing process improvements that increased operational throughput during peak volumes.
- Spearheaded daily financial controls and drift analysis to enable tax-efficient transitions, utilizing Bloomberg and Vestmark to scale rebalancing frameworks across multi-strategy portfolios.
Consultant
Inspection Engineers, Inc.
Miami, FL
Dec 2023 – Dec 2024
- Structured financial underwriting and market-entry analysis for land acquisitions, building ROI models to evaluate the viability of commercial and residential investment opportunities.
- Developed disposition strategies for investors to project profitability and guide capital deployment decisions.
Loan Analyst
First Republic Bank
San Francisco, CA
Aug 2021 – Jul 2023
- Presented ~50 comprehensive financial profiles per quarter to the Executive Loan Committee, driving $40M+ in strategic capital allocation and refinancing transactions.
- Optimized lending pipeline efficiency by managing high-volume deal flows and utilizing data-driven reviews to maximize growth and loan performance.
- Partnered with Relationship Managers to translate raw financial data into growth opportunities, developing credit-risk frameworks that balanced compliance with targeted client acquisition goals.
Compliance Analyst
Universal Service Administrative Co. (USAC)
Washington, D.C.
Mar 2020 – Aug 2021
- Advised on the strategic allocation of $2.1B+ in federal funding, conducting FCC-mandated compliance audits and PQA assessments to ensure resources were effectively distributed for rural healthcare and education infrastructure.
- Translated audit findings and rate deviation filings into reports for Internal Audit and FCC stakeholders, leveraging Tableau to identify operational anomalies and mitigate long-term compliance risks.
Accounting Assistant
MC, Inc.
Ashton, MD
May 2019 – Mar 2020
- Supported financial operations for the $1B+ Silver Line Metro infrastructure project, ensuring fiscal accuracy and utility coordination during critical project-scaling phases.
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
AI & Development Tools: Claude Code, Gemini, ChatGPT, VS Code, CLI, Git.
Data & Analytics: Python, SQL, Tableau, Large-Scale Data Analysis, Data Visualization, Market Research & Analysis.
Financial Strategy: Credit Risk & Underwriting, Model Reconciliation, Equity Trading, Financial Modeling (DCF, P&L, Lease-vs-Buy, Amortization), Tax-Efficient Harvesting, GAAP, FASB.
Operations & Systems: Pipeline Management, Lending Compliance, Internal Audit, Bloomberg, Vestmark, FactSet, Salesforce, FNMA Certified, NetOxygen, BQE Core CRM, QuickBooks, BillQuick.
Languages: Fluent in Spanish, Native in English.