Category: Project Management

Project Leaders Driving Vision, Alignment and Results

Project Leaders Driving Vision, Alignment and Results
Project Leaders Driving Vision, Alignment and Results

Top FREE AI Courses for Project Managers

Top FREE AI Courses for Project Managers
Top FREE AI Courses for Project Managers

Data Engineering Summary

Data Engineering Summary
Data Engineering Summary
Data Engineering : Step by Step Summary
Data Engineering : Step by Step Summary

Extract, Transform, Load (ETL) is a foundational data integration process that consolidates raw data from multiple disparate sources—such as CRM systems, databases, and APIs—into a single, centralized destination, typically a data warehouse or data lake. It is crucial for ensuring that data is clean, consistent, and ready for analytics, BI reporting, and machine learning.

Core ETL Process Steps

  1. Extract: Raw data is pulled from varied sources (structured or unstructured) into an intermediate staging area.
  2. Transform: The staged data is cleaned, formatted, and combined based on business rules to ensure consistency.
  3. Load: The prepared data is moved from the staging area into the final target data warehouse.

Key Benefits

  • Data Quality & Consistency: Standardizes formats (e.g., date formats, currency) and cleans up errors.
  • Historical Context: Combines legacy data with new information for long-term analysis.
  • Automation: Automates recurring data processing tasks, saving time for data engineers.

ETL vs. ELT

  • ETL (Transform before Loading): Transforms data on a separate processing server before loading, ideal for complex, heavy transformations.
  • ELT (Load then Transform): Loads raw data directly into the target warehouse (e.g., Snowflake, BigQuery) and transforms it using the warehouse’s power. This is better for large, unstructured datasets.

Detailed Summary

1. Extract

Extraction is the first phase, where raw data is gathered from various heterogeneous sources.

  • Sources: SQL servers, NoSQL databases, SaaS applications (CRM/ERP), JSON/XML files, and IoT sensors.
  • Methods:
    • Full Extraction: The entire source is copied; best for small tables.
    • Incremental Extraction: Only data modified since the last run is extracted.
    • Update Notification: Source system alerts the ETL tool of a change.
  • Staging Area: Extracted data is temporarily stored in a “staging area” (or landing zone) to avoid placing heavy loads on production systems during transformation.

2. Transform

This is the most compute-intensive phase, where raw data is converted into a usable format.

  • Cleansing: Mapping NULL values to 0, removing duplicates, and fixing errors.
  • Standardization: Converting character sets, date/time formats, or measurement units (e.g., kilograms to pounds).
  • Data Aggregation: Summarizing data (e.g., total sales per store per day).
  • Enrichment/Derivation: Creating new calculated values (e.g., calculating profit from revenue and cost).
  • Encryption/Masking: Anonymizing PII (Personally Identifiable Information) to comply with GDPR/HIPAA regulations.

3. Load

The final phase transfers the cleaned and transformed data into the target destination.

  • Target Systems: Data warehouses (e.g., Amazon Redshift, Snowflake, Google BigQuery) or Data Lakes.
  • Loading Methods:
    • Full Load: Wiping and replacing all data in the target.
    • Incremental Load: Only loading new/updated data (the “delta”) to the target at regular intervals.
  • Automation: The process is typically automated to run during off-hours, ensuring the data is ready for morning reports.

Modern Trends and Tools

  • Cloud-Native ETL: Tools like AWS Glue, Azure Data Factory, and Google Cloud Dataflow allow for serverless, scalable data integration.
  • Reverse ETL: Moving transformed data from the warehouse back to operational systems (like Salesforce) to activate insights.
  • Streaming ETL: Processing data in real-time as it arrives, rather than waiting for batch updates, using tools like Apache Kafka.
  • DataOps: Applying DevOps principles (automation, testing) to data pipelines to ensure reliability and faster deployment.

When to Choose ETL vs. ELT

  • Choose ETL when: You need to comply with strict data security, perform complex transformations before data hits the warehouse, or have limited computing power in your target database.
  • Choose ELT when: You are using a cloud warehouse, dealing with massive unstructured data volume, or need high-speed ingestion.

