Karl - Développeur .NET

• BizTalk Trainer and System handover
Staff training on both BizTalk, C# and also integration business specifics
Currently mentoring team of 3 senior developers
Generally be hand for other technical issues

• Online Parking Renewal Payments
BizTalk Integration to enable Lambeth residents to renew and pay for their parking permits online.
Design technical architecture & communications schemas
Define requirements specification for external vendor’s web service (Web Service WSDL)
Clarify business problems with Project Manager & Business Users
Design & implement credit card pre validation rules engine (C#)
Implement SSL for secure messaging for credit card data
Mentor senior developers

• Customer Master Single View
BizTalk Integration of multiple systems each with varying levels of data accuracy (including duplication). Brief was to provide a single master view of a customer by selecting the most trusted source system data values and ensuring that this master view is synced with the main CRM system Onyx OneServe.
BizTalk integration with Onyx OneServe and 3rd Party matching merging tool (VisionWare MultiVue Identification Server)
o MSMQ, MultiVue Biztalk Adapter, OneServe SOAP, File Transports
o Dynamic Mapping
o Complex Rules Engine for picking most trusted element data from various source systems developed in C# referencing a Singleton object instantiated from a configurable rules XML file.
Data synchronisation Windows Service calling into BizTalk Orchestration exposed as Web Service
Management of deployment, environments, testing and bug fixing
o NAnt, XML Preprocess, ElementTunnel , Wix Build, localised environment deployment settings file in Microsoft Excel
Extended Log4Net logging
Documentation
Support in Live environment

• Call Centre Capturing Tool
Application used in the Lambeth Call Centre to capture various levels of call detail, ranging from call duration, call reason, Service tree used, actions taken etc. These details are captured onto a database, which was subsequently sliced & diced to generate various reports for call centre management.
C# Windows Application
Customisable XML configuration of Users & Service Tree Hierarchy levels

• Housing Benefits to CRM Integration
BizTalk Integration of a customer website and linking these details between Housing Benefits and CRM
Data synchronisation Windows Service calling into BizTalk Orchestration exposed as Web Service
Temporary BizTalk Services architected in mind for easy replacement when next integration is live (Single View Customer Data Project)
Introduction & management of BizTalk deployment, environments, testing and bug fixing
NAnt, XML Preprocess, ElementTunnel , Wix Build, localised environment deployment settings file in Microsoft Excel
Extended Log4Net logging

• Property (Buildings) Adapter
.Net wrapper to the GAZOPS (Gazetteer Connector) web service to search for Properties within the Lambeth Borough. This was created to wrap all the complexity of the web service and its huge array of parameters away from the caller, who is only required to submit the minimum number of search parameters. This component is subsequently used in certain E-Forms on the Lambeth Web Site.

• Extension of Log4Net
Additional methods and properties added to the Log4Net Serializable component to enable easier diagnostic tracing and message auditing. Change to method signatures to enable custom properties to be persisted outside of the logger instance and in BizTalk Orchestration itself.

• Evaluation of ‘Screen Scaping’ technology
Where direct BizTalk integration with a system was not possible, whether too old, or no longer supported. A selection of vendors were chosen to demonstrate and provide a no obligation proof of concept.
Liaising with Vendors, supplying requirements
Product Evaluation
Proof of Concept implementation with Vendor Consultants
Demonstrations to internal business users using real case scenarios
Closure report with recommendations and pricing for upper management

• Development Standards Authoring and Source Code management
Development Standards and best practice for BizTalk Development
Determining hierarchical structures (and namespaces) within source safe for future development work
Putting SourceSafe in place


(May 00 – June 05) Biztalk 2004/C# .Net Senior Developer – Pearson (Media)

• Biztalk Integration from internal systems and trading partners.
Team lead (of 3 including external contractor), Architect and Technical Author
Actively involved in Business Analysis and specification review/iterations
R&D work to provide viable Biztalk solutions
Building & deployment to dev/UAT/Live servers
Biztalk 2004 Server
o Complex Orchestrations, including Sequential Convoy, delayed response.
o Data formats : XML, positional flat file, PDF
o Data transports : Email (with custom receive), FTP, SQL, UNC folder pickup/drop
o Custom pipelines (message logging, disassembling of flat file and XML, MIME encoding)
o Integration with existing C# assemblies of new production system
o XSLT map files to perform complex transforms in standard map
o Log4Net instrumentation
o NAnt deployment
o NUnit testing

• Development of a Greenfield project for Penguin and Dorling Kindersley production departments.
Oversees the entire process of Book Printing from scheduling initial concepts for the book to final delivery to the customer. It includes Book Specification and Costing, Print Scheduling, Purchase Order Production, Dispatch and Delivery, Invoice Payment Authorisation, Rights Management and Author Royalties.
Involvement with initial design, recommendations and prototypes
Winforms and web clients
Core written in C#, SQL server 2000
n-tier architecture
o Façade – Remoteable instance exposing the static BRL methods
o Shared Classes – Classes representing Business Objects shared on both client/server/interface applications
o BRLObjectManager – Static object factories used for getting and saving data to database as well as applying business logic
o DAL – Maps business objects to database representation both to and from the DB Server. All actions performed through executing stored procedures. (MicrosoftApplicationBlocksData is used quite extensively in this layer)
o Thread static data cache – ensures operations are performed on same instance of object and improves performance by reducing round trips to the database
Gang Of Four design patterns
o Singleton, Observer, Façade, Visitor
Extreme programming methodology
o Paired Programming
MSI installation with application auto update
3rd Party UI tools
o DevExpress Xtra Bars, Xtra treelist
Tests executed with NUnit 2.2

• Implementation of intranet to provide common centralised access and updating of bibliographic data
Due to the disparate nature of existing DK legacy systems, a lot of time was wasted re-entering the same data in between systems and often data was missing from some systems and data quality varied considerably. It was therefore required a centralised application where users could easily read and write real-time and correct product information.
ASP, Javascript, HTML client
n-tier VB6 architecture
SQL server 2000 database
MSMQ data interfaces

• Large scale data cleansing and legacy application readiness exercise
Preparation of reference data for above system involved a clean up exercise of existing legacy systems.
SQL DTS packages to import from various Access, Btreive and SQL Server databases
Custom user tool written in VB6 to allow correct title choice of legacy systems
TSQL used throughout to manipulate data, provide statistics, off the wall user queries

• Creation of intranet web site to allow querying of 4GL application
Allowed Penguin users to query product and production run details without having to install the main Production system onto their local machines
ASP, Javascript, HTML front end
VB6 engine
ORACLE 8 database

• Transporting an overloaded Access production system to use SQL Server
Many of DK’s legacy systems were written in variants of Microsoft Access, one of which experienced many data and corruption problems due likely to the number of users and increased load.

• Development take over of a contact address book system
A daily XML feed was generated from a SQL server database after which the client application would pull across the XML file and issue XSLT to query and display contact details on the screen.

(April 98 - May 00) VB6 Analyst Programmer/Production Support Analyst - AON Group (Insurance)

• Heading of prototype design, implementation, testing, deployment and support of new VB systems
• Investigation into new technologies and 3rd party controls
• Y2K compliancy work for existing legacy systems written in Clipper

Languages : VB6, 5 (Enterprise), MTS, Clipper 5, Summer 87
Deployment : VB Package and Deployment Wizard, Visual Studio Installer
Report Writers : VB6 Data Report, Business Objects 4.1
Source Control : Visual Source Safe 5, 6
Third Party Controls : Sheridan’s Active Suite, FaxMan
Databases : Oracle 8.05, TOAD 6.3, DBase
Database Interfaces : ADO2.1, VB6 Data Environment
Operating Systems : NT4, Novel, Windows 95, Windows 98, DOS
Courses : Mastering Enterprise development using Visual Basic 6 (MTS and SQL Server 6.5).

(1997 - April 98) Team Leader/Analyst Programmer - Eurostop Limited (Retail EPOS and head office)
• Technical Team Lead of a team of 3 (After 2 months joining at similar level to graduate peers)
• Actively involved with supporting existing business managers, capturing change requirements, new requirements through to work design, estimation, development, testing and delivery. Clients of which include, LK Bennett, Long Tall Sally, Sports Division, Ann Summers, Faith Shoes and Storm watches.
• Member of the ‘New Business’ team, demonstration of products to prospective clients