Oscar Gargallo
Lawrenceville
Summary
Data Analyst with over 5 years of experience delivering analytics-ready datasets, dashboards, and reports across CRM and ERP platforms. Advanced Excel and Power Query user with hands-on experience in data transformation, KPI development, and workflow automation. Proven ability to improve data integrity, accelerate reporting timelines, and partner with cross-functional stakeholders to drive business insights. Bilingual in English and Spanish.
Overview
24
24
years of professional experience
Work History
In-Home Family Caregiver
06.2024 - Current
- Coordinated schedules, financial tracking, and stakeholder communication in a high-responsibility environment.
Data Entry Clerk
Zimmer Biomet
08.2025 - 02.2026
- Standardized Salesforce datasets to ISO 3166-1, improving data integrity for downstream reporting.
- Developed KPI dashboards and analytical reports; partnered with Operations and IT to resolve data quality issues impacting performance metrics.
Data Entry Clerk
Primerica
03.2023 - 04.2024
- Led enterprise-scale CRM data remediation to support automation and analytics initiatives.
- Designed Excel-based analytical dashboards using XLOOKUP and dynamic arrays to monitor throughput, accuracy, and delivery status.
Data Entry Administrator
Waystar
06.2022 - 01.2023
- Executed Salesforce data migration and validation, delivering analytics-ready datasets ahead of schedule.
- Built automated data transformation workflows in Power Query, reducing manual effort and improving reporting reliability.
Associate Data Reporting Analyst
HealthStream
02.2022 - 03.2022
- Integrated multiple datasets into standardized analytical reports using Power Query and pivot tables.
- Optimized reporting pipelines, accelerating delivery timelines and improving decision-making accuracy.
LTL Pre-Invoice Clerk
Mansfield Energy
10.2021 - 01.2022
- Analyzed and transformed vendor invoice datasets to support accurate billing and financial reporting.
- Investigated anomalies and collaborated with stakeholders to resolve data discrepancies.
FTL Pre-Invoice Clerk
Mansfield Energy
01.2021 - 10.2021
- Maintained high-volume transactional datasets in ERP systems to support revenue and operational reporting.
LTL Dispatch Coordinator
Mansfield Energy
09.2020 - 01.2021
- Automated operational reporting workflows using Power Query and Excel; contributed to Power BI datasets.
- Analyzed logistics and delivery data to support nationwide fulfillment and vendor performance tracking.
Distribution Clerk
The Coca-Cola Company
03.2002 - 10.2016
- Spearheaded development of Access databases and SQL-based reports to support SLA and operational performance analysis.
- Improved reporting accuracy and efficiency through data automation and system enhancements.
Education
Some College (No Degree) - Music Education
University of Georgia
Athens, GASkills
- Excel
- Power Query
- Power Pivot
- Power BI
- SAP
- Microsoft Access
- Microsoft Dynamics 365
- Airtable
- KPI development
- Dashboarding
- Data quality improvement
- SQL
- Workbench
- Teams
- SharePoint
- Outlook
- Cross-functional collaboration
- Bilingual (English/Spanish)
- Data entry
- CRM management
- Data integrity
- Attention to detail
- Problem solving
- Salesforce proficiency
Core Skills
Excel, Power Query, Power Pivot, Power BI, Power Query, Excel, Power Pivot, Salesforce, SAP, Microsoft Access, Microsoft Dynamics 365, Airtable, KPI development, dashboarding, data quality improvement, SQL, Workbench, Teams, SharePoint, Outlook, Cross-functional collaboration, bilingual (English/Spanish)
Timeline
Data Entry Clerk
Zimmer Biomet
08.2025 - 02.2026
In-Home Family Caregiver
06.2024 - Current
Data Entry Clerk
Primerica
03.2023 - 04.2024
Data Entry Administrator
Waystar
06.2022 - 01.2023
Associate Data Reporting Analyst
HealthStream
02.2022 - 03.2022
LTL Pre-Invoice Clerk
Mansfield Energy
10.2021 - 01.2022
FTL Pre-Invoice Clerk
Mansfield Energy
01.2021 - 10.2021
LTL Dispatch Coordinator
Mansfield Energy
09.2020 - 01.2021
Distribution Clerk
The Coca-Cola Company
03.2002 - 10.2016
Some College (No Degree) - Music Education
University of Georgia