Portfolio - Aman Aggarwal

Hello! I’m Aman Aggarwal, a passionate data enthusiast with over 8 years of experience in turning raw numbers into powerful insights. I thrive on transforming complex data into compelling visual stories and actionable strategies. Whether I’m crafting engaging dashboards, unraveling complex data models, solving intricate statistical puzzles, or utilizing Microsoft Dynamics tools like Power Automate and Power Apps, my goal is to empower organizations through data-driven decision-making.

Dive into my portfolio to discover how I bring data to life and drive impactful change!

Senior Business Intelligence Engineer

Northbridge Financial Corp.

April 2025 - Current

Toronto, ON, CANADA

Senior Business Intelligence Consultant

Arcelormittal Dofasco

August 2022 - April 2025

Hamilton, ON, CANADA

Data Migration Specialist (ERP & Automation)

Guhring Corporation

April 2021 - August 2022

Kitchener, ON, CANADA

Technical/Data Ambassador (Power Platform & Cloud Solutions)

Conestoga College

January 2021 - December 2021

Kitchener, ON, CANADA

Data Modeller

All Eat App Networks Pvt. ltd.

August 2016 - September 2019

Croydon, London, United Kingdom

Projects

1. Portfolio Loss Triangle - Advanced Power BI & Snowflake Analytics

This project delivers a fully dynamic and highly optimized Portfolio Loss Triangle solution built for enterprise-level actuarial and financial analytics. It combines claims and premium data from Snowflake, real-time data modeling, advanced DAX calculations, and an interactive Power BI experience designed for senior leadership and actuarial teams.

The report includes both incremental and cumulative loss views, Loss and Loss Ratio analytics, accident-year KPI cards, development factor modeling, and a Python-based dynamic development chart. A hybrid architecture was used, integrating Snowflake materialized and secure views with Power BI’s Incremental Refresh to handle 10+ years of historical loss data at scale.

The interface uses dynamic slicers, buttons, and toggle-based navigation to switch between Loss, Loss Ratio, Net/Gross/Ceded/Assumed/Direct sources, and Incremental vs. Cumulative data tables. The result is a highly performant, audit-ready, and business-friendly analytics experience.

Loss Triangle Overview — Cumulative Loss Triangle View

Project Deliverables:

Modelled claims and premium data from Snowflake using optimized SQL and secure/materialized views
Designed Power BI semantic model with Incremental Refresh (1 month refresh, 10 years archived)
Built dynamic Loss and Loss Ratio measures with advanced DAX logic using Dev Age, Accident Year, and time intelligence
Created Python-based dynamic Loss Development chart integrated directly in Power BI
Developed two synchronized views: Cumulative Data Table and Incremental Data Table
Implemented slicer-based automation for Metric Type, Metric Description, Loss Source, and Accident Year views
Used buttons, bookmarks, and dynamic visuals to enable seamless navigation between views
Optimized report performance through query folding, model slimming, and hybrid storage modes
Coordinated with actuarial and finance leaders to validate accuracy of KPIs and development patterns

Technologies Used:

Power BI (Desktop & Service)
Snowflake (Secure Views, Materialized Views)
Advanced DAX (Dynamic measures, Dev Age logic)
Python Visuals in Power BI
Incremental Refresh (Hybrid Models)
Power Query (Query Folding, Parameterized M scripts)
Bookmarks, Slicers & Dynamic Buttons
Azure DevOps for versioning and deployment

2. SharePoint Migration and PowerApps Form Creation

The project involved migrating an on-premise SharePoint site to SharePoint Online and creating a PowerApps form integrated with a SharePoint list. The process began with an assessment of the existing SharePoint environment, followed by meticulous planning and execution of the migration using the SharePoint Migration Tool and PowerShell scripts. Data integrity and minimal downtime were prioritized during the migration. Once the migration was complete, SharePoint Online settings and permissions were configured to match the organization's needs. A PowerApps form was designed and developed, integrating seamlessly with a SharePoint Online list. The form included custom validation and logic to ensure data accuracy and user-friendly interactions. After thorough testing, the form was deployed for use. Technologies utilized in this project included SharePoint Online, SharePoint Migration Tool, PowerShell, PowerApps, and Microsoft 365.

Project Deliverables:

Assessed the existing on-premise SharePoint environment
Planned and executed the migration to SharePoint Online
Ensured data integrity and minimized downtime
Configured SharePoint Online settings and permissions
Designed and developed a PowerApps form
Integrated the form with a SharePoint Online list
Implemented form validation and custom logic
Deployed and tested the form

Technologies Used:

SharePoint Online
SharePoint Migration Tool
PowerShell
PowerApps
Microsoft 365

3. Data Migration from Linux-based ERP to SAP

Migrated the existing data from a legacy Linux-based ERP system to SAP to improve system efficiency and leverage advanced functionalities.

Project Deliverables:

Conducted a thorough analysis of the existing ERP system to understand the data structure and dependencies.
Developed a detailed migration plan, including timelines, resource allocation, and risk assessment.
Extracted data from the Linux-based ERP system using SAP Data Services, SAP Business One, SAP Business Suite, SAP Business Intelligence, Excel.
Transformed the extracted data to meet SAP’s data structure requirements.
Loaded the transformed data into SAP.
Conducted rigorous testing to ensure data integrity and accuracy post-migration.
Documented the entire migration process, including challenges faced and solutions implemented.

Technologies Used:

Python
SQL
SAP Data Services
SAP Business One
SAP Business Suite
SAP Business Intelligence
Excel

4. Monthly Dashboard Maintenance Automation

Designed and implemented an RPA solution using Power Automate to automate the monthly maintenance of company dashboards. This process involves extracting, processing, and exporting data to the online company platform, ensuring timely updates and enhanced accuracy. Integrated Python scripts for complex data manipulations.

Project Deliverables:

Developed automated workflows in Power Automate for dashboard maintenance.
Wrote and integrated Python scripts for data extraction and validation.
Collaborated with stakeholders to gather requirements for enhancements.
Conducted testing and debugging to ensure smooth operation of processes.
Created documentation and provided training for team members.

Technologies Used:

Power Automate
Python
Microsoft Excel
SQL
Online Company Platform

5. Power BI Dashboard - Shipped Not Invoiced

This dashboard provides insights into the shipped products that have not yet been invoiced, helping the sales and finance teams identify potential issues and improve cash flow management.

Project Deliverables:

Collaborated with stakeholders to define dashboard requirements.
Extracted data from multiple sources and transformed it for analysis.
Created interactive visualizations to represent data insights.
Conducted user testing to refine dashboard usability.
Provided training and support for end-users.

Technologies Used:

Power BI
SQL
DAX
Excel

6. Portfolio Website Development

Developed a responsive portfolio website with a user-friendly interface and Dark/light toggle functionality.

Project Deliverables:

I began by thoroughly analyzing my own requirements, determining the features and functionalities needed to create an effective portfolio website. This included considering my personal branding and the best way to showcase my work.
Next, I designed detailed wireframes and prototypes. This step involved creating visual representations of the website layout, ensuring a seamless and intuitive user experience. The designs were iterated upon based on feedback and usability considerations.
For the front-end, I utilized React.js to build a dynamic and interactive user interface. React.js allowed for efficient component-based development, making the codebase more manageable and scalable.
Implemented back-end using Node.js and Express
Ensured cross-browser compatibility and responsiveness
Deployed the application to AWS
Maintained and updated the website post-launch

Technologies Used:

React.js
Node.js
Express
AWS
CSS
HTML