Recommended expert

Davide Moraschi

Senior Data Architect/Engineer

Davide Moraschi
Seville, Spain

Experience

Jan 2024 - Present
2 years 1 month

Senior Data Architect/Engineer

Straumann Group

  • Data architect to design, create, and monitor pipelines for the marketing intelligence unit.
  • Maintain legacy ETL and new data pipelines using AWS AppFlow, Step Functions, Athena, Snowflake.
  • Deploy infrastructure as code with Terraform.
  • Monitor pipeline metrics and implement DevOps practices with AWS CodeCommit.
Jun 2023 - Dec 2023
7 months

Data Flow Architect

Sanofi

  • Gathered functional requirements from different business units and designed data flows and documentation in Jira.
  • Defined data flow methodologies, tools, techniques, and deliverables.
  • Performed functional design with stakeholders, capturing business requirements and creating data deliverables.
  • Developed logical and physical data models and implemented data governance.
  • Ensured proper implementation of Data Excellence guidelines and monitoring of metadata and KPIs.
  • Developed supply chain management indicators including delivery on time/in-full and shipment monitoring.
Jan 2022 - Jun 2023
1 year 6 months

Senior Data Engineer

Pfizer - PGS Operations Insights

  • Rebuilt Python pipeline introducing CI/CD tools and a DataOps mindset for supply chain insights.
  • Migrated application database from on-premises Linux to Kubernetes on AWS, reducing load times by 50% and adding exception handling, monitoring, and logging.
  • Migrated all SQL and job scripts from Redshift to Snowflake, reducing database size, backup times, and network costs.
  • Mentored colleagues on best practices in big data and infrastructure.
Jan 2021 - Dec 2021
1 year

Data Lead and Architect

Yara International

  • Led a team of 8 to audit, review, and document existing data infrastructure.
  • Proposed and bootstrapped a plan to increase efficiency and reduce costs.
  • Introduced a ticketing system for request and issue accountability.
  • Streamlined relationships with other departments and helped stakeholders define enterprise-wide KPIs.
  • Automated and debugged AWS Glue pipelines, reducing day-to-day operations and adding monitoring and logging.
  • Cleaned up redundant and obsolete pipelines.
Jan 2019 - Dec 2020
2 years

Azure Data Engineer

Caterpillar

  • Built a new version of a legacy system to store, retrieve, and update data about products, bills of materials, and services.
  • Tuned database design and processes to move data from the legacy system to Azure Cloud using Azure SQL change tracking and incremental load.
  • Added DevOps and DataOps as standard procedures for database deployment.
  • Optimized application performance by rewriting SQL queries and proposing plans to resolve data problems and save cloud costs.
Jan 2017 - Dec 2019
3 years

DBA, Backend Developer

MERGE (BEAM Interactive)

  • Developed SQL and JSON backend for CustomEyes Configurator, a sales automation tool that won a 2020 award.
  • Used T-SQL stored procedures and system-versioned tables to support disconnected and connected mode data sync.
  • Designed, optimized, and monitored Azure SQL data models.
  • Introduced DataOps procedures and standards.
Jan 2017 - Dec 2018
2 years

SQL Database Expert

Equature (DSS Corporation)

  • Overhauled dynamically generated database to improve speed and accessibility for ingestion and content delivery platforms.
  • Streamlined solution to segregate capture data from static data.
  • Optimized hardware, operating system, and database layers to achieve sub-second response.
  • Performed SQL Server DBA tasks and query optimization.
Jan 2016 - Dec 2016
1 year

Data Engineer, Data Analyst

COTY

  • Migrated accounting and financial reports from SAP BW to MicroStrategy, including data modeling, semantic layer, and dashboard creation.
  • Developed advanced KPIs for accounts payable, accounts receivable, and supply chain.
  • Coordinated external database stakeholders and designers across different time zones.
  • Translated stakeholder requirements into reliable, actionable insights.
Jan 2014 - Dec 2015
2 years

Data Architect, Engineer, Analyst

AGQ LABS

  • Gathered requirements, analyzed, and developed data analysis projects supporting logistics, production, and financial departments with data modeling, ETL, and training.
  • Maintained existing BI stack on MS SQL Server.
  • Performed DBA tasks and optimization.
  • Worked with SSIS and MicroStrategy.
