Guru P•••

About

On the record

Highly qualified consultant offering over 14 years of commercial experience working for companies within several industries including Manufacturing Corporate and Investment banking Health Care Insurance Automobiles and Telecom. • 11+ years of experience in designing and implementing data warehouse solutions using the MS BI stack. • Responsible for defining the information architecture and technology infrastructure along with the design of multi-dimensional data models and the Business Intelligence delivery solutions • Responsible for managing the data analysis data sources data mapping along with defining the meta data repository • Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs • Skilled in implementing Data Warehousing and Business Intelligence solutions. Expertise in Ralph Kimball and Bill Inmon’s Data Warehouse methodology • Expertise in Conceptual Data Modelling Enterprise Data Modelling Logical Data Modelling Physical Data Modelling Enterprise Data Warehouse Design Datamart Design Metadata Data Quality Master Data Management and Data Governance • Designed generic ETL template to utilize it across projects that could be expanded to additional implementation. • Expertise in creating OLAP cube and roles for security management using SSAS • Expertise in writing MDX queries for reporting requirement • Excellent documentation skills for database design document technical design document • Expertise in designing Dashboard KPIs and detailed reports using SSRS and Crystal Reports • Skilled in programming tasks-Stored Procedures CTE using SQL Server 2008/2005/2000 with T-SQL. • Expertise in Performance tuning Optimization Data integrity and Statistics by using SQL Profiler PerfMon and Spotlight • Experience across all phases of the SDLC from project initialization to post-implementation. • Exceptional problem solving and mentoring skills