Post Job Free
Sign in

Manager Sql Server

Location:
South Africa
Posted:
March 11, 2014

Contact this candidate

Resume:

IDENTITY DETAILS

SURNAME Koeries

FIRST NAME Neil

POSTAL ADDRESS 15 Populier Street

Bosmont

Johannesburg 2093

South Africa

CONTACT PHONE 083-****-***

IDENTITY NUMBER 591**********

CONTACT EMAIL ***********@*****.***

LANGUAGE English speak / read / write

Afrikaans speak / read / write

TECHNOLOGIES / TOOLS / PLATFORMS

LEVEL SKILL

1 Had appropriate training only.

2 Limited practical experience.

3 Solid practical experience.

4 Well versed, extensive experience.

5 Expert, extensive experience.

TYPE MONTHS LEVEL

OPERATING SYSTEM Red Hat Linux 7.1 8 3

SCO Unix 3 3

Windows XP Professional 12 3

Windows Server 2003 6 3

Enterprise Edition 6 3

Windows Server 2000 24 3

Windows 3.1, 95, 98, NT 3 2

Server 4 13 3

IBM VM ESA 2 3

IBM MVS ESA 45 3

IBM VSE ESA 24 3

IBM MVS SP (JES2) 27 3

MS-DOS 30 3

DME (ICL) 11 3

MCP (BURROUGHS)

TPE (ICL)

DEVELOPMENT TOOLS / PSDsoft Express 7.70 15 3

LANGUAGES Source Insight 3.5 15 3

MS HyperTerminal 5.2 12 2

Visual Basic 6.0 Enterprise 66 3

Edition 4 3

Natural for Unix 38 3

Natural I & II 12 2

Cobol 12 2

RM/Cobol-85 10 2

Fujitsu Cobol 4.0

DATABASES Microsoft SQL Server 2000 / 12 3

2005 12 3

Microsoft SQL Server Desktop 3 2

Engine 42 3

Oracle 9i 9 2

Adabas 41 3

Oracle 8i

MS Access

METHODOLOGY/CASE Adastrip and GMC 9 3

TOOLS JCL 36 3

CICS 2 2

Complete 7 3

TSO/ISPF 35 3

CMS 5 2

Predict 16 2

TECHNOLOGIES / TOOLS / PLATFORMS (continue)

SOFTWARE PACKAGES MS Office Professional Edition 32 3

2003, 2007 18 3

GroupWise 5 14 3

Lotus 123 1 2

Visio 4.0c for MS Windows 9 3

Microsoft Outlook 98 6 3

Q&A 24 3

MS Office 95 14 3

Turbo Cash

ACADEMIC QUALIFICATION

QUALIFICATION INSTITUTION YEAR

Standard 10 (Grade 12) Paterson High School 1979

Subjects:

Mathematics

English

Accountancy

Business Economics

Biology

Afrikaans

INDUSTRIAL QUALIFICATIONS

COURSE NAME INSTITUTION DATES

Maintaining a Microsoft SQL Bytes Technology Group 2008.9.26

2005

Database

Linux Fundamentals Incus Data (Pty) Ltd 2007.12.14

Querying Microsoft SQL Server CS Education Solutions 2006.9.13

2000 with Transact-SQL (Pty) Ltd

Microsoft Certified Solution Torque-IT Technical 2002.11.22

Developer (MCSD)

Development Software One Technikon of Southern 1995.4.18

Africa

Bookkeeping Norite Educational 1992.3.13

Systems

Lotus 123 Wynberg Business College 1991.11.29

The Basic Principles and Norwich Life (Pty) Ltd 1988.5.26

Practice of Life Insurance and

The Structure and Application

of Norwich Life Insurance

Plans and Benefits.

ADABAS Concepts and Facilities Norwich Life (Pty) Ltd 1987.11

NATURAL ONE Norwich Life (Pty) Ltd 1987.11

IBM MVS JCL Norwich Life (Pty) Ltd 1986

Network VTAM Norwich Life (Pty) Ltd 1986

IBM MVS SP (JES2) Norwich Life (Pty) Ltd 1986

COBOL Programming Intec College 1987.1.5

WORK EXPERIENCE

Company Name: Computron Software (Pty) Ltd, Zwartkop, Centurion,

Pretoria

Dates Employed: 2009.10.12 to Current

Capacity: Analyst programmer

Duties:

do Variance report run per period.

run, as requested by the client, Compensation Fund, the Section 85

Import process.

responsible for User registration, User access & Menu creation in

