ERIKA DOMMER
Middletown,NY
Summary
Dynamic data engineer transitioning to data analyst, proficient in SQL, Power BI, and data analysis. Successfully streamlined processes with an 80% reduction in manual tasks and improved data quality by 70%. Skilled in Azure with a proven track record of enhancing data-driven decision-making.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Associate Data Engineer
Gartner Inc.
Stamford, CT
04.2022 - Current
- Created Power BI Dashboards that streamlined processes and reduced manual workload by 80% and improved data analysis and accuracy from MDM (Master Data Management) jobs.
- Optimized query performance by implementing distribution and index type changes in Synapse tables tables and deployed pipelines in ADF(Azure Data Factory), to reduce over 1 TB of storage caused by expanding table sizes.
- Enhanced data quality by monitoring regression failures and conducting Oracle to T-SQL conversions..
- Supported Lead Software Engineer by addressing syntax issues in PostgresSQL during a migration from an Oracle MDM database.
- Worked with Principal Analytics Engineers to analyze high count REKEY tables and resolve issues with missing entries. Improved the data quality by 70%.
Mac Technical Support Specialist
Gartner Inc.
Stamford, CT
08.2019 - 04.2022
- Provided advanced troubleshooting for Mac and Apple devices, improving user satisfaction
- Provide advanced technical troubleshooting, diagnosis, and information gathering to provide business solutions. Remotely managed Mac and Apple devices via Workspace ONE.
- Led technical support efforts, resolving complex issues and collaborating with Mac Engineering for solutions.
Genius(Mac Technician)
Apple
Greenwich, CT
02.2014 - 08.2019
- Provided technical support to clients by diagnosing product issues. Educated clients on products.
- Performed all software and hardware via Apple internal ticketing system.
- Troubleshot local servers, Ethernet ports network connectivity in collaboration with Apple Engineers.
- Coordinated and prioritized tech bench assignments for Genius technicians scheduled for hardware repairs.
Education
Masters Degree - Data Science & Analytics
SUNY Polytechnic Institute
Online01.2027
Bachelors Degree - Digital Media
CUNY Lehman College
The Bronx, NY01.2016
Associates Degree - Computer Science
CUNY Bronx Community College
The Bronx, NY01.2014
Skills
- SQL
- Power BI
- Azure
- Data Cleaning and Preparation
- Data Exploration and Analysis
- Statistical Programming (R)
- Python
- Excel
- Data Management
- ETL Processes
- Database Management
- Version Control (Bitbucket)
Certification
- Microsoft Azure Fundamentals Certified, 03/01/23
- Microsoft Azure Data Fundamentals Certified, 11/01/24
- Microsoft Power BI Data Analyst (Pending 2025)
Accomplishments
- [May] [2025] - Present: Analyze Account Executive Cap Retention: Utilized Excel (pivot tables) & Power BI to track & visualize retention, identifying trends & improving departmental performance.
- [April] [2025]: Federal Contract Analysis & Data Storytelling: Analyzed federal contract value & developed Power BI visuals to illustrate expiry trends, providing clear insights & context for analysts.
- [May] [2024]: Hackathon Project: Awarded for building a recognition program app, demonstrating problem-solving & development skills.
- [October][2023]: Data Quality Recognition: Received Data Luminary Reward for Data Quality, highlighting attention to detail & data integrity focus.
Timeline
Associate Data Engineer
Gartner Inc.
04.2022 - Current
Mac Technical Support Specialist
Gartner Inc.
08.2019 - 04.2022
Genius(Mac Technician)
Apple
02.2014 - 08.2019
Masters Degree - Data Science & Analytics
SUNY Polytechnic Institute
Bachelors Degree - Digital Media
CUNY Lehman College
Associates Degree - Computer Science
CUNY Bronx Community College