!!!! PLEASE BID ONLY IF YOU KNOW YOU CAN DO THIS !!!! DON'T WASTE MY TIME !!!!
FBC uses 4 viral systems for the daily business which are Member-Reservation-System, SugarCRM, QuickBooks and SharePoint. All system has stored information’s about Members. Since every system holds an own copy of the same Member data and at the same time it’s very difficult to keep all four up to date. We want to overcome the manual update of member data in all four systems by developing software that holds all sources in synch.
The Sales team uses SugarCRM for their sales process and stores also address information for Suspect’s and Prospect’s. Once a Prospect signs a contract with FBC he becomes a Member and his Address information is synchronized with the reservation system. Stage 1 only synchronizes member data between SugarCRM and Reservation system. Stage 2 synchronizes member data between the Reservation system and the other two systems which are QuickBooks Enterprise and SharePoint 2012.
1. The Reservation system will be the lead system as far as unique Id’s and therefore all other systems will need to reference the member_number from the Reservation system.
2. Up to four members can be on the same Membership; therefore the membershipId will also be part of the Primary key.
3. Address changes can be entered in either system. The update of the other system must be immediate or shortly after.