Enthusiastic, dynamic and determined SQL and Database specialist.

Alexander Lennon

Unit ** Jargarra Villas / **** Pacific Highway, Tanah Merah, QLD 4128

E-Mail: ****.******@*****.*** .Tel: (+61) / (0-452******

Personal Profile

Enthusiastic, dynamic and determined SQL and Database specialist with over

8 years experience working on various platforms. Experience as follows; 11g

Oracle including theoretical administration knowledge and PLSQL, INGRES

Database administration, UNIX / Linux administration, Microsoft SQL Server

2005 including theoretical administration knowledge. Very experienced at

co-operating and engaging with other people in various roles and at all

levels, highly successful in team-orientated environments. Has the ability

to remain calm in stressful and difficult situations, with good personal

organization skills helping to avoid or alleviate those problems in the

first place. Committed to professional self-development and dedicated to

sharing knowledge as well as experiences with others.

Specific Database Skills

> 8 years experience of standard Structured Query Language (SQL), and

Query By Example (QBE).

> Skilled and experienced certified INGRES DBA.

> Extensive knowledge of Database Design, Entity Relationship Models,

Normalization, Transaction management, Data Migration, Data

Validation, System Testing.

> Substantial knowledge of T-SQL and SQL Server 2005. Undertaken self

study to become a Microsoft Certified Technology Specialist in

Microsoft SQL Server 2005.

> Experience in ASP.NET and VB.Net for linking databases to the web.

> Working knowledge of MySQL.

> Solid experience working in Oracle 11g including SQL writing and

functional testing. Undertaken self study to become an Oracle

Certified Expert in Oracle 11g Database SQL and also self study to

become an Oracle Certified Associate in Oracle Database 11g

Administration.

> Data analytical skills from both a development and business

perspective, gained extracting data and being involved in data

validation and migration projects.

I.T Skills

> 8 years experience using Microsoft Windows Operating Systems.

> 6 years experience with SCO UNIX and Linux Operating systems.

> Extensive knowledge of Korn / C-Shell scripting, development, testing.

> Working knowledge of VB script programming.

> Comprehensive knowledge of the whole Microsoft Office Suite and Ms

Exchange.

> Skilled and experienced in writing Business Requirement Specifications

(BRS) as well as Functional Specifications for managers and

stakeholders to sign off.

> Experience managing projects including dealing with; internal staff,

third party suppliers / vendors, offshore teams, client management

teams and developers.

> Extensive knowledge of process flow and documenting information, using

current functionality verses expected functionality (as-is & to-be

methodology).

> Knowledge of working with and producing effective process and dataflow

maps.

> Finance knowledge gained working with the accounts department of an

insurance company. This includes; running month end processes, cheque

runs, credit and debit runs, reconciling monies using bordereaux, and

the development of new credit card functionality not previously

implemented within the business model.

> Analysis, problem solving and creative thinking developed at

university and further developed in roles whilst creating

specifications / solutions.

> Planning and Time management skills progressed in my Systems Support

Analyst role, where scheduling tasks / prioritization take place on a

daily basis due to the customer driven orientation of the work.

I.T Career

Senior SQL Testing Analyst

03/2012 - 08/2012 The Royal Automobile Club of Queensland (RACQ),

Headquarters located in Eight Mile Plains.

(Queensland's largest mutual association with around 5000+

employees, contracted to work as part of the IBM led PG100

project).

Skills developed:

. Oracle skills; SQL test script creation, indexing, materialized view

creation.

. Testing skills developed; using source minus target, target minus

source analysis, functional testing, test plan creation, fully

integrated end-to-end system testing, co-ordination and lead of a

testing team of six, COGNOS report testing.

. SQL specific; AD HOC testing, raising and testing defects, data

validation and counts.

. Worked with Relational Quality Manager (RQM) which is a defect and

test case management piece of software used by IBM to track all

project based testing.

. Exposure to project management, environment management, requirement

gathering.

. Experience of contracting abroad and working on a very large scale

project involving leasing and working closely with IBM employees as

well as other software vendors.

. Providing tasks and guidance for the global development team, the IBM

team based in India who supported our team by developing test scripts.

. XML knowledge increased by testing a message store and batch

processing segment.

Systems Support Analyst

06/2005 - 04/2011 Cassidy Davis Insurance Services Ltd, Haywards

Heath.

(A subsidiary of Jubilee Managing Agency Ltd a large

multinational Lloyds Insurer with 150+ employees).

Skills developed:

. Ingres DBA skills; user setup, security, indexing, table partitioning,

disaster recovery, performance, daily monitoring and maintenance.

. Administered a UNIX RS6000 based backend operating system.

. Assisted with Ingres 2006, UNIX 2.3 and SUN upgrades.

. SQL used for; AD HOC reports, triangulations, data validation, data

loads, queries and investigations, data migration and analysis, and

record manipulation.

. Administered the Symposium phone system until it was replaced.

. Exposure to SQL Server 2005 through assisting a third party supplier

with a complex upgrade and migration project lifecycle which

ultimately replaced Reflect.

. Maintaining a business critical 100 user system called Reflect,

encompassing UNIX and graphical Windows based user interfaces.

. Specification, development, testing and maintenance of key flat file

automated loads which load to underlying Reflect tables, all written

in Korn Shell as scheduled jobs.

. Maintained the DocGen document generator which hangs off Reflect.

. Provided support for RTM a flat file system used in another branch.

. Working closely third party suppliers; Ellion (Web applications),

Eurobase (Reflect, Doc Gen), IBM (RS6000 hardware support), Midas (Ms

Windows) and CGI (RTM).

. Liaised with clients in requirement gathering including; Royal & Sun

Alliance, LTSB, C&G, Coverpoint, British Insurance, Central Trust and

Business and Domestic.

. Carried out daily accounts based processes, as well as month end

processing cycles, reconciliation of monies, and the specification and

development of new credit card functionality.

. Assisted in the costing and vendor choice for a replacement

companywide system, and aided with the data migration, reconciliation

and testing requirements involving the whole product lifecycle.

Database Analyst

06/2004 - 06/2005 Alchemetrics Ltd.

(A medium sized data-warehousing company with approximately

40 people. Specializing in data cleansing and storing

client's data in a postcode orientated method for direct

marketing purposes).

Skills developed:

. SCO UNIX and Linux familiarity along with C-Shell shell programming.

. SQL for outputting orders, data selection, data loads and validation.

. Some exposure to MySQL on secondary accounts.

. Emap management, Nikon / Telegraph account assistance and cover.

. Scheduling in tasks to make sure everything completed in accordance

with the SLA (Standard License Agreement) agreed with the client.

. Completion of chargeable AD-HOC tasks, day-to-day running, data loads

and maintenance of the Informa (In house) flat file database.

. Client query handling skills and project specification, working

closely with the Client Services department.

Database and Web Developer

04/2004 - 06/2004 Contracting work for PI Marketing Ltd.

(A very small company with only 10 employees, providing

teaching resources for courses and private study colleges).

Skills developed:

. Experience with SQL server 2003, and VB.NET to create a section of the

PI website which is connected to the database using data adaptors.

. Project management skills improved due to analysis & planning carried

out in order to build a Website with the correct functionality /

usability.

Education

BSc (Hons) Computer Science, Class 2:2.

University of Westminster, Harrow Campus, London, 09/2000 - 06/2003

Main studies: Databases, E-Commerce, Programming, Database Design,

Normalization, ER Models and SQL.

A Levels

Collyers College of Richard Collyer, 09/1997 - 06/2000

A level: Geography C, Physics D, Math's Mechanics D.

AS level: Information Technology B.

RSA (CLAIT) Stage I Pass, RSA (IBT) Stage II Pass.

Achievements and Hobbies

> Good spoken German.

> Full UK Driving License, without penalties.

> Fire Warden training undertaken for Cassidy Davis Insurance Services

Ltd still valid.

> Swimming, travelling, gym fitness, playing badminton, socializing with

friends, hiking.

> Travelling is my biggest passion; I travelled as a backpacker for four

months in South America (Peru, Chile, Argentina and Brazil) in May

2011 - August 2011 following my redundancy. I have also spent six

months between December 2011 - November 2012 travelling as a

backpacker in Australia (covering all states and territories) and six

weeks starting January 2013 travelling in New Zealand (both islands),

prior to settling down with my partner and buying a house together in

Queensland.

[pic]

[pic]

[pic]

[pic]

Contact this candidate