About Me
I am a senior information architect with more than 15 years of experience in business intelligence and advanced analytics with a focus on data quality and governance. At Microsoft I created a database application that grew to become the largest co...
Show MoreSkills
Data & Analytics
Others
Software Engineering
Development Tools
Programming Language
Web Development
Operating System
Portfolio Projects
Company
Built dimensional warehouse from scratch to replace Business Objects reports on SAP data
Role
Software Architect
Description
In this project I built a dimensional warehouse from scratch to replace a suite of Business Objects reports with SSRS reports. Source data was SAP. It involved extensive data quality work and ETL.
Show More Show LessCompany
Predictive analytics to support real-time UI adaptation
Role
Data Scientist
Description
Built analytical models to predict the ways users would configure a licensing tool based on their profile attributes so we could pre-configure the interrface and make it easier and faster for them to make adjustments. Used K-means algorithm to set defaults and EM algorithm to populate and sort alternative choices.
Show More Show LessTools
Visual Studio (Win)Company
Architectural analysis and performance tuning of production SSAS OLAP cube; Power BI dashboards
Role
Backend Developer
Description
In this project my role was to diagnose significant prerformance challenges with a large production OLAP cube that supported the daily analytical needs of the worldwide retail operation. Source data was on IBM Netezza. I created Power BI dashboards to support busness analysts and retail managment.
Show More Show LessSkills
Netezza SSAS Power BI Data ModelingTools
Visual Studio (Win)Company
Develop OLAP cubes and data warehouse
Description
With this customer I had multiple engagements: I developed OLAP cubes and analytical models to support finance and accounting; extended their data warehouse to support the OLAP cubes; I analyzed their entire reporting system to identify risks associated with a planned move to a new distribution center. Hard-coded references to the existing distrubution center were replaced with dynamic references in all ETL, Tableau workbooks, reports and code; I helped evaluate Snowflake for potential future migration.
Show More Show Less