Justin Lane

Enhanced healthcare plan efficiency by integrating Compass Rose and Utilization Management at Mass General Brigham Health Plan.

• Developed intricate SQL queries to deliver insights on health plan programs
• Transformed client caboodle environment by integrating care plans
• Constructed customized data collection models for specific visualization tasks
• Created several dashboards for care managers to monitor their programs and populations
• Wrote Chronicles, Clarity, and Caboodle-based reports

Assisted clients with their healthcare data journeys. I worked with a North Carolina based healthcare network that is on their way to being acquired by Risant Health/Kaiser Permanente. My role was to unify their disparate data with an emphasis on files coming from payors including claims, eligibility, and financial summaries.

• Laid the ground work for a Power BI and SQL-based automation that empowers stakeholders with a daily snapshot of where their data is, and where bottlenecks are with any given payor or file.
• Wrote complex queries in SQL to analyze SFTP actions for incoming and outgoing file transfers and their timeliness
• Analyzed and documented over a dozen ETL pipelines and advised on new approach, eliminating unneeded complexity and providing value to stakeholders
• Created Excel workbooks for high-level stakeholders as well as technical leaders, allowing them to understand where their precious data is at any given time

BI Analyst working for the Data Management team with a specialty in Epics' Healthy Planet (population health), and years of experience working with Beaker (lab), MyChart (digital health), EpicCare Link (external providers), and EpicCare Ambulatory (outpatient) applications. While Epic-based, these skills are highly transferable to healthcare report writing in general.

• Expertise in Epic Clarity and Caboodle report writing using T-SQL - very strong SQL skills
• Used Python to automate data manipulation for files being sent to 3rd party vendors
• Used PowerShell to automate delivery of Tableau workbooks to various users, giving them snapshots of dashboards as frequently as needed
• Developed SQL scripts for Tableau data pipelines and created dashboards and reports
• Developed highly complex SQL reports crucial to the organization's pop health efforts, such as the HEDIS-based supplemental data submission to Blue Shield
• Created ETL pipelines in SSIS for files to/from payors
• Demonstrated ability to work across several applications with immense care given to the nuances, considerations, and privacy requirements of each
• Empowered users with self-service reporting, including Tableau, SSRS, SlicerDicer, and Power BI
• Provided users with a suite of reporting tools across a range of metrics and KPIs, often for regulatory purposes with stringent standards
• Worked with a wide variety of payors with an equally wide variety of health plans - HMO, PPO, Medicaid, and MA, for example
• Managed SFTP file transfers to and from various payors
• Developed familiarity with claims and payor files

• Responsible for implementing strategies that support the integrity and administration of data for the Education Division of the Monterey Bay Aquarium
• Acted as the sole representative of the Education Division during the implementation of the Tessitura ticketing system and the ACE ecommerce platform
• Managed Salesforce for Education department, ensuring data integrity and cleanliness for thousands of students, teachers, and schools
• Aided in pioneering the AZA world's first online, fully-automated ticketing system for education programs