Franco Ropelato partly available

Franco Ropelato

Information Technology and Services - Consultant and Contractor

partly available
Profileimage by Franco Ropelato Information Technology and Services - Consultant and Contractor from MarinoRome
  • 00047 Marino (Rome) Freelancer in
  • Graduation: master in electronic and information technology engineering
  • Hourly-/Daily rates:
  • Languages: German (Elementary) | English (Full Professional) | Italian (Native or Bilingual)
  • Last update: 17.11.2019
Profileimage by Franco Ropelato Information Technology and Services - Consultant and Contractor from MarinoRome
Oracle, Oracle PL/SQL Development, Query Optimization, SQL Tuning, HP Openview, Management Accounting, IT Asset Management, IT Hardware Models, Data Quality, Pension Systems, Italian State structure, Public Sector, Amortization Schedules, Linux, Virtualization, MySQL, MySQL replication, Apache, Microsoft SQL Server, Software Development, Disaster Recovery, Business Objects, JavaScript, HTML, CSS, Joomla, WordPress, PHP, Business Intelligence, SQL, Database, PL/SQL, Sviluppo di software, Server Microsoft SQL, book self publishing, DPA Data Protection Advisor, HP DDMI, C, Delphi, VBScript, VBA, Microsoft Access, Microsoft Excel, QlikSense, Irion EDM, Axway XRDJ, IBI WebFocus
Dexia Crediop Bank, Rome (from Dec 2015)
  • Project Manager for the Data Quality.
  • Reorganization of full documentation of the input sources or 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).
  • Analysis and development of a solution based on Irion Edm for the Data Quality project.
  • Application Management in debugging and new developments using IBI WebFocus, migrating from Axway XRDJ Accounting Integration Suite.
  • Trainer of a younger programmer.
INPS - Osservatorio Economico Finanziario, Rome (Dec 2004 – Oct 2015)
  • 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.
Telecom Italia IT, Rome (Mar 2001 – Jun 2015)
  • 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 cost accounting department.
  • Manage or participate in several integration projects, all well completed, with the databases of the company's other applications: with the db of maintenance contracts, with the db of Archibus system of Data Centers' AutoCad maps, with the VMware systems of farms of virtualizers, with the db of EMC Legato Networker backup definitions, with the db of EMC Data Protection Advisor backup logs, 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 tools, with the db of the software licenses, and with the db of the colocation customers' physical and virtual assets.
  • Create optimized Oracle SQL views and PL/SQL packages for feeding the ETL process to the Oracle Warehouse OWB.
  • Produce 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.
  • Supervise a team of five full-time employees, in Rome and Milan, for registering and maintaining technical and accounting information.
Centro Mariapoli Internazionale, Castel Gandolfo, Rome (Oct 2010 – Apr 2014)
  • Analysis of the business requirements and design of the Relational Model and of the Data Layer.
  • Planning and implementation of front end and back end MySql databases with data replication.
  • Supervision of the work of the C# programmers.
Ministry of the Treasury, Italian Govt., Rome (Feb 2002 – Dec 2002)
  • 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.
ICCRS (International Catholic Charismatic Renewal Services), Rome (Jan 2004 – Nov 2004)
  • Developed interactive database (MS Access) of management of conventions and congresses 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.
See America Travel, Inc., Los Angeles, CA (Apr 2000 – Mar 2001)
  • Software maintenance of custom CRM system for the travel agency.
CEIA Spa (Costruzioni Elettroniche Industriali Automatismi), Arezzo, Tuscany (May 1994 – May 1998)
  • 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.
Fulltime or partime
I am a Computer and Information Systems Consultant with extensive professional experience as a Programmer Analyst, Business Intelligence Analyst and Database Specialist.

As a Programmer Analyst, I worked through all phases of the cycle of software development. In my career I wrote various software in the domains of IT Asset Management, Accounting, Warehouse systems, Cost Accounting, Italian public sector Pension system, Italian State structure, Loan and Mortgage plans, Payroll, ERP and CRM for a wide range of businesses including banking, government service, telecommunication, electro-mechanical production, tourism, and non profit services.
Keywords: C, Borland Delphi, Javascript, Microsoft Visual Studio VBasic and C#, SQL, PL/SQL, Microsoft ADO APIs, VBA, VBScript, JScript, HTML, CSS.
I'm expert in analysis of software requirements and design specifications for business operations. I do data and process modelling with UML and use case requirements engineering. I have long experience with Database Modeling, in attribute collection and in normalization. I have experience in continuous integration, test automation, quality control, and assurance. I do both architectural design, using the entity-relationships model, and physical layer design. I worked on extensive systems' integration projects and I have experience using Test-driven and Agile methodologies (pair programming).
I have long experience in production of technical and user documentation.
I worked with MS Windows, Solaris, Unix and various Linux platforms.
I'm expert in Unix shell scripts languages (ksh, bash) and with tools such as vi and awk, and I have full familiarity with Internet/intranet architecture, IP family protocols, routing, proxies, and firewalls.
I have experience in security issues (SQL injection, usage of MBSA and nmap), in setup of backup procedures, in server and desktop virtualization, and in moving from Windows to Linux (Debian and Ubuntu).

As a Business Intelligence Analyst and Database Specialist (Oracle and MySQL), I have long experience in data analysis and crunching, from just cleaning Excel files (identifying duplicates, combining and/or splitting data to follow company standards, spot-checking work for accuracy, removing unwanted characters and formats), up to designing and implementing data warehouses for building historical trends and finding correlations.
I have full knowledge about design and development of databases, and long experience in database applications.
I'm expert in optimization and tuning of queries in large scale databases and in advanced Oracle PL/SQL packages programming as stored procedures and triggers. I have experience with high-volume bulk data processing in PL/SQL: for INPS, the largest social security and welfare institute in Italy, I was able to reduce the running time of the monthly ETL process for the Public Sector Pension payments from a few days down to few hours.
I have also experience with MS Access, Crystal Reports, Business Objects XI, MS SQL Server, QlikSense, Irion EDM, Axway XRDJ, IBI WebFocus.