Kate Olsen

Solution Architect at United Healthcare

Queen Creek, Arizona, United States

About

Worked on various IT environments, platforms and industries working as programmer analyst, business analyst, senior lead software engineer, and senior business analyst throughout the career. Responsibilities included gathering requirements, generating data mappings, performing data analysis/profiling to generate technical design framework and designs that meet the client requirement. Work included creating and developing working relationships with various functional areas within IT such as data modelers, DBAs, system administrators, and quality analysts to ensure that the projects are implemented successfully. Working in very close collaboration with the data modeler to ensure that the data model and solution design defined meet the user requirements within the given IT framework. Additional responsibilities included providing support to project and resource managers for work assignments and project milestone deliveries. Also, oversaw all development work including code reviews and performing system integration testing.

Experience

  • UnitedHealth Group (31 yrs 3 mos)
    • Architect
      Aug 2022 - Jun 2026 · 3 yrs 11 mos

      Leading a group of analysts to deliver fully integrated data from varying legacy platforms and enterprise data warehouse for employer groups and broker facing reporting repository for Claims Experience Report application. Work closely with Business to gather and refine requirements, and collaborating with the data modelers, quality assurance analysts and software engineers to develop data mart to support reporting team in Azure Snowflake environment.

    • Principal Business System Analyst
      Nov 2021 - Jul 2022 · 9 mos

      Leading a group of analysts to deliver fully integrated data from varying legacy platforms and enterprise data warehouse for employer groups and broker facing reporting repository for Claims Experience Report application. Work closely with Business to gather and refine requirements, and collaborating with the data modelers, quality assurance analysts and software engineers to develop data mart to support reporting team in Azure Snowflake environment.

    • Principal Business Systems Analyst
      Jan 2018 - Nov 2021 · 3 yrs 11 mos

      Led delivery of a datamart for actuarial, network pricing and underwriting businesses by integrating data from enterprise data warehouse (Unified Data Warehouse) that contains claims, providers, member and customer information. Collaborated with the data modelers, database administrators and software engineers to develop solutions in integrating data into uniform sets for analytics.

  • Programmer Analyst at Waldenbooks
    Sep 1994 - Apr 1995 · 8 mos

    Coded and tested payroll and other human resource applications using DB2 and Cobol2. My tenure at Waldenbooks was short-lived as they were acquired by Borders and was moving the position to Michigan.

  • Business Analyst at CUC International
    Apr 1993 - Sep 1994 · 1 yr 6 mos

    Developed functional specifications and comprehensive system test plans. Bridged the gap between development team and user communities utilizing strong technical background and effective communication skills.

  • Programmer Analyst at Mellon Bank
    Aug 1989 - Apr 1993 · 3 yrs 9 mos

    Wrote programs in COBOL2/DB2 on a large IBM platform to support internal financial systems. Provided technical support collaborating with business analysts in processing monthly and yearly cycles.

  • Programmer Analyst at Union Switch & Signal
    May 1987 - Aug 1989 · 2 yrs 4 mos

    Developed train management systems as a C programmer on DEC and VAX platforms for large clients such as CSX and Union Pacific.