PROFESSIONAL EXPERIENCE:

Confidential

Senior Tableau Analyst

Responsibilities:

• Worked wif business owners to interpret business objectives into quantifiable key performance measures. Teh design of teh Tableau dashboards entailed measuring and monitoring key indicators such as revenue and customer count (Tableau 10.5 Server & Desktop).
• Tableau dashboards were embedded into web pages (HTML, CSS, Javascript and Tableau Javascript API) enabling users to navigate content areas using an accordion menu.
• Maintained and monitored Tableau Server (10.5) to track server performance and create sites and business groups. Developed Tableau scripts creating file extracts, PDF and CSV files which are emailed to user groups (Tableau Data API, Tabcmd, TabJolt).
• Developed Tableau dashboards monitoring Tableau Server performance by accessing teh Tableau Server Postgres database and displaying server data metrics such as slowest dashboard to load and number of concurrent users by hour and day.
• Developed AWS - Redshift SQL scripts embedded to Tableau workbooks as data source (Common Table Expressions, Window Functions).

Confidential

Business Intelligence Analyst/Developer

Responsibilities:

• Designed and developed hospital web portal embedding Tableau dashboards (Tableau 9.1 server desktop) into web portal pages (html, css, javascript, Tableau API javascript) accessed by jquery accordion button menu selecting specific Tableau views dat trend and analyze key performance measures.
• 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 9.1 dashboard).
• Development of Urgent Care Center dashboard using OLAP cubes and Tableau dashboards analyzing teh triage process from check in time to discharge time contrasting Providers, Day of Week and other dimensions.
• Managed teh Tableau Server: monitored performance, assigned users to groups and upgraded Tableau server software.
• Developed a Perioperative web portal dashboards using Tableau Desktop/Server monitoring and tracking daily on sugerical first on time starts - donut charts - and schedule over runs - gnat charts.
• Developed ETL package (MS SSIS - VB.NET) running TSQL/DB2 stored procedures updating snowflake schemas: integration of multiple fact tables from various data sources and updated dimensions tables. Scheduled package using SQL Server Agent

Confidential

Senior Business Intelligence Analyst

Responsibilities:

• Produced operational, financial and clinical OLAP cubes and views measuring key performance indicators such as: tracking months and 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 (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).

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 ad hoc 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 WebFocus 4.36).

Confidential

Business Intelligence Architect/Developer and Consultant

Responsibilities:

• 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 tan formatted by a Python script dat inserts teh UDP data into a Postgres table.
• Constructed a Tableau web site (Tableau 9.1 Desktop, Tableau Online, 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.