Northgate Address Data Cleanup and Rationalisation

• Working in a team established to resolve issues identified in the Northgate Housing Application.
• Production of Work Packages (Product Specifications) based on Northgate’s ‘Health Checks’ with my focus on addressing issues.
• Detailed analysis of Lambeth’s addressing issues in the Northgate Housing system.
• Production of Software Specifications for SQL and PL/SQL to enable the resolution of issues.

• Main areas of work:

• The cleansing of spurious comments from address lines. Many different comments had been inserted by users to identify various address types and flag working problems.
• Allocation and correction of the Local London Property Gazette (LLPG) UPRN codes to address lines.
• De-duplication of address lines requiring the development of string matching algorithms and rules to identify and resolve duplicates.
• Development of an interface between the Gazetteer and the Northgate system to update and insert ‘in borough addresses’.
• Production of SQL and PL/SQL scripts to identify and resolve the above issues.
• Production of ad-hoc Business Objects reports and Excel Spreadsheets for presentation of data to users to enable verification of results.
• Extensive user contact in the agreement, specification, development and testing of solutions.

Tools – ORACLE10g v 10.2, PL/SQL, SQL*PLUS , NORTHGATE HOUSING APPLICATION v5.13.1, BUSINESS OBJECTS v6.5.1, SQL TOOLS, LINUX RED HAT.

Reporting on Hedge Fund data

CDB (Corporate Database) - Development and Maintenance
• Small team handling GAM’s Business Objects reporting.
• Re-write of Contract Notes reports from universe based reports to procedure based reports to improve performance and control for intra day production.
• Development and maintenance of a wide range of reports, universes and PL/SQL packages used in the production of reports.
• Support of live Business Objects systems across all environments. Liaison with user community to approve all changes.
Siebel Development
• Design and build of new universe against the Siebel system to produce a suite of reports supporting the Private Client Department’s servicing initiative.
• Developed complex logic to control a user’s visibility of data in the reports. This functionality was seen as too difficult to build in the Siebel reporting tool.
• Worked closely with lead user on specification, development and testing of the developed products.
Version Control
• Reports, universes and PL/SQL released to London, New York, Hong Kong and Zurich.
• PVCS and Oracle Designer used for version control.

Tools – ORACLE10g v 10.2, PL/SQL, SQL*PLUS , BUSINESS OBJECTS v5.1.7 & v6.5.1, SQL TOOLS, ORACLE DESIGNER 2000 & 10, PVCS.

Archive of Rents, Benefits, Repairs and Migration of Service Charges to SX3 Housing System

Archive activities (Lola and Rams)
• Creation of new database instances and load of data. Analysis of legacy data, identify keys and referential integrity; Development DBA for all archive instances;
Migration activities (Iras)
• Copy of live service charge schema to new database instance; Mapping of service charge data to Northgate’s SX3 Housing System loaders; Design of transformation logic; Creation of new key values; De-duplication; Merging of data; Design and built of ETL code in PL/SQL; Support of service charge load of data up to user sign off; Build of ad-hoc reports for verification of data.
Business Objects
• Design and build of 4 Business Objects Universes and associated Reports on archived systems; Support of Housing Sections Business Objects SX3 Reports and Universes; Carried out upgrade of Housing IT Business Objects installation from v5.1.7 to v6.5.1
User Contact
• All work involved extensive contact with users in the Housing Section to develop an understanding of requirements and to produce specifications.

Tools – ORACLE9i v9.2.0, PL/SQL, SQL*PLUS, UNIX KORN SHELL, WINDOWS NT
, BUSINESS OBJECTS v5.1.7 & v6.5.1, T.O.A.D.

• Data warehouse for reporting on Image and Workflow and Concerns & Queries data.
• Build of feeds from DB2 and Oracle to the Warehouse using PL/SQL and shell scripts.
• Production of Business Objects reports.
• Support of system test, user acceptance, and performance test and implementation phases.

• Datastage jobs populate the data warehouse.
• Design and build of Business Objects Universes and Reports.
• March 2002 Amerada acquired by TXU. October 2002 Powegen acquire TXU/Amerada.
• Data migration. Large demand for ad-hoc reports using SQL*PLUS and Business Objects.

• Team working on (TCM) application managing the yearly allocation of bonuses and salary.
• Build feed from Global Compensation system to provide elections and deductions data to TCM.

• Work on Vista Ford Dealer Network’s Internet vehicle ordering system.
• Production of technical specifications from functional requirements.

• ‘This is London’ web site.
• Production of HTML pages to display news items and features for the ‘This is London’ site

• Mobill system is the hub for gathering data on services performed by London Electricity.
• Design and build of Oracle Forms 4.5, Report 2.5 and PL/SQL packages.

• Newspaper page tracking system.
• Time and Attendance system using the Oracle HR views.