Responsibilities & achievements

• Improved database query performance by up to 20% by suggesting “Elasticsearch” instead of PostgreSQL full-text search • Improved the load times from 6s to 2s for end-users by optimizing the storage of media files through the integration of Amazon S3 and CloudFront services. (Used to store and retrieve large PDF documents) • Implemented AWS Lambda functions with Node.js to automate a few manual processes, resulting in significant time savings and improved accuracy of data processing • Made the code reusable by using the "bridge" design pattern for the core functions so that the functionalities can be extended

Responsibilities & achievements

• Contributed to the open-source community by developing a stateless web application that performs sentiment analysis on cryptocurrency-related Twitter data. • Created Lambda functions to update Redis and S3 for analysis of new tweets • In charge of providing scalability, speed, and user-friendliness in order to deliver optimal results • Optimized the application's performance using AWS S3 for efficient storage and faster website speed • Implemented search functionality with Elasticache, and we set up a load balancer and auto-scaling group on AWS to ensure the application scales according to traffic and distributes incoming traffic evenly among the instances • Implemented a home page that allows users to select a cryptocurrency and view sentiment data, displaying positive, negative, and neutral sentiment scores, average scores, and keywords • Included a pagination feature built with React.js that allows for easy navigation through multiple pages of tweets Techonogies: Object-Oriented Programming (OOP) · Full-Stack Development · SQL · Redis · Amazon Web Services (AWS) · TypeScript · React.js · Node.js

Responsibilities & achievements

Responsible for optimizing and refactoring the architecture of the product. This included creating complex queries, improving database performance, and redesigning the reporting system for faster execution times. • Reduced reporting time from 45 minutes to 2-3 minutes by using caching mechanisms using Redis and proper design patterns • Converted data from Excel tables containing employee entry and exit times to a concise report format using PostgreSQL, providing clear insights to the managers and the CEO • Executed entity modeling in SQL database with create and update tables, and also stored procedures • Created complex queries for generating complex reports

Responsibilities & achievements

• Improved the website's performance by decreasing the first page load time from 20 seconds to almost instantaneous, through the implementation of Redis caching • Added a subscription system to the project using complex queries in MongoDB's aggregate with Mongoose ORM in order to achieve a B2B business model. (Since Lausof offers bus rental to other tourism agencies) • Optimized SEO of React app by up to 40% by migrating to Next.js framework, changing the server data fetching process, implementing dynamic routing, adding meta tags, and optimizing images • Analyzed the Next.js application and introduced an atomic design approach to divide it into more reusable parts. This resulted in a significant reduction of the JavaScript bundle size, with each page experiencing up to a 30% to 50% decrease. This approach enabled on-demand serving of these components, improving the overall performance and user experience ✓ Resulted in 8 new agency customers for Lausof, making 200%+ profits per month.

Responsibilities & achievements

• Improved database query performance by up to 20% by optimizing query parameters and reorganizing indexes to minimize execution time • Developed 160 reusable restful APIs for the company's project using Express.js and MongoDB in 4 months • Improved data ingestion and insights by integrating various third-party APIs and services, such as payment gateways (Mercado Pago), messaging platforms (SMS, Gmail), and code-tracking tools (Sentry). This enhanced functionality and improved the user experience for Lausof customers, resulting in increased user engagement and satisfaction.