Ruthwik Reddy Email & Phone Number

Toronto, Ontario, Canada

Developed custom Power BI reports using Python to meet specific client requirements on an as-needed basis. Ensured data quality, consistency, and accuracy within SSAS databases were maintained at all times. Created dimensions using both the cube wizard and T-SQL programming, regularly refreshing the cube to keep OLAP databases up to date. Successfully deployed cubes to production servers. Possessing a strong understanding of networking concepts and hands-on experience with Azure networking services such as Azure Virtual Network, Azure ExpressRoute, and Azure Load Balancer. Knowledgeable in IP addressing, DNS, and routing as an Azure cloud developer. Built and maintained ETL pipelines using Python libraries such as Pandas, NumPy, and PySpark.

North York, Ontario, Canada

Developed Lookup Transformation packages for data matching, comparing source and destination data based on IDs, retrieving new and updated records, and utilizing conditional split to select new records before inserting them into the database. Designed and developed SSRS reports based on business requirements and data models. Extracted data from Online Transaction Processing (OLTP) systems to Online Analytical Processing (OLAP) systems using SSIS. Identified various data sources and established connections using SSIS, creating data source views tailored to the required reports. Published reports using Power BI desktop, shared dashboards via Power BI service, and made reports accessible through mobile apps for end-users, including developers, stakeholders, managers, and clients. Designed enterprise data models and data warehouse solutions, specifying ETL pipelines, and devising data integration and migration processes, including the creation of master data.

India

Demonstrate proficiency in Power BI Desktop and Power BI Service. Exhibit a strong understanding of data modeling and the DAX language. Create interactive dashboards and reports to effectively visualize data. Connect and consolidate data from multiple sources, including SQL Server, Oracle, Excel, and SharePoint.