Data Quality Continuous Improvement

LAURA D. LOCH

913-***-**** ad75ny@r.postjobfree.com linkedin.com/in/LLoch/

Kansas City, KS/MO Metro Area (Kansas City, Overland Park & all surrounding metro) SENIOR DATA STEWARD

Data Governance Data & Business Analysis Operations Process Management Continuous Improvement

Proven track record in optimizing business operations through evaluation of data architecture, data quality, governance and metric compliance, as well as specializing in writing requirements, streamlining workflow diagrams to then query for data-driven insight shared through data storytelling with data visualizations in dashboards and reports. Driving continuous quality improvement methodologies to result in positive Profit and Loss Statement impact. Able to manage multiple projects, track resources, keep stakeholders in communication for meeting project timelines and budgets. Experience in training, mentoring, and managing multiple analysts: business, data, performance excellence analysts to ensure data quality within organizations to aid leadership strategic decision-making. SKILLS

Data Governance & Analysis:

● Able to mine for data, clean, analyze and present findings.

● Proficient in Business Intelligence, and Report creation with Data Visualization and Storytelling.

● Data mapping.

● Support data import/API implementation.

● Data dictionary creation for data quality and integrity.

● Design and create dashboards.

● Utilize statistics for insight.

● Able to analyze large datasets.

Business Analysis:

● Developed department policies and collaborated on interdepartmental policies to streamline operations in a minimum of 6 roles.

● Automated Processes.

Systems Analysis/Product Owner:

● Develop user stories, implement and test solutions, including UAT testing.

● Thrive in agile environments with sprints, collaboration and continuous improvement for efficiencies along projects.

● Proficient use of multiple software including: SQL, R, EXAGO Business Intelligence, Tableau, Power BI, Qlik, Microsoft Project, Microsoft Office Suite with Advanced Excel and Office 365 with TEAMS, SharePoint, Google Tools/GSuite, Smartsheet, Adobe Pro, Canva, ChatGPT, ZOOM, Skype for Business, Survey Monkey, Viseo, LucidChart, Miro, SMART PeopleSoft Financial, SAP Concur, Kofax.

Process Improvement/CQI:

● Conducted workflow analysis and research to identify areas for process improvement.

● Served as a champion of Agile, Lean, and Root Cause Analysis methods to drive efficiency and effectiveness.

● Developed and managed revenue tracking schedule, inventory management tracking, billing software in Smartsheet, and supply chain SOPs.

LAURA LOCH 913-***-**** Page 2

Project Management:

● Experience in Agile and Waterfall project management.

● Utilized Gantt charts, kanban, and RACI matrix for project management and tracking.

● Led software upgrade projects as subject matter expert (SME) and oversaw ad hoc data analysis and reporting.

Organizational Leadership:

● Presented and facilitated meetings to translate information for various audiences, including C-suite, management, individual staff, and technical teams.

● Implemented change management strategies with 2 software vendors in 2 different organizations. I also managed projects there to facilitate smooth transitions and adaptation to new processes.

● Demonstrated open-mindedness, motivated teams, and fostered outside-the-box thinking as a natural leader.

● Provided training, consultation and mentorship to individual contributors, operations management, and customers, including successfully managing an intern.

● Revealed interdepartmental communication issues and broke down silos to foster collaboration and a growth mindset.

● Promoted twice to head new departments where I hired, trained, established process’s and procedures for both successfully. Both of my teams had over 95% meets or exceeds satisfactory job performance evaluations. Provided support to Operations, Project management, Billing, Accounts Payable, Supply Chain, Contract management, Business Development. EXPERIENCE

Catalent - Kansas City, MO 2021 - 2024

Business Planning & Process Improvement Manager, Operations Group Leader, (promoted Senior Business Analyst 2022)

• Created, hired a new Planning department 2022; Implementation and Training of Business processes for my department of: Supply chain, Office assistant and Business analysts.

• Created and Led my team to create and maintain KPI Dashboards using Excel Pivot, Power Query, Power BI, Qlik and Smartsheet.

• Created monthly/quarterly plan to track revenue milestones and forecast models; consistent accuracy within 9% of projections.

• Project Manager for implementation, Trainer, and Issue Mgmt for Business software solution, requirements elicitation, analysis and management, current state vs. future state process mapping, need prioritization. Then System Administrator for implemented software and led my team for customization and module builds.

