Rohit Nath Nallam, PMP
TORONTO,CANADA
Summary
Results-driven Senior Consultant - Data & Analytics with 4+ years of experience in delivering enterprise-scale solutions across multiple sectors. Utilizes Microsoft Fabric, Azure, Databricks, Snowflake, Python, and Power BI/Tableau to enhance ETL processes, migrate legacy systems, and develop scalable data models. Leads offshore engineering teams and cross-functional projects, driving operational efficiency and enabling data-driven decision-making.
Overview
8
8
years of professional experience
7
7
years of post-secondary education
1
1
Certification
Work History
Senior Technology Consultant
EY
09.2022 - Current
- Delivered end-to-end data and analytics solutions across government, healthcare, real estate, and banking clients, contributing hands-on to data engineering while leading overall delivery
- Delivered a large-scale healthcare transformation by migrating Oracle-based systems to Microsoft Fabric, implementing PySpark-based Fabric Notebooks and Azure Data Factory pipelines for end-to-end data processing
- Led modernization of a provincial government platform by migrating 70 Oracle dashboards and 1000 Informatica workflows into a centralized cloud architecture, rebuilding legacy logic into scalable pipelines
- Built a full-stack analytics platform for real estate data (accounts, HR, IoT traffic) using AWS S3 for ingestion, Snowflake for data modeling, and Tableau for business reporting
- Designed Snowflake data models (staging, core, marts) and implemented transformation logic to integrate and standardize data from multiple source systems
- Conducted platform and architecture evaluations (Snowflake vs Microsoft Fabric), analyzing cost, scalability, governance, and operational trade-offs to support client decision-making
- Established Microsoft Fabric environment including OneLake storage design, workspace structure, and access controls using Microsoft Entra ID and Row-Level Security (RLS)
- Managed a team of 15 offshore engineers, BI developers, and QA resources, contributing to development and maintaining alignment with project requirements.
- Migrated SAS-based credit risk processing to PySpark using AWS Glue, validating outputs to ensure consistency with legacy models
- Served as Test Lead for a banking M&A program, managing a team of 5 testers and driving validation across key domains including stop payments, debit card systems, and account statement archival using structured test execution and Jira tracking
Data Engineer
Westjet Airlines
01.2022 - 09.2022
- Migrated Excel workflows to Apache Airflow using modular DAGs and versioned scripts, enhancing data orchestration reliability.
- Automated Python ETL pipelines using pandas and SQLAlchemy, cutting reporting cycle time by 80% to accelerate stakeholder access.
- Designed and maintained operational dashboards in Power BI and Tableau, consolidating on-time performance metrics for improved executive reporting.
Senior Supply Chain Analyst
Vapor Stone Rail Systems
Plattsburgh, New York
09.2019 - 06.2021
- Built predictive models to optimize production schedules and cut inventory costs by 20%.
- Led dashboard development to accelerate decision-making by 35%.
- Facilitated Kaizen events and performed time series analysis to reduce lead time by 10%.
- Developed supplier KPIs and regression models, reducing delivery delays and increasing supply chain reliability.
- Standardized inbound inspection procedures and reporting cadence, enhancing material availability and enabling steadier production runs.
- Mentored junior analysts on demand forecasting techniques and data visualization practices, boosting team capability and clarifying forecasts.
Supply Chain Specialist
Kawasaki Rail car Inc.,
New york city, New York
09.2018 - 08.2019
- Developed SQL and Excel analytics to track operations and sales, enhancing reporting accuracy and decision-making.
- Evaluated supplier performance and implemented corrective scorecards to improve on-time deliveries and strengthen vendor accountability.
- Performed MAKE/BUY cost analysis that reduced manufacturing costs by 6%.
- Implemented a Gurobi-based Python solver to optimize resource assignments and increase scheduling efficiency.
- Evaluated supplier performance and implemented corrective scorecards, increasing on-time deliveries and reinforcing vendor accountability.
Education
Master of Science - Management Analytics
Queens University
Toronto, ON 05.2021 - 05.2022
Master of Science - Industrial And Systems Engineering
Northern Illinois University
Dekalb, Illinois 08.2016 - 05.2018
Bachelor of Science - Mechanical Engineering
National Institute of Technology, Raipur
Raipur, India 05.2012 - 05.2016
Skills
- Azure
- ADF
- Snowflake
- Data modeling
- GITHUB
- Microsoft Fabric
- Pyspark
- Python
- SQL
- GUROBI
- Project management
- Agile
- Databricks
- Apache Airflow
Certification
Project Management professional (PMP)
Databricks Certified Data Engineer Associate
Databricks Certified Generative AI Engineer Associate
Databricks Certified Platform Architect
Microsoft Certified Fabric Analytics Engineer Associate
Microsoft Certified Power BI Data Analyst Associate
Microsoft Certified Azure Data Engineer Associate
Microsoft Certified Azure Fundamentals
Snowflake SnowPro Core Certification
Professional Scrum Master I PSM I
Tableau Desktop specialist
Timeline
Senior Technology Consultant
EY
09.2022 - Current
Data Engineer
Westjet Airlines
01.2022 - 09.2022
Master of Science - Management Analytics
Queens University
05.2021 - 05.2022
Senior Supply Chain Analyst
Vapor Stone Rail Systems
09.2019 - 06.2021
Supply Chain Specialist
Kawasaki Rail car Inc.,
09.2018 - 08.2019
Master of Science - Industrial And Systems Engineering
Northern Illinois University
08.2016 - 05.2018
Bachelor of Science - Mechanical Engineering
National Institute of Technology, Raipur
05.2012 - 05.2016