Davide is available for hire

Davide Moraschi

Verified Expert in Engineering

Data Engineer and Developer

Seville, Spain

Toptal member since June 18, 2020

Expertise

Data Warehouse Data Analysis Data Science Data Engineering Big Data Architecture Data Visualization Database SQL Excel Development

Bio

Davide is a data engineer certified by Microsoft Azure and AWS and an experienced data architect. He is the author of "Business Intelligence with MicroStrategy Cookbook." With a career spanning two decades in data warehousing, using relational and NoSQL databases, Davide's job consists of loading, transforming, and visualizing large amounts of data. Lately, he has been working on Cloud Big Data projects with Fortune 500 clients.

Portfolio

Toptal

Data Engineering, Data Analysis, Data Architecture

Atlas Group London Limited

Data Engineering, C#, Azure, Databases, Data Modeling, Architecture, .NET...

Pfizer - PGS Operations Insights

Data Engineering, DataOps, Snowflake, PostgreSQL, Apache Airflow, Python...

Experience

Data Modeling - 20 years
Microsoft SQL Server - 15 years
SQL - 15 years
ETL Development - 15 years
Azure SQL - 7 years
Python - 4 years
Snowflake - 3 years
Redshift - 3 years

Availability

Part-time

Preferred Environment

Microsoft Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS), SQL, Oracle

The most amazing...

...thing I've written is a book about business intelligence with Microsoft SQL Server and MicroStrategy, which is still selling well on Amazon after four years.

Work Experience

Data Strategy Advisor

2024 - 2024

Toptal

Worked as a data integration and analysis expert to support the preparation of a project proposal aimed at automating data ingestion from multiple sources and enhancing data analysis and visualization capabilities.
Assessed the current data collection processes from various sources, identifying opportunities for automation and integration.
Recommended and implemented best practices for setting up and managing the data warehouse.
Provided rough estimates for project completion (10-14 weeks) and budget considerations. Addressed key concerns around data validation and ensured robust data governance practices were in place.

Technologies: Data Engineering, Data Analysis, Data Architecture

Data Engineer

2023 - 2023

Atlas Group London Limited

Helped the client import into an SQL database some datasets related to projects, such as modeling, design, construction, operations/management, and procurement data. Imported Autodesk Revit data as JSON objects.
Tested several different I/O configurations with other disks and IOPS to do a POC for the client about how fast a file can be loaded.
Understood the business and BIM team needs and worked towards a more performant, scalable solution. Created a document on the proposed changes and the modifications required to make the application database safer and more performant.
Installed a VM in Azure with SQL Server, read a 200/400M JSON file from within the database, and completed the query in about one minute.

Technologies: Data Engineering, C#, Azure, Databases, Data Modeling, Architecture, .NET, Tekla Structures

Data Engineer

2022 - 2023

Pfizer - PGS Operations Insights

Was part of the team that provides insights into the supply chain. I helped the team transition to a full working CI/CD model based on GitHub, Terraform, and Kubernetes.
Migrated the application database from on-premises Linux VM to Kubernetes cluster in AWS. I also migrated all ETL scripts and processes from Redshift to Snowflake.
Improved the efficiency of Python code by 50%. Improved instrumentation of the code with logging, monitoring, and error handling.
Introduced the migration for databases based on Liquibase technology.
Reduced the database size, improved backup times, and reduced overall network costs.
Mentored colleagues on the best practices in big database infrastructures.

Technologies: Data Engineering, DataOps, Snowflake, PostgreSQL, Apache Airflow, Python, Liquibase, Kubernetes, Server Migration, Azure SQL, ETL Development, Redshift, Dimensional Modeling, Data Modeling, Containers, Database Modeling, Data-driven Design, ETL Tools, Data Analysis, Database Optimization, Database Migration, Amazon RDS, Microsoft Excel, Data, CI/CD Pipelines, Data Lakes, Database Development, ETL Implementation & Design, ETL Testing

Lead Data Architect

2021 - 2021

Yara International

Led a team of eight and audited, reviewed, and documented their existing data infrastructure.
Proposed and bootstrapped a plan to improve efficiency and reduce costs.
Introduced a ticket system for better accountability and tracking of data requests.
Streamlined relationships with different groups in the company.
Helped stakeholders in the definition of enterprise-wide KPIs.

