Simera Professional Key (SPK)

Mario C

Guatemala

Business Analyst & BI Consultant & Data Scientist | Functional Lead

$ 3,200/month

10+ yrs exp

Business Analyst and BI Consultant with 30+ years of experience across technology, business analysis, data, business intelligence, and digital transformation. I specialize in connecting business needs with data and technology to improve processes, support decision-making, and create measurable business value. My experience includes Power BI, SQL, data modeling, analytics, process optimization, automation, and AI solutions, working with stakeholders and technical teams to transform business chall…

Skills

  • Azure
  • Big Data
  • Business Analysis
  • Database Design
  • data modeling
  • Knowledge Management
  • Management
  • MySQL
  • Python
  • R
  • SAP
  • 3D Modeling
  • API Integration
  • Business Analyst
  • Data Architect
  • ISAP
  • JD Edwards
  • Oracle
  • Phyton
  • SharePoint
  • SOAP
  • Stakeholder Management
  • Stakeholder Engagement
  • Knowledge Base Management
  • User Adoption Strategies
  • Python/R
  • Data Interpretation
  • Managment
  • Task Prioritization
  • Python3
  • stakeholders management
  • Integration
  • Paython
  • Data integration
  • Business Analytics
  • Senior Stakeholder Management
  • HR managment
  • Client & Stakeholder Management
  • BPO management
  • management
  • Stakeholder Management,
  • Stakeholder engagement
  • MSQL
  • Sprint Planning, Reviews & Retrospectives
  • ERP Integration
  • IA API Integration
  • GSAP
  • Agile (Scrum, Kanban)
  • AI Integration
  • PSE Integration
  • REST API Integrations
  • Tme Management
  • Big Data Architecture
  • Stakeholder Management (C-Level)
  • Agency & Stakeholder Management

Mario C

Guatemala

Business Analyst & BI Consultant & Data Scientist | Functional Lead

$ 3,200 /month

Part Time: $ 2,250/month

10+ yrs exp

Business Analyst and BI Consultant with 30+ years of experience across technology, business analysis, data, business intelligence, and digital transformation. I specialize in connecting business needs with data and technology to improve processes, support decision-making, and create measurable business value. My experience includes Power BI, SQL, data modeling, analytics, process optimization, automation, and AI solutions, working with stakeholders and technical teams to transform business chall…

Skills

  • Azure
  • Big Data
  • Business Analysis
  • Database Design
  • data modeling
  • Knowledge Management
  • Management
  • MySQL
  • Python
  • R
  • SAP
  • 3D Modeling
  • API Integration
  • Business Analyst
  • Data Architect
  • ISAP
  • JD Edwards
  • Oracle
  • Phyton
  • SharePoint
  • SOAP
  • Stakeholder Management
  • Stakeholder Engagement
  • Knowledge Base Management
  • User Adoption Strategies
  • Python/R
  • Data Interpretation
  • Managment
  • Task Prioritization
  • Python3
  • stakeholders management
  • Integration
  • Paython
  • Data integration
  • Business Analytics
  • Senior Stakeholder Management
  • HR managment
  • Client & Stakeholder Management
  • BPO management
  • management
  • Stakeholder Management,
  • Stakeholder engagement
  • MSQL
  • Sprint Planning, Reviews & Retrospectives
  • ERP Integration
  • IA API Integration
  • GSAP
  • Agile (Scrum, Kanban)
  • AI Integration
  • PSE Integration
  • REST API Integrations
  • Tme Management
  • Big Data Architecture
  • Stakeholder Management (C-Level)
  • Agency & Stakeholder Management

Business Analyst & BI Consultant & Data Scientist | Functional Lead

La Riviera Tech
October 2025 - present