AXSOne.

create & modify reports using Epic.

modify & create reports utilising Crystal Reports 9.

stand in for Assessment run when required.

run the weekly PAMSS process, and do the Intimate Data update run.

prepare and verify the timesheets, do the CF billing.

do customization in VB6.

do the bank statement run load.

create reports using Excel.

modify the posting dates at month end.

produce daily REMEDY report.

do daily Cashiers run, i.e. process and post.

stand in for the Penalty run when required.

AXS-One first-line help desk support.

Company Name: UCS Software (Pty) Ltd, Braamfontein, Johannesburg

Dates Employed: 2007.7.17 to 2008.3.18

Capacity: junior Developer

Duties:

do hardware update report for production manager.

draft merch report based on FM MART & HOME CORP data.

draw-up daily log report spreadsheet.

Use RedHat linux to locate data.

resolve logs from HELPDESK on a daily basis, on financial applications,

as per service matrix.

follow-up on old logs as per service matrix.

checking stores for faulty hard drives & space issues on secondary hard

drives.

check central machines for space issues.

review program when errors occur.

send & receive data to and from stores.

do switching for relevant stores.

resolve program crashes ie FET, which are written to the XABRT.

WORK EXPERIENCE (continue)

Company Name: African Legend Technologies (Pty) Ltd, Sandton,

Johannesburg

Dates Employed: 2003.4.1 to 2006.8.31

Capacity: Analyst programmer

Duties:

engaged in Automated Fare Collection (AFC) project.

develop VISUAL BASIC 6 programs to update and fill tables in Microsoft

Access and MSDE.

set up PSD Sosft Express which is needed to load the operating system

onto the Circuitlink unit.

load latest operating system onto Sygade epoint unit including run time

applications coded in SAPPHIRE.

install Source Insight 3.5 that is utilised as a program editor and code

browser on C (embedded).

create database & tables in MS ACCESS and MSDE to store driver employee

information.

liaise with users when determining requirements.

develop training material and do user training.

review and test code including that of team member.

Company Name: African Legend Technologies (Pty) Ltd, Sandton,

Johannesburg

Dates Employed: 2001.3.1 to 2003.3.31

Capacity: Analyst programmer

Duties:

provide the client, Unemployment Insurance Fund (UIF) with development,

maintenance, testing and enhancements.

data extraction, using VISUAL BASIC 6, into an asci file from ORACLE and

Microsoft Access.

exposure to the following AXS-ONE (ERP) modules i.e. Accounts Payable,

Fixed Assets, Purchasing (PO) and Inventory.

develop and maintain VB6 code.

create and test new accounts in the GENERAL LEDGER module.

develop training material and do user training on the ERP system.

liaise and assist users with problem determination and problem solving.

WORK EXPERIENCE (continue)

Company Name: African Legend Technologies (Pty) Ltd, Sandown,

Johannesburg

Dates Employed: 2000.6.01 to 2001.2.28

Capacity: Analyst programmer

Duties:

provide the client, Government Employees Pension Fund (GEPF) with

development, testing, enhancements and analysis and implementation.

system and program testing on Outgoing funds (Finance), Incoming funds,

Special pensions and Military pensions and Civil pensions.

data extraction done utilizing JCL, ADASTRIP and GMC from ADABAS.

create HELP ROUTINE in program as well as applying program standards

including LABELS.

coding done in NATURAL ONE and NATURAL TWO accessing ADABAS.

create and use JCL to run and test batch work.

implement modified programs into the production environment.

create FUNCTIONS and add to appropriate TABLE.

liaise with users when determining requirements and do walkthrough.

Company Name: Brainware Consulting, Centurion, 0046

Dates Employed: 1999.9 to 1999.11.30

Capacity: PC Hardware & Software Technician

Duties:

engaged in PC year 2000 Environmental analysis and rectification.

Company Name: Imperial Car Rental (Pty) Ltd, Edenvale, 1610

Dates Employed: 1998.4.16 to 1998.7.31

Capacity: Programmer Analyst

Duties:

provided the client (Imperial) with enhancements, maintenance,

implementation and development on a contract basis.

system and program testing on a number of different applications.

involved in system design and data modelling.

Technology:

Natural I & II, Adabas

Natural for Unix, Oracle 8

WORK EXPERIENCE (continue)

Company Name: Edgars Group, Crown Mines, Johannesburg

Dates Employed: 1997.9.1 to 1997.12 & 1998.3.1 to 1998.04.15