• Contract Pricing gap analysis.

• Process creation to increase revenue through multiple additional streams, to increase quarterly revenue by thousands.

• Managed requests, approval and purchase of all department supplies resulting in decrease of quarterly expenses by thousands.

• Using SDLC and Agile Project management for collaboration with software vendor design, implementation, training and maintenance as Owner/System Administrator (Smartsheet with Dashboards, open API data import, Control Center data template automation).

• Microsoft 365 and AI champion.

• Created routine metrics to directors and managers for team performance improvement tracking. LAURA LOCH 913-***-**** Page 3

• Use continuous improvement strategies including implementing new business processes.

• Support and take part in CI activities regarding project management, forecast planning and expenses.

• Manage Planning Analysts, Executive Administrative Assistant and Buyer for the division with successful onboarding, department creation and all meets or exceeds expectations on first yearly reviews.

Missouri Alliance for Children and Families - Jefferson City, MO 2019 - 2020 Quality Assurance Specialist & Business Analyst

• Successful in varying states of remote, hybrid, flexible structure.

• Development of new Dashboards statewide for Foster Care Case Management Contracts and Specialized Case Management Contract from Missouri Children’s Division.

• Development of exit and permanency tracking workflow used statewide.

• Monthly reporting of KPI and Continuous Quality Improvement Initiatives.

• Execute project Data analysis, Research, and Report creation as needed.

• Lead CQI (Continuous Quality Improvement) Projects, track progress and completion.

• Psychotropic Medication Prescription monitoring statewide, report development with monthly tracking.

• Audit for compliance of Psychotropic Medication documentation from Center of Excellence and Children’s Division Guidelines.

• Council on Accreditation (COA) team.

Cornerstones of Care - Kansas City, MO 2018-2019

Manager Of Organizational Excellence and Business Process Improvement

• Managed, coached, mentored and trained Performance Excellence (Quality Assurance & Quality Improvement) Department staff & Health Information Management Department staff.

• HIPAA Compliance - Agency Contact.

• Council on Accreditation (COA) - Agency Lead.

• Sanctuary Accredited Agency - Accreditation Committee member.

• Project management of agency improvement plans with waterfall and agile concepts.

• Data governance development and implementation.

• Assist Corporate Business Strategy Manager and Program leaders with KPI development.

• Develop and coordinate the development of Reports through the EHR (Electronic Health Record).

• Led 4 program module implementations within a new EHR service provider.

• Created, facilitated, and managed UAT testing results.

• Led multiple trainings to program operations staff of new EHR workflows.

• Utilize tools for Process evaluation, root cause analysis, fishbone, gap analysis, PDSA (Plan, Do, See, Act) often and others.

• Develop and implement Performance Quality Improvement Initiatives for the organization along

• Data analysis and data extraction utilizing SQL, Excel, Crystal reports, Tableau.

• Lead agency survey creation, collection, reporting. Caseworthy - Salt Lake City, UT 2016 - 2018

Product Management - Technical Project Manager

• Product Management of core product:

• Gather requirements, project plan creation, routine updates to stakeholders, schedule meetings, system analyst tasks of form building/configuration as needed. Postmortem/Lessons Learned.

LAURA LOCH 913-***-**** Page 4

• Manage large-scale projects to the baseline application.

• Coordinate with external partners, contract staff and internal QA and Systems Analysts to manage version releases.

• Manage ongoing HMIS Data Standard and Report compliance changes.

• Organizational Development/Performance Improvement

• Requirements, design and configuration of project management functionality within application

• Process evaluation followed by initiation, recommendation or writing of Standard Operating Procedures (SOP) regarding interdepartmental processes related to software development life cycle as needed.

• Write internal project management SOP’s.

• Agile team lead and project manager:

• Operations’ department managers discussed and developed process and procedures for agile strategy to include SCRUM, sprint process, daily standups, PMO and kanban. Lead SOP development.

• Risk management – provide details to CEO, department manager and In-House of Counsel

• Product Management:

• Make recommendations on implementation and configuration to baseline product to CEO/Product manager regarding HMIS (Homeless Management Information System) through HUD issued compliance standards.

• SME for customer and internal HMIS issues to support Customer Success/Support departments.

• Company representative externally to existing and potential customers regarding HMIS.

• HMIS Customer Relations – User Group, Maintenance of compliance resource Dropbox folder

• Conduct research and make product recommendations.

