Open to opportunities

Mario Payán

@mariopayn

Message

I build data platforms and analytics that uncover revenue, efficiency, and strategic opportunities.

Mexico

Message

What I'm looking for

I'm looking for a remote US-hours role where I can lead end-to-end data strategy, BI delivery, and automation to uncover revenue and efficiency opportunities.

At ADI Global Distribution, I cut time-to-insight 50% by migrating 20+ legacy Excel and SSRS reports into a unified Power BI dashboard for Category Marketing. I lead analytics delivery from data strategy and schema design through executive-ready dashboards across millions of transactions and 100K+ SKUs.

Previously at Hexaware Technologies and Ventagium Data Consulting, I delivered Power BI, Snowflake, Microsoft Fabric, and Azure Data Factory solutions for Fortune 500 and global industrial, mining, retail, supply chain, and technology clients. My work cut reporting time by 50%, customer response time by 90%, and calculation errors by 90% while eliminating manual processes.

At Capa Tres, I originated a new revenue line, built a board-approved business case, and launched two new divisions. I also drove 15% annual sales growth through a unified ERP/CRM implementation and data-driven sales and marketing strategy.

Across 20+ years, I've led teams of 30+ and built ERP/CRM, BI, and operational systems that support growth. I combine hands-on technical delivery with executive communication in English and Spanish.

Experience

Work history, roles, and key accomplishments

Current

Sr. Strategic Analyst

Current

ADI Global Distribution

Aug 2025 - Present (1 year)

Leading migration of legacy reports to unified Power BI dashboards and delivering executive-ready analytics for a Fortune 600 retail and distribution company.

Power BI DAX SQL Data Migration Schema Design Executive Reporting

Power BI and Visualization Lead

Hexaware Technologies

Sep 2024 - Aug 2025 (11 months)

Led a 15+ dashboard Power BI implementation for a Fortune 500 mining company, cutting reporting time by 50% and eliminating manual processes. Migrated reports to Snowflake and consolidated data sources into a scalable ETL framework.

Power BI Snowflake Azure Data Factory ETL Data Modeling Stakeholder Management

Analytics Engineer

Ventagium Data Consulting

Feb 2023 - Aug 2024 (1 year 6 months)

Deployed Microsoft Fabric-powered Power BI dashboards for retail and industrial clients, cutting response times and manual work. Built Google Data Studio dashboards for a major social media platform and migrated Tableau to Power BI.

Power BI Microsoft Fabric Google Data Studio Tableau DAX Data Engineering

Analytics and Business Development Manager

Capa Tres

Sep 2017 - Feb 2023 (5 years 5 months)

Originated new revenue lines and drove 15% annual sales growth by implementing unified ERP/CRM systems and Power BI dashboards. Directed sales and marketing strategy across multiple industries.

Power BI ERP CRM Implementation Business Development Sales Strategy Data Analytics

Operations Manager

Transpoint Intermodal

Mar 2016 - Aug 2017 (1 year 5 months)

Led design and deployment of a new ERP system enabling expansion into new sites. Directed multi-location operations and implemented process controls across 3PL, intermodal, and transportation.

ERP Implementation Operations Management Process Improvement Logistics

Sales and Support Operations Manager

SYLO / SID GMG

Jan 2010 - Dec 2016 (6 years 11 months)

Directed teams of 30+ across IT, logistics, and customer support, implementing structured KPI reporting. Modernized ERP/CRM platform to support company growth.

Team Leadership KPI Reporting Operations