Aldo Alan Reyes Hernandez

Business Intelligence & Data Analyst

Working Experience

🧠 Intel Project Analyst

Contingent Worker at Arcthec L.L.C, sub-employed by Praxis
Intel Internal Sponsor: Kate Roberson – Trainer Manager (Developer Focus)
Duration: Nov 2021 – Mar 2025 · 3 years 5 months
Location: Portland, Oregon / Remote

📊 Dashboard Design & Business Intelligence

  • Supported teams across SATG, SP&E, DEP, and Developer Academia by designing Power BI dashboards tailored to specific business needs.
  • Delivered operational and strategic reports, including:
    • OKR & KPI Dashboards
    • Program Overview Summaries
    • Learning Program Consumption Pipelines
    • Developer Activity & Funnel Reports
    • Statistics, Demographics, NPS & Satisfaction Surveys
    • Data Quality Metrics

🔗 Data Integration & Modeling

  • Analyzed data structures from sources such as:
    • Azure Snowflake
    • Cloudera Impala
    • Salesforce Objects
    • Smartsheet
  • Transformed and modeled data using Power Query Editor (M language), with a preference for Star Schema architecture.

📈 Insight Generation & Visualization

  • Built actionable visualizations using DAX formulas and interpretative charts in Power BI.
  • Focused on clarity and usability to support decision-making across technical and business teams.
  • Designed dashboard frames and UI elements in Figma for a polished user experience.

🎓 Certified Instructor Program Dashboard

As Program Analyst, I provided accurate and timely insights into the Instructor Developer Program.
Initial data source: Salesforce → migrated to Power BI for enhanced flexibility and dynamic reporting.

🧩 Data Model Structure

  • Connected Power BI to Salesforce Objects via configured drivers.
Built a robust data model
- FactLearningPlan - FactCertifiedStatus - FactInstructors - FactInstructorActivity - DimAccounts - DimGeo - DimDate - DimCourses - DimLearningPlans - DimInstructorSponsors
📌 Applicants Pipeline
- Visualized applicant progress across learning plans and courses. - Enabled drill-down functionality for Program Managers and Sponsors. - Interactive filters: geography, sponsor, company, course status. - Highlighted “Pending Approval” status for managerial action. - Exportable Applicant Status table for Excel analysis. - Implemented custom DAX measure: **Days Inactive** (based on Salesforce activity field).
Applicants Pipeline
📋 Program Overview
Summary of program stages, enrollment metrics, and certification progress.
🎓 Instructor Activity
Tracking of instructor engagement, course delivery, and certification support.
✅ Certified Instructors
Overview of certified instructors by region, sponsor, and program.
👤 User Profile
Individual applicant profiles with progress, prerequisites, and activity logs.
📊 Data Quality
Metrics on data completeness, accuracy, and update frequency.
🩺 Program Health
Aggregated indicators of program performance, satisfaction, and growth.

🧪 Workshop Quality Survey Dashboard

Insights into workshop effectiveness, participant feedback, and satisfaction scores.

👨‍💻 Developers Trained

Tracking of developer engagement, training completions, and certification outcomes.

🎓 Docebo LMS Dashboard

Monitoring of learning paths, course consumption, and user progression within Docebo LMS.

Conagra Brands

Full-time Employment
Manager: Arely Perez, Team Leader Sales Capabilities & Analytics
Duration: Jan 2014 - Jan 2020 · 6 years 1 month
Location: Mexico City

🧠 Conagra Sales Analyst

Mar 2017 – Jan 2020 · 2 year 11 month

📊 Sales Intelligence Overview

🔍 Data Consolidation & Reporting

  • Sales Reporting & Data Mining
    Generation of sales reports and data mining for strategic insights.
  • Sell-Out Visibility Across Channels
    Consolidation of information provided by clients across Supermarket chains, Price Clubs, and Wholesalers to deliver company-wide Sell-Out visibility.

🧭 Strategic Analysis

  • Scope & Cataloging Opportunity Matrix
    Mapping of product reach and cataloging opportunities.
  • SI vs SO Analysis
    Comparative analysis between Sell-In and Sell-Out.
  • Sales Trends & Perfect Store Tracking
    Monitoring of sales trends and Perfect Store Model performance.
  • Launches, Seasons & Promotions
    Targeted analysis of product launches, seasonal campaigns, and promotional activities.

🛠️ Data Modeling & Automation

  • Data Model Structuring
    Design and structuring of data models for analysis and visualization.
  • Report Design
    Development of business-oriented report layouts.
  • ETL Automation with Power Query Engine
    Automation of ETL processes using Power Query Engine.

🏢 Operational Leadership & Process Management

Feb 2016 – Mar 2017 · 1 year 2 month

👥 Team Leadership & Coordination

  • Administrative Team Oversight
    Led the administrative team—including direct supervision of Administrators and Data Entry Operators, and indirect coordination with Liquidators and Warehouse Staff—to ensure daily operations across 7 national distribution centers (CEDIS).

🚚 Operational Execution

  • Pre-Sales Data Capture
    Oversaw the accurate and timely capture of pre-sales information.
  • Cargo Flight Scheduling
    Managed logistics related to cargo flights and delivery planning.
  • Inventory Reconciliation
    Ensured consistency and accuracy in inventory records across all centers.
  • Liquidation Audits & Promotions
    Conducted audits of liquidation processes and promotional activities.
  • Billing & Invoicing
    Supervised the generation and validation of invoices.

🔧 Process Optimization & Reporting

  • Process Improvement Initiatives
    Identified and implemented enhancements to operational workflows.

  • Channel Reporting
    Delivered strategic reports to Channel Management and Executive Leadership.

    📈 Management Control Analyst

    Feb 2015 – Feb 2016 · 1 year 1 month

🧮 Budget Management & Process Optimization

  • Trade Marketing Budget Oversight
    Improved the budget management process for the Commercial Trade Marketing area by delivering key performance indicators (KPIs) on process timing, balances, and deviations.

  • Relational Database Implementation
    Designed and implemented a backend system using a relational database in Microsoft Access to support budget tracking and reporting.

  • KPI Delivery & Operational Visibility
    Enabled visibility into financial and operational metrics through automated reporting and structured data flows.