Snehal Dhamale

Snehal Dhamale (She/Her) Email:- Toronto Open to relocate PROFESSIONAL SUMMARY: 5+ Years of experience in IT industry as a SQL BI Developer (SSIS, SSAS, SSRS, PowerBI). Adept at Database Development, System Analysis, Design, implementation, and support of MS SQL Server 2008/2008 R2/2012/2015,2017,2019. Proven experience in ETL (Extract, Transform and Load) such as Informatica, Database Design, ETL development frameworks using Azure Data factory, Databricks notebooks. Highly skilled in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues. Achieve optimized performance in SQL queries through problem solving, modifications, column removal, and eliminated redundant data. Knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables. Authoring, management, and deployment strategic experience in SSRS reporting solutions. Experienced in deploying and scheduling reports and transactions using SSRS to generate daily, weekly, monthly, and quarterly reports run periodically. Excellent knowledge in Dimensional Data Modeling, Data Warehouse analysis by building using SSAS. Ability to write MDX queries to access cube data in SSAS. Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS. Developed confidential analytical tools and reports using Excel, and Power Pivot, and Power Point. Experience with management of data to produce accurate and consistent longitudinal datasets. Proficient in using DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models. Set-up Enterprise Gateway and SSAS Connector for Power BI Report deployment on Azure VM. Expert in creating various Power BI Reports, Dashboards and visualizations tools using Tableau. Proficient in creating ETL packages using SSIS for data validation, extraction, transformation and loading data to data warehouse. Experience with SQL Server in both production and development environments and T-SQL in constructing tables, user defined functions, relational database models, triggers, and data integrity. Experience in Oracle database (SQL /PLSQL) design and development, including Complex Joins, Tables, Views, Sequences, Materialized Views, Procedures, Triggers, Functions, Packages and Oracle Scheduler Jobs Migrate data between systems using DTS/SSIS, with necessary transformations for data integrity and validity. Understanding of Data Marts and data warehousing concepts (OLTP & OLAP) and data mining Implemented type 2 slowly changing dimensions (SCD) type 2 to maintain the history. Skilled in logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio. Technical Skills: Data Warehousing/BI SQL Server Business Intelligence Studio – SSIS, SSAS, SSRS, Microsoft Azure, Azure Data factory, Azure Data Lake, Apache spark, Hadoop Database Tools SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, OLAP, MOLAP, ROLAP, OLTP Reporting Rules SQL Server Reporting Services, MS Excel, Power BI Application Packages MS-Front Page, Microsoft Office Suite, SSIS, SSAS, SSRS, JIRA Azure Operating Systems Programming Skills Windows 8 -2003, XP,2000, NT, ME, 98, Macintosh C#, .Net Framework .Net Core, ASP.Net, Python, T-SQL, Java, Github Professional Experience: Client: Capreit, ON Jan 2022- Present Role: SQL/Power BI Developer/ETL Responsibilities: Designed and implemented ETL processes using SSIS, with data collected from sources such as SQL Server 2012/2014/2016 Developed and deployed SSIS packages, schedules, and configurations to generate data in CSV and flat files Automated file transfer processes and email notifications using FTP Task and Send Mail task in packages Designed high performance ETL packages to extract, migrate, and manipulate data from MS Excel and SQL Server Conducted business requirements, functional, and technical meetings with business groups with written and verbal contracts. Developed complex SSRS reports using Sub Reports, Matrix/Tabular Reports, Charts and Graphs, and created report subscriptions Implemented Power BI, evaluated and compared to Tableau and Crystal Reports Created various visualizations (e.g., Stacked bar chart, clustered bar chart, Pie chart, etc.) and used filters in Power BI reports Published Power BI reports and made available in web clients and mobile apps Developed Tabular Models in SSAS and used DAX functions for calculations and measures Built Star Schema for OLAP cube generation and dimension modeling using SSAS Responsible for creating Ad-Hoc reports in Power BI as per business requirements Used indexing strategies and query optimization techniques to optimize stored procedures and long running queries Designed, developed, and implemented analytical solutions to support business strategy and decision-making processes. Utilized technical proficiency in SAS, SPSS, and Spotfire to diagnose and resolve data preparation issues, and to create analytical graphics for presentation. Conducted user acceptance testing for various data reporting and visualization tools and provided training programs to end-users on their usage. Designed and conducted data-driven exercises to measure the performance of new and existing tools and technologies. Contributed to the creation of data-driven strategies and solutions to support the company's goals and objectives, demonstrating expertise in strategic analytics. Demonstrated technical proficiency in reporting tools and MATLAB to produce accurate, reliable, and meaningful results. Collaborated with cross-functional teams to effectively communicate and influence data-driven decisions and outcomes. Efficiently monitored demographics and product trends to identify potential situations that could impact business performance. - Demonstrated strong judgment and communication skills in developing data-driven solutions to address complex business problems. Environment: MS SQL Server 2014/2016, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), DAX, POWER BI, Visual Studio 2014, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Toad, TWS, Excess, Windows 8 Client: Intrado, ON May 2019 – Dec 2021 Role: SQL/Power BI Developer Responsibilities: Coordinated with the project controls team to improve a Microsoft Tabular Cube used for project data reporting. Collaborated with customers to understand reporting requirements, translated them into technical requirements, and executed data warehouse development including a SQL database and SQL Tabular Cube. Developed strong understanding of both business processes and applications, along with analytical skills and applied Agile Methodology in the development of the Microsoft reporting environment. Designed Physical and Logical Model Designs for project enhancements and estimated time and effort required for completion. Utilized SSIS packages (ETL) to transform data from a MYSQL data warehouse to a SQL server database, standardizing data with primary keys, indexes, and elimination of duplicate records. Created SSIS packages to integrate data from various sources using transformations including Merge, Conditional Split, Union All, Script Task, OLE DB Command, Data Conversion, Lookup, and others. Experienced with OLAP data warehouses and design, implementation, and modeling. Proficient in partitioning SSAS cubes, writing stored procedures to process cubes, and using DAX for Tabular cubes and Power BI. Conducted testing on the cube and reports using Power BI. Created stored procedures, functions, indexes (clustered and non-clustered), tables, semantic views, and SQL joins, utilizing advanced DML and DDL syntax. Conducted performance tuning on tables and semantic views, optimizing results through creation of indexes on fact tables. Experienced in working with cursors, CTEs, schemas, permissions, and client-side and server-side database design. Implemented security roles on SSAS cubes and Power BI services using authentication and authorization methods. Installed a standalone SQL server and scheduled SQL Server Agent Jobs, monitoring daily jobs and deploying SSIS packages, SQL scripts, and SSAS cubes into production environments. Proficient in using TFS (Team Foundation Server) for Source Control, creating user stories and tasks, and maintaining source control with updated codes Environment: MS SQL Server 2017/2019, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Agile, T-SQL, SQL Profiler, GIT, MS Excel, SQL Developer 4.0.1 Client: Reliance Communications, India Nov 2017 – Apr 2019 Role: SQL ETL Developer Responsibilities: Coordinated the analysis and gathering of requirements and created the function design document. Worked closely with application developers in data modeling and entity-relationship design. Designed and managed schema objects, such as tables, views, indexes, and referential integrity, based on user requirements. Utilized DDL and DML commands to write triggers, stored procedures, and manipulate data. Built high-performance ETL packages using SSIS to transfer and manipulate data from MS Excel and SQL Server. Improved system stored procedures for optimal performance. Developed effective reports using SSRS and MS Excel to address business needs. Managed report subscriptions and scheduled SSRS reports. Assisted application developers by providing necessary SQL scripts using SQL and PLSQL. Developed and deployed SSIS packages, configuration files, and scheduled jobs to generate data in CSV format. Generated periodic reports based on statistical data analysis using SQL Server Reporting Services (SSRS). Managed database performance, backup, replication, capacity, and security. Experienced in creating multidimensional cubes using SSAS. Environment: MS SQL Server 2012/2014, T-SQL, SQL Server Management Studio (SSMS), SQL Profiler, Visual Studio 2005, SSIS, SSRS, Windows XP, TFS, TWS Education: Bachelor’s degree in computer engineering-University of Mumbai [2017] Online learning-Data Engineering Fleming College [2019]