Scroll To View More
Charles Lee

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
  • Novantas
    SQL Server, Management Studio, SVN, Sublime Text, PowerShell
  • JPMorgan Chase
    SQL Server, C#, VB.NET, SVN, T-SQL, Management Studio, Visual Studio, Oracle...
  • Microsoft SQL Server, 5 years
  • T-SQL, 5 years
  • Query Optimization, 4 years
  • Operations Research, 4 years
  • Performance Optimization, 4 years
  • Python, 1 year
  • Blockchain, 1 year
New York, NY, United States
Preferred Environment
Windows, Management Studio, Sublime Text, Spyder
The most amazing... 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.
  • Senior Database Developer
    2014 - 2017
    • 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
    JPMorgan Chase
    2011 - 2013
    • 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
  • Personal Website | Hugo on GitHub Pages (Development)

    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)

    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.

  • Languages
    T-SQL, SQL, Python, VB.NET, C#
  • Storage
    Microsoft SQL Server, Databases, PostgreSQL, Oracle PL/SQL, PL/SQL Developer, MySQL, PL/SQL, SQLite
  • Misc
    Operations Research, Performance Optimization, Query Optimization, Algorithms, Data Structures, Machine Learning (ML), Bitcoin, Deep Learning, Blockchain
  • Frameworks
    Windows PowerShell
  • Libraries/APIs
    Pandas, NumPy, SciPy, Scikit-learn
  • Tools
    Subversion (SVN), Git, MATLAB, JIRA, Notepad++, Sublime Text 3, Sublime Text
  • Bachelor of Science in Operations Research
    Cornell University - Ithaca, NY, USA
    2007 - 2011
I really like this profile
Share it with others