Austin Lossing Email & Phone Number

Chicago, Il, Us

Chicago, Il, Us

Eden Prairie, Minnesota, United States

Overview:Took over from a senior analyst with 47 years of experience. Supported multiple businesses by optimizing and documenting processes, disseminating responsibilities, and served as the central figure for pricing, forecasting, and sales analysis.Pricing and Forecasting:- Managed pricing across CRM (Zoho) and ERP (SAP) systems.- Interpreted, transformed, and uploaded customer forecast data to drive production.- Prepared customer-facing price lists and graphical templates in Excel.Sales Analysis:- Developed executive-level PowerBI reports integrated with Google Analytics and Catalyst for tracking sales and social media engagement.- Designed dashboards in Zoho Analytics to monitor pipeline flow.- Delivered ad hoc reporting on sales, forecasting, production costs, and pricing.Process Optimization:- As Zoho administrator, secured account permissions, formalized new product quote processes, and eliminated redundant product entries.- Established price change request standards and confirmation procedures.- Prepared part numbers for obsolescence.Key Achievements:- Employee of the Month (March 2024): Volunteered to audit 2,400 part numbers for a delayed warehouse management system migration, identifying hundreds of additional items not captured. Cleaned, sorted, and connected data in time for additional testing before collaboration with the external contractor.- Order Releasing Automation Initiative: Documented and outlined process steps for releasing orders to the shipping floor, aiming to automate the workflow. Presented to the company's external SAP provider, addressing current shortcomings before automation development.- Trend Analysis: Conducted trend analysis of historical forecast data of Fortune 500 clients, pinpointing disconnects in shipping and production times. Demonstrated that customer-provided forecasts were being lowered after the agreed-upon window, driving over-production and leading to additional reports for other customers.

Maplewood, Minnesota, United States

Overview: Deviated pricing analyst for 3M Commercial Solutions, focused on Facility Management and Graphics & Signage product lines. Expanded scope of role to aid in process optimization and analytical reporting.Daily Responsibilities:- In SAP, created, maintained, and audited national contracts for business and government institutions- Responsible for phase-in/phase-out SKU initiatives, auditing product listings and contract information for parity between Vistex, Vendavo, and SAP- Used Salesforce to coordinate with sales representatives and product owners to negotiate pricing, confirm pricing legality, and set expectations for contract durationAnalytical Reporting:- Authored Microsoft Excel macros in VBA to prepare ad hoc and monthly reports from SAP data for sales reps and external stakeholders containing location, product, and pricing information- Performed year-end reports of pricing and sales for key clients, which required manually converting 3M SKU information to customer ERP systems- Improved coding of existing Excel VBA macros to cut down processing time by 13 hours weeklyProject Highlight: Rebate Processing Overhaul- Identified rebate payments being made without required manual review, costing the department $10k-30K monthly- Before new process was codified, manually reviewed and actioned 1,000 - 2,000 lines per month - Year+ process to investigate, develop, document new SOPs, taking into account input from sales representatives and business owners- Collaborated with other departments to design a new Power BI portal- Authored process manual with screenshots totaling 200+ pages- Remotely led multi-week training for new team created to take ownership of discovered responsibilities

Golden Valley, Mn

- Created monthly consolidated invoices from multiple vendors in JD Edwards that were customized to client needs in Business Objects and Microsoft Excel for multiple national accounts- Reconciled billing, invoice, and catalog discrepancies by auditing internal systems and communicating with suppliers- Independently audited ERP system for duplicate, inaccurate, or outdated product information using V-lookups and pivot tables

St. Louis Park, Mn

- Audited program eligibility by analyzing submitted pay stubs, personal tax filings, Veteran's Affairs awards, and Social Security documentation- Distributed federal grants through a government portal, handling sensitive identifying information (SSN, addresses, etc.)- Responsible for on-boarding of new hires; created new interlinked training materials in Microsoft Word

Bloomington, Mn

Completed assessment of 11th grade standardized English tests for the state of Tennessee.Evaluated tentative test questions for effectiveness of future student assessment.

Education record

Recipient of a full scholarship to the NHLBI funded Boston University Summer Institute for Training in Biostatistics (Summer 2012)..

Bachelor Of Arts (B.A.), Statistics, Psychology, 3.832

Activities and Societies: Teaching assistant for STAT 1601 Introductory Statistics, STAT 2501 Probability and Stochastic Processes.