Data Platform Development

Expertware has a long tradition and cutting capabilities in data platform services. It includes relational and no-SQL heterogeneous data lakes, capability to extract, transform, enrich and correlate data from multiple systems or IOT sensors.

Virtual data warehouse

Traditional data warehouse solutions developed by enterprises in order to be able aggregating and keeping data snapshots for relevant metrics and calculated valued are difficult to extend and interconnect especially when the data sits in different clouds / data centers.

A new bread of solutions emerged: Virtual data warehouse which acts as a virtualization layer between the data structures, the aggregation layer and the information extraction. It is also referred as “Modern data warehouse” and one important feature is the capability to capture in stream data , enrich it and aggregating it on the fly.

Virtual Data warehouse (design, build & operate)

• Structured data from ERP, ServiceNow, Jira, Salesforce, SuccessFactors,
• Standardize data model & dimensions across systems
• Design data marts, define new measures & KPIs.
• Define & optimize virtual data warehouse combining multiple data sources

Data Lakes (design, build & operate)

• Gather, aggregate massive amounts of raw unstructured / non-relational data.
• Collect & Enrich types from sensors, web, devices, logs, sniffers.
• Archive for historical data.
• Corelate non-relational data with relational data.
• Test ML algorithms to detect patterns, anomalies, produce forecasts.

Master Data Capabilities Management

• Expertware developed and integrated master data management solutions for large customers (5000+ users)
• Information gathered from multiple data sources (monitoring, cloud, system centers, active directories) is normalized, cleansed and made available to subscriber applications in real time.
• It acts as an “asset management golden set” ensuring that historical details are preserved, and inconsistencies remediated automatically.
• Eliminates data inaccuracy and fragmentation laying the foundation for true business intelligence reporting across heterogenous systems.
• Master Data Services extended to customer, supplier data. ERP is the master systems and ITSM, Sales, Operational systems are subscribers and contributors

Competences

• Microsoft Data Platform and Big Data Gold Partner
• T-SQL Design and Development
• ELK, Kusto, Python, R
• Microsoft Master Data Services
• Virtual data warehouse: Azure Synapse, Business Objects Universes, SAP BW, Snowflake.
• ETL\ELT: Microsoft Azure Databricks, SAP Business Objects Data Services
• Business intelligence & data warehousing, MS OLAP, SAP DWH, Hana
• Formatted reports: SAP Business Objects, Crystal Reports
• Live dashboards: Power BI, Kibana, Grafana, SQL Reporting services

KPIs