SEARCH

Senior Client Data Manager, Research and Data Analysis Resume Example

Resume Score: 85%

Love this resume?Build Your Own Now
SENIOR CLIENT DATA MANAGER, RESEARCH AND DATA ANALYSIS
Summary

Talented Senior Client Data Manager and strategic planner possessing a solid understanding of data-driven decisions. Excels at building dynamic teams that achieve continual process improvement.

Highlights
  • Data collection and analysis
  • Inter-governmental and legislative relations
  • Exceptional organizational skills
  • Analytical thinker

  • Expert in integrated client data systems
  • Project management
  • Creative problem solver
  • Information technology policy development
Accomplishments
  • Lead development of the prototype for the agency's emergency response system.
  • Initiated and lead collaborative problem solving team that developed progressively effective methods and overcame barriers to implementing best security practices for IT developers.

Experience
01/1994 - Current
Department of Social and Health Services － Olympia, WASenior Client Data Manager, Research and Data Analysis
  • 1994-present More than 15 years' experience in the client data and system application infrastructure required for data-driven analysis and management reporting for the Department of Social and Health Services.
  • Senior Client Data Manager (ITS /AS 6), May 1, 2011 through present.
  • Presented on agenda items at [Number] meetings per [Time period].Negotiated contractual agreements for the city, including [Agreement description].Led the effort to expand and renovate the [System name] system.
  • Oversaw a [Number]-member city department serving a population of [Number].Served on the [Number]-member [City name] executive management team.Devised short and long-range action plans to address a wide variety of municipal needs.Served on the [Number]-member [City name] executive management team.Led the effort to expand and renovate the [System name] system.Spearheaded the [Number]-acre [Project name] expansion project.
  • Responsible for the Department-wide client specific service tracking database systems and related applications. As a subject matter specialist contribute to technological advancements that enhance RDA's Integrated Client Data infrastructure. Responsible for strategic planning and policy development around client tracking systems, and directs and manages an expert IT staff in all aspects of the system and application. Responsible to share client tracking solutions through discussions and presentations with jurisdictions, other agencies, and at the national level. RDA's Integrated Client Data systems and applications are comprised of multi-platform Oracle and SQL Server databases and applications, SAS applications and analytic files, and web applications. Responsible to ensure that systems and applications continue to evolve, taking advantage of new technologies while meeting the changing needs of the Department. The primary database among the DSHS-wide client tracking systems is the multi-platform DSHS Client Services Database (CSDB). It is the central repository for current and historical integrated individual client, service, cost, and location information from more than 20 case management and payment systems in DSHS. In addition to having the responsibility for ensuring the timely and accurate inclusion of the Department's new data systems, this position is also responsible for the acquisition of data from other state agencies, including the Department of Health, the Department of Corrections, and the Health Care Authority. Responsible for the CSDB and related applications, designed for statewide and cross Department use, also have national impact. This position provides consultation at the national level, with other states, other state agencies, and across the Department related to client tracking systems. Within RDA, the CSDB is essential for the work done by the Program Research and Evaluation Section (PRES) within RDA. PRES is responsible for designing, initiating, and conducting complex research and evaluation of programs and policies throughout the Department. This position is designated within the DSHS Planning Performance and Accountability Administration (PPA) as the highest level authority for the technical and organizational leadership of agency-wide client specific service tracking database systems and related applications. This position provides strategic planning and policy development around client tracking systems, and directs and manages an expert IT staff in all aspects of the system and application design, development, implementation and maintenance cycle. This position maintains a current understanding of all DSHS case management and payment data systems, client services, and business practices. This position, also, provides consultative services across DSHS and within the state related to client tracking systems. Under this position's leadership and primary among the DSHS-wide client tracking systems is the multi-platform DSHS Client Services Database (CSDB) information system. CSDB is the central repository for current and historical integrated individual client, service, cost, and location information from more than 20 case management and payment systems in DSHS and from other agencies, such as, the Department of Health, the Office of Financial Management (OFM) and the Department of Community, Trade and Economic Development (CTED). The CSDB and related applications have statewide impact. The information from these applications inform DSHS executive, budget, program, regional, and local staff, the Legislature, local providers, OFM, CTED, JLARC, the Employment Securities Department, the Washington State Institute for Public Policy and other state agencies, and the general public. The information is used to facilitate executive management of DSHS, policy development, cross program operations, and performance measurements. Direct and manage an expert IT staff in all aspects of the system and application requirements definitions, design, development, implementation and maintenance cycle for complex cross-agency client tracking database systems. These systems and applications are comprised of multi-platform Oracle and SQL Server databases and applications, SAS applications and analysis files, and web applications. These systems and applications continue to evolve with new technology and with the changing needs of DSHS. Serves as the PPA spokesperson for the cross agency client tracking systems and makes commitments on behalf of PPA. Provide strategic planning and policy development around cross agency client tracking systems. Develops business plans, decision packages, and acquisition strategy for client tracking systems and applications. Maintain a current understanding of all DSHS case management and payment data systems, client services, and business practices. Lead collaboration with executive management from each DSHS program to integrate client service records from all client data and fiscal systems in the Department. (DSHS) is required to report Title 19 expenditures to the Federal Medicaid Statistical Information System (MSIS). This position in Research and Data Analysis (RDA) performs at the expert level to develop, document, implement, and maintain a complex production MS SQL Server / Windows platform database system (RDA MSIS) which is used to report to MSIS the agency-wide Title 19 expenditures which are not paid through the Medical Management Information System (MMIS). The RDA MSIS database is essential for the department's accountability to the federal government. If MSIS reports are not delivered on time, DSHS can be fined by the federal government. This position also supervises a unit that participates in the development, implementation, and maintenance of the complex Oracle / UNIX platform Client Services Data Base (CSDB) and related high impact applications that are central to RDA's tracking of data for services provided by all programareas within the Department of Social and Health Services (DSHS). These applications support ongoing data analysis requirements of DSHS program managers for budgeting, planning, evaluation, and research purposes, and are essential for the department's accountability to both the state Legislature and Federal government. Supervises, assigns and directs staff in a unit that performs business analysis and data analysis, automates processes using database and web technology, creates agency-wide reports, defines services offered by DSHS, determines the costs of services, validates the accuracy of data, maintains the MSIS and CSDB data dictionary, maintains technical documentation and interacts with RDA and DSHS program area staff to ensure data completeness and quality. Sets standards for the work performed by the unit including documentation, reporting and validation criteria. Applies project management techniques to ensure the timely acquisition of data and production of reports. Timely data are required by the executive level management, the Legislature, the department's budget process, program areas, and the Federal government and research projects. Functions as the recognized expert in assessing the cost of DSHS services at the individual level. Possesses a comprehensive knowledge of services offered by DSHS. Client Services Database is an Oracle relational database on a Sun server that combines client records from 20 DSHS client and fiscal systems into client-level data utilized by agency management, legislature, researchers, and the public. For fiscal year 2001, CSDB included service records for 1,332,508clients and $5,546,892direct service expenditures. Member of the development team and lead for development of the cost allocation module that apportioned $1,033,696,219 to individual client service records. Resolved complex problems in consultation with the system architect, programmers, and senior researchers on the CSDB team and in the nine DSHS program areas. Set up and independently lead requirement-gathering sessions with budget staff, program managers, and information technology staff from the nine DSHS program areas to establish content, meaning, and definition of data elements from 20 DSHS client and financial data systems, including the following mainframe systems: Social Service Payment System, MMIS, and the Financial Reporting System (FRS). Develop criteria for programmers developing Oracle tables and forms and for SAS programmers developing the cost allocation processes and output reports. CORE is a SAS data system that combines aggregated data from 60 systems for local agencies doing community-level substance abuse prevention. Negotiated the acquisition of data from 60 systems operated by various state and local agencies including: Department of Corrections, Office of the Courts, Office of the Superintendent of Public Instruction, and Department of Health Vital Statistics. Negotiated and monitored inter-agency datashare agreements. Designed processes and established criteria for programmer to automate verification of data quality. Developed report templates for providing charts and graphs with data by local communities. Designed and implemented ACCESS data and metadata dictionaries that controlled the CORE SAS processes. Developed query tools linking SAS outputs with ACCESS metadata. combined DSHS client and fiscal data for individual clients producing the department's first unduplicated client counts and direct costs at the individual level. For fiscal year 1994, NADB included $3,884,266,000 (approximately 82% of DSHS expenditures) and records for 1,071,175 individual clients (estimated to be about 90% of those served). Negotiated the acquisition of data from 16 DSHS client and fiscal data systems and negotiated intra-agency datashare agreements. Researched and documented data anomalies and wrote descriptive documentation of agency services and database processes. Collaborated with programmers and system designer to resolve complex problems. Maintained the NADB SAS data dictionary. Lead for the HER project which provided client service information for health research. Developed user interface models, wrote help documents, and alpha tested the user interface for Trends and Patterns Database. Planned, developed instructional materials, and conducted training for professional research and programming staff.
