Daniel Sarmiento
Master Data Analyst
San José
"Success is the sum of small efforts, repeated day in and day out."
– Robert Collier
Summary
Data Analyst with 3+ years of experience in BI, data modeling, and automation. Skilled in Power BI, SQL, Excel, and VBA to build dashboards, optimize ETL, and manage large datasets. Strong background in master data management, KPI reporting, cross-team collaboration, and team leadership. Proven ability to transform data into actionable insights and drive business decisions in Agile environments.
Overview
3
3
years of professional experience
4
4
Certificates
2
2
Languages
Work History
Team Lead - Master Data Analyst
Alpemusa S.A. (Pequeño Mundo)
08.2024 - Current
- Lead the Master Data team, assigning tasks, monitoring workload distribution, and overseeing performance metrics.
- Developed and maintained dashboards in Power BI and Excel to track master data KPIs such as code creations, data modifications, and request types.
- Validated data integrity and ensured documentation of all master data processes.
- Collaborated with the IT department to design SQL queries and automate daily operations, improving data flow and reducing manual input.
- Spearheaded continuous improvement projects focused on enhancing data quality and operational efficiency.
- Provided justification reports for brand creation, vacation planning, and department-level decision-making.
Master Data Analyst
Alpemusa S.A. (Pequeño Mundo)
06.2023 - 08.2024
- Managed the creation, modification, and deactivation of SKUs in the master data system, ensuring data quality and consistency across departments.
- Handled end-to-end ticket lifecycle, documenting delays and blockers to improve visibility and resolution.
- Automated repetitive tasks using Excel macros (VBA), increasing operational efficiency and reducing manual errors.
- Developed team performance reports based on KPIs such as number of SKUs processed and average handling time.
- Coordinated with IT, Operations, and Sales to ensure data alignment with inventory and sales workflows.
- Standardized internal processes by developing manuals and documentation to facilitate training and consistency.
BI & Big Data Analyst
Liberty
07.2022 - 04.2023
- Transformed unstructured data into structured formats using tools such as Power BI and SQL Server to meet reporting needs across departments (Marketing, Sales, Customer Service, Billing, Collections, IT, Fraud, etc.).
- Maintained OLAP cubes and developed interactive dashboards and web-based reports.
- Designed, automated, and monitored ETL pipelines, significantly improving data availability and processing efficiency.
- Ensured data integrity through robust validation and cleaning processes across multiple databases.
- Created comprehensive documentation to support team onboarding and knowledge sharing.
- Collaborated with cross-functional teams to translate business requirements into scalable technical solutions.
Education
Bachelor’s Degree - Computer Systems Engineering
05.2001 -
- Intern – Software Development & Systems Analysis, Comuna S.A. - 2021.
- Certifications
Cisco CCNA 1: Introduction to Networks – 2021
Cisco CCNA 2: Switching, Routing, and Wireless Essentials – 2021
Course - Power BI
05.2001 -
Skills
Power BI Dashboard Development
Advanced SQL Queries
Data Modeling & DAX
Excel (Power Query & Pivot Tables)
VBA & Macros Automation
ETL Process Design
KPI & Business Reporting
Data Cleaning & Validation
MongoDB & SQL Server
Storytelling with Data
Cross-functional Collaboration
Agile / SCRUM Methodology
Certification
Introduction to Data Science - CISCO
Languages
Spanish
Native or Bilingual
English
Professional Working
Software
Power BI
Excel (advanced)
SQL
VBA
SSIS
Power Query
DAX
Python
MongoDB
Timeline
Team Lead - Master Data Analyst - Alpemusa S.A. (Pequeño Mundo)
08.2024 - Current
Introduction to Data Science - CISCO
11-2023
Master Data Analyst - Alpemusa S.A. (Pequeño Mundo)
06.2023 - 08.2024
R for Big Data Essential - LinkedIn Learning
06-2023
Python for data science and big data essentials - LinkedIn Learning
05-2023
SQL Server: Essential Integration Services - LinkedIn Learning
05-2023
BI & Big Data Analyst - Liberty
07.2022 - 04.2023
Fidelitas University - Bachelor’s Degree, Computer Systems Engineering
05.2001 -
Costa Rican Institute of Technology - Course, Power BI
05.2001 -