Nirav Patel Email & Phone Number

Mississauga, ON, CA

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

• Cofounded a company to help small businesses maintain their inventory with the existing infrastructure by importing data from Excel sheets into a central database.
• Extracted the inventory and transaction data from Excel sheets into a database, cleaned the data using SQL queries, and stored it in separate tables in the PostgreSQL database.
• Compared the inventory data with transaction data and created forecasting models to order items in a timely manner.

Winnipeg, Manitoba, Canada

• Eliminated 50 hours of work per month by removing legacy methods of downloading data from 3rd party warehouse websites and creating automated Python scripts to extract, clean, and display the data using Power BI.
• Managed to prevent $86,000 in pallet inventory losses from 3rd party warehouses by coordinating with 5 internal departments to maintain the proper inventory, creating a new pipeline for the data, and utilizing that.
• Replaced several inefficient and time-consuming Excel audit reports with automated ETL scripts and Power BI while uncovering $37,000 leakages.
• Spearheaded transition from PostgreSQL to Snowflake, saving the company $3300+ monthly and increasing the load speeds by an average of 32%.

Winnipeg, Manitoba, Canada

• Collaborated with resource planning and operations teams to replace 16 manual Crystal Ball staffing reports with 4 real-time Tableau dashboards, saving 20 hours per week.
• Uncovered $200,000 worth of idle time by 3rd party contact center employees who used to stay unproductive between calls by creating a new metric called actions per hour to compare their daily number of calls with hours.
• Freed operations managers and workforce analysts from 25 hours of repetitive analysis work each week by automating tedious tasks with Tableau dashboards.

Winnipeg, Manitoba, Canada

• Handled a critical client escalation by creating a process to provide the client with weekly reports on significant future events that could lead to an increase in call volumes, scheduling gaps, and planned software.
• Managed worldwide local RTA teams (spread across seven different countries) through live meetings, giving them feedback, guidance, and necessary approvals to ensure we had enough staffing support for the real-time call.
• Authorized overtime hours in the peak season to meet the higher email volume and maintained the service level requirements of the Email queues

Winnipeg, Manitoba, Canada

• Advised the operations team to maintain service level requirements of different queues by suggesting the overtime hours required during the peak season.
• Generated hourly interval reports in Excel to show real-time snapshots of call forecasts, actual calls handled, staffing levels, and service levels, catering to the needs of different business lines.

2142 Lasalle Blvd, Sudbury, ON P3A 2A7

Ahmedabad, Gujarat, India

• Created a website for a consultancy company, enabling its field agents to send reports of their daily hospital visits directly via mobile phone. This enabled the company to efficiently manage its operations directly.

Bachelor Of Technology (B.Tech.), Computer Science And Engineering

Network Technician Diploma, Network Technician