Charles Lee, Developer in New York, NY, United States
Charles is available for hire
Hire Charles

Charles Lee

Verified Expert  in Engineering

Performance Optimization Developer

New York, NY, United States

Toptal member since June 18, 2020

Expertise
DatabaseSQLPythonSoftware DevelopmentAlgorithmsMachine LearningBitcoinDeep LearningMATLABC#VB.NETOracle DevelopmentPostgreSQLMySQL
Bio

Charles is an application and database developer with more than 5 years of experience. He has been the database owner of multiple products—including an automation tool used extensively in asset management at JPMorgan Chase and a bank deposits pricing tool with 20+ clients and more than $1 billion under analysis.

Portfolio

Novantas
Windows PowerShell, Sublime Text, Subversion (SVN)...
JPMorgan Chase
Informatica, Oracle, Visual Studio, SQL Server Management Studio (SSMS)...

Experience

  • T-SQL (Transact-SQL) - 5 years
  • Microsoft SQL Server - 5 years
  • Operations Research - 4 years
  • Query Optimization - 4 years
  • Performance Optimization - 4 years
  • Blockchain - 1 year
  • Python - 1 year

Availability

Part-time

Preferred Environment

Spyder, Sublime Text, SQL Management Studio, Windows

The most amazing...

...business I considered recently was a joint venture to buy a Bitcoin ATM and put it in a high-traffic area in New York City or India.

Work Experience

Senior Database Developer

2014 - 2017
Novantas
  • Worked as the database owner of a bank deposits analytics dashboard with 20+ clients and more than $1 billion in total assets under analysis.
  • Helped a triple-client base and assisted an international expansion by maintaining a master version of the SVN code repository and synchronizing the shared code across all clients and environments.
  • Coordinated the database deployments of bi-monthly UI releases across 5 time-zones and multiple servers.
  • Developed new features, enhancements, utilities, and bug fixes—e.g. improved the accuracy of tracking CD renewal balances.
Technologies: Windows PowerShell, Sublime Text, Subversion (SVN), SQL Server Management Studio (SSMS), Microsoft SQL Server

Application Developer

2011 - 2013
JPMorgan Chase
  • Led the development of a technology cost savings initiative that was promoted globally and led to $3 million in savings for asset management in 2012.
  • Brought transparency to recurring and erroneous technology charges via monthly billing to all asset management end-users.
  • Led the development of a suite of email-based automation tools used firm-wide—15,800 distinct users and 116,000 transactions processed in 2012.
  • Owned the Informatica ETL process and Oracle PL/SQL algorithm that allocated server-level costs to individual applications based on usage.
Technologies: Informatica, Oracle, Visual Studio, SQL Server Management Studio (SSMS), T-SQL (Transact-SQL), Subversion (SVN), VB.NET, C#, Microsoft SQL Server

Experience

Personal Website | Hugo on GitHub Pages

https://github.com/charlesjlee/charlesjlee-website
This GitHub repository contains both the code for my personal website (master) and the files built using Hugo (GitHub-pages).

Steem Upvote Bot | Python and Heroku

https://github.com/charlesjlee/steemBot
Steem is a blockchain-based, social news platform where posters and upvoters, i.e. curators, are rewarded directly with cryptocurrency. This is a guide to creating a simple bot that will periodically upvote a random post on the Steem blockchain.

Education

2007 - 2011

Bachelor of Science in Operations Research

Cornell University - Ithaca, NY, USA

Skills

Libraries/APIs

Scikit-learn, SciPy, NumPy, Pandas

Tools

SQL Management Studio, Spyder, Visual Studio, Subversion (SVN), Sublime Text, Sublime Text 3, Notepad++, Git, Jira, MATLAB

Languages

SQL, T-SQL (Transact-SQL), Python, VB.NET, C#, Visual Basic .NET (VB.NET)

Storage

Databases, Microsoft SQL Server, SQL Server Management Studio (SSMS), PL/SQL, PL/SQL Developer, Oracle PL/SQL, PostgreSQL, SQLite, MySQL

Frameworks

Windows PowerShell

Platforms

Windows, Oracle, Blockchain

Other

Freelancing, Software Development, Blockchain Development, Performance Optimization, Operations Research, Query Optimization, Informatica, Algorithms, Machine Learning, Data Structures, Bitcoin, Deep Learning

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring