lokeshjha

Designed and implemented a Referral Program to increase new student registration. Developed a system that generates incentives and invoices on leads produced by different partners for various fields. Utilised advanced SQL queries and added checks to accurately track and verify referrals in a secure manner. Created and maintained a bulk student upload API and UI for seamless import and export of large volumes of student data. Secured old queries by rewriting them to protect against SQL injection, using Knex and Sequelize. Implemented asynchronous processing and error handling mechanisms in the API, managing up to 2 lakh leads per day.

Developed RESTful APIs using Node.js, Express, and MySQL for an employee communication system. Implemented APIs to send notices and letters to employees’ phones, improving communication efficiency. Used MySQL for secure storage and retrieval of employee data and hearing details, ensuring data integrity. Implemented version control using Git and employed Jenkins for CI/CD to automate testing and deployment processes. Achieved a significant reduction of 80% in paper usage by enabling SMS communication. Increased the response rate by 50% through the implementation of SMS notifications.