
Guoxi Lian
Section Commander

Connect with Guoxi Lian to Send Message
Connect
Connect with Guoxi Lian to Send Message
ConnectTimeline
About me
Pricing Analyst | Data Analyst | Business Analyst | Business Intelligence
Education

Boston Consulting Group
2022 - 2023Rapid & Immersive Skill Enhancement (RISE) Program in Business & Data Analytics DistinctionAdvanced Excel | MySQL | Power BI | Tableau | Python | Machine Learning

National University of Singapore
-Chemical EngineeringActivities and Societies: Basketball

Nanyang Technological University Singapore
2021 - 2022PACE certificate Business Analytics and Automation ToolsAdvanced Excel | Tableau | SQLite | Tibco Spotfire | Gleematic RPA
Experience

Singapore Armed Forces
Feb 2007 - Feb 2008Section CommanderLed 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 2012Training CoordinatorLed 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 2014Account ManagerPioneered 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 2018Sales ManagerConducted 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 2017PartnerLed 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 2022Foreign Exchange TraderData 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%
.webp)
Boston Consulting Group (BCG)
Oct 2022 - Mar 2023Upskilling (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 - nowPricing AnalystEnhanced 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
- View certificate

BUSINESS AND DATA ANALYTICS - DATA ANALYST
BCG RISEMay 2023 - View certificate

FUNDAMENTALS OF PYTHON PROGRAMMING-P210804LBF
NTUC LearningHubSept 2022 - View certificate

SGUnited Skills Programme in Business Analytics and Automation Tools (Synchronous & Asynchronous e-learning)
Nanyang Technological UniversityMar 2022 - View certificate

Google Analytics Certification
SkillshopJan 2024 - View certificate
.webp)
BCG RISE Capstone Distinction (Business and Data Analytics)
Boston Consulting Group (BCG)Jul 2023 - View certificate

Accenture North America - Data Analytics and Visualization Job Simulation
ForageJan 2024 - View certificate

Tata - Data Visualisation: Empowering Business with Effective Insights Job Simulation
ForageDec 2023 - View certificate

JPMorgan Chase & Co. - Agile Job Simulation
ForageJan 2024 - View certificate
.webp)
BCG RISE Distinction SQL Project
Boston Consulting Group (BCG)Jul 2023
Volunteer Experience
Treasurer
Issued by JCI Mandarin Singapore (新加坡文华国际青年商会) on Jan 2020
Associated with Guoxi Lian
Languages
- enEnglish
- chChinese
Recommendations

Al edouard
Public Servant | Community focused | Meeting residents where they are.New York City Metropolitan Area
Enola francisco
Graphic DesignerNew York City Metropolitan Area
Keith gillis, p. eng.
Senior Mechanical Engineer at CespiraVancouver, British Columbia, Canada
Tyler shannon
Store Manager at Domino’s Pizza UK & Ireland LtdDomino’s Pizza UK & Ireland Ltd
Szymon glinka
Entry Specialist - Process Automation in Arla FoodsGdańsk, Pomorskie, Poland
Jonathan chaves vargas
Ejecutivo negocios at BAC CredomaticCosta Rica
Deepak bastola
AI/ML/DS Enthusiast | PhD Scholar at Florida Atlantic University (Florida, USA) | Patron at Mathemat...Florida, United States
Sheriff lawal nd, aat, bsc, aca, acti
Manager at EY, Global Compliance and Reporting, Tax Services.Nigeria
Vishal tyagi
Mechanical Engineer || Presentation Specialist || SEO || Btech (ME) From NIET ||Noida, Uttar Pradesh, India
Abhinay jain
4*Certified Salesforce.com Developer.Bengaluru, Karnataka, India
Kevin liang
Sr. Brand Manager at Novo NordiskJakarta Metropolitan Area
Jason keller
Director Los Angeles Eats Itself & Arts Research Adjunct Professor at Woodbury UniversityLos Angeles, California, United States
Vikram singh
Software Engineer - FinTech | App Development | Specializing in Hybrid Applications | HTML | CSS | J...Bengaluru, Karnataka, India
✨ally sillins✨
Engineering Program Manager @ YouTubeSan Francisco, California, United States
Akkshay aadsul
Manager at CarLay AutosPune, Maharashtra, India
Himank sardana
ASU Computer Science Sophomore | Passionate about Coding and Problem Solving | Java , Python , Machi...Tempe, Arizona, Statele Unite Ale Americii
Anubha singhal
Architect | Project Manager | Disability Inclusion and Accessibility Consultant | Social Change make...Delhi, India
Kasper sylvester hansen
iOS specialistCopenhagen, Capital Region of Denmark, Denmark
Syndy anoran
Quality AssurancePhilippines
Masud rana
Supply Chain ManagerDhaka, Bangladesh
...