Stipo Androvic: Java/ORACLE/Unix Developer

Email : aca0oz@r.postjobfree.com

Phone: +44-795*-***-*** / 079**-***-***

Post: Ritarikatu 3 as 17, HELSINKI 00170

Qualifications: B.Sc. in Mathematical Sciences, majoring in

Mathematics & Computing

[University of Adelaide 1990, 73% Grade Point Average]

Nationality: British and Australian citizen

Date of Birth: 18-Jan-1965

Languages: Fluent English, fluent Croatian

Recent Skills [2004-2010]: ORACLE, UNIX, shell scripting, PL/SQL, SQL*PLUS

[5 years]

ORACLE 10g/11g, ORACLE Forms & Reports, http, html, XML

[2 years+]

Java SE, Eclipse, Apache Tomcat, Struts, JSTL, Maven,

Hudson, perl [2 years]

J2EE, NetBeans, Servlets, JSPs, css, Swing, awt, gwt

[Google Web Toolkit] [1 year]

Other Skills [1989-2007]: IBM Mainframe, COBOL, JCL, DB2, SQL, MVS, CICS,

ASSEMBLER [17 years]

Work History 1985 - 2013

Aug 2011 - Present: Alaric Systems 5 Great Suffolk St, LONDON SE1 0NS

POSITION: Java/ORACLE/Unix Developer

ENVIRONMENT: Eclipse Java IDE, Java SE, Tomcat, Swing, Maven, Red Hat

LINUX, ORACLE 11g, SQLDeveloper,

SQLPLUS, sqlldr, source control using Subversion & CVS, Hudson

CI [continuous integration tool].

PROJECTS: Development, Configuration, Maintenance, Installation and

Support at customer sites of Alaric products [Authentic

Payments switch & Fractals Fraud-detection Engine]

DUTIES: 1. Agile TDD development in Java [v6, v7] and ORACLE PL/SQL,

chiefly on server-side, but including some

Swing, awt & gwt UI work.

2. Build, import and export full ORACLE 11g databases using

scripts to create tablespaces,

user accounts and schemas. Use of ORACLE imp/exp, datapump

and directory objects

3. Coding of shell scripts in MS .bat, and LINUX bash,

including scripts running under Hudson CI

4. Coding, config & testing of Java Swing, awt & gwt GUI

webapps running under Tomcat and Websphere

5. use of VISA VTS, Thales HSM, & Level4 ATM simulators for

high-volume end-to-end message testing

6. Mapping & configuration of http JettyManager, TCP/IP

listener & socket connections for ISO-8583, BASE24,

WebCollect, WebPay & TIETO messaging

7. Use of Java Digester, w3c.dom, JAX, JMS, WSDL Web Services,

XSD, XSLT, ActiveMQ, RabbitMQ &

ORACLE AQ, regular expressions

8. use of VMWare & Oracle VirtualBox virtualization

9. remote access via sftp, Filezilla, WinSCP, VPN,

putty/pageant SSH-authentication

Oct 2010 - July 2011: Bluefin Corporate Consulting 9 Aldgate High Street,

LONDON, EC3N 1AH

POSITION: ORACLE/LINUX/Java Developer

ENVIRONMENT: ORACLE 10g & 11g, LINUX, IntelliJIdea Java IDE, AllRound

Automation PL/SQL Developer, Spring,

iBATIS Object-Relational mapping, SQLPLUS, sqlldr, svn & git

source control

PROJECT: Development & Maintenance of the ORBIT Website

[www.orbitbenefits.com]

DUTIES: 1. Maintain & develop ORACLE Data Model, DDLs, PL/SQL

Packages, Procedures & Functions.

2. Implement new website functionality, create iBATIS SQL

Maps, use of IntelliJIdea with Spring MVC & Spring

WebFlow, coding of html pages as CLOBs

3. ETL Load/unload from on-site & remote servers using sqlldr,

ftp, ksh & .bat shell scripts & TALEND

4. batch creation of html, css, XML, XSLT, PDF documents and

CLOBs

