Past Completed Major Projects:
For a mid-sized pet food manufacturing company - 2011-2013
- BI: designed and implemented unified data warehouse, conformed dimensions, the associated data marts and required ETL. Created supporting multi-dimensional (cube) reporting environments for marketing analysis, POS analysis, sales operations and financial analytics.
(SQL Server 2012, 2008, 2008R2, SSAS, MDX, SSIS, SSRS, Tableau, Qlikview)
- BI tool usage evaluation: Microstrategy, Tableau, devExpress, Qlikview, Hadoop, Cassandra.
For Thomson-Reuters - a global leader in business and financial information, 2010-2011
- BI: designed and implemented the customer and account mapping and assignment logic for the ĎTo Beí analytics platform for the business development organization. (SQL Server 2008, SSIS)
For a mid-sized global supply chain and recycling management company, 2009-2010
- Web based platform for BI and life-cycle management: designed and implemented database architecture, data modeling (Erwin) development and ETL (SQL Server 2005/2008, SSIS, SAP).
For Yahoo! (one of the internetís largest destinations for content and video), 2008-2009
- designed and built BI & reporting system, providing visibility into user video activity, Web Trends daily activity and server utilization activity. (SSIS, SSAS, MDX, SSRS, ERwin).
- Evaluated usage of Yahooís Hadoop infrastructure for video activity analysis
- optimized the video platform databases supporting a three-fold increase...
Read More »