|
BT at O2
Dublin
April 2010 - November 2010
|
This is the view from my office, overlooking the beautiful Samuel Beckett Bridge
|
Telefónica O2 Ireland
28 - 29 Sir John Rogerson's Quay
Dublin 2
Ireland
Switchboard: +353(01) 609 5000
Web: http://www.o2.ie/
|
|
We are a leading provider of mobile services, offering communications solutions to over 1.7 million
customers in Ireland. Headquartered in Dublin's Docklands, and with a Customer Care Centre in Limerick, O2 has a total workforce of over
1,300 employees.
O2 began life as Esat Digifone in Ireland in 1996. In 2000 British Telecom acquired Esat Digifone and subsequently demerged its wireless division – called mmO2 - in 2001.
In 2002, mmO2 rebranded and the O2 group of companies was officially launched.
In March 2006, O2 was acquired by Telefónica S.A. one of the largest telecommunications companies in the world and the O2 group of companies became known as Telefónica Europe.
In addition to O2 in Ireland, Telefónica Europe provides integrated mobile, fixed and broadband services in the UK, Germany, the Czech Republic and Slovakia under the O2 brand name.
Telefónica Europe's parent company, Telefónica S.A., is headquartered in Spain and is one of the largest telecommunications companies in the world, with a presence in 25 countries. Telefónica employs more than 250,000 people and has a customer base that amounts to 259 million accesses around the world.
|
|
My Role :
-
Requirement Analysis
- Design and Specification
-
Development of applications in Microsoft Access
2003/2007, Excel 2003/7, Oracle 8i/9i/10g and Sybase
that provide the internal CMDB services for the deployment and management of 2G and 3G Mobile Telephone and Broadband infrastructure.
Produced high-quality "shrink-wrapped" applications for Windows Installer deployments.
- Data
cleaning and importation from 3rd party systems.
-
Writing of UAT test plans.
- Devising deployment strategy and building the
deployment mechanisms.
-
Documentation of applications
-
Application Support
|
Access 2010, Access 2007, Access 2003 and Access 2007 Runtime were used to build and deploy applications |
 Custom
Office Ribbon User Interfaces were built as the main GUI
using both MS Office 2003 and 2007 |
Visual Studio was used in ribbon development
|
 Access
Package Solution was used to build complete runtime
applications deployed by Windows Installer. |
Microsoft Graph was used to build graphical reports.
|
  There
was significant interaction between the Access applications
and Excel. Complex spreadsheets were built by the
applications, Excel macros were called from the Access
applications, custom .XLA add-ins were used and spreadsheets
were imported and manipulated by the process. |
 Many
of the data sources were Oracle 8i, 9i and 10g. Dynamic
connections were made by DSN-less connections and the Oracle
OCI interface was manipulated directly using ADO. |
 Data
sources included Sysbase ASA15 and IQ15 databases |
 Complex
XML was used extensively as data sources and data targets. |
 PDF
files were part of the output of automatic document
generation of the applications.
|
Total Access Analyser, from FMS Inc, was used to analyse and manage existing appications, and perform the final check on applications for distribution.
|
 Some
applications used
Word automation
to build reports. |
The BSC Weekly Report MS Access application built complex multi-sheet spreadsheets from a variety of data sources and Excel macro mathematical libraries
|
|
| Trinity |
This is part of the customised Microsoft Office Ribbon GUI of the Main Menu of the Trinity application
|
| Designed, built and delivered a new runtime Access 2007 application to provide
network engineering data to field engineers
from complex diverse sources, including an Oracle database and Excel spreadsheets.
|
| BSC Weekly Report |
This was the video Splash Screen which was part of the rewriting of the BSC Weekly Report legacy Access application. Significant use was made of Excel macros.
|
| This Access 2007 application imported network performance data from various sources, including Excel spreadsheets
and a Sysbase database. The application built complex graphical multi-sheet spreadsheets and used Excel templates, macros and
libraries in the process. |
| Remedy Report |
This is the Splash Screen of this shrink-wrap application
that provides analysis of Remedy data.
|
| The Remedy Report application imported standard data from
the Remedy ticket/job progress system, and performed detailed
analysis of how Departments and Team Members were perfoming to
their SLAs. |
| 3G Transmission Database |
Major enhancements to this application allowed the 3G Transmission team to automatically access other database sources seamlessly
|
| The 3G Transmission database was the main source of CMDB data for the 3G Transmission team to configure new and existing field equipment. This relied on both direct and indirect data sources
|
| Other applications |
- 2G & 3G Datafill CMDB
- 3G Consistency CMDB
- Smart-Asset Database CMDB
- Neomad CMDB
|
|
