Emilio Pinedo

Designed SQL queries to analyze sales and inventory, automating replenishment alerts that reduced supply chain reaction time by 30% and optimized purchasing decisions. Automated data ingestion into SQL Server using Python and Azure Data Factory, increasing demand visibility by 25% for BI strategies. Implemented data integrity initiatives in Azure Synapse Analytics, achieving 100% accuracy in Master Data (SKUs, Vendors) to support reliable demand forecasting.

Data Analyst - Vida Software SAC - Lima, Peru

(2024-11 - 2026-05)

• Designed SQL queries to analyze sales and inventory, automating replenishment alerts that reduced supply chain reaction time by 30% and optimized purchasing decisions.
• Automated data ingestion into SQL Server using Python and Azure Data Factory, increasing demand visibility by 25% for BI strategies.
• Implemented data integrity initiatives in Azure Synapse Analytics, achieving 100% accuracy in Master Data (SKUs, Vendors) to support reliable demand forecasting.
• Designed interactive Sales vs. Stock dashboards applying data storytelling to track KPIs (Sell-Through Rate, DSI) and optimize reporting with stakeholders.

IT Audit Intern/IT Audit Trainee - Luz del Sur SAA - Lima, Peru

(2022-10 - 2024-11)

• Analyzed over 10,000 financial records using Excel and audit software to identify irregularities in petty cash and vendor billing, driving tangible business outcomes through process improvements that mitigated financial risk.
• Developed automation scripts for audit testing procedures, reducing manual data validation efforts by 20% and improving overall financial workflows.
• Designed and implemented over 20 interactive Power BI dashboards, improving reporting efficiency and empowering stakeholders to identify financial anomalies 15% faster, enabling agile corrective decision-making.

Professional title - systems engineering - Universidad Peruana de Ciencias Aplicadas (2025-07)

Bachelor's degree - systems engineering - Universidad Peruana de Ciencias Aplicadas (2023-12)