Business Intelligence Developer Resume

EXPERIENCE:

Confidential

Business Intelligence Developer

Responsibilities:

Full - stack developer of two Enterprise Data Warehouses (Kimball data modeling) using Microsoft Business Intelligence tools (SQL Server 2016)
Principal for two Multidimensional OLAP cubes (SSAS): Sales/Marketing & Maestro (Task Mgmt.) business applications
Lead major overhaul of several production cubes to implement role-based “row-level security” (MDX)
PowerBI (P1 Premium) team lead - administrative support of gateway, web service & internal technical contact
Integrated Azure DevOps within team environment (Sprint workflows, & Git/VSTS for source control)
Internal Data Science and analytics champion - principal on several internal quality classification projects (DataRobot)
Additional Software: R, PowerShell, C#

Confidential

Business Intelligence Analyst

Responsibilities:

Developed and managed SQL Server 2014 databases supporting analytics, reporting, data warehousing, and participant tracking supporting a national CDC program
Tailored dynamic, source-specific ETL solutions within multiple tools - SSIS, PowerShell, Python - supporting data model sources from MySQL (ODBC), FTP, REST API (JSON), SPSS, Excel
Developed multiple analytical visualization dashboards and algorithms, tracking multiple KPIs across cohorts and programs, used by leadership
Initially a subcontractor - primary duty to develop dashboards/reports and support/transition legacy MS Access Databases and VBA functions to native T-SQL functions and stored procedures

Confidential

SQL Programmer/Business Analyst

Responsibilities:

Primary role was to design, execute, update and maintain ETL and campaign processing stored procedures for two major national clients
Developed & automated business intelligence reporting/delivery
Supported a data-driven retention for several national clients with analytical reporting, data cleansing & standardization, and customer service

Software: SQL Server 2008, SSRS, Alteryx (GIS), Excel/VBA

Confidential

Consultant

Responsibilities:

Tasked by Confidential Medicine/ Confidential to analyze and benchmark ICD-9/CPT medical coding patterns in the M2/MDR by specialty and facility
Collaborated with Sr. Consultants on audit- readiness KPI development
Software: SAS, Cognos, MS Access and Excel/VBA

Confidential

Survey Analyst

Responsibilities:

As lead Survey Analyst, oversaw data quality for several EIA surveys (electrical, coal, natural gas)
Developed new, statistically-robust and updated existing data quality/cleaning tools
Coordinated both monthly and annual data quality reviews with internal and external parties
Software: SAS, MS Access/Oracle