Sijia Xu

Company Overview: Praemium is an Australian fintech firm providing an integrated investment platform for portfolio management and data analytics.

• Developed and maintained data interaction modules for a data monitoring system using Angular, AngularJS, and .NET (C#, VB.NET), including real-time data visualisation, authentication enhancements, and performance tuning.
• Integrated JavaScript charting libraries (Chart.js) into the Angular-based system, improving user experience and data clarity in batch data visualisation.
• Helped operate and maintain a cloud-based application built with Apache Airflow, AWS, and a Python backend, focusing on optimising workflows, monitoring performance, and resolving issues.
• Built and managed an automated Slack messaging system using Microsoft Logic Apps to improve internal communication efficiency, and ensure timely delivery of error notifications.
• Contributed to identifying and resolving security vulnerabilities in Praemium's .NET-based core platform (C#, VB.NET), improving authentication security and application robustness.
• Optimised SQL Server performance by rewriting inefficient queries, redesigning indexes, and normalising database structures, while also applying hashing to minimise user privacy risks.
• Investigated and remediated security vulnerabilities (e.g., CSV and SQL injection); implemented unit testing with MSTest; and conducted functional testing to improve software reliability.
• Created well-structured documentation for new features and monitored common issues to support continuous system improvement.
• Participated in Agile retrospectives and regularly took on hosting duties to support open dialogue and team growth.

Company Overview: Jobpin is a global recruiting company based in Australia, specialising in IT recruitment and connecting skilled candidates with employers.

• Developed web application features in an Agile team using React and Umi.js on the frontend, Spring Boot on the backend, and PostgreSQL as the main database.
• Participated in Agile meetings with BA and UI/UX designers to clarify requirements, using Jira for task tracking and sprint management.
• Developed responsive and user-friendly interfaces based on Zeplin UI designs.
• Designed and maintained database schemas; used Flyway for managing version-controlled database migrations.
• Redesigned tables and optimised entity relationships to improve performance for question-answer functionality.
• Managed frontend state and data flow using Redux; implemented candidate management features with React and Ant Design.
• Helped maintain and configure CI/CD pipelines using Jenkins, ensuring reliable build and deployment processes.