Mario Mercado
Finance & Analytics Professional
I build data-driven solutions for portfolio management, trading operations, and financial analysis.
About
I'm a finance professional with a passion for bridging the gap between quantitative analysis and strategic decision-making. My career has taken me through diverse roles spanning trade operations, credit analysis, compliance auditing, and financial consulting.
Currently based in the San Francisco Bay Area, I've worked with institutions ranging from Natixis Investment Managers to First Republic Bank, where I've developed expertise in portfolio management, risk assessment, and building data pipelines that drive business outcomes.
I thrive at the intersection of finance and technology—whether that's managing tax-loss harvesting operations across thousands of accounts, building Tableau dashboards for pipeline analytics, or conducting financial modeling for M&A transactions. I'm always looking for opportunities to leverage data to solve complex financial problems.
When I'm not analyzing markets or building models, you can find me playing soccer or exploring the Bay Area's vibrant food scene.
Experience
Jan 2025 — Present Trade Analyst·Natixis Investment ManagersSan Francisco, CA- Perform 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.
- Manage a ~2,400-request tax-loss harvesting pipeline, resolving execution discrepancies and ensuring accurate trade completion during peak cycles.
- Execute drift monitoring and cash controls for multi-strategy portfolios, enabling tax-efficient transitions.
- Bloomberg
- Vestmark
- Portfolio Management
- Tax-Loss Harvesting
Dec 2023 — Dec 2024 Consultant·Inspection Engineers, Inc.Miami, FL- Consulted analytical services for land acquisition.
- Provided financial underwriting, conducted leasing income analysis for commercial and residential purchases, and reported disposition strategies to investors.
- Financial Underwriting
- Lease Analysis
- Real Estate
Aug 2021 — Jul 2023 Loan Analyst·First Republic BankSan Francisco, CA- 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.
- 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 across technology, venture capital, private equity, and entrepreneur clients.
- Credit Analysis
- Tableau
- Pipeline Management
- KYC/AML
Mar 2020 — Aug 2021 Compliance Analyst·USACWashington, D.C.- 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.
- Compliance Audit
- Data Analysis
- Tableau
- Excel
May 2019 — Mar 2020 Accounting Assistant·MC, Inc.Ashton, MD- Provided staff accounting support for the Washington Metro Silver Line by managing invoicing and financial records for a $1B+ Design-Build infrastructure project.
- Processed invoices, DBE compliance documentation, progress reports, and payroll using BillQuick and QuickBooks.
- GAAP/FASB
- QuickBooks
- Infrastructure Finance
Skills
Software & Platforms
- Bloomberg
- Vestmark
- Factset
- Tableau
- SQL
- NetOxygen
- BQE Core CRM
- Salesforce
- Pipeline CRM
Technical Expertise
- Equity Trading
- Model Reconciliation
- Tax-Efficient Harvesting
- Financial Underwriting
- FNMA Certified
- Credit Risk Analysis
- Pipeline Management
Financial Modeling
- DCF Analysis
- Lease-vs-Buy Analysis
- P&L Modeling
- Occupancy Cost Analysis
- Amortization Tables
- LTV/DTI Analysis
Data & Analytics
- Large-Scale Data Analysis
- Data Visualization
- Market Research
- Internal Audit
- Lending Compliance
- KYC/BSA/AML
Certifications
Advanced Valuation and Strategy
M&A, Private Equity, and Venture Capital
Finance & Quantitative Modeling for Analysts
Financial Analysis Specialization
Languages: Spanish (Fluent) & English (Native)
Contact
I'm actively exploring new opportunities in finance and analytics. Whether you're looking for someone to join your team, want to discuss a potential collaboration, or just want to connect—I'd love to hear from you.
Get In Touch