▪ Design and develop of reporting data module for Credit Card Marketing Analytics.▪ Developed Up-selling and Cross-selling reports using DAX functions.▪ Creating Row level security with power bi and integration with power bi service.▪ Developed profit analysis reports and dashboards by products and customers.▪ Worked on all types of transformations that are available in Power bi query editor.▪ Scheduled Automatic refresh and scheduling refresh in power bi service.▪ Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.▪ Created reports using time intelligence calculations and functions.▪ Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.▪ Executed dashboard setups and data manipulation using DAX.

▪ Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.▪ Provided input to technical solutions in architecture meetings determining project scope, tasks, timeframe, resources to provide project estimates for the BI Team Lead.▪ Interaction with a variety of internal and external users to develop technical designs and reviews with the rest of the project team as appropriate.▪ Wrote SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views.▪ Created List reports, Cross -Tab reports and different types of charts like Column charts and Bar charts.

▪ Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire Microsoft BI.▪ Contracted during design phase of project to help complete the redesign of end client SQL Server 2017 Data Warehouse.▪ Created Star Schemas for BI applications. ▪ Created eight OLAP cubes from relational data warehouse with various measures, dimensions, and business critical KPIs and representing aggregations in different ways hierarchically and using custom groupings using SSAS.▪ Developed reports interactive business and with drill down abilities reports using Microsoft SQL Server Reporting Services SSRS based on existing data sources.