Education
Skills
Affiliations
Accomplishments
Timeline
Generic

John (Lingfeng) Shen

Education

Bachelor of Science -

Purdue University
West Lafayette, IN
12.2017

Skills

  • Advanced in PPT, Word, Excel(VBA)
  • Excellent statistical analysis and mathematical skills
  • Matlab, Python and SAS
  • Fluent in Mandarin and Cantonese

Affiliations

Detail-oriented analyst who has an extremely keen eye for detail. Adept at developing detailed analytical reports. Work with various teams to gather appropriate data and create compelling analysis for management.

Accomplishments

Tekni-Plex Heathcare

Sales Support Analyst/Product Marketing Analyst, Global Product Marketing Team (Jan. 2020 - Present)

  • Hold daily meeting across functional teams, to provide cost-benefit analysis, check efficiency and profitability across all product lines and implement value pricing further into the process
  • Construct universal cost model for Flexible team, intending to be more precise and user-friendly
  • Support Sales Excellence with Salesforce reports and dashboards. Gather data and build analysis through salesforce channel to help decision making.
  • Create budget and forecast and aligned with organizational objectives, driving cost reduction and revenue maximization

Tekni-Plex, Natvar
Sales Support Analyst (May 2019 - Dec. 2019)

  • Create new universal cost model to standardize formula and rates between plants globally. Implement targeted GM/value pricing concept into cost model to strengthen pricing strategy
  • Use RFQ log to create Quote-Hit-Ratio report to analyze performance regarding different customers, regions, product lines and market
  • Build SKU analysis for specific customers to analyze historical trends and forecast future performance of each part
  • Continue to perform essential functions from Sales Support and develop advanced analytical tools

Tekni-Plex, Natvar
Sales Support (Sep. 2018 - May 2019)

  • Provide cost models of new and existing products for quotations and further sales and gross margin analysis
  • Support sales team with requested cost-benefit analysis to track and analyze sales and profitability
  • Work with other departments to gather information that supports general analysis tasks and identify any cost saving opportunities

Alpha Capital Holdings, Inc.

Investment Banking Analyst Intern (March 2018 - Aug 2018)

  • Buy side deal development for large e-commerce to purchase complementary company including company profiles, valuation, merger and acquisition analysis, and financing options
  • Support the Managing Director by generating marketing materials and researching due diligence information for potential deals

Timeline

Bachelor of Science -

Purdue University
John (Lingfeng) Shen