offline
Last seen: May 31, 2012 1:05 PM EDT
Hire Me!
Rate: $20.00 USD/hour
Follow Invite to Project
 

EnricoGiorgi

Excel - VBA Developer

Username: EnricoGiorgi

  • Has not made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has not verified their secure phone number.
  • Verified
  • Payment is not verified.

Location: Cascina, Italy

Member since: May 2012

Reputation:

0.0/5

(0 reviews)

0
[see more]

No user has recommended this freelancer.

My skills:

My projects:

    EnricoGiorgi has not completed any projects.
    EnricoGiorgi has not completed any projects.
    EnricoGiorgi does not have any work in progress.
    EnricoGiorgi has not bid on any projects.
    EnricoGiorgi does not have any open projects.
    EnricoGiorgi does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Excel - VBA Developer free-lance

Feb 2012 - Apr 2012 (2 months)

Duferco Energia S.p.A.

Development of automated and efficient VBA sub-routines for the delivery of data, establishing connections between Excel, Word and Outlook to produce reporting and analysis to support decision making.

Logistics Employee

Nov 2010 - Nov 2011 (1 year)

Energetic S.p.A.

- Gas consumptions forecasting;<br />- Computation of necessary gas capabilities to satisfy customers' demand in each area;<br />- Creation of VBA routines for data analysis;<br />- Database Access update through query;<br />- Creation of reports and statistical analyses on Excel (via pivot tables, array formulae, macro);<br />- Support for corporate processes mapping and definition of the informative data flow.

Operations Data Analyst

Jul 2009 - Nov 2010 (1 year)

Prysmian Cavi e Sistemi Italia s.r.l.

- Development of multivariate statistical models (logistic regression, principal components analysis, Monte Carlo and cross-validation simulations, ROC curve analysis) to correlate the percentage of scraps with the parameters of the raw materials, using the R software;<br />- Production scheduling: creation of Excel reports about produced items, buffers, stocks.

Researcher

Feb 2009 - Sep 2010 (1 year)

National Institute of Geophysics and Volcanology

- Development of statistical models about expert elicitation techniques;<br />- Development of new algorithms using the software R;<br />- Multivariate statistical analyses (cluster analysis, principal components analysis, regression,) about volcanic eruptions data sets;<br />- Creation of probabilistic maps about volcanic risk management.

Education

Engineering Management

Università di Pisa

2003-2008

Publications

Comparison of a new expert elicitation model with the Classical Model, equal weights and single experts, using a cross-validation technique

Reliability Engineering and System Safety

The problem of ranking and weighting experts' performances when quantitative judgments are being<br />elicited for decision support is considered. A new scoring model, the Expected Relative Frequency<br />model, is presented, based on the closeness between central values provided by the expert and known<br />values used for calibration. Using responses from experts in five different elicitation datasets, a crossvalidation<br />technique is used to compare this new approach with the Cooke Classical Model, the Equal<br />W