Scarlett (Sijia) Long
Financial Analyst at LawDepot- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Excel: Power Pivot for Beginners
LinkedInMay, 2022- Nov, 2024 -
Excel: Working Together with Power Query and Power Pivot
LinkedInMay, 2022- Nov, 2024 -
Data Visualization: Storytelling (2016)
LinkedInMay, 2021- Nov, 2024 -
Learning Conversion Rate Optimization (2018)
LinkedInApr, 2021- Nov, 2024 -
Excel: Economic Analysis and Data Analytics
LinkedInMar, 2021- Nov, 2024 -
Financial Analysis: Making Business Projections
LinkedInFeb, 2021- Nov, 2024 -
Writing Headlines
LinkedInNov, 2020- Nov, 2024 -
Writing Ad Copy
LinkedInSep, 2020- Nov, 2024
Experience
-
LawDepot
-
Canada
-
Legal Services
-
100 - 200 Employee
-
Financial Analyst
-
Jun 2019 - Present
-
-
-
-
Brand Manager
-
Aug 2018 - Nov 2018
• Analyzed business metrics and developed strategic action plans; increased opportunities and 10%+ walk-in traffic• Conducted sales analysis, supply & demand analysis, inventory analysis and ad-hoc analysis for new products, and suggested campaigns and solutions to improve the current process• Created and maintained a quarterly competition dashboard with large transaction data collected from internal database and automated the reporting system• Led a team of two, planned and implemented monthly promotional events, achieved short- and long-term goals and ranked 13th in Canada • Collaborated with vendor partners and maintained stable inventory level, minimized backorders and consumer waiting time• Developed passive social media presence on WeChat, accomplished an average monthly increase in sales of 5%
-
-
-
Hudson's Bay Company
-
United States
-
Retail
-
700 & Above Employee
-
Counter Manager
-
Jun 2017 - Aug 2018
• Built solid client base through establishing and maintaining strong relationships with clients• Created reports to followed-up with customers after purchases and ensured customers satisfied with products and notified with upcoming events; significantly increased customer satisfaction rate• Developed effective phone selling technique through analyzing consumer behaviors and introducing new products• Conducted performance dashboards for the counter and exceeded sales goals for the year• Hosted special events, seasonal gift with purchase and holiday programs regularly • Monitored and analyzed stock level, ordered inventory and adjusted re-ordering points
-
-
-
-
Sales Associate
-
Jan 2017 - Jun 2017
• Recommended products based on customer needs; demonstrated excellent time management skill under pressure • Increased client satisfaction rating from 80% to 95% by customizing services based on consumer needs• Processed cash and credit payments accurately, balanced and closed daily cash • Facilitated customer satisfaction and grew business with follow-up calls • Recommended products based on customer needs; demonstrated excellent time management skill under pressure • Increased client satisfaction rating from 80% to 95% by customizing services based on consumer needs• Processed cash and credit payments accurately, balanced and closed daily cash • Facilitated customer satisfaction and grew business with follow-up calls
-
-
-
-
Summer Intern
-
May 2015 - Jul 2015
• Processed customer cash, check, transfer, statement transactions and reconciled discrepancies• Greeted and guided customers professionally and maintained excellent rapport with new and returning customers• Promoted and advised on financial products and services to customers and increased sales• Achieved excellent scores in customer service assessments and promoting products • Processed customer cash, check, transfer, statement transactions and reconciled discrepancies• Greeted and guided customers professionally and maintained excellent rapport with new and returning customers• Promoted and advised on financial products and services to customers and increased sales• Achieved excellent scores in customer service assessments and promoting products
-
-
Education
-
University of Alberta
Bachelor's degree, Accounting and Finance