Capacity: Programmer Analyst

Duties:

provide the client (Edgars) with maintenance and support with regard to

programming.

data extraction using additional JCL on the Credit Admin Management

System.

develop new programs according to specifications received.

ensure program is tested and error-free.

ensure success of implementation.

Technology:

Natural I & II

Adabas

Company Name: Central News Agency, Johannesburg

Dates Employed: 1996.09 to 1996.10

Capacity: Programmer Analyst

Duties:

enhancements on the Allocations and Inventory systems.

programming and testing on applications done in NATURAL TWO.

ensure success of implementations.

Technology:

Natural I

Adabas

WORK EXPERIENCE (continue)

Company Name: University of the Witwatersrand, Johannesburg

Dates Employed: 1995.08 to 1995.10

Capacity: Programmer

Duties:

programming and testing on applications accessing ADABAS.

ensure success of implementations.

modifications as a contractor on the Student Information and Record

System.

Technology:

Natural I

Natural II

Adabas

Company Name: Firestone SA (Pty) Ltd, Port Elizabeth

Dates Employed: 1994.09 to 1994.10

Capacity: Programmer

Duties:

engaged in enhancements and development work on the Debtors system.

Responsible for programming, testing and implementation.

Technology:

Natural II

Adabas

WORK EXPERIENCE (continue)

Firestone SA (Pty) Ltd, Port Elizabeth - Programmer (1994.09 to

1994.10)

engaged in enhancements and development work on the Debtors system.

responsible for programming, testing and implementation..

coding done in NATURAL TWO accessing ADABAS.

Maritame Motors (Pty) Ltd, Port Elizabeth - Warranty Claims clerk and

Assistant Cost clerk

(1994.3.1 to 1994.6.30)

within this motor vehicle dealership company I was responsible for all

motor vehicle claims.

assisting in costing as well as training staff at the other

dealerships.

Barlan Forms, Port Elizabeth - Lotus 1.2.3 Formatter (1993.09 to

1993.10)

creating spreadsheets for the Accounts Systems Manager on a contract

basis.

AR Mally Management and Financial Services, Johannesburg - Bookkeeper

(1991.05 to 1992.05)

debtors and creditors.

bank and various reconciliations.

journals, ledger and cashbook.

extracting a trial balance.

Norwich Life SA Ltd, Cape Town - Senior Computer Operator & Programmer

(1985.08 to 1987.10)

& (1987.11 to 1989.02)

performed enhancements based upon requested changes and development

work on the Agency, Real Estate, Underwriting, Reassurance, Values,

Investments, Change Control and Accounting systems.

program testing.

prepare program documentation.

coding done in NATURAL ONE and NATURAL TWO accessing ADABAS.

responsible for the activation of batch and security runs, on ICL and

HITACHI machines.

draw, load and return of magnetic tapes.

monitored operations on the mainframe and reporting faults.

log calls if system has down time.

monitor and execute system backups and ensure backup media is moved

off-site.

Atlantis Diesel Engines (Pty) Ltd, Atlantis - Acting Shift Leader

(1982.05 to 1984.10)

performed hand-overs to the next shift.

provide shift schedules to staff.

train operators on shift, running on machines B1900, B2570, A3.

support to the system programmers on COBOL.

ensure successful running of operations.

assist with recovery of data and disaster recovery.

printing and distribution of quality reports to users.

UPS testing performed.

log calls if system has down time.

WORK EXPERIENCE (continue)

Automotive Safety Glass (Pty) Ltd, Port Elizabeth - Senior Computer

Operator (1981.04 to 1982.02)

manage the shift environment running on a ICL1903 then ME29 machine.

monitor and ensure that all components are functional.

activate batch and security runs. draw load and return of magnetic

tapes.

balance financial systems.

train one operator on shift.

ensure that operating schedules are executed efficiently in accordance

with the standards.

print and distribute quality reports to the users.

mount and demount test disks onto drives when required.

report problems and malfunctions to the relevant support personnel for

resolution.

Camec (Pty) Ltd, Port Elizabeth - Computer Operator (1980.06 to

1981.03)

handling of computer equipment.

activation of batch and security runs.

responsible for the buying, selling, ordering and invoicing of parts.

dealing with telephonic client queries.

stock take on warehouse items.

CONTACT Reference

Fatima Blaauw 082-****-*** (Computron Software )

Brian Williams 083-****-*** (Edgars Group )

Buck Bauer 011 - 723 8000 (Imperial Car Rental )



Contact this candidate