Skip to main content

Carl Dalton Resume 2008 - Technical Version

Andrew Dalton

Project Server Specialist

& Programme Management Consultant

tel +44 (0)7734 274866



Personal Statement

Carl is an experienced
Microsoft Business Solution Architect with over seven years

experience in
working with the Microsoft Project Server and SharePoint

platforms, with a proven track record in design
and delivery of Microsoft solutions and processes that bring
measurable benefits to his clients.

He previously headed up
the EPM Solution Development Practice for a global Consultancy Firm focusing on Microsoft SharePoint and Project
Server technologies
, and has recently lead the IT Programme
Office Management function within a major retail bank, focusing on
Portfolio Management and Governance of all Group internal investments

Carl excels at
translating business process into technical solutions. He understands
key issues, defines strategies for resolving them and communicates
these to stakeholders in an open and effective way”

This recommendation taken
from my profile on

Career History

Microsoft UK (CSS)
    Dec 08 - now (CONTRACT)

Server 2007/2003 Technical Lead, tasked specifically with helping to
define and deliver operational improvements into the support group,
with the direct aim of achieving end of financial year targets for
customer satisfaction.  Providing technical mentoring to the
support team, and governing process compliance.

Microsoft UK (CSS)
    Feb 08 - Dec 08 (CONTRACT 3+2+6 months)

Providing Technical and
Best Practice Advisory support to EMEA-wide customers on Project
Server 2003 and 2007 (including Microsoft Office SharePoint Server
2007 and SQL 2000/2005)

07 – Feb 08

Lead Programme Office

  • Responsibility for
    overall governance of £15m IT Budget

  • In-house consultancy
    provided on SharePoint 2007 design and governance

Pcubed Ltd
03 – May 07


  • Project Server 2003 and 2007
    and SharePoint 2003 and 2007 Business Solutions Architect

  • SharePoint Solution
    Development Practice Manager

  • PMO Consultant/

  • Project and Programme
    Manager / Mentor

Example client

Accenture (NHS Programme)

Red Bee Media (formerly BBC Broadcast)

Fujitsu Services (NHS Programme and Corporate)


Central Government (multiple)

Cadbury Schweppes

British Sky Broadcasting (IT)

Arqiva (Telecoms & Engineering)

