Ross Maclean Email & Phone Number

Edinburgh, Scotland

Palo Alto, California

Palo Alto, California

Designed and implemented fully automated suite of production-level Tableau dashboards, demonstrating ROI and value proposition of product to clients. Developed underlying databases using PySpark which enable reporting to external clients and maintained production code which selects patients for outreach, based on model predictions.

Palo Alto, California

Consulted with senior management and external clients, identifying and communicating analytic insights while overseeing the function of the Health Plan Analytics team. Developed cost and utilization reporting packages, crafted the narrative behind the data and presented findings to external clients.Created comprehensive analytic solutions that enabled exploration of trend drivers, including identification of cost reduction opportunities through analyses. Hired, trained and actively… Show more Consulted with senior management and external clients, identifying and communicating analytic insights while overseeing the function of the Health Plan Analytics team. Developed cost and utilization reporting packages, crafted the narrative behind the data and presented findings to external clients.Created comprehensive analytic solutions that enabled exploration of trend drivers, including identification of cost reduction opportunities through analyses. Hired, trained and actively developed team members whom I managed. Show less

Palo Alto, California

Consulted with stakeholders to define requirements, developing insightful and sustainable analytical solutions to meet business needs. Created Inpatient and Emergency Department utilization databases using SQL and designed a suite of Tableau dashboards to allow more effective monitoring of utilization trends for senior management. In the areas of quality and case management, performance reporting is contractually obligated for clients and tied to financial incentives. Developed… Show more Consulted with stakeholders to define requirements, developing insightful and sustainable analytical solutions to meet business needs. Created Inpatient and Emergency Department utilization databases using SQL and designed a suite of Tableau dashboards to allow more effective monitoring of utilization trends for senior management. In the areas of quality and case management, performance reporting is contractually obligated for clients and tied to financial incentives. Developed analytical solution that enabled financial payout where no prior precedent existed in the organization. Show less

Edinburgh, Scotland

Senior Analyst and Project Manager for a data migration project - successfully advocated for and implemented an enhanced clinical system that yielded more accurate payments to GP practices while gaining higher user-satisfactions scores amongst physicians. It was the first primary care project to implement centralized reporting capabilities in the NHS Lothian region, a strategic milestone for the health board. The clinical software continues to be deeply embedded in NHS Lothian more than 7… Show more Senior Analyst and Project Manager for a data migration project - successfully advocated for and implemented an enhanced clinical system that yielded more accurate payments to GP practices while gaining higher user-satisfactions scores amongst physicians. It was the first primary care project to implement centralized reporting capabilities in the NHS Lothian region, a strategic milestone for the health board. The clinical software continues to be deeply embedded in NHS Lothian more than 7 years later. Senior Analyst responsible for data management/analysis for a cardiovascular disease project - managed clinical software while consulting with clinicians and IT to ensure product met user and analytical requirements. Conducted analyses which identified data quality issues and delivered training sessions which resulted in data completeness increasing from 68% to 93% within 6 months, enabling outcomes reporting. Streamlined system and reporting processes, serving a service that quadrupled in size with same analytical resource. Show less

Edinburgh, Scotland

Coordinated the prescribing team's National Statistics publications and managed a high priority Scottish Government report which incorporated sampling methods, data validation, analysis and report writing. Reduced report processing time by 4 weeks (50%) by streamlining and automating analytical processes.Key member of prescribing user-expansion project - redesigned the prescribing SAP Business Objects universe and provided user outreach initiatives, developing training materials and… Show more Coordinated the prescribing team's National Statistics publications and managed a high priority Scottish Government report which incorporated sampling methods, data validation, analysis and report writing. Reduced report processing time by 4 weeks (50%) by streamlining and automating analytical processes.Key member of prescribing user-expansion project - redesigned the prescribing SAP Business Objects universe and provided user outreach initiatives, developing training materials and delivering training sessions to health professionals across Scotland. Show less

Master Of Information And Data Science

Bachelor Of Science (Bsc), Psychology