Data Analyst Accountant

Mercedes Marquina 347-***-****

Lindenhurst NY *1757 *********.*****@*****.***

SUMMARY

Focused, determined, results-driven Data Analyst and Administrator with experience servicing both private and institutional, high-net worth clients in all aspects of financial business operations. Strong management skills and attention to detail. Capable of prioritizing, executing, and multitasking projects in a timely manner. Work well independently. Great team player with ability to work under pressure in a fast-pace environment with strong communication skills. Bilingual in English and Spanish.

Computer proficiency in: Advent APX, MOXY, DataExchange, ISS, Blooomberg, NetExchange, DTCC, OMGEO, with extensive knowledge of MS Excel, Word, Outlook, Lotus Notes, Access, DST Data System, Rumba 5.2, Data Library, SmartStream, Tamarac.

PROFESSIONAL EXPERIENCE

Stralem & Company Incorporated, New York, NY 2006-2019

Portfolio Administrator

Managed all aspects of the account opening process for both institutional and private clients across various types of accounts.

Collaborated with custodians and brokers to control that all cash and positions are reconciled, trade settlement and corporate actions.

Monitored and set-up accounts across different integrated portfolios and client portfolio management platforms such as Advent APX, Tamarac,ByAllAccounts and brokers (Moxy).

Acted as a liaison through the portfolio managers or directly with the clients to process requests of all asset movements.

Assisted in the quality control of account attributes and data to various parties, auditors, accountants and clients.

Maintained client’s cost basis which is integral to timely and efficiently trade execution for the purpose of tax harvesting.

Collaborated with the different Portfolio Managers to ensure that they are aware of all corporate actions, voluntary or mandatory, such as mergers, splits and spin-offs.

Directed performance verification by ACA Compliance group to make sure the firm has complied with all the composite construction requirements of the Global Investment Performance Standards (GIPS®).

Worked together with client and third parties to set up accounts for electronic feeds and online access through various platforms and interfaces: Advent (APX) Dashboard, Dataport, ByAllAccounts, Tamarac and banks.

Collaborated with firm’s Controller and Compliance Officer on numerous internal compliance projects in areas such as Billing, Asset Allocation and Guidelines/Restrictions reviews.

MERCEDES MARQUINA page 2

Alliance Capital Management LP, White Plains, NY 1999–2006

Portfolio Administrator

Performed daily and monthly reconciliation of equity positions, cash income, trade activity and multi-currency cash balances.

Prepared and maintained accurate and complete information on daily mutual fund activity using SmartStream .

Identified and resolved issues related to month-end and market value discrepancies.

Collected, reviewed and provided analysis for over 70 equity and fixed income mutual fund positions.

Evaluated trading activity to ensure portfolio guidelines and restrictions are satisfied. Interacted with trade operations to ensure successful settlements of all trades.

Reviewed internal reports to ensure accuracy of data in portfolios. Updated internal records where necessary. Investigated and resolved discrepancies between internal records and custodian statements.

Sanwa Securities (USA) CO., L.P., New York, NY 1998-1999

Accountant

Prepared daily estimated broker/dealer balance sheet including review of inventory, finance and customer receivable/payable components.

Morgan Stanley Discover & CO., New York, NY 1996-1998

Mutual Fund Accountant

Reconciled daily bank statement and determined cash availability of portfolios for investment purposes while serving as liaison between portfolio managers and bank custodians.

Processed trades involving foreign and domestic equities, commercial paper and repurchase agreements, utilizing DST.

Provided Auditors with account information. Maintained accurate records of all related fund information.

Prepared month-end reports such as: Aging schedule, Expense analysis and Portfolio Turnover.

Interfaced daily with Asian and European Securities market to verify trades and dividend corporate actions.

Inputted daily prices for domestic and international securities; verified all prices to assure the accuracy of the NAV calculation and then transmitted to NASDAQ.

EDUCATION

Queens College of the City University, New York, NY

BA Accounting

Contact this candidate