My Experiences -
▪ 8 years of experience as Business Intelligence Developer and ETL Developer
▪ 7 years of Development experience with Microsoft Business Intelligence Suite, .i.e. SSIS, SSRS &
SSAS
▪ 1.7years Development experience with Snowflake cloud data warehouse
▪ Experience in Data Modeling, Data warehouse, Reports, and Dashboard using Power BI Desktop and
Power BI Service
▪ Extensive experience in Designing Databases and the Development of Database objects Like -Stored
Procedures, Cursors, Indexed Views, User Defined Functions, Pivot, UNPivot, and Triggers using SQL
Server 2008/2014/2019.
▪ Experience of ETL with structure, semi-structured and Third-party API integration.
▪ ETL pipelines in and out of Data Warehouse using a combination of SSIS and Snowflakes
▪ Experience with Snowflake cloud data warehouse and Azure Data Lake for integrating data from
multiple source system
▪ Deployed and Monitored SSIS Packages for new ETL Processes and Upgraded the existing DTS
packages to SSIS for the ongoing ETL Processes
▪ Designing and Deployment of SSRS Reports for the End-User request using Web Interface & SSRS.
▪ Experience to automate processes using C# and python
▪ Experience in Migration, Database partitions, Data merging, Backups, Restore
▪ Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.
▪ Also, have a working knowledge of Big data ecosystem