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.