Visa Inc. | Software Engineering Intern
May 2024 - August 2024 | Atlanta, Georgia
- Utilized Apache Kafka to migrate 4 disparate MS SQL databases into a unified MySQL data warehouse, improving data accessibility and reducing query response times by 30%
- Employed Grafana to develop 3 interactive dashboards, leveraging MySQL data warehouse queries to visualize key performance metrics, enhancing data-driven decision-making processes across multiple teams
- Integrated Prometheus for real-time metric collection using PromQL, expanding monitoring capabilities and creating 5+ additional dashboards that improved system performance insights by 30%
- Developed a Python API to directly access and extract information from Grafana dashboards, enabling automated data analysis and reporting, which reduced manual reporting efforts by 25%
USAA Inc. | Software Engineering Intern
May 2023 - August 2023 | Dallas, Texas
- Engineered a new algorithm and feature using Java and Spring Boot, enhancing the enrollment flow process for new users, saving the company an estimated $50,000 per quarter
- Developed a RESTful API that allowed for the automatic generation of Service Now tickets based on information obtained through the new enrollment algorithm, reducing support time by 70%
- Built an asynchronous process with Spring Boot to identify enrollment mismatches in databases and automatically generate support tickets via the API
- Utilized Mockito to conduct extensive testing and debugging on newly created features, writing over 30 unit, integration, and mutation tests, achieving 100% code coverage
Power Banks Depot | Software Engineering Intern
May 2022 - August 2022 | Houston, Texas
- Spearheaded online operational improvements to increase profitability (shipping API integrations, customer portal buildout, sales tracking, back-end invoice tracking, and routing buildout)
- Programmed an intensive site tracking tool that tracked customers through their order process and enabled management to visualize gaps in marketing and critical touchpoints increasing customer conversion rate by 12%
- Refined and created a set of SQL queries to allow for the more efficient retrieval of customer data and records, decreasing query time by 15%
- Conducted a SPIKE on new ways to increase customer return rate and used this information to develop a program that gave targeted pop-ups to customers