Cameron J. Fletcher, MCP
+44 (0) 7835 168929 PROFILE
I am a Microsoft Certified Professional with proven skills in software development, analysis, and design. Having
successfully played a variety of roles in diverse environments, I am equally at home contributing to a team as I am
leading one. I have a solid understanding of software architecture and design, and a passion for elegance and quality.
With strong analytical and technical skills, I have developed solutions across a wide range of business areas, including
retail banking, mortgage services, asset management, investments, telecommunications, and customer relationship
management. I have offshore financial experience through working in Jersey (Channel Islands). I relish the challenge of
identifying and solving problems at all levels; from analysing business processes to building intuitive user interfaces.
My strong interpersonal skills ensure that I am able to develop productive relationships with clients and colleagues at all
levels. I am as at ease mentoring junior members of the team as I am presenting to senior management.
I am keen to find a varied and challenging position where I can put my skills and years of experience to good use.
? Successfully architected and led the development of a system for bringing in-house council based outsourced
taxi trips resulting in a potential saving to the company of in excess of ?250k pa.
? Responsible for the development of, and helped patent, a powerful and extensible peer-to-peer database
system which was responsible for winning a ?50k grant from the Scottish Executive for innovation.
? I am one of only 213 people worldwide to have achieved Microsoft Certified IT Professional (MCITP)
certification as a Database Developer (for SQL Server 2008). Figures correct as at April 9, 2009.
? Microsoft Certified IT Professional (MCITP) - Database Developer (SQL Server 2008)
? Microsoft Certified Professional Developer (MCPD) - Enterprise Application Developer (.NET 3.5)
? Microsoft Certified Professional Developer (MCPD) - Enterprise Application Developer (.NET 2.0)
? 4 A Levels: Maths, Further Maths, Electronics, and Physics
C#.NET, VB.NET, ASP.NET MVC 1.0, LINQ Visual Studio 2005 / 2008 / [Team Suite]
Visual Basic 6.0, VBA, Classic ASP SQL Server 2000 / 2005 / 2008
T-SQL, PL/SQL, ADO.NET Entity Framework SQL Server Reporting Services (SSRS), RDL, RDLC
.NET Framework versions 1.x, 2.0, 3.0, 3.5 Team Foundation Server (TFS) 2005 / 2008
.NET Compact Framework (.NET CF) Internet Information Services (IIS 6.0 / IIS7)
Web Services, SOA, SOAP SourceSafe 6.0 / 2005, CVS, SourceGear, SVN
XML, XSD, XPath, XSLT, XML Spy Oracle 9i, 10g
NUnit, NMock, TSQLUnit, MSTest Crystal Reports
Build.NET, MSBuild, nAnt, CruiseControl.NET Business Objects
Windows Forms (WinForms) Microsoft Office, Microsoft Access
Microsoft Application Blocks Agile Methodology (Scrum / XP)
Microsoft Enterprise Library Test Driven Development (TDD)
Windows Communication Foundation (WCF) Active Directory / ADAM / AD LDS
ASP.NET MVC Framework Google Analytics
Please refer to the accompanying Technical Expertise Datasheet for detailed breakdown of my skills.
An up-to-date version can be found at: http://www.cameronfletcher.com/documents/skills_datasheet.pdf ADDITIONAL INFORMATION
Written and verbal references are available on request.
I have my own limited company and am VAT registered.
Cameron J. Fletcher, MCP [Continued]
Cordia LLP, Glasgow June 2009 –
Team Lead Developer (contract) Sept 2009
C#.NET 3.5, ASP.NET MVC 1.0 Framework, SQL Server 2008, WCF, LINQ, AJAX, IIS7, MSBuild, Agile, TDD, Cruise Control, JQuery
I was leading a team of 6 on a Greenfield project to develop a council based transport and scheduling
system to replace existing outsourced taxi trips. My role involved architecting the system, mentoring other members of the team, and liaising with project stakeholders. The project was run using Agile Scrum. Transport and Scheduling Services
I designed the system to be based on the ASP.NET MVC Framework and Linq2Sql. I set up and automated the build environment for continuous integration and a daily build (for test) using a combination of MSTest, MSBuild, CruiseControl.NET, PartCover, and FxCop. I also implemented a QA process and enforced coding standards and analysis using Microsoft StyleCop and Microsoft FxCop. I was responsible for introducing test-driven development and continuous integration to the organisation. The project was delivered on time and considered the most streamlined and successful to date for the team that are now award winning, recognised internationally by the likes of Blackberry and xxx. Kelvin Solutions Limited, Glasgow June 2008 –
Senior Developer (contract) June 2009
C#.NET 3.5, SQL Server 2008, Oracle 9i / 10g, WCF, .NET CF, LINQ, MVC, XML, Web Services , XSD, XPath, XSLT, XML Spy, VBA, SOA, Active Directory, Google Analytics, IIS7, TFS, MSBuild, Agile, TDD I was responsible for helping design and develop a solution that allowed access and manipulation of data from multiple sources concurrently, operating across a WCF service layer. Multiple projects using language pre-processor directives enabled us to reuse the same code for a .NET CF (mobile) version. Connected Data Framework
I worked on several branches of the project, one of which was a custom code-generation application that would allow the creation of all the database and business layer code from .NET objects and pre-written templates. I developed the custom template language and a grammar and parsing library for use as a Visual Studio language service add-in which involved working with the Visual Studio Experimental Hive. I also worked on the core libraries for the main solution which, together with the code-generated business layer, allowed rapid development of connected data applications.
I was also tasked with setting up Team Foundation Server, which was used to track work items for each iteration, produce reports and act as version control for the source code.
Ignis Asset Management (formerly Resolution Asset Management), Glasgow Mar 2008 –
Developer (contract) June 2008
VB.NET 2.0, ASP.NET 2.0, SQL Server 2005, SSIS, SSRS, IIS 6.0, MSBuild
I was a member of a team developing a number of reports that would be run monthly for the two life
divisions of the company. The data was stored in ICON, a flat-file financial database, which presented
additional complications due to its size.
Monthly Reporting System
The reporting solution was a tiered application comprised of an ASP.NET front-end, a VB.NET business layer and a SQL Server back-end database. There was also a Windows Forms client, a Windows Service
to manage migration of the data from ICON, and a database deployment package using SSIS. I was responsible for writing the reports for admissible assets and unit linked growth funds. This involved updating the database project and associated MSBuild scripts, writing stored procedures, amending
standing data imports, and writing and deploying the reports. I was also required to optimise performance. Standard Life Bank, Edinburgh Nov 2007 –
Developer (contract) Mar 2008
C# 2.0, Windows Forms, SSRS, MVC, SVN, NUnit, NMock, nAnt, Agile, TDD
I was brought in as a member of an existing team to help port an existing call centre mortgage application rdto C# from a 3 party, proprietary technology (GTX).
Mortgage Application Processing System
The new solution was a tiered application comprised of a C# Windows Forms client (utilising the model-view-controller pattern), a Java business layer (implemented as a SOA framework) and a DB2 database. The project followed an agile (scrum/XP) methodology. My main task was to port the Key Facts Illustration section of the application using SQL Server Reporting Services. My responsibilities include determining
detailed requirements, developing and unit testing the application. Unit tests were developed and automated using NUnit, NMock and Rhino Mocks.
Cameron J. Fletcher, MCP [Continued]
Kingston Communications (Hull) plc (formerly Affiniti), Stirling July 2006 –
Technical Lead (contract) Nov 2007
C# 2.0/3.0, WCF, SOA, XML, Web Services, SQL Server 2005, SSRS, VBA, SourceSafe 2005, ADAM It was my responsibility to handle the data required for roll-out of 13,500 VoIP telephones across Fife
council. I was tasked with developing a system that would allow administrators for both the project delivery team and the end-client to access and amend the data whilst ensuring that the system was functional, secure, scalable and resilient. From the information entered into the system I was able to identify the
equipment needed on each of the 400 sites and produce a workpackage for the engineers to deliver. My role also involved frequently liaising with technical representatives, the end-client and project stakeholders. IPT Project Delivery Database
The solution comprised a C#.NET WinForms front end client that communicated with a back-end SQL Server database via a WCF service layer. SSRS over SSL was used for the reporting. Some of the reports that required interaction were developed to open in Excel and used VBA. I was also called upon to manage further integration of the system to communicate with Cisco systems using their AXL web service. Note: I have since set up my own Cisco VoIP system: http://www.cameronfletcher.com/page/voip.aspx Fundworks (UK) Limited, Glasgow Mar 2006 –
Lead Developer July 2006
C#.NET 2.0, Windows Forms, ASP.NET 2.0, Enterprise Library, Application Blocks, SQL Server 2005, T-SQL
I was responsible for leading the development team and acted as tutor and mentor to the junior members.
I was involved in designing and documenting the online investment portfolio management system. Investment Portfolio Management System
The solution comprised a tiered ASP.Net 2.0 front end with C# business and data components. The data was stored in an SQL Server 2005 database, accessed via both TSQL and CLR stored procedures. In
addition, a Windows Forms user interface allowed client management for the business administrators. The web based reporting solution comprising prices, performance, charting and illustration modules has been
implemented in a number of asset management companies and achieved Microsoft Certified Partner
status for the business. The solution is currently used by several major asset management companies. Contextus Limited, Falkirk Dec 2004 –
Senior Developer (contract) Mar 2006
VB.Net 1.1, Windows Forms, SQL, Remoting, CVS
Contextus Limited is a research company involved in the development of decentralised database
technologies. I started with the company soon after its inception as one of its senior developers. I was responsible for leading the development team, designing and documenting the solution and liaising with the patent lawyers involved with the designs. I experienced a high degree of interaction with technical peers at the forefronts of their respective fields through various activities organised by the Scottish government and centred on innovation and excellence.
Virtual Private Database Network
The solution comprised a VB.Net 1.1 front end with a peer-to-peer back-end bundled with each client. It required significant analysis of the SQL language and innovative solutions designed to combat such
problems as designing and developing a distributed query engine to retrieve partial records from different nodes. There was heavy emphasis on multithreading and windows sockets programming. During the design of the system I identified established patterns and developed object, component and data models. The project was submitted to the Scottish Government for a SMART award and won a ?50k prize. Sainsbury’s Bank, Edinburgh Nov 2003 –
Developer (contract) Dec 2004
Visual Basic 6.0, VBA, Microsoft Access, Microsoft Office, SQL
Purchase Order System
I developed the bank’s purchase order system using Microsoft Access from an existing specification
document. I completed the project on time and it was considered a resounding success. I was subsequently asked to remain working for the bank on an open-ended contract and was involved in
developing several other systems including budget tracking models, salary bonus calculators, and market
analysis tools using both Microsoft Access and Visual Basic 6.0.
Royal Bank of Canada (formerly Abacus Financial Services Limited), Jersey (Channel Islands) Oct 2000 –
Business Analyst Nov 2003
Visual Basic 6.0, VBA, Microsoft Access, Crystal Reports, Business Objects, Oracle, SQL, PL/SQL
Corporate Services System Development
I was responsible for the design of the corporate services company wide in-house system, and also provided support to the development teams on technical matters. I acted as a gateway into the wider
technical community within Abacus, often coordinating activities across teams.