COBOL programmer

Francesco Allegretti

Date of birth: **/**/**** Nationality: Italian Gender Male +39-351*******

*********.**********@*****.*** 40, Via Magenta, 70043, Monopoli, Italy 30/10/2017 – CURRENT

SYSTEM CONFIGURATOR – EXPLEO ITALIA SPA (EX SQS ITALIA SPA) SQL Server Management Studio

DB2I

Support in distributed testing environment

OTRS (Open-source Ticket Request System)

Public administration and defence; compulsory social security Via Colonnello Archimede Costadura n.2/c, 73100, Lecce, Italy 01/06/2013 – 31/05/2017

BUSINESS DEVELOPER – ALLEGRETTI FRANCESCO

I have prepared a business plan for starting an IT services business for obtaining a funding from the Puglia Region.

The lack of cooperation from the companies that should have supplied me with plants in accordance with the law and the negative evaluation

market analysis made me decide not to start the business. Information and communication Italy

06/11/2006 – 24/05/2010

ANALYST/PROGRAMMER COBOL/CICS/DB2 – RESIBAN SPA

Development and maintenance of COBOL / CICS / DB2 programs about management control. Financial and insurance activities 42, Strada degli Schiocchi, 41100, Modena, Italy 14/11/2005 – 19/05/2006

ANALYST/PROGRAMMER COBOL/CICS/DB2 – AGILEX SRL

Transparency project / ISVAP adaptation;

High level design;

Maintenance of PL/I /CICS/DB2 programs about insurance policy; Development and maintenance of PL/I DL/I COBOL DL/I programs about ledger. Financial and insurance activities 79, Via E. Menga, 73100, Lecce, Italy 09/03/2005 – 29/04/2005

ANALYST/PROGRAMMER COBOL/CICS/DB2 – SINTESI CONSULTING S.R.L. Maintenance of COBOL/DB2 programs about lost indemnity for toll refund management; Maintenance of COBOL/CICS/DB2 programs about tax refund. Financial and insurance activities 3/b, via G.B. Pontani, 06127, Perugia, Italy 01/04/2004 – 30/04/2004

ANALYST/PROGRAMMER – ELAN COMPUTING ITALY

COBOL CICS DB2 LU 6.2 program analysis on electronic practice, banking. Information and communication Parma, Italy

WORK EXPERIENCE

05/03/2001 – 15/03/2002

ANALYST PROGRAMMER COBOL/CICS/DB2 – WINTEC SPA

Development and maintenance of COBOL/DB2 programs about current account and deposit account exceeding management:

Development and maintenance of COBOL/DB2 programs about statement of account both in lire and euro currency. Financial and insurance activities via Uruguay, 35127, Padova, Italy 15/11/1999 – 31/10/2000

ANALYST PROGRAMMER COBOL/CICS/DB2 – S.S.D. SRL

Development and maintenance of COBOL/CICS/DB2 programs about University of Bologna treasury management; Development and maintenance of COBOL/DB2 programs about I.C.I. (Imposta Comunale sugli Immobili – Local Property Tax ) management;

Development and maintenance of COBOL/DB2 programs about the adjustment to antitrust law in consequence of Banca Sella in Unicredit merging.

Financial and insurance activities via Mazzini, 20036, Meda, Italy 01/03/1999 – 30/09/1999

ANALYST PROGRAMMER COBOL/CICS/DB2 – S.I.D.I. SRL

Monitoring of database input-output operations;

High and low level design;

Development and maintenance of COBOL/DB2 programs about credit management. Financial and insurance activities via Isimbardi, 20100, Milano, Italy 01/03/1997 – 15/05/1997

ANALYST PROGRAMMER COBOL TOOL BOX MICROFOCUS – PC – NETSIEL SPA Functional analysis about communal rates;

Development of COBOL/DB2 programs about attendance-registering. Public administration and defence; compulsory social security via Saverio Dioguardi, 70100, Bari, Italy 15/10/1984 – 31/12/1996

ANALYST PROGRAMMER COBOL/CICS/DL/I VSAM – COMUNE DI MONOPOLI Development and maintenance of COBOL/CICS/DL/I VSAM programs about registry, electoral, building concessions, rates and budget communal offices;

System management.

Public administration and defence; compulsory social security via Garibaldi 6, 70043, Monopoli, Italy 23/10/1980 – 28/02/1981

CONCEPT EMPLOYEE – ESATTORIA COMUNALE DI MONOPOLI

Tax collector - folder management

Financial and insurance activities via Umberto I, 70043, Monopoli, Italy 01/12/1979 – 28/02/1980

CONCEPT EMPLOYEE – COMUNE DI MONOPOLI

