Alexandra Shea
Charlotte, NC - 704-***-**** - *******@*****.***
Experience:
Hearst Magazines. May 2019 – Present
Accounting Analyst – Digital Media Customers
Manages Digital Media portfolio from billing, cash applications to AR (Order to Cash)
Resolves invoicing and receipt discrepancies with internal sales and purchasing teams
Communicates with customers regarding billing and cash received
Performed A/R functions including generating aging reports, posting of payments to customer accounts, invoicing and processing checks and electronic payments.
Account analysis and reconciliations done daily
Created and maintained cash flow analysis
Assisted with month end closing procedures and financial statement preparation
Posted and analyzed high volume of cash receipts on a daily basis
Assisted year end accounts receivable audits
Manages customers including Twitter, Skimlinks, Facebooks and OpenX
Created SOP’s for new procedures and Training Documents for new hires
Utilizes Excel, Oracle Cloud, ADDepot and Sidetrade on a daily basis
TTI Floor Care. November 2017 – April 2019
Credit Analyst
Analyze customer accounts including collections and deductions to ensure accounts are current
Extensive contact with customers and other external entities to identify, research, analyze and resolve complex issues pricing, freight and advertising discrepancies
Handles Tier 1 accounts such as Walmart, Walmart CA, Kohl’s and BJ’s
Manages each client’s unique Vendor Compliance rules and requirements
Communicate with customers to audit and verify claims
Account reconciliations and making appropriate general ledger entries
Responsible for entering co-op agreements and accruals
Manages SKU returns, damages and shortages as well as Freight Compliance claims
Works cross-functionally with transportation and distribution, finance, sales and channel marketing departments in order to ensure customer accounts are accurate
Issue returns, RMA’s, RGs, credits and rebills
Heavily utilizing Excel, Oracle, Commerce Hub and Salesforce on a daily basis
Created SOP’s for all customer accounts and other daily tasks and trained new team members
· Order Management Analyst
Maintain and troubleshoot the order fulfillment and purchasing process on a daily basis
Become expert on 15+ customers shipping requirements and demands
Book of business includes $132 million and customers such as Home Depot, Target and Kohls
Manages and forecasts inventory levels on E-commerce websites for Kohl’s and Home Depot
Correct and maintain current price sheets for items
Manage and communicate all order related issues in an accurate and timely manner to both internal and external customers
Works cross-functionally with transportation and distribution, finance, sales and product marketing departments in order to ensure customer orders are filled in full and on time
Issue returns, RMA’s, RGs, credits and rebills
Heavily utilizing Excel, Oracle, Commerce Hub and Salesforce on a daily basis
Created SOP’s for all customer accounts and other daily tasks
Developed training and on-boarding program for new hires from scratch and was Team Training Lead, trained a total of 6 new hires in my time there
Participated in quarterly office-wide presentations for updates on OM team, learning new skills and new SOP’s
Dimension Data. January 2017 – November 2017
· Vendor Contract Renewals
Consults and supports sales team providing client contract renewal quotes, RFQ, adjusting quotes as required to ensure best solution is presented to customer
Liaison between Sales Team and external Distributors and Manufacturers
Verify the data and pricing integrity of all quotes, purchase orders, and invoices
Coordinates with finance for acceptable profit margins
Resolves pricing and cost discrepancies
Vlookups and Pivot Tables are used regularly to compare customer assets to the assets we have in our database and to maintain pricing
Responsible for keeping current on product and services offerings
Created training literature, SOP’s and training sessions for new hires
Assisted the manager in interviewing prospective employees
Electrolux. October 2016 – January 2017
·Accounts Receivable Specialist
Monitor receivable deductions accounts and resolve within 30 days
Become the subject matter expert for Order to Cash processes for assigned accounts
Investigate claims to determine a course of action, VLookup against disputed products
Process approved credit notes
Identify and document customer’s internal processes to create continuous updates to profiles.
Responsible for Chargeback reduction initiatives
Partner with management and various business groups to manage customer disputes
Manage receivable escalations and disputes
Monitor aging service level and ensure targets are met
Provide excellent customer service to both internal and external customers
Belk. May 2015 - August 2016
·Transportation Analyst
Efficient movement of all domestic inbound shipments originating from the West Coast
Planning and forecasting analysis to support current requirements and future growth
Liaison between vendors, carriers, buyers, merchants and stores
VLookups and Pivot tables were heavily used to execute and present annual transportation budgets, metrics and KPI’s
Maintains compliance standards as related to the Belk Vendor Guide
Ensures adherence to all domestic transportation laws and regulations
Peak Season planning and coordination.
XPO Logistics. November 2012 – May 2015
·Freight Audit Bill Pay Analyst – Specializing in Special Billing Customers.
Reviews and analyzes carrier freight bills, accounts payable for special billing customers
Resolves any and all discrepancies
Communicates with multiple internal departments; sales, brokerage, finance, etc
Receiving carrier freight bills and allocating documents internal load numbers
Meets and exceeds quota while achieving a very high level of accuracy
Implements daily batch and Interface, then resolves rejects
Training Lead for new team members on processes, created SOP’s for new hires and management
Credit Memos, Debit Memos, Credit-Rebills
Various ad-hoc projects as assigned by management
·Carrier Procurement Representative.
Book available freight in a cost effective manner, freight broker
Source carriers and negotiate rates to move available loads
Build strong liaison relationships with XPO's customer base
Facilitate new carrier onboarding process
Communicate customer problems, needs, leads and inquiries to sales force
Make over 100 calls per day, cold calling carriers
Quote customers on new lanes when requested, communicate with regional capacity manager in the event of any issues, document orders thoroughly in the computer
Technologies:
Microsoft Suite, Access, YMS, PKMS, Oracle, AS400, Pegasus, McLeod and DAT. JD Edwards, FOCUS, REX, SAP, Cisco CSCC and CCW-R. Salesforce, Sidetrade.
Education:
Belmont Abbey College, Belmont, NC.
Bachelor of Arts, Business Administration, concentration in Management.
Scholar-Athlete, Women’s Tennis Team Captain and MVP