Aaron Hogancamp
Gallatin,TN
Summary
Experienced Business Intelligence Manager with 12+ years of experience in understanding and utilizing data with hands on experience in almost every data-centric role. Proven track record of team leadership, managing up to 20 globally distributed team members. Experience in owning, managing, and globally launching multiple new products. Exceptional problem-solving and analytical thinking skills. A results-oriented leader ready to add value to any organization.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Product Manager, Business Intelligence
Tricentis
Remote, TN
04.2022 - 09.2023
- Achieved 100% data quality in production by writing end to end tests in Python comparing the final output to Redshift to the original data source measured by random testing in production and the lack of customer-logged defects
- Owned and managed from the idea to a market release with a new add-on service to the flagship product creating the pricing strategy, multiple marketing blogs, a webinar, and 30+ customer engagements to describe what it is and how to implement it
- Developed comprehensive product quarterly, 1-year, and 3-year roadmaps to drive product adoption, coordinate with leadership and other teams, and meet customer expectations for an external-facing Business Intelligence self-service solution
- Designed and implemented an analytics database for reporting by using 3rd form star models in Redshift that efficiently combined all 5 major products within the company where they overlapped but allowed product-specific customization as well
Principal Data Engineer
Acqueon
Remote
09.2019 - 04.2022
- Consolidated all 5 product databases into a single 360 customer database by designing, building, and incorporating SQL, NoSQL, and Big Data solutions
- Managed 10 customer relationships around AI discussions and technical implementation by corresponding as both the Product Manager and the deployment engineer to the customer leadership and customer engineers, respectively
- Built 5 proofs of concept for new machine learning models using lower environment synthesized data to work out features and data structures for potential machine learning models
- Developed and deployed a completely custom Auto-ML solution built within Spark using Docker within one year using three globally distributed resources and acting as the architect, lead engineer, product manager, environment manager, and deployment engineer
Business Intelligence Manager
naviHealth
Nashville
12.2017 - 09.2019
- Regulated compliance requirements with working with Legal and Security by creating and implementing a data governance framework to ensure data integrity, quality, and compliance with over 250 customer contracts across three categories of usability regulations
- Improved post-acute patient care and reduced acute re-admittance by leveraging data science expertise to develop multiple machine learning solutions such as creating targets for occupational therapy scores, physical therapy scores, and speech therapy scores, recommending the lowest level cost of care without impacting the patient expected outcomes, and giving time window expectations of how long therapy should take to reach those scores
- Decreased machine learning model testing time by 6 weeks (75%) by building a self-service Tableau Server solution for the therapists dedicated towards testing the machine learning models against a standard patient population by highlighting outlier predictions when compared to the actual patient response
- Decreased machine learning model time to production by 8 months (89%) by integrating the AI team into a DevOps pipeline to regulate and automate model deployment across environments
Staff Data Scientist
The General
Gallatin, United States
11.2016 - 12.2017
- Discovered a fraud ring who had collected $60K already by implementing automated outlier alerts around custom features such as if the people in the claim were in previous claims as well, frequency of claims within a year, and number of driver-less claims such as crashing in ditches or against animals
- Made the data science effective by creating and maintaining the team datamart of 15 tables for data re-used more than once across projects including nightly updates, on-prem data sources, and cloud-based storage
- Improved customer experience by creating recommendation logic to map a pre-identified caller to the best agent available using NPS scores if the customer liked an agent previously and a machine learning model to identify the most likely skills needed by the agent for the customer
- Grew the data science reputation and capabilities by working with leadership teams to define potential AI-based or automation opportunities resulting in over 600 man-hours saved each year in repetitive tasks
- Increased efficiency in litigious responses by creating NLP models to identify and fast-track likely claims that will require legal advice resulting in 15-20 fast-tracked claims a month with a 75% accuracy rate
Data Engineer
Leidos
02.2015 - 11.2016
- Saved over $100K of man-hours a year by automating repetitive manual tasks throughout the company in Python such as monthly report building or excel updates by engineers
- Increased responses to bad units by creating IoT alerts for unresponsive meters using robust Oracle SQL data pipelines in near-real-time
- Created a data ingestion process for customers to push their data to our SaaS product via an SFTP server
Senior BI Developer
Asurion
Nashville, TN
06.2011 - 02.2015
- Increased efficiency and removed confusion across 600 resources in IT by consolidating all reporting and analytics into a common data dictionary and building a self-service SSAS cube to contain it
- Enabled data-driven decisions around releases, team-level decisions, and leadership KPIs by creating and scheduling reports in a timely manner using Business Objects XI and SSRS and by managing a custom, self-service, internal BI solution using javascript
- Validated 20 low-bug releases across a myriad of products by a leading cross-functional, globally distributed team of 10 testers, engineers, and analysts
- Reversed a poor reputation of an internal ops team within a year by working with all internal customers to effectively prioritize the "black hole" backlog and effectively manage the completeness of new requests
Education
Master of Science -
Tennessee Technological University
01.2011
Bachelor of Science - Mathematics
Tennessee Technological University
01.2008
Associate of Science - Mathematics Education
Volunteer State Community College
01.2006
Skills
- Advanced Algorithms
- AI Customer Implementation
- AI Product/Project Management
- AI Solution Design
- Automation
- Business Acumen
- Business Intelligence Development
- Business Intelligence Pipeline Development
- Business Intelligence Manager
- Business Objects
- Cross-functional Leadership
- Data Analytics
- Data Engineering
- Data Governance
- Data Integration
- Data Modeling
- Data Science
- Data Strategy
- Data Warehousing
- DataMart Design
- Functional Proofs of Concept
- Operational Efficiency Optimization
- People Management
- Prescriptive System Implementation
- Project Management
- Python
- SDLC Implementation
- Self-Reporting Capabilities
- SQA Testing
- SQL
- SSRS
- Tableau
Certification
- Deep learning AI (Oct 2023): Generative AI with Large Language Models
References
References available upon request.
Timeline
Product Manager, Business Intelligence
Tricentis
04.2022 - 09.2023
Principal Data Engineer
Acqueon
09.2019 - 04.2022
Business Intelligence Manager
naviHealth
12.2017 - 09.2019
Staff Data Scientist
The General
11.2016 - 12.2017
Data Engineer
Leidos
02.2015 - 11.2016
Senior BI Developer
Asurion
06.2011 - 02.2015
Master of Science -
Tennessee Technological University
Bachelor of Science - Mathematics
Tennessee Technological University
Associate of Science - Mathematics Education
Volunteer State Community College