HEALTHCARE
Implement a Patient Centric Relationship Program for a Healthcare Organization based on Patient visit patterns.
I M P L E M E N T A
P A T I E N T –
C E N T R I C
R E L A T I O N S H I P
P R O G R A M
T E C H N O L O G Y
ETL – Hadoop
Data warehouse – Amazon
Redshift
Reporting – Tableau
O B J E C T I V E
Improve patient awareness, well-being and loyalty through
relationship programs and concurrent communication
campaigns
A P P R O A C H
Developed advanced algorithms and matching criteria to
clean and de-duplicate more than a million patient records
set.
Analyzed patients’ OP (outpatient) and IP (in patient)
behaviors.
Number of visits and spend
By service used for e.g. consultation or diagnostics
By department/specialization e.g. neurology
Patients’ propensity to use broader range of services
Preventive Health Programs
Post IP recommended regular OP visits
Designed specific campaigns and patient relationship
program by patient segment, specialty, services and hospital
location.
O U T C O M E
Enhancements in front-end controls.
Well-structured patient relationship program; ensured
integration with departments and improved campaign
responses and Marketing ROIs.
Established closed-loop feedback mechanism to refine
campaign and relationship program offerings.