Erin Dempster Email and Phone Number
Erin Dempster's Location
Minneapolis, Minnesota, United States, United States
Erin Dempster's Contact Details
Erin Dempster work email
- Valid
- Valid
- Valid
Erin Dempster personal email
n/a
About Erin Dempster
Experienced SQL Server DBA in organizations with smaller data footprints. Certified Azure DevOps engineer automating SQL Server/Azure SQL DB deployments.Microsoft MVP presenting topics around Azure DevOps and SQL Server at data community events, including SQL Saturdays and PASS Summit.
Erin Dempster's Current Company Details
Erin Dempster Work Experience Details
-
Enterprise ArchitectTrean Corporation Jul 2024 - PresentWayzata, Minnesota, Us
-
Data Operations Team LeadTrean Corporation Nov 2020 - Jul 2024Wayzata, Minnesota, Us- Maintain SQL Server environments, both on-premises and in Azure- Database DevOps administrator, using Azure Pipelines for automated deployments- Build out and supervise the Data Operations Team- Investigate and recommend Azure technologies to expand and improve the data warehouse environment- Assist in the development of complex ETL processes- Provide mentoring to other members of the Data Team- Designed the current data warehouse- Work closely with the Infrastructure/Security Team, gauging the impact of new technologies on existing applications and processes
-
Sql Developer IiTrean Corporation May 2019 - Oct 2020Wayzata, Minnesota, Us- Provide technical guidance and leadership to the data warehouse development team.- Continually improving and optimizing the data warehouse environment, through architecture and development.- Migrate data warehouse environment to Azure, taking advantage of native services over VM lift and shift. . Azure SQL Managed Instance . Azure Data Factory with SSIS Integration Runtime . Azure Storage Account - Manage incoming and outgoing data feeds . Azure Automation - PowerShell scripting environment- Coordinate data warehouse-related projects with other IT teams and external resources.- Manage SQL Server 2012 - 2017 environments.
-
OwnerTrue North Data Sevices, Llc Sep 2023 - PresentBringing clarity to complex database devops solutions.* Speaker at SQL Server community events including * SQL Saturdays in the United States * PASS Data Community Summit * SQL Bits 2023
-
Senior Data & Analytics ConsultantSuperior Consulting Services Dec 2018 - May 2019Burnsville, Mn, Us -
Business Intelligence ConsultantSuperior Consulting Services Nov 2017 - Dec 2018Burnsville, Mn, Us- Led team of six developers in the design and implementation of an enterprise data warehouse for an insurance management company. - Provide leadership and mentoring to the in-office business intelligence consultant team.
-
Database AdministratorDocutap Nov 2015 - Oct 2017Sioux Falls, Sd, Us− Oversight of SQL server environments hosted locally and in Amazon Web Services (AWS) for the following:▫ Business intelligence environment, including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)▫ ePrescription transactional processing;▫ Internal, IT-related systems, such as SolarWinds and McAfee; and − Handling of the internal business intelligence (SSIS and SSRS) as well as the OpenEdge and SQL Server performance data− Assistance in overseeing the progress OpenEdge platform and PostgreSQL proof-of-concept environment for new web initiatives− Leadership and guidance to the Development Team in optimizing the daily loading of their enterprise data warehouse, which minimized the total processing time from 8 to 10 hours to 4 to 5 hours, thus resulting in the following:▫ Continuous selling of the analytics product to customers without affecting the processing times negatively;▫ Significant increase of the analytics customer base over the past year by more than 10%; and▫ Saving of $50 to $75K for the company by preventing them from purchasing additional hardware and licensing to maintain processing windows -
Business Intelligence Database AdministratorDaktronics Oct 2012 - Nov 2015Brookings, Sd, Us− Administration of business intelligence (BI) along with SQL server analysis services 2012 and integration services 2012− Keenly monitored the systems to ensure uptime and on-time data movement to operational data store (ODS)− Expert troubleshooting of system issues and execution problems with SSIS packages as well as SSAS cubes and tabular models− Proficiency in using Profisee Master Data Maestro 3.5.x to manage and monitor master data− Oversight to the BizTalk 2013 system administration to integrate service orders with the ERP system− Development of BI environments, from two servers, such as production and test and 4TB total storage, to four environments with more than 8TB used storage (14TB total)− Accomplishment of more than 25,000 SSIS executions daily in producing change data capture (CDC) between Oracle and SQL Server− Mentor for new developers by helping them understand the T-SQL syntax while providing business knowledge to improve their solutionsAssistance in managing the upgrade of BizTalk to 2013 R2 along with providing systems for the upgrade -
Developer | Junior Database Administrator | Team LeadDaktronics Jan 2012 - Oct 2012Brookings, Sd, Us− Development of BI while acting as a liaison between projects and BI management
-
Software DeveloperDaktronics Dec 2010 - Jan 2012Brookings, Sd, Us− Customization of the company’s service application, Amdocs 6.0 with the system’s three different client applications coded in ClearBASIC, Java/JSP or Active Server Pages (ASP) in adherence to the client’s application − Instrumental part in generating and administering the real-time integrations between Amdocs and the company's ERP system—Glovia, through the use of SQL triggers and Microsoft BizTalk Server 2009
-
Database/Software DeveloperDaktronics Jun 2008 - Dec 2010Brookings, Sd, Us− Contribution in generating transactional database for internal applications through design and implementation of database schema changes as well as creation and modification of database logic − Effectual assistance to application developers in writing business logic using C#.Net to call stored procedures for specific projects− Partnership with the Business Intelligence Team in implementing extraction, transformation, and load (ETL) packages with SSIS to an operational data store
-
Database Developer / Database AdministratorHintz Consulting Inc Jun 2006 - Jun 2008− Management of database by conceptualizing and implementing database schema and writing stored procedures toward efficient data access layer− Administration of C# business logic and web services which included ASMX web services− Contractor with Daktronics Inc. for an additional 6 to 8 months longer than other contractors, to assist in creating a content management system—Visiconn, as well as provide a regular source of revenue, which strengthened the Hintz Consulting operations -
Network AssistantThe First National Bank In Sioux Falls Jun 2004 - Jun 2006Sioux Falls, Sd, Us-- Migrated SMART reports to Cognos ReportNet, ahead of the bank's mainframe upgrade to IBM xSeries.-- Managed Windows 2000 and 2003 servers (file shares, email, web applications, etc.).-- Provided desktop support to the bank's staff. -
Web DeveloperSioux Falls School District Oct 2003 - Jun 2004Sioux Falls, Sd, Us
Erin Dempster Skills
T Sql
Microsoft Sql Server
Database Design
Sql
Visual Studio
Agile Methodologies
C#
.net
Javascript
Java
Ssrs
Windows
Windows Server
Iis
Databases
Business Intelligence
Html
Web Development
Ssis
Database Administration
Postgresql
Strategic Planning And Analysis
Programming And Coding
Information System Enhancement
Project And Program Management
Continuous Process Improvement
Application Support
Systems Integration
Microsoft Master Data Services
Erin Dempster Education Details
-
Dakota State University Graduate SchoolInformation Assurance And Computer Security -
Dakota State UniversityComputer Science
-
South Dakota State UniversityComputer Science
Frequently Asked Questions about Erin Dempster
What company does Erin Dempster work for?
Erin Dempster works for Trean Corporation
What is Erin Dempster's role at the current company?
Erin Dempster's current role is Microsoft MVP (Data Platform) - Enterprise Architect at Trean Corporation.
What is Erin Dempster's email address?
Erin Dempster's email address is ed****@****tap.com
What schools did Erin Dempster attend?
Erin Dempster attended Dakota State University Graduate School, Dakota State University, South Dakota State University.
What skills is Erin Dempster known for?
Erin Dempster has skills like T Sql, Microsoft Sql Server, Database Design, Sql, Visual Studio, Agile Methodologies, C#, .net, Javascript, Java, Ssrs, Windows.
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
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
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.
Start your free trial