Q3 Technologies: SharePoint sites on Moss2003 and Moss2007

Q3 Technologies. Gurgaon, India provided development support for client's SharePoint sites on Moss2003 and Moss2007 in order to customize them as per the requirements.

Business Situation:

Client required development support for its SharePoint sites on Moss2003 and Moss2007 in order to customize them as per the requirements. One such requirement is complete development of time tracking tools with options to analyze the time sheet in different formats.

Apart from this, a few bugs are reported every now and then, and they need to be fixed dynamically. The big challenge is that most of these sites are live and running websites, and while fixing the issues or configuring a site, any existing functionality should not be broken.

In addition, the quality and speed of the development and maintenance tasks are major concerns as these sites are live portals and their criticality cannot be ignored.

Solution:

• Q3 Technologies realized that it was important to consider and maintain the quality and accuracy. The majority of tasks were to be done on the live sites so the Quality Control was deemed extremely important.
• The SharePoint technology experts at Q3 Technologies thoroughly studied the client requirements and investigated the various features provided by the application. The IT team was approached, and replicas of the sites to be managed were hosted at the local domain so that each issue could first get fixed at the corresponding replicated site.
• The site maintenance operation was planned so that a bug is first fixed on the replicated site, the Testing team performs the test cycle on the replicated site, and thereafter the development team directly integrates the fixed codes in the running site. After integrating the changes in the live portals, the testing team again performs the test cycle in the portal in order to ensure total quality.
• A dedicated team of SharePoint experts has been provided to the client with the option of working in flexible hours, if needed.

For the Time Tracking tool, the database experts studied existing SQL database. During investigation, it was found that the database was not normalized and appropriate normalization of the database was done apart from adding new tables in order to match the requirements.