Seilas Phillips, MBA

Diamond Bar, CA *****

ad5b4g@r.postjobfree.com

310-***-****

To obtain a position with a successful company that promotes teamwork, communication, out of the box thinking, and integrity. As an employee, offers the possibility of upward growth in business strategy opportunities and development.

#readytowork

U.S. Citizen - Authorized to work in the US for any employer Work Experience

AR Manager / Revenue Reporting Analyst – REMOTE Contracted Consultant Deep Sentinel: Pleasanton, CA

February 2021 to Juy 2023

• Weekly Sales report from Shopify into Quickbooks

• Monthly Hardware sales by State Report (Used to reconcile QB to Shopify)

• Deferred Revenue Schedule

• Pending Shipments report

• Deposits report for DS2 Product

• Chargebee Subscription Analysis Report (Monthly) Reconciled against Stripe transactions

• RMA Distribution Analysis Report

• Ad hoc Reports upon request

• Develop & Manage AR Aging via ChargeBee AR Module & ChargeBee Billing

• Collection & Credit Management

• Manage & delegate AR collections & Cash receipts tasks to team of nine support staff Financial Analyst

Melrose MAC Inc. - Hollywood, CA

August 2017 to February 2020

• Executive Management Reports - (Includes Balance Sheet, Income Statement, Gross Profit, Sales by Department, Summary by Store Location, Open Sales Orders, Sales Rep Analysis, etc)

• Weekly Sales & Inventory Reports - (98-100%) submitted on time per Reporting Conditions & Guidelines

• Vendor Weekly Reports

• AR Aging Reports

• Projected Collections

• Monthly APPLE/WACOM vendor Reports

• Advance Monthly Retail Trade Reports

• Credit Card (CAYAN, American Express, Authorize.net) deposit entries

• G/L adjusting Entries

• Inventory Flow Analysis Reports - Converted from Monthly to Weekly

• Invoice Posting Need Reports - Daily

• Client facing spend reports (Viacom, Sony, Netflix, HULU, Snapchat, MGM, WARNER BROS, OWN/ HARPO, etc)

• Client Rebate reports

MTEC - Engineering Labor Division

• TEC Financial Reporting

• TEC Aging Analysis

• Work In Progress Reporting

• Profit & Loss Analysis - Project Specific

• TEC Reporting support - Upon request

• Shipment Specifics reporting

• Cash Reconciliation Analysis

• Credit Card Payment Transactions Analysis

• Inventory Reconciliations - Adjusting Entries

REPORT Tutorials:

How to input SHIPPER & TRACKING INFORMATION

How to run the TEC Summary Report

How to Run the List Orders-Invoices by Location Report How to look up a Product Sold by Serial Number

How to run a Sell Thru Report

How to apply adjusting entries to the inventory

- Product Rebate SPIFF Reports

- Bulk Load Reports

- Client Sales Report Requests

- Sales Tax exempt Report

- ConnectWise (CRM) - Finance Lead

Department Representation - Infrastructure Development

- Unreconciled PO Reports

- Inventory Receiving Analysis

- Slow moving inventory Analysis

- Proposed new revenue models and initiatives for implementation Host of Project Analysis & Reports upon Request

Budget Analyst- Contracted Consultant

Golden State Foods, Inc. - Information Technology Div - Industry, CA July 2014 to April 2017

