Principal Consultant I Sql/Bi Practice
Irvine, Ca, Us
Architect of end to end Business Intelligence & Data Warehouse solutions.* Data Modeling (OLTP & OLAP leveraging Kimball methodologies)* Assisting in the design and implementation of Master Data and Information Governance Strategies, Policies, and Road maps.* Defining Information Architecture.* ETL Architecture and Development primarily leveraging SSIS* Analytic Solutions (OLAP Cubes and Tabular models) - SSAS* Reporting & Dashboard - SSRS, Excel/PowerPivot, PerformancePoint, Visifire & Silverlight ControlsLeading technical teams from identifying deficiencies through requirements gathering to implementation and training on the solution.Presenting and demonstrating capabilities of software products and potential solutions to prospective clients.Estimation of efforts and breakdown of tasks for solution implementations.Mentoring clients on design and implementation best practices. Developed internal reusable IP that handles dynamic/automated cube maintenance. Includes partitioning, aggregate, and processing schemes.The initial implementation supported a SSAS Cube consisting of roughly 1 TB of data with no required maintenance over a 1 year duration.Technologies used: SQL Server 2008 R2 RDBMSSSIS 2008 R2SSAS 2008 R2Leveraging Agile/Scrum methodology for implementations.Growing the local and national Business intelligence practice through pre-sales support, sponsoring events, public speaking, interviewing and networking potential candidates.Clients Industries include: Commercial Land Development/Real Estate, Supply Chain Distribution, Renewable Energy, Commercial/Residential Power, Hospitality, Healthcare, and Internal Intellectual Property.