budget Variance Calculator - old and new
Summary
The pictures above is what ultimately lead me to pursuing a career in data science and going back to school full-time. It is a elaborate tool I created from scratch in Microsoft Excel to help with scheduling. Maintaining a budget is important in any business and monitoring hours is a huge part of that, however the tool I had at the time of creation this was lacking.
This tool allowed me to directly plug in the operations packet and calculate the hours and pay including overtime. There were several benefits to this. With this tool I could be updated quickly, prioritize who I would call in to stay under budget if I had a call-out, run overtime and stay under budget if I was under on hours, and avoid getting on budget calls with the COO at the end of the week.
This project was especially important to me because my VP at the time shared it with the entire region. What started as a personal project, ended up helping the budget company-wide. To this day I have not seen a tool like it. The picture on the rights is a GUI created in python with the same concept, but is much more user friendly.
Tags: Python, AI, Automation, Budgeting, PANDAS, tkinter, and gui.
Automated Reporting - old and new
Summary
I wanted to automate an old report I had to do weekly. You can observe above the old report on the left and the new automated report on the right. It went from being an overly formatted PowerPoint mess to a clean professional word document. With the input of a simple csv, the rest of the work is done automatically and is capable of being sent via email to whatever recipients you want through the code automatically. This will take the workload of making the report in quite a bit of time to only a few seconds.
Tags: R, AI, Automated, Reporting, KPI, and Word Document.
Automated Cover Letter
Summary
This project was created so I could manage to tailor a cover letter that was both personable and fast when applying for jobs. I don't think most people read them, but I think it is a nice touch if and when they do. The project is written in Python and is displayed in an easy-to-use GUI that lets users make quick adjustments. It also includes a default button in case you want to alter the code so you can populate your personal information without typing it every time you use it.
Tags: Python, personal project, cover letter, AI, GUI.