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

Minneapolis, MN *****

612-***-****

advv12@r.postjobfree.com

Richard Langree

Objective Data Architect

Experience 2021 to Present Consulting through Emergent Technology Long Term Care Group Eden Prairie, MN

Build Data Vault 2.0 Data warehouse in Snowflake for analytics and reporting. Using Confluent, Kafka for real-time cloud streaming. Migrate and enhance SSIS data transforms and streams. Build Python scripting for custom enhancements to transformations in Snowflake. Optimize existing Sql scripts and structures for views and model modifications.

2019 to 2021 Consulting through Superior Consulting WindSource Rockford, IL

Build integrated data collection and integration process for wind energy and solar energy analytics and assessments. Use IoT connection to Sql Server database using Sql Server Integration Services SSIS to automate data collection at the sources.

Build data model and analytics cubes using Sql Server Analysis Services SSAS in Azure to consolidate data sources for assessments. Use PowerBI and DAX to create dashboards reflecting performance analytics for energy production and efficiencies. Demonstrate predictive results for energy delivery in solar collectors and wind energy sources. United Bankers Bank Bloomington, MN

Assess enterprise need for data consolidation for data analysis. Design unified data model for enterprise consumption of operational performance analysis using Sql Server Analysis services SSAS. Build cubes to report performance and analytics.

Richard Langree

Build data transformation process to consolidate data from internal and external sources including data bases and pdf files. Use Sql Server Integration Services SSIS to automate transformations.

Design performance analytics dashboards using PowerBI to customize operational analysis for each department.

Use DAX to create custom functions to predict performance for future operational activities.

2008 to 2018 Consulting through Corporate Contract Services Tenere Parts Manufacturing Osceola, WI

Create an analytics cube for custom metal and plastic manufacturing operations in Azure from Excel data, txt and xml files. Imports to CosmosDb. Parse JSON into SSIS to load data mart and SSAS cube in Azure Sql Server. Build dashboards in Power BI to create calculations for KPIs and product evaluation visualizations to maximize efficiencies and promote most profitable product lines. Create custom R scripts to calculate custom prediction models for product delivery date distribution estimates.

Load pdf from legacy custom design contracts for searching and analysis of previous custom contracts using CosmosDb and Sql Server. Minneapolis Medical Research Foundation Minneapolis, MN Redesign federal national registry of human organ transplant history using Sql Server 2012 and 2016. Build cubes in SSAS and translation technology with MS Powershell and SSIS. Use dynamic TSql stored procedures to make flexible data structure changes to data loads. Use PowerBI and Datazen to create dashboards for self selected ad hoc reporting through dotNet web apps.

Build data collection web app which allows for data driven custom workflows, data collection form specifications and validation methods without additional coding to maintain.

Create Hadoop aware MapReduce data extraction methods using Powerbase and Sql Server 2016 to gather medical records data from hospital EMR systems.

Iverify aka Checkview Chanhassan, MN

Design ERP solution in Dynamics GP for home and business physical facilities security monitoring enterprise for nationwide activity tracking. Richard Langree

Build translation process to extract SAP data and load into custom ERP solution in Microsoft Dynamics GP. Use Sql Server and SSIS for workflow control. Use Hadoop installation with Map Reduce expressions to gather unstructured text data for consolidation into ERP target. Create Tableau dashboards for KPIs and performance metrics visualizations.

Build dotNet web app reporting dashboard and ad hoc self selected delivery data extraction solution using Dynamics GP and SSRS. Ecolab Saint Paul MN

Develop a business intelligence solution for tracking business activity for employee services to business customers. Design a tablular model cube in Sql Server Analysis Services, build import processes in SSIS, create visualization dashboards with existing tracking data with Power BI and SSRS reporting for tablets and pcs for use in the field by service employees. Make statistical packages using SSAS aggregations for performance metrics and KPIs.

Global Cash Access Burnsville, MN

Develop a table driven cash transfer system using Sql Server 2012 and 2014 for cloud based processing. Maintain clustered Sql Servers. Use SSRS for reporting. Maintain on legacy application management and transformations in Oracle 11g. Build dotNet web app access to database. MCG Energy Minneapolis, MN

Build a custom Service Broker driven system to synchronize disparate database systems in realtime using Sql Server for use as data mart. Build custom reports in SSRS to determine success of synchronization. Edit and improve performance on stored procedures. Troubleshoot performance problems in production database system for energy trading system.

Lutheran Board of Pensions Minneapolis, MN

Design data models and data integration strategies for internal financial management applications using schemas for business unit isolation and security. Propose data models for redesign of data warehouse, data marts and operational data stores. Build SSIS packages for ETL conversion and deployment of refactored OLTP line of business applications. Write stored procedures in Sql to perform customized data access tasks. Manage data design projects. Interact with customer areas to define and rework Richard Langree

project requirements. Advise and lead technical solutions for web based DotNet 4.0 data access with stored procedure optimization and tuning. Document project requirements, milestone gantt charts, data design standards, and code improvement techniques.

Royal Bank of Canada Minneapolis, MN

Manage multiphase project to upgrade data migration systems into and out of OLAP warehouse with various ETL processes. Determine dimension needs for financial asset management including daily performance, monthly earnings and performance and Assets Under Management calculations. Write custom code in Perl to refresh and manage LDAP data access for directory maintenance. Create project plans, manage milestones, document requirements and processes. Create custom Reporting Services reports. Update and improve Oracle 10g data store for client accounts. Use SSIS data transformation to exchange data with DB2 and Oracle database systems. House repository in Sql Server 2005/2008. Develop Analysis Services cube technology for business intelligence in Division level reporting environment. Maintain and edit web applications in DotNet 3.5 with C#.

Medtronic Mounds View, MN

Through contract with Magenic Consulting

Complete database redesign of world-wide web based patient management application using Erwin data modeling. Write and refactor stored procedures and data flows in SSIS. Investigate technical improvements to system-wide data flows and structures. Recommend server hardware technologies. Develop improved reporting systems using Reporting Services in version 2005 and 2008. 2007 -- 2008 International Species Info Systems Eagan, MN Develop data model and data access layer in Sql Server 2008 with Analysis Services and Integration Services 2008 for global animal care and research application using schemas and code migration in Team Foundation Server. Create redesign in Erwin for relational database in SQL Server 2008 for improved reliability, stability and maintenance. Setup LDAP system to deliver account directory access for worldwide user base. Design import methods for use of SNOMED standards for drugs, findings and body locations. Use HL7 protocol for medical record data transmissions. Create migration scheme for legacy data using SSIS packages.

Education

University of Michigan Ann Arbor, MI

B.S., Electrical and Computer Engineering. Magna Cum Laude.