Richard Finn

Conversion Team member working as the Requirements Lead and Sr. Business Analyst for the Global Custodian Conversion (BNYM to Citibank and HSBC), the associated Wealth Management account conversion (SEI Trust 3000 and SWP), and process reengineering/improvement work related to Asset Data (Security Master and Pricing across all asset classes and types), Trade Settlements and Security Movement & Control (SMAC), Corporate Actions, Income Collection, Tax Reclamation, FX Trading/Repatriation, Cash DDA, Proxy, Fees and Regulatory Reporting and New Accounts processes.·

• Requirements Manager across 17 cross functional teams responsible for gathering and driving requirements, driving deliverables, facilitating Impact Assessments, Requirements Sessions, Application Design Sessions (JAD) sessions with workshops to create high level designs (HLD), complex detailed workflows, System Requirements Specifications and obtain sign-off from business partners across multiple operational lines.
• Defined requirements for the redesign of SWIFT ISO15022 > ISO 20022 GTX API messaging protocols creating system and technical specs for the system integration work between SEI Trust 3000 messing hub, Citibank India and HSBC
• Translating business requirements (BRD) to functional system specifications (FRD/SRS) for Custody Operations, SEI mainframe and GTX MQ messaging developers, by creating current and future state workflows, source to target data mapping, transition state diagrams, UML Use Case diagrams and narrative, logical and physical data models for Oracle and Azure BIS environment.
• Working with Line of Business owners, Data Governance Review Board and Project Managers to ensure that requirements and development of processes and data updates adhere to Data Governance policies, are concisely vetted and understood by the data repository DevOps team, downstream data consumers and the Trust Accounting mainframe system engineers and developers.
• Working as a Data Stewards in the Global Custody space identifying and resolving data quality exceptions, authoring data definitions, making updates to tables, data elements and meta-data across multiple database domains and schemas for the Global Custodian Network taxonomy set of tables (40).
• Tasked to ensure Data Quality of conversion data including accurate data lineage flow, data completeness, data integrity checks, creating list of valid values, providing data definitions, update rules and meta data information on Global Custody CDE’s for the Data Governance framework (preparation for Collibra implementation in 2025).
• Defined hierarchies, entities, scrubbing rules and ETL translation rules for MDM developers.
• Performed conversion data profiling and data scrubbing on Asset Management, Trading Settlement, Corporate Action, Proxy and Pricing inbound files from sub-custodian through to staging tables and performed data validations in QA, UAT and Production.
• Creation of Data Quality dashboards using Tibco-Spotfire and Power BI, Excel Pivot Tables, Visio Data Models, Workflows, Transition State, Use Case / UML diagrams to depict data relationships and data quality metrics between vendor and client data (PII) and investments profiles and asset allocations across vendor portal extracts and stored reference and transactional data (in mainframe core system SEI T3K, Oracle RDBMS and Azure.
• Work across the enterprise databases to create and run daily data extracts, export files, reports, comparisons, look ups, pivot tables to support asset allocations, trade settlements, pricing and valuation of all non-US securities effected by the conversion.
• Performed hands on data profiling of inbound and outbound SWIFT messages (100, 200 300, 500 and 900 series) analyzing tags and content, defining automation for the reformatting of targeted MQ messages, edits and data quality checks, performing data mining, data scrubbing / cleansing and data preparation of load data to mainframe and Oracle databases (ODR/ODS/ODT).
• Participation in daily Scrum stand up calls, backlog grooming and PI release planning activities including creation and management of backlog tasks in an Agile tools (Rally/JIRA), managing a portfolio of Epics and User Stories in Rally/JIRA.

Solutioning DevOps Business Analyst and Data Steward for the data normalization project supporting newly designed Reference Data, Master Data and Data Governance systems. Successful in identifying opportunities to migrate legacy datasets and processes from mainframe, excel, DB2, SAP datasets to the newly designed Oracle DWH target state. High success rate of deliverables and responsibilities in a fluid environment under development with a technology stack of Oracle, DataStage, RDBMS, Collibra, SAP, Archer, Snowflake, Rally, SharePoint, ServiceNow, technology stack. Tasked to:

• Re-design and normalize the Catastrophic Weather and Critical Loss event repository and tracking system (CATS), in the Reference Data / MDM target state by defining tables and UI screen functionality, performing data clean up and enrichment which resulted in a single source of truth “Golden Copy” in Catastrophe processing and data consumption by designing cross-functional reference tables for the mastering of primary and meta-data to over 5,000 traceable Catastrophe Events (Natural and Man-made) across 12 independent lines of business and reporting.
• Data Steward working in the Oracle RDBMS and Collibra implementation responsible for the promotion of tables and data of 250+ RDM tables, their content and associated meta-data, logic rules, authoring of business glossary data descriptions, definitions, usage, and Terms & Conditions across the Catastrophic Event domain, Cause of Loss, Injury, Damage, ISO 3166-2 Country, Subdivision, Location Clusters, ISO 4217 Currency, Workers Compensation, Property Claims, Injury, Damage, Anatomy, Payments, Business Unit and Company/Legal Entity Blueprint hierarchy of tables.
• Managing adds, deleted, updates in Collibra and data staging for Informatica Hybrid MDM.
• Managing inbound data source files from Property & Casualty (PCS), National Weather Service, FEMA, NTSB, FAA
• Provided hands on Data Governance and Stewardship in Collibra modules, tables, datasets and their associated DWH tables insuring CDE data replication and continuity, updating Business and Technical Ownership, performing data quality checks in RDM and Collibra including setting up new users and establishing User Rights & Entitlements. Daily workflow queue managements in the Issue Management and Remediation components of the Collibra architecture.
• Conducted user and technology reviews and walkthrough sessions across multiple business lines with a wide array of users as well as senior management, department heads, team leads and Scrum Masters.
• Managed daily updates to the Catastrophe and Cause Loss tables including data enrichment, meta data changes, creation of upload files, performed validations in UAT and monitored daily CAT user entries in Collibra and RDBMS systems.
• Defined current and future-state workflows, created logical and physical data models for the development of the target state, provide data procurement, profiling, and data mapping of multiple sources to target states with rules for both internal and externally sourced and vendor managed data supporting the integration of Claims Loss product, Adjusters, Underwriting, Actuary information to the RDM, Collibra and ERM Archer system standards and protocols.
• Create roadmaps, logical data models, process flows and narratives, performing walk-throughs to business stakeholders, DDRB (Data Governance Review Boards) and DGC (Data Governance Council) oversight committees.
• Convert legacy Policy/Customer data in SAP to the new Reference Data domains including Account, Interested Party, Company Directory, Profit, Cost and Division Centers, Business Unit Hierarchy, MLOB (Master Line of Business) taxonomy of tables supporting data processing and internal/external regulatory reporting.
• Manage a portfolio of Epics, Features, User Stories and Releases in Rally and its associated JIRA/Confluence framework by provide backlog grooming, updates, acceptance criteria, approvals across multiple lines of business, schemas, data domains and environments through all levels of SDLC starting with Requirements Management through to production release.
• Daily stand up in scrum calls, PI Planning, Release Management and Change Control activities using Rally as an AGILE/SCRUM management solution. Creation of Epics, Features, user stories and their acceptance criteria.
• Define the reference data architecture, system tables, ETL/ELT, data provisioning and meta data content management of an RDM/MDM domain solution as part of the EDM ERP Business Intelligence project and its integration into customer, policy, and product data hierarchies.
• Source to target mapping and table stand up of Payment Types, Transaction Types, Payment Settlement data domains.
• Defined and managed Critical Data Elements (CDE’s), KPI’s, structured and unstructured meta data, match/merge rules, data propagation, ETL transformations, Cross-reference files, internal and external vendor sourced data, golden copy creation, data subscription and data consumption across 30 backend schemas / domains to a uniquely defined normalized set table structure and data elements oracle data warehouse.
• Conducted workshops to elicit user requirements/use cases, document current and future state process flow, identify “pain points” and suggest solutions, define matching/merge rules and data propagation between staging and consumption layers.
• Testing Manager Role for the General Insurance Reference Data domain including Change Control managing MDM testing of data loads, match/merge, golden copy and the promotion of structures and jobs through DEV/QA /UAT environments.

Tasked to define, build and deploy an Oracle data Repository and File Delivery/Release Management Control Service in support of the Split Merge of all Wells Fargo and SEI Trust 300 data extracts, leveraging Master Data Management (MDM) and Data Governance (DG) processes in Informatica 10.4.

• Creation of artifacts and documentation to detail system functionality and flows to assist the implementation of the newly created PFG Business Line System Integration and Intelligence layer.
• Provided insight, guidance, and day to day file management between Wells Fargo, PFG and SEI Trust 3K Technology teams to set up the environment and assist in the complete split of “Business as Usual” processes.
• Working with Atacama ONE, DQ Analyzer, tasked to profile and compare all Trust / Custody Data Extract files EBR -Spectr Pension Statements, Corporate Actions and Security Master Reference Data (200+ files) with Bloomberg & Reuters flat files to streamline exception handling and error processing.
• Leverage output of DQA to support on- going Data Source Validations, Data File mapping, Data table and element set up and maintenance as well as unstructured and structured text fields related to Global Custody & Trust processing.
• Creation of full set of UML Architecture and Integration Models.
• Artifacts include Traceability Matrix, Current and Future State models and workflows. Functional specs on Batch job management, JCL Load to In-data using ETL Informatica processes supporting Trust Custody and Wealth Management
• Implementation of a Digital Reference Catalogue using Azure and SQL Server + proprietary technology ODT and ODR Database Services from SEI Trust 3000.
• Deep dive analysis of all files set for vendor transmission and creation of the stand-up Master File MDM
• Hands on works with Teradata RDBMS, Data Warehouse, Data Mart, Data Lake for Event Management and Transactional Data Storage, Ad- hoc Reporting and management of the Reference Data Catalogue Trusted Data and Golden Copy Source of Truth processing.

Requirements Manager & Sr. Business Analyst IV for the MDM (EIM) Enterprise Information Management Project (ERP/CRM Customer 360 Informatica Collibra), defining systemic solutions through Informatica – Master Data Management suite of products.

• Defined requirements for the Informatica Customer 360 and Collibra implementation creating Business and functional specifications with definitions of services, classes, features and functions for the Entity Management project to implement and track GDPR data using Data Quality (Data Integrity and Completeness) with DSS Data Security Standards and Masking techniques.
• Creation of Functional and Design specifications around GDPR, ISO 3166, CCAP, Policy, Contracts, Obligations, Control & Rules databases, and processes which will be used in Collibra.
• Performed data analysis, data scrubbing and meta data updates for tables and CDE’s in the ISO geography hierarchies, product and business entity tables and content including data profiling from legacy mainframe extracts, DB2, and Oracle databases, defining match/merge specification, fuzzy logic, data propagation, tracking data lineage and making updates in the application to resolve exceptions.
• Lead Business Analyst coordinating the requirements and implementation efforts around the full SDLC of the Entity Management in MDM and Global Policies Engine deliverables defining match/merge, scrubbing, meta data and data propagation while ensuring data quality and data lineage is aligned with target state.
• Creation of Business & Functional requirements with regards Data Privacy (On soil & Cloud.
• Conducted user and vendor interviews to support the selection of technology tools needed for the execution of Data Governance and MDM HUB data quality / data clean-up work.
• Creation of customized road maps, dashboards, and visualizations.
• Defined specifications for Product, Customer, Business Unit, Payment Method and Card Issuance Hierarchies, Inventories, Data Flows HLD LLD and BPWM
• Establishment of Source of Truth processing standards during data conversion from legacy to newly developed domains.
• Facilitated effective communication between technical and non-technical stakeholders by translating complex concepts into easily understandable language.

Working in the capacity as Sr. Business Analyst and Trust System SME to normalize and convert data from Wealth/Trust IRT & Legacy Risk Financial Systems to the new 3rd Party SEI T3K SWP Wealth Management platform supporting Asset Management, Payments, Corporate Action, Trade Settlements, Counterparty Trade Surveillance, Asset Statements and CDE’s for CCAR BCBS 239 compliance and regulatory reporting.

• Focus on defining the future-state with supporting Workflows, Data Mapping, Data Views supporting both Customer and Street Side Data. Creation of User Stories and Use Cases for the normalized “One Stop Shop Initiative”.
• Liaison with SEI Investment T3K Development and Testing Staff. Worked within the MDM Group structure focusing on ETL, Data Quality and Data Governance teams eliciting Requirements, Data Mapping documentation as well as performing Data Profiling for 3rd party inbound data. Creation of Business and Functional Specifications in support of CCAR Basel III BCBS239 reporting working both directly on site and remotely as a team lead.
• Tasked to bridge the gap between legacy system Trust and Custody systems as well as targeted systems be decommissioned as a recent of recent acquisitions and the new Enterprise Data Warehouse. Defined “Match Merge” rules to support Golden Source Asset Data records.
• Major tasks included: Identification of KDE/KPI’s (Key Data Elements and Performance Indicators) for the new CRM system across Risk, Finance, Legal Compliance with goal set to normalize fields across the bank in the following domains: Asset Class, Corporate Action Events, Geography, Legal Entity, Counterparty Risk, Party Master and Organization Hierarchy for the MDM transition team.

Data Governance Engineer/ Data Steward for the merger between Royal Bank of Scotland and Citizens Bank US. Daily meetings with M&A, SCRUM, Data Governance, Project. Management Office and DevOps supporting BAU. Creation of requirements, test plans, test cases and test scripts, traceability matrices, data models, transition state diagrams within the ALM space for the surviving entity structure (RBS Bank US).

• Championed a culture of continuous improvement by identifying areas where improvements could be made in current processes or technology solutions used within the company’s Data Stewardship function.
• Implemented data validation rules, significantly reducing the rate of errors in the database.
• Developed and maintained product data dictionary to document data source, ownership and accountability details.
• Monitored and managed data cleansing requirements and data conversion initiatives.
• Creation of Reference Table / Data Hierarchies, Data Source taxonomies and lineage/history for consumption in IBM Infosphere, Data Stage.
• Creation of the raw data profile and cleanse processes supporting data ingestion of structured and unstructured data.
• In a Teradata environment with IBM Infosphere MDM using Data Stage and Data Steward Center (Quality Stage) for reviewing and updating data type and definition exceptions across schemas and tables. Real time operational support for de-bugging on the fly updates and ad-hoc scenario building. Hand on Data Authoring, Rules Management, and modelling of updates. Creation of User Roles, Right & Entitlements, Input/Maker/Checker/Approver workflows. Worked on Multiple releases within the ERP framework of Customer 360, PIM Product Master, and Location modules.

Prior Contracting Engagements as Sr. Business Analyst and Conversion Specialist

• Key Bank (Cleveland, OH) Aug. 2012 – Sep. 2013

Sr. Business Analyst/Conversion Specialist

Wealth Management AML Mantas/ SunGard Interface

• M&T Bank (Buffalo, NY) Feb. 2010 – Jul. 2012

Sr. Business Analyst/ Testing Coordinator

Wealth Management Fraud Compliance Activities

• SAC Capital Hedge Fund (New York, NY/Stamford, CT) Oct. 2007- Dec. 2009

Sr. Business Analyst - Asset Data & Pricing Initiative

Strategic Reference Data Team

• Bessemer Trust Co - (New York, NY/ Woodbridge, NJ Dec. 2006 – Oct. 2007

Conversion Technology Team / Wealth Management

Sr. Business Analyst/UAT Lead - Hedge Fund Products - Global Market Data

• Fannie Mae, (Washington, DC) Oct. 2004– Dec. 2006

Sr. Business Analyst/ Cash & Securities Management

• SEI Investments (Oaks, PA) Oct. 2001 – Aug. 2005

Sr. Business Analyst- MDM Team Lead

Daily management of all transaction processing for Merger and Acquisition activities (Tender Offers, LBO, Merger of Equal Assets, International and Domestic Settlements, Corporate Action, Income Collection, Tax Reclamation.

• Managed IT infrastructure, ensuring reliable network connections and minimal downtime for users.
• Developed detailed documentation outlining system requirements, design specifications, and testing protocols for use in future projects or troubleshooting efforts.
• Implemented data security measures, protecting sensitive information from unauthorized access and potential breaches.
• Collaborated with cross-functional teams to develop innovative technology strategies aligned with business goals.

• Oversaw daily operations of the department, ensuring smooth workflow and timely completion of tasks.
• Applied strong leadership talents and problem-solving skills to maintain team efficiency and organize workflows.