Alan Williams

Health Information Manager / Security Officer @ The Alliance

About

I develop/maintain the Data Warehouses and Business Intelligence solutions that support reporting, ad hoc requests, tabular cubes, company security guidelines, HIPAA compliance auditing, Security Risk Assessment (SRA) review with external vendors and other SRA related projects. Report requests include: provider disruption, employee disruption, utilization trending, provider/medical group profiling, national quality measures, market share, financial, negotiation modeling, daily production monitoring analytics and a wide variety of ad hoc requests. Current development is done in SQL Server 2016 (SSIS, SSAS, SSRS, SSMS) and Excel. Specialties: Business Intelligence Solutions in SQL Server 2016 (SSIS, SSAS, SSRS, SSMS) Programming Code: T SQL / TSQL Excel (advance tools, links, formulas, modeling, etc.) Historical projects not currently in production: Desktop Power BI, SQL Server 2012, SQL Server 2005, SQL Server 2000, Visual Fox Pro 6.0, Visual Fox Pro 9.0 , MS Access, Crystal Report 9.0, VBScript, InterDev/ASP, HTML, etc.

Country

United States

City

Greater Madison Area

Industry

Hospital & Health Care

Skill

Data Warehousing, Databases, SSIS, SSRS, Health Insurance, T-SQL, Healthcare, HIPAA, Healthcare Management, Data Analysis, EHR, Microsoft SQL Server, Programming, Healthcare Information Technology, Project Management

Experience

Health Information Manager / Security Officer

The Alliance

2021-4 - Present · 5 yrs 6 mos

Madison, Wisconsin, United States

Health Information Manager / Security Coordinator

The Alliance

2019-10 - 2021-3 · 1 yr 6 mos

Madison, Wisconsin, United States

Health Information Manager

The Alliance

2004-4 - 2019-9 · 15 yrs 6 mos

1. Data Warehouse developer. 2. Business Intelligence Analyst: Responsible for creating reports, data cubes, and ad hoc query environments. 2. Database Admin/Developer: SQL Server 2016/2012/2005, VFP 6.0/9.0. 3. Programmer: TSQL, VFP, etc... 4. Over 23 years of programming health care analytic solutions. The Alliance is an employer-owned, not-for-profit cooperative of more than 240 members who self-fund their health plans. These employers provide coverage to more than 100,000 individuals in Wisconsin, Illinois and Iowa. The Alliance uses its purchasing power to negotiate with and provide access to an extensive network of doctors and hospitals that are paid to improve quality by performing better not doing more. The cooperative exists to help member employers manage their health care dollars while positively impacting employees’ health. The Alliance Mission: To move health care forward by controlling costs, improving quality and engaging individuals in their health.

Health Care Data Analyst / Programmer

The Alliance

1999-4 - 2004-3 · 5 yrs

Madison, Wisconsin, United States