Technologies: Amazon Web Services (AWS), Apache Airflow, AWS Glue, AWS Database Migration Service (DMS), PostgreSQL, Amazon Redshift Spectrum, Snowflake, Architecture, SQL, Python, Jira, Team Leadership, Azure SQL, ETL Development, Redshift, Dimensional Modeling, Data Modeling, Database Modeling, Data-driven Design, ETL Tools, Data Integration, Data Analysis, Data Build Tool (dbt), Amazon S3 (AWS S3), AWS Data Pipeline Service, Amazon CloudWatch, Business Intelligence (BI), Database Optimization, Amazon Aurora, AWS Lambda, Apache Kafka, Database Migration, Amazon RDS, Database Design, Data, CI/CD Pipelines, Data Lakes, Database Development, ETL Implementation & Design, ETL Testing

Azure Data Architect

2019 - 2021

Fortune 100 North American Construction Equipment Manufacturer

Built the new version of a legacy system used to store, retrieve, and update data about products, bills of materials, and services. The information included components, parts schematics, and maintenance manuals in all languages supported.
Designed the database and the processes needed to move the data from the legacy system to the new one. The overall engagement consisted of building the data infrastructure supporting the application.
Introduced Azure SQL change tracking, so tables only loaded and updated if they had modifications. Helped introduce DevOps to Azure as the standard procedure for database deployment. The entire ecosystem is hosted on Microsoft Azure.

Technologies: Azure DevOps, T-SQL (Transact-SQL), Azure, Data Marts, Data Engineering, Relational Databases, Data Pipelines, Apache Airflow, Snowflake, Azure SQL, ETL Development, Redshift, Dimensional Modeling, Data Modeling, Database Modeling, Data-driven Design, ETL Tools, Architecture, Data Integration, Microservices, Data Analysis, Business Intelligence (BI), Database Optimization, Database Design, Data, CI/CD Pipelines, Data Lakes, Database Development, ETL Implementation & Design, ETL Testing

Database Developer | Report Writer (SQL/Oracle)

2017 - 2019

Toptal Client

Handled the entire lifecycle of the data layer that helps run an award-winning sales representative operation application.
Designed the architecture, developed the database, and rolled out the same in coordination with the rest of the development team.
Handled the different stages of the database (development, testing, production) and used several tools to sync the schema and the data between them all and maintain the Azure SQL code so that it's up-to-date in the Azure DevOps repository.
Strove to keep all the plates spinning at full speed, which involved monitoring logs, modifying T-SQL code, and optimizing indexes, statistics, and table structure to maximize Azure SQL performance.
Designed the ER diagram from initial requirements based on a series of JSON documents needed by the middle layer. Using the latest JSON SQL techniques, I developed a series of stored procedures underpinning an API layer.
Handled the rollout and the different phases of the database lifecycle (development, UAT, production) and synced data between the instances to keep the app running.
Created a series of T-SQL functions using Microsoft SQL Server system-versioned tables that calculate and return only the inserted or modified data after the previous API call. This was a requirement for a disconnected progressive app.

Technologies: Windows PowerShell, Oracle, Database Design, JSON, DevOps, Azure SQL Databases, Data Management, Data Architecture, Data Modeling, Data Warehousing, Azure SQL, ETL Development, Dimensional Modeling, Database Modeling, Data-driven Design, ETL Tools, Data Analysis, Business Intelligence (BI), Database Optimization, BI Reporting, Dashboards, Database Development, ETL Implementation & Design

Microsoft SQL Database Expert

2016 - 2019

Toptal Clients

Optimized tables and indexes and analyzed and created a proof of concept for a better search using multiple filters. Used Power BI, SSRS, and data aggregation.
Developed the company's audits, logging, and alert reporting interface with knowledge of Power BI, dashboard creation, data aggregation, and SSRS.
Extracted data from the raw database to populate the aggregation database, analysis services, or SQL data marts with SQL Server Integration Services (SSIS).
Designed ERD and database scripts for progressive web apps. Developed stored procedures to synchronize data between offline clients and a central database via JSON files.

Technologies: C#, Microsoft SQL Server, Amazon Web Services (AWS), Azure, DevOps, Data Management, Data Architecture, Data Modeling, Data Pipelines, Azure SQL, ETL Development, Dimensional Modeling, Database Modeling, Data-driven Design, ETL Tools, Data Integration, Data Analysis, Business Intelligence (BI), Database Optimization, Dashboards, Database Transactions, Database Structure, Database Development

