Douglas A. Hempel

**** ***** ****** ***** **

Cass Lake, MN 56633

651-***-**** – adyhro@r.postjobfree.com

Objective Information technology professional capable of managing technology projects from concept to completion with sensitivity toward deadlines. Eighteen years as an accomplished ETL Developer of writing and creating SQL SSIS Packages/Scripts for migration of database objects from development through production environment. Strong analytical skills combined with experience, compatible team player, understanding project life cycle from testing to final implementation. Excellent communionication skills. Fluent in English.

Technical Experience

Databases Teradata, SQL Server 2019, SQL Server 2016, SQL Server 2012, SQL Server 2008, ORACLE10g, ORACLE11g

Technology Epic, Minnesota Community Measures (MNCM), Infinite Campus, Viewpoint, Naviance,

PDExpress, PCS (Foodservice), Renaissance Learning Destiny, Visual Basic 6.0, Versa Tran,

Transact T-SQL, SQL/Plus, Cold Fusion, Reporting Services SQL, MDX, MDM

Software Transact-SQL, MS SQL 2016, Management Studio, Visual Studio; Integration Services (SSIS);

MS Master Data Services, Outlook/Skype, Teams

MS SQL 2014, Management Studio, Visual Studio, Integration Services (SSIS),

MS SQL 2012, Management Studio, Visual Studio, Integration Services (SSIS),

Reporting Services (SSRS),

Platforms SAP BUSINESS OBJECTS, Dell Server 1950, 610, Windows 2008, Red Hat Linux, Sun Solaris, RS6000, IBM 390DEC VAX, UNIX, IBM MVS 390, Windows XP Professional

Business Health Care, Education, Testing, Management, Finance, Sales and Commissions,

Experience Business Analyst, System Migrations, System Conversions, and Promotions

Professional Experience

DIVERSANT Minneapolis, MN. 2022 – Present

Lead Data Management Analyst at Wells Fargo (Commercial Banking Financial Crimes Unit.)

The Lead Data Analyst works within the Insights, Data Engineering & Analytics organization to meet the data pipeline strategies and objectives across the bank (Wells Fargo).

Skills and experience in data/analytics competencies in domains including subject matter expertise, analytic methods and tools, business intelligence, data management, data architecture, analysis and critical thinking skills, data governance, analytics education/learning, and metadata.

Participate in data analysis via data discovery, exploration, investigation, and impact assessments.

Development including requirement analysis, design, testing, and implementation of applications, mappings, scripting, data mart and data labs for reusable objects.

The Emily Program St. Paul, MN. 2021 – 2022

EHR Senior Analyst 3

Involve in data warehouse development including requirement analysis, design, development, testing, and implementation of applications; design and develop complex ETL packages, mappings, transformations, scripts, data mart and reusable objects.

Maintain and Support SSIS ETL packages; Complex SSRS reports and processes for the existing systems, as well as creating new packages and reports as needed for the data warehouse.

Participate and lead validation testing of new designs/build and provide implementation support.

Douglas A. Hempel adyhro@r.postjobfree.com - 651-***-**** Page 2 of 2

Sr. Data Integration and Warehouse Dev, Fairview St. Paul, MN. 2017 – 2021

Info Mgmt. Engineer, Health East St. Paul, MN. 2015 – 2017

Create SSIS packages to ETL data from an external source to our Caboodle data warehouse,

In addition, BOE Cube to Populate Lawson payroll for salaried and hourly employees.

Create SSIS packages to ETL Claims and Consents data from Healtheast SQL Server to Fairview

Oracle Ext_Payer.Tables.

2+ years of experience working in an Agile (SCRUM) environment.

Write code to perform business logic/rules from source to target for Minnesota Community Measures (MNCM) output was to be submitted to the state of MN. for audited purposes.

Create/Design SSIS packages to ETL for Claims Project. 3 Packages per Payers (Media, IHP,HP,BCBS,Preferred,UCare) from Staging, Reporting and Importing them into the EDW

Provide Expert working knowledge, coaching and technical mentorship of SQL Server tools, to my co-worker when requested.

MIS Analyst/Application Supp, St Paul Schools St. Paul MN. 1999 - 2015

Create SSIS packages to ETL data from the source database to Oracle data warehouse.

Create Dashboards using OBIEE (Oracle Business Intelligence Enterprise Edition) to design/develop analysis by navigation of the User Interface (UI)

Create tables/views and display analysis for reports (SSRS) as well as editing the prompts/columns/views and table properties.

Create tables; triggers; stored procedures; views; Reports; DTS and DTSX packages to production; migration scripts automatically overnight to various locations to use by other applications.

Responsible for compiling, troubleshoot, and debug everyday production issues, check error logs.

Create reports, maintain, and support assessment data/application using SQL Server, MS Reporting Services (SSRS); Access; Excel; Crystal Reports; and BI Dashboards

Grant Security access to teachers; counselors; principals; and other administrators for numerous applications that track students.

Design/Develop web pages for attendance for summer school for secondary/elementary students.

Documentation of system enhancements. Used Visio to diagram new Applications with new features.

Education and Certification

IBM DataStage Certification Training (Intellipaat online) Delhi, India.

Certified ITIL @ V3 Foundation St. Paul, MN.

SAP Business Objects Information Design Tool St. Paul, MN.

Updating My Skills to SQL Server St. Paul, MN.

Caboodle Administration Verona, WI.

Implementing a Data Warehouse with MS SQL Server Eden Prairie, MN

MS Master Data Services (MDS) Boot camp Minneapolis, MN.

2030 Exclusive-Creating Reporting Services with Microsoft SQL Server Edina, MN.

Enterprise Extraction, Transformation, and Loading (ETL) with SQL Server

Advanced Oracle PL/SQL Edina, MN.

Integration Services (SSIS) and Reporting Services (SSRS) Edina, MN.

University of Minnesota, NTier Client and Server Technology Certificate Minneapolis. MN.

St. Thomas University, Computers and Technology for Human Resource Dev. St. Paul, MN.

Metropolitan State University, BA, Management Information Systems St. Paul, MN.

Moorhead State University, Associate of Arts Moorhead, MN.

Contact this candidate