Scroll To View More
Charles Lee, Performance Optimization Developer in New York, NY, United States
Charles Lee

Performance Optimization Developer in 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

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

  • T-SQL, 5 years
  • Microsoft SQL Server, 5 years
  • Performance Optimization, 4 years
  • Operations Research, 4 years
  • Query Optimization, 4 years
  • Blockchain, 1 year
  • Python, 1 year
New York, NY, United States

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#, Visual Basic .NET (VB.NET)
  • Storage

    Databases, Microsoft SQL Server, PL/SQL, PL/SQL Developer, Oracle PL/SQL, PostgreSQL, SQLite, MySQL
  • Other

    Software Development, Blockchain Developer, Performance Optimization, Operations Research, Query Optimization, Algorithms, Machine Learning, Data Structures, Bitcoin, Deep Learning
  • Frameworks

    Windows PowerShell
  • Libraries/APIs

    Scikit-learn, SciPy, NumPy, Pandas
  • Tools

    Subversion (SVN), Sublime Text, Sublime Text 3, Notepad++, Git, Jira, MATLAB
  • Platforms

    Blockchain

Education

  • Bachelor of Science in Operations Research
    2007 - 2011
    Cornell University - Ithaca, NY, USA
I really like this profile
Share it with others