Mario Enrique Mercado
Professional Experience
Trade Analyst
Natixis Investment Managers
San Francisco, CA
Jan 2025 – April 2026
- Reconciled hundreds of SMA/UMA equity and fixed income models for portfolio managers, using SQL to identify variances and mitigate portfolio risk.
- Drove process improvements across a ~2,400-request tax-loss harvesting cycle, resolving trade discrepancies and maintaining data accuracy during peak volumes.
- Conducted daily financial controls and drift analysis to enable tax-efficient transitions, using Bloomberg and Vestmark to align rebalancing frameworks across multi-strategy portfolios.
Consultant
Inspection Engineers, Inc.
Miami, FL
Dec 2023 – Dec 2024
- Built a ~20-prospect, $50M+ investor pipeline by leveraging existing client relationships, advancing qualified leads in BQE Core CRM from initial outreach to proposal stage for principal-led close.
- Spearheaded underwriting and leasing income analysis to evaluate land acquisitions and multi-sector investments.
- Developed disposition strategies that projected ROI and surfaced data-driven market-viability insights for investors.
Loan Analyst
First Republic Bank
San Francisco, CA
Aug 2021 – Jul 2023
- Underwrote ~50 residential and commercial deals per quarter ($1M–$10M each) for 3 Relationship Managers, leading weekly pipeline reviews and tracking deal status in Salesforce Financial Services Cloud.
- Flagged cross-sell opportunities across Lending and Wealth Management portfolios, joining client meetings to deepen relationships and expand wallet share.
- Presented credit memos to the Executive Loan Committee, informing $100M+ in quarterly capital allocations.
Compliance Analyst
Universal Service Administrative Co. (USAC)
Washington, D.C.
Mar 2020 – Aug 2021
- Conducted FCC compliance audits and PQA assessments across $2.1B+ in rural healthcare and educational programs, using Tableau to escalate rate deviations and fund disbursement irregularities to FCC stakeholders.
Accounting Assistant
MC, Inc.
Ashton, MD
May 2019 – Mar 2020
- Managed financial records and invoicing for the $1B+ Silver Line Metro infrastructure project, ensuring GAAP/FASB compliance and utility coordination during critical project 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, Trend 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: Salesforce, BQE Core CRM, Pipeline Management, Lending Compliance, Internal Audit, Bloomberg, Vestmark, FactSet, FNMA Certified, NetOxygen, QuickBooks, BillQuick, Excel, PowerPoint.
Languages: Fluent in Spanish, Native in English.