Bill MacSwiney's Email Addresses & Phone Numbers

📖 Summary

Data Analyst @ Signature Consultants at Bank of America Regulatory Data Governance From October 2016 to February 2018 (1 year 5 months) San Francisco Bay AreaProgrammer / Actuarial Technician @ Phoenix Mutual Life Insurance Company – Hartford, CT. Developed life insurance proposal systems. From July 1981 to April 1986 (4 years 10 months) Hartford, CTBusiness Systems Analyst @ Equinix Supporting the implementation of Siebel UCM customer master application. Including analysis of source data, validation of data migration and testing. From November 2013 to October 2016 (3 years) Redwood City, CASr Data Consultant @ Unify Consulting San Francisco Bay AreaData Quality Consultant @ Signature Consultants at Wells Fargo From May 2018 to April 2020 (2 years) San FranciscoBusiness Analyst / Data Architect. @ Bank of America Merrill Lynch – Global Markets Operations Technology 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.Supported Fixed income inclusion in master Data Linage tracking application. Products supported: Fixed Income, Mortgage backed , TBAs, Short term paper, Repo and financing. From January 2009 to March 2013 (4 years 3 months) San Francisco, CABusiness Analyst / Data Architect @ Bank of America - Capital Markets shared data environment. 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. Basel II categories supported included Repo-Syle, 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.Products Supported: Equity, Listed Options, Fixed Income, Financing transactions, Stock Loan and derivatives. From January 2005 to December 2008 (4 years) San Francisco Bay AreaData Warehouse Manager @ Banc of America Securities 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.Collected and displayed rudimentary, business function aligned meta data for the shared environment.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.Products Supported: Equity, Listed Options, Fixed Income, Financing transactions. From June 1998 to December 2004 (6 years 7 months) San Francisco, CAProject Manager @ Bank of America – Global Corporate Investment Banking Managed various system integration and MIS projects for back office operations.Managed integration of back office systems with automated clearing and settlement providers such as BONY and Federal Reserve bank of San Francisco.Multiple back office conversion projects related to merger and acquisition activity: Security Pacific, Continental Bank, Nations Bank.Developed reporting data mart from fixed income system of record to facilitate rapid reporting and MIS development. From June 1988 to June 1998 (10 years 1 month) San Francisco Bay AreaProgrammer @ Midland Montague Securities Inc – San Francisco, CA Developed applications using data from back office system of record.Designed and programmed daily P&L reporting Trading management and Finance. From August 1986 to June 1989 (2 years 11 months)