Jan 2012 - Dec 2012
1 year

Author

PACKT Publishing

  • Managed book development from concept through writing, proofreading, and release.
  • Created additional materials including videos and examples.
  • Coordinated with PACKT editor team in Asia to release the book ahead of schedule.
  • Covered data warehouse, data modeling, SQL Server, and advanced analytics in MicroStrategy.
Jan 2010 - Dec 2013
4 years

Database Developer, Programmer

INyDIA

  • Automated integration of multiple diagnostic appliances with the Xiril Workstation (thermoshaker, barcode scanner, etc.).
  • Conceived and developed a database for unified sample reporting based on MS Access and XML/XSLT.
  • Developed an application in C++ for motor driver management and integrations in C#.
Jan 2009 - Dec 2014
6 years

Database Specialist Business Intelligence Architect

Public Health Services of Andalucía

  • Designed and created an MVP for a hospital data analysis application and infrastructure based on MicroStrategy and SharePoint with SSO and privacy compliance.
  • Integrated departmental pipelines with the Hospital Information System using HL7.
  • Implemented microservices architecture and API and streams integration.
  • Automated database maintenance using T-SQL and PowerShell and managed Bitbucket source code repository.

Summary

Author of the book “Business Intelligence with MicroStrategy”

Worked for years in Fortune companies designing and maintaining scalable data infrastructures based on Azure and Amazon Web Services. Completed successfully on-premises cloud migrations including ETL pipelines. DataOps approach to database development. 15+ years of experience with SQL technologies. 5+ years DevOps tools and Agile projects. 5+ CI/CD tools experience (GitHub, Azure DevOps, Terraform).

Skills

  • Learning Ability
  • Curiosity
  • Resilience
  • Adaptability

Languages

English
Native
Spanish
Native
Italian
Native

Certifications & licenses

Microsoft Cert if ied Azure Data Engineer

Microsoft

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Renato Dall’armi
Renato Dall’armi

Principal consultant Digital transformation

View Profile
Mariano Filiberto
Mariano Filiberto

SAP Business Intelligence Solution Architect / Team Lead Core Program

View Profile
Anton Klonov
Anton Klonov

Head of Technical Overall Integration NSC / Hadoop Cloud Development

View Profile
Stephan Sahm
Stephan Sahm

Senior Data/ML Consultant & Technical Lead

View Profile
Eduard Van kleef
Eduard Van kleef

Workshop Leader 'Introduction to AI Development Tools'

View Profile
Davide Imperati
Davide Imperati

Consultant – Lead Data Engineer

View Profile
Íñigo Montoya
Íñigo Montoya

SAP Analytics Expert

View Profile
Axel Berron
Axel Berron

Microsoft Fabric & Power BI Developer

View Profile
William Nguyen
William Nguyen

Product Owner Frontend

View Profile
Thomas Hoefkens
Thomas Hoefkens

Senior MLOps, DevOps Engineer

View Profile
Almudena Barreiro carrillo
Almudena Barreiro carrillo

Data Ethics Telecommunications Company

View Profile
Jorge Machado
Jorge Machado

Data Architect

View Profile
Olivier Hartzer
Olivier Hartzer

International Senior Consultant

View Profile
Andrea Goldoni
Andrea Goldoni

Senior Software Developer and Consultant

View Profile
Hernani Costa
Hernani Costa

AI CTO & Co-Founder

View Profile
Kalin Stefanov
Kalin Stefanov

Sr Data Engineer / Architect

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Ildar Allayarov
Ildar Allayarov

Senior Data Engineer

View Profile
Sebastian Palacio
Sebastian Palacio

ML Engineer

View Profile
Simon Stegelmeier
Simon Stegelmeier

Cloud Data Platform Product Owner & Project Manager

View Profile
Rodrigo Herrán
Rodrigo Herrán

Data Engineer

View Profile
Piero Giorgio
Piero Giorgio

Data Consultant

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Noel Figuera
Noel Figuera

Career Transition

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Kay Moritzen
Kay Moritzen

Head of Risk Modeling & Cloud Infrastructure

View Profile
Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Ashkan Zadeh
Ashkan Zadeh

Microsoft Azure Senior Data Engineer / Senior Data Scientist

View Profile
Philipp Brunenberg
Philipp Brunenberg

Instructor

View Profile