It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Kan være tilgængelig
(Opdateret 1+ år siden)Lead Data Architect/Senior Data Engineer
Sevilla, Spain
Modersmål Italian, English, Spanish
- 10+ years exp. SQL Server
- Azure / AWS / GCP
- Data pipelines
Kvalifikationer (36)
PROBLEM SOLVING
TECHNICAL DOCUMENTATION
PL/SQL
MS SQL Server
BI
DOCUMENTATION
STORED PROCEDURES
Oracle
DATABASE
Data Analysis
PRODUCT SUPPORT
Microsoft SQL Server
Visual Basic
SQL
METRICS
SQL Server
LOGGING
XML/XSLT
FINANCIALS
XML
MAINTENANCE
GOAL ORIENTED
BIOMEDICAL
DATA SCIENCE
XSLT
PUBLIC HEALTH
MARKETING ANALYSIS
MENTORING
ACCOUNTS RECEIVABLE
ACCOUNTS PAYABLE
HARDWARE INTEGRATION
Supply Chain Management
ROBOTIC
ECOSYSTEM
SUPPLY CHAIN
CREDIT ISSUES
Resumé
https://www.linkedin.com/in/davidemoraschi
Professionel erfaring
Author
tr ate gy Ce
2021-01 - 2021-01
Yara International, global leader in crop nutrition, Toptal client. AWS Redshift As Data architect, leading a team of 8, I audited and reviewed and Airflow documented their existing data infrastructure.
Proposed and bootstrapped a plan to improve the efficiency and • S3, Spectrum reduce costs. • Segment data streams Introduced a ticket system for better accountability and tracking of data requests. • Python debugging Streamlined relationships with different groups in the company.
Helped stakeholders in the definition of enterprise wide KPIs.
Manage and improved the AWS ecosystem, reducing day to day operations and introducing monitoring/logging. Cleaned up the ETL infrastructure from unused, redundant and faulty pipelines.
2016 - 2020 Fortune 100 US hardware manufacturer, Toptal client. Azure CI/CD I built the new version of a legacy system used to store, retrieve, and Azure SQL update data about products, bills of materials, and services. The information included components, parts schematics, and • ETL, data pipelines maintenance manuals in all languages supported. Designed the • SQL stored procedures database and the processes needed to move the data around from the legacy • Scripting system to the new one--The overall engagement consisted of building the data infrastructure supporting the application. Introduced Azure SQL change tracking, so tables now are loaded and updated only if they had modifications. Introduced DevOps and DataOps with Azure as the standard procedure for database deployment--The entire ecosystem is hosted on Microsoft Azure.
US beauty product manufacturer, leader in the fragrance sector. MicroStrategy Migration of the SAP FI reporting from SAP BW to IBM Netezza MicroStrategy: data modelling, semantic layer and report/dashboards development. Accounts Payable, Accounts Receivable, and • FI Metrics DSO, DPO, WAPT Supply Chain Management advanced KPIs. Replicate SAP BW KPIs to work • Remote multi-site teamwork • Tight deadlines exactly the same in MicroStrategy as in BW info cubes.
Proposed and bootstrapped a plan to improve the efficiency and • S3, Spectrum reduce costs. • Segment data streams Introduced a ticket system for better accountability and tracking of data requests. • Python debugging Streamlined relationships with different groups in the company.
Helped stakeholders in the definition of enterprise wide KPIs.
Manage and improved the AWS ecosystem, reducing day to day operations and introducing monitoring/logging. Cleaned up the ETL infrastructure from unused, redundant and faulty pipelines.
2016 - 2020 Fortune 100 US hardware manufacturer, Toptal client. Azure CI/CD I built the new version of a legacy system used to store, retrieve, and Azure SQL update data about products, bills of materials, and services. The information included components, parts schematics, and • ETL, data pipelines maintenance manuals in all languages supported. Designed the • SQL stored procedures database and the processes needed to move the data around from the legacy • Scripting system to the new one--The overall engagement consisted of building the data infrastructure supporting the application. Introduced Azure SQL change tracking, so tables now are loaded and updated only if they had modifications. Introduced DevOps and DataOps with Azure as the standard procedure for database deployment--The entire ecosystem is hosted on Microsoft Azure.
US beauty product manufacturer, leader in the fragrance sector. MicroStrategy Migration of the SAP FI reporting from SAP BW to IBM Netezza MicroStrategy: data modelling, semantic layer and report/dashboards development. Accounts Payable, Accounts Receivable, and • FI Metrics DSO, DPO, WAPT Supply Chain Management advanced KPIs. Replicate SAP BW KPIs to work • Remote multi-site teamwork • Tight deadlines exactly the same in MicroStrategy as in BW info cubes.
MicroStrategy
2015-01 - 2015-01
SSIS Migration from 9.4.1 to 10.5 and project upgrade. Design and SQL Server development of several MicroStrategy projects to support the management decisions in Logistics, Production, Financials: data • Project management modelling, ETL, development and support. Maintenance of the • Gathering requirements existing BI stack. Training. Support. • Setting expectations davidem@eurostrategy.net +34 690063666 https://moraschi.com Microsoft Partner of the Year 2013 - Business Intelligence. Microsoft Power BI Business Intelligence projects in the hospitality and marketing SQL Server SSAS sector. Advanced ETL scripts, JSON REST web services, semantic text analytics, geographic queries with Microsoft SQL Server. Design of POC • Startup culture dashboards in Power BI. • International public bidding • Technical presale 2009 - 2014 Public health Services, Region of Andalucía. SharePoint Oracle Managing a 5 members team, design and proof of concept of a MicroStrategy full-stack BI infrastructure for hospital data analysis, based on MicroStrategy and SharePoint with custom SSO and user • Ability to adapt to change authorization to comply with PA standards. More Series of departmental • Negotiation skills integrations with the Hospital Information System, HL7 validation. Interactive • Proactivity, Resilience data pages for almost real-time ER monitoring and beds allocation.
Engineering Company, Diagnostics & Research. C++/C# VBA Automation, integration of multiple diagnostic appliances to Xiril XML/XSLT Robotic Workstation (thermoshaker, barcode scanner, ).
Development of a new application to manage and service an array reader • Project management (serial communication layer + UX design). • Hardware integration • Source version control Publishing Company, Data Science & Web Development. MicroStrategy Word One book, "Business Intelligence with MicroStrategy". Concept, SQL Server Outline, writing and reviewing. Creation of additional material for the web site: videos, code, examples. From the first idea to the • Negotiation skills online promotion, working together with the editor team, one • Multi-cultural environment chapter at a time over a one-year period. More • Focus
Engineering Company, Diagnostics & Research. C++/C# VBA Automation, integration of multiple diagnostic appliances to Xiril XML/XSLT Robotic Workstation (thermoshaker, barcode scanner, ).
Development of a new application to manage and service an array reader • Project management (serial communication layer + UX design). • Hardware integration • Source version control Publishing Company, Data Science & Web Development. MicroStrategy Word One book, "Business Intelligence with MicroStrategy". Concept, SQL Server Outline, writing and reviewing. Creation of additional material for the web site: videos, code, examples. From the first idea to the • Negotiation skills online promotion, working together with the editor team, one • Multi-cultural environment chapter at a time over a one-year period. More • Focus
The European Commission
2003-01 - 2009-01
is the 'engine room' of the EU. Oracle PL/SQL Study, analysis and development of a time-series oriented Visual Basic database for storage, consultation and update of time series datasets used in economic models. Having different models and • Teamwork and assertiveness different mathematical software (GAMS, Vensim), the database allowed • Goal oriented approach input/output and conversion of datasets between them. More • Listening skills Spain's leading consulting and technology multinational. MicroStrategy Design, development and maintenance of an Oracle data- Oracle Warehouse Builder warehouse in one of the biggest hospitals in Spain. ETL loads, semantic layer, and daily monitoring. Warehouse Builder mentoring and • Data modelling skills MicroStrategy user training. • Customer oriented • Proactivity, Accountability
Pioneer
1998-01 - 2002-01
in new types of cross-disciplinary biomedical research. Oracle Ultrasearch Study and proof of concept of a full-text search engine for the SQL Server retrieval of medical and biological literature from scientific web databases (PubMed, Omim, ) and international genome • Background in Biology databases (SNP, Ensembl, ). Intranet proteomic application aimed at helping • R&D attitude the hemoglobin variations research. • Self-study Molecular and serology products worldwide manufacturer. Oracle Linux Help building a European database of samples and antibiogram VBA Kermit test results for an antibiotic surveillance network. Connections to different lab hardware and software, extraction and data cleansing. Remote support to hospital personnel. • Travel arrangements • Communication skills • Can do attitude 1991 - 1998 Leading agriculture company, Crop Protection, Seeds. Oracle Linux Hardware e software maintenance, third-party provider Classic ASP management and user support. Sales department data-warehouse.
Help migrating data from legacy AS-400 to SAP R/3 system. • Service oriented • Vendor relationship • Out-of-the-box thinking Software manufacturer, worldwide leading service provider. Cobol Visual Basic Product support engineer, customer support, troubleshooting, beta SQL Server testing. Development of samples and technical documentation.
Help building a customer satisfaction data-warehouse to measure • Communicating with customers the call-center performance. • Problem solving approach • Software life-cycle
Help migrating data from legacy AS-400 to SAP R/3 system. • Service oriented • Vendor relationship • Out-of-the-box thinking Software manufacturer, worldwide leading service provider. Cobol Visual Basic Product support engineer, customer support, troubleshooting, beta SQL Server testing. Development of samples and technical documentation.
Help building a customer satisfaction data-warehouse to measure • Communicating with customers the call-center performance. • Problem solving approach • Software life-cycle
Certificeringer
MicroStrategy Certified Engineering Principal (MCEP)
MicroStrategy Certified Engineering Principal
Microsoft Certified Azure Data Engineer
MCPS: Microsoft Certified Professional
Microsoft Certified Professional
Microsoft Certified
MCPS