William MacSwiney-- Hastings Shore Lane, Redwood City, CA 94065
SUMMARY
Data Management professional with over 25 years of securities industry experience combines deep business insight with data management, data quality and meta-data skills to deliver data environments that integrate multiple sources into a business process aligned model to support applications, reporting, self-directed user access.
CORE COMPETENCIES
Data Warehouse design and management, Requirements acquisition and analysis, Data flow mapping, Data base design, Data modeling, Data Quality, Meta Data, Master Data management design, Customer Lifecycle Management, Multiple source integration into common model, Third party data enrichment and integration. Data Privacy and Governance.
TECHNICAL SKILLS
Microsoft SQL Server 2000/2005/2008, Oracle, Sybase SQL Server, AutoSys, MS Visio, MS Office, COBOL, ER/Studio, Ab Initio Express>It and Enterprise Meta Data Portal, Apache HIVE, Aqua Data Studio, Palantir Foundry, Jira, Pyspark, Snowflake
EMPLOYMENT
October 2022 – April 2023
Diligente Technologies at First Republic Bank - Data Governance Analyst
Improved data quality and visibility by integrating third party sources of client data into centralized client master data.
Analyzes data quality issues and define metrics for key client data attributes.
Used complex SQL to analyze key CRM data elements across multiple sources
Designed model enhancements to the internal MDM system to support greater precision supported by new sources.
September 2021 – June 2022
Data Governance Analyst with Unify
Analyzed and documented data integration between Salesforce and SAP. Investigated specific examples, researched data in source and target.
Articulated potential inconsistencies and weaknesses in the existing integration process.
Propose model and process improvements for future data integration projects.
Developed views to examine and compare application data across sources and expose those structures to data quality rules.
Enhanced Unify’s Data Governance practice with Data Privacy design.
April 2020 – September 2021
Unify Consultants at PG&E – Data and Analytics - Data Quality Analyst
Designed and developed a model to parametrize, capture and persist data quality findings in newly deployed Palantir Foundry environment.
Engineered SQL and Pyspark transforms to perform specific Data Quality rules and output results into the Data Quality model.
Analyzed source data to provide detail to rule specification and support supplemental data provided to Data Quality dashboards.
Designed and engineered dataflow SQL and Pyspark pipelines to bring Data Quality findings and supplemental data to Data Quality dashboards.
Implemented Collibra based Data Quality rules in Palantir Foundry environment,
Contributed as agile team member to refine end user requirements into story components, create and maintain Jira items and plan team activities.
April 2018 – April 2020
Signature Consultants at Wells Fargo – Data Management and Insights – Data Quality analyst
Designed and developed Ab Initio (the data quality tool) configurations and rules for ongoing monitoring reports.
Analyzed source data for relationships and data quality patterns subject to validation.
Updated enterprise Meta Data store for source and Data Quality models.
Designed Data Quality configurations for Apache HIVE DB.
Oct 2016 – Feb 2018
Signature Consultants at Bank of America – Treasury Capital - Data Quality and Governance analyst
Designed test cases for ongoing data quality monitoring reports.
Detailed analysis of data issues affecting the Risk Weighted Asset (RWA) application and credit risk reporting system.
Management of Key Business Element meta-data and mapping of sources into the application data store.
Detailed analysis and comparison of new sourcing application in support of adoption project for Derivative (CDS, Options, Swaps, Swaptions, Equity Swaps / Options, FX and Commodities) and Repo / Securities Lending products.
Nov 2013 – Oct 2016
Insight Global contract at Equinix – Global Information Technology – Business Systems Analyst
Supported implementation of Master Data Management application Siebel UCM.
Coordinated initial load of data from spoke systems into MDM central distribution database.
System Integration and User Acceptance testing of UCM integration with other Salesforce, Oracle EBS and Siebel CRM
Managed initial load of employee data into Siebel CRM for hierarchy and position assignment.
Optimized integration with Dun & Bradstreet to enrich customer data and assign account hierarchy.
Account hierarchy automation, cleansing and maintenance.
Jan 2009 – Mar 2013
Bank of America Merrill Lynch – Global Markets Operations Technology - Business Analyst / Data Architect.
Responsible for solution design for user and application integration with our shared data environment.
Designed and specified integration of BofA fixed income back office systems with Merrill Lynch, compliance, regulatory reporting and accounting systems.
Implemented data integration with the strategic source for securities reference data -PME.
Specified data feeds into Risk management systems for fixed income trades and positions.
Specified data feeds into Middle office P&L reporting system.
Designed and implemented unified Affiliate Position reporting combining positions from both BofA and Merrill legacy Systems of Record and strategic instrument reference data.
Specified customer and product identifier master data integration.
Supported fixed income inclusion in Data Linage tracking application.
Jan 2005 - Dec 2008
Bank of America - Capital Markets shared data environment - Business Analyst / Data Architect
Designed and specified an integrated data environment for support of Risk applications and initiatives.
Designed database and real time source feeds to incorporate inputs from multiple systems to track the life cycle of trades from execution to settlement.
Responsible for data architecture, data base design and interface specifications for data provisioned to Global Risk management in support of the Basel II initiative and CCAR projects. Basel II categories supported included Repo-Style, Fixed Income Forwards and Cash Securities Positions.
Developed detailed data mapping specifications using a standard template designed by our group. Integrated mapping specifications into preliminary Meta data store intended to support data lineage analysis.
Jun 1998 - Dec 2004
Banc of America Securities – San Francisco, CA - Data Warehouse Manager
Managed a team to design and implement an integrated data warehouse environment supporting the back office of the Bank's NYSE broker / dealer BAS.
Data support for major back office integration project to consolidate the system of record for BAS onto one platform.
Developed a common data model to hold transaction, position and reference data from multiple sources to support back office applications and user self-service MIS.
Created the conceptual account and party sub-model for the warehouse.
Formed MS SQL data marts to enhance usability of data for a broad user community that were consumers of output from the new back office system.
EDUCATION
Syracuse University – BS Mathematics
