Portfolio - Aman Aggarwal

Hello! I’m Aman Aggarwal, a passionate data enthusiast with over 7 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 Consultant

Arcelormittal Dofasco

August 2022 - Current

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. 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.

Key Responsibilities:

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

2. 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.

Key Responsibilities:

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

3. 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.

Key Responsibilities:

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

4. 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.

Key Responsibilities:

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

5. Portfolio Website Development

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

Key Responsibilities:

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