Alex Stearns Email & Phone Number

Kansas City, Missouri Area

• Developed price-&-date-sensitive inventory reorder criteria for seasonal greeting cards and streamlined reorder recommendations process.• Maintain core responsibilities of prior Specialist role (website and leadership sales reporting, systems testing, credit analysis, store training) with greater emphasis on process improvement and inventory management.

Kansas City, Missouri Area

• Supported 54% department YoY sales growth and 121% gross sales plan attainment by helping grow Hallmark.com’s Ship-From-Store network by 150+ stores and ensuring these stores were properly trained and equipped to handle the incremental sales volume.• Partnered with senior finance manager and other stakeholders to revamp Hallmark's online promotion-crediting process, resulting in roughly $500,000 program cost savings for 2018.• Optimized Hallmark.com sales dashboards to senior management and retailer performance scorecards to 1,000+ order-fulfillment stores with Microstrategy and Excel.• Operated as system admin for Radial’s StoreNet order fulfillment software, managing user access, adjusting store and order settings, manually processing exception orders, and resolving retailer inquiries through ServiceNow tickets platform.• Evaluated online product lifecycles as stores declined SKUs or reported discontinued items, relying on Microstrategy and Salesforce inventory attributes and reports to determine SKU viability on Hallmark.com and Amazon.com.• Validated order processing software deployments (Radial StoreNet), conducting equipment testing for fixes and upgrades and creating own test orders and criteria as appropriate.• Served as department SME on manual crediting process for Hallmark.com orders, calculating credits owed stores fulfilling 2018/19 promotional orders, mispriced orders, and incorrectly processed exception orders.• Utilized Radial StoreNet, Retail.Net, Salesforce Commerce Cloud (Order Center), ServiceNow, SAP CRM, Microstrategy, DemandWare, Microsoft Excel and Access, and Teradata SQL Assistant software.• Educated retailers on Seamless Retail programs and inventory management practices at the 2019 Atlanta Retail Gift Show and through biannual district manager conferences, retailer webinars, and conference calls.• Led training sessions for 25+ internal resources on Radial order processing procedures to reduce analyst ticket forwarding.

Kansas City, Missouri Area

• Determine corporate reimbursements and sales credits for 950+ retailers for participation in 75+ 2017 and 2018 online sales promotions.• Incentivize and report retailer participation in high-growth SFS (Ship From Store) and BOPIS (Buy Online Pick-Up In Store) initiatives, supporting seamless shopping experiences for customers.• Analyze all 2017 promotional orders placed on Hallmark.com through Salesforce Commerce Cloud – further evaluate discrepancies between SCC reports to identify optimal reporting methods.• Develop and report key metric dashboards to management including reimbursement amounts, retailer participation rates, net sales attained on promotional items, and SFS and BOPIS usage rates across fiscal quarters.• Partner with Omni Channel, Finance, Marketing, E-Commerce, and Accounts Receivable teams as well as product owner, delivery analysts, and developers to meet project goals.

Overland Park, Ks

• Administer multiple transactional tax compliance processes for major telecommunications clients, preparing, reviewing, and processing returns; generating recurring reports; and uploading client data to solutions platform.• Scrutinize client tax data files against solutions platform calculations, identifying and correcting, applying, or escalating credit concerns, rate mismatches, tax form issues, etc. • Maintain timely entry of received jurisdictional notices in system.• Utilize Microsoft Excel and Outlook and Google Drive and Docs daily (solutions platform is in-house).

Kansas City, Mo

• Supported State Street’s North American implementation and testing of Oracle E-Business Suite R12 software for Accounts Payable department.• Provided project support by gathering, analyzing, and communicating time-sensitive project status information to Project Team.• Assured 100+ project test scripts reflected accurate and comprehensive Accounts Payable processes and/or program functionalities and proposed changes to developers.• Analyzed and scrubbed 3000+ domestic, EMEA, and APAC vendor records to adhere to approved formatting changes and reflect consistency across files.• Assisted Accounts Payable team with research and data analyses of past due invoices and credits and with vendor communication / invoice status inquiries on customer service e-mail account.• Collected and/or closed $275,000 total outstanding credits.• Maintained tracking documentation for invoices received during 2-week conversion blackout; monitored missing items list and determine respective record or physical locations. • Recorded, verified, and submitted to management daily check and ACH payment totals for 23 North American State Street companies and resolved nonpayment issues.• Ran bimonthly AP Trial Balance reports; ran reports / compiled documents for audit review by Federal Reserve.

St. Joseph, Mo

• Earned department-wide 2014 “Program of the Year” and supervisor’s 2015 “Director’s Choice RA” awards.• Documented detailed incident reports accurately for direct supervisor, Director of Residential Life, and Director of Student Affairs.• Provided consultation to residents on money, time, and resource management; personal and professional development; and conflict resolution.• Resolved policy violation conflicts independently and in team settings.• Promoted diversity, fostered community and resident engagement, and directed creative student development programs (i.e. smart financing for broke college students; active shooter preparedness training; month-long “Honors Olympics”).• Collaborated to execute joint resident initiatives with MWSU’s Living Learning Communities Coordinator, Honors Program Director, and Campus Police Department.

St. Joseph, Missouri Area

Recruited students to pursue Honors Program and Golden Griffon Scholarship both in-person and over phone (cold call experience).Created Excel spreadsheet charting a multi-semester tracking procedure for Honors students and redesigned office's core retention spreadsheets.Generated biannual Honors newsletter with Publisher, serving as lead writer and architect and conducting appropriate student and faculty interviews. Volunteered two years beyond employment as Honors student representative at various Program recruitment events and as both member and leader of the newly-reinstated Honors Retreats' activity planning committees.

Kansas City, Mo

• Generated 45 procedural workflows (below), such as verification clearances and asset movement involving non-retirement accounts, after analyzing existing company-wide operations.• Evaluated website suitability for attracting millennial audience; created brand-focused content, layout, and theme; and recommended changes.• Gained experience using Redtail financial advising CRM service.

St. Joseph, Mo

President, 2012 - 2014VP Marketing, 2014 - 2015Enacted effective planning and policies to grow defunct club to award-winning status and 300% projected membership over executive board term, 2012-2015.Led organizational renewal and recruitment efforts; collaborated on programmatic initiatives with officer team; wrote and implemented 70-page handbook; expanded membership from 5 to 60 members. Received 2015 MWSU Student Government Association’s ‘Spirit of the Griffon’ organization award following self-directed development and submission of organization resume.Improved club procedures for community-wide Trivia Night fundraiser, constructing 7-month calendar for committee delegation, marketing decisions, prize procurement, business partnership, etc.Executed event featured on school newspaper's front page: http://www.thegriffonnews.com/2014/03/sho-hosts-game-night/Designed club logo (below).

St. Joseph, Missouri Area

Analyzed individual securities and client portfolios with Morningstar Advisor Workstation.Observed current and prospective client-advisor financial planning meetings and trade order executions.Prepared company financial presentation entitled "10 Financial Rules for Life in Your 20s". PowerPoint and speech adapted into official company video (below), bullet-listing steps.

St. Joseph, Missouri Area

First voice constituents heard when expressing concerns or scheduling appointments.

Master Of Business Administration - Mba

Bachelor Of Science In Business Administration (Bsba), Accounting And Finance, 3.9/4.0

Activities and Societies: MWSU Honors Program Participant, MWSU Student Honors Organization (SHO), Beta Gamma Sigma International Business.