Nick Larkin Email & Phone Number

Indianapolis, In, Us

Indianapolis, Indiana, Us

Indianapolis, Indiana, Us

Indianapolis, In, Us

• 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

New York, Ny, Us

• 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

Indianapolis, Indiana, Us

• 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

• 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

Arlington, Virginia, Us

• 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

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

• 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

Master Of Science, Applied Data Science

Linguist, Russian

Bachelor'S Degree, International Relations And Affairs

Bachelor'S Degree, Psychology

Education record