Product Project Case Studies

Project Case Studies

A great way to learn about eknow and Integrator is through "day-in-the-life" challenges of real clients. Each case below is notable for different reasons – either the sheer scale of the problem, the speed of the solution, the quantitative benefit, or the complexity of a problem that Integrator makes simple. 

eknow clients: To suggest a case study or to correct an error below, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it

"Hands-Free" Integrator Transition

Please note: Unlike other cases below, the following situation is not unique to this client case. It is included because many clients believe their situation is exceptional while in fact it is routine.

Situation
A serial acquirer wished to adopt Integrator, but the management team (a) was fully occupied by two acquisitions in progress, and (b) did not feel that it's existing M&A process was "ready" or sufficiently well-defined.

The client feared that, before they would be capable of making a transition to an well-organized system like Integrator, it would have to first define an internal M&A discipline (a perpetually unfinished project), and/or wait for a break in M&A activity. However no such opportunity was on the horizon. eknow and Integrator were selected to "make it happen."

Challenges
The corporate development management team simply did not have time to commit to organizing, explaining, and migrating data or processes. The individuals with the most knowledge were the least available. M&A process existed in each business unit but were not centrally defined. Many processes were not explicitly define at all. There was no single repository for corporate development or integration-related data or documents. The relevant documents were spread across multiple teams and team members: primarily spreadsheets, but also Microsoft Word, Powerpoint or Project documents.

In short, without significant interaction with the client, eknow would have to create, define and migrate the client's processes, and migrate the client's data. Integrator would have to be populated with the client's organization, workflow, historical data, client-specific templates for future deals, and customized forms and reports matching the client's nomenclature and process. eknow would know if it had "gotten it right" only after the client had reviewed the essentially completed implementation.

Solution

  • One contact person in a support role at the client organization was designated to locate and forward documents, which eknow would identify for him. The client contact person would internally request specific types of documents from the colleagues who would have access to them.
  • eknow then requested anything available from the following list: a corporate development organization chart, any spreadsheets previously used to track potential targets, a due diligence checklist, and a copy of pre-close and post-close integration task spreadsheets from at least one recent acquisition, and at least one sample of a weekly or monthly executive summary or progress report for a previous integration.
  • The client contact person located these documents and forwarded them to the eknow project manager as they were located. 
  • eknow analyzed these documents and determined the organization and processes they reflected. With this information and data, eknow recreated the organizational structure in Integrator, created client user accounts, and tailored Integrator reports and forms to reflect the implicit requirements of the client and its industry. During this process a few clarifying questions regarding roles were answered by the client contact person. 
  • Next eknow extracted all relevant data from those documents, manually when necessary, regardless of the format of the document. Spreadsheets were "massaged" or "scrubbed" into importable form. MS Word and Powerpoint documents were manually translated into importable data. Task lists were read and manually edited by eknow analysts and imported into Integrator.
  • In this case eknow hid all Integrator tools or modules, such as TSA's, head count management, and risk mitigation, that were not immediately relevant to the client's M&A activity. Note however that this type of configuration can now be done by a client administrator at any time by simply checking the appropriate boxes.
  • Finally, select Integrator iMemo templates were modified to request and collect task data from users, for the client's assessment, due diligence, and integration processes.

The completed implementation was presented in a walk-through for the customer contact who had assisted with the documentation above. eknow made minor revisions within one business day.

Outcome
eknow presented client management with a fully populated system, and made final revisions, in just over one week. The system reflected the client's organization, contained user accounts for all initial users, was populated with historical data, included templates for target assessment, due diligence, pre-close activities, and post-close integration. Forms, reports and iMemos were tailored for the client. 

Most importantly, this was accomplished (a) without wasting time of busy corporate development managers, (b) without requiring the client to have a well-defined, disciplined process before the transition, and (c) without distracting the team from deal it was working on at the time.

The outcome was a success. However, success in this situation is routine, for two reasons. First, eknow's long experience with precisely this situation allows it to work quickly with little guidance. Note also that, because this specific service is included in eknow's flat fee structure, eknow is incentivized to complete the work correctly and as quickly as possible. Second, Integrator's M&A-specific design mean that the core M&A process and best practices do not have to be defined by the customer. It is already defined in Integrator. The customer need only identify any necessary exceptions or variations from the norm.  

Highly Customize Integrator in 1 Week

Situation
A major energy client needed to deploy Integrator, customized and loaded with the client's pre-close planning templates, to its PMO and integration teams effectively 1 week after executing the eknow service agreement. 

Challenges
One week is more than sufficient to set up Integrator, create the client team structure in the system, create individual user accounts, and train the key users in the program office. However, the client had a number of special requirements to be satisfied in that same time frame:

  • Replace eknow terminology with customer terminology throughout the system
  • Create three new planning sub-phases, each with its own data entry and progress views, to replace Integrator's standard pre-close & planning phase
  • Configure the system to hide all other M&A phases and tools (Integrator 11 lacked the auto-configuration of Integrator 12)
  • "Massage" Microsoft Project integration planning templates and import into Integrator. These templates included several thousand tasks and involved virtually all functional areas of the combined company. Before the launch these plans would have to be reviewed, re-written and re-imported several times. 
  • Add new risk capture and reporting functionality
  • Reconfigure a variety of form fields and reports
  • Incorporate the client's graphical identity
  • Create a custom "quick-start" training deck for program office users around screen shots of the now client-tailored screens and the client's graphical identity 
  • Deliver training on-site training to the program office and team leads

 