Family allowance file management

Human health and social work activities via Garibaldi, 6, 70043, Monopoli, Italy 15/02/2021 – 15/02/2021 – Italy

GENERAL DATA PROTECTION REGULATION (GDPR 2016/679) – Expleo Group Field(s) of study

Basic / broad general programmes

Other

26/03/2020 – 08/04/2020 – Italy

DATA VISUALIZATION – Dataninja school

Tabula

Excel

LibreOffice Calc

Google Sheets

Datawrapper

ArcGIS

Flourish

Field(s) of study

Computing

Post-secondary education (Vocational training)

20/03/2020 – 25/03/2020 – Italy

INTRODUCTION TO CYBERSECURITY – Accademia del Levante - Cisco Networking Academy Global implications of cyber threats

Way in which networks are vulnerable to attack

Impact of cyber-attacks on industries

Cisco's approach to threat detection and defense

Field(s) of study

Computing

Post-secondary education (Vocational training)

10/08/2019 – 19/08/2019 – Italy

ETL USING SSIS – UDEMY

SSIS installations

control and data flow tasks

variables, loops, fuzzy lookups

email tasks, web services

deployment tasks - logging, checkpoints

Field(s) of study

Computing

Post-secondary education (Vocational training)

EDUCATION AND TRAINING

28/03/2019 – 03/05/2019 – Italy

MICROSOFT SQL SERVER ADMINISTRATION PART 2 – UDEMY clustered index

non cluster index

composite index

SQL profiler for indexes

reorganize and rebuild indexes

SQL profiler

SQL profile with index tuning

SQL server side trace

database engine tuning advisor

statistic

activity monitor

SQL performance monitor

SQL performance monitoring hardware CPU

SQL performance monitoring hardware memory

SQL performance monitoring hardware disk

dynamic management views

block and locks

import export data

bulck copy program

partition

contained database

policy based management

linked servers

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/03/2019 – 27/03/2019 – Italy

MICROSOFT SQL SERVER ADMINISTRATION – UDEMY

SQL SERVER installation

SQL Server Management Studio

SQL Server System Databases

SQL Server Data and Log files

SQL Server recovery models

SQL Database creation

SQL Server backups

SQL Server restore

SQL Server maintenance plan

SQL Server agent

Authentication or mixed mode security

SQL Server roles

SQL Server permissions

Field(s) of study

Computing

Post-secondary education (Vocational training)

18/01/2019 – 29/01/2019 – Italy

T-SQL – UDEMY

stored procedures, If Else, While Loop, cursors, derived tables, temp tables, CTEs, sproc permissions, sproc parameters Field(s) of study

Computing

Post-secondary education (Vocational training)

01/12/2018 – 06/01/2019 – Italy

ANGULAR 6 – UDEMY

Angular 6

Field(s) of study

Computing

Post-secondary education (Vocational training)

19/11/2018 – 28/11/2018 – Italy

FLUTTER – Google Developers Group

Flutter

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/10/2018 – 24/10/2018 – www.w3schools.com, online, Italy JAVASCRIPT – w3schools

Javascript

Field(s) of study

Computing

Upper secondary education

01/08/2018 – 28/08/2018 – Italy

WEB APPLICATION PENETRATION TESTING V3 – eLearnSecurity Networking

Web Applications

Penetration Testing

C++

Python

Information Gathering

Footprinting and Scanning

Vulnerability Assestment

Web Attacks

Systems Attacks

Network Attacks

Field(s) of study

Computing

Post-secondary education (Vocational training)

30/10/2017 – 30/10/2017 – Italy

ITIL V3 – SQS Italia Spa

ITIL v3

Field(s) of study

Computing

Post-secondary education (Vocational training)

12/04/2016 – 28/04/2016 – Bari, Italy

ANDROID FOR BEGINNERS - STUDY JAMS – Google Developers Group Android Studio (XML + java)

Field(s) of study

Computing

Post-secondary education (Vocational training)

12/03/2012 – 29/05/2012 – 4, Via Orabona, Bari, Italy OBJECTIVE C – Cultural club of the University of Bari Objective C

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/02/2012 – 29/02/2012 – www.uninettunouniversity.net, Italy JAVA – UNINETTUNO

Java (remote course)

Field(s) of study

Computing

Post-secondary education (Vocational training)

27/04/2011 – 21/12/2011 – Via Giolitti, Monopoli, Italy IT ADMINISTRATOR – En.A.I.P.

Hardware,

operating systems,

LAN management,

Information Security

Field(s) of study

Computing

Post-secondary education (Vocational training)

16/02/2004 – 19/03/2004 – Trieste, Italy

AS/400 – C.S.I. S.r.l.