01/1990 - 01/1993
Pollution Prevention Guidance, Washington State Department of Trade and Economic Development － Olympia, WATechnical Writer
  • Growth Management Act Guidance, Washington State Growth Management Act, Trade and Economic Development
  • Pollution Prevention Guidance, Washington State Department of Ecology
  • South Sound Places: Guide to Thurston County, Four Seasons Press
Education
2008
University of Washington － Tacoma, Washington, USMasters: Social WorkUniversity of Washington, Tacoma, Washington Masters, Social Work 2008
1987
The Evergreen State College － Olympia, Washington, USBachelor of Arts: Business and Public PolicyThe Evergreen State College, Olympia, Washington Bachelor of Arts, Business and Public Policy 1987
Certifications
RDA
Professional Affiliations
development team and lead for development of the cost allocation module that apportioned $1,033,696,219 to individual client service records. Resolved complex problems in consultation with the system architect, programmers, and senior researchers on the CSDB team and in the nine DSHS program areas
Presentations
Responsible for the Department-wide client specific service tracking database systems and related applications. As a subject matter specialist contribute to technological advancements that enhance RDA's Integrated Client Data infrastructure. Responsible for strategic planning and policy development around client tracking systems, and directs and manages an expert IT staff in all aspects of the system and application. Responsible to share client tracking solutions through discussions and presentations with jurisdictions, other agencies, and at the national level
Skills
Database, Oracle, SAS, Serial Attached Scsi, Its, Ms SQL Server, SQL, SQL Server, Case Management, Database Systems, Databases, Policy Development, Strategic Planning, Solutions, Budget, Economic Development, Documentation, Agency Management, Financial Reporting, Mainframe, Relational Database, Sun, Clients, Needs Assessment, Training, User Interface, Client Services, Maintenance, Technical Writer, Public Policy, Application Design, Business Plans, Financial Management, Operations, Securities, Access, Data Quality, Metadata, Statistics, Budgeting, Business Analysis, Data Analysis, Executive Level, Federal Government, Marketing Analysis, Medicaid, Medical Management, Pricing, Project Management, Technical Documentation, Unix, Business Management, Program Management, SQL Server 2008
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Department of Social and Health Services
  • Pollution Prevention Guidance, Washington State Department of Trade and Economic Development

School Attended

  • University of Washington
  • The Evergreen State College

Job Titles Held:

  • Senior Client Data Manager, Research and Data Analysis
  • Technical Writer

Degrees

  • Masters : Social Work
    Bachelor of Arts : Business and Public Policy

Similar Resumes

View All
Research-and-Data-Analysis-Manager-resume-sample

Research and Data Analysis Manager

Salud Family Health Centers

Denver, Colorado