Gaurav Amin

About Gaurav Amin

I am a Data Analyst and ERP Systems Analyst with a proven track record of leveraging data to drive operational efficiency and solve complex business problems. At the intersection of data analytics and Microsoft Dynamics 365, I specialize in transforming raw data into strategic insights. I have built Power BI dashboards that tracked key performance indicators, resulting in a 4.2x increase in units sold. My expertise includes automating data pipelines with SQL and Python to ensure data integrity and optimize performance. I thrive in dynamic environments and am adept at using Azure, Power BI, and DevOps to deliver data-driven solutions that directly impact the bottom line.

Experience

1. Data Analyst

   Zenith Technology LLC

   Jan 2025 — Present · NJ, US

   Developed a Power BI dashboard to track critical inventory and supply chain KPIs, including 34% warehouse utilization,15.56 Day Sales of Inventory, and 23.47 Inventory Turnover Ratio, providing actionable insights into over 1,200 backorders and supporting a 4.2x increase in units sold over a four-year period. • Designed and executed SQL stored procedures and functions to automate data extraction and transformation (ETL processes) of financial data from transaction tables in Microsoft Dynamics F&O ERP systems.• Developed and maintained Python-based data validation scripts to ensure data integrity across various disparate datasets, reducing data-related errors by 25%.

Education

• National Institute of Technology Karnataka

  Bachelor's degree, Electronics and Communications Engineering

• NYU Tandon School of Engineering

  Master's degree, Computer Engineering