? Meet client and business stakeholders to understand and gather BI requirements. ? Design logical, physical, dimensional data model in Erwin. ? Design architecture and framework for BI implementation in IBM Cognos and Microsoft BI Stack. Strong Knowledge on Power BI. ? Design and implement ETL Solutions in SSIS, Data Manager. Write code in TSQL. ? Hands on Experience in Extraction, Transforming and Loading (ETL) data flows, creating mappings/workflows to extract data from SQL Server and other different sources like Excel, Flat files and load into various Business Entities. ? Design and implement OLAP cube solutions in SSAS. Write MDX scripts to fetch data from OLAP cubes. ? Develop reporting framework in various reporting and visualization tools such as SSRS and PowerBI. ? Creating customized SSRS report for displaying the KPIs as per their status indicators.