Financial Analyst Reporting
Resume:
Seilas Phillips, MBA
Diamond Bar, CA *****
******.********@*****.***
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