Uploaded File
add photo
Edward
edpflager@gmail.com
419-450-8585
1700 San Pablo Rd S Apt 801
Jacksonville, FL 32224
Manager, Data Services
16 years experience W2
0
Recommendations
Average rating
15
Profile views
Summary

Qualifications

  • Experienced IT professional with background in multiple database platforms (Microsoft SQL Server, MySQL, and PostgreSQL), ETL applications (Microsoft SSIS - Integration Services, IBM DataStage, and Pentaho Data Integrator) ,analytics tools including Microsoft Power BI, SQL Server Analytics Services and R and Operating Systems (Windows, Mac OSX and Ubuntu, Mint, and CentOS Linux).
  • Innovative professional with proven ability to identify, analyze and solve problems with a focus on increasing user satisfaction and controlling costs while working closely with line of business personnel to achieve long and short-term strategic goals.
  • Dedicated, hardworking individual with the interpersonal and communication skills to work at all levels of the organization. Extensive experience in managing staff, in sales and IT environments, from 3 to 25 staff members.
  • Successful in meeting new technical challenges and developing solutions to meet the needs of the customer or organization using commercial and open source products.

Experience
Manager, Data Services
Information Technology
Oct 2014 - Jan 2019
  • I lead a team of ETL developers using IBM DataStage and SQL Server Integration Services to manage data on SQL Servers, DB2 iSeries, and Oracle for analytics and other reporting needs, and develop dashboards and reporting in Power BI and SQL Server Reporting Services.
  • Moved analytical reporting from Tableau to Power BI and SQL Server Analytics Services and the saved company over $50K annually in licensing costs.
  • Monitor and manage performance on Business Intelligence systems including Power BI, Cognos BI 10 and SQL Server Reporting Services and SQL Server Analysis Services 2008 - 2019.
  • Monitor and administer over twenty production Microsoft SQL Servers running various components of the Microsoft DB suite, including the on-premise Power BI report server.
  • Communicate extensively with business personnel throughout project delivery to make sure requirements are met and to offer appropriate suggestions for design and implementation.
  • Successes include conversion of large-scale SQL Server DTS system to SSIS and acting as
  • primary technical lead on Master Data Management implementation during Dynamics CE rollout.
Business Intelligence Cognos DB2 ETL ETL Developer MS Power BI Oracle SQL SQL Server Tableau Data Management SSIS
Remove Skill
Business Intelligence Systems Lead
Information Technology
Oct 2007 - Oct 2014

Business Intelligence Systems Lead

  • Maintained and developed ETL processes to support the company's Business Intelligence initiative from an Enterprise One ERP platform and from the company-developed retail management system.
  • Monitored and managed performance on various systems including Business Objects 3.1 and 4.0, SAP Data Services, Pentaho Data Integrator and SQL Server Integration Services systems.
  • Supervised staff across various functional domains including Business Intelligence, Business Objects development, and SQL Server and DB2 DBAs.
  • Acted as IT project lead on several large-scale upgrades. The highest profile one included migrating from Kronos Workforce Manager 5.1 to 6.0 which involved a dozen new servers and impacted 5000 employees.
  • Consolidated SQL Server systems from dedicated boxes to shared platforms, going from 50 servers down to 25.
Business Intelligence ERP ETL SAP SQL SQL Server
Remove Skill
Contract Network/Database Administrator
Information Technology
Nov 2006 - Oct 2007
  • Relocated the company's computer operations from Warren, MI to Monroe.
  • Maintained both database and network servers running SQL Server and Exchange.
  • Supported over 100 users, locally and remotely.
DBA SQL SQL Server
Remove Skill
Information Systems Director
Information Technology
May 2005 - Nov 2006
  • Supervised the internal Help Desk staff, supporting over 100 users.
  • Administered and maintained Windows 2000/2003, Exchange 2003, Netware and SQL Servers as well as monitored network performance and security.
  • Worked on multiple data analysis projects and report creation with Crystal Reports.
  • Received the President's Award for Innovation for the following initiatives:
  • Migrated the company from Novell and GroupWise email to Microsoft Windows file/print sharing and Exchange/Outlook email.
  • Rolled out a new Sales CRM system (SugarCRM) based on MySQL and Apache.
  • Implemented a Help Desk tracking website on Microsoft SharePoint and SQL Server.
CRM MS SharePoint Project Management SQL Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Business Intelligence
Eastern Michigan University
Management
University of Toledo
Certifications
I hold Microsoft certifications on Window Server 2000/2003 and SQL Server 2005
Skills
SQL
2019
13
SQL Server
2019
12
Business Intelligence
2019
11
ETL
2019
11
ERP
2014
7
SAP
2014
7
Cognos
2019
4
Data Management
2019
4
DB2
2019
4
ETL Developer
2019
4
MS Power BI
2019
4
Oracle
2019
4
SSIS
2019
4
Tableau
2019
4
CRM
2006
1
MS SharePoint
2006
1
Project Management
2006
1
Windows
2006
1
DBA
2007
1
Linux
0
1
MySQL
0
1
PostgreSQL
0
1