Design new Data warehouse using SQL Server 2005 Beta2, CTP & release versions. Maintain/improve current warehouse using SQL Server 2000.

Responsibilities:

• Create and maintain logical and physical data models using ER/Studio.
• Design coding standards, best practice guides and templates.
• Design and implement code release strategy.
• Design ETL layer using SQL Server Integration Services.
• Assist/mentor SQL developers with implementation of new SQL Server features including CLR integration and Reporting Services.
• Design/Develop data warehouse manual data maintenance application.

Achievements/Improvements made:

• New data warehouse is able to support new business model requirements including multi-company and multi-currency scenarios, better FSA integration, complex intermediary fees models and removing the need for lengthy month end process previously taking 4 working days.

Development of the global financial sub-ledger and the related feeds and tools.

Responsibilities:

• Create feeds from external sources using DTS.
• Create complex stored procedures to implement business rules, enrichments postings based on deal and position information, etc.
• Tune existing stored procedures, implement new indexing strategies, optimise views and user defined functions, etc.
• Optimise reports and feeds to accounting and regulatory systems.
• Provide mentoring and support for other members of the development and support teams.

Contract consisted of two assignments:
• Review disaster recovery procedures and implement required changes to backup jobs, review slow performing stored procedures, analyse indexes.
• Design and develop a solution for selective archiving of sets of data in a much normalised, highly transactional database. Techniques used included .NET transactions, delegates, threading, collections, extensive ADO.NET and complex stored procedures.

Varied role comprising database administration, web and windows development.

Responsibilities:
• Implementation and administration of SQL server databases, including installation, upgrades, backup strategy, security, normalisation, index tuning, capacity planning, data conversion and loading and other ad-hoc DBA roles.
• Liasing with different Finance departments to optimise systems integration, create data feeds, DTS packages, and reports and data replication solutions.
• Developing software for data manipulation, export/import, mapping, report generation, etc.
• Designing and developing software to extend the capabilities of the company’s accounting software including console applications, components and windows applications.

Achievements/Improvements made:
• Development of a suite of tools to automate system administration routines, interfaces between systems and file conversions. Successful implementation of these tools reduced administrative labour costs by more than 70% while it provided improved reliability and a consistent audit trail.