Lucida Plc (now Lucida Limited) operated as an insurance company that focuses on annuity and longevity risk businesses. The company offered solutions to risks, volatilities, and administrative burdens associated with corporate defined benefit pension schemes and bulk annuities markets. It served companies and trustees.

Our consultant was responsible for the technical redesign, development, implementation and support of the core data hub system which imports, holds and exports Asset and Pension scheme data in a SQL Server via BizTalk processes and exposed WCF services developed in C#. Interaction with Bloomberg via Web Service to enrich Asset data. SSRS used to expose data to users. Replaced previous processes with faster, scalable and more robust mechanism to guarantee quality and consistency of the loaded data. Upgraded from BizTalk 2006R2 to BizTalk 2009, and planned upgrade to BizTalk 2010. Produced suite of tests in Visual Studio to prove requirements still met on each change. Upgraded from VS 2005 to VS 2008 and finally to VS 2010. Upgraded from SourceSafe to TFS. Data in XML and Excel files is converted and bulk loaded into staging tables then processed into the relational tables. ETL rules design and support. Mentoring junior developers.

Operating System: Windows Server 2003 R2.

Backend database: SQL Server 2005,SQL Server 2005 Notification Services and SQL Server 2005 Reporting Services.

Development IDE: Visual Studio.Net 2005 backed by SourceSafe and Visual Studio.Net 2008 backed by Team foundation server

BizTalk versions: 2006 R2 and 2009