Experience

Indiana Management Performance Hub
• United States
• Government Administration
• 1 - 100 Employee
• Data Architect

  • Jan 2019 - Present


hc1.com

• Data Engineer

  • Mar 2018 - Aug 2018

  • Managed an Amazon Web Services (AWS) data lake storage repository • Automated and scheduled ETLs with Cron jobs and jobs created with Pentaho Spoon and Kitchen - Extracted and loaded large data sets to and from MySQL and PostgreSQL servers as well as AWS S3 buckets and Redshift clusters • Designed and implemented a new data-driven marketing product - Utilized CMS claims and commercial claims data sets to identify trends in medical referrals - Enabled clients to identify high-volume sources of referrals and target new sales opportunities - Designed and delivered new business intelligence visualization products with Tableau dashboards • Discovered and fixed significant deficiencies in vendor-provided healthcare data sets including CMS and commercial claims • Designed and implemented new data models in production and development environments • Migrated databases from AWS Redshift clusters to Snowflake servers • Created new data quality control (QC) and data quality assurance (QA) procedures - Composed hundreds of pages of technical documentation - Utilized Tableau dashboards, Excel reports, pivot tables, ad hoc T-SQL, MySQL, and PostgreSQL queries to analyze and optimize process performance Show less



Precision for Value

• United Kingdom
• 1 - 100 Employee

• Business Intelligence Analyst

  • Jan 2017 - Nov 2017

  • Led product development and client engagement for two big pharma clients with combined FY 2017 contracts totaling over $2.2M revenue • Developed and managed ETLs for data-driven marketing products • Managed new product development - Coordinated back-end developers and front-end developers - Programmed solutions supporting email campaigns that targeted prescribers with individual unique cost and coverage messages for branded drugs - Programmed solutions supporting dynamic web banners that targeted prescribers with individual unique cost and coverage marketing messaging for branded drugs - Programmed solutions supporting mobile applications that enabled sales representatives to deliver unique marketing messages to individual prescribers - Data sets included Insurance Claims and Cost Shares, Pharmacy Transactions, Sales Representative Identities, Prescriber Identities, Healthcare Systems, Hospitals, and Facilities • Developed and implemented new data quality control (QC) and data quality assurance (QA) measures - Ad hoc SQL queries and stored procedures, SSIS packages, SSRS reports • Provided work management solutions using SharePoint Online with complex workflows Show less



Indiana University Health

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Data Architect

  • Mar 2015 - Sep 2016

  • Managed Indiana’s largest healthcare Enterprise Data Warehouse (EDW) - Assisted in the design and implementation of a Parallel Data Warehouse (PDW) - 24 Nodes, 400 Terabytes, 40,000 Users At-Large, 16 Source Marts, and 500 Self-Service Users • Coded and executed ETLs across development and production environments - Oracle, SQL Server 2012, and SQL Server 2014 - Ad hoc SQL queries and stored procedures, SSIS packages, and SQL Agent jobs • Designed, built, and implemented departmental Change Management solutions - Created and managed on-premises SharePoint sites and SharePoint Online sites - Designed and implemented complex ticket management workflows using SharePoint Designer, Visio, and Infopath • Developed requirements and tested proofs of concept for PDW enhancements - Stood up Informatica Master Data Management (MDM) and Informatica Data Quality (DQ) enterprise solutions - Tested and implemented JAMS Job Scheduler enterprise solutions • Responsible for protected health information (PHI) in partnership with external organizations including the National Research Corporation (NRC) and federal regulatory agencies - Scrubbed PHI from 100,000 monthly patient encounter records with zero regulatory violations - Managed and executed hundreds of ETLs • Populated performance score cards for 18 hospitals and two departments with SAP Business Objects • Led the Spec and Quality Assurance (QA) Teams - Developed specs and managed QA for 1,000 Data Warehouse enhancement, change, and fix requests - Delivered QA reports with Tableau dashboards Show less



Self-Employed - consultant

• IT Services and IT Consulting
• 100 - 200 Employee

• Independent Business Management and Marketing Consultant

  • Jun 2014 - Feb 2015

  • Provided IT and marketing solutions for businesses - Designed, built, and managed traditional and responsive business websites - Delivered branding, identity, and logo solutions - Managed marketing messaging and social media campaigns - Designed and delivered mobile solutions for job estimate and customer invoice delivery - Managed licenses for business IT and communications solutions - Provided employee IT training - Snell Tree Experts, an arborist and landscaping company with 15 employees - Achilles Built, a home improvement contractor with four employees - SWAT Off-Road, a storefront for off-road vehicle aftermarket parts and services - Cammed Crazy, an all-terrain vehicle dealership Show less



US Army

• United States
• Law Enforcement
• 1 - 100 Employee

• Intelligence Officer

  • 2005 - 2014

  • Led, trained, evaluated, and mentored teams of 3 to 16 intelligence analysts, geospatial engineers, and media specialists both stateside and during combat operations (Ramadi/Fallujah, Operation Iraqi Freedom, 8/06 to 11/07) • Identified challenges to the doctrinal intelligence process and implemented original solutions, published: “Sustainment-Centric Intelligence.” Army Logistician Jul. – Aug. 2009: 13. Print. • Designed, built, and managed data analysis systems serving the intelligence requirements of over 20,000 US Army, US Marine Corps, and foreign military commands during combat operations • Presented over 2,000 multimedia intelligence products to live and broadcast audiences • Planned and executed over 1,000 intelligence, logistical supply, and economic development operations • Selected for and served as the Intelligence Officer for the Global Response Force (GRF) • Administrated a SharePoint farm for over 3,500 personnel as Knowledge Management Officer • Managed security of operations, personnel, and information systems for over 3,500 personnel • Honorably discharged with multiple awards for technical achievements and combat leadership Show less



Wayne Township Fire Department

• United States
• Truck Transportation

• Firefighter/EMT

  • May 2001 - Apr 2003

  • Responsible for WTFD Ambulance 82 • Responded to over 1,000 911 emergency calls • Responsible for WTFD Ambulance 82 • Responded to over 1,000 911 emergency calls



On-Net Internet Services

• Technical Support Engineer

  • Jan 1996 - Sep 1998

  • Designed, built, and managed 5 business websites • Served as a technical support engineer for dial-up Internet access customers - Resolved over 3,000 technical support requests • Created, operated, and managed a new in-house hardware repair program for 200 customers • Recruited and managed 4 student employees • Designed, built, and managed 5 business websites • Served as a technical support engineer for dial-up Internet access customers - Resolved over 3,000 technical support requests • Created, operated, and managed a new in-house hardware repair program for 200 customers • Recruited and managed 4 student employees