Steps to Write a Project Plan

Steps to Write a Project Plan
Steps to Write a Project Plan

Campus Serge Kampf Les Fontaines, in Gouvieux-Chantilly near Paris

The Campus Serge Kampf Les Fontaines, located in Gouvieux-Chantilly near Paris, is a premier corporate seminar and training center owned by Capgemini. Originally a 19th-century Rothschild estate, it was transformed into a “Campus” for learning, innovation, and reflection, blending historic architecture with modern, sustainable meeting facilities.

Campus Serge Kampf Les Fontaines, in Gouvieux-Chantilly near Paris
Campus Serge Kampf Les Fontaines, in Gouvieux-Chantilly near Paris

Detailed History Timeline

18th Century: Romantic Origins

  • Late 18th Century: Jacques Berthault acquired a 28-hectare plot, developing a romantic-style garden around a lake, featuring small “follies” (decorative buildings).

19th Century: The Rothschild Era

  • 1878: Baron Nathan James Edouard de Rothschild purchased the estate, increasing it to 52 hectares.
  • 1879–1882: Construction of the Château des Fontaines took place, designed by architect Félix Langlais in an eclectic mix of styles (medieval, 17th-century, Louis XIV). It served as a summer residence and venue for lavish receptions.

20th Century: War and the Jesuits

  • 1931: Baroness Thérèse von Rothschild died, after which the property was passed to her son, Henri.
  • World War II (1939–1945): Occupied by the German army; utilized by the Luftwaffe as an observation base with a hidden bunker.
  • 1946: The Jesuits acquired the estate to create a cultural and spiritual center, including a vast private library.
  • 1970: The facility was formally established as the Centre Culturel des Fontaines.

Late 20th Century: Acquisition by Capgemini

  • 1997: Facing high maintenance costs, the Jesuits decided to sell the property.
  • 1998: Capgemini bought the estate to create a dedicated international training and seminar campus.
  • 1999–2002: Major redevelopment took place under architects Valode & Pistre to create the campus facilities.

21st Century: The Campus Serge Kampf Les Fontaines

  • January 2003: Campus Les Fontaines opened its doors.
  • 2003–Present: The campus hosts around 275 events annually, serving as a hub for Capgemini University, international meetings, and corporate training.
  • November 2017: Renamed to “Campus Serge Kampf Les Fontaines” to honor the recently deceased founder of Capgemini.
  • 2020: The lounges of the Château were fully refurbished.

Key Features and Role

  • Architecture: Combines the historic 19th-century Rothschild château with the “Forum,” a modern, circular 300-room campus building.
  • Sustainability: Focused on environmental responsibility with a strong commitment to reducing the carbon footprint of events for over 20 years.
  • Capacity: 50 meeting rooms, including a 500-seat auditorium.

About Serge Kampf

Serge Kampf (1934–2016) was a French entrepreneur who founded Sogeti in 1967, which became Capgemini. He was known for his dedication to client relationships and nurturing entrepreneurial talent.

Campus Serge Kampf Les Fontaines, in Gouvieux-Chantilly near Paris

Capgemini – Campus – Serge Kampf Les Fontaines, Chantilly, France – Advanced EM Course – November 2017 Class

November 2017 – Advanced Engagement Management Course – Level 2 Exam

Charts Every Project Manager Should Master

Charts Every Project Manager Should Master
Charts Every Project Manager Should Master

SAFe Scaled Agile Framework

SAFe Scaled Agile Framework
SAFe Scaled Agile Framework

Degree 53 was a Manchester-based digital agency specializing in user experience, design & software development

Degree 53 is a Manchester-based digital agency specializing in user experience (UX), design, and software development, primarily for the online gambling and sports betting industries.

Founded by Andrew Daniels in 2013, the agency has built a reputation for developing high-stakes transactional mobile apps and websites for major operators like Betfred and Scientific Games.

Following its acquisition by Bally’s Corporation in 2021, it now serves as the Sports Product Studio for Bally’s Interactive, focusing on North American gaming products.

