< Azure Data Engineer />< Web Developer />< Competitive Programmer />

Rajat Agarwal.p

<About Me />
I'm an enthusiastic learner, dedicated coder, and proficient full stack MERN developer. My expertise lies in crafting code logics to solve complex problems. With a track record of solving over 1500+ problems on coding platforms like GeeksForGeeks, Codechef and HackerRank, I continually refine my problem-solving skills. Currently I'm employed as an Azure Data Engineer at Tata Consultancy Services, Kolkata
<Education />
Heritage Institute of Technology, Kolkata
Maulana Abul Kalam Azad University of Technology (MAKAUT)
Bachelor of Technology- Electronics & Communication Engineering
DGPA: 8.32
GRADE: A
Shree Jain Vidyalaya, Kolkata
West Bengal Council of Higher Secondary Education (WBCHSE)
Higher Secondary - Physics, Chemistry, Maths & Computer Science
PERCENTAGE: 86.2%
GRADE: A+
Shree Jain Vidyalaya, Kolkata
West Bengal Board of Secondary Education (WBBSE)
Secondary Examination
PERCENTAGE: 88.2%
GRADE: A+
<Skills />

Azure Data Engineer

Azure Data Factory
Azure Databricks
SQL
Python
ETL

★ Azure Data Engineer - Tata Consultancy Services, Kolkata

(Aug 2023 - Present)

Perform Extract, Transform and Load (ETL) to create pipelines and workflows using Azure Data Factory (ADF). Used Azure Databricks and SQL for Data Analysis. Used Logic Apps to implement automated alert emails.

Web Developer

ReactJS
NextJS
NodeJS
MongoDB
Express
JavaScript
TypeScript
Tailwind
React Redux
Postman

★ Web Developer Freelancer

(Dec 2022 - June 2023)

Contributed and collaborated in building a web-app from scratch. Implemented modal, pagination, loader, state management, most recent visited page scrolling & used optimization techniques like lazy loading, Redux, Socket.IO.

★ Web Developer Intern - Vedasis Analytics

(Oct 2022 - Nov 2022)

Worked on Frontend - NextJS. Used Hooks and Redux to create web components. Learnt Poject Collaboration with Git.

Competitive Programmer

C++
Data Structure
Algorithms

★ GeeksForGeeks practice

(Nov 2020 - Present)

Solved 1075+ problems on various DSA problems. Overall rank below 600 and institute rank - 3

☆ TCS CodeVita 2022 - Global rank 56

☆ CodeChef - Highest rating 1810

☆ HackerRank - Gold badges in problem solving & C++

☆ Infosys HackWithInfy - Qualified for PPI

<Projects />
Emotion Detection Using Neural Learning
RNN | Keras | Sklearn | Pandas | Numpy | Librosa
A group final year project. It can run to detect emotions for analysing audio files and detect the maximum probablity of emotion it resembles. The neural model is trained using RNN - long-short term memory (LSTM) technique.
Train Accuracy: 86.7% Test Accuracy: 66.7%
NoteIt - Note Keeping Application
React | NodeJS | MongoDB | Express | Bootstrap
NoteIt is a MERN full-stack web application software. Users can create, update, delete and read notes on the go. Used MongoDB database to perform CRUD operations. Express handles calling and sending of responses along with validation. Used useContext, useEffect, useState, useNavigate hooks in React. JWT Authentication of users is done for secure access. Passwords are stored using hashing and encrypted.
Task Manager - Backend
NodeJS | Express | MongoDB
A task manager backend application. Implemented basic api endpoints such as GET, POST, PATCH and DELETE. A user can read, add, update and delete notes created. Used express for managing routes and MongoDB Atlas as database.
ResDec - Resistor Decoder Application
React | CSS
Single page React application to decode the value of a resistor. Conversion from resistor color code and value. Fully responsive website.
TypeLit - Typing Practice Application
JavaScript | HTML | CSS
On Screen Keyboard indicating the typing letters. Simultaneous error detection while typing. Accuracy detection of typed words.