Acted as functional lead and tech lead bridging stakeholders, process engineers, developers, and BI teams across complex digital transformation projects. Attended stakeholder interviews and workshops to elicit requirements for BI and actionable KPIs; translated business needs into data flow diagrams, BPMN models, business rules, and KPI/metric definitions aligned to strategic objectives. Defined backlog of functional requirements for BI and system development teams, ensuring compatibility with data models, calculation logic, and integration with websites and analytics layers. Collaborated with product owner and development team on dashboard and indicator design — defining aggregation levels, drill-down logic, RLS security, and actionable visualizations in Power BI and embedded context integration. Managed Agile delivery: backlog definition and prioritization, sprint planning, retrospectives, and velocity tracking to maximize value delivery. Developed training materials, user guides, and hands-on workshops to build sustainable data literacy and data-driven decision culture across organizations; tracked adoption metrics post-deployment. Delivered final product for organizations operating across LATAM and EMEA time zones in a fully remote, cross-cultural environment.

BI Coordinator & Knowledge Management — DMEL Department

World Vision Guatemala / Central America
January 2024 - September 2025

Served as functional lead and BI specialist for a begining to end multi-country BI platform implementation, coordinating requirements between the Senior Leadership Team, project managers, and TI teams across 4 countries. Defined data governance standards, data quality rules, and integration architecture connecting SQL Server, SharePoint, KoboToolbox, MS Forms, and Power BI. Designed and delivered training programs for senior leadership, project managers, and field teams on Power BI, data governance standards, and data-driven reporting — driving adoption of the BI platform across 4 countries. Facilitated Knowledge Management workshops to document processes, lessons learned, and decision frameworks; supported adaptive management cycles. Designed and delivered BI adoption programs for C-suite executives, directors, and operational teams — translating complex dashboards and data models into clear, actionable insights aligned to each audience's decision-making needs. Contributed to strategic planning (OKRs, KPIs, 2030 roadmap) aligned to SDGs, generating data models for the Central American Dry Corridor and ENAB initiatives.

BI Consultant

Colegio de Arquitectos de Guatemala
January 2023 - December 2023

Defined reporting requirements and data models for financial, demographic, and electoral processes; delivered structured Power BI dashboards and data pipelines to institutional decision-makers. Designed and prototyped data models for AI and Big Data solutions in the insurance sector, incorporating computer vision and machine learning components.

BI Consultant & Business Analyst — Competitiveness

AGEXPORT
August 2022 - December 2024

Defined indicator architecture and business rules for an open government electronic KPI system and further as project manager with contractor development team. Dashboard redesign for Competitiveness Observatory (energy, logistics, maritime, customs sectors). Coordinated requirements between business stakeholders and BI development; automated workflows with Power Automate to reduce operational overhead. Produced project management documentation and led software project coordination across concurrent workstreams.

BI Specialist & Digital Transformation Lead

Ministry of Foreign Affairs
March 2020 - July 2022

Trained department heads and administrative staff on newly deployed dashboards and digital tools — ensuring adoption and effective use of BI outputs for operational decision-making. Led requirements gathering and functional specification for 2 institutional information systems; documented BPMN process flows and redesign opportunities. Delivered 21 Power BI dashboards across departments; applied Agile project management methodology for delivery coordination and progress reporting. Analyzed data life cycles to identify redesign and automation opportunities, generating measurable reductions in processing time and repetitive manual tasks.

Process Analyst / Systems Coordinator

Municipality of Guatemala — Cadastre Directorate
January 2016 - March 2020

ISO-9000 process analysis: performance indicators and compliance monitoring (2019–2020). Systems coordination: web/mobile development, Oracle georeferenced database and MySQL databases; satellite and orthophoto data integration for construction registry and GIS. Data architecture & modeling, Power Designer, BPMN.

Project Manager — Operations

DHV Consultants
January 2002 - December 2015

13+ years managing operations, financial projections, process improvement, KPI's impementation and stakeholder coordination in a consulting company for Guatemala City Municipality's modernization.

Smart Scores

Communication
85
Role Fit
95
Adaptability
90
Problem-solving
88

Smart Skills

beta