Arthur Ngugi

Senior Data Modeler @Duke University Hospital

Durham, NC, US

Worked on Agile methodology and successfully delivered on time all sprint deliverables. Translated Business Requirements into Data Design Requirements used for driving innovative data designs that meet business objectives. Interacted with business users to analyze business processes and gather and collect use case requirements Worked closely with data governance, SMEs and vendors to define data requirements. Worked on preparing scope documents and allotted tasks to data modeling team. Worked with data investigation, discovery and mapping tools to scan every single data record from many sources. Utilized IBM Infosphere Information Analyzer to perform data profiling Identification of Risks in schedule and marking them in the Use Cases. Used data vault modeling method which was adaptable to the needs of this project. Translated business requirements into working logical and physical data models for Staging, Operational Data Store and Data marts applications. Utilized IBM Data Architect for creating CDM, LDM & PDM Utilized IBM Fast track tool for creating source to target mapping inclusive of all transformation & data quality rules. Extensively used Star Schema Methodologies in building and designing Dimensional Models. Forward Engineering the Physical Model to generate the DDL scripts to implement on Netezza database. Conducted performance tuning of the database that included creating optimal distribution & organization keys for Netezza database