Franco Ropelato Email & Phone Number

Rome, Italy

Project Manager for Data Quality: analysis and development of checks using Irion RTG.“Data Dictionary” project: design of the ER model and the physical structure of the db, functional analysis of the requirements of the web application for the editing, programmers supervision, application test, initial loading of data, assistance to the design of QlikSense based consultation tool.Project “migration from Axway XRDJ to Irion EDM” of the procedure of accounting movements’ generation: analysis and development of the extraction of algoritms from XRDJ and their parsing using regular expressions.For AM: analysis and development of software changes for maintenance and evolution (Irion EDM and IBI Focus).Reorganization of full documentation of the input sources of the data warehouse regarding the financial activities (Loans, Bonds, Securities, Repos, Derivatives, Collaterals, Options, Deposits).Market analysis of metadata management tools (Irion Edm, Oracle Enterprise Metadata Management, SAP BO Information Steward).Trainer of younger programmers.

Rome, Italy

Optimization of queries and reports (pension payments database: 2.5 million records monthly for the past 10 years; public employees contributions database: 3.5 million record monthly for the past 7 years).Design of the data warehouse (Relational Model and the Data Layer).Production of ETL software applications that automate import and check loading of external data into the data warehouse.Production of reports (functional analysis of the business requirements, design and optimization of queries for the Business Objects universes) on pension expense growth, on collected contributions to the pension plans, on welfare programs, on loans and mortgages delivered to public employees.

Pomezia, Italy

Assist in the organization and management of the Technological Assets'​ database, tracking more than 170,000 computers, storage, and network appliances in the company internet data centers'​ inventory;Produce and maintain PL/SQL scripts and queries on the Oracle database for the accounting department;Managed or participated in integration projects (all well completed) with the db of company applications, with the db of maintenance contracts, with the db of Archibus system of Data Centers'​ AutoCad maps, with the db of ECC Legato Networker backups'​ logs, with the db of backups'​ definitions, with the db of HP DDMI automatic discovery of servers' configurations, with the db of NetApp OnCommand Insight storage monitoring tools, with the db of Control Room management;Created and produced conversion scripts and provided data summary reports to management during the migration phase to the HP Peregrine-based asset management system;Produce software programs for data entry and on-site data quality verification;Produce catalogue of the models of the assets, structuring them by macro categories and organizing the research of the specification data on the websites of the manufacturers and maintenance service companies;Provide 2nd level assistance to end users;Supervised a team of five full-time employees, in Rome and Milan, who were responsible for registering and maintaining technical and accounting information, producing reports and doing data mining activity.

Castel Gandolfo, Italy

Analysis or requirements, projects design and planning, db design.Developed interactive database of management of conventions and congresses. The program offers complete delegate registration, arrivals check-in and check-out, logistical management of groups, translation services, shuttles to hotels, accommodations organization, billing, and payment registration. The back-end is a MySql database with a C# custom interface (using DevExpress), the front-end is another MySql database with a custom web PHP interface.I planned the two databases (with a two ways replication) and supervised the two programmers' teams.

Los Angeles, Ca

Software maintenance of custom CRM system for the travel agency

Rome, Italy

Developed interactive database (MS Access) of management of conventions for this non profit organization. The program offers complete delegate registration, arrivals check-in and check-out, logistical management of groups, translation services, shuttles to hotels, accommodations organization, billing, and payment registration.

Rome, Italy

Analyst Consultant for the Italian public employees' payroll system;Regular meetings with representatives of the Treasury Ministry for system review;Analysis of the maintenance and enhancement requests for the payroll system;Produced documentation of the software requirements specifications;Supervised the work of the programmers and provided final testing and certification of software.

Arezzo, Italy

Installed and administered the mixed Unix - Windows NT LAN in this manufacturing company in the field of security systems. Administrator for the Unix/Informix database for the accounting system.Implemented the change to the SAP R/3 based on NT/Oracle with analysis of the ERP and warehouse management functionalities.Responsible for installation and administration of PCs in the offices and production departments, and of the Sun workstations with Solaris operating system, and of the Silicon Graphics workstations in the labs.Organizational analysis of electro-mechanical production businesses. Provided technical review and reporting evaluations of IT market.Participated in data warehousing and data mining projects using SQL Server as database engine and Microsoft Office (Excel, Access) for business report generation, developing ad hoc VBA functions.

Arezzo Area, Italy

Teacher of Electronic

Incisa Valdarno, Italy

Planned and migrated to PDP11 DEC minicomputer.Written the accounting system in Pascal.Then planned and migrated again to PCs with Novell Netware LAN.Participated in the development of the digital interface between electronic calibration benches and controlling PCs.