Zekun Yan
Melbourne,VIC
Summary
Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
2
2
years of professional experience
Work History
Software Engineer Intern
DBXB ANY Pty Ltd.
10.2024 - Current
- Administer and maintain SQL Server databases in both production and development environments.
Perform regular data backups, restorations, and disaster recovery planning to ensure data integrity and business continuity.
Monitor and troubleshoot database health, resolving issues related to performance and connectivity. - Develop, optimize, and debug complex SQL queries, stored procedures, and functions.
Design and implement efficient database schemas and tables to meet business requirements.
Analyze and optimize query performance, including indexing and execution plans. - Created and managed ETL workflows to extract, transform, and load data between systems.
Generate and automate reports to support business decision-making. - Worked with development teams to integrate database solutions into applications and tools.
Provide database support, documentation, and guidance to other teams as needed. - Use scripting languages such as Python or Bash to automate routine database operations and reporting tasks.
- Worked with design teams and Senior Software Engineers to build customized software products for consumers.
Junior Software Engineer
Itentube
11.2023 - 08.2024
- Configured a complete Airflow container suite using Docker Compose, including PostgreSQL, Redis, Scheduler, Web, and Worker components
- Created Docker Compose files to define images, environment variables, dependencies, and network configurations
- Configured ClickSend environment variables for scheduling important user notification emails to enhance user engagement and retention, and integrated ClickSend API credentials into Airflow configuration files to ensure secure and reliable email functionality
- Designed multi-stage Python scripts as Directed Acyclic Graphs to filter registered users from the database, including a DAG with data extraction, data cleaning, and email sending tasks, and used task queues for information transfer to ClickSend
- Deployed Apache Airflow on Kubernetes using custom values.yaml files in Helm Charts to ensure high availability and scalability, crafted values.yaml files, defined resource quotas, node selection, and persistent storage configurations, and managed Airflow installation and upgrades via Helm
- Developed HTML email templates for specific users, used Jinja2 for dynamic content generation to enhance email personalization and user experience, and created Jinja2 template files with dynamic variables for personalized welcome emails, promotional emails, etc
- Analyzed and optimized existing workflows to improve performance and reduce resource consumption, employed techniques such as parallel task execution, SQL query optimization, and task scheduling adjustments
- Engaged in code reviews to uphold code quality and system security, delivered constructive feedback through Pull Requests and Code Review processes, promoting code standards
- Languages: Python | Containerization: Docker, Docker Compose | CI/CD: GitLab Scripting: Bash Script | Kubernetes: Minikube, kubectl, Helm | Notification Services: ClickSend | Template Engine: Jinja2 | Databases: PostgreSQL, Redis | Front-end Development: Vue.js
- Analyzed code defects and failures and presented code refactors and design fixes.
- Assisted development of technical documentation and revised documentation.
Backend Developer
TripTribe
09.2023 - 01.2024
- Used Express.js as the HTTP server framework for Nest.js to handle file upload requests
- Utilized Multer middleware to parse multipart/form-data requests, ensuring efficient and secure file uploads
- Integrated AWS SDK with the service to interact with S3
- Developed service classes using the AWS S3 client to upload, retrieve, and delete image files, ensuring the reliability and scalability of file storage
- Used Mongoose to connect to and operate MongoDB, recording image information returned by S3
- Created and managed MongoDB models to record metadata of user-uploaded files, such as filename, URL, and upload time
- Separated services and controllers to ensure code readability, maintainability, and reusability
- Defined independent service classes to handle business logic, while controller classes managed request and response mapping
- Defined data transfer structures using DTOs for file upload format and size, ensuring class instances could access and set buffer properties
- Used class-validator and class-transformer for data validation and transformation, ensuring data integrity and security
- Used Nodemailer to send emails with activation links for user registration, ensuring timely account activation
- Configured Nodemailer to use an SMTP server, developed service classes to generate and send activation emails, including the activation link and instructions
- Used JWT to generate tokens with a3-day expiration for user activation link verification, ensuring security and timeliness
- Developed service classes to generate JWT tokens with expiration times, including user ID and other necessary information, and verified token validity when users clicked activation links
- Used GitHub Actions workflows to automate the deployment of the Nest.js application to AWS Elastic Beanstalk
- Wrote CI/CD configuration files to define the code build, test, and deployment processes, ensuring automatic deployment on each code commit, improving development efficiency and deployment reliability
- Languages: TypeScript | b MongoDB | Frameworks: Nest.js, Node.js, Express.js | File Handling: Multer | Email Service: Nodemailer | Authentication: JWT | Automated Deployment: GitHub Actions, AWS Elastic Beanstalk | Cloud Services: Amazon S3, AWS SDK | Database ODM: Mongoose | Data Validation and Transformation: class-validator, class-transformer
DevOps Engineer
China Software Testing Center
02.2023 - 07.2023
- Improved code deployment efficiency by automating processes with CI/CD pipelines.
- Maintained version control systems like Git or SVN for seamless collaboration among developers and engineers during project lifecycles.
- Automated manual tasks through scripting languages such as Python or Shell, boosting team productivity levels.
- Designed and implemented containerization strategies using Docker and Kubernetes, improving resource utilization and management.
- Monitored automated build and continuous software integration process to drive build/release failure resolution.
- Contributed to the creation of a DevOps culture within the organization, leading to increased agility and cross-functional collaboration.
- Tested and deployed scalable and highly available software products.
Education
JR Academy boot camp
Melbourne, VIC02.2024
Master of Computer Science - Network and Information Security
University of Wollongong
12.2022
undefined
Chengdu University of Information Technology
08.2019
Skills
- Python, JavaScript, TypeScript, Bin Bash
- Docker
- Frame: Django, NestJs
- Containerize: Docker, Kubernetes, OpenShift
- Git: GitLab, GitHub
- AWS: Lambda, SQS, IAM, EC2, LoadBalancer, S3, CloudFormation, DynamoDB, API Gateway
- SQL Server, SQL Server Management Studio (SSMS)
- Trouble Shooting
- Software development
- API integration experience
- Software engineering
- Code review practices
Languages
Chinese (Mandarin)
Native or Bilingual
English
Full Professional
Timeline
Software Engineer Intern
DBXB ANY Pty Ltd.
10.2024 - Current
Junior Software Engineer
Itentube
11.2023 - 08.2024
Backend Developer
TripTribe
09.2023 - 01.2024
DevOps Engineer
China Software Testing Center
02.2023 - 07.2023
Master of Computer Science - Network and Information Security
University of Wollongong
undefined
Chengdu University of Information Technology
JR Academy boot camp
Similar Profiles
Collins ChellaswamyCollins Chellaswamy
Senior Manager, Quality Assurance at Dun And Bradstreet (DBXB ANZ Pty Ltd)Senior Manager, Quality Assurance at Dun And Bradstreet (DBXB ANZ Pty Ltd)
Mekondjo JohannesMekondjo Johannes
Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)
Mekondjo JohannesMekondjo Johannes
Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)Human Resources Superintendent at Blue Sea Fishing Company (PTY)Ltd, Pereira Seafood Company (PTY)Ltd, Hatutungu Fishing Company (PTY)