Sean Delaney

Phone: 703-***-****

Email: ad1dgz@r.postjobfree.com

EXPERIENCE:

Capital One Bank 1/2017 to 7/2023

Business Analyst

●Prepared documentation required per internal Risk, Compliance and / or S/OX Audit controls for 200+ applications. The following is a list of Enterprise departments that were covered by our team for these purposes, followed by a summary of the main functions these departments performed and the applications / systems used:

Capital Markets Treasury - Bond and Derivative trading systems i.e. Murex, Summit, Bloomberg AIM, FXAll, Quantum, DTCC.

Controllers - Individual and Enterprise expense tracking and reconciliation using PeopleSoft.

Accounting - General Ledger reconciliation using Frontier ReconPlus.

Balance Sheet Management (1st and 2nd line) and Quantitative / Model Risk Analysis - Quantitative Risk Metrics (QRM), PolyPaths and other proprietary Analysis processes using Python, R and SQL code.

●Created application / database SQL queries to support Audit Reviews in efforts to semi- or fully automate those processes.

●Created and / or maintained documentation related to the preparation of internal and external Audit Review procedures, Risk reporting and standardized team processes / procedures related to those activities.

●Managed communications and support needs with application and engineering teams and stakeholders related to Business-As-Usual access issues or data / access requests for Finance Technology applications.

●Led team Kanban / scrum meetings to review project / task assignments and their related statuses and / or impediments.

●Led or participated in knowledge transfer for both new and existing team members. Presented knowledge topics to internal and external teams.

●Led meetings and reporting efforts for Incident and Change Management of applications supported by Finance Technology Development and Engineering teams.

●Systems / tools: MS Office Suite, Google Suite, AWS, Bloomberg, Tableau, Confluence, SailPoint, DOORs, C++, Java, HTML, XML, Business Objects, JIRA, Github, Artifactory.

Fannie Mae Corporation 8/2014 to 1/2017

Business Analyst

●Created and updated system / technical requirements and functional specification documents adhering to internal and external (IEEE) standards for Single Family Data Warehouse Operations system and database enhancements / improvements.

●Prepared database queries and procedure documentation (internal and S/OX-compliant) for reconciling Production data for the Enterprise Data Infrastructure (EDI).

●Prepared detailed analytics and reports on an ad hoc basis per management, internal / external audit, and project stakeholder requests.

●Participated in Agile Scrum session meetings and prepared meeting notes and follow-up task lists for the Business and System Analyst teams. Participated at various times as: Developer, system and user acceptance tester, analyst, team lead.

●Interacted with development teams in order to inform them of initiative-based business decisions and business requirements as they pertained to system requirements.

●Created development code for the purpose of complimenting the overall development effort.

●Created onboarding documentation (internally and adapted for use by Hexaware Technologies, the primary vendor for the project, for future project onboarding) and assisted with the onboarding process for new team members (laptop provisioning, software requests, introductory informational / Knowledge Transfer sessions).

●Systems / tools: MS Office Suite, Tableau, DOORs, ClearCase, Unix, SQL, Visual Basic, C++, Java, HTML, XML, Business Objects, Liferay, Informatica.

Freddie Mac 12/2013 to 7/2014

Business Analyst

●Created and updated written business / technical requirements and functional specification documents adhering to internal and external (IEEE and S/OX) standards for Multifamily system enhancements / improvements.

●Reviewed and enhanced business rules and process flows for Pricing, Costing, Securitization and Hedging processes.

●Interacted with System Analysis and Development teams in order to inform them of business decisions and initiatives.

●Prepared detailed analytics and reports on an ad hoc basis per management or stakeholder requests.

●Led and participated in Agile Scrum session meetings and prepared meeting notes and follow-up task lists for the Business and System Analyst teams.

●Systems / tools: MS Office Suite, DOORs, ClearCase, SQL, Visual Basic, C++, Java, HTML, XML.

Financial Industry Regulatory Authority (FINRA) 12/2012 to 10/2013

Business Analyst

●Performed daily review and maintenance of data (Oracle, Netezza, GreenPlum, Hadoop platforms using SQL) for Production internal surveillance applications used by legal, regulatory bodies (i.e. the Securities and Exchange Commission (SEC)), and investigative teams within FINRA.

