Mike Sanker
Analytics Lead/Manager at RealSelf- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
Topline Score
Bio
Experience
-
RealSelf
-
United States
-
Technology, Information and Internet
-
1 - 100 Employee
-
Analytics Lead/Manager
-
Jan 2022 - Present
Oversee a core analytics team consisting of business analytics, data science, and analytics engineering resources. Support Product teams with product usage analyses and A/B test design, including explicitly stating business questions/hypotheses, identifying relevant metrics, defining success criteria, and interpreting results. Forecast quarterly traffic and conversion performance for Marketing and SEO teams and create anomaly-detection resources to distinguish meaningful trend changes from historical performance. Create and manage intuitive and user-friendly Looker dashboards. Develop customer-specific likelihood-of-success and cost-benefit models for the Paid Marketing team to increase in conversion rate and decrease Google Ads spend. Facilitate biweekly Business Review meetings with executive leadership to highlight company health, identify and quantify risks, and report goal-attainment. I reorganized the format from an overly-complex yet generic company overview to a well-defined, agenda-based forum which provided a 30 minute reduction in weekly meeting time. Serve as a Looker (BI tool) administrator and implement cost-savings efforts to consolidate redundant/remove outdated data models leading to a $200k/year reduction in data storage costs and cloud computing spend.Analyze user interaction of website content to recommend expansion and deprecation opportunities to the Content team, leading to an increase in Search Engine Result Page (SERP) rankings.Provide (and ask for) peer review pull request approvals for changes to DBT and LookML data models. Create user segments based on site-engagement behavior to infer conversion-funnel stage.Assist Sales, RevOps, Advertising, Finance, and International teams with various ad hoc analytical requests. Show less
-
-
Senior Data Analyst
-
Jan 2021 - Jan 2022
Provide analytical support for RealSelf's email marketing, paid marketing, organic social, and advertising teams by providing ad-hoc deep-dives and building data visualizations with Looker.Partner with internal clients to consult on campaign testing and provide insights, recommendations, and roll-out projections.Work closely with finance and business unit stakeholders to develop team-specific traffic and conversion goals, report ongoing performance to leadership, and quantify the revenue risks for variances to goals. Create and manage data models in dbt to transform raw data into reporting and analytical layers. Show less
-
-
-
American Greetings
-
United States
-
Manufacturing
-
700 & Above Employee
-
Lead Analyst
-
Sep 2019 - Jan 2021
Partnered with leadership in sales, operations, inventory, and IT areas to define purpose and scope of proposed initiatives and provide analytical feedback on anticipated KPIs and methodology. Developed segmentation models centered on product reordering policies, historical sales data, and retail footprints in order to prioritize distribution strategies and decrease transportation costs. Designed and managed test vs. control experiments in field operations intended to measure the impacts to sales trends and merchandiser retention when field policies are changed.Created predictive models which estimate the impacts on retail inventory metrics by simulating changes to product reordering, manufacturing, and distribution center policies.Visually told a story from the data and develop user-friendly and intuitive reporting vehicles including senior leadership and executive level dashboards.Extracted data from multiple sources, clean, shape, and load into an environment for analysis.Mentored junior analysts and lead technical and analytical training. Show less
-
-
Sr. Operations Analyst
-
Sep 2016 - Sep 2019
Increased the work productivity of several operations departments – supply chain, forecasting, seasonal demand planning, order processing, UPC communications, field operations – by creating custom business tools designed to streamline and automate time-consuming processes. Delivered analytical support to operational areas by mining inventory and distribution data for patterns and testing opportunities, modeling sales and shipment dynamics, and quantifying estimated impacts from changes to operational policies.Developed distribution segmentation strategies to increase product-fill in shipments, reduce waste and reordering costs, and protect against loss sales due to retail out-of-stocks. Piloted proof-of-concept processes, lead discussions on recommendations, and served as an analytics subject matter expert for various corporate cost-savings and process improvement initiatives. Show less
-
-
Sr. Statistician/Quantitative Analyst
-
Oct 2014 - Sep 2016
Produced statistical clusters centered on product mix and historic sales patterns to guide the product development and product management, and order-writing teams’ strategies.Provided demographic-based marketing segments to merchant teams for product placement.Developed ensemble regression models to predict seasonal card sales to guide order-writing. Supported the seasonal order-writing teams by evaluating competing forecast models. Collaborated with internal clients on test design for seasonal product and marketing initiatives.Led project to design, code, and validated future-state departmental SAS processes for an enterprise systems migration from mainframe to server.Participated in interviewing potential new junior analysts and mentored those recently hired. Show less
-
-
Statistician
-
Sep 2012 - Oct 2014
Created dynamic Excel macro- and slicer-driven reports which provided multiple layers and views of product performance to support the testing and tracking of new product introductions. Co-authored a tool which provides recommendations for product category space allocations along with estimated annual sales and profitability impacts. Regression models and optimization methods drive the output of this tool.Facilitated product ratings for technology cards by adjusting for known bias for use by our Retail Merchant, Product Development, and Creative departments. Show less
-
-
Quantitative Analyst
-
Sep 2010 - Aug 2012
Prepared weekly, monthly, and seasonal sales performance reports for internal and external clients by making use of Point-of-Sale (POS) and customer loyalty data.Gained insights into shopper behavior and sales trends.Traveled to external retailer client’s headquarters for meetings and presentationsActively participated in customer relationship forums where external retail partners were hosted at American Greetings headquarters
-
-
-
Bryant & Stratton College
-
United States
-
Higher Education
-
700 & Above Employee
-
Mathematics Instructor
-
May 2012 - Dec 2019
Adjunct faculty member for adult education. Taught remedial math, Algebra, and Statistics. Adjunct faculty member for adult education. Taught remedial math, Algebra, and Statistics.
-
-
-
Lake Ridge Academy
-
United States
-
Education Management
-
1 - 100 Employee
-
Mathematics Teacher
-
Sep 2007 - Aug 2010
7-12 Mathematics teacher: Taught Algebra 1 through AP Statistics, was an adviser to an assigned group of students, helped with efforts to take the grading system web-based. 7-12 Mathematics teacher: Taught Algebra 1 through AP Statistics, was an adviser to an assigned group of students, helped with efforts to take the grading system web-based.
-
-
-
Pymatuning Valley Local School District
-
Andover, Ohio, United States
-
Mathematics Teacher
-
Aug 2006 - Jun 2007
Middle school mathematics teacher for 7th and 8th grade. Middle school mathematics teacher for 7th and 8th grade.
-
-
Education
-
Cleveland State University
Master's degree, Applied Mathematics -
Youngstown State University
Bachelor of Science (B.S.), Mathematics -
Youngstown State University
Bachelor of Science (B.S.), Secondary Mathematics Education