Viewing entries in
MC | Technology | System Integration

Multifamily REIT

Multifamily REIT

For a large multifamily REIT, RealFoundations professionals implemented J.D. Edwards and interfaced with AMSI and Essbase data warehouse solution.

Objective

  • Reduce and redeploy personnel by centralizing and consolidating accounts payable processes to one system
  • Streamline month-end reporting processes by reducing the need for numerous Excel consolidations
  • Combine financial and non-financial data into one source for non-system users

Involvement

  • Consolidated three applications to J.D. Edwards and interfaced J.D. Edwards to AMSI and the Essbase Data warehouse
  • Reduced the financial and job cost accounting process to seven days
  • Provided an improved platform for field personnel to access financial information

Specialty Subcontractor

Specialty Subcontractor

For a large specialty subcontractor, RealFoundations integrated J.D. Edwards with Primavera’s Expedition project management tool utilizing a commercial integration solution.

Objective

  • Develop integration between JDE A7.3 to Primavera Expedition 6.3 utilizing Oberon Prospero
  • Develop migration strategy to integrated solution
  • Implement Expedition 6.3
  • Manage overall project

Involvement

  • Developed high level integration design documentation
  • Developed detailed integration specification documentation
  • Designed, built and tested integration procedures
  • Conducted conference room pilot and extended pilot testing
  • Prepared project data for migration to integrated solution
  • Developed web-based interface
  • Assisted in the implementation and training of Expedition
  • Provided overall project management
  • Provided post-conversion support

Online Procurement Solution Provider

Online Procurement Solution Provider

For a leading provider of an online procurement solution for the homebuilding industry, RealFoundations developed the integration with the TrueLine homebuilder management system.

Objective

  • Define the technical requirements and user interfaces necessary to share data between the online tool and the TrueLine back office system
  • Manage the integration development effort
  • Identify streamlined processes and efficiencies to be gained from leveraging an integrated solution

Involvement

  • Researched various integration tools and technical approaches
  • Defined the necessary data mappings, file formats and integration rules
  • Managed programming resources to write integration code according to the defined spec
  • Prepared test scripts and performed quality control testing
  • Documented end user procedures and conducted training sessions for TrueLine end users
  • Defined how the integration further enabled streamlined processes and increased efficiencies for the user community

Top 5 National Homebuilder

Top 5 National Homebuilder

For a top five national homebuilder, RealFoundations managed the integration design, development and testing between J.D. Edwards and the sales office system.

Objective

  • Lead integration design, development and testing efforts
  • Minimize manual setup of sales office system data
  • Ensure data integrity between J.D. Edwards and the sales office system
  • Provide project management of integration team

Involvement

  • Defined specifications for a download of community, lot, plan/elevation and option data from J.D. Edwards to the sales office system
  • Developed high-level design of upload workflow from sales office system to J.D. Edwards
  • Addressed business process issues related to defining an integration to support all divisions
  • Provided tools and procedures to facilitate clean-up and synchronization of option data between the two systems prior to activating the download
  • Managed the design, programming, QC testing and user procedures development for both the download and the option clean-up tool