Comprehensive Evaluation Timeline

  • 2013: Founding and Launch
    • Andrew Daniels, a former Betfred employee, founded Degree 53 Limited on May 21, 2013, with initial backing from Betfred founder Fred Done.
    • The agency initially established its office at The Sharp Project in Manchester.
  • 2015: Regulatory Milestone
    • In April 2015, the agency secured a Remote Gambling Software license from the UK Gambling Commission, a rare credential for a digital agency that allowed them to build bespoke transactional gambling platforms.
  • 2016 – 2017: Rapid Expansion
    • In 2017, the agency moved to a new HQ in Steam Packet House, Manchester, after recruiting over 30 new staff members, bringing its total headcount to 75.
    • The firm diversified its portfolio during this period, developing products for non-gambling clients like Vibe Tickets.
  • 2020: Sharp Gaming Spin-Off
    • Founder Andrew Daniels launched Sharp Gaming, a B2B gambling technology business, with £25 million in investment from Fred Done.
    • While Sharp Gaming focused on full-stack platform services, Degree 53 continued its focus on UX and front-end development under new Managing Director Richard Wagstaff.
  • 2021: Acquisition by Bally’s Corporation
    • On October 27, 2021, Bally’s Corporation acquired Degree 53 to bolster its internal technical unit for the launch of products like Bally Bet 2.0.
    • The team of 54 experts was integrated into Bally’s Interactive but remained based in their Manchester studio.
  • 2024 – 2026: Consolidation and Leadership Changes
    • The agency remains an active subsidiary of Bally’s. Recent regulatory filings indicate leadership transitions, such as the appointment of Raja B-Sheikh as a director in August 2025.

Summary of Key Services

  • Bespoke Development: Building native mobile applications (iOS, Android) and responsive web platforms.
  • UX/UI Specialization: User-centered design approach, including mapping customer journeys and conducting user testing.
  • Industry Expertise: Complex system integrations, data feed management, and API development specifically for the betting, gaming, and lottery sectors.

Key Areas Summarised

  • Core Focus: High-quality digital solutions for complex, regulated industries.
  • Key Services: UX/UI Design, Native iOS & Android Apps, Web Development, API Integrations, and Digital Strategy.
  • Strengths: Strong focus on user journey and engagement, particularly in betting platforms. They are noted for bringing high-quality digital solutions at competitive prices.
  • Impact: A significant player in the Manchester digital scene, moving to larger premises to accommodate growth from 50 to 75+ staff between 2014 and 2017.
  • Acquisition: In 2021, Degree 53 became the Sports Product Studio for Bally’s Interactive, supporting its North American expansion.

Key Clients and Projects

  • Betfred/Totesport: Mobile betting apps and websites.
  • Bally’s Interactive: Currently developing sports products.
  • Vibe Tickets: Developed a secure ticket-selling app.
  • Sofology: ‘My Account’ functionality.
  • Other projects: Ready for School, Football Acca, Horse Tracker.
Degree 53 logo Manchester Based
Degree 53 Logo

Key Company Facts

  • Acquisition: Acquired by Bally’s Corporation in October 2021 to advance its global sportsbook and mobile platforms.
  • Specialties: Mobile app development, UX/UI design, Bespoke .NET development, and API integrations.
  • Major Clients: Historically has worked with Betfred, Scientific Games, and Gamesys brands like Rainbow Riches.
  • Office Location: They are currently based at 60 Spring Gardens in Manchester city centre. Previous locations included Steam Packet House and The Sharp Project.

Mark Whitfield involvement 2014 – 2015 :

In late 2014, I joined Betfred as a Senior IT Project Manager in the Gambling and Casinos industry delivering multiple projects for both Betfred online and mobile (iOS, Android and Windows) using the Agile SCRUM framework. Project deliveries covered payment gateways and methods, sportsbook for football and horse racing amongst others and the online virtual (computer generated) gaming components.

As a major part of this allocation, I also linked into Degree 53 for project/ app status and aid in the setting of priorities for their Betfred specific software delivery.

Degree 53 was a Manchester-based digital agency specializing in user experience (UX), design, and software development
at Degree 53 Manchester office, 2015

