Yash Pokharna
Profile picture of Susim Mukul Roy standing in a field with trees in the background

MS Student

Santa Clara University

LeetCode GeeksforGeeks HackerRank

About Me

I am a Master of Science student in the Department of Computer Science at Santa Clara University. I thrive in solving complex problems and enjoy working in challenging environments. I have experience in full-stack development, primarily working with the MERN (MongoDB, Express.js, React.js, Node.js) stack. In addition to my development skills, I have a strong foundation in data structures and algorithms, with extensive experience in competitive programming. I'm passionate about building scalable applications, collaborating in fast-paced projects, and continuously expanding my technical expertise.

Interests

  • Web Development
  • MERN Stack
  • Database Management
  • API Development and Integration

Education

  • MS in Computer Science and Engineering, Present
    Santa Clara University, CA
  • B.Tech in Information Technology, 2023
    Vishwakarma Institute of Information Technology



Experience

Company logo Indexnine Technologies

Software Engineer

Jan 2024 – August 2024 · Pune, India

Responsibilities include:

  • Developed integrations for various applications using Node.js, Express.js, JavaScript, TypeScript, React.js, and MongoDB, including working with Zilla Security to scrape data using three methods: Zus, API, and CSV
  • Implemented auto-pagination with Puppeteer to scrape multi-page data, reducing user effort by 30%.
  • Built ZUS browser extension using Node.js and Cheerio for automated data extraction via unique attributes.
  • Utilized React.js and MongoDB to design and implement a user-friendly dashboard, enabling efficient visualization and management of extracted data.
  • Developed secure authentication with REST APIs and JWT, enabling role-based access control.

Company logo Aspect Ratio

Software Developer Intern

Sep 2022 – January 2023 · Pune, India

Responsibilities include:

  • Developed a full-stack SQL Query Automation Tool using React.js, Flask, JavaScript, and MySQL, enabling users to generate SQL queries through a drag-and-drop interface.
  • Implemented dynamic SQL generation with support for joins, aggregate functions, and clauses, allowing users to build complex queries within 20 seconds
  • Designed a seamless workflow for database connection, table selection, and data fetching directly from MySQL, providing real-time query results and CSV export functionality.

Company logo CDAC

Analyst Intern

Jan 2022 – May 2022 · Delhi, India

Responsibilities include:

  • Developed and optimized SQL queries to extract large datasets, reducing data retrieval time by 30% and ensuring data accuracy for further analysis.
  • Utilized Python and Power BI to create interactive visualizations, enabling stakeholders to gain insights from complex datasets and improving data-driven decision-making by 25%.
Projects


Project Image

SQL Query Automation.

SQL Query Automation - Visualize SQL queries in 20sec by just Drag N Drop.

Skills: Flask, Python, JavaScript, SQL, MySQL, HTML, CSS

Code
Project Image

Appointment Booking System.

The Appointment Booking System is a multi-panel platform enabling patients to book appointments with doctors, manage time slots, and make payments seamlessly. It provides doctors with tools to manage schedules and earnings, while administrators oversee system metrics and revenue.

Skills: React.js, Node.js, JavaScript, Express.js, MongoDB, Cloudinary, JWT, REST APIs

Code
Project Image

Wordle Game

Wordle Game - JavaScript

Code Game Link
Project Image

Restaurant Management System

The platform enables users to order food and book rooms online through a simple interface. It features a user panel for browsing restaurants, placing orders, and reserving rooms, while the admin panel manages listings, orders, and bookings.

Skills: JavaScript, PHP, MySQL, SQL, PhpMailer, HTML, CSS

Video Code
Project Image

Library Management System

A perfect Library Management System efficiently handles the cataloging, tracking, and issuing of books, ensuring seamless user access to resources while managing inventory and transactions. It simplifies administrative tasks, supports user management, and provides real-time data on availability, all in a secure, user-friendly interface.


Skills: NodeJS, ExpressJS, ReactJS, JWT Authentication, MySQL, SQL, NodeMailer

Code
Project Image

Student Managemnt System

A Student Management System with two panels, Student and Admin, allows students to view and manage their profiles, courses, and grades, while admins handle student enrollment, course assignments, and overall system administration. This system streamlines academic management and enhances communication between students and administrators.


Skills: PHP, MySQL, JavaScript, SQL

Code
Project Image

Password Generator

Password Generator - ReactJS Tailwind CSS

Code
Project Image

Rock Paper Scissor - JavaScript

A Stone Paper Scissors game implemented in JavaScript utilizes random number generation and conditional logic to simulate gameplay, dynamically updating the user interface to display results and determine the winner.

Code
Project Image

Dream 11 Team of the Year

A Dream11 Team of the Year project in Python allows users to create the ultimate fantasy sports team by analyzing player statistics, performance data, and optimizing team selection based on predefined criteria. This tool automates the decision-making process for fantasy sports enthusiasts.
Skills: Python, SQL, Pandas, Excel, PowerBI,Jupyter Notebook

Code
Project Image

YouTube Clone - JavaSript

A YouTube Clone project replicates core functionalities of the popular video-sharing platform, allowing users to upload, stream, like, and comment on videos. It includes features like user authentication, video recommendations, and responsive design to provide a seamless viewing experience.

Code

Contact Me

Linkedin
+1 (408) 581-2805
© 2024 Yash Pokharna.