• Senior Project Manager (Customer Implementation Project management, Training, Systems Analyst configuration):

• Training/mentoring new project managers.

• Manage customer implementation contracts - create discovery, requirements, project plans.

• System analyst tasks of baseline setup and custom configuration.

• System Administrator training.

Cornerstones of Care - Kansas City, MO 2014 - 2016 Performance Excellence Specialist

• Reporting: Requirements gathering, wireframe or report spec creation, data analysis, monthly and ad hoc reporting, new report development using ODBC connection, Crystal reporting, PowerBI, Excel.

• Specialist for the foster care contract with reconciliation and yearly reporting, coordination with the State of MO Children’s Division

• Grant and RFP assistance.

• Gap analysis of accrediting bodies: COA, Joint Commission and CARF, for C-suite for development in strategic plan.

• CQI, PI activities.

• Coordinate with Netsmart for software implementation: advised system requirements and work with Product Manager to develop baseline foster care module.

• Co-Presenter at Netsmart Conference with Product Manager, 2016.

• Member of EHR (Electronic Health Record) training team. Netsmart CareManager for Nurse Case Manager coordination of care contract - reporting requirements, report configuration. LAURA LOCH 913-***-**** Page 5

EDUCATION

The Augment MBA

Masters in Business Administration certification 2023 - 2024 Western Governors University

Masters in Data Analytics courses 2018 - 2021

• Database Creation & Administration, Data Mining, Data Visualization, Forecasting & Predictive Modeling, Database Principles, Data Analytics.

• Tools: SQL, Power BI, R, Tableau.

Various 2016 - 2020

• Udacity online - Intro to Computer Science, Intro to Programming, SQL, Python.

• LinkedIn Learning - Project Management

• Agile Transformations, Omaha NE - Agile project management: Scrum and Kanban methodologies.

Northwest Missouri State University

Business courses focused on Finance, Economics, and International Business Management Northwest Missouri State University

Bachelor of Science of Zoology - Human emphasis (pre-med) & General Business

• TriBeta Honorary Organization

• Business Coursework: Business Finance, Statistics, Managerial Communication, Management Process & Behavior, Accounting I & II, Business Law, Principles of Marketing,

• Pre-Med Coursework: Sociology, Psychology, Genetics, Anatomy & Physiology, Comparative Vertebrate Anatomy, Vertebrate Histology, Ecology, Physics, Zoology, Biology, Chemistry I, II & Organic.

CERTIFICATIONS:

• Six Sigma White Belt certification, Catalent - 2023.

• Progress towards Yellow Belt certification as Kaizen contributor x 2, Catalent, October - December 2023.

• HIPAA Awareness for Business Associates certificate 2005-2011, 2017.

• Human centered design certificate 2013 Cornerstones of Care.

• Office & Medical Office Systems certificates 2003 Northwest Missouri State University.

• The Sanctuary Model (Sandra Bloom’s emotional intelligence, growth & change, etc.) certificate: 2014, 2015, 2016, 2018, 2019.

ACCOMPLISHMENTS & PHILANTHROPY:

• National Conference Presenter, Foster Care module codesigner Netsmart. Nashville, TN 2016.

• Scholarship Chair - PEO (Philanthropic Educational Organization), 2014 – 2016.

• Social Media Chair - Johnson County Christmas Bureau – Chair and Development Committee member – 2012 – 2014.

LAURA LOCH 913-***-**** Page 6

• Silver AMBIT marketing award winner (JCCB Holiday of Hope Fundraising Campaign) – 2013 as: Social Media marketing, Facebook administrator, development and strategic planning, branding, community business relationship building, volunteer recruiting, event coordination and planning. Corporate Collaboration AI team member, Catalent, 2023 - 2024.

• Committee Chair on Hackathon Committee(1 of 5 chairs across US Corporate), Catalent, 2023.

• Member - Corporate Data Science Team Catalent, 2022 - 2024.

• ERG Leadership Committee lead of Environmental sustainability. Project manager, marketing design, engineering implementation plan for ‘green spot’ initiative. - July 2022 - Feb 2024.

• Member CQI Employee Council – St. Francis Hospital, 2011.

• Member Relay for Life Committee – St. Francis Hospital, 2011.

• TriBeta Honorary Organization Inductee – Northwest Missouri State University, 2002 – 2003.

• National Honor Society Inductee – 1999.

Contact this candidate