SettlementsCleaning up and Setting up fails based on data from Daily Reports, Delivering Physical Certificates to other Brokers through DTCC. Knowledge of DTC CUST and New York Window.Prime BrokerageProcess data entry and perform reporting tasks related to Prime Brokerage. Book Journal Entries in BPS, Automate Excel and Access Reports using Visual Basic Macros to “Screen-Scrape” data in BPS Reflection Sessions. Utilize Monarch Text File Extraction tool to convert print image reports into usable data files.

VBA ProgrammingUsed VBA to streamline manually intensive processes to increase productivity and efficiency in Brokerage Operations departments: ATS, PNS, Reorg, Mutual Funds, New Accounts, Dividends, and OCD.Access Database CreationDeveloped Microsoft Access Databases to automate and streamline Periodic Reporting Processes, freeing up Associates for other daily responsibilities. Examples include Metric Databases for ATS, Dividends, and R&D.Monarch ReportingProficient in Monarch, a DataWatch Program for extracting data from print image reports, to provide access to report data into a more user friendly format like Excel.Monthly Metric ReportingCreated a front-end tool for Operation associates to record daily metrics into a centralized database to automate the creation of month-end management reports in a PowerPoint Presentation.Basic Level System SupportUtilize my technical skills and knowledge of computer systems to troubleshoot basic questions, ranging from Missing toolbars to Customizing Graphical User Interfaces.

Maintained Mutual Funds Databases (Access & SuRPAS)Used Microsoft Access to set up new Mutual Funds and edit existing Mutual Funds in both Access and SuRPAS.Customer Service via Phone, Web and Outlook InquiriesAnswered Customer, Middle Office, and Internal Inquires about Mutual Funds using information found in the previously stated Databases.