Eric Mcgregor

Eric Mcgregor Email and Phone Number

Data Modeler at Zions Bancorporation @ Zions Bancorporation
Eric Mcgregor's Location
Salt Lake City Metropolitan Area, United States, United States
Eric Mcgregor's Contact Details
About Eric Mcgregor

20+ years experience in information technology specializing in database technology, SQL, ETL tools and business intelligence.

Eric Mcgregor's Current Company Details
Zions Bancorporation

Zions Bancorporation

View
Data Modeler at Zions Bancorporation
Eric Mcgregor Work Experience Details
  • Zions Bancorporation
    Data Modeler
    Zions Bancorporation Sep 2019 - Present
    Salt Lake City, Utah, Us
    I work on the modeling team responsible for creating new entities and attributes in the enterprise data warehouse and other systems using both dimensional and 3NF methodology. I use ER Studio to maintain the ERD and meta-data for databases and APIs. I work with information analysts to interpret business requirements and design modeling solutions that conform with the industry standard Teradata financial services data model (FSDM). Currently working on a common data language model (CDL) that utilizes data governance business terms to create a REST API model library for data sharing across the enterprise in a uniform manner while dealing with architectural ambiguity. Responsible for system administration of ER Studio software, installation, upgrades and user provisioning.
  • Zions Bancorporation
    Data Warehouse Developer
    Zions Bancorporation Aug 2012 - Sep 2019
    Salt Lake City, Utah, Us
    I worked on the ETL team responsible for transforming data from the 3rd normal form layer into the dimensional data mart layer of the enterprise data warehouse. I also wrote extracts and feeds from the EDW to operational systems throughout the bank and its affiliates. I coded Business Objects Data Services jobs to execute push down SQL on Greenplum, created job schedules in Control-M, and provided support.
  • Marketstar
    Data Specialist
    Marketstar Mar 2006 - Sep 2006
    Ogden, Utah, Us
    I wrote SQL queries, views, and stored procedures in support of the market analysis team. I developed applications and reporting systems in Microsoft SQL Server, DTS, SSIS, and C#.
  • Focus Services
    Programmer
    Focus Services Sep 2000 - Mar 2006
    Roy, Ut, Us
    I developed call center data processing and reporting systems in .NET and Visual FoxPro. I also installed and supported call center hardware and software.
  • Utah Army National Guard
    Artillery Section Chief / Squad Leader
    Utah Army National Guard Jun 1995 - Mar 2006
    I served as a field artillery cannon section chief on an M109A6 Paladin 155mm howitzer, supervising an 11 man crew in gunnery training and maintenance. I deployed to Operation Iraqi Freedom from 2004 to 2005 as a rifle squad leader performing urban combat operations including route reconnaissance, IED route clearance, cordon and search, convoy security, and training and mentoring Iraqi border patrol forces.

Eric Mcgregor Skills

Etl Data Warehousing Sql Databases Teradata Data Modeling Data Integration Business Intelligence Business Objects Data Analysis Erwin Microsoft Sql Server Database Design Data Warehouse Architecture Pl/sql Data Marts C# Microstrategy Data Mining Relational Databases Ssrs Unix Shell Scripting .net Sdlc Stored Procedures Oracle Ssis Bteq Sql Tuning T Sql Postgresql Greenplum Data Services Performance Tuning Teradata Data Warehouse Enterprise Architecture Data Architecture Dimensional Modeling Unix Replication Database Administration Shell Scripting

Eric Mcgregor Education Details

  • Weber State University
    Weber State University
    Information Systems & Technologies

Frequently Asked Questions about Eric Mcgregor

What company does Eric Mcgregor work for?

Eric Mcgregor works for Zions Bancorporation

What is Eric Mcgregor's role at the current company?

Eric Mcgregor's current role is Data Modeler at Zions Bancorporation.

What is Eric Mcgregor's email address?

Eric Mcgregor's email address is em****@****ail.com

What is Eric Mcgregor's direct phone number?

Eric Mcgregor's direct phone number is +180199*****

What schools did Eric Mcgregor attend?

Eric Mcgregor attended Weber State University.

What skills is Eric Mcgregor known for?

Eric Mcgregor has skills like Etl, Data Warehousing, Sql, Databases, Teradata, Data Modeling, Data Integration, Business Intelligence, Business Objects, Data Analysis, Erwin, Microsoft Sql Server.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.