Elizabeth Royer Email & Phone Number

• Built and managed 2 long-term agile scrum teams responsible for Data Governance, Reporting & Analytics, and Data Architecture and Integration for the Data Warehouse• Helped design the foundational concepts of 3 layers of data for reporting & analytics purposes – roughly similar to the medallion architectural storage zones and lake house concept• Coordinated with DevOps & System Architecture teams to define & implement strategies pertaining to the data lake/ODS and data warehouse databases• Functioned as business analyst, high-level designer, & manager for two short-term agile scrum teams that built a parallel comparison testing system and a tool to copy plan benefits configurations between platforms• Defined and established the beginnings of Data Governance policies, procedures, and enforcement• Provided data subject matter expertise to help design a star schema data model for the new data warehouse, as well as supply & validate data mappings for the warehouse model• Lead the team through evaluation, implementation, and beginning development of structured, ad hoc, and self-service reporting using Jasper Reports• Guided the team through evaluation, implementation, and beginning development of data ingestion and integration frameworks, including incremental data pipelines using Informatica Intelligent Cloud Service (IICS) to load data in the warehouse• Remotely hired, trained, mentored, & motivated team members across three US time zones plus India• Collaborated with internal IT and business product owners as well as external stakeholders across all US time zones to identify business requirements and translate them into technical requirements• Provided data subject matter expertise as needed for my own teams and others in the organization• Provided status updates and insights to program managers and IT leaders• Facilitated defect triage and resolution for system integration testing of the claims adjudication system

Kansas City, Missouri Area

• Provided descriptive analytical insights into specific business questions • Designed and developed a machine learning method of analyzing pharmacy benefits configurations• Designed and developed a Proof-of-Concept effort using machine learning techniques to identify potential pharmacy Fraud Waste & Abuse situations• Designed and developed a Proof-of-Concept effort using machine learning techniques to predict stipulations of drug rebate contract provisions• Worked jointly with data engineers using Hadoop, pyspark, and python to ingest, cleanse, organize, and transform data prior to analysis• Converted existing qualitative and quantitative data profiling processes from pyspark to python• Mentored a junior data scientist in data analytics, providing overall guidance and data subject matter expertise• Designed and built a batch processing engine for a major enhancement to the Fraud Waste & Abuse detection system using python and bash shell scripts deployed using GitLab/GitHub CI/CD

Kansas City, Missouri Area

For all job titles at this company combined:• Researched questions and defects in the pharmacy claims processing system, designed and implemented solutions as needed, and provided mentoring and guidance to other developers and engineers• Designed and developed advanced queries and ad hoc data extract and transformation processes to identify claims impacted by various system defects, occasionally using DataStage software to incorporate data from multiple databases and types of “flat” input files• Researched the processing logic of various claims processing subsystems, creating and/or maintaining system documentation based on that logic• Mentored and trained others as a subject matter expert in several areas within pharmacy claims processing, including Member Matching, Part D Transition & Protected Class, Part D Financial Information Reporting (FIR), and Part D Member Accumulation Reorder (MAR) • Helped design and build the original Parallel Claims Comparison testing system• Designed and executed thorough unit testing of new or modified code, and occasionally QC testing as well

On contract at Argus Health Systems

• Managed small- and medium-sized technical projects• Provided leadership and guidance to other programmers on larger projects (“Technical Lead” role)• Analyzed and fixed processes in computer systems with no prior training or exposure to them• Learned obscure software packages and programming languages “on the fly” to provide production support• Participated in and managed every stage in the software development life cycle • Designed new applications and enhanced existing applications to satisfy the requirements of internal customers• Provided 24/7 technical support for production systems on a rotational basis• Mentored junior coworkers and provided consultation for others• Created training documentation for new systems and processes for internal customers• Analyzed programming changes required for software upgrades and implementations• Worked with systems and business users in these functional areas: Accounting, Finance, Accounts Payable, Tax, Property Accounting, Cargo Claims, Driver and Shipment tracking systems, Equipment Maintenance, Operations Productivity ReportingPrevious Job Titles at YRC Worldwide Technologies during these years:Application Programmer/Analyst IIIApplication Programmer/Analyst IIApplication Programmer/Analyst IApplication Programmer

• Provided technical support for software applications used in a graduate-level class on computer cartography• Learned several graphics-related software applications on my own, without formal training• Created tutorials for various software applications• Helped students solve technical problems related to coursework• Assisted with administrative tasks related to teaching and keeping track of students’ work

• Prepared, organized, and delivered lectures for an undergraduate geography class about maps• Updated the course’s web site to meet the needs of the current semester• Enhanced the course’s web site, adding interactive tutorials on several topics• Administered and critiqued student assignments, projects, and exams• Recorded and issued student grades for the course

• Enhanced, queried, and managed GIS database for the state of Missouri• Designed and produced graphs for department planning meetings• Conducted extensive research of HTML and web page design

• Supervised and assisted student workers on a project for the Missouri Highway Department using Arc/Info GIS software at the Geographic Resources Center• Controlled the quality of the data supplied for the Missouri Highway Department project• Updated and executed automated routines (ARC Macro Language) to process data in the GIS database for the Missouri Highway Department project• Created a historical map for publication in a calendar, primarily using Adobe Illustrator graphics software

• Assisted voters with registration and voting• Organized and transported supplies to ensure adequate resources at voting locations• Officiated at voting polls on election days

• Prepared and delivered semi-weekly lectures for “lab” class accompanying an undergraduate lecture course• Created and administered class assignments and exams for the lab• Recorded and issued grades for 110 students each semester

Master Of Science - Ms, Business Intelligence & Analytics

Ma, Geography

GPA 3.595

Ba, Geography, Math

Activities and Societies: Bright Flight Scholarship, Virginia Hultz Booth Education Scholarship, Arts & Science Alumni Scholarship.