
Technologies
Technology Expertise
Snowflake Cloud
- Snowflake Cloud Data Warehousing
- Data Vault 2.0 implementation in Snowflake database
- Transition from the traditional BI tools to Agile, Real-Time Business Intelligence solutions in the Cloud
- Tableau Desktop and Tableau Server
- Preparation of data sources (TDE extracts, TDS), integration with data virtualization tools and Big Data
- Analysis, visualizations, dashboards, custom calculations
- Big Data integrations - lambda and S3 processes
- Oracle optimization, tuning, pl/sql procedures
- Data Vault modeling and implementation
- Architecture and implementation of Data warehouse loads and interfaces
- Big data integrations - loading cloud data warehouses (including real time), S3 integrations, Lambda
- Data migrations and cleansing processes
- Review of the existing work and optimization of the ETL processes
- Enhancements and migrations to the new versions
- Tuning and repair - aligned with the RDBMS used by an organization
- Custom coding - to handle company specific processing issues
- Automated ETL processes generation
- Workshops, trainings, best practices and guides
- Data migrations and data integration processes (using Informatica PowerCenter ETL, Oracle, Pentaho Open Source, Apex Data Loader, Force.com Excel Connector)
- Logical Data Warehouse engineering with Denodo data virtualization
-
Pentaho as an end-to-end, cost-effective Business Intelligence information environment, which includes:
- Pentaho Data Integration (PDI, Spoon) - ETL processes which control the data flow from source systems into a data warehouse
- Dashboards and management cockpits - embedded into an informational portal
- Dynamic multidimensional OLAP analysis and information delivery
- Static, pixel-perfect reporting
- SAP Business Objects, Crystal Reports, SAP BW and Business Objects integration
-
Cognos Enterprise Performance Management solutions:
- Cognos 8 and Cognos 10 Business Intelligence - metadata modeling with Framework manager, report and analysis design, Cognos Connection portal administration
- Cognos PowerPlay and PowerPlay Transformer - powercubes modeling, optimization, automation
- Microsoft SQL Server databases
- SSRS - Reporting Services
- SSAS - Analysis Services
- use of Microsoft Excel in BI