About

Soniya Suki is a highly skilled Software Engineer and Microsoft Certified Professional with over 11 years of experience in BI development. With expertise in designing, modelling, developing, implementing, and supporting complex systems, Soniya has a proven track record of delivering high-quality solutions. Soniya's technical skills include writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views, and cursors. She is experienced in using recursive CTEs, CTE, temp tables, and effective DDL/DML triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications. Soniya has extensive experience in analyzing, designing, developing, configuring, and deploying ETL jobs. She is skilled in error handling and logging and has proficiency in resolving issues. She has hands-on experience in using SSIS, Datastage tools like Import and Export Wizard, Package Installation. She is also experienced in importing/exporting data between different sources like Oracle/Access/Excel using SSIS/DTS utility. Soniya has experience in ETL processes involving migrations and in sync processes between two databases. She has experience in creating, monitoring, and configuring jobs using IBM Datastage. She is also experienced in creating configuration files to deploy the SSIS packages across all environments. Soniya has experience in SSAS for XMLA, XMLA for Cube Processing, Use of XMLA in SQL Server Agent. She can invoke SSAS Cube Processing from SSIS and has experience in MDX, .Members, Children in MDX, NonEmpty Function, where clause, Axis in MDX, Filter Function, Asc vs BAsc, Union, Intersect, and Except. She is experienced in Time Series, DMX Query, data Mining Model deployment, and using Partitions and Processing options in SSAS. Soniya is proficient in ROLAP, MOLAP, HOLAP Applying to partitions, Personal and Professional BI, Power Pivot, Pivot Table, DAX Queries, Multidimension and Tabular instances, SSAS Projects. She has experience in SSRS and implementing Matrix, Tabular, Parameters, Sorting, Expressions, and using features like Bar chart, Gauge, and Indicators. She is also experienced in Deployment of Reports. Currently working as a Software Engineer at CGI, Soniya holds a Master of Computer Applications degree from Dr. D. Y. Pat