Professional Experience

Amazon Advertising, New York, NY Mar 2022 - Current

Software Engineer

Buy Supply (Caprice Electronics, Inc. E-commerce Division), Brooklyn, NY Mar 2019- Mar 2022

Software Engineer

• Used Python to automate the daily order submission process, inventory update, profit calculation, etc
• Established RESTful API and EDI integrations with various vendors, shipping carriers, and platforms.
• Constructed ETL data pipelines and designing unified database schema.
• Designed and developed internal web applications using HTML, CSS, and Bootstrap in Python Django framework.
• Built and upgraded the pricing model for over 500,000 products to maximize the profit margin which already helped increase sales by over 150% compared to the same period in the last year.
• Integrated and analyzed inventory and orders data from different vendors into the database and various platforms to improve team efficiency.

Goldman Sachs, New York, NY Jan 2019- Mar 2019

Investment Data Analyst, Pension Fund Investment Management

• Oversight of the data aggregation, management, and analysis for all available S&P 500 companies' pension funds.
• Supported the investment management team in monitoring market environmental changes, and analyzing market trends regarding U.S. pension funds' portfolio to contribute to the white paper.

China Merchants Bank, New York, NY Jan 2018- Jan 2019

Credit Analyst, U.S. Leveraged Finance & Structured Finance

• Created 10+ Credit memos to deliver concise interpretation and visualization for companies' market situation, financial position and future growth strategies.
• Drafted 5+ credit applications along with fundamental credit analysis, industry analysis, market research, research on risks and mitigations, collateral/enterprise value coverage analysis and financial projections.
• Composed 40+ quarterly credit reviews independently on companies' financial reports for 24 existing deals, using EBITDA, Leverage ratio, Interest Coverage ratio and Current ratio.
• Built financial projection models under three scenarios to analyze borrowers' future credit ratios, free cash flow generation ability and debt repayment schedule to detect potential issues for the 1st performing team.
• Conducted $450 M+ CLO pool analysis, cash flow modeling with Moody's CDONet, and fundamental collateral analysis, and portfolio monitor via monthly trustee report and ensured borrowing base and relevant concentration limits in line with loan agreement.

Education

Skills