Post Job Free

Resume

Sign in

Python, C++, Sql Server, Django

Location:
Princeton, NJ, 08542
Posted:
August 26, 2023

Contact this candidate

Resume:

Linyang (Iorek) Han

** ***** **, ****** ****, NJ 07310 917-***-**** ady8zm@r.postjobfree.com

Github Link: https://github.com/IorekHan Linkedin: https://www.linkedin.com/in/linyang-han-59a28921b/ Strong Python, C/C++ programming and data engineering knowledge and hands-on experience. Graduate with a master’s degree in Electrical Engineering from Columbia University, focused in software programming, data engineering and computer networking areas. EDUCATION

Columbia University New York, NY, the United States Master of Science in Electrical Engineering, focusing on computer science course, December 2022 Beijing Institute of Technology Beijing, China

Bachelor of Science in Engineering Electrical Engineering, June 2021 SKILLS

Programming Backend: Python, C/C++, Visual Studio, RESTful API Full-stack: Django, DRF (Django REST framework), HTML, CSS, JavaScript Data: Pandas, NumPy, SQL (SQL Server, MySQL, SQLite), SSMS, SSIS, IBM DB2, Microsoft VBA, ODBC Other: Git, GitHub, AWS, Google Cloud Platform, UE5, SourceTree, DumpSec, Firco, SysAid Specialized Areas Computer Programming, Data engineering, Computer Networking, Machine Learning, Windows schedule tool PROFESSIONAL EXPERIENCE

CITIC Bank International, New York Branch New York, NY, the United States Software Engineer Jan 2023 – Now

Software Developing:

• Designed and programmed a full-stack web platform using Django (Python).

- Realized back-end connections to SQLite database for user info and data. Developed 4 self-developed modules with separate login authorization and more than 10 Python applications and business functions inside to provide different reports and functions.

- Designed and coded more than 30 web pages and templates with JavaScript, HTML and CSS, with user friendly interfaces.

• Developed Python AML algorithms to prevent fraud and illegal transactions.

- Combined string similarity algorithm, regularized algorithm, cosine similarity algorithm and other distance algorithms to build a comprehensive structured and reliable software product.

- Optimized algorithms to get 10x faster and 10x more accurate than the old one and completed in minutes on million-level data.

• Developed a C++ application to replace manual reconciliation operations.

• Developed a C++ application to realize Liquidity Stress Test with functions of allowing manually input and future prediction Data Engineering:

• Operated a Microsoft SQL Server database and an Access database, both linked with IBM DB2, SWIFT, EIBS through ODBC

• Developed SQL queries and more than 10 stored procedures in SQL Server databases with SSMS

• Developed 3 work flow and data flow projects with SSIS to connect databases and call stored procedures to generate reports to realize scheduled report generating and data formatting

IT Engineering:

• Data backup with SQL server; user review with DumpSec and Firco; domain control and security admin with SysAid Shenzhou Yunhai Technology Co., Ltd. Shenzhen, China Software Development and AI Engineering Intern Dec 2020 – July 2021

• Designed deep learning models and algorithms (Tensorflow, CNN, etc) that addressed the interruption problem in human-robot voice interaction using UML Statechart Diagram to define the behavior of machine speaker.

• Co-implemented an automatic voice interaction module for robots used in retail scenarios using Python

• Realized the module which incorporated ASR(Deepspeech2), NLP(NLTK) and speech generation capabilities, achieved 92% accuracy per human judgement. Our module was helping two of the biggest snacks retailer in China to realize no-human customer service. Zhongke Jiudu Technology Co., Ltd. Beijing, China

Software Development Engineer Intern, Project Manager Intern Feb 2019 – Jun 2019

• Programmed with C++ to build a platform on supervising and adjusting manufacturing part size with QT front-end

• Participated in two tender submissions and maintained communication between clients and developers afterwards

• Implemented a VPN network to transmit data securely in public internet through a tunnel transport PROJECTS

C/C++: Instant Message System (Concurrent communication between server and clients) C++, Multi-Threading programming: Thread Pool in producer-consumer mode Python, spark, google cloud platform, Flask: US House/Department Price Prediction Python, Networking: Network Implementation of TCP and UDP Protocol R, Machine Learning: Online Shopping Intention Predictor



Contact this candidate