Mackenzie Ulrikson

Mackenzie Ulrikson

Manager Sales Analytics · Vereco, LLC

United States

In My Own Words

Experienced Senior Analyst with 10+ years of experience in financial modeling, forecasting, and quantitative analysis. Knowledgeable in leveraging financial modeling expertise to provide critical analyses and data-driven insights that optimize sales and improve organizational revenue. Adept at providing leadership and facilitating cross-functional collaboration across the organization.

Open to new challenges in combining Data Science, Analytics, and presenting and telling the story of the data.

Work Experience

Manager Sales Analytics

Vereco, LLC

2017 – Present

Managed Print Services for health care. Focused on sustainable print management methodologies in health care. • Formulate financial models for new clients maintaining a 30% profit margin • Support the preparation of 5 new master financial models for cybersecurity department • Reduce clients' capital investment through quantitative analysis while improving company ROI • Consistently developed clients' replacement plans with one-week average turnaround for over 500+ units • Created tools and scoping questions to assess needs of clients to identify sales opportunities • Designed Excel tools to streamline sales models; achieving a 40% increase in efficiencies • Collaborated with Sales and Supply Chain to implement an optimized process to minimize lead-time • Produce enhanced templates that forecast accurate key measures such as customer revenue, COGS, and margins to report profitability to executives • Partnered with Finance to prepare forecasting of the 5-year budget projections for prospective new accounts • Forecast client's expenditures resulting in less than 3% variance to plans • Present client financials to senior sales leadership and executives regularly • Performed biannual reviews for direct reports to build up leadership within the department • Lead daily department meetings for project planning and delegation of tasks • Formulas used regularly in MS Excel: nested IF, AND, OR, SUM, VLOOKUP, INDEX, MATCH, CHOOSE

Past Club President Toastmasters International

Professional Organizations and Affiliations

2014 – 2015

Analyst

Vereco, LLC

2009 – 2012

Managed Print Services for health care. Focused on sustainable print management methodologies in health care. • Responsible for final review of analysis prior to delivering to management to ensure accuracy • Ongoing communication throughout project with senior sales leadership addressing follow up questions from client during close of sale • Developed and managed daily action plans with variable priorities on a client by client basis • Manage onsite assessments of potential new clients by delegating resources, coordinating logistics, establishing and tracking to key measures to ensure successful project completion • Analyze data from multiple sources to create comprehensive reports for leadership review • Interact effectively with vendors, coworkers, client IT resources and client key stakeholders to achieve best results • Routinely engage in cross functional collaboration with all departments • Systemize the optimization of customer product offerings by increasing the efficiency of data analysis • Develop detailed data collections in Excel of 1,000+ units per system at hospital systems across the US • Analyze and synthesize incomplete financial data from client into a 5-year Pro Forma of cost projections and savings • Create and maintain proprietary department tools for daily use resulting in shortened analysis time • Evaluate client's current processes with key stakeholders to discover areas of opportunity to increase sales • Formulas and functions used regularly in MS Excel: vlookups, sum arrays, pivot tables, and graphs • Employee of the Year: 2013

Education

Bachelor of Science

Chapman University, Argyros School of Business & Economics

Bachelor of Science

Industries

BikeGolfDiveCreative AgenciesFashionFishingLifestyleMoto & PowersportsMusicOutdoorRunSkateSnowStreetwearSurfSwimTechTriathlonWakeYogaHealth & Fitness

Companies I Follow

See all