• Designed, developed, and troubleshooted application code for an Ed-tech product by implementing feature based solutions to complex technological problems for a customer base of around 300K+ active users.
• Built various kinds of import and partial import features for inserting the data into the DB with auto detection of file type, by using batch processing techniques and cron jobs along with validations and error handling.
• Collaborated on identity and access management for displaying content and features based on the user roles.
• Composed complex calculations for child progress and playtime reports and customized dynamic graph report generations based on various filtering parameters.
• Improved dashboard latency by 15% by implementing pagination in javascript and adding indexes to DB tables.
• Optimized complex SQL queries for increasing speed and efficiency of database functions resulting in reducing load times for various modules by approximately 14%.
• Remodeled the relationships between tables to cater to ever increasing user roles and functionalities.
• Mentored and onboarded 3 college graduates while working in an agile process and following scrum principles.