• Ad Agency Talent Management Model

    Ad Agency Talent Management Capability Model
  • PeoplePM Training Course

    Improving the people skills of project managers
  • Improve Marketing Productivity

    Improve marketing department productivity
  • Enterprise Marketing Management Foundation

    Enterprise marketing management foundation
  • Improve HR Program Management

    HR Program Management Software
  • HR Roadmap Brochure

    HR Roadmap Brochure
  • Sapphire for Succession Planning

    HR Roadmap Brochure
  • Transform IT Governance

    IT Governance Transformation Brochure

Case Study: Ad Agency Job Tracking Portal

Client: Global Advertising Agency

Project: Job Tracking Portal Implementation

The Challenge

A large global advertising agency desired to implement a customized web-based job tracking portal as a front end to its production job tracking and financial management system. The new system handled job number creation, job start notification, call reporting, estimates, purchase orders, job closure, reporting, and other key job tracking activities. The new portal was intended to facilitate client cost management and foster timely communication about job status amongst production team members.

The current system was not intuitive and often difficult for inexperienced users to navigate. The system did not provide users with the most up to date information, and did not allow them to view and manage all impending client job charges. The reports provided by the current system were cumbersome and often included inaccurate data from the internal production departments.

The agency lacked standardized job tracking controls, guidelines, and procedures. Client requirements, instead of agency financial management and other data needs, drove most of cost tracking activities. The responsibilities of estimating and managing client job costs were unclear and inconsistent from account to account.

The Solution

Intellilink undertook a multi-pronged approach in order to address the agency’s challenges, and to maximize the benefit of the new system.

Process Analysis & Functional Requirements Gathering – The Intellilink team organized a multi-disciplined project team made up of department leads from Finance, Account Management, Project Management, Print and Broadcast Production, Client Accounting, and Information Technology. The objective was to gather functional requirements that truly captured the needs of all parties involved in job cost tracking. Intellilink conducted group process workshops and one-on one interviews to document as-is processes and identify improvement opportunities. The team developed to-be processes which incorporated proposed systems functionality and job cost management procedures. The re-design emphasized gathering quality data at the source, providing real-time access to information, and establishing better ownership of cost management by the appropriate departments.

Policy Development – The Intellilink team then wrote a Job Tracking Policies and Procedures Manual based on the improvement recommendations created during the process re-design phase. The policy manual was the first document created to standardize production roles and responsibilities across account teams. This document spelled out guidelines including; account management’s interaction with clients, turnaround times on signed original and revised client estimates, and purchase order requirements for internal and external vendors. Intellilink managed the agency-wide communication of the document and tailored key messages for each department. The policy manual was critical as leadership wanted to ensure that agency employees understood that the job tracking systems rollout was not simply an IT exercise, but a transformation in the way the agency conducted business.

Systems Implementation – Intellilink then identified a key account on which to pilot the job tracking system. The team selected the account based on the equal volume of print and broadcast work in its pipeline, timing of production, and complexity of the client requirements. Intellilink recommended that the IT department pilot and implement select functionality in a phased approach instead of releasing all of the new systems functions at once. The phased approach allowed the pilot team, to socialize and become comfortable with each system function versus being overwhelmed by an overnight system rollout. This approach also allowed the developers to tweak and enhance each function as the pilot group provided feedback. Intellilink developed and managed the implementation plan, oversaw the release of each function, and recommended system enhancements to facilitate the new job tracking processes.

Change Management – The Intellilink team then organized the training, communications, success tracking, and other change management efforts. The team developed presentations for each department lead to communicate key process and policy changes to their staff. The team also managed job tracking system training for the pilot and other account teams, and created feedback tools for users to provide input on the new processes, and recommend systems enhancements.

Case Study: Project Reporting

Client: Financial Services Institution

Project: Develop IT reporting capability

Overall Project Mission

A global financial services firm with over 10,000 IT staff worldwide lacked an integrated system to generate reports on its internal information technology projects. As a result, significant manual effort was expended to collect information on a monthly basis. Frequent fire drills would occur to provide ad-hoc management reports, and real-time information was nearly impossible to access. Even for these manual reports, the company lacked firm-wide standards for project reports, procedures, and reporting taxonomy.

The overall project mission was to create reports to facilitate IT project management and oversight. Reports were created for project execution, project tracking, portfolio management, resource management, resource deployment, financial management, and other key activities. Intellilink facilitated the reporting requirements documentation, development of reporting taxonomy, and created firm-wide standardized reports to satisfy end-user information needs.

The Reporting Challenge

Many challenges needed to be overcome to improve IT reporting capability. First, the client was implementing an integrated IT portfolio management system; however, the standard reports provided by the system did not fully satisfy the end users’ reporting needs. The development team would need to customize many of the standard reports and develop new ones to close the gap. The second challenge was that the existing systems did not share the same data sources, nor did they allow for seamless information sharing across lines of business (LOB). This required users to leverage multiple systems to generate project management reports. In addition, lines of business used group-specific reporting tools that hindered firm-wide knowledge sharing. The third challenge was that the firm has varied reporting requirements, making it difficult to standardize reports across the company. The fourth challenge was the decentralization of the firm’s lines of business. Because LOBs’ IT organizations were decentralized, some groups did not buy in to the need for firm-wide oversight and were not willing to have common definitions or reports.

In order to overcome these challenges, the reporting effort documented firm-wide user requirements, developed reports that could be used across all lines of business, and established universal reporting language. Reports provided project-level views of IT activities and aggregate level views for CIO level executives and senior IT oversight committees.

The Program

The reporting effort was organized into several phases, each with distinct activities and deliverables.

Scope Project – The project lead worked closely with client leadership to develop the project scope and establish parameters around the short and long term project objectives, project approach and timeline, the key deliverables for each project phase, and the key stakeholders involved in the effort. The team also developed data collection and communication templates to enable efficient and effective usage of the stakeholders’ time.

Assess Current Report Inventory – The team issued requests to each stakeholder group to submit samples of existing project-related reports. The team developed a preliminary list of standardized reports based on a combination of these submissions and Intellilink’s best practice database. The preliminary list of reports utilized a standardized reporting taxonomy based on system data definitions.

Develop To-Be Report Inventory – The team met with key stakeholders to vet the preliminary list of standardized reports and review drafts of report templates. The team defined critical reporting factors for each including end users, data elements/attributes, business purpose, delivery method, report generation method, and frequency.

Assess Report Delivery Feasibility – The team documented the final reporting requirements and delivered them to the report development technical team. Reports were organized into logical groupings such as project management, financial management, and resource management. The reporting team worked closely with developers to assess the ease of implementation of each report based on data availability, estimated development hours, and user priority. The end result was prioritized list of reports and a rollout plan.

Develop Reports – The team created scripts for developers and end users to test reports, as the technical team developed the custom reports. Reporting guidelines and other user documentation was developed to facilitate report usage post-implementation.

Implement/Rollout Reports – The team released reports to the end user community. A continuous improvement tool was created to capture future change requests and improvement opportunities.

Follow

Get every new post delivered to your Inbox.

Join 27 other followers