IBM OS/400

COBOL/400

WebSphere Host On Demand 2.07

Field(s) of study

Computing

Post-secondary education (Vocational training)

25/11/2002 – 17/06/2003 – Via Pepe, Milano, Italy

SAP/R3 - ABAP EXPERT – MULTIJOB NET CENTER scarl

ABAP/4 ( report, sapscript, batch input, module pool), SAP/R3 MM, PM, SD,

MS PROJECT,

technical english,

communication skills,

training course c/o GFI/OIS Spa - Milan

Field(s) of study

Computing

Post-secondary education (Vocational training)

04/03/2003 – 13/05/2003 – Via Pepe, Milano, Italy

XML – C.F.P.

XML

Field(s) of study

Computing

Post-secondary education (Vocational training)

24/10/2002 – 24/11/2002 – 1, Via Nazionale Toscana, San Lazzaro di Savena, Italy HTML, ASP – C.E.F.A.L.

HTML, ASP

Field(s) of study

Computing

Post-secondary education (Vocational training)

19/12/2001 – 30/06/2002 – 3, Via Bigari, Bologna, Italy WINDOWS NT 4.0 – E.C.A.P. S.c.a.r.l.

WINDOWS NT 4.0 Workstation

Windows NT 4.0 Server

Field(s) of study

Computing

Post-secondary education (Vocational training)

19/12/2001 – 06/03/2002 – 3, Via Bigari, Bologna, Italy LOCAL AREA NETWORK – E.C.A.P. S.c.a.r.l.

L.A.N.

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/01/1999 – 30/06/1999 – 64, Via Putignani, Bari, Italy VISUAL BASIC 5.0 – Centro Studi Levante

Visual Basic 5.0

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/01/1997 – 30/06/1997 – 64, Via Putignani, Bari, Italy AUTOCAD 13 – Centro Studi Levante

AUTOCAD 13

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/03/1996 – 30/03/1996 – Italy

C LANGUAGE – Centro Studi G. D'Annunzio Sas

C language

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/01/1993 – 30/06/1993 – 61, Via G. Laterza, Bari, Italy IT MANAGEMENT – E.N.A.P.A.I.C.A.

MS-DOS, CLIPPER

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/06/1991 – 30/06/1991 – 13/a, Via Dalmazia, Brindisi, Italy MS-DOS UNIX – ETA INFORM Srl

MS-DOS - UNIX

Field(s) of study

Computing

Post-secondary education (Vocational training)

07/01/1982 – 30/06/1982 – 24, Via Cap. Pirrelli, Monopoli, Italy COBOL PROGRAMMER – S.E.S.A.M. s.n.c.

COBOL language

Field(s) of study

Computing

Post-secondary education (Vocational training)

01/10/1972 – 30/06/1977 – Via Europa Libera, Monopoli, Italy SCHOOL-LEAVING CERTIFICATE – Liceo Scientifico Statale G. Galilei Mathematics, science, english, italian, latin, history, geography, philosophy. Field(s) of study

Life sciences

Upper secondary education

Mother tongue(s): ITALIAN

Other language(s):

UNDERSTANDING SPEAKING WRITING

Listening Reading Spoken production Spoken interaction ENGLISH B2 C1 B2 B2 C1

GERMAN B1 B2 B1 B1 B2

FRENCH B1 B2 B1 B1 B1

RUSSIAN A1 A1 A1 A1 A1

SPANISH B2 C1 B2 B2 B2

LATIN C1 C1 C1 B2 C1

Levels: A1 and A2: Basic user; B1 and B2: Independent user; C1 and C2: Proficient user

LANGUAGE SKILLS

Other skills

financial analysis, provide guidelines for content development, ICT debugging tools, organise business documents, Market entry planning, computer programming, analyse cultural trends, fill out forms, use presentation software, manage database, Develop information standards, process commissioned instructions, communicate with customers, analyse data about clients, identify legal requirements, apply business acumen, Support ICT system users, strive for company growth, file documents, market entry strategies, perform office routine activities, SQL, Manage changes in ICT system, apply ICT system usage policies, route correspondence to business departments, marketing principles, penetration testing tool, use spreadsheets software, identify new business opportunities, use analytics for commercial purposes, market research, database management systems, debug software, market analysis, create flowchart diagram, develop professional network, apply system organisational policies, sales strategies, COBOL, business analysis, SQL Server, Customer insight, identify customer requirements, strategic planning, plan software testing, DB2, apply grammar and spelling rules, address problems critically, use traditional toolbox tools, study sales levels of products, ensure compliance with legal requirements, legal requirements of ICT products OTHER SKILLS

Contact this candidate