Killadi Venkata jai Santeswar

Software Engineer

Loyatly Juggernaut Inc.•  June 2023 - Present•  Hyderabad

Engineered an automated utility for large-scale data migration, efficiently processing nearly 150 million records and achieving a 50% reduction in migration time through optimized SQL queries, Python scripts, and effective chunking strategies. Streamlined the Django-based backend for loyalty programs by enhancing transaction processing capabilities, resulting in a 30% faster post-transaction time and ensuring precise management of user balances across over 1 million active accounts. Implemented real-time fraud detection and alerting systems, enhancing security and reducing fraudulent activity by identifying and addressing suspicious behavior, with automated email notifications to clients improving incident response time by 30%. Consolidated third-party subscriber services, achieving synchronized and efficient user communications, and improving overall user experience. Performed regular code reviews, ensuring 100% adherence to data integrity and system reliability while promoting best practices in software development.

software Engineer Intern

Loyalty Juggernaut Inc.•  January 2023 - May 2023•  Hyderabad

Developed a utility to facilitate the thorough deletion of client user data from PostgreSQL and AWS DynamoDB databases. Optimized SQL queries to streamline the efficient large-scale data removal of up to 2 million records, achieving completion within hours while ensuring both speed and accuracy. Applied advanced techniques to uphold data integrity and accelerate the deletion process for over 1 million records. Enhanced database management by reducing the time required for data purging by 50%, resulting in a 40% increase in overall operational efficiency and ensuring compliance with data retention regulations.