Leslie Cooley Email & Phone Number

Tacoma, Wa

Create, maintain, and produce databases and reports that support management decision-making, provider compensation, and achievement of business objectives.Combine data from Legacy and Epic systems to produce reports and extracts for Financial Close.Utilize tools including MS SQL Server Stored Procedures, SSIS, SSRS, MS Access Databases, MS Excel.Researches and analyzes data sources for new or better sources of information from production systems.Troubleshoot and resolve problems identified in legacy reports. Develop processes to mitigate future issues.Writes and maintains technical documentation related to the local data warehouse and reporting.Epic 2017 Certification on Clarity Data Model - Resolute Professional Billing and Resolute Hospital Billing

* Played an integral role in sharpening organization-wide compliance with Healthcare Effectiveness Data and Information Sharing (HEDIS) protocol for NCQA Accreditation and Medicare 5* Ranking.* Developed source-to-target mapping specifications for multiple source system extracts. * Worked closely with QA/ETL groups to move extracts through the SDLC, and helped develop an automated comparison tool to facilitate cycle-to-cycle comparisons. * Modified SQL to pull data for Medicare Procedure Frequency reporting mandated by CMS. * Served as liaison for successful HEDIS and Medicare audits. * Provided subject matter expertise on the analysis of iKA Systems as a data source for replacement of Claims and Membership systems.

* SME for sunsetting of LastWord application and Sybase implementation of Epic Practice Management Suite in the Enterprise Data Warehouse* Analyzed large amounts of data from LastWord and reports taken from Epic to synthesize compatible tables and determine structure/schema of the new system. (Conversion was completed on-time with zero data loss). * Developed data models in ErWin, content overviews, and source-to-target mappings for a claims system offset redesign project—coordinating activities with Scrum Master, ETL and QA. * Worked with Business Objects developers to build self-service query universes

* Completed extensive requirements gathering from business users via interviews with management teams and analysts. * Worked with data modelers to define and develop new design, and liaised with QA for validation.* Selected to deliver “Brown Bag” presentations on newly-developed data warehouse content. * Consulted with SAS programmers on Sybase data extraction, and with end users on implications of system upgrades and modifications to existing subject areas.

* Implemented a Data Warehouse Help Desk monitoring plan and escalation path.* Created a data warehouse development project template in MS Project to establish metrics and track effectiveness. * Standardized database architecture for LastWord upgrade dimensions, identifying opportunities for reduction of data duplication between SAS and the data warehouse. * Significantly improved user satisfaction with Data Warehouse data quality. * Conducted and coordinated monthly “Brown Bag” sessions for end users with a 66% approval rating.

* Developed and delivered training courses on data warehouse subject matter. * Developed custom training for a department-specific ODS data model.* Helped hire and on-board an additional training resource for Seattle* Consulted on an “Introduction to BI Queries” class. * Collaborated with Group Health Northwest staff on the Statewide Systems Integration project designed to integrate data from disparate sources. * Created Sybase stored procedures for type 2 dimensions and pushed through SDLC

* Conducted a “lessons learned” survey of Financial Management Training pilot. * Coordinated interviews, analyzed results, presented findings* Established a Training Administration Access database to capture performance data and course registration information. * Worked with IT Project Manager to develop custom GQL training for 50+ Pharmacy Managers and staff.

* Developed SAS reference manuals and courses for Membership, Claims, and Outpatient Encounters. * Developed instructor led course for analysts/programmers. * Worked with Cost Consultant to offer Cost Allocation Methodology class for CPE credits for approx. 30 students with internal and external instructors at an offsite training location.* Worked with IT project manager on the conversion of SAS programs from MVS to UNIX. * Learned the basics of the UNIX environment for SAS programming and created training materials for programmers. * Developed and taught instructor led training courses on the conversion to UNIX. * Worked with Data Warehouse Project Manager, IT staff, and users to define a prototype data dictionary tool to document DW subjects. * Attended vendor training on Patient Care Management and Financial Modeling Software. * Customized training materials and developed classes for Group Health and Virginia Mason staff.

* Provided Half-time support to the Planning Division for their data needs. * Prepared graphs and presentation materials as needed. * Created datasets for use in annual studies. * Provided Interpretation/analysis, and basic SAS reporting, * Provided administrative support for departmental budgeting process. * Prepared documentation for onboarding 10 new staff as department expanded.

Certificate, Solution Architecture

Bachelor Of Business Administration (B.B.A.), Accounting

Activities and Societies: Beta Alpha Psi