Projects varied in size and cost and extended over multiple phases requiring the management of many software suppliers, each delivering different aspects of the solution from fraud detection, frontend, middleware, payment services and mobile apps.

Key Product Owner Terms

Key Product Owner Terms
Key Product Owner Terms

Agile Scrum Overview and Evolution Timeline

Agile Scrum is a widely adopted, iterative, and incremental framework designed to manage complex product development and software projects.

It breaks down large, daunting projects into small, manageable units called sprints—fixed-length iterations typically lasting 1–4 weeks—to deliver functional components faster and adapt to changing requirements.

Detailed Summary of the Scrum Framework

Scrum relies on three pillars—transparency, inspection, and adaptation—and is defined by specific roles, events, and artifacts.

1. The Scrum Team (Roles)

  • Product Owner (PO): Maximizes the value of the product by managing the Product Backlog. They define “what” is built.
  • Scrum Master: A servant-leader who helps the team follow Scrum theory and removes impediments.
  • Developers: The cross-functional team members responsible for creating the increment each sprint.

2. Scrum Events (Ceremonies)

  • Sprint Planning: Defines the Sprint Goal and the work to be done during the sprint.
  • Daily Scrum: A 15-minute daily meeting for developers to synchronize activities and plan the next 24 hours.
  • Sprint Review: Held at the end of the sprint to showcase the increment to stakeholders and gather feedback.
  • Sprint Retrospective: The team reflects on the process and identifies improvements for the next sprint.

3. Scrum Artifacts

  • Product Backlog: An ordered list of everything required in the product.
  • Sprint Backlog: The set of Product Backlog items selected for the sprint, plus the plan for delivering them.
  • Increment: The usable, working product increment produced at the end of a sprint.

Evolution of Scrum Over the Years

Scrum was developed in the early 1990s as a response to the failures of the linear “waterfall” approach.

  • 1986 (Concept Origins): Takeuchi and Nonaka publish “The New New Product Development Game,” comparing traditional relay-race product development to a rugby “scrum” team.
  • 1993 (First Implementation): Jeff Sutherland, John Scumniotales, and Jeff McKenna implement the first Scrum team at Easel Corporation.
  • 1995 (Public Introduction): Ken Schwaber and Jeff Sutherland formalize Scrum and present “The Scrum Development Process” at the OOPSLA ’95 conference.
  • 2001 (Agile Manifesto): Sutherland and Schwaber become signatories of the Agile Manifesto, cementing Scrum as a major Agile methodology.
  • 2010 (The Scrum Guide): The first official Scrum Guide is released to standardize the framework worldwide.
  • 2011–2017 (Refinements): The guide is updated to clarify roles and events, including strengthening the role of the Scrum Master and introducing self-organizing teams.
  • 2020 (The Modern Scrum Guide): A major update makes the guide less prescriptive, focusing on a single Scrum Team (removing “development team” and “scrum team” split), introducing the Product Goal for long-term focus, and focusing on one team working towards one product.

Key Resources and Links

Agile Scrum Overview and Evolution Timeline

Business Analyst Ecosystem and Core Competencies

Business Analyst Ecosystem and Core Competencies
Business Analyst Ecosystem and Core Competencies

Agile Backlog MoSCoW, Must, Should, Could and Won’t Have

Agile Backlog MoSCoW, Must, Should, Could and Won't Have
Agile Backlog MoSCoW, Must, Should, Could and Won’t Have

How AI Artificial Intelligence is Evolving in Project Management Career

How AI Artificial Intelligence is Evolving in Project Management Career
How AI Artificial Intelligence is Evolving in Project Management Career

Project signals not to be ignored and their meaning

Project signals not to be ignored and their meaning
Project signals not to be ignored and their meaning

Product Manager vs Project Manager

Product Manager vs Project Manager
Product Manager vs Project Manager

The Reality of a Project Manager, Execution and Accountability

The Reality of a Project Manager, Execution and Accountability

Agile Story Points and the Fibonacci Series, Estimation Strategy

Agile Story Points and the Fibonacci Series, Estimation Strategy
Agile Story Points and the Fibonacci Series, Estimation Strategy

Scrum and Agile in Projects

Scrum and Agile

