Sruthi D. Email & Phone Number

Ontario, Canada

As an Analyst Developer, I specialize in seamlessly integrating business requirements with innovative technical solutions. With a robust background in both business analysis and software development, I excel at translating complex business needs into efficient and effective software applications. Writing clean, efficient code; performing thorough testing; and collaborating with development teams to ensure high-quality software delivery.

Experienced and adept IT professional with a robust background in database management and data integration. Proficiently installed SQL Server 2018 and implemented SSIS & SSRS features in a dynamic Development environment. Specialized in data migration, utilizing SQL, SQL Azure, Azure storage, and Azure Data Factory, alongside SSIS and PowerShell for seamless transitions. Demonstrated expertise in creating C# applications for loading data from diverse sources into Azure SQL, including web API integration, with a focus on scheduling daily web jobs for efficient data processing. Skilled in constructing optimized queries using Snowflake tool and enhancing Looker-ML for dashboard building. Successfully managed ETL processes, extracting and transforming data from OLTP and OLAP using SSIS, while creating and managing SSAS Tabular models with DAX expressions and partitions. Proficient in generating insightful reports through SSRS, encompassing drill-through and drill-down functionalities, as well as various report types such as sub-reports, charts, matrix reports, and linked reports.

Noida, Uttar Pradesh, India

Proficient database professional with a focus on optimizing efficiency and troubleshooting performance issues. Played a key role in defining database requirements and enhancing existing models and reports. Developed highly optimized stored procedures, functions, and database views, implementing business logic with clustered and non-clustered indexes. Contributed to performance monitoring, tuning, and capacity planning, advising on query optimization through Execution Plan analysis. Translated business requirements into BI application designs, creating SSIS packages for data loading from diverse sources and incorporating data scrubbing techniques. Implemented comprehensive error handling configurations and participated in the complete life cycle of SSIS packages in both Development and Production environments. Designed, deployed, and maintained complex reports using SQL Server 2008 Reporting Services (SSRS), customizing reports with filters, calculations, and summaries. Published PDF reports on SharePoint Portal for seamless access and collaboration.

Mumbai, Maharashtra, India

Skilled professional adept at implementing data solutions through Copy activity and Custom Azure Data Factory Pipeline Activities. Specialized in comprehensive data migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS, and PowerShell. Developed C# applications for loading data from various sources to Azure SQL, with scheduled web jobs for daily loads. Utilized Snowflake tool for optimizing queries and enhanced Looker-ML for dashboard building. Proficient in extracting data from OLTP and OLAP using SSIS, while creating SSAS Tabular models with DAX Expressions and implementing partitions. Ensured data quality and adherence to standards, creating shared dimension tables, measures, hierarchies, and cubes. Actively collaborated with business groups to manage and resolve data quality issues, providing mediation and arbitration services when needed.