Supply Chain Business Analyst

Ling Fang

****.*****@*****.*** (***) - *** - **** LinkedIn: https://www.linkedin.com/in/lingling-fang/ Technical Skills

Data Analytics Tools: SQL (My SQL, Postgres, ABAP), Tableau, Looker Studio, Google Analytics, Python, R, Advanced Excel Software: SAP S/4 HANA, Google Suite, Microsoft Suite, CRM, OMS, Funnel Skills: Logistic Management, Supply Chain Management (SCM), Material Management, Data Analytics, Data Visualization Work Experiences

Inossem, Jersey City, NJ 2022.08 – Present

IT Service and Consulting, Business Analyst

● Achieved a 45% operational efficiency boost by optimizing Order to Cash (OTC) processes and providing hands-on SAP trainings to non-technical clients, resulting in streamlined supply chain operations

● Contributed to a $2+ million increase in ARR through successful project management and delivery

● Utilized advanced Excel functions (Vlookup and Pivot Tables), and led data cleaning and restructuring processes to ensure data accuracy and reliability for supply chain optimization

● Leveraged advanced analytical expertise to craft comprehensive Supply Chain Management solutions realizing in ABAP SQL

● Organized weekly technical trainings to clients to increase SAP system utilization rate by 15%

● Oversaw and directly executed two end-to-end SAP implementation projects, yielding a 95% satisfaction rate for the service team Allen & Gerritsen, Boston, MA 2022.02 – 2022.08

Marketing & Media, Analyst Intern

● Generated a 5% conversion uplift through the implementation of data-driven strategic recommendation

● Delivered weekly reports to management, extracting valuable insights to inform strategic decision-making

● Executed funnel analysis to evaluate and optimize the engagement performance of digital ad campaigns

● Meticulously tracked user engagement KPIs and translated findings into compelling narratives presented in dashboards

● Collaborated with cross-functional teams to develop recommendations for enhancing mobile user experience

● Applied Tableau and SQL expertise to conduct comprehensive analyses of first-party data Heroes In Transition, Mashpee, MA 2021.09 - 2021.12 Non-profit Organization, Business Analyst Volunteer

● Managed seven analysts in the proficient completion of a comprehensive data analysis project from initiation to conclusion

● Accomplished a notable 6% increase in donor participation by conceptualizing and recommending a Go-To-Market approach

● Executed extensive research, SQL query, exploratory data analysis (EDA), regression and classification using Python, data visualization using Tableau, and presented valuable insights to stakeholders Augere Tech, Shanghai, CN 2021.07 - 2021.09

IT Service & Consulting, Business Analyst Intern

● Assisted in project management, efficiently collecting real-time requirements and addressing pain points to enhance outcomes

● Successfully renewed annual service contracts with an insurance company client, exceeding a total value of $140,000

● Performed data cleansing, customer segmentation analysis, and model selection using Python, and created interactive dashboards in Tableau to deliver actionable insights

Target Social Tech, Shanghai, CN 2021.05 - 2021.07 Marketing & Media, Business Analyst Intern

● Delivered data-driven sentiment analysis results, surpassing $50,000 through the utilization of social listening tools

● Protected a cosmetic client against public relations risks to prevent revenue loss totaling $1.5 million

● Conveyed 45 daily and 12 weekly analytical deliverables, encompassing SQL data analysis, competitor analysis, social media campaign performance evaluation (KPIs in user engagements), visualization of findings Education

Northeastern University – Boston, MA 2020.09 – 2021.12 Master of Science in Business Analytics (STEM) GPA: 3.9/4.0 University of Minnesota – Minneapolis, MN 2016.09 – 2020.05 Double Majored in Economics (B.A.) & Statistics (B.S. STEM) GPA: 3.4/4.0

Contact this candidate