PnC Sharepoint Application is to help drive the process in PnC Team. PnC Team manages it's team data in Microsoft SharePoint. This Application interacts with the Microsoft SharePoint through Web Services, gather the data and performs process driven tasks..
This application is designed to host multiple processes driven actions or gather information such as
- Active Team Details
- Team Members on Leave Today
- Team Members Defaulting on filling Actual Miles
- etc..
Actual Miles is a in-house tool developed to track the effort put in by each team member daily. This tool helps the team managers derive various metrics such as the Estimated Hours Vs Actual Hours..
The entire process is based on the resposibility of each team member to update the efforts in the Sharepoint, failing to do so can result in incorrect data casaded up the chain.
This applciation was built in order to valdiate that all the team members update their effort daily and send out a reminder email in case the team members fails to comply with the process..
The User needs to enter their Credentials and the Date (Defaulted to Current Date - 1 since we validate if yesterday's efforts were logged properly in most cases) they want to valdiate the actual miles
The outcome would be an email send from the company's network (In this case from gmail since we are outside the network) with the names of the team members who failed to update their efforts..
Following is the application Flow on launch
- User enters the credntials and update (if needed) the Date to Validate
- Validate the Date and it's format.
- Authenticate the user credentials.
- Retrieves the Active Team Member Details.
- Retrieve the Team Member on Leave.
- Retrieves the Actual Miles Details.
- Check if the Actual Miles effort logged for each team member in 0 only if
- Active team member
- Not on leave
- Is an IT personal (not Manager etc)
- Send out a consolidated notifications to the defaulters, CCs the Managers and Actual Miles Process owners
Following are the Key scenario that are handled in the application
- Valdiate Actual Miles for active team members on the given date.
- Valdiate Actual Miles for the team members not on leave on the given date.
- Valdiate Actual Miles for IT Team Members only (exclude Managers etc.)
- Date to validate is defaulted to Current Date - 1 for Tuesday, Wednesday, Thrusday & Friday.
- Date to validate is defaulted to Current Date - 3 for Monday.
- Date to valdiate is not in future.