M Rohith

Etl Developer @BMO

CA

Designed and developed data warehouse solutions using SQL Server, star and snowflake schemas, including data models, contract retention databases, and centralized reporting structures. Built and automated end-to-end ETL pipelines using SSIS and Azure Data Factory (ADF), integrating data from multiple sources such as Blob Storage, Azure SQL Database, and on-prem SQL Servers. Developed and optimized SQL solutions, including stored procedures, data transformations, scheduling jobs, and performance tuning within Azure and SQL Server environments. Implemented data validation, reconciliation, and error handling using SSIS package variables, event handlers, parallelism, and custom script tasks to ensure data quality and reliability. Created interactive Power BI reports and dashboards for Finance, Sales, Supply Chain, Warehouse, Production, and Operations teams to support analytics and decision-making. Led BI and analytics initiatives, including data sourcing, integration, reporting strategy, and stakeholder collaboration, resulting in measurable outcomes such as a 35% reduction in warehouse costs through inventory analysis. Supported cloud migration and DevOps practices, including Azure lift-and-shift migrations, CI/CD deployments using Azure DevOps (VSTS), and full SDLC involvement from requirements gathering to production deployment

Seneca Polytechnic

Postgraduate Degree, Business Analytics

Conestoga College

Postgraduate Degree, Supply Chain Management- Global

Alliance University

Bachelor of Business Administration - BBA, Finance, General