Con Edison

Engineering document management and secure infrastructure

FIS's founding engagement

Challenge
Con Edison's Central Engineering group needed to manage the drawings, specifications and business documents behind New York City's electrical infrastructure, including substations and transmission lines, with strict control over who could see and change them. After 9/11, protecting this critical-infrastructure documentation became even more important.
What we did
David architected a SharePoint-based document management system, which the team implemented, to store, retrieve, modify, plot and print engineering documents. Access control, audit records, version control and lifecycle management were core requirements.
Technologies
  • SharePoint
  • Windows infrastructure

Jefferies

KYC/AML onboarding and acquired-firm data integration

~2012

Challenge
After an acquisition, Jefferies needed the acquired firm's data and client documentation brought onto its own standards for metadata, content and reconciliation, while meeting KYC/AML requirements.
What we did
We built ingestion and tagging of KYC/AML documentation into Jefferies' repository, linked to database records we designed, built, tested and ran. We also built a front-office application to review, reconcile and validate records that failed rule checks on ingestion. David led the program across client onboarding, compliance workflows, governance and executive reporting, and architected infrastructure enhancements that improved the KYC/AML and reconciliation processes in a secured, audited way.
Technologies
  • Data ingestion and tagging
  • Relational databases
  • Document repository
  • Front-office web application

Deutsche Bank

Data governance and regulatory reporting

~2013–2015 · Role: Program Manager, Data Governance & Reporting

Challenge
Meeting the data-aggregation and reporting expectations of BCBS 239 and the capital-planning requirements of CCAR across Finance, Risk and Technology.
What we did
Led enterprise data-governance, regulatory-reporting and technology-transformation programs that supported BCBS 239 and CCAR across those functions.
Focus areas
  • Data governance
  • Regulatory reporting
  • Program governance
  • Executive reporting

Millennium Partners

Bulk dividend processing for the front office

~2016 · Role: Technical Project Manager

Challenge
In an equity-derivatives environment, front-office staff had to process dividend adjustments one record at a time.
What we did
Delivered a tool that shows every dividend needing attention in one list, with in-place bulk edit and submit. We architected the underlying API as a reusable web endpoint that other applications could use too. The work spanned corporate actions, reconciliation, reporting and P&L-related workflows, with globally distributed teams.
Technologies
  • Web application
  • REST API
  • Reconciliation and reporting

Have a complex program or system to get right?

Tell us a little about the problem, the timeline and who's involved. We'll reply personally.

Email David