Apoorv Mehrotra
**** *, ***** ****** *** *** San Jose - CA 95112
Æ +1-669-***-**** • Q ******.************@*****.*** • MehrotraApoorv
ApoorvMehrotra0706
Education
MS Software Engineering GPA 3.74/4.0 Jan 2020 - Dec 2021 San Jose State University, San Jose, CA
B.Tech Electrical Engineering GPA 3.7/4.0 Sep 2009 - June 2013 Uttar Pradesh Technical University, Lucknow, India Skills
+ Language: Java, Perl, Python, JavaScript, HTML, CSS
+ Frameworks: Node.js, React, Redux, Express, MVC, Spring-boot, Bootstrap, REST API
+ Tools: Perforce, Eclipse, Visual Studio Code, MySQL WorkBench, Intellij IDEA, GitHub, PuTTy
+ Cloud: Google Cloud Platform, IBM Cloud, AWS, Docker
+ Other: Apache Kafka, Apache Zookeeper, JMeter
Experience
Teaching Assistant Aug 2020 - Present
San Jose State University, San Jose, CA
+ Guided students with their queries in coursework for Operating System and Enterprise Distributed System
+ Assisted in grading the assignments and providing feedback to students Information Technology Analyst Mar 2014 - Dec 2019 Tata Consultancy Services, Lucknow, India
+ Headed the Perl automation team of 10 members, and, individually automated new scripts
+ Developed new RESTful APIs to support the migration of the content to cloud
+ Built new modules following design pattern to provide better code maintenance
+ Created APIs using Java and Spring-boot framework
+ Wrote new Continuous Integration Test suites thus helped in code integration testing within a few hours
+ Achieved the goal of stabilizing the regression cycles, thus resulting in 4 times faster delivery of phases Projects
Currency Remittance Nov 2020
Technologies used: React, Redux, Java, Spring-boot, Hibernate, MVC, MySQL, AWS EC2, Heroku
+ Designed the backend using Spring-boot framework for SQL query handling
+ Contributed to designing of the frontend using React and Redux
+ Concatenated text and mail services using SMTP server
+ Provided features like offer posting, negotiations, sending emails and money transactions Glassdoor Prototype Nov 2020
Technologies used: MySQL, MongoDB, Express, Node.js, React, Redux, Passport, JWT, AWS EC2
+ Utilized Redis caching service to speed up the system response.
+ Scaled the setup using auto-scaled AWS cluster to handle an enormous network traffic
+ Implemented Kafka Messaging Queue between the backend APIs and Database calls for high throughput
+ Incorporated role based access management throughout the portal Yelp-Prototype Sept 2020
Technologies used: React, Node.js, MySQL, MongoDB, Kafka, GraphQL, AWS EC2
+ Designed a working prototype of Yelp website using MERN stack
+ Incorporated MongoDB and Kafka Messaging queue to scale up the system
+ Wrote re-usable code for food ordering,menu handling, and review section Achievements
COCO-LVIS 2020 challenge completion, Star Performer, Technical Excellence Award