SQL Expert

2016 - 2017

Toptal Client

Reviewed and optimized SQL queries and merged them from different data sources.
Built complex SQL, optimizing tables and indexes and partitioning.
Optimized geographic queries with SQL, finding the closest matches given a point and a radius.
Converted data from the previous on-premise server to the cloud.

Technologies: SQL, Azure, Microsoft SQL Server, Azure SQL, ETL Development, Dimensional Modeling, NoSQL, Database Modeling, Data-driven Design, ETL Tools, Business Intelligence (BI), Amazon Aurora, BI Reporting, Dashboards, Database Transactions, Database Structure, Database Development

MicroStrategy Senior Consultant

2016 - 2016

COTY

Migrated SAP FI reporting from SAP BW to MicroStrategy.
Developed the semantic layer and reports/dashboards.
Advanced KPIs for accounts payable, accounts receivable, and supply chain management departments.
Replicated SAP BW KPIs to work exactly the same in MicroStrategy as in BW info cubes.
Worked in a remote multisite team within tight deadlines.

Technologies: MicroStrategy, Shell Scripting, DevOps, Data Management, Big Data Architecture, Microsoft Power BI, ETL Development, Containers, Database Modeling, Data-driven Design, ETL Tools, Tableau, Data Visualization, BI Reporting, Database Transactions, Transactions, Database Development

Business Intelligence Senior Consultant

2015 - 2015

Bism@rt

Handled business intelligence projects in the hospitality and marketing sectors. Involved in international public bidding and technical presales.
Worked with advanced ETL scripts, JSON REST web services, semantic text analytics, and geographic queries with Microsoft SQL Server.
Designed POC dashboards in Power BI. Immersed in the startup culture. Optimized geographic SQL queries.

Technologies: Microsoft Power BI, SQL Server Integration Services (SSIS), Microsoft SQL Server, ETL, SQL, DevOps, Data Management, Data Architecture, Big Data, NoSQL, Database Modeling, Data-driven Design, PostgreSQL, Architecture, Data Integration, Tableau, Data Visualization, API Integration, Database Administration (DBA)

MicroStrategy Senior Consultant

2015 - 2015

AGQ Labs

Contributed with key elements to several MicroStrategy products to support management decisions in logistics, production, and financials. Provided data modeling, ETL, and development.
Gathered requirements, set expectations, trained junior employees, managed projects, and provided support for all products.
Maintained the existing BI stack and improved the efficiency of SQL databases.

Technologies: MicroStrategy, SQL Server Integration Services (SSIS), Microsoft SQL Server, Data Analytics, Shell Scripting, DevOps, T-SQL (Transact-SQL), SQL Stored Procedures, Data Management, Data Warehousing, Data Visualization, API Integration, Database Administration (DBA), Transactions

Business Intelligence Architect

2009 - 2014

Public Health Services, Region of Andalucía

Managed a five-member team proactively and negotiated with clients.
Designed and built a proof of concept for a full-stack BI infrastructure for hospital data analysis based on MicroStrategy and SharePoint with custom SSO and user authorization to comply with PA standards.
Made a series of departmental integrations with the hospital information system and HL7 validation.
Built interactive data pages for almost real-time ER monitoring and bed allocation.

Technologies: HL7, REST, MicroStrategy, Oracle, Oracle PL/SQL, ETL, SQL, DevOps, Azure, Azure DevOps, Bash Script, Data Warehousing, PostgreSQL, Data Visualization, API Integration, Database Administration (DBA), Oracle DBA, Electronic Health Records (EHR)

Author

2013 - 2013

PACKT Publishing

Authored "Business Intelligence with MicroStrategy," from concept to final review.
Created additional material for the website, including videos, code, and examples.
Collaborated with the editing team, one chapter at a time.
Prepared practical exercises and videos, editing and post-processing.
Used heterogeneous sources, including Vertica and BigQuery.

Technologies: Amazon Web Services (AWS), Azure, MicroStrategy, Microsoft SQL Server, Shell Scripting, DevOps, Redshift, BigQuery, Data Warehousing, Amazon RDS, Database Structure

Diagnostics Equipment Integration and Automation Developer

2009 - 2012

INyDIA Labs

