Shun L Email and Phone Number
Shun L work email
- Valid
- Valid
Shun L personal email
- Valid
- Valid
Shun L phone numbers
Strong analytics leader with a history of working in the E-commerce, marketing, and advertising industry. Experienced in building an ETL/ELT pipeline through DBT, SQL, and Python utilizing API connections. Skilled in Excel, Looker, Tableau, and R for all things related to data analysis and visualization.I have successfully created contribution margin/profitability models, inventory planning tools, third-party data import/export pipelines, and top LTV path analysis. Key strengths:- Setting up an End-to-end BI technology stack from the ground up using scalable warehousing and visualization techniques.- Optimizing data workflow and transfer across multiple departments to automate work.- Performing analysis and tracking strategy around customer LTV, retention, repurchase, and other success KPIs.Skills:- Analysis: Python, SQL, API calls, R, and Excel- Digital/Web Tracking and Attribution: Google Analytics, Heap, Segment- Visualization: Looker, Tableau- Data Warehousing: Redshift, Snowflake- ELT : Python, Matillion, DBT.
Nordstrom
View- Website:
- nordstrom.com
- Employees:
- 10
-
Data Science And AnalyticsNordstrom Jul 2021 - PresentSeattle, Washington, Us -
Senior AnalystMeundies Jun 2019 - Jul 2021I am responsible and for supporting and building the data pipeline, analysis, and reporting for projects and initiatives. I dig deep into the data to build reports that business users can understand and uncover potential stories that data can reveal for business optimizations.Achievements:- Built a brand new analytics technology stack using Redshift data pipeline, piping different sources through Matillion and Python, and performing transformations in DBT to be exposed in Looker. MeUndies advanced data platform impressed investors and was a huge factor in securing a $40 million investment from a growth equity firm. https://www.businesswire.com/news/home/20201123005913/en/Provenance-Announces-40-Million-Investment-in-MeUndies- Identified the most profitable customer order paths and journeys through LTV cohort analysis and integration of a customer segmentation project to prioritize strategy and measure our success if our core customers and growing our average customer LTRs by over 10% YOY for the past 3 years.- Led a cross-functional project to create a contribution margin model that calculated % margins by product across categories through Netsuite, purchase orders, shipping tables, among other sources, giving the company the first-ever way to look at LTV and break-even CPAs.- Built an in-house inventory planning reporting platform that optimized the work of the inventory planners by automating hours of weekly work, leading to increased visibility into sell-thru rates and optimized buys across prints and products.
-
Bi AnalystMeundies Jul 2018 - Jun 2019Earned my first promotion after 6 months, after the following achievements:- Independently led an RFP of ELT Providers and stood up the first ELT tool from the ground up with Matillion, directly leading to $80k of yearly savings from offboarding consulting services.- Migrated all SQL queries off of the old BI tools and created a centralized source of KPI definitions and leading to the first real-time tracking of metrics. - Created tracking dashboard of MeUndies' first StarWars print and reporting to PR agencies for the most successful print at the time, and the company has since produced 20+ new IP prints.https://mashable.com/2018/09/13/me-undies-star-wars/
-
Associate Bi AnalystMeundies Feb 2018 - Jul 2018
-
Business Insights AnalystBlackwood Seven, North America Jan 2017 - Feb 2018Los Angeles, Ca, UsIn the Client Services team, executed key deliverables on marketing activity for our clients, and helped improve internal systems and processes of handling data. Wrote SQL queries, R scripts, Excel templates, and Tableau dashboards to automate weekly performance summaries, and ad-hoc requests. -
Associate AnalystBlackwood Seven, North America Aug 2016 - Jan 2017Los Angeles, Ca, UsFormerly TWO NIL, Blackwood Seven is an analytics/media-marketing agency that uses a AI to allocate marketing spend, and analytics as our foundation to create scalable campaigns. Using real-time modelling and advanced KPI prediction, the team has been able to increase a company’s media ROI by up to 15-25%I support the Business Insights team on writing SQL queries to load and pull client data, performing analysis on the effectiveness of TV campaigns, and create visualizations to create stories for our clients to see how effective their dollars are performing. -
Student Affairs Information Systems Research AssistantUniversity Of California, Riverside Aug 2015 - Jun 2016Riverside, Ca, UsWorking within UC Riverside's Student Affairs department, I conduct survey research for the University to gauge the successes and shortcomings of diversity and academic improvement programs, as well as campus climate and student opinions. I worked on improving survey design and report template aesthetics, as well as working with different departments to build the website.Specializing with database and statistical analysis software, I implement a variety of programs including SPSS, Excel, and R. I focus on performing analysis of UC Riverside specific data from internal and external sources and constructing reports on significant findings to support data driven decisions and insight.Also working with publishers such as Barrons, Petersons, and Wintergreens, I provide information to college guides on student statistics. As a researcher, I have demonstrated on multiple occasions that I am highly effective at pulling information from the web to solve problems with limited background knowledge.For more information, please reference the website posted below: -
Undergraduate Research AssistantUniversity Of California, Riverside Oct 2014 - Jan 2016Riverside, Ca, UsInitially as a volunteer, I was able to recover 90 percent of transgenic drought resistant potato plants, by fixing the irrigation system and managing temperature, I obtained a project involving large-scale micro-propagation of asparagus plants. I managed logistics of the project as a whole, performing feasibility analysis, growth rate projections, managing supply and data collection. The most significant contribution I have provided to this project included scouting and hiring a team of 5 student research assistants with little to no prior experience, I provided guidance and supervision within the laboratory to train them in research methods as well as making progress on the project itself.Maintaining teamwork, safety, and efficiency within my team as well as improving processes to solve problems have been my main focuses as a project coordinator and leader. -
Office AssistantPico Union Housing Corporation Jul 2013 - Sep 2013Through UCLA, I interned for the Pico Union Low Income Subsidized Housing Corporation over the summer after high school to help a low income community. Here I was in charge of many clerical responsibilities, which included updating and processing housing contracts, organizing data for current residents, safely filing documents containing sensitive tenant information, and receptionist duties, acting as a liaison between current or potential tenants, and administration. I also worked for the auditing department in software installations and minor PC troubleshooting. I backed up housing contracts in the computer, and typed out or updated contracts that only existed in paper copy or new contracts.
-
Campaign Organization VolunteerMatt Szabo For City Council Jan 2013 - Mar 2013This was a campaign for Los Angeles District Council #13 which encompassed the Los Feliz, Silverlake, and Echo Park communities in central LA (which is not part of East LA as many confuse it for). Working directly with the candidate and key staff, my duties included phone banking to potential voters, informing them of how to vote and poll locations, and performing basic market research to identify the needs of our voters. I was in charge of creating strategy for ideal locations of campaign literature distribution based on demographics and organized packets for other volunteers to hand them out in a timely fashion.
Shun L Skills
Shun L Education Details
-
University Of California, RiversideStatistics
Frequently Asked Questions about Shun L
What company does Shun L work for?
Shun L works for Nordstrom
What is Shun L's role at the current company?
Shun L's current role is Data Science and Analytics at Nordstrom.
What is Shun L's email address?
Shun L's email address is sh****@****ies.com
What is Shun L's direct phone number?
Shun L's direct phone number is (888) 552*****
What schools did Shun L attend?
Shun L attended University Of California, Riverside.
What are some of Shun L's interests?
Shun L has interest in Environmental Sustainability, Digital Imagery, Data Analysis, Technological Innovations, Sculpture, Bicycling, Marketing Research.
What skills is Shun L known for?
Shun L has skills like Statistics, Microsoft Office, Data Analysis, Microsoft Excel, Sql, Tableau, Spss, Marketing, Qualtrics, R, English, Customer Service.
Who are Shun L's colleagues?
Shun L's colleagues are Gabriela Weatherston, Bernadette Williams, Ashley Rib, Keith Jones, Aimee Hunter Rosemond, Dawn Quadrini, Ilsoung An.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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