Colton Smith

Experience

• 

  Smith + Company Tax

  Jun 2011 - Aug 2013

  Accounts Receivable Clerk

  Cooperatively managed 25 client’s QuickBooks and Creative Solutions accounts to keep up to date records as well as monitor regular business activities.Inputted 2 years of detailed monthly cash receipts for a Petroleum DistributorPrepared spreadsheets and invoice reports for a myriad of small businesses spanning from veterinarian offices to lawyers and waste management companies

• 

  University Portland

  Jun 2014 - Sept 2014

  Moreau Center Service Plunge Coordinator

  Collaborated with 10 schools and non-profit organizations in the North Portland area to create a 2- day service immersion for 120 members of UP’s incoming freshman classDesigned T-shirts, wrote social justice reflection material, developed and taught training for group leaders and ran detailed registration and check-in processes for the day of the event

• 

  AC Portland

  Feb 2015 - May 2015

  Outreach & Marketing Intern

  Researched, created and implemented a report on best volunteer management and engagement practicesSold $500 worth of 50/50 raffle tickets on average at Timbers, Thorns and Trail Blazer games to fund raiseCreated lists and reached out to companies who could provide volunteersUpdated Salesforce to track new volunteersDeveloped marketing material to expand the number of people following AC Portland on social mediaPosted engaging and mission driven social media updates daily Show less

• 

  M J Murdock Charitable Trust

  May 2015 - Aug 2015

  Summer Intern

  Conducted detailed research to aid program directors in developing grant proposals to give to the trustees Performed investment analysis of 25 multi-million dollar portfolios alongside the Trust’s CFO Investigated 12 candidates to invite to a regional media/communications forum for the Trust’s CEOProof read and offered edits on the 1st edit of the CEO’s book

• 

  Nordstrom

  Jun 2016 - Aug 2016

  Cashier

  Provided consistently positive and timely customer service by processing returns, attended to customer concerns and questions and meticulously organized product displays and clothing racks to appeal to shopping customers.Monitored and communicated hourly selling figures to sales associates and department managers.Checked out customers and offered rewards and member programs to increase department sales.Fulfilled direct to customer orders, inventory transfers, and organized back stock product to maximize efficiency.Utilized store databases to increase company sales and service levels. Show less

• 

  Columbia Sportswear Company

  Aug 2016 - Jan 2017

  E-Commerce Merchandise Coordinator

  As a part of a young but stable e-commerce department at Columbia Sportswear I provided cross functional support to the merchandise team as a whole in the form of projects that ranged from delivering current and future product merchandise strategies, to giving feedback on department processes and communication practices. Daily tasks were centered around improving and updating site presentation for the present and future, which directly affects sales and profitability as seasonal directives came and went. While completing tasks, feedback was given to either reinforce current practices or circumvent for future solutions. Creative interpretation is used when building certain custom parts of the site for the purpose of improving customer experience and satisfaction with the site. Incremental positive website performance was monitored from a season’s beginning marketing push to its analytical end results, this was achieved by focusing on being accurate and efficient to achieve a clean and easy to use website marketplace. Coordination at this level required organization, communication and an eye for detail, which I provided with a commitment to daily, incremental success.Deliverables:o Constructed webpages filled with product on a daily basis drawing from current selling data and merchandising initiatives meant to drive traffic, engagement and sales. o Facilitated a comprehensive training session regarding our e-commerce platform, Demandware, which helped on-board two new coordinators, and increased competency for my department’s buyers.o Aided in the website product launch of a limited edition Columbia and Lucasfilm clothing collaboration from the film, Star Wars: Rogue One, which yielded nearly half a million dollars in e-commerce revenue.o Built product pages for Columbia.com’s outlet affiliates exclusive program, allowing third party website to advertise Columbia.com product to sell with discounted coupon codes, contributing to sales of $902k in Q4 2016 alone. Show less

• 

  Mathys+Potestio

  Mar 2017 - Sept 2017

  Logistics Analyst (ETW at Nike)

  Oversaw shipments in SAP of Nike products from overseas directly to 7 regional wholesale accounts, and assisted with one national account, within Nike’s North America Direct Ship Supply ChainAnalyzed Tableau data from 3rd party logistics providers to both create and protect revenue opportunities across Nike’s financial quartersCross analyzed weekly air-freight shipment expenditure from SAP and Excel to maximize revenue vs. expenditureCollected daily SAP shipment reports to analyze with the goal of maximizing shipped sales and minimizing costsCreated shipment changes within SAP to either delay product or rush it to our customers based on needCommunicated quickly and effectively while building relationships with account contacts, for mutual benefit Show less

• 

  Nike

  Oct 2018 - now

  Execute financial forecasts totaling for Nike’s ERP Engineering team using SAP & ExcelMaximize the capitalizable costs of a SAP S/4 HANA upgrade project (SEC Program) using Relay PPM and Smartsheet automation to run actuals, then analyzing the data to add valueDesign a Power BI dashboard to create KPI’s for the supply of NA resources allocable to SEC program workBuild resource and cost models in Excel that enable senior leaders to deliver business goals under budgetPresent financials that highlight business risks & opportunities to SEC Program executive leadersInfluence annual operating plans using analytics to identify staffing gaps and prioritize work Show less My main role as an A/R representative has been to negotiate payment plans for 1,000+ Nike Golf accounts to repay debts as large as $2.5M daily using a variety of communication techniques that work at both large and small scales to help our customers navigate Nike's invoices and their payment options.I often find myself prioritizing cross-functional communication with sales and marketplace operations to find risk & increase cash flow opportunities among specific accounts that cannot pay until their operational questions are answered.I have built Tableau connected Excel dashboards containing the KPI's to improve my team's reporting speed and capabilityI also play an integral role as a subject matter expert on my team's latest capability upgrade, automated due date notices, which included running a pilot on the program, building ad-hoc reporting to prove it's business viability and sustaining its operations through written training documents and workshops with peers Show less Networked, interviewed and attained this temporary role (2 days a week) to gain analytical finance experience, while also continuing as a credit representative (3 days a week)Provided multi-scenario cost analysis to leadership on $3.5M in cost savings for program depreciation costsAssisted on month-end program cost accrual process by downloading SAP expense reports for USA and China cost centers and reporting the numbers within Nike’s operating and capitalized accounting frameworkModified program financial tracking models in Excel based on direction from program management to improve visibility into important program cost driversPrepared professional services tracking for month-end cost accrual by inputting new project costs each monthAutomated the process of monthly cost reports and asset currency valuations for efficient financial planning Show less

  • Finance Analyst

    Apr 2022 - now

  • Accounts Receivable Representative

    Sept 2017 - Apr 2022

  • Finance Analyst

    Oct 2018 - Dec 2018