BUSINESS INTELLIGENCE - DATA WAREHOUSING - ETL


Business Intelligence - Data Warehousing - ETL - Reporting

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
  • 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
 AWS Amazon Redshift
  • Big Data integrations - lambda and S3 processes
 Oracle data warehousing
  • Oracle optimization, tuning, pl/sql procedures
  • Data Vault modeling and implementation
ETL - Informatica PowerCenter, Microsoft SSIS and IBM Infosphere Datastage
  • 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
 Salesforce.com (SFDC)
  • Data migrations and data integration processes (using Informatica PowerCenter ETL, Oracle, Pentaho Open Source, Apex Data Loader, Force.com Excel Connector)
Denodo data virtualization
  • Logical Data Warehouse engineering with Denodo data virtualization
Pentaho Open Source BI
    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
  • SAP Business Objects, Crystal Reports, SAP BW and Business Objects integration
 IBM Cognos BI
    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
  • Microsoft SQL Server databases
  • SSRS - Reporting Services
  • SSAS - Analysis Services
  • use of Microsoft Excel in BI