About Me

An image of Prateek Balani

Prateek Balani

I am currently in my fourth year pursuing a Bachelor of Science degree in Computer Science at The University of British Columbia, Okanagan Campus.

My academic journey has fostered a deep interest in software development and web development, particularly with a strong emphasis on backend development.

Throughout my studies, I have honed my skills in various programming languages and development frameworks, which has enabled me to build robust projects. I am passionate about creating efficient and reliable software solutions that can address complex problems. My coursework and projects have provided me with hands-on experience in database management, server-side logic, and API development.

I am eager to continue expanding my knowledge and expertise in this field, and I look forward to contributing to innovative projects and connecting with like-minded professionals in the industry.

Download my resume here

Work Experience

Software Developer Intern - Systems Plus Pvt Ltd

  • Developed an Internal Automation Tool

    I spearheaded the development of an internal tool to automate the invoicing process for the captive team at Systems Plus. This tool significantly reduced manual data entry, leading to a 60% increase in processing speed and a marked decrease in errors.


  • Technology Stack

    The project was built using the Django framework, leveraging a Python backend to handle data processing and business logic. For the frontend, I utilized HTML/CSS to create a user-friendly interface, ensuring seamless interaction for non-technical users. The project was securely hosted on the company's internal server, complying with all internal data protection protocols.


  • Excel Automation with 'openpyxl'

    The tool integrated with 'openpyxl' to automatically generate and populate Excel sheets with invoice data. This automation streamlined the generation of invoices, reducing the time taken from hours to minutes and allowing the team to handle a higher volume of invoices efficiently.


  • Impact

    By automating the invoicing process, the tool enhanced the team's productivity, improved accuracy in financial reporting, and allowed the company to reallocate resources to more strategic tasks. The successful deployment of this tool demonstrated the value of automation in routine processes and laid the groundwork for future automation projects within the company.

Frameworks

Over the course of my academic career I have come across various frameworks and languages. Some of which that I am proficient at are listed below
c svg
css svg
cuda svg
django svg
docker svg
c svg
css svg
cuda svg
django svg
docker svg
git svg
html svg
java svg
jsp svg
mysql svg
git svg
html svg
java svg
jsp svg
mysql svg
numpy svg
panda svg
php svg
python svg
tableau svg
xampp svg
numpy svg
panda svg
php svg
python svg
tableau svg
xampp svg

Projects

Gen Z vs Gen X

Conducted an analysis of Spotify’s data on the music listening habits of Generation Z and Generation X, discovering intriguing differences and patterns

Pondr

Developed Pondr, a discussion forum website inspired by Reddit and HackerNews, in a 3-person group project for a Web Development class

Tixx

Developed Tixx, a web application for event organization and attendance, in a 5-person team for a Software Engineering class using the Django framework

107 Frogs

Developed a web store for selling frogs in a 2-person group project for a Databases (DBMS) class

Any Inquiries? Reach Out!