Figura professionale: Analista programmatore Oracle PL-SQL

Nome Cognome: M. G. B.Età: 45
Cellulare/Telefono: Riservato!E-mail: Riservato!
CV Allegato: Riservato!Categoria CV: DBA/Oracle/SQL Server/Mysql
Sede preferita: Pavia, Milano

Accesso Full al database con 31.325 CV a partire da € 80,00  ABBONATI SUBITO


Sommario

Analista programmatore Oracle PL-SQL

Esperienze

WORK EXPERIENCE:  Over  20 years 

April 2017 – until today
• Employer name

CONSOFT SPA c/o  BMW Bank

• Sector

Bank – Finance
• Job type

Database architect, Analist programmer Oracle PL-SQL 
• Main responsibilities

IT consulting through Consoft SPA in BMW Bank in  banking and finance sector.
Responsible for the migration of production database from Oracle 11g to Oracle 12c.
Remake of the entire datawarehouse system on a new production machine.
Oracle PL / SQL package analysis / development activities and Oracle Warehouse Builder mapping design. 
Data integration from AS400 systems to Oracle.
Data quality and reporting production for data aggregation in decision-making support of the Risk Management office.

June 2013 – March 2017
• Employer name

HRM Informatica S.r.l. 
(c/o  Mediobanca  SPA / Accenture ) 
(c/o  Sorgenia  SPA / Accenture ) 
(c/o  ZURICH Italia SPA / Accenture )
(c/o  INTESASANPAOLO SPA ) 

• Sector

Bank – Insurance – Energy
• Job type

Analist programmer Oracle PL-SQL 

• Main responsibilities

 IT consulting through Accenture at Mediobanca SPA in  banking and finance sector.
Oracle PL / SQL and Package Oracle Data Integrator (ODI) package analysis / development activities following the migration to the new Murex 3 system.
Data integration between different systems and production of Flat flows.
Data quality on data and production of reports for aggregation of summary data.

IT consulting through Accenture in the energy sector at Sorgenia SPA.
Analysis and development of Oracle PL / SQL packages for the management of new ETL flows.
Development and maintenance of unix shells for the start of loading flows.
Performance analysis and tuning of Oracle production applications.
Data quality and rewriting of complex queries.
Realization of summary data reports, to be provided to billing systems.
Troubleshooting and data remediation activities.

IT consultancy through Accenture in Zurich Italia SPA in the insurance sector
at ZURICH Italia SPA.
Analysis and development of PL / SQL code for data remediation.
Analysis and development of PL / SQL code for the management of new evolutionary.
Performance analysis and tuning of Oracle production applications.
Data quality activity through complex oracle queries.

IT consulting at Intesa Sanpaolo Spa.
Analysis and development of new packages / stored procedures for the management of commercial campaigns of Intesa Sanpaolo.
Implementation of materialized views in FAST and COMPLETE mode for data preparation.
Performance analysis and tuning of production Oracle applications.
Rewriting of production PL / SQL code to improve execution times.
Technologies used: Oracle 11g rel. Database 2, oracle PL / SQL scripting, unix shell.

March 2012 – May 2013
• Employer name

Thera S.r.l. / NTT-Data  (c/o  ENI SPA )
• Sector

Energy
• Job type

Analist programmer Oracle PL-SQL 
• Main responsibilities

IT consulting at Eni Spa.
Performance analysis and tuning of Oracle development / test / production applications.
Performance and tuning of the sql and pl-sql code.
Analysis and development of new packages / stored procedures for statistical data management related to oil wells.
Development, optimization of sql code for reporting and creation of complex views for data preparation.
Technologies used: Oracle Database 11g rel. 2, oracle PLSQL scripting.

August 2011 a February 2012
• Employer name

Infodue S.r.l.  /  HP (c/o IntesaSampaolo  Milano)
• Sector

Finance – Bank
• Job type

Analist programmer Oracle PL-SQL / Datawarehouse
• Main responsibilities

IT consulting in the HP Sistemi di “Sintesi group” of the INFORMATION SYSTEMS DEPARTMENT of Intesa SanPaolo.
For the DSI Datawarehouse, analysis activities of new Mappings on Oracle Warehouse Builder and their development. Support to users and in general 360-degree Application Management on Oracle systems and their reporting.
Technologies used: Oracle database, PLSQL and SQL scripting for complex views, Korn shell unix development, Oracle Warehouse Builder.

