Harrison Baker Email & Phone Number

Salt Lake City, UT, US

Ogden, UT, US

• Assisted in the creation of a comprehensive 5-year strategic plan, with a full financial forecast (income statement, balance sheet, cash flow) that accounted for debt, capital expenditures, and estimated sales growth..
• Primary resource for evaluating multiple capital investments and potential acquisitions.
• Assisted with the development of a new pricing model for key customers, resulting in additional margin and fees to cover inventory storage and cost of capital.
• Created a department level income statement, allocating SG&A and other overhead costs to get bottom line net income per business unit.
• Restructured a losing division into a 150% profit increase the following year and a 56% ROI through better inventory, expense, and sales management.
• Developed data reporting infrastructure, with experience in SQL, SSRS, Tableau, Power BI, Crystal Reports, Sage Alerts & Workflow.

Ogden, UT, US

• Built integrations between various systems using scheduled scripts, API calls, flat file transfers, EDI, and data transforms/loads.
• Onboarded new EDI connections and monitored existing connections for validation failures.
• Setup Robotic Process Automation (RPA) for routine transaction posting tasks.
• Developed an in-house training website for a cost of less than $200 to rollout IT security training to all end users.
• Assisted in the maintenance and setup of new workstations, servers, and users, utilizing PDQ, WSUS, Active Directory and Group Policy.
• Assisted with other IT tasks as necessary.

Ogden, UT, US

• Created custom reports using SAP Crystal Reports to enable the Accounting, Sales, and Marketing teams to have better information for decision making.
• Utilized Tableau to create custom reports and dashboards from data in our ERP and Manufacturing Performance Optimization systems.
• Created custom email alerts that are triggered based on records identified in a SQL query and that go out on a scheduled basis.
• Assisted in customizing the ERP system to better fit business needs: adding user defined fields, adjusting forms, identifying ways we can more fully utilize the software.
• Assisted in the implementation of a new Warehouse Management System to improve inventory visibility and streamline receiving, picking, and shipping processes.
• Streamlined and maintain a Magento 1 Ecommerce site, ensuring security while adding functionality through custom extensions and modifications.

Ogden, UT, US

• Created bi-monthly sale newsletters using MailChimp that go out to over 35,000 customers.
• Coordinated newspaper and online marketing methods for four locations over three states, analyzing ROI and conversion rates.
• Ensured 3 customer databases were kept in sync and updated.
• Assisted in sale planning for four brick and mortar stores, keeping margin and cost in mind.
• Created an automatically updating Price List that is sent out by request to customers.
• Created an automatic sale tag creation program to standardize their design and creation.

Ogden, UT, US

• Managed inventory using Sage 100 ERP. Responsible for ordering from various vendors and conducting quarterly inventory.
• Analyzed monthly financial reports to determine where costs could be cut to increase efficiency.
• Reduced inventory 50% at the SLC Store by analyzing non/low-sellers and reducing our on-hand quantities of those items.
• Reduced the Point of Sale item database 40% by deleting old items or marking them inactive.
• Assisted in scheduling teachers for baking classes, marketing classes through calendars and an online presence, and tracking class attendance through online and physical signup forms.
• Created an Automated Labeling System, Warehouse Mapping Diagram, and cleaned up the item database using Microsoft Excel.

Ogden, UT, US

• Assisted in cashiering, customer service, and stocking.
• Created an item order and stocking spreadsheet.
• Re-organized store warehouse to increase operational efficiency.

Created and managed websites for clients of Baker3 using Adobe Dreamweaver and Wordpress.Helped a client migrate their phone, internet, and hosting plan to another provider resulting in cost savings of 40%.Assisted in domain and hosting transfers.Managed Google Adwords Campaigns and analyze results from Google Analytics. Google SEO Optimization, including.

Master Of Accounting, Macc, Accounting & Business Analytics

Bachelor Of Science - Bs, Accounting

Bachelor Of Science - Bs, Information Systems

Hs Diploma