PROFESSIONAL EXPERIENCE

QARR Data Manager

Confidential

Responsibilities:

• Designed and developed OLAP hospital dashboard using Tableau 8.1 (server and desktop software) trending and analyzing costs and other key performance indicates for various surgical procedures: Lobectomy, Prostatectomy and partial Nephrectomy.
• Produced operational, financial and clinical OLAP cubes and views measuring key performance indicators such as: cost analysis in relation to number of surgeries and operating room durations (MS SQL Server Analysis Services 2008 R2, (MDX - parallel periods, rolling 13 month average and Tableau 8.1 dashboard).
• Development of Urgent Care Center dashboard using OLAP cubes and Tableau analyzing teh triage process from check in time to discharge time contrasting Providers, Day of Week and other dimensions.
• Developed ETL package (MS SSIS - VB.NET) running TSQL/DB2 stored procedures updating snow flake schemas: integration of multiple fact tables from various data sources and updated dimensions tables. Scheduled package using SQL Server Agent
• Produced operational, financial and clinical OLAP cubes and views measuring key performance indicators such as: tracking membership months and membership disenrollment administration initiatives and analysis (MS SQL Server Analysis Services 2008R2, (MDX, and Panorama).
• Produced labs and billing supplemental data extracts for HEDIS scoring software (Catalyst) for Quality Assurance Reporting Requirements (QARR) incentive measures (MS SQL Server 2005: SSIS).
• Documented workflows for QARR supplemental data extract processes and provider board certification (MS Word, MS Project).
• Project Manager co-leading a team to develop and build a business intelligence data warehouse integrating clinical and financial database systems. Teh team used teh warehouse to measure key performance indicators, design online analytical processing and data-mine (MS Project, MS SQL Server 2005/2008: SSAS SSIS).
• Produce clinical OLAP cubes and views measuring key performance indicators such as average length of stay, readmits, discharge time and patient volume for Six Sigma projects and nursing administration initiatives (MS SQL Server Analysis Services 2005/2008, MDX, and Panorama).
• Produce financial OLAP cubes and views measuring revenue opportunity, key performance indicators such FTEs, general ledger expenses, and profit/loss for General Accounting.
• Develop SAS programs for production and adhoc reports; transforming and segmenting data sources; and transfer data to teh SQL server database claims warehouse (SAS 9.2: MACRO, GRAPH, BASE, STAT, SQL).
• Designed and developed a real time air pollution monitoring database (Postgres SQL 9.0) coordinated wif teh Department of Health, New York City, measuring PM25 (Fine particles 2.5 micrometers in diameter) levels using nephelometer instruments stationed throughout teh New York City.
• Created an ETL process (stored procedures, job agents) reading an UDP messages sent by Raspberry Pi devices attached to nephelometer instruments and then formatted by a Python script that inserts teh UDP data into a Postgres table.
• Constructed a Tableau web site (Tableau 9.0 Desktop, Server, HTML, Tableau Javascript API, JQuery, CSS) tracking PM25 levels per second and at 15 minute intervals averages per station.

Confidential

Consultant

Responsibilities:

• Provide programming and analysis support for a National Institute of Health grant studying Primary Immunodeficiency Diseases in Minorities. (Primary investigator; C. Cunningham-Rundles, M.D., PH.D.)
• Analyzed diagnosis codes from teh billing registration system (Eagle) using SAS 9.1.3: MACRO, GRAPH, BASE, STAT, And SQL: Oracle 10g.

Confidential

Senior System Software Specialist

Responsibilities:

• Produced clinical operation reports for teh Quality Assurance department committees exploring treatment issues and developing measures for JCAHO requirements (SAS 8.2 ODS, MACRO, GRAPH, BASE, STAT, SQL, and Oracle 8.1).
• Produced profit/loss reports for inpatient and outpatient services investigating direct and indirect cost regarding operational and practice issues (TSI).
• Developed adhoc reports from Oracle database through PL/SQL querying teh relational database for analysis of various clinical performance measures (SAS 8.2, Oracle 8.1).
• Developed web pages reporting hospital key operational daily measures (MS Excel, MS Outlook, VBA, and WebFoucus 4.36).

Confidential

Database Analyst

Responsibilities:

• Managed several phase four studies coordinating programmers and clinical data coordinators to meet timelines (MS Project).
• Wrote edit check documents and programs for various phase four studies used to ensure teh integrity of teh clinic trial databases (SAS 6.11 MARCO, SQL, BASE, STAT).
• Supported 40 users on two local area networks (Novell 3.12) providing access to E-mail (Pegasus) and teh Internet (Netscape).
• Analyzed multiple databases investigating anxiety diagnosis wif psychosomatic symptoms: ANOVA and MANOVA (SAS 6.10).
• Analyzed juvenile offender database, developing a point scale measuring failure to appear in court (SAS 6.10).
• Supported 50 users on local area network (Novell 3.11, Excel, Word, and Visio).