Automated and integrated multiple diagnostic appliances with Xiril robotic workstation (thermoshaker, barcode scanner, etc.).
Developed a new application to manage and service an array reader (a serial communication layer and UX design).
Integrated hardware and software from disparate vendors and created an OLE DB layer to manage different machines.
Managed projects and oversaw source version control.
Did RS232 programming in C++ and user interface in C#.

Technologies: XML/XSLT, C#, Shell Scripting, DevOps, C++, Integration, APIs, Database Administration (DBA), Excel 2016, Database Structure, Transactions

Data Analyst | Database Developer

2003 - 2009

European Commission

Studied, analyzed, and developed a time series-oriented database to store, consult, and update the time series datasets used in economic models.
Utilized different models and mathematical software (GAMS, Vensim), enabling the database to allow input and output and conversion of datasets between them.
Helped multiple teams create databases for their statistical models.

Technologies: PL/SQL, Oracle, Microsoft Excel, Databases, Data Warehousing, Excel 2016, Database Structure, Transactions, MySQL, Statistics

Business Intelligence Developer

2003 - 2006

INDRA

Designed, developed, and maintained an Oracle data warehouse in one of the biggest hospitals in Spain.
Dealt with ETL loads, semantic layer, and daily monitoring.
Mentored warehouse builder and MicroStrategy users.
Maintained a proactive, customer-oriented presence with impeccable accountability.

Technologies: MicroStrategy, Shell Scripting, DevOps, Data Warehousing, Excel 2016, MySQL, Statistics

Bioinformatics Developer

2002 - 2002

CNR Milano

Studied and produced a proof of concept for a full-text search engine for the retrieval of medical and biological literature from scientific web databases (PubMed, etc.) and international genome databases.
Researched and developed an intranet proteomic application aimed at helping hemoglobin variations research.
Created a cluster of 30 Linux machines to run different FASTA/BLAST searches.

Technologies: Oracle, Shell Scripting, Linux, Microsoft SQL Server, DevOps, Data, Transactions, Microsoft Excel, Statistics, Bioinformatics, Genomics

Bioinformatics Developer and DBA

2000 - 2002

FOCUS Diagnostics

Helped build a European database of samples and antibiogram test results for an antibiotic surveillance network.
Developed connections to different lab hardware and software.
Facilitated extraction and data cleansing. Developed and maintained shell scripts and Python code to do ETL/ELT.
Provided remote support to hospital personnel. Provided remote desktop and unattended maintenance.

Technologies: Linux, Oracle, Shell Scripting, Python, Data Modeling, Data, Data Warehousing, MySQL, Microsoft Excel

Helpdesk and Third-party Vendor Management Specialist

1998 - 2000

Syngenta Seeds

Provided hardware and software maintenance, third-party provider management, and user support.
Designed, developed, and maintained the sales department data warehouse.
Helped migrate data from a legacy AS-400 to an SAP R/3 system.
Maintained crucial vendor relationships with a service-oriented approach.

Technologies: Linux, Oracle, Shell Scripting, Data Pipelines, MySQL, Microsoft Excel

Support Engineer

1991 - 1998

Microsoft

Applied a problem-solving approach to product support, customer support, troubleshooting, and beta testing.
Developed samples and technical documentation to be included in the company knowledge base.
Helped build a customer satisfaction data warehouse to measure call center performance.
Communicated successfully with customers and handled issues/bugs/feature recommendations.

Technologies: Microsoft SQL Server, DevOps

Experience

A Preliminary Study for a Unified Time Series Model Data Warehouse

http://www.slideshare.net/dmoraschi/PP1-704726

I handled the design, implemention, and rollout of an Oracle architecture aimed at supporting data interchange between different financial models written in GAMS and Vensim.
I also developed and supported an ETL tool used to convert datasets between several models (time series).

Business Intelligence with MicroStrategy Cookbook

https://www.packtpub.com/product/business-intelligence-with-microstrategy-cookbook/9781782179757

A book I authored and published via Packt.

About:

Learn about every step of the BI project, starting from the installation of a sample database. Design web reports and documents. Configure, develop, and use the mobile dashboard. Master data discovery with Visual Insight and MicroStrategy Cloud Express. Learn with the help of practical, real-life examples and screencasts for each exercise.

Proyecto PANDAS

https://www.youtube.com/watch?v=nKmeod_SGFk&feature=youtu.be

