Financial Analyst Accounts Receivable

Debra J. Russell

*** ******** ***., #*****, *******, FL 32828

551-***-****, ************@*****.***

Work Experience:

CBS Radio/Entercom, Orlando, FL

Financial Analyst Temp: October 2017 to February 2018

●Review cash and credit card payments versus the invoices and correct any inaccuracies

●Generate Special Handling/Co-Op Invoices weekly and at month end for Billing periods

●Write up procedures and enhance current procedures for audit/changes due to merger and change over from IBS to Wide Orbit

●Create Oracle ERP aging reports and ensure all payments are applied to reduce missed revenue/commissions

●Use Wide Orbit/IBS Sales Desktop to create invoices, review accounts, assist AEs with any inquiries and review Log reports.

●Submit and follow up on all accounts payable items, special requests by the manager

●Create Memo Bill invoicing, review and finalize Non-Spot Reconciliation; used Macros in Excel

YMCA, Orlando, FL Temp: October 2016 to January 2017

Financial Analyst

●Accounts Receivable reconciliations including PayPal, credit card, RDS (an electronic check processing system), cash and ACH deposits. Determine if customer payments were missing, underpayments, overpayments, and suggest course of action

●Reconciliation of refunds, discount adjustments, partial period refunds and validating postings to their CRM (Client Reporting Management) system for accurate historical reporting and records management of past and future client transactions

●Validate, reconcile and bring breaks to the attention of the department manager, ensuring that all files would be in good order for an imminent audit in a fast paced and timely manner with full accuracy of all data entered, adjusted, reviewed and input

●Assist with any requested reporting, planning meetings and all requests, use Excel cross calculation as needed and create reports as requested by management. Used calculations, macros and Pivot tables in Excel.

Apex Computer Systems, Inc., Orlando, FL & Cerritos, CA Temp: November 2013 to April 201

Financial Analyst

●Generate and review all needed reports on the IBM Cognos system, craft and utilize the reports on the IBM Cognos Query Studio for national account client billing for Incidents and Work Orders for daily reporting and monthly billing, analysis of the reported data for statistical compilation for daily, weekly, monthly, yearly, and separate regional District Managers review.

●Prepare and combine the daily reports utilizing 12 reports from both 7.2 and 7.5 IBM Cognos and Query Studio reports and email the appropriate Apex Management Teams by District Manger

●Produce and maintain monthly billing via 8 reports for the Data Center and their separate reporting of their specialized work compiled for multiple specific inter-department and national client billing requirements

●Compile data for the RU Breakdown Templates and supply to national client for their interim review while the finalized billing is being completed for the month. Used macros, calculations, & Pivot tables in Excel.

●Diagnose issue with reporting wherein the systemic reports were incorrectly calculating the “reported by” fields and built separate reports for authentication of the issue and for future corrected billing until reports could be reconciled with the national account team

●Assist with Special Project Billing Coordination and compilation of data as needed for any projects ongoing with the firm, ensure accurate cost is applied, discounts, and payment processes are annotated therein

●Assemble training procedures and maintain for each month due to interim changes in the reporting systems, pricing and data required to meet the National Account Client’s needs as well as their Third Party Firm Account Manager’s review/requests

Barclays Wealth Management, New York, NY Temp: August 2011 to March 31, 2013

Fee Analyst

●Participated in project planning for expansion of the RevPort system, streamlining their Accounts Receivable and Referral Fee processes, updated Excels for Research and Dev teams for reporting of fees to upper management

●Facilitated discussions with custodians, enabling resolution of outstanding data transmissions to achieve automated payment standards and handled trade breaks on the Advent APX for the portfolio team

●Investigated underpayment and overpayment of fees that had been billed incorrectly over a protracted period, planned resolutions and worked with each client to discuss their issue and their specific resolution in a clear and concise manner to facilitate clients’ trust in billing process going forward for the dept. Enacted procedures to prevent issue from occurring again in process.

●Created in RevPort fee system the quarterly and termination fee billing, verifying fee rates, billing information, special instructions, and reviewed daily set up of data to bring accuracy and stability to quarterly billing

●Trained in Microsoft Access, enabling the creation of invoice reports to send to their IRs and clients decreasing the time required for generation of certain reports that were required by the IRs for Accounts Receivable process of Quarterly Fees

●Utilized Excel Pivot tables and Macros to streamline reporting of Referral fees for processing and upper management reports. Utilized VLookups on Referral fees and also on daily use of the fee billing to look up proper Rep, Office, Delivery Instructions, etc. for fee billing data to be sent. Created and maintained the database during the time with Fee Billing Dept.

●Brought the department current in their aged accounts receivables using Excel to log and track aging receivables; received 2.9 million dollars in outstanding aged invoices in 4 months: total manual invoices paid in 13 months: 12.3 million dollars