Mark Whitfield, SC Cleared Senior Project Manager, Manchester

Mark Whitfield is a highly experienced, SC-cleared Senior Project Manager and Engagement Manager specializing in complex IT software development lifecycle (SDLC) projects, digital transformation, and cloud migrations.

Currently based in Greater Manchester, UK, he has over 31 years of experience in the IT industry, working with major blue-chip companies across various sectors, including UK Government, retail banking, aerospace, and utilities.

He is a certified PRINCE2 Practitioner, skilled in both Agile SCRUM and Waterfall methodologies.

Website Links:

Professional Biography:

Mark specializes in bridging technical teams and business stakeholders, delivering complex IT systems under challenging conditions.

His career spans from early roles as a developer on Tandem Mainframe Computers (HPE NonStop) to senior management positions focusing on cloud resources, API integrations, and CRM platform implementations.

  • Key Skills: Project Planning, Stakeholder Management, Financial Forecasting, Risk Management (RAID), Agile Scrum, PRINCE2, ITIL.
  • Key Strengths: Cloud Migration (Azure/Dynamics 365), Payment Systems (ATM/POS), and API-led connectivity.

Detailed Career Timeline:

  • Nov 2023 – Feb 2024 (UK Government – Capgemini): Acted as Client-Side Technical Delivery Manager for a £1m+ Fish Export Service (FES) to CHIP project, facilitating Azure-based API updates for UK-Northern Ireland trade.
  • Nov 2022 (UK Government – Capgemini): Managed two Microsoft Dynamics 365 Azure Cloud projects, including a £0.4m Dynamics 2016 migration and a £0.54m CRM platform discovery/build.
  • Feb 2022 (UK Utility Industry – Capgemini): Managed a £0.5M project migrating legacy document management systems to an Azure-based Enablon product.
  • 2020 (UK Gov – Capgemini): Senior PM for a £375k Agile proof-of-concept (POC) project migrating legacy applications (MS Access/Oracle) to Microsoft Azure and Dynamics 365.
  • Oct 2018 – June 2019 (MuleSoft): Served as Delivery Manager overseeing 5+ UK accounts for MuleSoft Anypoint Platform (API-led connectivity) implementations.
  • Oct 2017 (Automotive Industry – Capgemini): Managed a £430k Digital Readiness project and a £670k Customer Portal/Online Sales project (Agile).
  • May 2017 (Local Govt – Capgemini): Led a £400k telecommunications project (CCaaS) for the Support for Mortgage Interest (SMI) program.
  • Jan 2017 (Aerospace/Def – Capgemini): Senior Project Lead for two £1.3M projects with high-governance and gated deliverables.
  • Jan 2016 – Present (Capgemini UK): Joined as an Engagement Manager (A8), working on projects including Apple iOS app development for UK Air Traffic (NATS) and a £4.3M data center migration for Postal Services.
  • Dec 2014 – Jan 2016 (Betfred Limited): IT Senior Digital Project Manager for online/mobile payment gateways and sports book platforms.
  • Sep 2013 – Dec 2014 (Wincor Nixdorf): Senior Project Manager for a £5+ million ATM/POS software swap-out at a UK retail bank.
  • 2013 (Retail Banking – Riyadh): Delivered an RTLX transaction tracking project (BASE24 Classic) at a Saudi Arabian bank.
  • 1995 – 2013 (Insider Technologies): Worked on Strategic Technical Initiatives and bank-facing projects on the HPE NonStop platform (Tandem) for products Reflex 80:20, Reflex ONE24, RTLX and XPERT24.
  • 1990 – 1995 (The Software Partnership/Deluxe Data): Commenced career as a programmer specializing in electronic banking software on Tandem Computers (HPE NonStop), sp/ARCHITECT-BANK

Education:

  • 1988 – 1990: Higher National Diploma (HND) in Computing, Distinction/Overall First, Bolton Institute of Higher Education (now University of Greater Manchester from 2024).

Mark Whitfield, SC Cleared Senior Project Manager, Manchester

Why Do Project Managers Exist?

Why Do Project Managers Exist
Why Do Project Managers Exist?