Sharmistha Soni
About Sharmistha Soni
Sharmistha Soni is a Senior Data Warehouse Developer at Intact in Toronto, Ontario, Canada, with over four years of experience in SQL and BI development. She specializes in database management, T-SQL optimization, and Microsoft Power BI, and has a background in engineering education from Nirma University.
Work at Intact Financial Corporation
Sharmistha Soni has been employed at Intact Financial Corporation as a Senior Data Warehouse Developer since 2022. In this role, she is based in Toronto, Ontario, Canada, and has accumulated two years of experience in this position. Her responsibilities include database installation, configuration, maintenance, and monitoring, as well as managing SQL jobs. She is involved in SQL Server Job scheduling, which is essential for executing Integration Services packages and distributing client reports.
Education and Expertise
Sharmistha Soni earned her Master of Technology (MTech) degree from Nirma University in Ahmedabad, Gujarat, India, from 2010 to 2012. Her educational background has equipped her with a strong foundation in engineering principles. She has over four years of experience as a SQL Developer and BI Developer, demonstrating proficiency in various tools such as SSIS, SSRS, and collaboration with SSAS teams.
Background in Academia
Prior to her current role, Sharmistha Soni served as an Assistant Professor at Dharmsinh Desai University in Gujarat, India, from 2012 to 2018. During her six years in academia, she contributed to the education of students and engaged in academic research, further enhancing her expertise in data management and analysis.
Technical Skills and Experience
Sharmistha Soni possesses extensive skills in developing and optimizing complex T-SQL components, including Stored Procedures, Functions, Triggers, Views, Cursors, Joins, and Subqueries. She has hands-on experience with Microsoft Power BI, where she creates dashboards, datasets, visuals, and paginated reports. Additionally, she has expertise in transforming OLTP data into Data Warehouses using SSIS and employs various logging methods in SSIS for effective data management and troubleshooting.