Charles Lee
Verified Expert in Engineering
Performance Optimization Developer
New York, NY, United States
Toptal member since February 7, 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.
Portfolio
Experience
- Transact-SQL (T-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
Work Experience
Senior Database Developer
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.
Application Developer
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.
Experience
Personal Website | Hugo on GitHub Pages
https://github.com/charlesjlee/charlesjlee-websiteSteem Upvote Bot | Python and Heroku
https://github.com/charlesjlee/steemBotEducation
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, Transact-SQL (T-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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring