Yufeng Qian

Programming Makes Our Lives Easier

Summary

Experienced software engineer with 6 years of expertise in software development, real-time optimization, and scalable system design. Skilled in building production-ready recommendation systems, budget pacing platform, machine learning, and data-driven infrastructure that support high-impact applications at Amazon Advertising. Strong foundation in experimentation, algorithm development, and distributed systems using Java, Python, and AWS.
  • Master of Science in Computer Science from Georgia Institute of Technology
  • Master of Science in Finance from Johns Hopkins University

Resume

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

Master of Science in Computer Science, Georgia Institute of Technology


Master of Science in Computer Science, Monroe College


Master of Science in Finance, Johns Hopkins University


Bachelor of Science in Accounting, St. John's University


Honors: Dean's List (2013-2014, 2015-2016); Cum Laude for Academic Excellence

Skills

  • Programming: Python, Java, HTML, CSS, SQL, Excel, SAP, R
  • Language: Fluent in English and Mandarin Chinese
  • Related Courses:Object Oriented Software (Python), Computer Architecture, Database Systems (SQL), Designing E- Commerce Site, Advanced Hedge Fund Strategies (Python), Quantitative Financial Analysis (Matlab), Statistical Analysis