Food Manufacturing & Distribution (McDonald's, Chik-Fil-A, Pizza Hut, Chipotle, etc.) Software: Lawson GUI, Excel, Microsoft Outlook

• Research and establish variance models for budget analysis (Manufacturing & Distribution)

• Created an A/P payment schedule for $14 million budget

• Researched budget vs. actual for previous 3 yrs. to est. spending trends

• G/L Analysis & Reconciliation

• Audit software licensing agreements

• Review and process capital for building (CB) requests

• Analyze and monitor AP aging

• Code, batch, and process invoices for payment

• Analyze major IT consultant invoices (CSC, Manhattan, etc) Accounting (A/P) Analyst

The Society of Hispanic Professional Engineers, Inc - Industry, CA February 2013 to July 2014

City of Industry, CA

Accounting Specialist Consultant

Non-Profit February 2013 - July 2014

Software: QuickBooks Enterprise, Excel, Microsoft Outlook

* Process A/P schedules for distribution - 30 Invoices weekly

* Weekly/Bi-weekly Check Runs

* Analyze vendor accounts and payment schedules

* Managed cash and credit card positions with the Dir. of Finance

* Bank & Credit Card Reconciliations

* G/L Analysis & Reconciliation

* Analyze and reconcile cash & portfolio positions in the Merrill Lynch Investment/Endowment accounts

* Developed and Optimized expense reimbursement system

* Processed Directors & Officers Insurance for the foundation

* FY 11 & 12 AUDIT: Prepared Cash and A/P audit schedules

* FY 11 & 12 AUDIT: Analyzed specified Trial Balance transactions per auditors request

* Foundation: Process expense and grant funding distribution

* Analyze and manage budget control for foundation & distribution AR Analyst

Worldlink Media, Inc - Los Angeles, CA

January 2012 to February 2013

Short Form & Long Form Media Space Advertising-Television Software: Adtran, Peachtree Quantum, Excel

* Invoice distribution- Long Form (Infomercials) & Short Form (Direct Response)

* Aging Analysis-Primary focus on 60-120+ day aged account collections

* Check/Wire payment application

* Maintained low outstanding collections for Short and Long form accounts

* Developed A/R initiative with sales staff to ensure account payment/credit applications as part of a strategic goal to increase payment accuracy/turnaround.

* Managed multiple sub-accounts for major clients.

* Worked with network accounting to validate invoiced run times Staff Accountant

Aura Asset Group /TenantPlus.com - Los Angeles, CA August 2007 to January 2012

Property Management-Comm. & Res. Real Estate Investment/Online Rent Payment Software: Yardi Enterprise Systems, Peachtree Quantum, Excel

• Input and reconcile account payments from managed properties.

• Developed and managed data spreadsheets to bridge financial gap between Texas and California offices.

• Research and analyze financial projections to forecast future projected income.

• Process, Research, and Approve Credit Applications

• Rent aging-Property Collections

• Purchase order, Invoice and Vendor Ledger reconciliation.

• Credit Checks

• Lease verification/Vacancy-Occupancy Analysis

• GL Coding and Batching Invoices-Maintenance

• Check Runs

• Bank Reconciliation / Cash Flow Analysis

• Worked with Property Acquisitions Department on specialized financial projects. Billing Operations Manager

AMP'D Mobile - Santa Monica, CA

September 2005 to July 2007

Mobile Virtual Network Operation-Mobile Communication Voyager, BCG, MySQL, RSS, Micro Strategy, Net Aumen, Excel

• SQL queries developed and performed to assess errors and anomalies. Daily goals included adjusting the customer's account information to accurately reflect service packages, prices and contract life.

• Billing Cycle Suspense- Report used to reconcile minute usage through Voyager/BCG systems and RSS (Text messaging usage).

• Manage analyst team/ Escalation response: Billing and collections performance. Analyze escalation account activity for fraudulent information / activity.

• Credit Card Reconciliation analysis- Reconcile credit card transactions. Data research account / credit card transactions for payment anomalies, errors, payment amount, and fraudulent activity.

• Special analysis projects- Senior management

• TNI- Telephone Number Inventory - Inventory all telephone number distribution for the North American account activations. Develop Telephone numbering forecast based on quarterly productions.

• Managed a team of four analysts and achieved 93% accuracy of department goals. Accounting Analyst - Lead

LowerMyBills.com an Experian Company - Santa Monica, CA February 2003 to August 2005

Home Purchasing & Refinancing Lead generator

Softwares: QuickBooks Enterprise (Transitioned to Oracle Financials 11i- Oct. 2004), Crystal Reports, TOAD, Microsoft Access, Excel

• Invoiced client lead counts/credits.

• Gross Lead Reconciliation report: Data Accuracy analysis

• Cash Receipts Applications

• Balanced Credit Card Reconciliation reports for credit card processing.

• Compiled Invoice detail data for all invoices generated for Credit verification.

• Audit Credit Memo Reports for errors in billing. (monthly)

• Collections- Researched and compiled collections spreadsheet for delinquent payments. Decreased 90+ outstanding balances by 52%.

• Assisting in month end-General Ledger Reconciliation

• Active aging schedules for collections summary.

• Served as finance liaison between Sales Account Managers and clients.

• Issued invoices, account summaries, payment spreadsheets upon Sales or client request.

• Invoicing: Weekly- 200 invoices and credit memos AR Accountant / Credit &

Collections Research Analyst

Coca-Cola Enterprises - Los Angeles, CA

June 2000 to January 2003

Software: MAS90, Basic, Pentagon, Excel, Ice Cold (Internal Software)

• Audit Northwest and Southern California accounts to detect pricing errors

• G/L Reconciliation Research

• Invoicing Analysis on cost projections and discounts derived from multiple vendors in the Southern California area.

• Analyzed Charge backs for pricing accuracy

• Compiled financial spreadsheets through internal software (Ice Cold) to develop Account Receivable reports to submit to management.

• Processed invoicing schedules through AS400 software

• Invoicing: Between 750-1000 per week

• Research billing history to offer credit terms for successful regional clients

• Regional Collections: Worked with AR Aging to strategically offer payment options for 90-120+ aged collection accounts (78% success rate)

• Credit & Payment schedule monitoring for all Northwest Regional clients Education

Doctorate of Business Management - Information Technology Univ. of Phoenix:

3.3 gpa

February 2021 to Current

Master of Business Administration in Business Marketing Univ. of Phoenix:

3.4 gpa

August 2018 to November 2020

Bachelor of Science in Business Marketing

Univ. of Phoenix:

3.2 gpa

July 2014 to August 2016

High school diploma

Everett High School - Lansing, MI

August 1995 to June 1999

Skills / Software Experience

• Accounting (20+ years)

• Excel (10+ years)

• Invoicing (10+ years)

• MAS90 (5 years)

• QuickBooks (10+ years)

• General Ledger Accounting

• GAAP

• Microsoft Excel

• Sales Management

• Microsoft Powerpoint

• Financial Report Writing

• Bank Reconciliation

• Business Analysis

• Accounts Payable

• Balance Sheet Reconciliation

• Account Reconciliation

• Credit & Collections

• Marketing (8 years)

• Business Development (6 years)

• Sales Management (4 years)

• Journal Entries

• Microsoft SQL Server

• Computer Networking

• Financial Analysis

• Accounts Receivable

• Forecasting Analysis

• Internal Audits

• Financial Statement Preparation

Software and Additional Skills

AS 400, Basic, Ice Cold (Internal Software-Coca Cola), Pentagon, Epicor, EDI Invoicing, Yardi Enterprise,

Peach Tree Quantum, Oracle Financials 11i, QuickBooks Pro, QuickBooks Enterprise, People Soft,

Microsoft PowerPoint, Excel, Word, Access, Micro strategy, Discoverer, TOAD, Oracle- Net Acumen Portal, Visual Works, ACC PAC, MAS90, Lawson, Squirrel (SQL Database used to generate queried reports from the BCGI/Voyager software), RSS, Lightspeed (Apple Accounting software), Chargeback analysis, 92 WPM, 10 Key, Team Player, Clear and professional client communication

Contact this candidate