Simera Professional Key (SPK)

Jose P

Guatemala

Business Intelligence Analyst

$ 4,300/month

6 yrs exp

Business Intelligence and Analytics professional with 5+ years of experience designing data ecosystems, regional Business Intelligence capabilities, and Microsoft Power Platform solutions for organizations across Latin America and the United States. Specialized in transforming complex business processes and large-scale datasets into scalable analytical systems that enhance decision making, operational efficiency, and financial control. Experienced in partnering directly with C-level executives i…

Skills

  • Agile
  • Automation
  • Business Intelligence
  • C
  • CI/CD
  • data structures
  • ETL
  • Finance Reporting
  • Git
  • Java
  • Jira
  • Linux
  • Microsoft PowerPoint
  • Microsoft Project
  • Microsoft Word
  • Python
  • Scrum
  • Solution Architecture
  • AdvancedMD
  • Business Process Optimisation
  • C#
  • Data Warehousing
  • Microsoft Power Apps
  • Oracle
  • Phyton
  • Power Automate
  • Power BI
  • React Native
  • Snowflake
  • SSH
  • Web Analytics
  • Financial Reporting
  • Territory Management
  • Organization
  • Python/R
  • Data Interpretation
  • Business Intelligence Tools
  • Time Series Analysis
  • Scriptwriting
  • Business Automation
  • CICD
  • Data engineering
  • UI Design
  • Analitic
  • PowerBI
  • Python3
  • Process Optmization
  • AI Design
  • Algorithms
  • Integration
  • Paython
  • Java.
  • Process Automation
  • Business Process Documentation
  • Technical Documentation
  • Data integration
  • Microsoft Power Point
  • HR Analiytics
  • SOP & Technical Documentation
  • GitHub Actions
  • Analítico
  • Scripting
  • analytics
  • Business Analysis & Requirements Gathering
  • Business Process Optimization
  • DB (management, normalization, joins, transactions, schema design, indexing, data modeling)
  • Operational Reporting
  • Business Intelligence (BI)
  • Advanced SQL & Data Analysis
  • o Technical Documentation Skills
  • Business Process Automation
  • AWS S3
  • Financial Routines
  • Data Quality
  • Power BI Development
  • Executive Dashboard Design
  • ETL Development
  • Power Platform
  • Rapid Learning of New Technologies

Jose P

Guatemala

Business Intelligence Analyst

$ 4,300 /month

Part Time: $ 2,450/month

6 yrs exp

Business Intelligence and Analytics professional with 5+ years of experience designing data ecosystems, regional Business Intelligence capabilities, and Microsoft Power Platform solutions for organizations across Latin America and the United States. Specialized in transforming complex business processes and large-scale datasets into scalable analytical systems that enhance decision making, operational efficiency, and financial control. Experienced in partnering directly with C-level executives i…

Skills

  • Agile
  • Automation
  • Business Intelligence
  • C
  • CI/CD
  • data structures
  • ETL
  • Finance Reporting
  • Git
  • Java
  • Jira
  • Linux
  • Microsoft PowerPoint
  • Microsoft Project
  • Microsoft Word
  • Python
  • Scrum
  • Solution Architecture
  • AdvancedMD
  • Business Process Optimisation
  • C#
  • Data Warehousing
  • Microsoft Power Apps
  • Oracle
  • Phyton
  • Power Automate
  • Power BI
  • React Native
  • Snowflake
  • SSH
  • Web Analytics
  • Financial Reporting
  • Territory Management
  • Organization
  • Python/R
  • Data Interpretation
  • Business Intelligence Tools
  • Time Series Analysis
  • Scriptwriting
  • Business Automation
  • CICD
  • Data engineering
  • UI Design
  • Analitic
  • PowerBI
  • Python3
  • Process Optmization
  • AI Design
  • Algorithms
  • Integration
  • Paython
  • Java.
  • Process Automation
  • Business Process Documentation
  • Technical Documentation
  • Data integration
  • Microsoft Power Point
  • HR Analiytics
  • SOP & Technical Documentation
  • GitHub Actions
  • Analítico
  • Scripting
  • analytics
  • Business Analysis & Requirements Gathering
  • Business Process Optimization
  • DB (management, normalization, joins, transactions, schema design, indexing, data modeling)
  • Operational Reporting
  • Business Intelligence (BI)
  • Advanced SQL & Data Analysis
  • o Technical Documentation Skills
  • Business Process Automation
  • AWS S3
  • Financial Routines
  • Data Quality
  • Power BI Development
  • Executive Dashboard Design
  • ETL Development
  • Power Platform
  • Rapid Learning of New Technologies

Business Intelligence Analyst

Alleviate Financial Solutions
March 2024 - present

Designed and implemented an enterprise platform on Microsoft Power Platform used by more than 200 employees to manage regulatory complaints, integrating Power Apps, Power Automate, Microsoft Teams, and Outlook to automate case assignment, investigations, tracking, and audit controls. Developed executive dashboards used by C-suite executives, management teams, and operational stakeholders consolidating critical metrics across millions of monthly records in Snowflake and establishing a single trusted source of truth for decision-making. Automated bonus calculations using advanced DAX logic in Power BI, reducing manual compensation errors by 20% and generating approximately $6,000 in annual direct savings. Eliminated 100% of manual Excel records in the critical escalation process, reducing reputational risk and strengthening internal audit controls in a highly regulated financial company. Structured an analytical layer over an ecosystem with millions of monthly records in Snowflake, aligning metrics across three key functional areas (operations, finance, and executive leadership) and establishing the organization’s “single source of truth” for reporting. Developed more than 20 business automation workflows using Power Automate, integrating CRM systems, databases, Excel, Outlook, and Microsoft Teams to support operational, commercial, and executive reporting processes.

Regional Business Intelligence Coordinator

Corporación Multi Inversiones (CMI)
January 2022 - March 2024

Led the development of regional Business Intelligence capabilities following the AIS Bakery acquisition, establishing analytical standards and reporting frameworks across operations in seven Latin American countries. Designed a relational model integrating 12 SAP tables —each containing hundreds of thousands of records —from SQL Server, creating multi-country analytical views that consolidated transactional and financial regional data. Developed 7 executive dashboards supporting analysis of approximately $20M in monthly sales across Guatemala, El Salvador, Honduras, Panama, Mexico, Colombia, and the Dominican Republic, enabling strategic commercial decisions. Implemented advanced DAX logic to standardize commissions and freight tax calculations across 7 countries, eliminating 30 monthly person-hours previously spent on manual financial reconciliation. Reduced approximately $5,000 in annual costs caused by commission-calculation errors, strengthening regional financial control and reducing operational inconsistencies. Presented quarterly results to 7 country managers and the regional CEO, actively participating in performance reviews and alignment of corporate strategic metrics. Aligned regional metrics with a corporate grouping (B4B) and multiple internal analytical units, facilitating post-acquisition integration across the corporate ecosystem.

E-Commerce Systems Analyst

Unisuper S.A
June 2020 - January 2022

Analyzed thousands of monthly rejected transactions on the e-commerce platform, identifying root causes and improving resolution times through coordination with customer service to recover potentially lost sales. Designed and developed ETL processes using Oracle and Python/Jupyter to support audience segmentation and activation campaigns targeting more than 70,000 users. Executed SMS and email campaigns using AWS services (S3 and SES), managing data storage and distribution for scalable digital communications. Implemented digital measurement on a platform with thousands of monthly active users using Google Analytics and Data Studio to monitor user behavior and commercial performance.

Smart Scores

Communication
90
Role Fit
95
Adaptability
80
Problem-solving
90

Smart Skills

beta