• Accounts Receivable reconciliation including PayPal, credit card, RDS (electronic check processing system), cash and ACH deposits. Determined 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• Validated, reconciled and brought breaks to the attention of the department manager, ensuring that all files would be in good order for an audit in a fast paced and timely manner with full accuracy of all data entered, reviewed and input• Assisted with any requested reporting, planning meetings and all requests; used Excel for cross calculation and created reports

*Reviewed thoroughly all billing data and CE’s notations on each ticket for appropriate coding for billing transactions, review daily billing reports for accuracy and daily balancing to keep records accurate for daily as well as monthly billing and reporting. Provided Tier 1 customer service to both managers, CEs, end client and our interim Account Manager*Produced and maintained monthly billing via 8 reports for the Data Center and their separate reporting compiled for multiple specific inter-department and national client billing requirements *Compiled data for the RU Breakdown Templates and supply to national client for their interim review, approval*Generated and reviewed all billing reports on the IBM Cognos system, crafted new reports and utilized them on the IBM Cognos Query Studio for national account client billing for Incidents and Work Orders*Analyzed the reported data for statistical compilation for daily, weekly, monthly, yearly, and separate regional District Managers for more accurate and timely billing reporting. Assisted with each month end close process*Prepared and combined the daily reports (utilizing 12 reports from both 7.2 and 7.5 IBM Cognos and Query Studio reports) to then email the appropriate teams by District Manager for senior managements’ review*Created reports, compiled data for accuracy of CE (Client Engineer) coding on all reported Incidents and Work Orders for the monthly billing supplied to the national account team and management. Review costs applied and ensure accuracy of data supplied for both the CE and for the Data Center’s reports for billing to the National Account*Diagnosed 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 billing accuracy until reports were corrected and reconciled*Handled Special Project Billing Coordination and compilation of data for any special projects

• Reconciled Accounts Receivable billing using ADP and Dashboard for daily activity and billing balances, updated for daily balancing and payments received to have fully accurate reporting on daily basis• Created in RevPort fee system the quarterly and termination account fee billing, verifying fee rates, billing information, special instructions, and reviewed daily set up of data to bring accuracy and stability to quarterly billing and process termination payments daily as received to ensure timeliness and accuracy for the department’s daily reporting• Investigated underpayment/overpayment of fees that had been billed incorrectly over a protracted period, planned resolutions and worked with each end client to discuss their issues and their specific resolution in a clear and concise manner to facilitate clients’ trust in the billing process going forward for the dept. by providing top notch customer service• Facilitated discussions with custodians, providing Tier 1 customer service as well as enabling resolution of outstanding data transmissions of billing for accounts to achieve automated payment standards and timely receipt of payments• 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 for their review• Utilized Excel Pivot tables to streamline reporting of Referral fees for billing 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 accurately. Brought the department current in their aged accounts receivables for billing 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

• 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 6 weeks less 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

• 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 for accuracy and invested any 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 and thorough good customer service, enabled one custodian to merge over from manual reconciliation to the automated system

• 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

• Established TAMP procedures for Pershing’s new wrap fee program. Trained new reps in the TAMP programs• 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 customer 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