I am currently pursuing a Master's degree in Computer Science at Columbia University, set to graduate in 2024. With a relentless commitment to excellence, I bring 100% dedication to every project I undertake.My academic journey and professional experience have equipped me with proficiency in a diverse range of technologies including Python, Java, React, Django, Flask, MySQL, PostgreSQL, MongoDB, HTML5, and CSS. This foundation has empowered me to tackle various challenges in software development, data science, and beyond.I am particularly passionate about exploring the intersections of natural language processing, computer vision, and generative AI. Through my work, I aim to develop innovative solutions that address real-world issues, positively impacting millions of users.With a drive for continuous learning and a dedication to pushing boundaries, I am eager to contribute my skills and expertise to meaningful projects in the field.
-
Research AssistantThe Data Science Institute At Columbia University Oct 2023 - May 2024- Developed 10+ ETL data pipelines based on 3 GB DNA sequence data and improved data extraction rate by 18%.- Applied the FixMatch Semi-Supervised algorithm to successfully pseudo-label 2 GB of unlabeled & unbalanced data, reduced manual labeling time and increased raw data utilization rate by 40%.- Designed, implemented and trained a model combining a bidirectional LSTM Network and a CNN to predict whether a transcription factor combined with a given DNA sequence with 85% accuracy… Show more - Developed 10+ ETL data pipelines based on 3 GB DNA sequence data and improved data extraction rate by 18%.- Applied the FixMatch Semi-Supervised algorithm to successfully pseudo-label 2 GB of unlabeled & unbalanced data, reduced manual labeling time and increased raw data utilization rate by 40%.- Designed, implemented and trained a model combining a bidirectional LSTM Network and a CNN to predict whether a transcription factor combined with a given DNA sequence with 85% accuracy using PyTorch. Show less -
Software DeveloperCeridian Sep 2020 - May 2021Toronto, Ontario, Canada- Built a web portal featuring AI-assisted HR scheduling optimization and performance analytics with React & JavaScript.- Utilized Node.js, Express.js, JavaScript, HTML & CSS to implement RESTful services that generated 5000+ sales simulations based on Poisson distribution. (tested in Jest and Enzyme with 90% branch coverage).- Designed MongoDB NoSQL schemas to securely manage data for 4,000+ employees and 500+ schedules with fault tolerance and crash recovery mechanisms.- Automated… Show more - Built a web portal featuring AI-assisted HR scheduling optimization and performance analytics with React & JavaScript.- Utilized Node.js, Express.js, JavaScript, HTML & CSS to implement RESTful services that generated 5000+ sales simulations based on Poisson distribution. (tested in Jest and Enzyme with 90% branch coverage).- Designed MongoDB NoSQL schemas to securely manage data for 4,000+ employees and 500+ schedules with fault tolerance and crash recovery mechanisms.- Automated CI/CD pipeline (Maven and Gradle dependencies), saving 4 hours of manual testing and deployment per release.- Wrote unit and integration tests in JUnit with 80% branch coverage and deploying order execution services as Docker images. Show less -
Technology Summer Analyst, Software DevelopmentCiti May 2020 - Sep 2020Mississauga, Ontario, CanadaEnhanced the efficiency of COMET(Citi’s equity & derivative trading platform)’s order execution pipeline by optimizing algo-rithmic strategies in Java & RabbitMQ, increased daily executed orders from 270,000 to 310,000.· Orchestrated 3 event-driven microservices within a distributed system using Spring Boot, Docker & K8s for real-time pricefetching, order dispatch to stock exchanges, and order relay to settlement services, achieving 24/7 availability.· Integrated option & future… Show more Enhanced the efficiency of COMET(Citi’s equity & derivative trading platform)’s order execution pipeline by optimizing algo-rithmic strategies in Java & RabbitMQ, increased daily executed orders from 270,000 to 310,000.· Orchestrated 3 event-driven microservices within a distributed system using Spring Boot, Docker & K8s for real-time pricefetching, order dispatch to stock exchanges, and order relay to settlement services, achieving 24/7 availability.· Integrated option & future trading options into COMET and unlocked 6 new trading strategies.· Designed SQL relational schema, executed object-relational mappings with Hibernate to ensure seamless data management. Show less -
Research StudentUniversity Settlement Oct 2017 - Apr 2018● Analyzed University Settlement’s volunteer data collection practice. ● Along with other team members, researched for available open source solution and customized to the need of the organization which allowed volunteers to easily record their volunteer hours via computer or phone, and allowed the administrator to retrieve, edit and download volunteer information. -
Technical AnalystVancouver Community Network May 2017 - Aug 2017Vancouver, Canada Area● Participated in a project which built a resident management website for a local property management company.● Performed data cleaning/integration/normalization using Excel and Access; managed databases by creating or updating stored procedures and tables, and also supported monthly data refresh cycles.● Performed QA testing for the staging website. Identified, documented and reported bugs and worked with the web development team to solve those problems.● Actively communicated… Show more ● Participated in a project which built a resident management website for a local property management company.● Performed data cleaning/integration/normalization using Excel and Access; managed databases by creating or updating stored procedures and tables, and also supported monthly data refresh cycles.● Performed QA testing for the staging website. Identified, documented and reported bugs and worked with the web development team to solve those problems.● Actively communicated with different property managers to investigate the major pain points they experienced in current data management system and continuously improved on the system based on their feedback. Show less
-
Camp InstructorGeering Up Ubc Engineering & Science For Kids Jul 2015 - Aug 2015Vancouver● Instructed students with Minecraft programming activities and various other game development projects.
Erica Li Education Details
-
3.67 -
Point Grey Secondary
Frequently Asked Questions about Erica Li
What is Erica Li's role at the current company?
Erica Li's current role is MSCS student @ Columbia University | Currently enrolled in CodePath | Actively seeking 2024 new grad opportunities.
What schools did Erica Li attend?
Erica Li attended Columbia Engineering, University Of Toronto, Point Grey Secondary.
Not the Erica Li you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial