Ashley Todd Email and Phone Number

Lead consultant on Refill Concierge Refill Tracking project. Leveraged multiple years’ experience to assist in research discussions, and advised on both data requirements and reporting capabilities in order to meet end user needsConsults with Business Owners and Project Leaders to identify research questions, data sources, and reporting needsBuilds self-service Power BI, Tableau, and SSRS reports for departments e.g. Rx Education, Patient Safety, and HCPRUses CRM experience to build EDW-based reports to support HP Call Centers in tracking call rep. performance, member behavior, and member experienceUses Oracle and T-SQL coding languages to build reports in the EDW and Builds and the Humana Pharmacy SQL Databases (HPDW), respectively. Experienced with using PL/SQL and Microsoft SQL Server Management Studio

Develops complex self-service Tableau dashboards to support Commercial business partners in tracking metrics, identifying trends, and making business decisions Utilizes SAS programming and SQL querying to create fit automated processes for updating Tableau dashboard data sources Leverages statistical skills and data knowledge to identify the connection between Net Promoter Score and Perfect Call metrics, including identifying factors that optimize Net Promoter Score

∙ Lead UAT tester and assistant SAS programmer for the Patient Safety Refill Concierge program∙ Supported intra-department research projects, including the PCP Visit Cadence study led by Laura Happe (CPO), and Adherence to Statin Guidelines Post-revascularization and Cardiovascular Outcomes study led by Charron Long (CMO)∙ Calculated monthly medication adherence rates for 10 million Humana members across 130 therapeutic classes ∙ Maintained large adherence rate datasets to track adherence trends and to identify members for outreach programs∙ Published 3 monthly dashboards and 5 monthly data pulls as well as ad hoc requests for adherence rates∙ Utilized SAS EG to perform dataset joins across multiple tables or to extract data from the EDW system∙ Summarized complex data through simplified, user-friendly visualizations or tables in Tableau and Excel Dashboards∙ Collaborated with and provided support data to multiple departments, including Patient Safety, Clinical Analytics, Market Quality Operations, HPS Specialty Strategy, and Trend Analytics and Forecasting∙ Discovered and notified IT of a critical data integrity issue in a SAS benefits eligibility table that impacted over 20,000 members at the end of 2017

- Maintained/updated 5 databases regularly- Maintained/updated variance report values as needed- Assisted with construction of KPI report and other reports - Further developed applications for preexisting SAS database- Wrote SAS programs as needed- Manipulate and Analyze data within Microsoft Excel

- Conducted statistical testing under the direction of a research professor- Coordinated research with research professor and postdoctoral colleague- Wrote programs in SAS as for creating datasets and analyzing data- Wrote a research abstract regarding completed research- Presented research to the Northern Kentucky community through Northern Kentucky University's Annual Celebration of Student Research and Creativity - Assisted in writing a published research paper

- Answered student questions about class material and/or statistical tests - Aided students in understanding class material/homework and assisted with test preparation

- Answered student questions about vocabulary words and grammar- Assisted students with mastering the various writing scripts (hiragana, katakana, and kanji) - Practiced speaking in Japanese with the student.

- Served guests quickly and smoothly - Handled payment transactions - Addressed guest complaints and comments - Ensured a pleasant experience for customers

- Welcomed guests and handled their orders- Maintained and filled the salad bar- Prepared pizzas- Processed take-out orders- Addressed the needs of customers