Business intelligence infrastructure for the healthcare data analysis based on SharePoint, Oracle, MicroStrategy, and Linux that was rolled out to 16 hospitals.

I developed a RESTful layer to interface MicroStrategy with SharePoint.

Microsoft Professional Program Data Science Certificate

https://academy.microsoft.com/en-us/certificates/bac602db-9cea-431b-952c-6988d4a69d0d

The Microsoft Professional Program is an industry-driven online learning program from Microsoft that teaches conceptual skills and provides hands-on experience that is necessary to succeed in some of today’s most exciting technical jobs. To earn this certificate from the Microsoft Professional Program, graduates earned passing scores from a rigorous curriculum that included activities like online video lectures, hands-on labs, exams, and assessments.

Education

1981 - 1986

Bachelor's Degree in Literature

Liceo Classico - Milan, Italy

Certifications

JULY 2024 - PRESENT

AWS Certified Data Engineer – Associate

Amazon Web Services

MARCH 2023 - PRESENT

Snowflake Hands On Essentials - Data Warehouse

Snowflake

MARCH 2023 - PRESENT

Hands On Essentials - Data Applications

Snowflake

MAY 2022 - PRESENT

Liquibase Fundamentals Certification

Liquibase

MAY 2021 - MAY 2023

Microsoft Azure Data Engineer Associate

Microsoft

MAY 2020 - PRESENT

MicroStrategy Certified Architect

MicroStrategy

NOVEMBER 2019 - NOVEMBER 2021

Google Cloud Certified - Associate Cloud Engineer

Google Cloud

MAY 2015 - PRESENT

Microsoft® Certified Professional

Microsoft

MARCH 2012 - PRESENT

MicroStrategy Certified Engineering Principal

MicroStrategy

Skills

Libraries/APIs

Liquibase, Pandas

Tools

Microsoft Power BI, Excel 2016, Microsoft Excel, Apache Airflow, BigQuery, Tableau, AWS Glue, Amazon Redshift Spectrum, Jira, Amazon CloudWatch, Amazon Athena

Languages

T-SQL (Transact-SQL), SQL, Snowflake, Python, Python 3, Bash, Bash Script, C#, XML/XSLT, JavaScript, R, C++

Paradigms

ETL, Business Intelligence (BI), Database Design, DevOps, Data-driven Design, Database Development, ETL Implementation & Design, REST, Azure DevOps, Dimensional Modeling, Microservices, Building Information Modeling (BIM)

Platforms

Amazon Web Services (AWS), Oracle, Azure, Jupyter Notebook, Databricks, Linux, Kubernetes, Google Cloud Platform (GCP), AWS Lambda, Apache Kafka, Azure Synapse

Storage

Oracle PL/SQL, SQL Server 2012, Azure SQL Databases, Microsoft SQL Server, Oracle RDBMS, SQL Server 2014, SQL Server 2016, Azure SQL, Databases, PostgreSQL, SQL Stored Procedures, Data Pipelines, Database Modeling, Data Integration, Database Administration (DBA), Database Migration, Database Transactions, Database Structure, MySQL, SQL Server Integration Services (SSIS), Oracle 10g, Oracle 11g, SQL Server DBA, Oracle SQL, Amazon S3 (AWS S3), Amazon Aurora, Data Lakes, Oracle DBA, PL/SQL, JSON, Redshift, Relational Databases, NoSQL, AWS Data Pipeline Service, Apache Parquet

Frameworks

Windows PowerShell, Spark, .NET

Industry Expertise

Bioinformatics

Other

Data Warehouse Design, MicroStrategy, ETL Development, Data Analysis, Data Warehousing, Data Engineering, Data Marts, Data Analytics, Architecture, APIs, Data Modeling, Data Management, Data Architecture, Big Data, Big Data Architecture, DataOps, Data Visualization, Database Optimization, BI Reporting, Dashboards, Transactions, Data, ETL Testing, Data Science, Complex Data Analysis, Azure Data Factory, Integration, Team Leadership, Server Migration, Containers, ETL Tools, API Integration, Amazon RDS, CI/CD Pipelines, Writing & Editing, Microsoft Azure, HL7, Shell Scripting, Azure Data Lake, Azure Databricks, AWS Database Migration Service (DMS), Data Build Tool (dbt), Statistics, Genomics, Electronic Health Records (EHR), Tekla Structures

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring