Harshilkumar Patel Email & Phone Number

Toronto, On, Ca

● Designed and implemented a Power BI dashboard, leveraging DAX and interactive data visualizations to reduce waste by 25%, resulting in an annual cost saving of $35,000.● Utilized PivotTable and VLOOKUP functions to analyze and consolidate data from multiple sources, improving reporting accuracy and reducing data retrieval time by 30%.● Leveraged Power Query Editor to clean and transform data, incorporating it into a Data Model to improve data consistency and streamline the reporting workflow.● Collaborate with multiple teams and manage multiple projects simultaneously, ensuring timely delivery of data-driven solutions and seamless communication across departments

Mundra, Gujarat, India

● Designed a BI report to track defect percentages and identify underlying causes, reducing defect rates from 10% to 4% and generating annual savings of $48,000.● Developed and implemented VBA macros to automate repetitive tasks in Excel, resulting in a reduction of manual processing time by 20 minutes per task.● Built an hourly machine data monitoring system, facilitating early issue detection and decreasing product rejection rates from 3.2% to 1.4%.● Collected data from SQL databases on the equipment and used exploratory data analysis techniques to pinpoint the machine that is the bottleneck for overall efficiency.

Postgraduate Degree, Data Analytics For Business

Bachelor Of Engineering - Be, Mechanical Engineering