Data-Driven Analyst with KPI & Automation Expertise

Oscar Gargallo

Lawrenceville, GA 404-***-**** *********@*******.***

Professional Summary

Data Analyst with 5+ years of experience delivering analytics-ready datasets, dashboards, and KPI-driven reports across CRM and ERP platforms. Advanced Excel and Power Query user specializing in data transformation, automation, and data quality improvement. Proven ability to accelerate reporting timelines and partner with cross-functional teams to drive actionable insights. Bilingual in English and Spanish.

Core Skills

Data Analysis & Visualization: Excel, Power Query, Power Pivot, Power BI

Data Transformation & Modeling: Power Query, Excel, Power Pivot

Databases & Systems: Salesforce, SAP, Microsoft Access, Microsoft Dynamics 365

Analytics Enablement: KPI development, dashboards, data quality

Tools: SQL, Workbench, Teams, SharePoint, Outlook

Professional Experience

Data Entry/Data Analyst (Contract) — Multiple Clients Aug 2020 – Feb 2026

Delivered analytics-ready datasets, dashboards, and standardized reports across Salesforce, SAP, and proprietary CRM systems.

Led data migrations, validation, and remediation efforts supporting automation and BI initiatives.

Built automated data transformation workflows using Power Query, reducing manual processing and improving reporting reliability.

Developed KPI dashboards and Excel-based analytical models to track operational, financial, and data-quality metrics.

Partnered with Operations, IT, Finance, and external vendors to investigate anomalies and resolve data discrepancies.

Distribution Clerk / Database Specialist · The Coca-Cola Company (Contract) — Mar 2002 – Oct 2016

Developed Microsoft Access databases and SQL-based reports to support SLA and operational performance analysis.

Improved reporting accuracy and efficiency through data automation, system enhancements, and Excel-based reporting.

Supported onboarding, reporting requests, and cross-team operational initiatives.

Contact this candidate