Zihan Lin
Summary
Computer & Information Technology and Statistics junior seeking internship opportunity to learn and grow industry experience and contribute with technical skills.
Overview
1
1
year of professional experience
1
1
Certification
Work History
SQL Youtube Database
09.2022 - 12.2022
- Designed and implemented SQL queries for reporting and complex solution development.
- Maintained complex SQL queries, views and stored procedures in multi-database environment to store, manage and analyze user preferences.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
Linux Webpage Design
09.2022 - 12.2022
- Installed system-wide hardware components, confirming interoperation and compatibility with Linux-based softwares.
- Provided input on hardware and software purchasing, prioritizing return on investment to optimize IT spending.
- Developed organization-wide administration policies to encourage continuity across multiple systems and facilities.
C Laguage
01.2022 - 03.2022
- Used C Language to build a self-identified translator and a scientific calculator in one convenient extension tool with an A grade
System Administration
08.2021 - 12.2021
- A group project of 3 people which interacts with Microsoft Windows System Administration with user authentication policies, roaming profiles, folder redirection and networking
- I created several virtual machines within the same domain and successfully applied the folder redirections.
JAVA
11.2021 - 12.2021
- Using Java to create a scientific calculator with GUI, which could be displayed and used as a digital calculator on a computer for convenience with an A+ grade
SQL Database
Geta’s Gym
09.2021 - 12.2021
- A group Oracle project of 4 people which built a database that was created and managed with all data of Gym consumers, coaches, products, and payments
- In which I helped build the DDL script, insert records, and ensure data integrity.
Raspberry Pi
03.2021 - 04.2021
- Built a VPN using Raspberry Pi to access the campus network, and a network-wide ad blocker with an A grade.
Education
Bachelor of Science - Computer & Information Technology - Information Technology / Statistics
PURDUE UNIVERSITY
Skills
Strong SQL, R Language, Java, Python, C Language, Linux, Microsoft Access, Microsoft Excel, Arduino, Visual Paradigm
Certification
Arduino Programming Certificate
· Supported by Purdue University for participants who are able to code with Arduino. Tests for getting the certificate includes designing distance measurement monitor, lighting sensor and LED sound player.
Data Science & Business Analytics (In Progress)
· Supported by Purdue University. Certificate holders must complete a 6-8 month professional program with the training of R Language, Tableau, Python, SQL, and pass examinations.
Honors
Dean's List - 2020 FALL ; 2021 SPRING ; 2021 FALL ; 2022 SPRING; 2022 FALL
Working Experience
Student Associate, LAWSON ON-THE-GO, Aug 2022 – Present
· Managing utilities and food storages for the entire dining court, taking orders, serving food and drinks.
Student Management Associate, Hall of Music, Sep 2022 – Present
· Participating in sports events, campus festivals and other performances. Helping with setting up and controlling stage digital sound and lighting system.
Student Associate, EARHART DINING COURT, Sep 2021 – May 2022
· Managing food storages, arranging utilities backups for part of the dining court sections.
Languages
Chinese (Mandarin)
Native or Bilingual
Timeline
SQL Youtube Database
09.2022 - 12.2022
Linux Webpage Design
09.2022 - 12.2022
C Laguage
01.2022 - 03.2022
JAVA
11.2021 - 12.2021
SQL Database
Geta’s Gym
09.2021 - 12.2021
System Administration
08.2021 - 12.2021
Raspberry Pi
03.2021 - 04.2021
Bachelor of Science - Computer & Information Technology - Information Technology / Statistics
PURDUE UNIVERSITY
Similar Profiles
Mohanad Abdel-RahmanMohanad Abdel-Rahman
Academic Peer Tutor at NAAcademic Peer Tutor at NA
Shlomo JaffeShlomo Jaffe
Highschool Math Tutor at NAHighschool Math Tutor at NA
CLÉLIA CROZE-LABBECLÉLIA CROZE-LABBE
Baby sitter at NABaby sitter at NA
Jaylen Tindale-SeymourJaylen Tindale-Seymour
Property Maintenance at NAProperty Maintenance at NA
Richard SmithRichard Smith
<ul><li>Writing code for creation, deployment, maintenance, and enhancement of mobile apps, windows apps, and Web services, with Agile-SCRUM methodology.</li><li>Providing support for applications and end-users including software support, understanding end-users needs of the software and identifying either software or process improvements to enhance productivity.</li><li>The creation, deployment and maintenance of reports using MS SQL Server and Crystal Reports.</li><li>Creation and maintenance of MS SQL database. The writing, debugging and deployment of stored procedures and functions within SQL. Creation and updates on tables and data.</li><li>Evaluating, modifying, testing, debugging, and implementing existing software applications, modules, and systems in order to effectively maintain data integrity, optimize system performance, and output accuracy.</li><li>Provided production support and enhancements to both Legacy software systems and new applications.</li></ul> at FasTraxPOS<ul><li>Writing code for creation, deployment, maintenance, and enhancement of mobile apps, windows apps, and Web services, with Agile-SCRUM methodology.</li><li>Providing support for applications and end-users including software support, understanding end-users needs of the software and identifying either software or process improvements to enhance productivity.</li><li>The creation, deployment and maintenance of reports using MS SQL Server and Crystal Reports.</li><li>Creation and maintenance of MS SQL database. The writing, debugging and deployment of stored procedures and functions within SQL. Creation and updates on tables and data.</li><li>Evaluating, modifying, testing, debugging, and implementing existing software applications, modules, and systems in order to effectively maintain data integrity, optimize system performance, and output accuracy.</li><li>Provided production support and enhancements to both Legacy software systems and new applications.</li></ul> at FasTraxPOS