◦ Enhanced Data Processing and PDF Generation: Developed a back-end query to fetch user details and send

it as Blob, converting it to JSON for seamless PDF downloads, improving report generation efficiency by 20%.

◦ Optimized Backend Performance: Designed and optimized Node.js APIs, reducing data retrieval times by 30%

and improving SQL query efficiency by 85% through bulk operations and Prisma transaction optimizations.

◦ Introduced an employee archive functionality: Developed an employee archive functionality allowing admins

to remove old employee data from the organization, reducing database clutter by 20%.

◦ Streamlined data export functionality: by crafting APIs to retrieve employee data, convert it to Excel, and

enable downloads improving accessibility for User by 40%.

◦ Created 5+ role-specific dashboards for admin and other roles, enhancing user experience by providing

tailored features and functionalities based on user roles.

◦ Designed and implemented a scheme for video and category mapping, Developed a frontend to display videos based

on features assigned to user roles, leading to a 60% increase in user satisfaction.

◦ Engineered a Chrome extension for automated data scraping, elevating team productivity by 90%.

◦ Built a recursive horizontal chart to visualize deeply nested objects, supporting debounced search, adjustable

widths, and improving rendering speed by 30% via lazy loading for optimized performance.

◦ Created a Table component with features such as sorting, filtering, and drag-and-drop column reordering,

improving data management efficiency by 40%.

◦ Architected employee review system by designing RESTful APIs for competency and review data utilizing SQL

CTEs and JSON aggregation for effective hierarchical data management cutting review processing time by 35%.

◦ Built async task management system to eliminate timeout errors for long-running SQL reports and data

scripts, reducing request failures from 60% to 5% and enabling processing of tasks up to 30+ minutes

◦ Developed comprehensive employee progress tracking system with timeline visualization and real-time

activity monitoring, enabling managers to track 100+ development activities and reduce review time by 45%

◦ Built self-service reporting system with templated SQL queries and async processing, enabling users to

generate custom business reports independently, eliminating 100% dependency on manual data extraction and

supporting 15+ report types

◦ Technical Stack: TypeScript, NextJs, React, Redux, Node.js, PostgreSQL, Prisma, GitHub, MUI