Feb 2008 - Oct2010: KANTAR / TNS WorldPanel Westgate W5 1UA, London

POSITION: UNIX/ORACLE Developer, Analyst-Programmer

ENVIRONMENT: HPUX UNIX, ORACLE 10g, PL/SQL, SQLPLUS, PERL, ORACLE Forms &

Reports, SQLDeveloper, html, XML, UNIX shell scripting,

ORACLE Application Express [APEX], MicroFocus COBOL, PVCS

Source Control

PROJECTS: Development, Enhancement & Maintenance of systems to

collect, process & analyse market research data

DUTIES: 1. Agile development in: PL/SQL, SQLPLUS, ORACLE procedures,

functions & triggers, 10g

Forms & Reports, ksh & PERL shell scripts, MicroFocus COBOL programs

2. Use of ORACLE DDL to design, create & alter ORACLE schemas,

tables, views & indexes.

3. ORACLE DML/EXPLAIN/AUTOTRACE & optimizer hints for

performance tuning.

4. Automated real-time html email & SMS processing using

ORACLE utl_smtp & utl_http protocols.

5. Use of ftp, PERL, awk, vi, sed & subversion.

6. Creation, maintenance & performance tuning of high-volume

market research databases & reports.

7. Statistical analysis & weighting of shopping data with

detailed demographic breakdowns.

8. Real-Time telephone & TCP/IP polling of OPTICON, PALM &

CLICKER bar-code scanners.

9. http & ftp file transfer from external & internal servers.

10. Upgrade of ORACLE db, procedures, function, forms &

reports from versions 6i/8i to 10g.

11. ETL Operational Data to ORACLE Data Warehouse, and export

to PowerView Datamarts.

Aug 2007 - Jan 2008: Travel / Looking for work

Jan 2007 - Jul 2007: Abbey Bank / Banco Santander Shenley Wood House,

Chalkdell Drive, Milton Keynes MK5 6LA

POSITION: IBM MainFrame Contract Analyst-Programmer / System Tester

PROJECTS: Migrate Abbey Cards to Partenon Platform - Extract, Transform

& Load (ETL) from legacy files to DB2. Data Cleanse & Error

Reconciliation. Use of HSM Encryption/Decryption Routines to

created Pin-Mailer letters.

DUTIES: Design, Development, Analysis & Testing of COBOL, CICS &

DB2/UDB Programs.

Oct 2006 - Dec 2006: Paternity Leave

Apr 2005 - Sep 2006: Royal Bank of Scotland Eastgate House, 73 Leman St,

LONDON E1 8EY

POSITION: IBM MainFrame Contract Analyst-Programmer / System Tester /

Environment Build Co-ordinator

PROJECTS: Debit cards Development - Switch-to-Maestro Migration, Ulster

Bank Integration

DUTIES: Migration of Credit/Debit Cards from SWITCH to Maestro. ETL data

migration of Ulster Bank database to RBS. Interface to

Streamline Authorisation. DB2 Tuning. 24/7 Ops Support.

Jan 2005 - Mar 2005: Looking for work

Jul 2004 - Dec 2004: Churchill/DirectLine Insurance Hanover Place, 8

Ravensbourne Rd, BROMLEY, KENT BR1 1HP

POSITION: IBM MainFrame/UNIX Contract Systems Analyst, Tester & Ops

Support

PROJECT: Produce high-volume print output for Systems/UAT Testers on

the DirectLine Integration Project.

DUTIES: Document production using CA7. Manage VPS & UNIX print servers

thru Connect:Direct & IPW.

May 2004 - Jun 2004: Paternity Leave

Jun 2003 - May 2004: Lloyds TSB Group IT Credit Systems, St George's

House, 6 Eastcheap LONDON EC3M 1AE

POSITION: AIX/UNIX/ORACLE Contract Systems Analyst & Tester

ENVIRONMENT: ORACLE 8.1.7 on IBM AIX machine, HP Unix Server, HP Unix

11.0, Oracle Forms v6i, PL/SQL,

PCs [WinNT], TOAD, QueryMan, MS-Query, ERWIN data modeller,

