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..
-
Business AnalystN-AbleOttawa, On, Ca -
Market Data AnalystFarm Boy Inc. Aug 2023 - PresentOttawa, Ontario, Canada -
Market AnalystAdecco Jul 2021 - Jul 2023Toronto, Ontario, Canada -
Associate Business AnalystUniversity Consulting Group (Ucg) Jan 2020 - May 2021Hamilton, Ontario, CanadaSpearheaded 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. -
Product & Intelligence Officer - Building A Career-Oriented, Immersive E-Learning Platform ReviRevi Oct 2019 - Jan 2021Hamilton, Ontario, CanadaReVi 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. -
Graduate Research Assistant - Data & SurveyMacpherson Institute Jan 2020 - May 2020Hamilton, 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
-
Technology Entrepreneurship
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?
-
2gmail.com, mitacs.ca
Free Chrome Extension
Find emails, phones & company data instantly
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.
Start your free trial