Excel (VBA)
Jaziel Alberto Pineda Franco
Business Intelligence Specialist
Puebla
Summary
Detail-focused data analyst with knowledge in business intelligence tools, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for data analysis.
Overview
9
9
years of professional experience
4
4
years of post-secondary education
3
3
Certificates
3
3
Languages
Work History
BI Specialist and Cost Engineer
Audi México S.A. de C.V.
Puebla
02.2018 - Current
- Development, design and programming of interactive dashboards with Microsoft Power BI for different kind of KPIs (costs, failures production, personnel absenteeism).
- Key-user for Microsoft Power BI Service/Desktop and SAP Business Objects.
- Achievement of ETL processes for data analysis and modeling using Power Query.
- Dimensional Data Modeling using star and snowflake schemas in Microsoft Power BI.
- Development of flows and apps using Microsoft Power Automate and Microsoft Power Apps respectively, for different purposes and areas within company.
- Development, design and programming of macros with VBA in Excel at advanced level.
- Monitored and reported budgetary discrepancies to management to maximize reporting efficiency and finalized spending plans.
- Calculation and distribution of annual budget for production area.
- Forecast calculation for different categories of overhead expenses.
Material Management Specialist
Audi México S.A. de C.V.
Puebla
11.2016 - 02.2018
- Monitored inventory to maintain sufficient supply levels to meet business and customer needs.
- Internal scrap charges (not suppliers) in SAP system.
- Direct communication with quality area and suppliers to dispose of non-conforming material.
- Monitoring costs charged to production area, generated by nonconforming material (Scrap).
Petroleum Engineer
Academia Nacional de Investigación y Desarrollo A.C.
Morelos
06.2014 - 06.2016
- Performing basic and advanced petrophysical tests in well cores (naturally fractured carbonates and sandstones) with Core Laboratories and Core Test equipment.
- Cleaning of cores based on API RP-40 standard.
- Preventive and corrective maintenance to computers at software and hardware level.
Education
Bachelor of Science - Petroleum Engineering
Universidad Veracruzana
Poza Rica, Veracruz, México 08.2010 - 12.2014
Skills
Data visualization
Analyzing data
Budget and cost analysis
Team collaboration
Software
Microsoft Power BI
Microsoft Power Automate
Microsoft Power Apps
SAP Business Objects
SAP GUI (ERP)
Tabular Editor
DAX Studio
Think-Cell
SSMS
Python
Visual Studio C#, WPF
Certification
MOS: Microsoft Excel Expert
Timeline
Python For Data Science
10-2023
EF SET Certificate English: C1 Level
09-2022
MOS: Microsoft Excel Expert
06-2022
BI Specialist and Cost Engineer
Audi México S.A. de C.V.
02.2018 - Current
Material Management Specialist
Audi México S.A. de C.V.
11.2016 - 02.2018
Petroleum Engineer
Academia Nacional de Investigación y Desarrollo A.C.
06.2014 - 06.2016
Bachelor of Science - Petroleum Engineering
Universidad Veracruzana
08.2010 - 12.2014