Telnet, Mercury Test Director

PROJECTS: DB2 Corporate Credit Risk database migrated to ORACLE on AIX

& UNIX. implement BASEL2 requirements.

DUTIES: Create ORACLE test data with PL/SQL, MS-Query SQL, TOAD & QueryMan.

ETL from DB2 to ORACLE.

Aug 2002 - Feb 2003: STW Computing UK Ltd 128 Crawford St, LONDON W1

POSITION : IBM MainFrame/UNIX Contract Systems Analyst / Programmer

ENVIRONMENT: IBM Mainframe, PCs with MS Project98 & Mercury Test Tools,

DEC Alpha with UNIX, ORACLE, korn shell

DUTIES: Code COBOL/DB2 programs & UNIX shell scripts. DB2 Data modelling &

tuning. ETL ORACLE data into DB2 data warehouse.

Oct 2001 - May 2002: Natwest/RBS Mgmt of Dev & Test Environments,

Goodman's Fields, London E1 Ph 020*-***-****

POSITION: IBM MainFrame System Analysis & Testing - Mainframe Test Bed

Environment Build Co-ordinator

PROJECTS: Maintain Test Environments. ETL Data conversion from legacy

Natwest formats to RBS DB2 database.

Jun 2001 - Sep 2001: Travel / Looking for work

Oct 2000 - May 2001: Natwest/RBS Goodman's Fields, London E1

POSITION: IBM MainFrame Contract Systems Designer, Analyst & Tester

PROJECT: End-to-end Client/Server System Testing of the Natwest-to-

RBS Branch Teller VB GUI applications.

DUTIES: Design, code & test: CICS-COBOL, PL/1 & Assembler programs. ETL

Natwest data to RBS.

May 2000 - Aug 2000: Looking for next contract

Aug 1999 - Apr 2000: Southern Electric IT Centre Bartons Rd, Havant,

Hants. PO9 5JB Ph 084*-***-****

POSITION: IBM MainFrame Contract Systems Analyst, Tester & Programmer

PROJECT: System Test a new Billing, Payments & Letters System.

DUTIES: Produce high-volume Print runs. Test Royal Mail address codes,

barcodes & character recognition.

Feb 1999 - Apr 1999: Looking for next contract

Feb 1998 - Dec 1998: John Lewis Partnership 10 Clipstone St LONDON W1

POSITION: IBM MainFrame Contract Analyst/Programmer & System Tester

PROJECTS: 1. Conversion of a FORTRAN sales analysis/forecast program:

rewritten in COBOL & DB2.

2. Automatic Stock Replenishment System: Test & implement

online CSP screens & batch programs

DUTIES: Regression Test against existing FORTRAN program, using volume

data. System testing.

Nov 1997 - Jan 1998: Travel / Looking for next contract

Sep 1995 - Oct 1997: British Telecom Software Engineering Centre (LSEC),

207 Old St LONDON EC1V 9NR

POSITION: IBM MainFrame Contract Analyst/Programmer

PROJECT: Build a Financial Transaction Process to create & post journal

entries to Ledgers. Extract to DB2 DWH.

DUTIES: Design, Code & Test: (1) COBOL DB2 programs; (2) IE

[Information Expert] Reports; (3) JCL & DB2 utilities.

Apr 1995 - Jul 1995: ESSO UK Ltd IT Services Dept, Ermyn Way,

Leatherhead, Surrey KT22 8UX Ph 01372 - 233 - 900

POSITION: IBM MainFrame Contract Analyst/Programmer

PROJECT: High-volume EFTPOS data collected via ftp, then loaded/unloaded

to/from DB2 tables.

DUTIES: Design, Code & Test COBOL-II DB2 Batch programs, DB2 Utilities

& JCL. Prepare Unit & System Test Plans.

Feb 1995 - Mar 1995: Looking for next contract

May 1994 - Jan 1995: Norwich Union Business Systems Devt., St Stephens

House, Westlegate NORWICH NR1 3NS

