• Responsible for building reports in Power BI and Tableau from the Scratch. • Setting up Tableau Online solution for a team of 50 Users.• Interacted with Subject Matter Experts & End Users and gathered business requirements.• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. • Developed Dynamic Row level security with power bi and integration with Power BI service portal

• Design the Data Model for the current solution to make it centralized for the other line of businesses.• Understanding the existing data and create the required data models for the development.• Created Databases, Data Mart Tables, Views, Stored Procedures, Triggers, Cluster/Non-Cluster Index, Unique/Check Constraints.• Developed packages using different transformations, SCD, Look up, Aggregate, Derived column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.• Used SQL Server Profiler to trace the slow running queries and the server activity.• Worked on query optimization, index tuning, caching and buffer tuning to improve performance of databases.• Involved in performance tuning and monitoring of T-SQL blocks.• Created Datasets using different data sources like Microsoft SQL Server, Excel, Oracle, CRM Dynamics.• Developed and maintained multiple Power BI dashboards/reports• Created Workspace and Apps in Power BI and giving access to end users to Apps.• Configured Gateways in the Power BI service.• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.

• Worked on Microsoft Power BI to build complex Visualizations and Dashboards.• Using Power Query Editor for Data Cleansing and Transformations.• Defining and documenting Data Flows and Data pipelines involved in creating various reports inside the organization.• Hands-on experience in Data Modelling inside Power BI.• Developing Financial Statements (P&L reports) Using Power BI.• Created unique reports with emphasis on Story telling using data through Power BI dashboards.• Created reports using SQL Reporting services (SSRS) for Customized and AD-hoc Queries.• Building and Maintaining complex SSIS packages.• Hands-on Experience in connecting SSAS cubes to SSRS and excel reports.• Implemented query optimization techniques to optimize the existing reports.• Worked extensively to optimize the ETL process used for reporting.• Worked Extensively on Human resource Information Systems (HRIS) Reports.• Performed analysis on the data model to find ways to optimize it for efficient reporting.• Created Financial Reports and dashboards for daily commission tracking for retail Salesman• Training various business users inside the organization on the different tools and functionalities in Cognos.• Experience in designing visualizations dashboard in healthcare, Retail domain using tableau & Power BI and publishing and presenting dashboards on web and desktop platforms.• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau and Power BI Reports.

• Design the Data Model for the current solution to make it centralized for the other line of businesses.• Designed Data Model with multiple Fact Tables and Dimensions depending on the business requirements.• Created Tables, Views, Indexes, Stored Procedures and Backend validations using Insert/Update and Delete triggers.• Involved in Data scrubbing/Cleansing/validating/Translating, and scheduling SSIS packages.• Created Power BI reports as Proof-of-concept (POC) for End users.• Migrated Excel reports to Power BI.• Developed and maintained multiple Power BI dashboards/reports.• Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure, Excel and Snowflake.• Created Workspace and Apps in Power BI and giving access to end users to Apps.• Configured Gateways in the Power BI service.• Implemented Data security (Row level security) on Dataset and Reports in Power BI.• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. • Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.• Created Calculated Columns and Measures in Power BI depending on the requirement using DAX queries.

• Involved in developing ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.• Involved in the Data modelling, Physical and Logical Design of Database.• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.• Created T-SQL queries (DDL and DML) for schemas, views, stored procedures, triggers and functions for data migration.• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.• Performed system study and requirements analysis, prepared data flow diagrams and table structures to store the data.• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and helped the front-end application developers with their queries.• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008.