Emily Ayers Spadt, MPH

•Managed data exchange for Census files, Eligibility files, Medical and Rx Claims for 60+ clients/TPAs/PBMs •Sole owner of Client Census ETL processes designed to maintain eligibility statuses and demographics of active eligible population for 60+ clients and 500k+ eligible lives in Salesforce environment •Responsible for compiling quarterly and annual client reporting across a variety of metrics; including maintaining the schedule, delivery and client custom asks •Conducted geographic analyses for national sales team using Spotfire to drive decision making and provide insight for new client contracts •Managed ETL processes for patient satisfaction survey data (NPS), leveraging Survey Gizmo and Salesforce •Managed SFTP server; setting up new connections and troubleshooting •Served as a Salesforce SME for the Analytics team; proficient with the use of data loader, Xcel Connector, and the Salesforce reporting tool, in addition to a mastery of the data model •Performed ad-hoc analyses for both internal and external stakeholders using SAS, Spotfire, Microsoft SQL server and Salesforce reporting tool •Built and maintained Spotfire Dashboards leveraging propriety data sets to drive insights & deliver custom reporting to 60+ clients •Sole Analytics liaison for new client implementations; working directly with clients to implement new file feeds including eligibility data, medical claims, and Rx claims •Produced infographics to highlight data points using Visme •Key participant in Salesforce Health Cloud implementation, assisted with the schema crosswalk for all impacted Analytics processes •Key participant in Matillion implementation, assisted with the schema crosswalk and documentation of all existing business logic, in addition to end-to-end testing of newly developed jobs

•Conducted interviews, facilitated focus groups and workshops •Designed and administered surveys to populations of interest using Survey Monkey •Analyzed quantitative primary and secondary data using SPSS •Analyzed qualitative interview and focus group data using MAX-QDA •Developed evaluation plans, program logic models and evaluation reports to help non-profit clients measure and report on success towards their grant goals •Prepared and presented findings and recommendations to clients •Established and maintained collaborative relationships with clients across the metro Atlanta area •Managed projects to ensure all work was completed on time and on budget

• Worked alongside a local healthcare organization and NGO, KIHEFO • Conducted primary data collection and interviews in rural villages • Held nutrition education and HIV awareness seminars for women and children • Helped KIHEFO implement local, sustainable solutions to malnutrition and HIV • Performed data entry, management, and analyses for HIV clinic