Loading profile…
Mario Payán
Open to opportunitiesSr. Strategic Analyst
I build data platforms and analytics that uncover revenue, efficiency, and strategic opportunities.
MexicoSr. Strategic Analyst at ADI Global Distribution
About
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
Sr. Strategic Analyst
Leading migration of legacy reports to unified Power BI dashboards and delivering executive-ready analytics for a Fortune 600 retail and distribution company.
Power BIDAXSQLData MigrationSchema DesignExecutive Reporting
Power BI and Visualization Lead
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 BISnowflakeAzure Data FactoryETLData ModelingStakeholder Management
Analytics Engineer
Education
Microsoft
Microsoft Fabric Analytics Engineer certification (in progress) from Microsoft.
Universidad Panamericana
Bachelor's Degree in Economics from Universidad Panamericana in Mexico City.
Universidad Nacional Autónoma de México
Information Security Diploma from Universidad Nacional Autónoma de México.
Coursera
Google Data Analytics Professional Certificate from Coursera.
Microsoft
Microsoft Certified: Power BI Data Analyst Associate certification from Microsoft.
MITx
Supply Chain and Logistics Fundamentals Diploma from MITx, Center for Transportation and Logistics.