July 2010 – July 2011
• Employer name

Sowre People S.A. (c/o KPMG  Milano)
• Sector

Finance – Audit
• Job type

Analist Programmer Oracle PL-SQL
• Main responsibilities

IT consultancy at the "SISTEMI INFORMATIVI & Datawarehouse" group Analysis and development of new PL / SQL
 Oracle procedures, on Oracle 10G Database for data management, to be prepared for reporting. Realization of
 queries and complex views for the generation of summary reports to be exposed to the various KPMG areas.
 Development of reports on IDE iReport Professional 3.7.1.1 and upload on Jasper Server production server. 

January – June 2010 
• Employer name

HRM Informatica (c/o CheBanca!  Milano)
• Sector

Bank
• Job type

Analist Programmer  Oracle PL-SQL
• Main responsibilities

IT consultancy at "SISTEMI DI SINTESI" (Business Intelligence CheBanca!), Analysis and development of new data
 flows to be loaded into the DWH, through ODI (Oracle Data Integrator), development of PL / SQL Oracle procedures, on Oracle 10G Database for the data management. 
Creation of queries and SQL scripts for the generation of summary reports to be exposed to the marketing group. 

January – December 2009
• Employer name

DIVIS srl 
• Sector

 Financial/Industrial  
• Job type

Analist Programmer  Oracle PL-SQL
• Main responsibilities

Development of Oracle PL / SQL procedures for data crypting and monitoring of instances remotely. 
Spot consulting with Oracle technology customers. 

February 2008 – January 2009
• Employer name

TEAM4 srl (c/o ENI SpA)
• Sector

 Chemical/Industrial
• Job type

Analist Programmer  Oracle PL-SQL
• Main responsibilities

For ENI Servizi, technical support in the ENI backend group. 
Development and maintenance of PL / SQL procedures for data processing. 
Reporting and administration of Oracle databases. 
Creation of a unix shell for processing and generation of flat files. Office automations routine. 

October 2006 – January 2008
• Employer name

TEAM4 srl (c/o REPLY Milano /  Boehringer Ingelheim)
• Sector

Farmaceutical sector(Ottobre 2006 a Maggio 2007) – Banking (Giugno – Dicembre 2007 ) 
• Job type

Analista Programmatore/DBA Oracle
• Main responsibilities

For Boehringer Ingelheim Realization of a custom DATAWAREHOUSE for the processing of the data of the scientific informants of the drug, for decision support. 
Implementation of processes for ETL activities with Oracle PL / SQL. 
Maintenance of Oracle databases for development, user creation, grants management, space sizing, code tuning and performance optimization. Scheduling of jobs and their realization. 
Development activity by merger of Gruppo Intesa – Sanpaolo databases (IMI-CABOTO). 
Implementation of Stored Procedures for Mapping between databases, reporting, data remediation. 

January – September 2006
• Employer name

TECHNE srl  (c/o RAS Milano)
• Sector

Insurance / Financial
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

Application support in the RAS finance management backend group. 
Evolutionary maintenance of the diagrams and development of PL / SQL Oracle code for data processing. Collaboration in the creation of a financial data warehouse. 
Analysis and implementation of processes for ETL activities with Oracle WareHouse Builder. 

January – December 2005
• Employer name

TECHNOSPHERA srl  (c/o SKY tv)
• Sector

Digital television
• Job type

Analist programmer Oracle PL-SQL – DBA Oracle
• Main responsibilities

Application support in the Business Intelligence backend group. 
Maintenance and development of PL / SQL Oracle code. 
Nighttime search activity on data warehouse loading systems. 
Management of Oracle development instances and schema maintenance. 
Backups and management of SQL Server development databases. 
Analysis and implementation of Job with DataIntegrator for ETL activities. 
Implementation of new TSQL procedures for data processing. 

May – Dicember 2004
• Employer name

HRM Informatica  ( c/o  BANCAINTESA  e ETNOTEAM )
• Sector

Banking and  Industrial
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

