| SOX Compliance and Technology Options | 52 days? | Mon 01.01.07 | Tue 13.03.07 | | |
| SOX Compliance Review Preparation | 4 days? | Mon 01.01.07 | Thu 04.01.07 | | |
| Meeting with the external audit firm | 1 day? | Mon 01.01.07 | Mon 01.01.07 | | External Auditing Firm |
| Define SOX compliance review roles and responsibilities | 1 day? | Tue 02.01.07 | Tue 02.01.07 | 2 | External Auditing Firm,CFO,Internal Audit Director |
| Define SOX compliance review and decision processes | 1 day? | Tue 02.01.07 | Tue 02.01.07 | | External Auditing Firm,CFO,Internal Audit Director |
| Create SOX compliance review project plan | 1 day? | Wed 03.01.07 | Wed 03.01.07 | 4 | External Auditing Firm,CFO,Internal Audit Director |
| Conduct kickoff meeting | 1 day? | Thu 04.01.07 | Thu 04.01.07 | 5 | External Auditing Firm,CFO,Internal Audit Director |
| SOX Compliance Review Preparation Completed | 0 days | Thu 04.01.07 | Thu 04.01.07 | 6 | |
| Initiation and Scope | 5 days? | Fri 05.01.07 | Thu 11.01.07 | | |
| Determine the systems and processes that are in scope | 0 days? | Fri 05.01.07 | Fri 05.01.07 | 4,6 | Accounting,SOX Compliance Team |
| Build communications plan for project participants and stakeholders | 1 day? | Fri 05.01.07 | Mon 08.01.07 | 9 | SOX Compliance Team |
| Identify SOX training requirements for project participants | 1 day? | Mon 08.01.07 | Tue 09.01.07 | 10 | SOX Compliance Team |
| Define project plan, key milestones, budget, and key project participants | 1 day? | Tue 09.01.07 | Wed 10.01.07 | 11 | SOX Compliance Team |
| Define project progress reporting and structure for senior management | 1 day? | Wed 10.01.07 | Thu 11.01.07 | 12 | SOX Compliance Team |
| Project Initiation Complete | 0 days | Thu 11.01.07 | Thu 11.01.07 | 13 | |
| Review and Identify Improvement Opportunities | 24 days? | Thu 11.01.07 | Tue 13.02.07 | | |
| Perform Risk Assessment | 4 days? | Thu 11.01.07 | Tue 16.01.07 | | |
| Review and confirm risk factors | 1 day? | Thu 11.01.07 | Fri 12.01.07 | 14 | SOX Compliance Team |
| Validate probability and impact of risk factors | 1 day? | Fri 12.01.07 | Mon 15.01.07 | 17 | SOX Compliance Team |
| Estimate and validate size and complexity of risk factors | 1 day? | Mon 15.01.07 | Tue 16.01.07 | 18 | SOX Compliance Team |
| Identify Significant Accounts and Internal Controls | 2 days? | Tue 16.01.07 | Wed 17.01.07 | | |
| Identify and validate application controls over the initiating, recording, processing, and reporting | 1 day? | Tue 16.01.07 | Wed 17.01.07 | 19 | SOX Compliance Team |
| Confirm General IT Controls | 3 days? | Wed 17.01.07 | Fri 19.01.07 | | |
| Review Security Policies and Procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | 21 | IT Network & Infrastructure Team,SOX Compliance Team |
| Review Change Management Policies and Procedures | 2 days? | Wed 17.01.07 | Thu 18.01.07 | | |
| Review version management/release management procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Applications Team,IT Network & Infrastructure Team,SOX Compliance Team |
| Review source code/document version control procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Applications Team,IT Network & Infrastructure Team,SOX Compliance Team |
| Review Disaster Recovery Procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Network & Infrastructure Team,SOX Compliance Team |
| Review Backup and Recovery Procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Network & Infrastructure Team,SOX Compliance Team |
| Review Service-Level Agreement Policies | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Director / Manager,IT Applications Team,IT Network & Infrastructure Team,SOX Compliance Team |
| Review Application Development and Coding Standards/Review Procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Applications Team,SOX Compliance Team |
| Review Testing Policies and Procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Applications Team,SOX Compliance Team |
| Review QA procedures | 1 day? | Wed 17.01.07 | Thu 18.01.07 | | IT Applications Team,SOX Compliance Team |
| Summarize Improvement Opportunities Findings | 1 day? | Thu 18.01.07 | Fri 19.01.07 | 23,25,26,27,28,29,30,31,32 | SOX Compliance Team |
| Confirm Control Design | 4 days? | Fri 19.01.07 | Wed 24.01.07 | | |
| Identify policies and procedures | 1 day? | Fri 19.01.07 | Mon 22.01.07 | 33 | Accounting,SOX Compliance Team |
| Review narratives and flowcharts | 1 day? | Mon 22.01.07 | Tue 23.01.07 | 35 | Accounting,SOX Compliance Team |
| Review system configuration documentation | 1 day? | Mon 22.01.07 | Tue 23.01.07 | | IT Applications Team,SOX Compliance Team |
| Validate internal control checkpoints and processes | 1 day? | Tue 23.01.07 | Wed 24.01.07 | 37 | |
| Evaluate Operational Effectiveness | 4 days? | Wed 24.01.07 | Mon 29.01.07 | | |
| Identify/confirm labor-intensive and cost-inefficient internal controls | 1 day? | Wed 24.01.07 | Thu 25.01.07 | 38 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Prioritize inefficiencies - ongoing costs/internal control risks/cost and efficiency impacts | 1 day? | Thu 25.01.07 | Fri 26.01.07 | 40 | CFO,SOX Compliance Team,Internal Audit Director |
| Develop cost estimates and efforts for prioritized improvement | 1 day? | Fri 26.01.07 | Mon 29.01.07 | 41 | CFO,SOX Compliance Team,Internal Audit Director |
| Finalize Cost/Benefit Analyses | 12 days? | Mon 29.01.07 | Tue 13.02.07 | | |
| Group improvements opportunities into technology improvement projects | 1 day? | Mon 29.01.07 | Tue 30.01.07 | 42 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Develop cost/benefit analyses | 1 day? | Tue 30.01.07 | Wed 31.01.07 | 44 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Develop future state scenarios and opportunity savings | 1 day? | Wed 31.01.07 | Thu 01.02.07 | 45 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Identify gaps | 1 day? | Thu 01.02.07 | Fri 02.02.07 | 46 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Identify project risks and impacts of doing nothing | 5 days? | Fri 02.02.07 | Fri 09.02.07 | 47 | SOX Compliance Team |
| Identify additional key resources and information sources | 1 day? | Fri 09.02.07 | Mon 12.02.07 | 48 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Validate scope, participants and efforts | 1 day? | Mon 12.02.07 | Tue 13.02.07 | 49 | CFO,Accounting,IT Director / Manager,SOX Compliance Team,Internal Audit Director |
| Improvement Design Complete | 0 days | Tue 13.02.07 | Tue 13.02.07 | 50 | |
| Control Design | 10 days? | Tue 13.02.07 | Mon 26.02.07 | | |
| Project kickoff meeting | 1 day? | Tue 13.02.07 | Wed 14.02.07 | 50 | IT Applications Team,SOX Compliance Team |
| Design new systems and cross-reference to related internal controls | 1 day? | Wed 14.02.07 | Thu 15.02.07 | 53 | IT Applications Team,SOX Compliance Team |
| Identify technologies that will be implemented | 2 days? | Thu 15.02.07 | Fri 16.02.07 | | |
| Identify data capture and editing systems | 1 day? | Thu 15.02.07 | Fri 16.02.07 | 54 | IT Applications Team,SOX Compliance Team |
| Identify logging and monitoring systems | 1 day? | Thu 15.02.07 | Fri 16.02.07 | | IT Applications Team,SOX Compliance Team |
| Identify analysis and reporting systems | 1 day? | Thu 15.02.07 | Fri 16.02.07 | | IT Applications Team,SOX Compliance Team |
| Design necessary process changes | 1 day? | Fri 16.02.07 | Mon 19.02.07 | 56,57,58 | IT Applications Team,SOX Compliance Team |
| Create policies, standards, and procedures | 1 day? | Mon 19.02.07 | Tue 20.02.07 | 59 | IT Applications Team,SOX Compliance Team |
| Communicate changes that will required | 1 day? | Tue 20.02.07 | Wed 21.02.07 | 60 | IT Applications Team,SOX Compliance Team |
| Identify appropriate frequency of control | 1 day? | Wed 21.02.07 | Thu 22.02.07 | 61 | IT Applications Team,SOX Compliance Team |
| Finalize design | 1 day? | Thu 22.02.07 | Fri 23.02.07 | 62 | IT Applications Team,SOX Compliance Team |
| Obtain approvals needed (SOX Compliance/Management) | 1 day? | Fri 23.02.07 | Mon 26.02.07 | 63 | IT Applications Team,SOX Compliance Team |
| Control Design Complete | 0 days | Mon 26.02.07 | Mon 26.02.07 | 64 | IT Applications Team,SOX Compliance Team |
| Development | 4 days? | Mon 26.02.07 | Thu 01.03.07 | | |
| Develop/implement redesigned systems and/or controls | 1 day? | Mon 26.02.07 | Tue 27.02.07 | 65 | IT Applications Team,SOX Compliance Team |
| Re-communicate all changes to all impacted groups | 1 day? | Tue 27.02.07 | Wed 28.02.07 | 67 | IT Applications Team,SOX Compliance Team |
| Validate internal controls maintained and/or improved | 1 day? | Wed 28.02.07 | Thu 01.03.07 | 68 | IT Applications Team,SOX Compliance Team |
| Development complete | 0 days | Thu 01.03.07 | Thu 01.03.07 | 69 | |
| Testing | 5 days? | Thu 01.03.07 | Wed 07.03.07 | | |
| Validate control effectiveness | 1 day? | Thu 01.03.07 | Fri 02.03.07 | 70 | IT Applications Team |
| Document test cases/results in detailed test plans and summaries | 1 day? | Fri 02.03.07 | Mon 05.03.07 | 72 | IT Applications Team |
| Validate improvement and/or remediation actions accomplished | 1 day? | Mon 05.03.07 | Tue 06.03.07 | 73 | IT Applications Team |
| Document testing results | 1 day? | Tue 06.03.07 | Wed 07.03.07 | 74 | IT Applications Team |
| Testing complete | 0 days | Wed 07.03.07 | Wed 07.03.07 | 75 | |
| Implement | 5 days? | Wed 07.03.07 | Tue 13.03.07 | | |
| Update procedures and control documentation | 1 day? | Wed 07.03.07 | Thu 08.03.07 | 76 | Accounting,IT Applications Team,IT Network & Infrastructure Team |
| Implement system changes | 1 day? | Thu 08.03.07 | Fri 09.03.07 | 78 | Accounting,IT Applications Team,IT Network & Infrastructure Team |
| Monitor results and improvements | 1 day? | Fri 09.03.07 | Mon 12.03.07 | 79 | Accounting,IT Applications Team,IT Network & Infrastructure Team,SOX Compliance Team |
| Document results and summarize to senior management | 1 day? | Mon 12.03.07 | Tue 13.03.07 | 80 | Accounting,IT Applications Team,IT Network & Infrastructure Team,SOX Compliance Team |
| Implementation complete | 0 days | Tue 13.03.07 | Tue 13.03.07 | 81 | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |