| By Ashwini Kumar, Raghav Mathur | Article Rating: |
|
| November 26, 2004 12:00 AM EST | Reads: |
17,933 |
The passage of the Sarbanes-Oxley Act of 2002 (SOX) marks a new era of accountability for corporate officers. Signed into law by President Bush in response to corporate accounting scandals, it is a major concern and top priority for the CEOs, CFOs, boards of directors, and audit committees of public companies, as well as for auditors, accountants, attorneys and regulatory governing bodies. Starting in 2004 (2005 for smaller companies), the financial reports of publicly traded companies in the United States must begin to comply with the financial disclosure requirements of this Act.
One of the major areas of concern is Section 404, Management Assessment Of Internal Controls, which requires companies to include in their annual report "an internal control report, which shall:
(1) State the responsibility of management for establishing and maintaining an adequate internal control structure and procedures for financial reporting; and
(2) Contain an assessment, as of the end of the issuer's fiscal year, of the effectiveness of the internal control structure and procedures of the issuer for financial reporting."
Successful compliance with Section 404 of SOX requires management to make visible and provide documentation of the status of all the various compliance issues associated with the new law. In addition, the company's auditors must review the company's SOX compliance and include an assessment in the auditing report. In order to provide such extensive documentation, companies are turning to solutions offering both content management and reporting components, such as IBM Lotus Workplace for Business Controls and Reporting.
The Act has heralded an age of intense content management at a time when content has morphed into many formats. Scanned paper images from accounting departments, electronic forms from human resources, presentations, e-mail, online messaging logs, and even voicemails are all forms of data made equal under the auspices of the Sarbanes-Oxley Act.
Using information technologies, companies can achieve the following goals needed for SOX compliance:
- An unambiguous definition of the procedures that a business user, not an information technology professional, could easily use
- A comprehensive explanation of the business process and the associated roles and responsibilities
- Automatic reference from a single process step to related, unstructured information and reports
- Clear identification of the controls within the process
- The ability to monitor processes and procedures related to content management
The Web-based Workplace software leverages a range of third-party control catalogs and knowledge of industry-specific internal processes to help businesses understand and prepare for Sarbanes-Oxley mandates and jump-start the controls process. An organization can identify, assign, test, and monitor controls. The solution provides role-based access, which directs controls and financial reporting directly to the individuals responsible for execution, and provides real-time access with the "at-a-glance" dashboard. Both allow for quick issue identification, risk mitigation, and responsiveness. The solution also adds minimal impact on day-to-day operations enabling compliance activities to become a fluid part of employees' regular routines.
The content management component of this product allows content to be checked in and out of the system's repository. Library services also provide key features allowing metadata and audit log management, as well as content versioning - safeguards that enable users to roll back to previous versions if necessary. This repository is further augmented by the capability to search using full-text, keyword, or advanced technologies such as pattern recognition, expert recommendation, and semantic searching.
Lotus Workplace for Business Controls and Reporting is built on the industry's leading middleware technologies, IBM WebSphere Portal, and IBM DB2 Content Manager, which provide a single, unified and reliable platform for the entire organization. Lotus Workplace for Business Controls and Reporting also includes a fully integrated Crystal Enterprise Reporting Engine for generating the different reports showing the effectiveness and status of the business controls.
Other features of Lotus Workplace for Business Controls and Reporting include:
- A role-based interface. When employees log in to the system, they are presented with their individual tasks and responsibilities and the resources and tools they need to complete those tasks.
- Role-based reports. Role-based reports allow you to report on various combinations of data. You can have executive views showing summaries of control effectiveness and deficiencies in graphical format that are linked to detailed reports about each control. You can generate reports for employees and managers that need to combine information from different data sources.
- Robust security features. You can protect your sensitive data with features such as single sign-on, role-based access and read-only access.
- Scalable framework. The product provides a framework allowing you to organize and document your business processes and expand as needed.
- 24/7 access. Implemented as a Web-based portal application, it gives 24/7 workplace access to employees and users. Even if your employees are offsite, they can retrieve the information and find the tools they need to do their work.
- Collaborative environment. Electronic workplaces allow employees to collaborate on projects and tasks. Presence awareness and instant messaging allow for real-time resolution of questions and problems.
- Ease of navigation. Enhanced navigation allows users to quickly complete control tasks for greater focus on core business.
- Audit trails and archiving. Audit trails and archiving help to ensure process and document integrity.
- Third party enhancements. You can take advantage of industry insights and knowledge of internal control processes and practices via leading third-party control catalogs from vendors such as KPMG.
- Integration of existing systems. It doesn't replace existing SAP, PeopleSoft, etc., applications. Instead it accesses information from those applications to present in reports for management so that management can assess risk in their organizations.
Figure 2 illustrates how you can drill down to the controls that make up a process, in this case the controls that are a part of the Bad Debt process in Accounts Receivable.
Technology Components and Servers
Components of Lotus Workplace for Business Controls and Reporting (LWBCR) are installed on three core systems (machines). Distribution of components on these three systems is based on the role performed by each system in the configuration. A typical distribution of these components is listed here:WEBSPHERE PORTAL SERVER
A platform for the following components used in application presentation and business logic:
- WebSphere Portal 5.0.2
- DB2 8.1 ESE Fixpack5 (DB2 Client)
- Information Integrator for Content Developer Client (II4C) 8.2
A server for data storage and for controlling user access based on their roles with the following components:
- DB2 8.1
- Visual C++ 6
- WebSphere Application Server 5
- Content Manager 8.2
- Information Integrator for Content Developer Client (II4C) 8.2
- IBM Directory Server SDK 5.1
The Crystal reporting engine is used for generating the reports that access the database on the content manager server and render the images over HTTP. The components installed are:
- DB2 8.1 (required for IDS 5.1)
- IBM HTTP Server 2.x
- Crystal Enterprise Server 10
- IBM Directory Server SDK 5.1
Installation
The installation of Lotus Workplace for Business Controls and Reporting is a very complex and sensitive process involving the correct installation and configuration of several IBM and third-party software components. It is recommended that you leverage IBM services or hire a Lotus Workplace consulting expert such as Prolifics to expedite the installation process.Install the Workplace components in the following order:
- WebSphere Portal on the Portal server
- DB2 Installation on the Content Manager (CM) server
- IBM Content Manager on the CM server
- WebSphere Application Server installation on the CM server
- Installation of Information Integrator for Content Developer Client (II4C) on Portal and the CM server
- IBM Directory Server on the CM server
- DB2 Developer Client on the Crystal Enterprise (CE) server
- Crystal Reports Server Install on the CE server
Getting Started
After the software is installed and configured, you need to input the information specific to your business. The following steps provide an overview of the process you would follow in order to implement Lotus Workplace for Business Controls and Reporting.- Typically you start by defining your organization - the managers and employees that make up your company - and assign the ownership of business units to the corresponding manager.
- After entering your organization information, you need to document your business processes, objectives, risks, and business controls. Alternatively, you can import best practices.
- Part of defining your business processes and controls is to document how this control can be evaluated and tested along with a date for performing these tests. As you use the system, you will need to continue this evaluation process in order to determine its effectiveness.
- You can attach or link documents to the processes with the necessary financial data.
- In order to check the effectiveness of the system, generate reports for your processes and controls.
Summary
Even though publicly traded companies are required to comply with the Sarbanes-Oxley Act, this legislation does provide an opportunity for all organizations to review their business controls and streamline their business processes. For companies with paper-based financial reporting systems, this can be the time to migrate to online controls and the advantages that come with an online system. With Lotus Workplace for Business Controls and Reporting you have a tool to start and implement the process and a tool that can grow with your needs.The following is a summary of some its key benefits:
- Lotus Workplace for Business Controls and Reporting leverages third-party control catalogs that are ERP and industry-specific, and internal controls knowledge from KPMG to create best practices and jump-start the process.
- The portal infrastructure aggregates information for an enterprise-wide view and provides a unified approach for companies to conduct self-assessment of internal controls at an entity-wide level.
- The role-based, real-time access enables companies to make more informed business decisions and help mitigate risks.
- Sophisticated content management and reporting capabilities allow companies to consolidate any format of content whether paper-based, voice-based, or online, and present a detailed assessment of compliance within the auditing reports.
Published November 26, 2004 Reads 17,933
Copyright © 2004 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Ashwini Kumar
Ashwini Kumar is a senior software consultant at Prolifics. An IBM certified portal solutions developer, Ashwini has over 8 years of experience in building scalable and distributed J2EE and struts-based Web applications, and is also experienced in process choreography, Web Services and business integration solutions. He holds a Master of Technology degree in computer sciences from Mysore University, India and a Master of Sciences degree in engineering management from the Gordon Institute of Tufts University.
More Stories By Raghav Mathur
Raghav Mathur is a senior architect for the Portal Consulting Practice at Prolifics. A certified portal solutions developer, Raghav has expertise in products and technologies including WebSphere Application Server, WebSphere Portal Server, WebSphere Studio Application Developer, DB2, J2EE, and Java. Raghav helps organizations to translate their business requirements into a robust portal architecture, providing the overall design specifications and validating the existing design.
- IBM Rips Out Its Siebel Seats
- Big Data and the Cloud at Cloud Expo New York
- CleverTouch achieves compound growth of over 120% p.a., opens in Europe, and appoints new MDs and advisory board
- IBM Puts All Its Experience in a Box
- The Converged Application Container
- Hot Tech Firms at the 2012 DoDIIS Conference
- IBM Buying Varicent Software
- IBM and Red Hat Join OpenStack
- Cloud Office and Collaboration Productivity Applications Market Shares, Strategies, and Forecasts, Worldwide, 2012 to 2018
- IBM Sells POS Unit in Lenovo-Like Deal
- IBM’s Buying Vivisimo for Its Big Data Push
- Beyond the Walls of the Enterprise
- IBM Rips Out Its Siebel Seats
- Big Data and the Cloud at Cloud Expo New York
- CleverTouch achieves compound growth of over 120% p.a., opens in Europe, and appoints new MDs and advisory board
- IBM Puts All Its Experience in a Box
- The Converged Application Container
- Hot Tech Firms at the 2012 DoDIIS Conference
- IBM Buying Varicent Software
- IBM Acquires Worklight
- IBM and Red Hat Join OpenStack
- Cloud Office and Collaboration Productivity Applications Market Shares, Strategies, and Forecasts, Worldwide, 2012 to 2018
- IBM Sells POS Unit in Lenovo-Like Deal
- IBM’s Buying Vivisimo for Its Big Data Push
- Java vs C++ "Shootout" Revisited
- Where Are RIA Technologies Headed in 2008?
- WebSphere Application Server Java Dumps
- Breaking News: New Internal IBM Report Says "Another Flawed Study"
- How To Deploy Scalable WebSphere Applications Using "Maven" Build Tool
- Last Exclusive JDJ Interview With "IBM's" John A. Swainson, Now CA's Newly Appointed CEO
- Profiles for WebSphere Application Server 6.0
- Unveiling the java.lang.Out OfMemoryError
- Automated Deployment of Enterprise Application Updates
- Developing Java and Web Services Applications on Rational Application Developer V6
- Your Guide to Portal Clustering in WebSphere Portal Server 5.1
- The Top 250 Players in the Cloud Computing Ecosystem

















