Charles Lee

New York, NY, United States

Member since January 16, 2017

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.

Charles is now available for hire

Hire Charles

Portfolio

Novantas
SQL Server, Management Studio, SVN, Sublime Text, PowerShell
JPMorgan Chase
SQL Server, C#, VB.NET, SVN, T-SQL, Management Studio, Visual Studio, Oracle...

Experience

Microsoft SQL Server, 5 years
T-SQL, 5 years
Performance Optimization, 4 years
Query Optimization, 4 years
Operations Research, 4 years
Blockchain, 1 year
Python, 1 year

Availability

Part-time

Preferred Environment

Windows, Management Studio, Sublime Text, Spyder

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.

Employment

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: SQL Server, Management Studio, SVN, Sublime Text, PowerShell
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: SQL Server, C#, VB.NET, SVN, T-SQL, Management Studio, Visual Studio, Oracle, Informatica

Experience

Personal Website | Hugo on GitHub Pages (Development)
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 (Development)
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.

Skills

Languages
SQL, T-SQL, Python, C#, VB.NET
Storage
Databases, Microsoft SQL Server, Oracle PL/SQL, PostgreSQL, SQLite, MySQL, PL/SQL, PL/SQL Developer
Other
Query Optimization, Performance Optimization, Operations Research, Deep Learning, Bitcoin, Data Structures, Algorithms
Frameworks
Windows PowerShell, Machine Learning
Libraries/APIs
Scikit-learn, SciPy, NumPy, Pandas
Tools
Sublime Text, Notepad++, Git, JIRA, MATLAB, Sublime Text 3, Subversion (SVN)
Platforms
Blockchain

Education

Bachelor of Science in Operations Research
2007 - 2011
Cornell University - Ithaca, NY, USA

To view more profiles, join ToptalJoin Toptal

I really like this profile

Share it with others

0shares