Bi Developer Solutions Architect

Daniel Sansie

Epic BI Developer

PROFESSIONAL SUMMARY

Over 5+ years of IT industry experience in using Microsoft SQL Server 2005/2008/2008R2/2012/2014for data design, Data migration, Business Intelligence & DBA.

Domain expertise in Financial, Sales and Healthcare

Strong analytical and problem-solving skills along with inter-personnel communication skills as well as ability to acquaint to fast changing environments.

Database Management & SQL – T-SQL, MySQL, PostgreSQL, RDS, SSRS, SSAS, SSIS

CERTIFICATION

•Cogito

•Caboodle Data Model

•Clarity Data Model

•Clinical Data Model

•Cogito Tools Administration

•Cogito SQL Badge

•SlicerDicer Custom Build Badge

•Tableau Desktop Specialist

•AWS Solutions Architect Associate

•AWS Solutions Architect Professional

PROFESSIONAL EXPERIENCE

Darthmouth Health August 2024 to Present

Epic BI Developer

•Build Radar dashboards for report consumers

•Builds Reporting Workbench reports, templates, and extracts for the application

•Develop reports and dashboards to support clinical and revenue initiatives long-term

•Ensures that consumers are satisfied with reports and distribution tools

•Performs post-live volume testing and evaluates overall consumer happiness with reports

•Ensures that all application dashboards and reports are tested

FastMed Urgent Care March 2020 to August 2024

Epic BI Developer

•Build Radar dashboards for report consumers

•Builds Reporting Workbench reports, templates, and extracts for the application

•Develop reports and dashboards to support clinical and revenue initiatives long-term

•Ensures that consumers are satisfied with reports and distribution tools

•Performs post-live volume testing and evaluates overall consumer happiness with reports

•Ensure that all application dashboards and reports are tested

I-Ping Solution LLC March 2017 to March 2020

Tableau Developer

•Data blending implemented on databases and generated interactive dashboards with Tableau 2018

•Create ad hoc reports to users in Tableau by connecting various data sources.

•Handle Tableau admin activities granting access, managing extracts and Installations

•Manage dashboard permissions within a complex matrixed organizational structure

•Maintenance and scheduling of Tableau Data Extracts using Tableau server and the Tableau Command

•Tableau administrative duties: adding users, groups, data connections, scheduling tasks, embedding views, etc.

•Developing complex calculated fields for the business logic, field actions, sets, and parameters to include filtering capabilities for the dashboards, and to provide drill down features for the detailed reports

•Generate Dashboards with Quick filters, Parameters and sets to handle views more efficiently with Tableau 2023.1

•Publish Workbooks by creating user filters so that only appropriate teams can view it.

•Embedded Tableau views into SharePoint and analyzed the source data and handle efficiently by modifying the data types.

•Use excel sheet, flat files, CSV files to generate Tableau ad hoc reports.

•Generated Tableau dashboards for sales with forecast and reference lines with Tableau 2023.1

•Generated Tableau dashboards with combination charts for clear understanding.

Actionet March 2016 to February 2017

Business Intelligence Developer

•Worked closely with data engineers and administrators in the development of OLAP (online Analytical processing) system that will be used to make critical business decisions

•User technical help and support

•User help understanding and meeting business deliverables

•User help for data accuracy and consistency

•Document requirements

•Create data results with tools such as SharePoint, Reporting Services (SSRS), Excel, PowerPoint, and Power view

•Manage data warehouse content and user rights within the SharePoint environment

•Document/Maintain process and procedures related to Data warehouse activities

•Document/Maintain process and procedures for other supported 3rd party software (WASP, RedBeam,MP2)

•Support contact for 3rd party supported software (WASP, RedBeam, MP2)

•Experience in Online Analysis Processing (OLAP).

•Built data models using PowerPivot and deployed models to SharePoint Server.

•Developed interactive dashboards using Excel BI tools

•Experience in developing various types of reports like Drill Down, Drill Through, Matrix, and Parameterized using SQL Server Reporting Services (SSRS).

•Utilized MDX expressions to query OLAP Cube

•Created Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.

•Created several Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas driven, summarized and conditional formatting) using SSRS.

•Designed and created Report templates, bar graphs and pie charts based on the financial data.

•Involved in development and modification of existing Financial Reports and Marketing reports which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.

•Maintained and provided support to users for the deployed reports.

•Created Development and Production support documents.

•Developed Query for generating drill down reports in SSRS.

EDUCATION

MS in Finance & Business Management

oUniversity of Bedfordshire

Contact this candidate