Sign in

Data Analyst Customer

Winchester, Virginia, 22601, United States
March 19, 2019

Contact this candidate


Michael R. Trainor

*** **** **** ****:412-***-****

Winchester, VA 22603 email:


Account reconciliation including cash, positions and trading history

Financial reporting including realized gain/loss history and calculations

Mutual fund and common stock security analysis

Creation and implementation of automated billing processes

Analysis of transaction processes to develop and implement alternatives

Design and deliver training materials and classes

Proficient in Microsoft Excel, Microsoft Word and Microsoft Outlook

Career Experience:

Kulak Design Associates, LLC


Consultant – Created accounting system for companywide revenues and expenses. Developed a reporting process to transfer accounting system data for use in preparing Partnership tax returns. Ongoing filing of Partnership tax returns and all Federal, State and local tax returns for partners.

BNYMellon – A Global Investment Company


Senior Reconciliation Associate - Provided professional support to Investment Managers and Clients through timely and accurate processing of trade instructions and related global and domestic transactions. Assisted in the resolution of trade problems to ensure accurate client statements. Created training materials and conducted training classes for new employees and cross training of existing employees.

Cookson, Peirce & Co. –A Registered Investment Counselor


Research Analyst and Trader– Responsible for reconciliation and maintenance of all client account positions. Monitor and maintain securities database. Provide support for securities selection process. Coordinated the conversion of all client data to new trading, reporting and client contact software system. Responsible for creating and processing all client trading activity. Created system models and tolerances for re-balancing Client accounts. Designed and implemented an automated client fee calculation and collection process which reduced costs and increased efficiency and accuracy.

The Fragasso Group, Inc. – A Full Service Financial Planning Company


Assistant Portfolio and Information Systems Manager – Responsible for securities

selection and account reporting for over 600 clients. Created, delivered and maintained a reporting system for tracking customer non-transferable retirement asset accounts that resulted in the generation of $150,000 in additional revenues. Researched and installed a customer contact system that reduced telephone costs by 60% and substantially raised consultants’ efficiencies and capabilities. Responsible for developing, installing and maintaining customer accounts, security positions and tax reporting systems.

Converted historical performance information to new portfolio management software permitting continuous, accurate customer reporting.

Federated Investors – A National Leader in Financial Investments


Data Analyst – Responsible for reconciling and balancing five mutual funds and for

maintaining the security database. Coordinate and test enhancements to the trading system. Converted five Smith Barney mutual funds into new Federated Investors mutual funds. Insured accurate positions and timely opening of new funds.

Mellon Financial – An International Financial Services Company


Collective Trust Associate – Responsible for the Mutual Fund Processing unit with nine employees posting trades and dividends for over 2000 customer accounts. Managed a yearly budget of over $315,000. Responsible for employee evaluations and hiring for new staff.Responsible for the daily valuation of five Collective Trust funds with net asset value of over $5 billion. Completed project that identified and collected over $350,000 in outstanding foreign dividends and tax reclaim accruals. Responsible for determining and posting all global corporate actions for customer holdings in Australia, New Zealand, Italy, Spain, Portugal, Mexico and Canada. Completed project that balanced all customer positions with sub-custodian banks. Designed and implemented automated system for processing principal and interest payments increasing daily volume from 125 transaction to over 3,000 transactions per day.

Education and Continuing Development:

Professional Certificate of Accountancy

Duquesne University

Master of Business Administration degree

Duquesne University

Bachelor of Science degree in Mineral Economics

The Pennsylvania State University

Contact this candidate