Robert Crain Email and Phone Number

Responsible for the processing of all Security Assets and maintenance for Banking & Investment firms. My team interacts directly with Portfolio Management, Reconciliation, Settlements, Compliance, Client Reporting, Pricing and Technology. Assist with Operations to ensure Data Integrity across multiple databases. Cross reference information relating to CUSIP/ISIN/SEDOL numbers or other market identifiers. Vendor-to-Vendor Informational Comparisons.Ensure that business objectives, project scope, and systems requirements are clearly understood by the development team. Analyze the causes and effects of business problems, evaluate options and propose solutions. Analyze and understand the various business rules within the Product Master system. Possess intimate understanding of Security Master Reference and Pricing Data. Translate business systems requirements into functional specifications for developers. ( SME ) Subject Matter Expert.Develop/execute comprehensive function testing on any application changes. Work with cross-functional teams to develop applications. Manage multiple priorities associated with multiple, concurrent application changes and/or projects. Analyze production issues when they occur and be able to determine root causes and propose resolutions. Provide Subject Matter Expertise on Security Master Reference and Pricing Data to business and systems associates. Assist in developing end-user training content for use in instructor-lead and technology-based training.Work with customers throughout the training process by collecting and analyzing feedback. Ensure that test conditions are translated into test scripts without loss of intent. Review the actual test results against expected results and assess whether the test conditions are met. Ensure accurate and timely reporting of defects and drive defect resolution. Deep experience in( UAT ) functional testing processes including Test Strategy, Test Planning &Test Condition.

Providing Information Regarding Custody Activity/Inventory for the Recon Area. Downloading Accounts Information (Citibank). Run Morning Production (Current Market Reports, GAAP, and Matrix Reports) Support Corp Actions. Review Account Balance Report. Analyze Security Master, Asset Set Up, Process Manual Daily Cash Recon, SunGard Invest-One Parallel Testing and Production for Wealth Management Clients. Process( Security Master ) Enterprise Citrix Solutions. The Security Master and Pricing team designs, develops, implements, and supports security master reference and pricing data for the clients Brokerage platform. The development team focuses on delivering innovative solutions that meet the needs of our clients. Test Lead Responsibilities Coordinate test execution activities for a group of applications across all test phases Track and manage issues/risks through resolution Serve as project’s point of contact for the respective test execution teams. Allocate work to team members report / coordinate test creation and execution status. Generate and communicate status reports for test execution activities. Demonstrate understanding of the functional requirements, data needs, business operations work flow for various processes and asset classes for responsibility area.

Responsible for Asset Management, Security Type, Closing Price, Trading Blotter. Analyze Archives and Security Master Database. Reconcile Data Discrepancies. Adjust Current Restrictions on Assets being traded. Also Research Corp Action's Data on Bloomberg. Knowledge of Asset Set-Up on Macgregor, SunGard Systems Invest-One & Parallel Testing.Schedule and track technical and department users utilizing testing lab resources. Document testing results in both the as-is and to-be context.Develop test scripts, test plans and test scenarios based on the as-is state as well as the to-be models. Document results of application testing for Windows 7/Office Replacement. Utilize application database tracking to manage application certification. Directs quality of entire systems ensuring that the systems meet the needs of the Business Unit through user acceptance testing .- Mentors less experienced Systems Analysts.

Provide Data Integrity, Spreadsheet Analysis and research for the support of Control, Transfer, and Contributions. Maintain departmental logs, and resolve problem situations. Mutual Funds Processing. Conversion and Emerging Databases for data clean up. Update of PAM Accounting Systems and Security Master Files. Ability to summarize and report application testing results. Experience in Buy Side/Securities Services industry, including middle office and back office processes Strong understanding of trade lifecycle and post trade processing activities for various asset classes. Functional knowledge of products in responsibility area. Strong communication and team management skills.

Creating new accounts on UNIX and Mainframe systems. Edit and change Allocations, Annuity, and Beneficiary information on requests. Maintain Investment and Participation Agreements. Conversion and Emerging Databases for data clean up (MIDAS). Mutual Funds Processing (CFE- Common Front End Systems). Transmit data to service providers. Attend project and team meetings to report results and take assignments.Detailed knowledge of a broad range of financial instruments, investment securities and the capital markets. (Equity, ADRs, MBS, ABS, Corporates, FI and Equity Futures, Options, etc.) Lead and assist business users for operational readiness as part of every relevant project.

Act as a Liaison between Front and Back Office Groups. Interface with Compliance Group to Understand Pricing Requirements, Issues and Business Needs. Analyze Security Master Database and Produce Detailed Business Requirements. Reconcile Data Discrepancies for Wealth Management Clients. Perform all Functions of a Project Management Role including Planning, Prioritization, Resource Allocation, Management Reporting, Coordination between Internal Departments,And Outside Vendors, Implementation, and Post Release Support. Monitoring and Automated 8,500 Issues for Pricing Purposes. Support of Custody Settlements, Corporate Actions. Life Cycle Performance Testing. Data scrubbing and Data Governance. Support of SEI functionally.

Process Changes to Asset Master Data (Security Master Data Files) for PortfoliosManagement. Prepare, Attend, Help Facilitate and Document User/ Project Team Meetings. Develop High Quality Presentations/Reports to Effectively Communicate Project Findings. Track Benchmark Performance of Current Indicators for Domestic & International Identifiers. Monitoring and Automated Issues for Mid and End Month Pricing. Management of Pricing for Corporate and Treasury bond Indices. Distribute Information to The Wall Street Journal, CNN News, and the Financial News Networks. Knowledge of MBS Hedge Fund Reports. Relationship with 3rd Party Vendor for Security Master/ Reference Data for Wealth Management Clients.