TECHNICAL EXPERIENCE

• Infrastructure design, disaster recovery planning, environment configuration and release management
• Database and Data Flow design, Entity Relationship Modeling, Database re-engineering
• Managerial responsibilities including line management, resource planning and budgetary management
• SQL Server 7, 2000 and 2005 Administration and performance tuning of Transact SQL
• SQL Server Analysis, SQL Server Reporting, Data Transformation and SQL Server Integration Services
• Development using Visual Basic versions 3 through 6 , Design using System Architect and Erwin
• Integration with 3rd Party systems including CODA, COGNOS, FMIS, Framework
• I have received formal training in Systems Analysis and Design, Team Leadership, Mentoring and Project Management.

EMPLOYMENT

Confidential

Business Data Analyst

• Data Interrogation and management of CRM system through SSIS, DTS and SSRS SQL 2000 and 2005 clustered servers
• Dashboard view creation using Dynistics Active Dashboards software
• Internet and Intranet ASP .NET / java customer and employee survey development

Confidential

BAE Systems, Sunbury-on-Thames, Middlesex

• Contract Resource Database Architect
• Support of multi-site merge replicated database infrastructure
• Support of database for multi-site, multi-user application on an SC project
• Responsible for best practices implementation and change management on SQL Server 2005
• Sole on-site DBA

Confidential

Consultant Database Architect

Provide remote advice and guidance on Database Design for a variety of clients

Confidential

Contract Resource Database Architect

• Design and implementation of multi-site merge replicated database infrastructure
• Design of database for multi-site, multi-user application on an SC project
• Responsible for design and implementation on SQL Server 2005
• Sole on-site DBA

Confidential

Contract Resource SQL 2000 DBA and Developer

• CRM, Business Intelligence and MIS system design and development.
• Multi-channel Commissions system design and project management.
• Lead SQL DBA - Terabyte database administration focused on data design and database optimization.
• Cross-platform design role SQL Server 2000 / Oracle 8 / 9i using Popkin TeleLogic System Architect
• Infrastructure design, implementation and management.
• COGNOS Planning suite administration
• Key achievements within this role include:
• Design and implementation of billion-row MIS / BI data model and multi-channel Commissions system.
• Stabilization of existing large >1TB database, including performance enhancements.
• Migration of billing data from Oracle to SQL Server

Confidential

Contract Resource Developer and SQL Server 2000 DBA

• Design and shaping of Half-Hourly metered Electricity supply and billing system.
• VB6 Developer and SQL 2000 DBA for fledgling utilities system.
• Key achievements within this role include:
• Single-handed design of Half-Hourly metered Electricity supply and billing system.

Confidential

Design Authority Oxford Systems

• Design Authority comprising both Service Delivery and Solutions Delivery viewpoints System Architect / Erwin .
• Design and shaping phases of change - delivery and support of the solution for the business.
• High-level design, cost and time estimates for pre- to post-implementation requirements.
• Infrastructure to application-level design.
• Integration of bespoke billing engine with third party financial application CODA
• ITIL best practice methodologies encouraged and rigorously implemented.
• Key achievements within this role include:
• Application specific scalability re-designs overcoming legacy database structure issues
• End-to-end plans for system consolidation and stability to enable strategic migration
• Support Manager
• Responsibility for IS infrastructure for the Oxford site - Network infrastructure, telephony, workstations, servers, applications and staff.
• Strong Business focus to ensure Service Delivery is not compromised due to the pound and reputation cost unplanned down-time results in.
• Line manager for 10 direct technical reports, from First to Third Line support, responsible for recruitment, career progression, training, objectives, appraisals, performance and bonus reviews.
• Facilitation of communication between local and remote technical staff.
• Management of and integration with third party relationships and products, including CODA Financials
• Ownership of all major IS decisions impacting on the Oxford site
• Key Achievements within this role include:
• De-coupling from Enron was planned, coordinated and successfully implemented ahead of schedule and to budget.
• Creation of a diverse, multi-functional support team from scratch. Selection of all team members and introduction of outsourced 3rd party Help Desk function.
• Key contact for Development staff, from guiding technical design to assisting with recruitment
• Creation of snapshot and transactional replicated reporting environment

Confidential

Lead VB Developer

• Key point of contact for the Electricity modules of the bespoke systems
• Holder of key business knowledge
• Key achievements within this role include:
• Creation and deployment of Accredited Electricity supply system
• Supported business growth from 25 staff and 10k customers to 270 staff and 150k customers

Confidential

Varying roles including Analyst, Tester and Developer

• Customer Services User-Acceptance tester and business analyst
• Analyst / Developer role within the Office Systems Development, using VB3 / Access to facilitate small systems development
• Migrated into IT department developing bespoke applications using Natural / ADABAS
• HR Developer, with access to privileged payroll information
• Key achievements within this role include:
• Testing, documentation and training of new bespoke product management software
• Successful migration of in-house payroll from VB3 / Access 2 to VB5 / Access 97.