Patrick C. Email & Phone Number

-Conducted technical testing for system upgrades, enhancements, and patches.-Collaborated with technology teams to deliver ongoing support for critical applications daily.-Assisted Application Custodians to ensure information is current and compliant with RBC policies.-Managed extensive datasets, proficient in data transformation, cleansing, and reconciliation to ensure accuracy and reliability.-Diligently administered Systems, managing user setup procedures and ensuring robust data security measures for safeguarding sensitive information.-Assigned permissions to users based on job titles, ensuring access to relevant datasets aligned with their roles and responsibilities.-Proficient in initiating and managing change requests through ServiceNow for Development, System Acceptance Integration (SAI), and Production environments, ensuring seamless implementation of updates and enhancements.-Demonstrated a proactive approach to problem-solving and delivering successful outcomes.

Massachusetts, United States

-Responsible for loading, creating, and validating benchmark indices data to a central repository in addition to third-party systems. -Validated solutions/alerts to monitor raw data coming from the vendors, identifying issues, and providing accurate data to clients.-Engaged in research, mapping, and supporting newly incorporated benchmark indices within the service.-Analyzed Client data requirements concerning various Benchmark Data Providers (FTSE, Russell, MSCI, S&P, ICE BofA Indices, etc). I Liaisoned with external index vendors/internal teams regarding data issues such as data validations, late files, incorrect format changes, and erroneous data points. -Collaborated with BA/PM and internal clients to define, document, and develop new benchmarks.-Ensured data integrity across multiple environments by effectively QAing key data points.-Worked as QA to locate, troubleshoot, and resolve data gaps/issues as and when new data vendors signed up with the team.-Opened Salesforce/PTs to track and document new client requests, issues, and resolutions. -Attended weekly DEVOPS meetings to review the status of open PTs. Provide client/internal groups with status updates on their open items. -Supported the SaaS operation and implementation team with client upgrades. Work with these internal groups to onboard new clients. Checked client’s vendor licensing and confirmed their index contract allowance stated in the order form. -Participated in department-wide initiatives, including the annual review and upkeep of policies and procedures, checklists, and other ad hoc projects.-Updated servers with patches and CIP(Client Install Packages) so Clients receive the latest and greatest version of the CRIMS service. -Four-time BRAVO award winner nominated by the manager.

Massachusetts, United States

-Ensured accurate calculation of Index values via execution of all daily production procedures and controls while operating within strict deadlines.-Performed routine quality assurance procedures, verified prices, and monitored market activity to determine the impact on index levels of all ICE index products.-Consistently reviewed procedures and implemented enhancements/efficiencies created through additional tools to support existing products and potential new ICE index launches.-Provided information on business specifications for implementing new Index requirements within the test system. -Assisted with onboarding new clients who licensed new or existing ICE index products or data.-Responded to client inquiries, monitored index calculations, disseminated client files, and provided timely resolution of issues. -Liaised with internal Client Service teams to resolve incoming queries regarding ICE Index products.

Massachusetts, United States

-Delivered top-tier service to Financial Service clients, adeptly addressing inquiries, resolving concerns, and fulfilling requests with professionalism, thoroughness, and timeliness.-Partnered with internal Client, Sales, Product Management, and Development groups to provide solutions to client inquiries and ensure a seamless onboarding process.-Tested, implemented, and maintained ICE product requests.-Built strong relationships with top Funds clients, maintained documentation of client deliveries, and created and maintained new setups.-Prepared critical information for monthly status reports on new client set-ups, product enhancement, and special projects.-Monitored the file delivery production process daily.