• The organization provided RCM and other managed services to over 60+ medical practices across 4 states. Developed data warehouse and ETL process to gather data from disparate practices to support centralized reporting.
• Developed executive dashboard at the CBO level, as well as individual practice level
• Distributed daily reports on production, claim lag, and over 30 key metrics
• Built Cognos cubes for larger clients to slice and analyze data over time
• Built a black box to effectively track claims work across disparate systems

Behavioral Health

Built a patient dashboard that accumulated historic lab results and appointment attendance to visually inform providers of patient adherence to treatment protocolsSystem pulled appointment information from EMR, as well as lab results from multiple internal and external lab information systemsFiles were transmitted daily with secured transfer (sftp) toGoogle Cloud Platform, normalized and processed with python scripts, MySQL stored procedures, and visualized with Google DataStudio