CARY HOGAN
Mt. Juliet,TN
Summary
Dynamic Data Engineer with a proven track record, excelling in data quality and governance initiatives. Expertise in SQL and data transformation, coupled with strong communication skills, led to a 50% reduction in QA time. Passionate about leveraging data analytics to drive impactful decision-making and enhance organizational performance.
Overview
17
17
years of professional experience
Work History
Data Engineer
Sonata Software
10.2023 - 12.2024
- Worked within the Enterprise Data Management (EDM) team as a Data Engineer, leading and implementing key initiatives and special projects
- Key projects include: Data Quality Framework | Medical Economics | HEDIS Measures | CMS Activities & Requests | Site Mappings
- Data Warehouse architecture, design, and development
- Data integration and data pipeline development done using MS Visual Studio
- Data Extraction, Transformation, and Loading (ETL & ELT) done using SQL coding, SSIS, and stored procedures
- Nightly intake of EHR data for loading into the Data Warehouse
- Relational database concepts applied using Data Normalization techniques
- KPI metrics design, documentation, and development
- Ad hoc analyses and report development
- Agile scrum development framework
- Service Now (SaaS)
- Azure (DevOps)
Director of Data Management
Pharmaceutical Strategies Group (PSG)
Plano, Texas
04.2016 - 11.2022
- Led and directed the Data Transformation & Quality Assurance team for Artemetrx, PSG's robust data and analytics technology platform (SQL Server), primarily, for new clients, making sure the historical Eligibility, Medical, and Pharmacy data were successfully on-boarded, and the client successfully implemented on schedule
- Helped implement the company’s first Data Governance framework which enhanced the quality and accuracy of the data, leading to better data-driven decisions, automation initiatives, and increased data value within the organization
- Helped develop the company’s first automated end to end Data Quality Assurance process, which ran as a part of the recurring ETL data pipeline process and reduced the time and costs to QA the data by at least 50%
- Developed the company’s first end to end Data Quality Executive Dashboard
- Relational Database concepts applied using Data Normalization techniques
- Data defects, and where to drill down and troubleshoot those defects, were identified much quicker, which saved on resource costs and allocation
- Managed the SQL Cloud Server instance for processes and procedures for PSG’s Specialty Monitor and Rx Monitor applications via Citrix Virtual Desktop Infrastructure (VDI)
- During client implementations, met with external stakeholders to assure technical specifications were communicated, and then worked with them to obtain file record layouts, data dictionaries, and other supporting documentation
- Evaluated the member and claims level detail data to determine appropriate methodology to be used for Medicare, EGWP, and Commercial grouping break outs
- Conducted analyses to determine member counts, claim counts, and PMPM costs by group
- Mapped the data attributes from the client source data to the PSG target destinations to develop the Eligibility, Medical, and Pharmacy data import adapters and data transformation procedures in SQL
- Executed the data transformation procedures to load the historical Eligibility, Medical, and Pharmacy data
- Performed the data QA, and then, facilitated the UAT with applicable stakeholders
- Created advanced data analytics, formulas, pivot tables, charting, etc
- Using MS Excel
- Developed KPI measures in SQL, as well Data Visualization in Excel and SSRS for effectively & efficiently analyzing and visualizing the data using pivot tables, summaries, and trends for the total population and for breakouts of the data by Medicare, Commercial, and EGWP
Director of Client Analytics
Evolent Health
Arlington, Virginia
01.2016 - 04.2016
- Supported the Vanderbilt Health Affiliated Network (VHAN) as the reporting and analytics engagement lead
- Traveled to company headquarters in Arlington, Virginia, monthly, for training and team building
- Provide insights into the client's culture and analytics and reporting needs
- Frequently met with client stakeholders to help foster a healthy relationship between Evolent Health and VHAN
- Project lead on the conversion of Business Intelligence and Reporting platforms from Tableau to Micro Strategy
Senior Corporate Strategy and Innovation Specialist
Tivity Health
Franklin, Tennessee
03.2012 - 12.2015
- Specialized in Wellness and Behavior Change outcomes development, measurement, and Finance value proposition
- Co-Developed performance indicator dashboards to monitor and report on product performance and efficacy
- Using Oracle and SQL Server, coded the queries and pulled the metrics data, for analysis and reporting
- Utilized Excel to pivot and analyze the data
- Tailored metrics to allow for Client and Group Level breakouts for Medicare, EGWP, and Commercial populations
- Assisted client account teams in interpreting trends and answering questions related to Wellness measures
Senior Data Quality Assurance IT Consultant
IDR, Inc.
Greater Nashville Area, TN
11.2011 - 03.2012
- Primary project was related to the conversion of Data Integration tools from Java Caps to a hybrid combination of SSIS and BizTalk
- Developed processes to assist in data quality initiatives, one involving the development of a file comparison tool, useful in comparing result sets from Java Caps and SSIS
- Areas of focus were Data Integration, Quality Assurance, and Testing
Senior Product and Market Performance Analyst
Tivity Health
Franklin, TN
07.2007 - 11.2011
- Specialized in Pharmacy Benefit Management (PBM) Market performance measurement and tracking
- Partnered with Operations and the client account teams to establish key metrics and Performance Guarantees for tracking purposes
- Created and developed KPI dashboards to assist in performance guarantee tracking and provide proactive insights into whether a PG was going to be met or not, and if adjustments were needed in order to meet the PG
- Included capability within the dashboard to allow for population breakouts, primarily by Client and Group Level, Medicare, EGWP, and Commercial
- Developed processes to help drive and maximize performance, one consisting of a nightly automated procedure that assisted the call center manager (the following morning) in assigning calls for the day
- Developed Performance Guarantee and SLA reporting and tracking
Education
Master of Business Administration - MBA - Business Management Information Systems
Tennessee Technological University
Cookeville, TNBachelor of Science - BS - Business Management Information Systems
Tennessee Technological University
Skills
- Data Analysis
- Data Architecture
- Data Analytics
- Data Management
- Data Modeling
- Data Reporting
- Data Governance
- Data Quality
- Data Metrics
- Data Visualization
- Databases
- SQL Server
- Programming
- SQL
- Stored Procedures
- MS Office
- MS Excel
- Process Improvement
- Communication
- Project Management
- Product Analytics
- KPI Development
- Data Mapping
- Data Transformation
- Consulting
- Healthcare Data
- Medical claims data
- Pharmacy claims data
- Mentoring
- Servant Leadership
- Issue Resolution
- Problem Solving
- Troubleshooting
- Research
- Data Measurement
- Cloud technologies
- Outcomes Measurement
- Visio
- Cost Reduction
- Scalability
- Automation
- Innovation
- Data Integration
- ETL
- ELT
- Business Intelligence
- Oracle
References
References available upon request.
Timeline
Data Engineer
Sonata Software
10.2023 - 12.2024
Director of Data Management
Pharmaceutical Strategies Group (PSG)
04.2016 - 11.2022
Director of Client Analytics
Evolent Health
01.2016 - 04.2016
Senior Corporate Strategy and Innovation Specialist
Tivity Health
03.2012 - 12.2015
Senior Data Quality Assurance IT Consultant
IDR, Inc.
11.2011 - 03.2012
Senior Product and Market Performance Analyst
Tivity Health
07.2007 - 11.2011
Master of Business Administration - MBA - Business Management Information Systems
Tennessee Technological University
Bachelor of Science - BS - Business Management Information Systems
Tennessee Technological University
Similar Profiles
Sai Prudvi TejaSai Prudvi Teja
Product Support Engineer at Sonata Software (Vaakruthi Software Pvt Ltd)Product Support Engineer at Sonata Software (Vaakruthi Software Pvt Ltd)
RajasekharaReddy ChintalaRajasekharaReddy Chintala
Digital Architect / Senior Azure Data Engineer at Sonata SoftwareDigital Architect / Senior Azure Data Engineer at Sonata Software
Sivaprasad TSivaprasad T
Lead Hybris Developer at Sonata SoftwareLead Hybris Developer at Sonata Software