●Participated in data mining / research / analysis exercises to identify potential data quality and system enhancements.

●Lead planning, analysis, requirements gathering and testing efforts for system enhancements based on FINRA and SEC rule filings, process improvements, using both SDLC and Agile Scrum methodologies.

●Created and updated written business / technical requirements, functional specification documents and business and process flows using standard BPMN approaches and IEEE documentation standards for system enhancements / improvements.

●Coordinated and assisted with application and ETL code review and testing related to system enhancements.

●Systems / tools: Bloomberg, Visual Basic, ProC, Java, HTML, SQL, Ab Initio, MS Office Suite, XML.

Fannie Mae Corporation 8/2007 to 12/2012

Business Analyst

●Performed data loading, reconciliation and analysis tasks for the Multifamily Relational and Accounting Data Warehouses in compliance with FHFA, S/OX and internal control standards.

●Identified and assisted with the resolution of bugs or ETL errors related to Production data loading jobs.

●Participated in data mining, research, profiling and analysis exercises to identify potential data quality and system issues or enhancements.

●Created data integrity checkpoints and reporting related to data load processes using Informatica, Business Objects, Brio and SAS.

●Consulted on data modeling, standardization and categorization efforts, both Enterprise-wide and local to the Single Family and Multifamily loan data warehouse areas.

●Business and System Analysis (scope definition, requirements gathering and analysis, testing, documentation) on projects related to Multi- and Single Family data warehouse systems or data enhancements. Change Management systems used: Rational (Clearquest, ReqPro), Quality Center. Project management methodologies / standards used: IEEE, SDLC, Agile Scrum, and internal Enterprise-level standards.

●Responded to internal and external audit and data consumer requests. Data query and reporting methods or applications used: MS Office Suite, Bloomberg, SQL, SAS, Ab Initio, Business Objects, XML.

●Reviewed application and ETL (Ab Initio) code used by Production processes to address identified or potential data or process issues, and to look for possible system enhancements.

●Created and reviewed Business Process workflows, procedures and training-related documents for use with existing system requirement documentation.

●Participated in training of new employees.

●Member of: 1. Enterprise Data Warehouse Operations Training Team, 2. Enterprise Data Warehouse Operations Volunteer Effort Coordination Team.

Freddie Mac Corporation 5/2007 to 8/2007

Business Analyst

Fannie Mae Corporation (contingent worker) 10/2006 to 4/2007

Business Analyst

Citigroup Inc. 7/2004 - 8/2006

Operations Specialist

●Researched and reconciled contractual cash flow discrepancies for Derivative trading activity.

●Processed cash transfers used to resolve identified cash flow discrepancies.

●Prepared DTCC settlement details for monthly and quarterly Derivative trading cash flow activities.

●Reviewed and revised (if needed to resolve an outstanding contractual issue with a Counterparty) Interest Rate and Credit Default Swap documentation adhering to SEC standards.

Deutsche Bank AG 12/2003 – 7/2004

Operations Specialist

●Performed and reported daily valuations for Bonds and Interest Rate Derivatives using Excel, Bloomberg, Reuters, Murex and Summit systems.

●Responded to audit requests related to individual Bond or Derivative prices previously reported.

Washington Mutual Bank 3/2003 – 12/2003

Mortgage Loan Processor

Credit Suisse First Boston

(Donaldson, Lufkin and Jenrette (DLJ) from 2/1999 through 9/2000) 2/1999 – 2/2003

Operations Specialist

●Entered Option, Collars, Interest Rate and Credit Default Swap details into either proprietary systems (Excel, Java or VB script-based), General Ledger systems (i.e. Pershing PAR) or external applications (Summit / Murex).

●Reconciled Interest Rate and Foreign Exchange Swap activity between the New York and London offices.

●Reconciled and reported daily derivative trading activity to external Hedge Fund customers.

CERTIFICATIONS:

Virginia - Real Estate Sales Agent - VREB License #: 022******* 8/2018 - Present

EDUCATION:

1997-1999 Queens College (CUNY) – Aaron Copland School of Music

Master of Music: Performance

1992-1996 Queens College (CUNY) – Aaron Copland School of Music

Bachelor of Music: Performance

Minor: Business and Liberal Arts program

Contact this candidate