Rodrigo He

Work Experience

ETL Developer, Co-op

Victoria, BC

BC Pension Corporation

May 2023 - Dec. 2023

  • Engineered and deployed ETL pipelines, ensured seamless integration of new data sources using MS SQL Server and SSIS
  • Optimized daily ETL completion by 28% (2.5 hours) by restructuring job execution order based on dependency analysis
  • Designed, developed, and debugged new and existing procedures and views using T-SQL to enhance database functionality
  • Developed, tested, and implemented PowerShell and Python automation scripts, streamlining workflows for the Analytics team
  • Partnered with Data Scientists and Analysts to enhance data quality and usability across key data-warehouse dimensions
  • Authored comprehensive onboarding materials for ETL interns, covering coding standards, deployment procedures, and proprietary tools

Technical Business Analyst, Co-op

Victoria, BC

BC Investment Management Corporation

Sep. 2022 - Apr. 2023

  • Developed and delivered bug fixes and additional features for various financial valuation applications built on the Appian low-code platform, enhancing functionality and ensuring alignment with business needs
  • Collaborated with cross-functional stakeholders to gather requirements, and implement tailored technical solutions
  • Delivered system solutions to clients through clear verbal communication and well-structured documentation, securing consensus for application enhancements and issue resolutions
  • Authored and maintained operational support models and technical user guides using Jira and Confluence, ensuring seamless knowledge transfer and system continuity
  • Participated in Agile development cycles to manage user stories and tasks, supporting Product Owners in maintaining prioritized and actionable backlogs

Projects

VikesPlace

FastAPI, ElasticSearch, Kafka, MongoDB, PostgreSQL, Neo4J, Docker

  • Developed a full-stack marketplace application, modeled after Facebook Marketplace, exclusively for UVic students
  • Implemented advanced search functionality using the ELK stack (Elasticsearch, Logstash, and Kibana)
  • Containerized application components with Docker to improve maintainability and ensure cross-environment compatibility
  • Designed and built a custom recommendation system leveraging Neo4J and Elasticsearch, providing personalized recommendations based on user browsing history and proximity

MisterED - The One Piece

Flask, React, MS SQL, Docker, Azure

  • Developed a microservice-based application to manage waitlists for a mock Emergency Department, leveraging Python (Flask) for the backend and React for the frontend
  • Implemented containerized deployment using Docker and Azure Service App, integrating Azure SQL Database for scalable cloud hosting
  • Enhanced system modularity and maintainability by adhering to microservice architecture principles

CLI Secure Messaging

Python, Git

  • Designed and developed a secure command-line messaging application with end-to-end encryption using Python, ensuring confidentiality and integrity in real-time communication
  • Implemented Signal's Extended Triple Diffie-Hellman (X3DH) and AES-GCM, supporting perfect forward secrecy
  • Simplified user experience by building CLI commands for seamless message sending, receiving, and key management

Skills

  • Languages: Python, Java, TypeScript/JavaScript, C, HTML, CSS
  • Technologies: Flask, FastAPI, Docker, Micrsoft SQL Server, PostgreSQL, REST, MongoDB, MySQL React.js, Next.js, Pytest, JUnit, Selenium, scikit-learn, Appian, ELK
  • Developer Tools: Git, VS Code, Subversion, LaTeX, Postman, Jira, Confluence

Education

University of Victoria

Victoria, BC

Bachelor of Software Engineering

2018 - 2024

Relevant Courses: Data Structures and Algorithms, Artificial Intelligence, Database Systems, Data Mining, Systems for Massive Datasets, Software Testing, Security Engineering, Computer Vision, Blockchain Technologies