Jul 2023 – Jun 2025 · 1 yr 11 mos · Bengaluru, Karnataka, India · On-site

• Architected and implemented a high-throughput data ETL pipeline for realtime analytics of workflows in 1-click checkout.
• Utilizing Apache Kafka for log aggregation, engineered a Sessionizer microservice to segregate logs by sessionIDs with sub-second latency which is capable of processing over 1 million logs per hour.
• Integrated Clickhouse Database to store and retrieve data by implementing Kafka engines, which significantly improved data duplication and query performance by 60 percent.
• Collaborated with the payments team to integrate prepaid payment instruments into our checkout system, enabling support for applying promotional offers. This integration enhanced the payment flexibility and provided a seamless user experience during the checkout process.
• Developed a rule engine that blocks payment methods in UI based on metrics such as customer, offer, shipping, and other factors.
• Migrated clickhouse from Kubernetes to EC2 while increasing performance and decreasing cost.

Jan 2022 – Jul 2022 · 6 mos · Lucknow, Uttar Pradesh, India · Remote

• Designed RESTful API Architecture: Developed RESTful APIs for user authentication, question posting, answering, commenting, and voting features similar to Stack Overflow.
• Implemented User Authentication and Authorization: Integrated secure authentication (JWT, OAuth) and role-based access control for different user types (admin, moderator, user).
• Database Schema Design: Designed a relational database schema using PostgreSQL/MySQL to handle users, questions, answers, comments, and votes with efficient indexing.
• Implemented CRUD Operations: Created backend services for creating, reading, updating, and deleting (CRUD) questions, answers, and comments using Node.js/Express.
• Handled Pagination and Search: Developed efficient pagination and search functionalities for retrieving questions and answers, supporting advanced search filters like tags and keywords.
• Vote and Reputation System: Implemented a voting system (upvote/downvote) and reputation algorithm to incentivize user participation and reward contributions.
• Optimized Database Queries: Utilized indexing and query optimization techniques to enhance performance and reduce query execution time for large datasets.
• Handled Concurrency and Scalability: Implemented concurrency handling mechanisms to manage multiple simultaneous user actions, ensuring the platform’s scalability.
• Error Handling and Validation: Integrated comprehensive error handling and data validation mechanisms to ensure robustness and prevent invalid data from being submitted.
• Implemented WebSocket for Real-Time Updates: Added real-time notifications using WebSocket for updates like new answers, votes, or comments on questions users are following.

Sep 2021 – Dec 2021 · 3 mos

• Created Problem Explanations: Wrote detailed explanations of competitive programming problems, breaking down the problem statements and explaining expected outputs and constraints.
• Authored Tutorials on Algorithms: Developed step-by-step guides for solving common competitive programming challenges using algorithms such as Dynamic Programming, Greedy Algorithms, or Graph Traversal.
• Provided Code Examples: Wrote and reviewed code snippets in popular languages (e.g., C++, Python, Java) to accompany problem solutions, ensuring they were efficient and optimized for time complexity.
• Explained Data Structures: Wrote articles on fundamental and advanced data structures like arrays, trees, heaps, and graphs, focusing on their application in competitive programming.
• Reviewed Problem Solutions: Analyzed and proofread solution approaches to common programming contests' problems, ensuring the accuracy of logic and clarity in explanation.
• Authored Complexity Analysis: Created content that explained time and space complexity for various solutions, helping readers understand the performance trade-offs.
• Created Contest Preparation Guides: Wrote detailed guides for preparing for programming contests like Codeforces, LeetCode, and TopCoder, including problem-solving strategies and practice tips.
• Collaborated with Developers: Worked closely with software developers or competitive programmers to refine content, ensure accuracy, and clarify complex problem-solving methods.
• Engaged in SEO Optimization: Ensured the technical articles were SEO-optimized to attract aspiring programmers looking to improve their competitive coding skills.
• Updated and Maintained Content: Regularly updated older articles and tutorials to reflect the latest trends and changes in competitive programming platforms and tools.

Feb 2021 – Dec 2021 · 10 mos

• Wrote 10+ articles on advanced data structures and algorithms.
• Link to profile -https://www.geeksforgeeks.org/user/vermaaayush68/