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