Franco Ropelato personal email
- Valid
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 government services, telecommunications, electro-mechanical productions, tourism, and non profit services.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: 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 3 days down to 4 hours.I have experience with MS Access, Crystal Reports, Business Objects XI, MS SQL Server and QlikView.Other areas of activity:- setup of backup procedures- server and desktop virtualization- moving from Windows to Linux - Ubuntu- ICT infrastructure planning- analysis, planning and development of software
-
Senior Business AnalystEngage Spa Dec 2015 - PresentRome, ItalyProject 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. -
Senior Business AnalystInps Dec 2004 - Oct 2015Rome, ItalyOptimization 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.
-
Database Application AdministratorTelecom Italia Information Technology (Ti.It) S.R.L. Mar 2001 - Jun 2015Pomezia, ItalyAssist 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. -
It Project ArchitectCentro Mariapoli Internazionale Dec 2003 - Apr 2014Castel Gandolfo, ItalyAnalysis 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.
-
ProgrammerSee America Travel, Inc. Apr 2000 - Sep 2005Los Angeles, CaSoftware maintenance of custom CRM system for the travel agency -
ProgrammerInternational Catholic Charismatic Renewal Services Jan 2004 - Nov 2004Rome, ItalyDeveloped 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.
-
Business AnalystMinistry Of The Treasury Mar 2002 - Dec 2002Rome, ItalyAnalyst 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. -
It ManagerCeia S.P.A. May 1994 - May 1998Arezzo, ItalyInstalled 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. -
TeacherIstituto Comprensivo "Margaritone" Oct 1992 - Jul 1993Arezzo Area, ItalyTeacher of Electronic
-
It ManagerAzur Jan 1982 - Sep 1992Incisa Valdarno, ItalyPlanned 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.
Franco Ropelato Skills
Franco Ropelato Education Details
-
Information Technology
Frequently Asked Questions about Franco Ropelato
What company does Franco Ropelato work for?
Franco Ropelato works for Engage Spa
What is Franco Ropelato's role at the current company?
Franco Ropelato's current role is Senior Business Analyst.
What is Franco Ropelato's email address?
Franco Ropelato's email address is fr****@****ail.com
What schools did Franco Ropelato attend?
Franco Ropelato attended Università Degli Studi Di Padova.
What skills is Franco Ropelato known for?
Franco Ropelato has skills like Linux, Oracle, Mysql, Sql, Database, Virtualization, Business Intelligence, Oracle Pl/sql Development, Query Optimization, Data Quality, Pl/sql, Management Accounting.
Not the Franco Ropelato you were looking for?
-
Franco Ropelato
Corrientes -
Gianni Franco Ropelato
Argentina
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial