vashist patel

Front end developer (Python, SQL, JavaScript) with recent experience working on Data Admin projects within the utilities sector. Proven experience working with Dashboards, Data Queries and Microsoft SQL Server Management at Ontario Power Generation. 

Locker App – Co-Lead Software Developer

• Developed Locker app, an application that streamlines locker management for 8,000 lockers across two nuclear sites 
• Led talks with two nuclear sites to determine project requirements, manage expectations, and negotiate compromises that meet both parties' needs 
• Designed and implemented a new entity relationship (ER) diagram using TypeORM to merge two old datasets and improve efficiency by saving managers 5-10 hours per week 
• Languages: TypeORM, React, Material-UI

Internal Dashboard – Software Developer

• Contributed to the development of the internal Dashboard, an application designed for employees to access a range of important information, including employee and nuclear power plant statistics, vacation requests, and training qualifications
• Resolved various bugs and issues in the internal Dashboard application to improve functionality and user experience
• Provided quick access to key information by developing queries that can be downloaded as an Excel file
• Provided valuable insights by implementing drill down functionality for graphs 
• Languages: SQL, JavaScript, CSS

Miscellaneous Tasks – SQL Developer

• Designed stored procedures and views that queries data from multiple different sources in SSMS
• Created import packages to import data from old excel sheets to database
• Deployed a PowerShell script that sends an automated email to section managers about their employee qualifications
• Helped test new AI software versions to ensure reasonable accuracy to ensure the new update works as intended

Used stored procedures and views to decrease data querying time by up to 50% 

Graduated form Ontario Tech University with Bachelors of Science in Computer Science.