BUSINESS INTELLIGENCE - DATA WAREHOUSING - ETL


Business Intelligence - Data Warehousing - ETL - Reporting

Technology Expertise

Informatica PowerCenter and IBM Infosphere Datastage
  • Architecture and implementation of Data warehouse loads and interfaces
  • 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
  • Big data integrations
  • Workshops, trainings, best practices and guides
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, Kafka streaming
Oracle data warehousing
  • Oracle optimization, tuning, pl/sql procedures
  • Data Vault modeling and implementation
Salesforce.com (SFDC)
  • Data migrations and data integration processes (using Informatica PowerCenter ETL, Oracle, Pentaho Open Source, Apex Data Loader, Force.com Excel Connector)
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
Pentaho Open Source BI
    Pentaho as an end-to-end, cost-effective Business Intelligence information environment, which includes:
  • Data Integration (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
Microsoft
  • SSIS ETL - Integration Services
  • SSRS - Reporting Services
  • SSAS - Analysis Services
  • use of Microsoft Excel in BI
Denodo data virtualization