Collaboration in a data integration project between different systems, through Oracle Interconnect and PL / SQL procedures. 
Development and customization of PL / SQL Oracle code, application support. Shell unix for managing data loading flows on data warehouse. 

September 2002 – April 2004
• Employer name

HRM Informatica (c/o VODAFONE Milano)
• Sector

Telecommunications
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

At ScriptTeam group, development of SQL scripts – PL / SQL Oracle for maintenance-management, reports, 
data reclamation, on Oracle DB 8.1.7 – 9.x. 

March – August 2002
• Employer name

HRM Informatica
• Sector

IT and Consulting Sector
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

Collaboration in the design and implementation of an Oracle DB for a Software House that manages provincial databases.
Administration of a database, based on SQLServer2000.

September 2001 – April 2002
• Employer name

HRM Informatica  (c/o Lombardia Informatica Milano)
• Sector

Informatics and Healthcare
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

Analysis and development of PL / SQL code for the ASLs of the region. 
Maintenance of databases and data warehousing on Oracle database 8.1.7. 

November 2000  – 30 July 2001
• Employer name

HRM Informatica  (Gruppo Intesa-BCI  c.o. CABOTO Holding Sim Milano)
• Sector

Banking
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

PL / SQL programming (for Oracle 8.0.5 version) and SQL Server 7.0 database management. development and maintenance of C shell code on Unix, customization of programs written in Visual Basic 6.0. 

September – October 2000
• Employer name

HRM Informatica  (c.o. Mizar Informatica Sesto S.G.)
• Sector

Management computer science
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

PL / SQL programming stage, installation, development and verticalization of proprietary packages.

February – July 2000
• Employer name

HRM Informatica  
• Sector

Informatics
• Job type

Analist programmer Oracle PL-SQL
• Main responsibilities

Start of collaboration with IT consulting company HRM Informatica.
Theoretical-practical programming course in Oracle PL / SQL, Oracle Developer 6.0 (Forms and Reports).

February – Dicember 1999
• Employer name

Punto EXE 
• Sector

Informatics
• Job type

C Programmer
• Main responsibilities

Programming stage c.o. software house in C language, assistance as HW / SW technician, verticalization of packages.

January – December 1998
• Employer name

Laboratorio di Progettazione 
• Sector

Informatics
• Job type

Tecnician HW  /  SW
• Main responsibilities

Support work as a software hardware technician.

16 October 2006
• Name of educational or training institution

Oracle,  c/o  Sesto S.Giovanni MI.
• Qualification achieved  

Certification DBA – Oracle Certified Associate  (O.C.A.)
•  Main subjects of the study

Certification exam 1Z0-042 Oracle 10g: Administration I – OCA

European Computer Driving License ECDL. Information technology and Office suite. 

Oracle
• Qualification achieved 

OCA
• Main subjects of the study

Certification exam Oracle 9i SQL exam 1Z0-007  
• Level, vote in the national classification 
(if applicable)
Success

Istituto Tecnico Industriale Statale G. Marconi (CT)
• Qualification achieved 

Perito Informatico
• Main subjects of the study
49/60

INGLESE
Good

Relational skills and competences
Living and working with other people, in a multicultural environment, occupying places where communication is important and in situations where it is essential to work in a team (eg culture and sport), etc.

Technical skills and competences With computers, specific kinds of equipment, machinery, etc. 

OPERATING SYSTEM:        
                                     Unix (Sun Solaris ),
                                  Linux Redhat, CentOs, Fedora, Ubuntu, OpenSUSE 
                                  Dos, Windows 10
              

programming languages:     
                                                          PL/ SQL,  Sql,  
                                                     TSQL
                                                     cms JOOMLA!
                                                     HTML

Web Server: Apache HTTP
                
data base:  Oracle  (from version 7.3  to  12c  release 2),     
                  SqlServer (from  ver. 7   to   2000)
                  MySQL  on   LAMP/XAMPP  platform

REPORTING TOOLS: Jaspersoft iReport Professional 3.7.1.1

ETL TOOLS: Oracle Data Integrator ( ODI ) , 
                          Oracle Warehouse Builder (OWB)

graphic tools: Adobe Photoshop, ADOBE LIGHTROOM

other:   XML (Metadata Comprension), HTML
 

71 total views, 1 today