Case Study Project Management System Focusing on Employee Data Management
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client
Requirement
Client is a leading systems integration company and consulting firm that specializes in the implementation of business applications including CRM, MDM, EAI, BI and SaaS. This application dealt with project management with a major focus on collecting and storing Employee-related data. 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. Timesheet module being the complex part of the app, it gave Employee the facility to add their own customized tasks and fill the time accordingly. Employee’s managers have right to access the leave management section and track the Employee’s leave verifying the records of already availed and pending leaves. Managers can approve the leave(s) or reject them. Each module had a related ‘Reports’ section which provided a useful insight into monthly and yearly summary. As the application encapsulated crucial data capturing employee/work management modules, it had to have a strong logical checks and validations as to which user level gets access to what and which user level has what part in module flow. This is controlled by using an admin-level permissions module which allows access for managing module-level data to each user group.
Project
Challenges
Team faced the following challenges: •
SSRS integration with SharePoint server to show Reports.
•
Created Windows Services to execute on daily and monthly basis.
•
Optimized store procedures to eliminate performance issues when reports are accessing a large record.
Technologies Operating System & Server Management
Development Tools & Environments Database
Used 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 Microsoft Sharepoint 2005, Java Script, Visual Studio .Net Framework, SQL Server Reporting Services, SVN etc. SQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 2
Manpower Project Leader
1
Developers
2
Designers
1
DBA
1
Quality Assurance Testers
1
Planning The following 3-tier development approach was adopted to equip the site with numerous features and functionality mentioned below: •
The Database layer containing SQL Server 2005 Database, Tables, Triggers and so on.
•
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.
Architecture UI Apply For Leave for User
Applied Leave details For User
UI Approve/Reject for Leave (Approver)
UI User List of applied Leave (Approver)
Business logic/Validation for Leave
Data Base
Monthly Scheduler Will calculate and Update Leave Table for all leave/Resources
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 3
Development Highlights The design approach was centralized replacement for multiple web applications and 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 was used to communicate with the relational databases in an object-oriented manner. Triggers were used only for complex updation and deletion of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the application. The UI part of SharePoint application was used as a web part and data was being called from their respective code. The site was developed and fully functional within a span of 2 months.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4