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.