Johnathan Tse Email & Phone Number

Northbrook, Il, Us

- Collaborated in a 7-person team to build a web application that allowed over 5,000 insurance agents to manage their business needs, from voicemail configuration to office and team management.- Integrated a TypeScript/React frontend and a Spring Boot backend to automate service requests, thereby eliminating the manual approval process of ServiceNow tickets. This accelerated the approval process from days to a few minutes.- Spearheaded an ETL project with Python, Pandas, and SQLAlchemy to dynamically extract Parquet file data into a database, significantly boosting processing speed.- Applied Test-Driven Development (TDD) methodologies to maintain a high standard of code quality and reduce defects.- Implemented Docker containers for the Postgresql and MSSQL databases, enabling uniform local testing across team members' machines with different hardware architectures. Provided hands on support to team members in setting it up.

San Diego, Ca, Us

- Contributed to the development of the Mission Ready web app, aimed at providing clients with an intuitive inventory management system for their virtual machines, enhancing operational efficiency and resource utilization.- Designed UI wireframes so the development team and stakeholders could communicate and come to an agreement on what is to be developed.- Engineered robust API endpoints with Spring's Rest annotations (e.g., RestController, GetMapping, PutMapping), enabling seamless communication between frontend and backend systems.- Implemented Angular components and Ng-bootstrap modals, enhancing user interaction with API endpoints and fostering a user-friendly experience.- Unit tested rest controller using JUnit and Spring’s MockMvc.

Arlington, Virginia, Us

- Created entire virtual routing networks and demonstrated a working prototype to the team lead.- Analyzed an enterprise Java project and wrote code to patch security vulnerabilities like cross-site scripting and sql injection.

Rockville, Md, Us

- Automated report generation and data pipeline jobs using Python, resulting in products being delivered to clients several weeks ahead of deadlines.- Created business intelligence products using a variety of AWS tools including Athena, Quicksight, Lambda, Step Functions, and Fargate.- Improved React project by consolidating duplicate code into more reusable and maintainable components. This led to improved development speed and code quality.- Developed internal applications using Sqlalchemy and Flask, empowering analysts with enhanced data control capabilities and a more intuitive user experience.- Worked closely with product owners and analysts in a scrum/agile environment to ensure that the product being developed was in line with stakeholder expectations.- Greatly increased test coverage through unit and integration tests, ensuring code accuracy.

San Diego, Ca, Us

- Mentored 5 newer analysts in learning MySQL, database structure, and best practices for creating client reports.- Took a lead role in QA for coworker projects, giving the final sign off and ensuring report accuracy before sending to clients.