Data Warehouse Modeler - Bi Architect Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Expert data modeler with emphasis on innovative Inmon - Kimball data warehouse and business intelligence designs
- Fluid critical thinking skills, an ability to reduce complex problems into simple solutions
- Authoring designs to substantially reduce development and operational costs
- Master-level integrations of existing systems into new ones
PROFESSIONAL EXPERIENCE
Confidential
Data Warehouse Modeler - BI Architect
Responsibilities:
- SQL-Server 2017
- Modeled and implemented a normalized Inmon OLTP data warehouse to support discrete Operational audits and reporting
- Modeled and implemented a denormalized Kimball Star data warehouse to support Historical (period over period) reporting
- ER-Studio (case tool for data modeling)
- Multi-Dim SSAS cube (MDX), SSRS, Power-BI
- MS Server Data Tools for Visual Studio 2017 (SSDT)
Confidential
Data Operations/Warehouse Modeler - BI Developer (FTE)
Responsibilities:
- SQL-Server 2014
- SSIS (Integration Services)
- Multi-Dim SSAS cube (MDX), SSRS, Power-BI, Excel Pivot
- ER-Studio (case tool for data modeling)
- Idera SQL-Compare for schema promotion
- MS Server Data Tools for Visual Studio 2015-17 (SSDT)
