Guoxi Lian

Guoxi Lian

Section Commander

Followers of Guoxi Lian460 followers
location of Guoxi LianSingapore

Connect with Guoxi Lian to Send Message

Connect

Connect with Guoxi Lian to Send Message

Connect
  • Timeline

  • About me

    Pricing Analyst | Data Analyst | Business Analyst | Business Intelligence

  • Education

    • Boston Consulting Group

      2022 - 2023
      Rapid & Immersive Skill Enhancement (RISE) Program in Business & Data Analytics Distinction

      Advanced Excel | MySQL | Power BI | Tableau | Python | Machine Learning

    • National University of Singapore

      -
      Chemical Engineering

      Activities and Societies: Basketball

    • Nanyang Technological University Singapore

      2021 - 2022
      PACE certificate Business Analytics and Automation Tools

      Advanced Excel | Tableau | SQLite | Tibco Spotfire | Gleematic RPA

  • Experience

    • Singapore Armed Forces

      Feb 2007 - Feb 2008
      Section Commander

      Led and managed a team of six soldiers with diverse backgrounds to align themselves to a greater objective and to fulfill the platoon's overall goalInvolved in the training and grooming of the soldiers to achieve their fullest potential

    • Life Mastery Academy

      Mar 2012 - Sept 2012
      Training Coordinator

      Led the coordination and supervision of the program and its materialsSupported the trainers to evaluate the results of the course and implement adjustments upon reviewManaged the sales sign up process for the largest course in the academy

    • Poket Pte Ltd

      Jun 2013 - Dec 2014
      Account Manager

      Pioneered the business development of a new product, onboarding 100+ clients in first yearCollaborated with cross-functional teams to address client needs, leading to a 15% improvement in client success metricsPartnered with clients to identify business objectives and delivered engaging presentations that outlined actionable data strategies, resulting in 10% improvement in key performance indicatorsActed as a liaison between clients and internal teams, facilitating effective communication with non-technical stakeholders and achieving 20% improvement in project success rates Show less

    • Elusyf Singapore

      Dec 2014 - Dec 2018
      Sales Manager

      Conducted thorough analysis of sales data to identify key market trends and analyzed customer data to identify cross-selling opportunities, resulting in a 5% increase in market shareSustained process improvement in the training curriculum to reduce onboarding time for new hires by 30%Teamed with department heads to identify training gaps and successfully aligned training programs with organizational goals, resulting in a 10% increase in employee performanceLed a team of 5-10 sales executives to pursue a collective goal aligned with organizational targets, with the peak of achieving 500% more than the average monthly sales generated Show less

    • Macchiato Design and Marketing

      Jan 2015 - Sept 2017
      Partner

      Led the formulation, tracking and maintenance of the project management plan, controlling the project life cycle and improving project submission rate by 10%Spearheaded a major pricing restructure, increasing overall margin of 10% by redirecting focus on overall branding communication instead of just customers’ design needs Adopted key sales metrics monitoring system, such as conversion rates and average deal size, thereafter implementing strategic solutions to improve sales generated by 10% Show less

    • Self-employed

      Jan 2019 - Oct 2022
      Foreign Exchange Trader

      Data analysis of over 100,000 data points led to the development of data-driven trading strategies that optimized ROI by 10%Performed hypothesis testing on trading strategies, resulting in a confidence level of 95% for optimal decision-makingMonitored and managed market risks, maintaining a risk-reward ratio in line with the developed strategies used, leading to a decrease in portfolio volatility by 20%

    • Boston Consulting Group (BCG)

      Oct 2022 - Mar 2023
      Upskilling (Data Analyst)

      Program in Business & Data AnalyticsCapstone Project involved data analysis of customer transaction data for an e-commerce FMCG client to develop data-driven strategies to increase revenue in key segments and build customer engagement to position the client as a leading market brand*Crowned Top 3 teams for the impact recommendations, completing the program with Distinction - Led a diverse team of 7 across multiple disciplines as the Codemaster, overseeing end-to-end data analysis and ensuring data accuracy and integrity within AWS SageMaker environment - Business intelligence included business requirement gathering, statistical techniques, and data engineering to create data models and optimize data pipelines to support the analysis - Conducted data mining techniques, mapping out customer segment using [e.g. k-means, RFM], product bundling using market basket analysis, SKU optimization and trip-driving product analysis, leading to significant impact of 7-12% potential revenue upliftMachine Learning Project involved using supervised modeling techniques [e.g. random forest] to build predictive modeling solutions for income qualification levels for families in Latin America, providing aid to the right people*Optimized predictive model accuracy to 94.6% Python Project involved creating a logistic regression model to predict movie ratings likened to a recommender system Show less

    • Procter & Gamble

      Mar 2024 - now
      Pricing Analyst

      Enhanced data integrity by implementing robust data validation procedures, enabling more reliable decision-making and reportingReduced pricing discrepancies by 15% through monitoring and consolidating pricing data from multiple sourcesStreamlined reporting workflows, improving report preparation time and boosting data accuracy by 20%, delivering clearer business insights

  • Licenses & Certifications

    • BUSINESS AND DATA ANALYTICS - DATA ANALYST

      BCG RISE
      May 2023
      View certificate certificate
    • FUNDAMENTALS OF PYTHON PROGRAMMING-P210804LBF

      NTUC LearningHub
      Sept 2022
      View certificate certificate
    • SGUnited Skills Programme in Business Analytics and Automation Tools (Synchronous & Asynchronous e-learning)

      Nanyang Technological University
      Mar 2022
      View certificate certificate
    • Google Analytics Certification

      Skillshop
      Jan 2024
      View certificate certificate
    • BCG RISE Capstone Distinction (Business and Data Analytics)

      Boston Consulting Group (BCG)
      Jul 2023
      View certificate certificate
    • Accenture North America - Data Analytics and Visualization Job Simulation

      Forage
      Jan 2024
      View certificate certificate
    • Tata - Data Visualisation: Empowering Business with Effective Insights Job Simulation

      Forage
      Dec 2023
      View certificate certificate
    • JPMorgan Chase & Co. - Agile Job Simulation

      Forage
      Jan 2024
      View certificate certificate
    • BCG RISE Distinction SQL Project

      Boston Consulting Group (BCG)
      Jul 2023
      View certificate certificate
  • Volunteer Experience

    • Treasurer

      Issued by JCI Mandarin Singapore (新加坡文华国际青年商会) on Jan 2020
      JCI Mandarin Singapore (新加坡文华国际青年商会)Associated with Guoxi Lian