RICHARD NGAI

Elmhurst, NY | rngai000@citymail.cuny.edu | 718-795-8698 | github.com/RichardNgai | repl.it/@RichardNgai

Education

Macaulay Honors College at The City College Of New York

• Mechanical Engineering, Minor in Computer Science: May 2022. GPA: 4.0/4.0

Technical Abilities  

• Proficient in Java, C++, Python, HTML, CSS, R, G-code, RobotC
• Autodesk Inventor Certified Professional 2018 and Certified User 2015
• Experience with Solidworks, CNC Milling, MATLAB, Labview, Arduino, Raspberry Pi, VEX Robotics

Work Experience

Fixed Income Intern | Morgan Stanley | Sept 2019 – Present

• Automated Net Asset Value calculations in Excel to calculate FX trades impact (adj. for currency)
• Bulk uploaded historical Danish bank Excel spreadsheets to MS Access Database using Python
• Cleaned news headline data in preparation for financial sentiment analysis
• Created a new framework by changing R workflow for comparing financial data from Bloomberg into a Python based dashboard

Engineering Intern | Con Edison | June – Aug 2019

• Audited Energized Object Report database
• Participated in field work inspecting poles and assisted during a Corporate Emergency Response
• Used Excel to create graphs for salt data, temperature loads
• Suggested improvements to the Electric Distribution Engineering Manual
• Filled out 400 SOS Work Request and Overhead Inspection Forms

Comp. Engr. Intern | Con Edison | July – Aug 2018

• Created Microsoft Access database to store gas drip valve information
• Digitized microfilm of Manhattan and Queens Gas Mains and Services maps to PDFs
• Removed duplicates of Mains and Services maps from hard drive

Software Engnr. Intern | Con Edison | July  – Sept 2017

• Analyzed peak summer transformer load graphs for 900 customers in Con Edison’s networks
• Created electrical load relief contingency plans using proprietary mapping software for adjacent networks

Projects

Checkers Playing Robot                                                                 Spring 2018

• Worked with a partner to utilize OpenCV, Raspberry Pi, and Python
• Programmed stepper motors, designed and 3D printed custom parts in Autodesk Inventor

Vice President of Teenergetic                                        Fall – Spring 2017

• Brooklyn Technical HS club pushing for accessible and appealing school lunch in NYC public schools
• Discussed impact of food availability in disadvantaged neighborhoods during weekly meetings with Community Food Advocates
• Prepared testimony for City Hall, attended rallies and created signs to support free school lunch for all
• Successfully brought free school lunch to all NYC public school students in conjunction with the Lunch4Learning campaign, a citywide effort by food policy advocates