Banner Image

All Services

Engineering & Architecture

ETL, BI, Data Warehouse Consulting

Perform 3NF and Kimball Dimensional Modeling to produce Enterprise Multi-Tenant Data Warehouse Architecture

Produce Conceptual, Logical and Physical Database Models and produce DDL scripts to generate physical databases

Perform Legacy Source System Profiling, Learning and Documentation

Deliver Logical Data Mapping and Source to Target definition for every column in the Data Warehouse

Define roadmap for next Generation Data Warehouse Architecture leveraging Hadoop and new Business Analytics capabilities

Architect, develop and deploy MIS Data Warehouse and Administration framework to all DB servers and to standardize and automate compliance to architecture standards.?

Create Dashboards, KPIs, Scorecards, Analytic Grids, Charts, and integrate BI content, components and applications into a single service

Clinical Data Management, including large-scale data acquisition (ETL) for multi-site studies and FDA pre-clinical trials.

Deliver SharePoint solutions using PowerShell, SharePoint Designer and Visual Studio

Produce robust and highly performing ETL Framework to securely migrate production data from on premise hospitals to the MediServe hosted data warehouse.

Deliver commercial OLAP capability leveraging SQL Analysis Services BI Semantic Models (BISM).

Establish Reporting Platforms for various online and offline use-cases utilizing SSRS, PowerPivot, and PowerView.

Skills & Expertise

AnalysisAnalyticsArchitectArchitectureBusiness AnalyticsClinical Data ManagementConsultingData AcquisitionData ManagementData MappingData WarehouseData Warehouse ArchitectureDimensional ModelingEtlHadoopManagementMicrosoft SQL SsasModelingOlapPowerShellSharePointSharePoint DesignerSQLSsisSSRS

0 Reviews for This Service

This Freelancer has not received any feedback.