SQL
Fernanda Guzman
Power BI Developer
Guadalajara,Jalisco
Summary
Detail-oriented and analytical professional with a background in Mechatronics Engineering and hands-on experience in data analysis using SQL and data visualization tools like Tableau and Power BI. Strong foundation in business process analysis, requirements gathering, and system configuration. Skilled in extracting insights from complex data sets to drive informed decision-making. Passionate about leveraging data to solve problems and enhance business performance.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
1
1
Certification
2
2
Languages
Work History
Power BI Developer
IBM
02.2025 - Current
- Developed interactive Power BI dashboards to visualize key performance indicators, enhancing data-driven decision-making across departments.
- Conducted data modeling using DAX to streamline data transformation and improve reporting efficiency.
- Leveraged SQL to extract and manipulate data from multiple sources, enabling comprehensive and accurate analytics.
- Implemented automated reporting solutions, reducing manual reporting time by 30% and accelerating insight delivery.
- Collaborated with cross-functional teams to gather and analyze business requirements, ensuring reporting solutions aligned with organizational goals.
- Applied Power Query and custom measures to build scalable, dynamic, and visually compelling reports for both operational and strategic use.
FUNCTIONAL ANALYST
ARROW
06.2023 - 02.2025
- Analyzed system and business data using SQL, PL/SQL, and XML to support reporting and configuration.
- Created ad hoc reports and insights to support cross-functional teams in data-driven decisions.
- Built process flowcharts in Visio to document workflows and support system improvements.
- Conducted UAT to validate enhancements, ensuring alignment with business and data standards.
- Gathered and translated functional requirements into technical specifications for Agile teams.
- Managed test execution, data migration, and conversion for major deployments.
MATERIALS PLANNER
ARROW
07.2022 - 06.2023
- Analyzed historical data to support forecasting and supply chain planning.
- Created Excel and Tableau dashboards to track demand trends, inventory levels, and material flow.
- Performed gap analyses to identify process inefficiencies and recommend improvements.
- Delivered statistical insights to improve forecast accuracy and reduce overstock.
- Collaborated with stakeholders to align data insights with operational decisions.
- Implemented forecasting techniques that enhanced inventory control and reduced excess.
INTERN - MATERIALS
PLEXUS
01.2020 - 01.2021
- Automated reporting tasks using Excel VBA and Macros, reducing manual workload.
- Designed and built dashboards using Power BI and Tableau aligned with corporate standards
- Applied DAX and data modeling to support visual reporting of operational KPIs.
- Collaborated with analysts to define metrics and improve data visualization strategies.
Education
Mechatronics Engineering -
Universidad Del Valle De Mexico
Guadalajara, Jalisco 01.2016 - 01.2020
Certificate - Google Data Analytics
Coursera
SQL for Data Analysis - undefined
LinkedIn
Skills
Attention to detail
Software
R / Python
Power BI (DAX, Data Modeling, Power Query)
Tableau (Calculated Fields, Parameters, Dashboards)
Excel (Advanced functions, PivotTables, VBA/macros)
Software development tools: JIRA, confluence
Database programming
Microsoft Visio
Agile development methodologies
Data Modeling
Certification
Google Data Analytics Certificate
Timeline
Power BI Developer
IBM
02.2025 - Current
FUNCTIONAL ANALYST
ARROW
06.2023 - 02.2025
Google Data Analytics Certificate
11-2022
MATERIALS PLANNER
ARROW
07.2022 - 06.2023
INTERN - MATERIALS
PLEXUS
01.2020 - 01.2021
Mechatronics Engineering -
Universidad Del Valle De Mexico
01.2016 - 01.2020
Certificate - Google Data Analytics
Coursera
SQL for Data Analysis - undefined
LinkedIn
Similar Profiles
Bhavya ReddivariBhavya Reddivari
SAP GRC Consultant at IBMSAP GRC Consultant at IBM
Jhon Arzu GilJhon Arzu Gil
Application Developer at IBMApplication Developer at IBM
Kale BodieKale Bodie
Intern at IBMIntern at IBM
SAGAR BHAVSARSAGAR BHAVSAR
Senior Customer Success Manager – Strategic Accounts at IBMSenior Customer Success Manager – Strategic Accounts at IBM
Aura Patricia Guevara RamírezAura Patricia Guevara Ramírez
Staff Accountant at Trustwell LivingStaff Accountant at Trustwell Living