Microsoft SharePoint version 2007 was selected as a collaboration tool for internal Citigroup resources in different departments. Particularly, the tool was selected to aid in managing of all Citigroup fund services Canada projects and programs. Our team member was the project manager for this implementation. The implementation approach followed a defined project management methodology of scope definition, requirements gathering, business/technical requirements documentation, coding, deployment, quality assurance & acceptance testing and post implementation support.
The architecture selected was a simple multiple front-end (web servers) with loadbalancers between multiple FE web servers to ensure application scalability. At the backend was a database server capable of handling expansion for extranet SharePoint farm or additional intranet applications.
The software elements deployed on FE web servers include: MS Windows server 2003 R2; MOSS 2007; MOSS Standard CAL; while MS SQL server 2005; active-passive cluster configuration; MS Windows server 2003 R2 Enterprise Edition. An active directory domain controller was also deployed to take care of users access and authentication.
The intranet SharePoint application was also integrated with all Microsoft applications such as excel services, word, access etc to allow for maximum use of MOSS 2007 features. Of importance was the backend severs integration with existing legacy application reporting servers to allow for full use of business intelligence features of MOSS 2007 for dashboard reporting.
The project was completed on time and on budget with very positive client feedback on value for money that MOSS 2007 delivered, and increased resources productivity.
Microsoft Office SharePoint Server (MOSS) 2007 was implemented to enhance reporting capabilities of SAP standard reports and provide a web based reporting user interface that can be accessed from the web using uniform resource locator (URL) accessed through a secured hypertext transfer protocol https://. The integration leveraged an existing intranet developed on MS SharePoint platform accessed by an average of 1000 users a day. The existing intranet SharePoint site is accessed using windows authentication defined by domain controller (active directory).
Business server pages were integrated and made available on MOSS site URLs using dynamic page viewer which is a custom MOSS web part. The layout and configuration of specific dashboard report is made possible by updating parameter values in each mapped web part. Our extensive knowledge of MOSS features, configuration and customization resulted in a more efficient and effective delivery of customized dashboard reports using rich UI features in MOSS 2007.
Digitization of archived building is a project that emanated from the need to digitize i.e. capture, collate, store, manage and disseminate data critical to the successful implementation of an automated building plan approval process which is an initiative put forth for implementation by the Abuja Metropolitan Management Council. The project is also driven by the need to create portability for building plan data that can easily be leveraged by other departments under the metropolitan authority for subsequent reusability.
This project include: collating, capturing, digitizing and converting into CAD-readable models (compatible with the proposed automated software solution of the Department) at least 22,000 approved building plans in the department’s archives and registry (for districts in Phase I, II & III of the FCC).
Examples of this project deliverables are:
- Enhance existing data
- Digitized cadastral Sheets for the entire districts in the project area
- Digitized survey beacon coordinates for all the plots in the project area
- Digitized parcel boundaries for all the plots in the project area
- Digitized topographic data (contour maps) for all the plots in the project area
- Digitized land-use and layout plans of all the districts in the project area
Electronic data output from existing hardcopy data captured, enhanced, stored and referenced/charted include:
- Shape files (.shp) or
- Personal Geodatabase file (.mdb)
- Compressed JPEG (.jpg)
- Portable document format (.pdf)
- Digitized and indexed building/development plans (layout plan, all floor plans, roof plan)
- AutoCAD .DWG format
The project is an ongoing project currently managed by members of our team.
SET UP OF FIBRE OPTIC TRANSPORT FACILITY FOR MPLS VPN BASED DR (DISASTER RECOVERY) NETWORK FOR EXPERIAN SCOREX
Our team members implemented the setup of fibre optic lines from primary data centre to the disaster recover site in Dallas USA. The project involved the laying of fibre optic cables along 45km route between the primary data centre and DR (disaster recovery) site also in Dallas USA.
Our participation also includes the setting up of MPLS VPN based cloud using a layer 3 approach. Activities performed on this project involve procurement of Solaris and Gateway servers, routers such as multiservice edge routers, customer routers, provider routers etc. Various hardware configurations were also implemented which include but not limited to: creation of VRF tables, labeling of IP datagrams, defining rules within RD, etc.
The deliverables from this project include: establishment of disaster recovery network built on fibre optic capable of running MBGP/MPLS VPN, mapping of backend production servers for virtual redundancy between production and backup servers at defined interval, installation of customer edge routers within Experian sub-net, definition of recovery time & point objectives based on DR network availability, validation of meeting service level agreement promised clients and validation of DR required network bandwidth/size.
Our members employed total quality management to ensure deliverables meet required technical specifications and industry standards as well as defined client objectives.
We ensure site inspection was carried out to identify the less risky path/route for the fibre optic cable installation. Our approach resulted in compliance with local authority cabling standards and by-laws.
REPATRIATION OF BACK-OFFICE SYSTEMS AND NETWORK FOR LOBLAW COMPANIES LIMITED/PRESIDENT’S CHOICE BANK
Our team members were involved in the back-office repatriation project for Loblaw Companies Limited/PC Bank. The project involves the repatriation of the entire back-office operations from one vendor to several other vendors. The existing networks prior to repatriation were 4 T1 lines of 32 channels running on a leased line. Activities performed on this project includes: measurement of required bandwidth based on new application and technology platforms (ACD system for call centre, PEGA document management application etc.) which requires video, VoIP, voice calls, images etc. hence more bandwidth size.
To support faster response time and enhance application performance, we implemented VPN on MPLS cloud within Loblaw/PC Bank network. The MPLS cloud was configured to serve as a mega connection hub for the new vendors. Routers placed within the Loblaw/PC Bank network were configured to route frames and packets in accordance with virtual routing & forwarding (VRF) tables.
Due to the nature of the vendor’s business activities, secure shells (SSH) were set up on the routers to control network access. The network tunnel between vendor’s sites and Loblaw/PC Bank MPLS VPN based cloud was also secured using AES (Advanced Encryption Standard) encryption algorithm.
Deliverables achieved on this project include but not limited to: successful creation MPLS VPN on existing T1 lines, procurement and configuration of routers to allow IO (input/output) traffic, installation of certificate authority ACL on primary network server, installation of secure shells (SSH) on all customer edge routers, project management (on budget and on time delivery of components) etc.
The above summarizes few of the many more of our previous experiences/projects. We are happy to share on more of our experiences/projects in the very near future.