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

• 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

• 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

• 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• Managed schema and server role security, restricting employee access to meet PHI security standards

• 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 planning.

• 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

• 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• Automated file drop tasks for proprietary applications

• 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

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

• 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

• 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