Scroll To View More
Davide Moraschi, SQL Developer in Seville, Spain
Davide Moraschi

SQL Developer in Seville, Spain

Member since August 24, 2016
Davide is a senior business intelligence consultant and SQL Server certified professional as well as the author of the book "Business Intelligence with MicroStrategy." With a career spanning three decades in data warehousing using Oracle and SQL Server, among others, his job consists of loading, transforming, and visualizing large amounts of data, no matter where they come from—be it a relational database, NoSQL, web stream, or a blockchain.
Davide is now available for hire

Portfolio

Experience

  • Microsoft SQL Server, 15 years
  • Business Intelligence (BI), 15 years
  • Data Analysis, 15 years
  • SQL, 15 years
  • Oracle, 12 years
  • DataMart, 10 years
  • Azure SQL Databases, 5 years
  • SQL Server Integration Services (SSIS), 2 years
Seville, Spain

Availability

Full-time

Preferred Environment

SQL Server Management Studio, MicroStrategy

The most amazing...

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

Employment

  • Database Developer/Report Writer (SQL/Oracle)

    2017 - PRESENT
    Toptal Client
    • Handled the entire lifecycle of the data layer which helps run a sales rep operation application.
    • Designed the architecture, developed the database, and rolled out the same in coordination with the rest of the dev team.
    • Handled the different stages of the database (DEV, TEST, PROD) and used several tools to sync the schema and the data between them all and to maintain the Azure SQL code so that it's up to date in the Azure DevOps repository. I use tools from Microsoft, Redgate, and Devart.
    • Strove to keep all the plates spinning at full speed. This involves: monitoring logs, modifying T-SQL code, and optimizing indexes/statistics and tables structure to get the most out of Azure SQL performance.
    • Designed the ER diagram from initial requirements, based on a series of JSON document 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 (DEV, UAT, PROD) and synced data between the instances to keep the app running.
    • Created a series of T-SQL functions using SQL Server system-versioned tables that calculate and return only the data that was inserted or modified after the previous API call. This was a requirement for a disconnected progressive app.
    Technologies: Azure SQL, Redgate, Devart, Powershell
  • Microsoft SQL Database Expert

    2016 - 2019
    Toptal Clients
    • Optimized tables and indexes as well as analyzed and created a proof of concept for a better search using multiple filters. PowerBI, SSRS, and data aggregation.
    • Developed the company's audits, logging, and alert reporting interface with knowledge of PowerBI, dashboard creation, data aggregation, and SSRS.
    • Extracted data from the raw database to populate the aggregation database, analysis services, or SQL data marts with SSIS.
    • Designed ERD and database scripts for progressive web apps. Developed stored procedures to synchronize data between offline clients and central database via JSON files.
    Technologies: Microsoft SQL Server, ASP.NET, C#
  • SQL Expert

    2016 - 2017
    Toptal Client
    • Reviewed and optimized SQL queries and merged them from different data sources.
    • Built complex SQL.
    Technologies: SQL Server, SQL Data Warehouse, Azure
  • 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 multi-site team within tight deadlines.
    • Optimized SQL queries.
    Technologies: IBM Netezza, MicroStrategy
  • Business Intelligence Senior Consultant

    2015 - 2015
    • Handled business intelligence projects in the hospitality and marketing sectors.
    • 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 startup culture.
    • Involved in international public bidding and technical presales.
    • Optimized geographic SQL queries.
    Technologies: Microsoft BI, SQL Server, SSAS, SSIS
  • MicroStrategy Senior Consultant

    2015 - 2015
    AGQ Labs
    • Contributed key elements to several MicroStrategy products to support management decisions in logistics, production, and financials.
    • Provided data modeling, ETL, and development.
    • Maintained the existing BI stack.
    • Trained junior employees.
    • Provided support for all products.
    • Managed projects.
    • Gathered requirements.
    • Set expectations.
    • Optimized SQL and ETL scripts.
    Technologies: SQL Server, SSIS, MicroStrategy
  • Business Intelligence Architect

    2009 - 2014
    Public Health Services, Region of Andalucía
    • Proactively managed a five-member team.
    • 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.
    • Negotiated with clients.
    Technologies: Sharepoint, Oracle, MicroStrategy, REST, SOAP HL7 Web Services
  • 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.
    • Operated successfully in a multicultural environment.
    Technologies: SQL Server, MicroStrategy, Amazon EC2, Azure
  • 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 (serial communication layer + UX design).
    • Integrated hardware.
    • Managed projects and oversaw source version control.
    • Did RS232 programming.
    Technologies: C#, VBA, XML/XSLT
  • Data Analyst and Database Developer

    2003 - 2009
    European Commission
    • Studied, analyzed, and developed a timeseries-oriented database to store, consult, and update the timeseries datasets used in economic models. With different models and mathematical software (GAMS, Vensim), the database allowed input/output and conversion of datasets between them.
    • Employed a goal-oriented approach.
    Technologies: Oracle, PL/SQL, Visual Basic
  • 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, Oracle Warehouse Builder
  • 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.
    Technologies: Oracle Ultrasearch, SQL Server, Linux, Shell Scripting
  • 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.
    • Provided remote support to hospital personnel.
    Technologies: Oracle, Linux, VBA, Kermit
  • Helpdesk and Third-party Vendor Management Specialist

    1998 - 2000
    Syngenta Seeds
    • Provided hardware and software maintenance, third-party provider management, and user support.
    • 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: Oracle, Linux, Classic ASP
  • Support Engineer

    1991 - 1998
    Microsoft
    • Applied a problem-solving approach to product support, customer support, troubleshooting, and beta testing.
    • Developed samples and technical documentation.
    • Helped build a customer satisfaction data-warehouse to measure call center performance.
    • Communicated with customers.
    Technologies: COBOL, Visual Basic, SQL Server

