Case Study for Project Management System Using Sharepoint
Brainvire Infotech Pvt. Ltd www.brainvire.com
http://www.brainvire.com
Š 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Client Requirement ➢
Client is a leading systems integration company
➢
Applications including CRM, MDM, EAI, BI and SaaS
➢
Application dealt with project management
➢
Consulting firm that specializes in the implementation of business
➢
The app dealt with management of users, groups and departments
➢
It gives the facility to create and assign tasks to employees
➢
Employees in turn can fill in their timesheets against the allocated tasks
➢
Employee’s managers have right to access the leave management section
➢
Track the Employee’s leave verifying the records of already availed
http://www.brainvire.com
© 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Project Challenges ➢
➢
SSRS integration with SharePoint server to show Reports Created Windows Services to execute on daily & monthly basis
➢
Optimized store procedures
➢
Eliminate performance issues
➢
Reports are accessing a large record
http://www.brainvire.com
© 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Technologies Used Operating System & Server Management
Windows OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance
Development Tools & Environments
Microsoft Sharepoint 2005, Java Script, Visual Studio .Net Framework, SQL Server Reporting Services, SVN etc
Database
SQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
http://www.brainvire.com
Š 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Manpower Project Leader
1
Developers
2
Designers
1
DBA
1
Quality Assurance Testers
1
http://www.brainvire.com
Š 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Planning ➢
➢
➢
➢
The following 3-tier development approach was adopted to equip the site The Database layer containing SQL Server 2005 Database, Tables, Triggers Reporting Service is used to show report on web part of the Pages The User Interface Layer which forms the Graphical User Interface of the web part
http://www.brainvire.com
© 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Architecture
http://www.brainvire.com
Š 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Development Highlights ➢
Design approach was centralized replacement for multiple web applications
➢
Supports various combinations of enterprise website requirements
➢
In order to access the database most effectively in an object-oriented context
➢
An interface translating the object logic to the relational logic
➢
Triggers were used only for complex updation and deletion of data
➢
Multiple tables and were entirely avoided with conditional syntax
➢
UI part of SharePoint application was used as a web part
➢
The site was developed and fully functional within a span of 2 months
http://www.brainvire.com
© 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Sources : http://www.brainvire.com/project-managementsystem-focusing-on-employee-data-management/
Contact Info : 1-631-897-7276 Email : info@brainvire.com Website : www.brainvire.com
http://www.brainvire.com
Š 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com
Contact Us https://www.facebook.com/Brainvire https://twitter.com/Brainvire http://google.com/+Brainvire http://www.linkedin.com/company/brainvireinfotech-pvt-ltd
Contact Info : 1-631-897-7276 Email : info@brainvire.com Website : www.brainvire.com
http://www.brainvire.com
Š 2014 Brainvire Infotech Pvt. Ltd
info@brainvire.com