Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Personal Information
Core Skills
Languages
Timeline
Generic

Efrain Prada

Eagle Mountain,Utah

Summary

Results-driven Global Sales Data Analyst at Modere with expertise in data visualization and ETL workflows. Achieved a 40% improvement in query performance and mentored junior analysts, enhancing team efficiency. Proficient in Power BI and SQL, I excel in collaborative environments, delivering actionable insights that drive strategic decision-making.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Global Sales Data Analyst

Modere
Eagle Mountain, UT
01.2024 - 04.2025
  • Administered and optimized SQL Server databases for daily global operations, improving query performance by 40%.
  • Built interactive Power BI dashboards enabling leadership to monitor real-time sales KPIs, driving a 25% faster decision cycle.
  • Designed and maintained ETL workflows, reducing data latency by 30% across reporting systems.
  • Collaborated with operations and marketing, reducing reporting bottlenecks by 20% through cross-system data integrations.
  • Mentored 3+ junior analysts, accelerating team onboarding and reducing dashboard delivery time by 15%.

Founder & Mobile App Developer

AnyJob Technologies
10.2023 - 01.2024
  • Launched 'AnyJob,' a platform connecting skilled professionals with customers; gained 1,000+ users in the first 90 days and facilitated 200+ bookings using Flutterflow & Supabase.
  • Oversaw all phases of app development-UI design, DB setup, QA, deployment-and onboarded 100+ service providers.
  • Engineered scalable database architecture supporting 10,000+ user records with 99.9% uptime reliability for seamless client-provider interactions.
  • Executed growth campaigns resulting in 1,000+ downloads in the first 3 months.

Data Analyst

Modere
Springville, UT
11.2022 - 05.2023
  • Migrated 300+ legacy WebFocus reports to Power BI and PowerBuilder, improving visual clarity and maintainability.
  • Used complex SQL queries and performance tuning to optimize reporting efficiency by 35%.
  • Created fact/dimension tables in support of scalable BI models using Kimball methodology.
  • Automated 15+ ETL workflows using Pentaho, decreasing manual load errors by 40% and enhancing data pipeline efficiency.

Data Analyst

Entrata
Lehi, UT
11.2020 - 08.2021
  • Designed and maintained robust data pipelines with Python and SQL, reducing manual data prep by 50%.
  • Optimized SQL queries to cut average execution time by 40% and reduced server load.
  • Developed interactive dashboards that integrated real-time leasing metrics and client data, improving analysis efficiency by 40% and enabling faster decision-making across three departments.
  • Led multiple cross-team efforts to streamline reporting and validate data integrity.

Network Engineer

SK Express
DeKalb, IL
12.2018 - 05.2019
  • Designed scalable network architecture, reducing downtime by 30%.
  • Managed VPNs, firewalls, and switches; implemented IDS and security protocols.
  • Enhanced bandwidth performance and introduced preventive maintenance strategies.

Education

B.S. - Computer Science

Universidad Rafael Belloso Chacín
Venezuela

A.S. - Computer Science

Colegio Universitario Rafael Belloso
Venezuela

Machine Learning & Data Science Bootcamp -

ZT Academy

Advanced DAX for Power BI -

Maven Analytics

Skills

  • Data analysis and business intelligence
  • Power BI and dashboards
  • ETL workflows and integration
  • Data visualization techniques
  • Statistical modeling and validation
  • Collaborative teamwork and mentoring
  • User experience design principles
  • Strategic analytics and KPI reporting
  • Interactive dashboards development
  • Database management (SQL Server, PostgreSQL, MySQL, MongoDB)
  • Optimization and indexing strategies
  • Automation and transformation scripts
  • Machine learning algorithms (regression, clustering, neural networks)
  • Data wrangling processes
  • PowerBuilder and Flutterflow expertise
  • Supabase and Sisense proficiency
  • WebFocus reporting tools
  • Bilingual communication skills

Certification

  • Data Analysis with Python & Pandas
  • Python Foundations for Data Analysis
  • Advanced DAX
  • Power BI Services
  • Power BI Desktop
  • Thinking Like an Analyst

Accomplishments

  • Migrated over 300+ reports to Power BI-enabling self-service reporting and improving decision speed.
  • Boosted SQL Server performance by 60% at SK Express via intelligent indexing and schema tuning.
  • Built Power BI dashboards that reduced executive reporting time from hours to minutes.
  • Designed SQL disaster recovery plan to ensure business continuity during outages.
  • Trained and mentored junior team members in advanced SQL and Power BI development.

Personal Information

Title: Data Analyst | App Developer

Core Skills

Strategic analytics, KPI reporting, Interactive dashboards (Power BI), ETL (Pentaho), SQL Server, PostgreSQL, MySQL, MongoDB - optimization, indexing, administration, SQL, Python, VB.NET - automation, reporting, transformation scripts, Regression, clustering, neural networks, data wrangling, Power BI, PowerBuilder, Flutterflow, Supabase, Sisense, WebFocus, Team collaboration, mentoring, bilingual communication (Fluent English/ Native Spanish)

Languages

English
Professional
Spanish
Native/ Bilingual
Italian
Elementary

Timeline

Global Sales Data Analyst

Modere
01.2024 - 04.2025

Founder & Mobile App Developer

AnyJob Technologies
10.2023 - 01.2024

Data Analyst

Modere
11.2022 - 05.2023

Data Analyst

Entrata
11.2020 - 08.2021

Network Engineer

SK Express
12.2018 - 05.2019

B.S. - Computer Science

Universidad Rafael Belloso Chacín

A.S. - Computer Science

Colegio Universitario Rafael Belloso

Machine Learning & Data Science Bootcamp -

ZT Academy

Advanced DAX for Power BI -

Maven Analytics

Similar Profiles

CREATE PROFILE
Efrain Prada