Mario Payan

Mario Payan

About

Detail

Remote-ready Senior Data Analytics & Technology Leader, AI Leveraging, Business Intelligence, Strategic Project Management, ERP/CRM Implementation
Santiago de Querétaro, Querétaro, Mexico
Contact Mario regarding: 
work
Full-time jobs
Starting at USD5.5k/month
Flexible work
Starting at USD60/hour
groups
Networking

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • R
    Sr. Strategic Analyst
    Resideo Technologies ADI Global
    Aug 2025 - Current (1 year)
    • Design and deliver executive-level analytics frameworks for Category Marketing at Resideo Technologies, a Fortune 600 US retail and distribution company. • Reduce time-to-insight by 50% by consolidating 20+ legacy Excel and SSRS reporting into a single Power BI dashboard, unifying category marketing KPIs and incorporating data from a new ERP system for the first time. • Contribute to post-acquisition data warehouse consolidation, data mapping, transformation, and schema design across systems handling millions of transactions, 100K+ SKUs, and billions in sales — delivering executive dashboards from the merged data. • Partner with executives and cross-functional stakeholders company-wide to translate business questions into analytics soluti
  • Hexaware Technologies
    Power BI and Visualization Lead
    Hexaware Technologies
    Sep 2024 - Aug 2025 (1 year)
    • Led end-to-end Power BI implementation for a Fortune 500 US mining company, delivering 15+ dashboards across engineering, procurement, and document control — reducing reporting time by 50% and eliminating 10+ manual processes. • Migrated 15+ Power Query report data to Snowflake, consolidating Oracle and Azure data sources into a scalable ETL framework via Azure Data Factory, significantly improving dashboard performance and data reliability. • Served as primary BI point of contact for engineers and executives across 3 departments, translating complex operational requirements into production-ready dashboard solutions.
  • V
    Analytics Engineer
    Ventagium Data Consulting
    Feb 2023 - Aug 2024 (1 year 7 months)
    Delivered end-to-end analytics solutions across three global enterprise clients spanning retail manufacturing, social media, and industrial equipment — owning each engagement from requirements gathering through production deployment. • Designed and deployed 4 Microsoft Fabric-powered Power BI dashboards for the world's largest bedding manufacturer, covering inventory and supply chain operations — reducing customer response time in retail stores by 90%. • Built 2 Google Data Studio dashboards for the world's largest social media platform, delivering PR and lobbying spend analytics across Latin America and enabling an 18% reduction in spending while retaining full regional influence. • Designed and deployed a Power BI-embedded compensation en
  • C
    Analytics and Business Development Manager
    Capa Tres
    Sep 2017 - Feb 2023 (5 years 6 months)
    • Designed and deployed Power BI dashboards adopted by 50+ associates, reducing report turnaround time by 90% and enabling data-driven decisions across sales and marketing. • Directed sales and marketing efforts for technology products and services, achieving 10%+ annual growth. • Implemented CRM and ERP systems across all departments, unifying company data, creating a single source of truth and enabling cross-functional reporting that reduced decision lag and improved sales and operational efficiency. This facilitated a 15% annual sales growth and the opening of three new locations.
  • T
    Operations Manager
    Transpoint Intermodal
    Mar 2016 - Aug 2017 (1 year 6 months)
    • Directed multi-location operations across 5 strategic ports and inland sites, implementing process controls across 3PL, intermodal, M&R, and transportation that created measurable, trackable service performance for the first time. • Led end-to-end design and deployment of a new ERP system, building a unified operational data layer that streamlined S&OP planning and gave leadership real-time visibility across all sites, allowing company expansion to 2 new sites in one year.
  • C
    CEO / Founder
    CSP Consultores
    Oct 2007 - Oct 2010 (3 years 1 month)
    • Founded and ran a foreign trade and logistics consultancy, delivering international sourcing strategies, process automation, and custom software implementations across 10+ SME clients in construction, real estate, distribution, logistics, and transportation - reducing lead times, expanding supplier networks, and driving operational growth across organizations employing hundreds of workers.
  • S
    Sales and Support Operations Manager
    SYLO (Intermodal Cargo Terminal)
    Jun 2002 - Mar 2016 (13 years 10 months)
    • Single-handedly designed, built, and deployed the ERP/CRM system still running the company today — replacing manual processes with real-time operational data and directly enabling a 400% growth in container operations within one year. • Modernized and expanded the ERP/CRM through successive iterations over 14 years, continuously improving system capabilities as the company scaled across new operations and market segments. • Directed teams of 30+ across IT, logistics, customer support, equipment control, and access control, implementing structured KPI reporting that formalized performance tracking company-wide.
Education verified_user 0% verified
  • Microsoft
    Microsoft Fabric Analytics Engineer (In Progress)
    Microsoft
    Jan 2026 - Current (7 months)
  • Microsoft
    Microsoft Certified: Power BI Data Analyst Associate
    Microsoft
    Jan 2024 - Jan 2026 (2 years 1 month)
  • C
    Google Data Analytics Professional Certificate
    Coursera-Google
    Jan 2020 - Jan 2021 (1 year 1 month)
  • MITx
    Supply Chain and Logistics Fundamentals Diploma
    MITx
    Aug 2015 - Jul 2016 (1 year)
  • Universidad Nacional Autónoma de México
    Information Security Diploma
    Universidad Nacional Autónoma de México
    May 2001 - May 2002 (1 year 1 month)
  • Universidad Panamericana
    Bachelor’s Degree in Economics
    Universidad Panamericana
    Aug 1994 - Dec 1998 (4 years 5 months)