Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

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
Online
01.2027

Bachelors Degree - Digital Media

CUNY Lehman College
The Bronx, NY
01.2016

Associates Degree - Computer Science

CUNY Bronx Community College
The Bronx, NY
01.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
ERIKA DOMMER