Projects Summary:-

  • Product
    and Programme Management of Solutions Development team, focusing on
    Microsoft technology-based extensions to the Microsoft
    Project Server solution offering.

  • Design
    and build of Microsoft Office Project Server 2007 prototypes
    client delivery, including design and build of WSS3/MOSS2007
    based SharePoint solutions

  • Lead
    architect for an integrated Programme Management solution (Project
    Server 2003)
    and processes to support the management and
    delivery of a multimillion pound UK wide IT programme (NHS
    Modernisation Programme)

  • Design
    and Implementation of a Proof of Concept (Project Server 2003 and
    Windows SharePoint Services 2003)
    solution within a leading IT
    Services organisation (NHS Modernisation Programme Southern Cluster)

  • Implementation
    of Project and Programme Management solution (Project Server 2003
    and Windows SharePoint Services 2003)
    within a large broadcast
    media organisation

  • Implementation
    of Pilot SharePoint Portal Server (SPS) collaboration and
    knowledge management environment for Arqiva (Telecoms)

  • Consultancy
    support on MOPI Programme Management solution (Project Server
    2007 and Windows SharePoint Services 2007)
    across multiple
    police forces

  • Delivery
    of full EMEA-wide EPM solution for Cadbury Schweppes (Project
    Server 2003 and Windows SharePoint Services 2003)

  • Lead
    Solution Design outline as part of EPM Project Feasibility Study.
    (Project Server 2003 and Windows SharePoint Services 2003)

  • Design
    and Implementation of a multi-programme EPM solution for the Home
    Office IT and IND (Project Server 2003 and Windows SharePoint
    Services 2003)

  • NHS
    modernisation programme exposure within both Accenture and Fujitsu
    IT Services (Project Server 2003 and Windows SharePoint Services

  • Design,
    implementation and delivery of Programme Governance / Assurance
    procedures at BSkyB (£100m Portfolio) (Project Server 2002)

  • Home
    Office IT / IND Programme Delivery Processes – defined
    approaches across project delivery within both IT and Corporate
    Services Modernisation programmes

  • Client
    Relationship Management experience at Programme Director to CIO

  • Motivator
    and manager of teams in extreme operational situations

Ltd                 Jun
03 – Jul 03

are a leading provider of Open OS platforms for Mobile Communications

  • Leading
    role in the design and implementation of both Master Planning and
    Resource Planning functions within a newly created department

  • Solution
    design consultancy to the project team responsible for the
    implementation of their EPM solution based on Project Server 2002

Ltd. Programme Office Consultant Jul 01 – Jun 03

Ltd are the main Automated Clearing-House for the retail-banking
sector in the UK.

initially as a Project Support Analyst, Carl’s role developed
into having responsibility for all strategic and tactical
improvements within the NewBACS Programme Office. In addition, he is
a project team member, working on the implementation of MS Project
2002 across the enterprise.

  • Leading
    team of 9 PSO’s across the programme, ensuring delivery of key
    customer information and data quality – PRINCE 2 environment

  • Responsibility
    for delivering Programme Office tactical improvement plan, including
    Financial Audit, Reporting development, tool and process design.

  • Business
    and technical lead on Project Server/P10 and Sharepoint Server

  • Re-engineering
    Programme and Enterprise-wide reporting processes/templates
    including review of all Project & Programme Office procedures

  • Project
    planning troubleshooting and MS Project SME, including
    training and best practice guidance

  • Holding
    ongoing training of the project management community (technology &

NV, Amsterdam. Programme Co-ordinator (contract) Jan 01 – Jun

are a broadband telecomms service provider and carrier, based in the
Netherlands, Belgium and Germany. Carl was contracted with Versatel
to co-ordinate their Billing (Singl.eView), CRM (Clarify) and
Middleware (ActiveWorks) implementation throughout their European
offices. He was solely responsible for co-ordinating all planning and
financial activities on behalf of the Programme Manager across the

  • Review
    and update Programme Office procedures

  • Writing
    the budget proposals and tracking models for the programme

  • Planning
    and authoring internal communications

  • Administering
    the Change Control process

  • Administering
    the Risk and Issues processes.

  • Defining
    “ways of working” best practise processes for the
    project teams

& Young, London. Project Coordinator (contract) May 00 –
Jan 01

was contracted to work on a project to rollout Windows 2000, Office
2000 and Notes R5 across the UK, as part of a global desktop
strategy. His responsibilities included:

  • Management
    of the overall project budget

  • Designing
    and writing both technical and informative communications to all
    levels of the firm, including the production of the Communications

  • Design
    and administration of the Change/Version control process

  • Assist
    project managers in planning and scheduling

  • Transition
    Project coordination and issue management

  • Working
    with regional administrators to ensure the migration process ran
    smoothly and on plan

IT (Database Support Unit), Leeds. Team Leader Oct 97 – Apr 00


2003 Server, Windows 2000, Windows 95,NT4, Office 95, Office 97,
Office 2000, MS Access 2000 and SQL, MS Exchange ,Project 2000,
Project 2002 Professional, Project 2002 Web Access, Microsoft Office
Project Server 2003, Project 2002 Server Administration, Project 98,
Project Central, Visio 2000, Notes R5, Lotus CC:Mail, Lotus
Organiser, MS Outlook, MS SQL Server 2000, UMT 3.3, Microsoft Office
Project Portfolio Server 2007, MOSS, Microsoft Office Sharepoint
Services 2007, WSS3, Microsoft Office Project Server 2007, Sharepoint
Portal Server, SQL Server 2000, SQL Server 2005

and Training

  • UMT
    3.3 (Microsoft Project Portfolio Server) Install, Design and

    Practitioner - Foundation and Practitioner course (5 day

  • MS
    Office User Specialist

  • MS
    SQL Server, Technical Intro & Administration

  • Project
    Central, Advanced & Administration

  • MS
    Project 2002, Intermediate & Advanced

1 of 4


Popular posts from this blog

#projectserver2013 VIEW FAILURE: The view failed to load. Press OK to reload this view with the default settings. Press cancel to select another view.

** UPDATE ** includes notes relating to secondary bug where Timesheet is created without Administrative tasks.

Does this ring any bells?

This has been bugging me for months, but finally I have a repro for this:

Issue Summary:  When a task is deleted from a plan that is approved into a previous or current timesheet - even when there are no actuals on the task - you can no longer view the timesheet

The following repro has been proven:
- Setup system with Single Entry Mode, with enforced Status Approval before Timesheet Approval
- Create resource as own timesheet manager
- Create new project
- Create two tasks in the same week, starting monday with 5 days duration:  1) Task to assign actuals, 2) Task to delete post submission
- Assign Resource to tasks
- publish project
- as Timesheet User, go to the appropriate timesheet period for the tasks created
- Assign actual work to one task (task 1), leaving task 2 with no actual work
- Submit timesheet
- as Project Status Manager, approve the time on task 1 …

What to do when your application server goes bang

What happens when someone kills your Application Server?
So imagine the scenario:
Three Server Solution - SQL - SharePoint 2010 and Project Server 2010 Application Server (Central Admin Host) - Wfe/ReportServer
We wake one bleary Monday morning to find that some numpty has killed the application server and the users are baying for blood.
Well surprisingly SharePoint handles this disaster recovery scenario particularly well.  Well.  Better than I thought it would to be honest.
Rough steps:
- quick SQL backup to be safe - Rebuild your application server - reinstall pre-reqs - reinstall SP, PS, SPFSP1, SPS+PSSP1, Cumulative Update and other stuff you usually put on there. - Run your configuration wizard to reattach to the Farm, and select Host CA Site
The last step was what I was VERY wary of.  Would the server simply reattach to the Farm, even when there is no CA server available?  
Bingo your back.... almost.... you are going to get errors a-gogo in your event log as things just aren't quite back…

Reporting from Project Server 2016 - multiple sites and userviews

Just a quickie...
I've been interested in how MS have handled the "multiple PWA sites in a Content DB" thing since I read that this was their new approach.  Most of my reporting is via SSRS so i am reliant (still... in 2016) on DB queries rather than OData feeds (tsk) and this "querying a PWA DB with more than one PWA site in it is unsupported" quote was worrying me.

So it looks like what is happening is this.

When you create the first PWA site in a Content DB it hard-codes the SiteID into the _Userview view design elements.  This means that your first PWA Site is the default.  All the data for subsequent sites are still held in the tables against separate SiteID's but you cannot utilise the OOTB _Userview components (see below)

SELECT        ProjectFields....
FROM            pjrep.MSP_TVF_EpmProject('FF19B767-CA6D-4C4C-B123-C0B5AE5354D6') AS MSP_EpmProject