Kathryn Reed

Experience

• 

  Hayward Area Information Center

  Jun 2001 - Aug 2004

  Front Desk Information Center Specialist

  Customer service representative for the City of Hayward, Wisconsin and the surrounding area, providing information for patrons regarding local businesses involved in the better business bureau. Assisted patrons. Operated advanced functions of Microsoft Word, such as mail merger, to maintain the mailing label database for vacation brochures.

• 

  University of Minnesota - Wilson Library Annex

  Sept 2006 - May 2007

  Student Library Assistant

  Part of a team of roughly 10 students supporting the greater university library system controlling over 5 million volumes and aiding over 50,000 library patrons. Utilized both the Dewy Decimal and the Library of Congress classifications.

• 

  TEKsystems

  Mar 2007 - Feb 2010

  Project Analyst

  Generated monthly, quarterly and annual metrics presentations by gathering data from three database sources and background information from 12 managers. Created reports that detailed project trends and provided data to assist in business decisions.

• 

  Duke Realty Corporation

  Apr 2010 - Sept 2010

  IT Project Coordinator

  Assisting the Executive Project Manager of the PMO with maintaining current project statuses. Assisiting with audit documentation.

• 

  Belcan Engineering

  Sept 2010 - Apr 2012

  Junior Engineer / Project Manager

  Contract position with Rolls-Royce Naval Marine Inc.•Managed a Microsoft Project resource pool for 49 project plans and 22 resources.•Provided Management with weekly and monthly statuses on Department of Defense projects over 3 manufacturing sites across North America.•Provided resources with weekly reminders of their assigned tasks and advised the project owners’ of upcoming work scheduled for each of their resources.•Assisted with the gated review of critical projects through the use of the Engineering Product Change Board/ Design Definition Resource Allocation Management, Product Information Lifecycle Management (PCB/DDRAM PILM) process across 3 North American sites and partnered with the United Kingdom site in Bristol to ensure joint projects were receiving sign-offs from appropriate budget holders while maintaining US Government International Traffic in Arms Regulations (ITAR) requirements.•Improved the process through which project metrics were being reported through the creation and implementation of Visual Basic for Application (VBA) macros that reduced the project plan reporting time from 3 days to 2 hours. •Worked as database administrator for the repository of department action items in order to ensure all needful tasks were accurately captured and delivered on time.•Facilitated in the accurate tracking and timely transfer of customer deliverables both internally through the TeamCenter Project Lifecycle Management (PLM) Software and externally through a web-based delivery system that transferred documents to the customer for official review and approval.•Worked with SAP to fascilitate transfer of repairs from customer to vendor. Show less

• 

  BCforward

  Apr 2012 - May 2014

  Process EngineerMapped complex inter-department processes and responsibilities into easy to understand visual flow charts.Analyzed and engineered improvements of Enterprise account management processes for multiple fortune 100 customers.Clarified responsibilities through the use of RACI diagrams in an effort to facilitate information flow and accountabilities between multiple departments in a Global environment.Gathered requirements by interviewing all levels of the business unit so the processes documented met the needs of everyone involved.Crafted a Data Analytics tool to pull information from SharePoint into Excel Charts that showcased data points relevant to 7 Business Areas.Project Management CoordinatorDesigned and implemented an Excel-Powered program that links SharePoint 2010 to an interactive dashboard for the consumption of Employee Utilization data forecasting. This tool is used by 50 stakeholders to manage assignment, utilization, and capacity of 100 project managers across a portfolio of 450 projects with a budgetary value in excess of $250,000,000 per annum. This automation saved over 2,500 hours per year of manual effort.Crafted, updated and maintained tri-annual metrics that utilized process data, customer satisfaction data, and Key Event planning information provided through SharePoint and presented in charts and graphs through the use of Excel 2007 macros and PowerPoint. Documented all processes surrounding the creation of metrics to facilitate knowledge transfer of the metrics process.Devised, designed, and implemented ITIL-based Service Level Metrics that calculate and report on 11 Service levels on a monthly basis. Show less Assisting to manage 60 quality and testing resources through the assignment of deliverables necessary to fulfill both project and support tasks. Working to deliver timely metrics and ensure Service Level Agreements are met with the client (Eli Lilly and Company) by performing weekly analysis of strategic data and ensuring all resources are compliant with expectations. Performing monthly and quarterly data analysis to assist with invoicing and reporting to the customer and upper management.Also assisting with management tasks for ~60 application development resources and ensuring upper management is aware of any issues with Service Level Agreements.Data gathering and SharePoint administrator for auditable key events and upcoming issues management necessary for the smooth flow of products through the manufacturing lifecycle. Show less

  • Project Management Coordinator

    May 2013 - May 2014

  • Service Coordinator

    Apr 2012 - May 2013
