Yue Shang

Yue Shang Email and Phone Number

Business Analyst @ N-able
Ottawa, ON, CA
Yue Shang's Location
Kanata, Ontario, Canada, Canada
About Yue Shang

I am a professional data analyst with experience in marketing, sales, consulting, and finance.Key Skills:- Data Management: Microsoft SQL Server, Snowflake, BigQuery, Microsoft Azure, MicroStrategy- Data Visualization: Power BI, Tableau, Looker- Data Analysis: Excel (Pivot table, Lookups, Power Query, Macro), Python (Pandas, NumPy, Matplotlib, Seaborn, Plotly, Beautiful Soup); Statistical modeling (hypothesis testing, regression, correlation, clustering)- Marketing/Revenue Platform: Google Analytics, Google Search Console, Google Tag Manager, Sprout Social, Mailchimp, SEMrush, Ahref, Microsoft Clarity, Sprout Social, Salesforce, ZoomInfo- Business Analysis: Website analytics; Sales/Revenue analysis; CRM and Marketing Campaign analysis (Social, Email); E-commerce data dump automation; QA & QC of data in the data warehouse; C-level dashboard development & automation; Customer profiling & targeting; Customer churn and retention prediction; Competitors/Industry benchmark; A/B testing and analysis; Customer cohort/cluster analysis; Root-cause analysis; Pricing/Cost Analysis; Market Share modelling; Python API connection; Comments Sentiment analysis; NPS calculation; POS data (customer count, average basket); Seasonality analysis and campaign planning; Revenue generation plan..

Yue Shang's Current Company Details
N-able

N-Able

View
Business Analyst
Ottawa, ON, CA
Website:
n-able.com
Employees:
2087
Yue Shang Work Experience Details
  • N-Able
    Business Analyst
    N-Able
    Ottawa, On, Ca
  • Farm Boy Inc.
    Market Data Analyst
    Farm Boy Inc. Aug 2023 - Present
    Ottawa, Ontario, Canada
  • Adecco
    Market Analyst
    Adecco Jul 2021 - Jul 2023
    Toronto, Ontario, Canada
  • University Consulting Group (Ucg)
    Associate Business Analyst
    University Consulting Group (Ucg) Jan 2020 - May 2021
    Hamilton, Ontario, Canada
    Spearheaded 3 engagements for 2 Toronto-based ventures in the non-profit and health services industries; worked closely with company executives to identify and deliver business innovation initiatives, managed end-to-end project delivery by effectively utilizing Gantt Charts, RACI Charts, and other PM tools.- Organization 1: An OHIP-backed health services company specializing in eating disorder treatment programs. Engagement 1: Worked with a group of 6 consultants, conducted competitive research and benchmarking to support its Canadian market positioning and pricing strategies; applied human-centred design and systems thinking while working with stakeholders to understand and map end-to-end services and processes from the customer's perspective.Engagement 2: Performed ad-hoc analyses in Excel and Power BI to investigate product optimization, sales data, and marketing performance; formulated a business branding and marketing proposal encompassing social media marketing, SEO, SEM and Google Analytics to understand consumer behaviors and enhance marketing presence; analyzed participant and employee experience across channels (mobile, web, social media, phone, face-to-face, print, mail).- Organization 2: A nonpartisan, non-religious, nonprofit Canadian registered charitable organization.Engagement 3: Performed operational research to evaluate operational decisions, best practices and market competitiveness across Tirgan’s portfolio; developed KPI dashboards in Excel for functional areas such as membership models, space utilization, headcount, programs set up to support operational and financial projections and project go- lives; developed a Grant Application Evaluation and Scoring Matrix in Excel for government grant applications.
  • Revi
    Product & Intelligence Officer - Building A Career-Oriented, Immersive E-Learning Platform Revi
    Revi Oct 2019 - Jan 2021
    Hamilton, Ontario, Canada
    ReVi is an Immersive e-Learning Platform helping students improve soft skills for a smooth transition from school to work life, through practice in real-life events and including an evaluation toolkit designed to provide quantitative and qualitative feedback to the ReVi user.- Conducted primary market research (i.e., surveys, focus groups, interviews, case studies) with over 250 respondents to arrive at a solution with a clear value proposition and identify target customers whose pain points were being solved.- Conceived and built an end-to-end platform to connect students, recruitment specialists, and other institutional users in 4 months; conducted SME interviews.- Applied customer-centered design methodologies, conducted usability testing with proof-of-concept beta website with over 70% satisfaction rating, developed through WordPress, Unity, IBM Watson speech to text API and RStudio, with the integration of AR/VR technologies.- Developed financial projections for 5 years (income statements, balance sheets) and it breaks even on par with industry standards in 3 years using Excel financial modelling; encompassed key assumptions and industry benchmarks.- Created PowerPoint presentations to pitch the business and gained approval from the advisory committee.- With a focus on sustainability, embedded people (social), profit (economy) and planet (environment) into the DNA of the start-up to guide innovation and competitive advantage.
  • Macpherson Institute
    Graduate Research Assistant - Data & Survey
    Macpherson Institute Jan 2020 - May 2020
    Hamilton, Ontario, Canada
    - Reviewed the “Getting the Supervisory Relationship Off to a Good Start” handbook that outlines topics for graduate students and supervisors to discuss as part of the formation of their relationship.- Created and distributed both paper-based and electronic surveys to staff and students; collected data, and analyzed data using Excel Pivot Tables, and developed insights for revising and improving the existing tool.

Yue Shang Education Details

Frequently Asked Questions about Yue Shang

What company does Yue Shang work for?

Yue Shang works for N-Able

What is Yue Shang's role at the current company?

Yue Shang's current role is Business Analyst.

What schools did Yue Shang attend?

Yue Shang attended Mcmaster University, Guangdong University Of Technology.

Who are Yue Shang's colleagues?

Yue Shang's colleagues are Nafsika Zgouri, Amanda Harris, بوسالم صلاح, Emmu Yilma, ณัฐพล จันทร์บำรุง, 王開文, Andrei Borza.

Not the Yue Shang you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.