Fabián Hernández Data Engineer

DATA ANALYST

LogicSource Inc

Mar 2024 - Current (2 years 3 months)

- Automated a high-effort client dashboard refresh process that consumed most of the team's operational time by migrating Python notebook transformations into SQL stored procedures with CTEs, enabling scheduled production updates by client schema. - Led the first working prototype and implementation foundation for the Cross Client Project, consolidating client-specific flat tables into a normalized, reusable data asset for spend, payment terms, supplier, material, and category analysis. - Designed SQL and Python/PySpark workflows aligned with AWS Glue Spark patterns to reconcile inconsistent schemas, ingest data from S3 data lake layers, apply validation logic, and prepare curated datasets for Redshift and downstream analytics. - Built Powe

DATABASE ENGINEER

Indra

Aug 2023 - Mar 2024 (8 months)

- Supported data engineering, database development, and production database server operations for utility and enterprise clients, working with Oracle, SQL Server, Unix/Linux servers, SQL-based data pipelines, shell scripts, and PowerShell. - Contributed to data solutions for electric utility operations, including power transmission, distribution, commercialization, monitoring, and alerting workflows, helping consolidate operational indicators across complex public-sector environments. - Participated in detailed requirements discovery and data audit sessions with client stakeholders, aligning business areas around shared definitions for key data points, indicators, and reporting logic. - Helped define the technical and data scope for 20+ pip

D

DATABASE ANALYST

Deca Arquitectura

Jul 2021 - Jun 2023 (2 years)

- Built Power BI dashboards to track commercial and operational indicators for internal teams. - Extracted and prepared data from Oracle for comparative analysis, market research, and recurring reports. - Cleaned and standardized datasets using SQL, Python, and Excel to improve reporting consistency. - Supported administrative and commercial teams with ad hoc analysis, dashboard updates, and report automation.

D

COMMERCIAL EXECUTIVE

Deca Arquitectura

Apr 2018 - Jul 2021 (3 years 4 months)

Fabián Hernández

About

Detail

Timeline

Résumé