Shankar Narayanappa

Background

About Shankar Narayanappa

An extraordinary and passionate ETL and BI Architect with 14+ years of experience in leading overall architecture of DW/BI efforts from requirement gathering, Database development to DW implementation and Reporting. Twelve plus (12+) years of data warehouse and database development. experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Oil, real Estate,Automotive,Manufacturing,Retail distribution industry. Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing (Dimensional Modelling, ETL and database Design), and Business Intelligence (Reports, KPI, Dashboards, OLAP). Strong experience in SQL Server Integration Services (SSIS) for data transformation, data cleansing using various transformations from various sources and loading into Data Warehouses and Data Marts. Strong Experience on IBM Cognos BI Suite (Framework Manager, Report Studio, Analysis Studio, Active Reports),IBM Cognos Transformer and Cube Designer Data Architecture (Conceptual, Logical, and Physical) experience involving Kimball’s bottom-up approach by building Star Schema, Dimensions (Slowly Changing, Snowflake, and Conformed Dimensions), Facts, Metrics, and KPI. ETL Architecture experience involves defining different layers (staging, Reload on Failure) complete ETL schedule and flow to fit SLA, mapping design, data transformation, data cleansing (DQS), Error handling and Workflow Design in SQL Server Integration Services (SSIS) from various sources and loading into Data Warehouses and Data Marts. Strong expertise in SQL Server Analysis Services (SSAS) for OLAP Cube design implementing Dimensional Modelling, Dimensions and Facts, KPI and Calculations, Advanced knowledge writing complex T-SQL queries, stored procedures (CTE, triggers, UDFs) in SQL server for database development and report generation.