Solution
eknow flew an analyst to the client site, who coordinated with colleagues at eknow. The eknow team worked evenings and both adjoining weekends to get more than a week of work completed in one business week.  

Outcome
In fact eknow successfully completed all of the necessary changes to the system, including visual and functional customization, converted and migrated thousands of rows of plan data into Integrator, created custom documentation, and trained key users in two sessions, on time, in one business week (including two weekends). The eknow team received high praise for its responsiveness, professionalism, and the working relationship with the client team. Note that despite the greater than normal customization, no engineering or programming was required. Integrator is a flexible configuration platform. However the experience did lead to the addition of several permanent features to Integrator 12, including auto-configuration, built-in template duplication, and risk features, among others, to the benefit of all eknow clients.

Integrate Facilities, Distribution in 50+ Countries

Situation
A large medical client acquired a company with presence in dozens of countries on five continents. The client had a presence in many of those countries. Now the acquired company would need to convert or consolidate distribution, facilities, and other operations around the world.

Challenge
The client feared that it would not be able to train these diverse managers on the full Integrator dashboard in the time allotted. But the longer their operations remained as is, the more financial benefit of the acquisitions would be lost forever to the simple passage of time.

Solution
The client developed a template of key integration deliverables for all locations. eknow created a simple iMemo that would be usable by managers with varying levels of English. The iMemo was automatically emailed by Integrator to team leads in each location. Each iMemo listed only the recipient manager's own integration deliverables and their status, associated documentation, and other management information. The iMemo recipients entered their integration activity data and attached documents directly in the iMemo. Integrator continuously aggregated and reported this data for the US program office.

Track Cost-Cutting by 200+ Teams

Situation
A large chemical client was tracking cost saving targets from very large acquisitions, involving hundreds of locations and scores of functional areas. Over 200 integration teams were accountable for cost savings in several countries in Europe and North America.

Challenges
The process of maintaining and distributing the spreadsheet model, capturing the quarterly results, identifying and following up on errors, and aggregating and reporting the final corrected data, was extremely labor intensive and time consuming. Results were not available until weeks after the close of the quarter. Relatively senior management had to take their focus away from day to day operations for an unacceptable length of time. Data was captured in two currencies. Managers would sometimes edit data from the wrong time period. The process of entering the quarterly data in the model was also tedious for the responsible managers. Some synergies were more critical, due to their value or their state of risk, and quarterly reporting was insufficient to allow for effective or timely course-corrections.

Solution
eknow and the client used an iMemo, sent automatically to critical synergy owners on a monthly basis, and quarterly to the other synergy owners. The iMemo presented only the synergies for which the recipient was responsible. Past financial measures and future plan values were visible in the table but were read-only. Only the financial measures and applicable time period was editable to the user. As synergy implementation and value capture progressed, the program office simply flagged or unflagged synergies as critical in the Integrator dashboard.

Outcome
Integrator and the iMemos were used with great success throughout the multi-year integration and subsequent restructuring efforts. The Integrator and iMemo approach improved data quality immediately, and saved vast amounts of time for the program office and integration teams responsible for synergies. The executive and program office enjoyed the ability to flexibly identify, track and respond quickly to critical synergies. The Integration team members enjoyed the simplicity of the iMemo, and the fact that the iMemo presented "on a silver platter" only the synergies, financial measures, and time frame to be updated.

10,000 Employees. 40,000 Agreements. 15 Days

Situation
M&A can require mass adoption of agreements, policies and procedures. A US eknow client had to deliver new non-compete agreements, compensation, non-disclosure and other agreements required as a condition of their employment, to just under 10,000 employees.

Challenges
A non-compete agreement was required of each employee, but the terms it could contain depended on the laws of the state in which the employee lived. Other agreements had to be executed depending partly on employee role, functional area, and management level. Finally, if possible at least 90% of the agreements were to be executed in time for a Board of Directors meeting on the subject in less than a month. Similar efforts in the past had required 3 months or longer to complete, and had never greatly exceeded 90% compliance.

Solution
eknow imported the key employee variables (state of residence, functional area, management level, etc.) into Integrator. eknow set up an iMemo which Integrator sent to each employee. The iMemo automatically presented the precise set of documents that the employee had to review and execute. The iMemo contained a mechanism to legally execute the agreements, or indicate the reasons for which they could not do so at that time. Integrator kept track of who had and had not completed the task and sent automatic reminders only to those who had not. Employee refusals, concerns, or requests to correct their profile were automatically relayed to supervisors and legal for immediate personal follow-up. No custom programming or engineering of Integrator was required.

Outcome
The target of over 90% of the agreements was exceeded in just two weeks. This was approximately 6X the compliance or completion rate of similar initiatives prior to adopting Integrator. The management and administrative effort was reduced by a comparable if not greater amount. In the third and fourth weeks, virtually all stragglers – the remaining 10% – were rapidly accounted for: according to the client, accounting for leaves of absence and turnover during the period, they effectively achieved 100% compliance within 30 days. Importantly, management knew exactly where they stood every day throughout the process.