Blake E. Email & Phone Number

• https://futuremodel.ioWith Support For:
• Google BigQuery
• Snowflake
• Amazon Athena
• Amazon Redshift
• Microsoft SQL Server

Greater Minneapolis-St. Paul Area

• Built data pipelines for clinical burn data from the American Burn Association into AWS RDS MySQL data sources
• Using Tableau Embedded Analytics, authored a set of standard reports, custom reports, and an ad-hoc reporting environment for each qualifying burn center
• Rebuilt core data warehousing model to more easily serve up Real World Data, eliminating the need for 2 legacy databases
• Developed a role-based security structure within Tableau to isolate each burn centers PHI through Embedded Analytics
• Managed Tableau Sever licensing, and created administration scripts utilizing Python and the Tableau API to more easily manage deployments

Greater Minneapolis-St. Paul Area

• Sole architect and data modeler for 3 critical microservice business application databases; one estimated to be responsible for $42 million in annual company revenue
• Carries out capacity planning for scaling application databases to handle 2x their current inventory. Database sizes range from 5GB - 1TB
• Utilizes RDS, S3, and AWS CLI to build data flows in a hybrid environment
• Responsible for logical and physical data modeling on all new applications, ensuring highly performant databasesthat serve up quick and accurate data
• Maintains daily scheduled reporting on 50+ million medical chart inventory to Optum/UHC

Greater Minneapolis-St. Paul Area

• Architected the companies most widely used data warehouse using a Star Schema Model, and built incremental ETL processes to transform OLTP sources into OLAP system
• Increased data accessibility and performance for Tableau and Microsoft Power BI by architecting a Microsoft SSAS OLAP Cube
• Improved application performance through indexing, query tuning, minimizing blocking, reducing stored procedure runtime up to 99.86%, using SolarWinds DPA and Microsoft Query Store
• Integrated Address Standardization procedures to enhance import grouping and deduplication initiatives
• Monitored the Backup and Restore of production database instances, resolving incidents at they occur
• Directed SQL Agent jobs to defragment indexes, update statistics, update rollup tables, and extract data via Powershell

Minneapolis, Minnesota

• In addition to Applications System Analyst responsibilities, I prioritized team projects and allocated resources using JIRA, lead morning stand-ups, resolved team barriers, and provided strategy for departmental.

Minneapolis, Minnesota

• Supported 500+ myEvolv system users by creating web forms, managing privileges, writing custom SQL reports, and building out workflows
• Created and administered custom views, reports, and data sources for Crystal Reports by SAP SE
• Authored PowerShell scripts for pushing data between systems and scripting manual tasks
• Promoted company intranet as a SharePoint Product Owner; developing workflows, retention policies, product strategy, and the metadata term store
• Minimized manual data entry and pioneered data integrity by integrating system backends using SSIS and DQS

Bloomington, Minnesota

• Provided application support for 1,600+ clients in a specialized role
• Implemented and migrated to new CRM, building out permissions, web forms, and workflows
• Was responsible for configuring 30+ different software integrations
• Worked with school district system administrators to solve network, firewall, and data-transfer issues
• Queried SQL to locate, investigate, and correct dropped or missing payments
• Performed web service and file drop application integrations for school districts and utility billing

Bloomington, Minnesota

• Wrote SQL queries to audit merchant on-boarding
• Aided in reconciliation of $15M processed monthly
• Improved inventory management system by scripting macros, saving 8 hours of weekly manual data entry

Plymouth, MN

• Authored a list of company policies to minimize legal liability
• Restructured employee job tasks based on knowledge, ability, and tools available

Lakeville, MN

• Assists in maintaining 5 commercial buildings throughout the greater twin cities area
• Acts as primary contact for 9 commercial tenants in regard to maintenance requests
• Performs security checks, monitoring and maintaining CCTV security system

Minneapolis, MN

• Negotiated contractual agreements for venue owners, radio promotions, record labels, and licensing rights
• Marketed company brand through use of posters, fliers, social media, street teams, and radio
• Managed web presence and online store, increasing site traffic and total sales

Bachelor Of Science, Business & Marketing Education

Bachelor Of Science, Human Resource Development

Associate Of Arts, Liberal Education