Software Developer
ICC Loyalty
05.2023 - 08.2023
- Achievement: Automated Loyalty Bonus Validation with Python Scripts
Description: Engineered Python scripts automating the validation of loyalty bonus points by extracting user profiles and transactions from the MYSQL database, and dispatching SQL validations to the team via daily email. This initiative resulted in an impressive 80% reduction in processing time, shifting the team's role from manual validation to efficient result oversight.
Technologies Used: Python, MySQL, Email Integration
- Achievement: Streamlined Report Retrieval with Spring Boot REST APIs
Description: Crafted JSON REST APIs using Spring Boot, enabling relationship managers to instantly download required reports with a single click. This innovation eliminated the need for manual report retrieval, reducing dependencies on colleagues and enhancing workflow efficiency.
Technologies Used: Spring Boot, JSON, MySQL
- Achievement: 50% SQL Processing Time Reduction
Description: Optimized a critical SQL script, slashing processing time by 50%. Restructured data retrieval using AUTO-generated IDs and custom logic for faster access. Introduced a well-indexed temporary table, enhancing query execution speed. Collaborated with the database team to fine-tune performance.
Impact: Significantly improved system efficiency, resulting in quicker data retrieval, better application performance, and cost savings.
Technologies Used: MySQL, Query Optimization
- Achievement: Automated Profile & Transaction Generation
Description: Developed a Python script automating user profile and transaction request generation, mimicking real-world scenarios. Routed requests to a REST API microservice, skillfully parsing JSON responses for precise failure categorization and streamlined troubleshooting.
Technologies: Python, REST API, JSON Parsing
