Projects & case studies
A few representative engagements. Each one involved systems that had to be secure, auditable and right the first time.
Con Edison
Engineering document management and secure infrastructure
- 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
- 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
- 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
- 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.