Beck, Mack & Oliver LLC, New York, NY March 2008 to September 2010

Senior Portfolio Administrator

●Merged price file for the week and downloaded dividend, interest, T-Bill interest and split transactions from Interactive Data Corporation, showing partners that they could have performance on a daily or weekly basis with accrued interest

●Ran Daily and Weekly performance with dividend and interest on an account by account basis, reconciling any items that broke and reviewing performance for accuracy, improving their standard process by 6weeks time

●Reviewed corporate action items daily and advised managers of any bonds being called, spin-offs, or any other items that would impact clients

●Downloaded and translated data feed from custodian using Dataport; translated transactions including deposits and cleaned Dataport transaction files for cleaner processing and more accurate data for a faster response time for reporting

●Started Advent DTCC process, downloading, translating, matching, and reconciling confirms using DTCC for all prior day trades, monitored for any anomalies requiring review by trading, reviewed and noted any breaks on commission, SEC fees, shares, security types, for a faster response time for reporting trading issues to traders

●Reconciled accounts to custodian using Rexx in the Dataport system and the position files supplied by the custodian and the Advent custodial data feed for faster daily and weekly verification of holdings

●Performed administration of Moxy system including applying restrictions to accounts as required, cleared locked orders, and security maintenance for traders as needed and upon request of new security transactions

Traust Sollus Wealth Management F.K.A. Zdenek Financial Planning, Flemington, NJ March 2007 to March 2008

Investment Services Supervisor Firm Relocated to South Jersey

●Created customized reports on the Axys Report Writer to streamline tax season and updated quarterly reporting

●Coordinated the yearly audit of the ZFP Fixed Income hedge fund

●Handled review of assistant and submitted review notes to the partners for their final review

●Enhanced loading and processing of Fee Billing into Axys for the Accounts Receivable manager for faster, more accurate processing of data

●Added to the Quarterly Recap index benchmark information, mutual fund returns, and SMA managers’ returns

●Reviewed cash balances on mutual fund accounts and invested excess funds

●Created year-end tax extract reports of Income and Realized Gain/Loss for tax preparation

●Manually reconciled accounts monthly versus the custodial statements for non-Rexx enabled custodians

Jacobs Levy Equity Management, Florham Park, NJ July 2004 to August 2006

Portfolio Accountant Corp. Restructuring

●Created and maintained performance excel sheet which compared our returns versus the custodians’ and third parties’ monthly, yearly, annualized to date and inception to date to enable the partners to better discuss the differences due to performance calculations used by other parties, thereby resolving client concerns

●Reviewed Oasys files from the prior night’s processing to make sure all allocations were taken in by brokers and utilized Trade Suite to affirm unmatched trades that did not automatically match and resolved any incorrect confirms with discussions with Traders of our trade away transactions, making sure to update cost basis information

●Generated daily, weekly and monthly performance for the partners for current data reports for client meetings

●Manually reconciled accounts against broker and bank statements on a monthly basis; worked with custodian contacts on any breaks or delays in corporate action processes, notified traders of any pending securities for their trading holds

●Inquired and resolved reconciliation issues with the custodians for proper entry into client files on Axys

Bank of New York/Pershing, Jersey City, NJ June 2000 to July 2004

Client Service Liaison

●Established TAMP procedures for Pershing’s new wrap fee program

●Trained new reps in the TAMP programs, assisted in conversion of new wrap fee and RIA clients to our systems

●Reviewed ADVs of Privately Managed Account Program (PMAP) managers before final review by Compliance

●Designed, authenticated and maintained statistical data for email service for dept. on Excel workbooks

●Handled day to day service for Turnkey Asset Management Programs (TAMPs), Tier 1 RIAs and Hedge Funds

●Worked with PMAP managers to resolve trade issues, set up DTC Id Confirms, requested proper system codes for their accounts for proper routing of APL return files

●Answered performance questions from Hedge Fund clients. resolved their issues, and worked with Performance Group

●Handled cash, ACH, security loan, trade settlement issues and worked with many departments to facilitate client requests

Software Experience:

Oracle ERP, Wide Orbit, IBS Sales Desktop, SharePiunt,, IBM Cognos Reporting, IBM Cognos Query Studio Report Creation and Maintenance, RevPort, Microsoft Access, Advent Axys & APX, Oasys, Portia, Alert, ProxyEdge, GPS, Acromobile, Microsoft Excel, Word, MS Outlook, DTC Trade Suite, Lotus Notes, Advent’s Dataport, DTCC and Moxy Software systems. I am training in SQL.

License & Education:

Series 7 (Expired July 2006). Associates Degree from Natha url Hawthorne. I am currently learning SQL, Macros on Excel and taking college courses with Penn Foster’s online program. In February, 2011, I attended a two day training class in the new Portia system and have taken Performance Training classes toward CGIPs.

Contact this candidate