Emily Garcia

Managed data for four concurrent high-volume legal cases, using SoQL and Salesforce to extract, transform, validate, and load data into production datasets. Owned end-to-end data and reporting for a key case, designing a Salesforce dashboard that brought a 12-month objective to completion in 6 months.

Managed and cleaned 150+ leads daily using Pipedrive, eliminating duplicate records and improving data quality for sales operations. Built Excel-based performance trackers for 11 sales representatives and developed tools to track client payments, interest calculations, and payout schedules.

Extracted, transformed, and analyzed large datasets using Microsoft SQL Server and Excel, ensuring data quality and delivering actionable insights. Developed VBA-based automation tools that improved workflow efficiency by 75% and reduced time on manual tasks.

Oversaw the management and manipulation of large datasets, ensuring data integrity for comprehensive reporting and analysis. Created advanced SQL Server queries and Excel functions to generate actionable insights, and developed an SOP that reduced operational errors by 15%.

Bachelor of Science in Mathematics from Fairleigh Dickinson University from 2018 to 2022.