• Involved in Software Development Life Cycle (SDLC) for a new subject area; requirements gathering, data quality analysis and business rules, dimensional modelling, and database architecture.• Good understanding of Snowflake cloud technology, Snowflake multi-cluster warehouses, building snow pipes, using Snowflake clone and time travel and other Snowflake processes.• Migrating data from on-prem databases to Snowflake database.• Great ability to understand and analyze Business Requirements and working with team developers to create Data Models• Developing and Implementing Reporting, Analytics and Data visualization solutions with Power BI.• Working with Power Pivot, Power BI Online, Power BI Desktop and DAX.• Creating Row Level Security with Power BI Desktop and integration with Power BI Service portal.• Optimizing Reports and setting up Power BI service, Gateways, and scheduling data refresh.• Experienced in working in Agile methodology and Scrum methodology environments.• Developing Dashboards in Salesforce

• Working with Business analyst, Data architect and business users to understand Business Processes, Document Project Requirements and translate them into Functional and Non-Functional specifications for BI reports and applications.• Creating complex SSIS packages to extract data from various sources and use various transformations and tasks to load data into Staging, ODS and Data Warehouse databases.• Designing and developing Data Warehouse, Data Marts and Business Intelligence using Multi-Dimensional Models - Star Schema and Snowflake Schema.• Developing OLAP cubes by identifying Fact and Dimension tables, Data Source and Data Source Views, Attributes and Dimension members using MS-SSAS.• Conduct Performance Tuning, Data Optimization, Query Optimization and Job Scheduling.

• Analyzed source System Data to determine the Data Model and ETL solution that will meet business requirements.• Created Technical Specifications, Test Plans and Test Data to support ETL processes.• Created and modified SSIS packages to Extract, Transform and Load data from various Data Sources, Populate Dimensional Tables and Fact Tables in MS-SQL Server Data Warehouse.• Responsible for enhancements, maintenance, and monitoring of the Data Warehouse on SQL Server and the daily ETL Processes.• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.