Davide Moraschi

MicroStrategy project design, schema objects creation, reports and dashboards for a leading provider of telehealthcare solutions.Service Level agreement monitor, Stock level information historical charts.

MicroStrategy Certified Engineer. Analysis, design, development, support for different MicroStrategy projects.

Interface design, software development, support for lab solutions in the fields of Diagnostics.

Analysis, development and maintenance of a business intelligence system for the hospital management. Definition of KPIs and ETL processes (Oracle Warehouse Builder + Microstrategy Intelligence Server).Administration/Optimization of the Oracle DBMS servers in the Hospital area.Testing and evaluation of a new BI reporting DB and analysis tool (Alterian Suite).Preparation and data cleansing for the forthcoming introduction of a new Hospital Information System (Diraya).

Study, analysis and development of an economic models database aimed at storage, consultation and update of timeseries datasets used to run policy support simulations. Having data from different models and different mathematical softwares, the database allows direct interchange of datasets between different models (GAMS, Vensim). Design/implementation of a project-management/time-reporting system for the “Competitiveness & Sustainability” unit. Based on and compatible with Microsoft Project, this windows client application was build in compliance with the restrictions/requirements of the European Commission IT infrastructure. Support to end users and database maintenance.Microsoft Office (Word, Excel, Powerpoint, Access) courses for intermediate and advanced users.Development and maintenance of unit web sites.

•Design, development and maintenance of an Oracle 9iR2 Datawarehouse in a public health institution (biggest hospital in Spain for number of medical treatments). ETL module, web presentation module and monitoring system for daily tasks.Multiple data source extraction system (Sybase 12.5, Oracle, Access, ASCII files, etc.). Loading and calculation of monthly key performance indicators for the intranet reporting system.

•Bioinformatics consultant, database design and development of proteomics application.Study and implementation of a full-text search engine (to be included in the European project “Oncology Over Internet”) for the retrieval of medical and biological literature from the most famous scientific web database- (PubMed, Omim, etc.) and sequence analysis in international genome databases (SNP, Ensembl, etc.)

Implementation and maintenance of a multinational network of hospital computers for the collection of diagnostic data about antimicrobial resistance.Design and development of software for the extraction of such data from the different laboratory information systems; quality control of the data, reliability check and normalization of the tests; automatization of the data flow towards an Oracle database in the US.Creation of format conversion utilities for the different historical data.

•IT manager, hardware e software maintenance, third-party consultant management and user support.Token-ring network migration from Netware Novell + IPX to NT + TCP/IP. Client migration from Windows 3.11 + Novell Netware + Netware for SAA to Windows 98 + MS client + TCP terminal emulation for AS/400Switch to accounting system SAP R/3 with customer data transfer from AS/400.Implementation of Lotus Notes 4.5 mail system for all internal and external users.Sales force automation (Sales Manager + Product Managers + Sales reps) with Microsoft RAS system and 8 toll-free auto-switch ISDN lines.Development of a web based report system extracting sales data from SAP database via ODBC. Design of a data-mart and dynamic ASP pages for the business intelligence and decision support of sales force.

Internal tools manager (CRM) September 1997 – May 1998Responsible for setup and implementation of the different software tools used by the support engineers.Creation of an intranet site with the dynamic presentation of customer satisfaction data and development of an automated customer mailing system.Beta test and localization engineer.Language and functional check of the Italian software during the development phase; management of the problems connected to the different language and culture, collection of customers complains and suggestions for the new releases, testing in cooperation with the developers and final assessment of the product quality. Product support service engineer: customer assistance, support and troubleshooting for the products: COBOL, MS-DOS, Windows 95, Access, Visual Basic, FoxPro