POSITION: IBM MainFrame Contract Analyst/Programmer & Systems Tester

PROJECT: Direct Debit Collection System. Systems analysis, coding, testing

& user acceptance sign-off.

DUTIES: Analyse, Design, Code & Test COBOL batch & CICS online

programs using DB2, SQL & JCL.

Jan 1994 - Apr 1994: Looking for next contract / Travel

Feb 1993 - Dec 1993: Reuters Ltd Futures & Options Exchange, Commodity

Quay, LONDON E1 9UN

POSITION: IBM MainFrame Contract Analyst/Programmer

PROJECT: Develop an online & batch system controlling access to Reuters

products. Data conversion & reporting.

DUTIES: Code CICS /COBOL/DB2 programs. System Testing, data analysis &

enhancement of DB2 data models.

Nov 1992 - Feb 1993: British Telecom plc D & P Group, North Star House,

North Star Ave SWINDON SN2 1BS

POSITION: IBM MainFrame Contract Analyst/Programmer

PROJECT: Code a Purchase Order & Delivery System - stock management,

delivery monitoring, inventory control.

DUTIES: Design, code & test COBOL-II, PL/1, CICS online & batch

programs. System test Purchase Order System.

May 1992 - Oct 1992: Argos Distributors 289 Avebury Ave, MILTON KEYNES,

Bucks.

POSITION: IBM MainFrame Contract Analyst/Programmer

PROJECT: Stock replenishment system. Automated order estimation from sales

data. Code CICS online stock control.

DUTIES: Design, code & test: APS & COBOL CICS programs using DB2 & TSQ

processing. Coding of C-Lists & JCL.

Oct 1991 - Apr 1992: Gardner-Merchant 310 Broadway, Salford Quays,

Manchester

POSITION: IBM MainFrame Contract Analyst/Programmer

PROJECT: Migration tracking & change management system. Design & code

interfaces to General & Purchase ledgers.

DUTIES: Code & test CICS online programs, COBOL batch programs & JCL.

Liason with DBAs, Ops staff & analysts.

Dec 1989 - Aug 1991: Mutual Community Insurance, Gawler Place, Adelaide,

South Australia

POSITION: IBM MainFrame Graduate Programmer [with Stowe Computing

Australia]

PROJECTS: Insurance Claims Management; Customer Database; Bank Rec

interface; OLAS General Ledger Interface

DUTIES: Coding & testing of APS CICS online & batch COBOL programs &

reports; JCL; QMF reports from DB2.

Oct 1985 - May 1987: National Mutual Insurance, King William St,

Adelaide, South Australia

POSITION: Actuarial Calculations clerk [Life Insurance]

PROJECT: Assist actuaries in calculations for Life Insurance products

DUTIES: Calculate returns & surrender values of policies & annuities.

Previous Study

2011 Building Web Applications with Java, City University: J2EE,

NetBeans, MySql, Apache Tomcat, Struts, MVC,

FirestormDAO, GlassFish, JSTL, custom tag libraries

2010 Object Oriented Programming with Java, City University: Java

1.6, Swing, JDK, NetBeans, Eclipse, JCreator

1986 - 1989 Bachelor of Science, University of Adelaide, in Applied

Mathematics & Computer Science.

Subjects: Artificial Intelligence & knowledge-based systems;

Statistics; Probability; market behaviour; non-linear algebra;

Numerical Analysis; Mathematical Biology, Fluid Mechanics;

Hydrodynamics; Graphics & Animation; Data modelling

methodologies - SSADM [structured systems analysis & design] ;

NIAM [Nyquist Information Analysis Method], IEM [Information

Engineering Metholodogy],Jackson-Teece Structured Design;

UNIX, VAX/VMS, GUIs, Pascal, C, PL/1, BASIC, FORTRAN, PROLOG,

INGRES, LISP, INFOMAN statistical package.

1983 - 1984 Diploma in Performing Arts, South Australian College of

Advanced Education

1977 - 1981 Matriculation with Distinction [i.e. A-levels], Sacred

Heart College, Adelaide, South Australia

Contact this candidate