Alessandro Grimaldi

Design and development of VBA ad-hoc solutions

Design and development of MS Office ad-hoc solutions, supporting the ECB's SSM mechanism. Several periodical Europe-wise bank stress tests have been performed using my VBA tools to receive, scan, analyse, categorize and save the bank submissions. Some of the graphical interfaces created with MS Access have been particularly appreciated by the Business.

Development of VBA solutions supporting Risk Management activities. I developed several Excel sheets to automate Risk Management models. These models used Excel’s @Risk statistical plugin, which I had to automate through VBA to create a fully automated analytic system.

Review of existing ICT systems to support current ERP-related processes. Support to data cleansing activities. Definition of new data formats required for migrating data into the new SAP platform. Design and development of VBA solutions for MS Office application integration and office automation.

Quality tester for Enel’s contract management software. Design and development of VBA solutions for MS Office application integration and office automation. I automated (VBA) some common operations, yielding a remarkable speed improvement in the data quality process. I did the same with MS Word, creating an interface to automatically format the periodic reports, ensuring consistency, dramatically improving the report delivery timeliness, and reducing the errors.

[Addis Ababa, Ethiopia] 1. Design of several databases to manage WFP activities in Ethiopia, and development with MS Access. 2. Design and development of a pilot web based database to store and analyse security reports from all over the Country. 3. Analysis and optimization of WFP’s business flow 4. Design of a questionnaire to check knowledge and expertise of IT-related job candidates.

[Pyongyang, DPRK] Design of a database, and development with MS Access, to store and analyse quantitative and qualitative data gathered by the Programme Officers during their monitoring missions.

[Rome, Italy] Design of an experimental database, developed with MS Access, within the CMEA project (Common Monitoring & Evaluation Approach), meant to act as a worldwide common platform to store WFP activity data, allowing detailed, reliable and homogeneous reports and statistics.

[Kabul, Afghanistan] Re-design of ACORD (Afghanistan Country Office Reporting Database), the database which tracked all WFP activities in Afghanistan, and design of the database used by the Human Resources Unit. Development with MS Access.