• 

  Milliman

  May 2014 - Nov 2015

  Actuarial Data Analyst

  Managed deliverables consisting of using SAS to create a relational mapping of the following sources: o Health Formulary data o Medicaid and Medicare Enrollment data o Commercial Enrollment data from Health Leaders Interstudy using US Census to determine where lives are dually enrolled. o Health Insurance Transaction data o Pharmacy Benefit Managers (PBM) relationships to Managed Care Organizations (MCO)Migrated the deliverable from a Monthly process to a Weekly process.Assisted in creating a quarterly Hierarchal view of changes of affiliation between Managed Care Organizations (MCOs) and Pharmacy Benefits Managers (PBMs). Such changes have the potential to change the relationship of Transactions and Lives allocations for the coverage of products.Documented the previously unwritten Milliman process by which the weekly Lives Enrollment, Account, and Transaction data was provided.Maintained the Quality Resource Management workbook, which documents the Pre-Release Peer Review signatures of acceptance attained from Milliman Principles prior to the delivery of the artifacts.Provided Enhancements to the SAS programs that create the deliverable through the collaboration and version control tool of GitHub. Show less

• 

  Randstad Technologies US

  Feb 2016 - Sept 2016

  Process Improvement Advisor

  Contract position with Anthem, Inc.Documented previously undocumented processes utilizing Microsoft Word and Visio swim lane diagrams to create and describe process maps that clearly describe the processes.Managed a team to create a document repository on SharePoint that would not only store the new documentation but would also act as a reminder system to alert the process owners of upcoming Periodic Reviews.Assisted in the gathering of all audit deliverables so that they might be added to an audit repository, ensuring that when the team responded to an audit request, the response would be in line with what was delivered in the past.Assisted in the creation of metrics dashboards that showcased the health of Network Appliances and detailed whether we were missing or meeting our SLAs. These dashboards were created in Microsoft Excel using Pivot Tables and Pivot Slicers, then linked to a SharePoint Web Part so that any user with the SharePoint link could view the dashboards and view the data in the way that made the most sense to them.Improved the metrics creation by automating the way the metrics were being generated so that manual errors would not occur. Show less

• 

  Theoris Services

  Sept 2016 - Aug 2017

  Information Security Analyst

  Contract position at Navient.Managed Monthly and Biweekly reporting on vulnerability management metrics, ensuring that key stakeholders are informed of which systems are the most vulnerable and how remediation is trending over recent scan cycles.Used advanced sharing features of Microsoft Excel to combine status reports from multiple project managers into a single organized format capable of informing management of the current remediation progress on key systems under audit from federal regulators.Standardized the metrics process, previously in flux, through the coding of Visual Basic (VBA) to create Microsoft Excel macros. This standardization decreased user error in the creation of the monthly metrics.Assisted in the documentation of the Metrics processes allowing easy handoffs between team members as necessary. Show less

• 

  BCforward

  Aug 2017 - Mar 2018

  Business Change Manager

  Designed weekly trending analyses for Medicaid Claims to keep the business informed of the changes in percent of claims paid versus those that were denied, allowing for more proactive corrective action to take place when errors occurred in billing. These analyses utilized Standard Deviation calculations to ensure that current data was within expected parameters and called attention to data points that were outside regulatory compliance.Utilized Microsoft Excel’s Power Query function to relationally link multiple claims data sources such as from SharePoint, Excel, and csv files to provide timely and complete operational reports to management.Managed the design and implementation of a Tableau interface for weekly reports to provide management with a graphical display of current business health.Managed the business side of Statewide and Nationwide Projects for Indiana Medicaid’s Cost of Care initiatives and kept the business informed of project progress and delays.Documented several metrics processes to allow for the easy hand off of repeatable reports to the team’s data analysts. Show less

• 

  Anthem Blue Cross and Blue Shield

  Apr 2018 - now

  • Health Information Manager

    Apr 2022 - now

  • Business Information Analyst

    Apr 2018 - Jun 2022