Decision Support Technical Specialist Resume

SUMMARY

Creating in - depth BI Solutions driving Business operational decisions and improving company financials.
Dynamic developer of software systems offering 10+ years of experience developing complex mission-critical BI systems, KPIs and reports. Proficient in designing Data Marts, BI Systems, Dashboards and ETL packages.
Skilled in all phases of the software development life cycle (SDLC); proficient in interpreting business requirements and creating quality BI solutions.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Decision Support Technical Specialist

Responsibilities:

Designed a Data Warehouse which was populated via ETL packages (SSIS). The DW was used to create a SSAS Cube which populated a Tableau Dashboard. The Cube contained Health metrics.
Created a hospital-centric Data Mart. This contained specific hospital KPIs. An ETL (SSIS) package was developed that retrieved hospital data from various sources and then populate the Data Mart.
Designed / Developed Tableau 2019.2 Visualizations reporting Health Metrics for Hospitals.
Tableau Administrator duties such as setting up extract schedules, monitoring Workbook automated extracts etc.
Coordinated the migration of SQL Server 2008 to 2012.
Coached team members on SQL queries and DB best practices.
Developed DB best practices for department such as DR plans and SQL coding
Coordinated with IM and IT regarding any technical concerns/issues.

Confidential

BI Consultant/Data Architect

Responsibilities:

Created a complete BI Solution from scratch, using the MS BI Stack (SSAS, SSIS, SSRS).
As the DBA, designed the logical and physical aspects of the SQL Server DB including several Data Marts. Leveraged extensive Data Modeling experience to design the data warehouse using the star schema architecture.
Designed and created multiple Cubes (Tabular and Multi-Dimensional), Packages and KPIs/Reports.
Developed multiple SSIS / ETL packages which extracted data from MySQL and third-party APIs which then populated the Data Mart.
Wrote complex T-SQL procedures and functions which complemented the SSIS packages.
Worked with Senior Business Executives to analyze business KPIs and design reports/KPIs.

Confidential

Consultant

Responsibilities:

Designed and created several BI Financial Cubes using Hyperion Essbase. Wrote Calc Scripts and Business Rules.
Developed T-SQL procedures and functions.
Supported the transition of the firm's Essbase systems to SAP BPC.
Designed and created a Hyperion Essbase cube to house Budget and Forecasting data, following the latest defined COA.
T-SQL procedures and functions were written to aid in the Cube's data load.
Designed and created Weekly/Quarterly Forecast Summary Reports for Business and ultimately the US Securities and Exchange Commission (SEC).