Background: In order to automate financial reporting processes until a new long term solution was fully implemented, CTS Impact performed the following:

• Created Access database to support management reporting requirements
• Developed macros, filters, VLOOKUPS and other spreadsheet management tools
• Perform system testing in support of system upgrades
• Issue identification and resolution
• Developed data warehouse plan (Microsoft Analysis Server)

CTS Impact Solution: With significant real estate accounting operations and JD Edwards system implementation and user experience, the CTS staff performed the following:

• Business process analysis
• Workflow design and documentation
• Testing
  • Develop methodology
  • Script development
  • System and user testing
• Develop user-training  program and manual
• Trouble-shooting and support during go-live