Skills and Experience

Technologies

Athena IT Solutions has extensive experience with the following technologies:

Database
Oracle, Microsoft SQL Server, IBM DB2, MySQL, Sybase, Informix, Oracle Rdb.

Data Integration and Extract, Transform & Load (ETL)
Informatica PowerCenter, Microsoft SQL Server Integration Services (SSIS), Informatica Cloud, Talend, Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Pentaho Data Integrator (PDI), IBM InfoSphere DataStage, SAP BusinessObjects Data Integrator, IBM Cognos and custom coding.

Business Intelligence (BI), Analytics and Data Visualization
Microsoft BI: SQL Server Reporting Services (SSRS), PowerPivot, PerformancePoint; SAP Business Objects; IBM Cognos; OBIEE Oracle BI (and Hyperion); Pentaho; Information Builders and others.

On-Line Analytical Processing (OLAP)
Microsoft SQL Server Analysis Services (SSAS), MicroStrategy, Cognos PowerPlay, Hyperion Essbase, Computer Associates Eureka.

Data Modeling
CA ERwin Data Modeler, Embarcadero ER/Studio, SAP Sybase PowerDesigner, Oracle Designer, Microsoft Visio.

Enterprise Resource Planning (ERP) – Reporting and Analytics
Oracle, SAP, PeopleSoft, Siebel, SunGuard HE (SCT) Banner, Epic, and others along with custom coded applications.

Business Applications

The Athena IT Solutions team has experience designing business intelligence and data integration solutions supporting the following business initiatives:

• Enterprise BI, dashboards, reporting and analysis
  
• Self-service BI
  
• Enterprise Data Warehouse (EDW)
  
• Predictive analytics
  
• Replacing spreadmarts and data shadow systems
  
• Revitalizing multiple data warehouses, data marts and other reporting databases
  
• Customer Data Integration (CDI) or One View of the Customer
  
• Corporate Performance Management (CPM) and balanced scorecard
  
• Customer Relationship Management (CRM)
  
• Supply Chain Management (SCM)
  
• Financial budgeting, forecasting and planning
  
• Profitability analysis
  
• Operational BI and ERP reporting and analytics