Carlos Arturo Crespo Smith
Carlos Arturo Crespo Smith

Data Analyst

Actively looking · Member since 26 Feb 2025
Location
Mineral de la Reforma, Mexico
Desired salary
Unspecified
Work preference
Remote Only / Full Time
Experience level
Mid

About

Professional summary

I am a Data Analyst with more than three years of focused experience in data analytics and business intelligence, supported by a professional trajectory spanning over five years. I transform scattered operational and financial data into clear, decision-ready insights for leadership teams.

I specialize in reporting automation, SQL, Excel, Power Query, DAX, Power BI, Tableau, and Python-based analysis. My work includes building ETL workflows, cleaning and validating data, developing KPI reporting, and creating visualizations that make complex information actionable.

At EFYDE, I reduced financial report processing time by 90% through Power Query automation and improved leadership review efficiency by consolidating dispersed metrics into core daily KPIs. I also helped scope the data architecture for a company-wide commercial dashboard.

In the Government of the State of Hidalgo, I automated reporting processes across five departments, reducing institutional report delivery time by 60% and lowering data-entry errors. I produced strategic reports on environmental and health topics that supported public policy discussions and executive decision-making.

My experience also includes sustainability analysis at the Laguna Verde Nuclear Power Plant, where I streamlined environmental regulatory data collection. Through independent portfolio projects, I have applied SQL, PostgreSQL, Python, SciPy, Mann-Whitney U tests, and Z-tests to competitive intelligence, operational efficiency, and A/B testing audits.

I bring analytical thinking, data storytelling, stakeholder management, and a cross-industry perspective from government, energy, and financial-services environments. I am comfortable collaborating with remote teams and quickly adapting to new business contexts and data ecosystems.

Skills

25 capabilities

Tech stack & tools

Working toolkit

Data Stores

Development

Languages & Frameworks

Libraries

Experience

Career history

Business Intelligence Analyst EFYDE

Automated financial data transformation workflows with Power Query, reducing financial report processing time by 90% and freeing dozens of team hours each week. Consolidated approximately 20 dispersed metrics into five core KPIs for a daily financial snapshot, reducing leadership morning review time by roughly 70%.

Built a Power Query hierarchy model that classified partners across more than 20 referral tiers, improving partner activity visibility from near-zero to full coverage. Scoped the data architecture for a company-wide commercial dashboard by mapping six department data sources and gathering requirements with department directors.

Data Analysis & Insight Coordinator Government of the State of Hidalgo

Redesigned and automated the Excel reporting process across five departments, reducing institutional report delivery time by 60%. Implemented validation checks that lowered data-entry errors by approximately 30% to 40% and standardized data collection fields to reduce KPI review meetings from eight hours to two.

Produced more than 30 strategic reports on environmental and health topics using a standardized reporting workflow that informed public policy discussions. Delivered 14 quarterly executive reports consolidating KPIs from all organizational areas, using Microsoft Publisher to support high-level decision-making.

Sustainability Analyst CFE - Laguna Verde Nuclear Power Plant

Systematized environmental license renewal data collection and consolidation in Excel for regulatory reporting activities.

Reduced regulatory data consolidation time from weeks to days by organizing and standardizing the collection workflow for environmental data.

Data Analyst Portfolio Projects

Conducted a competitive intelligence audit using SQL and PostgreSQL on a nine-table relational database. Identified that a 12-title imprint achieved three times higher per-book engagement density than the top-volume supplier, which had 42 titles.

Performed an operational efficiency audit using Python and SciPy on more than 1,000 call-center operators, applying business rules and Mann-Whitney U tests. Conducted an A/B test forensic audit with Python and Z-tests, identifying an undersized sample, seasonal confounding, and a tracking bug that prevented a poorly measured production rollout.

Education

Learning history

UPAEP

B.Sc., Environmental Engineering

Bachelor of Science in Environmental Engineering.

SmartProAcademy

Certificate, Advanced Excel

Advanced Excel certification.

A2 Capacitación

Certificate, Advanced Excel, Power Pivot, Power BI & SQL

Training in Advanced Excel, Power Pivot, Power BI, and SQL.

TripleTen

Professional Certificate, Data Analytics

Data Analyst Professional Certificate.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

Jobs Talent AI Tools Salaries
Menu