Experience

  • A Preliminary Study for a Unified Timeseries Model Data Warehouse (Development)
    http://www.slideshare.net/dmoraschi/PP1-704726

    Design, implementation, and rollout of an Oracle architecture aimed at supporting data interchange between different financial models written in GAMS and Vensim.

  • Business Intelligence with MicroStrategy Cookbook (Development)
    https://www.packtpub.com/mapt/book/Big%20Data%20&%20Business%20Intelligence/9781782179757

    A book I authored and published via Packt.

    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 every exercise.

  • Proyecto PANDAS (Development)
    https://www.youtube.com/watch?v=nKmeod_SGFk&feature=youtu.be

    Business intelligence infrastructure for healthcare data analysis based on SharePoint, Oracle, MicroStrategy, and Linux.

  • Microsoft Professional Program Data Science Certificate (Other amazing things)
    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.

Skills

  • Languages

    T-SQL, SQL, JavaScript
  • Platforms

    Oracle, Azure
  • Storage

    Oracle PL/SQL, SQL Server 2008, SQL Server 2012, Azure SQL Databases, Microsoft SQL Server, DataMart, Oracle DBMS, SQL Server 2014, SQL Server 2016, Azure SQL, SQL Server Integration Services (SSIS), Oracle 10g, Oracle 11g, SQL Server DBA, Oracle SQL
  • Other

    MicroStrategy, ETL Development, Data Analysis, Business Intelligence (BI), Data Warehousing, Complex Data Analysis
  • Tools

    Microsoft Power BI
  • Paradigms

    Data Science, ETL

Education

  • Bachelor's degree in Literature
    1981 - 1986
    Liceo Classico - Milano
Certifications
  • Microsoft® Certified Professional
    MAY 2015 - PRESENT
    Microsoft
  • MicroStrategy Certified Engineering Principal
    MARCH 2012 - PRESENT
    MicroStrategy
I really like this profile
Share it with others