Rashmitha Reddy Email & Phone Number

Toronto, Ontario, Canada

• Successfully implemented a cloud-based solution using Azure Virtual Machines and Azure SQL Database, resulting in a 50% increase in performance and availability for a high-traffic e-commerce website.• Demonstrated expertise in deploying and managing scalable, secure cloud infrastructures, leveraging Azure services such as Virtual Machines, App Services, Functions, and Storage, as well as configuring network and security features.• Reduced maintenance costs and improved database performance by migrating an on-premises SQL Server database to Azure SQL Database. Conducted performance tuning and optimization, achieving a 35% improvement in database query performance.• Proficient in data integration and transformation using Azure Data Factory, creating linked servers between on-premises and Azure Cloud. Analyzed data schemas and flow, working closely with data analysts and modelers to define the analytics/reporting consumption layer.• Proficient in automation tools and scripting languages such as PowerShell and Python, utilizing them to automate routine tasks, streamline operations, and improve overall efficiency.• Experienced in creating reports and dashboards using Power BI and writing complex DAX queries for advanced data analysis and reporting capabilities.

Toronto, Ontario, Canada

• Proficient in writing complex T-SQL stored procedures, utilizing advanced features like Merge and Except commands in SQL Server.• Experienced in developing and deploying SSIS packages, configuring schedules and jobs for generating data in CSV files, and implementing data cleaning and loading processes in data warehouses. • Proficient in T-SQL query development, including common table expressions (CTE), stored procedures, and functions for designing SSIS packages.• Skilled in creating SSIS packages for transferring data between OLTP and OLAP databases using incremental load techniques.• Extensive experience in data migration using SQL Server, SQL Azure, Azure storage, Azure Data Factory, and SSIS, with a focus on Azure cloud platform components such as ADF, Azure SQL & Datawarehouse, and Azure Data Modeling.• Collaborated with cross-functional teams to implement a new data modeling strategy using Azure cloud platform components, reducing data redundancy by 30%.• Proficient in creating DAX queries for generating computed columns in Power BI, as well as developing SSIS packages with various transformations, data flow tasks, and control flow tasks to support report generation and data export from different sources to the data warehouse.

Hyderabad, Telangana, India

• Designed and developed SQL Server Reports and queries using SSRS that enable drill-down and drill-through functionalities, resulting in improved data visibility and a 40% increase in overall report usage rate.• Optimized database performance by tuning queries, indexes, and database parameters, resulting in a 30% increase in database performance and scalability.• Proficient in designing and implementing data entities in Azure data services such as Azure SQL DWH, Azure SQL DB, and Azure Data Lake Store (ADLS), with experience as a data engineer and expertise in database design.• Extensive experience in developing complex T-SQL code, including stored procedures, functions, triggers, indexes, and views, to optimize data manipulation and storage efficiency.• Skilled in building data pipelines using Azure Data Factory, employing ELT methods, and working with Azure Data Lake Store for capturing and processing data of varying sizes and types.• Strong understanding of data architecture, data modeling, and optimizing database performance through query tuning, index optimization, and database parameter configuration.• Proficient in creating dynamic SSIS packages for data validation and transfer across platforms, archiving files, and deploying packages using File System Deployment.• Experienced in designing and developing SQL Server Reports using SSRS, incorporating drill-down, drill-through, and interactive functionalities. Generated various reports, including matrix, charts, linked reports, and sub-reports, to display business data and sales information.