Dedicated IT professional with exceptional data warehouse, database, and business intelligence experience.

Core competencies include:

  • 7 years of Data Warehousing ETL experience using Informatica Power Center 9.5/9.1/8.5/7.1.
  • Experience working on relational databases such as Oracle 10g/9i SQL Server 2008/2005/7.0 Sybase 12 11.0 IBM UDB DB2 8.0/7.0 and MS Access.
  • ETL/Informatica Developer with comprehensive IT experience in Analysis design development and Implementation of Business Intelligence solutions using Data Warehouse techniques ETL OLAP OLTP Client/Server and Web applications on Windows and Unix platforms in various verticals.
  • Extensive work experience with Powercenter configuration and migration.
  • Possess expert level skills in scripting across the UNIX and windows environment.
  • Extensive experience in Data Modeling using Erwin.
  • Dimensional Data Modeling expertise using Star Snow Flake schemas.
  • Experience working on Dataquality tools Informatica IDQ 9.1 Informatica MDM 9.1 .
  • Expertise in working with various sources such as Oracle 11g/10g/9i/8x SQL Server 2008/2005 DB2 8.0/7.0 UDB Netezza Teradata flat files XML COBOL Mainframe.
  • Business Intelligence experience using Business Objects 6.5/6.0 and ProClarity.
  • Extensive experience with SQL/PLSQL.

Technical Skills

  • Data Warehousing Informatica PowerCenter 9.5/9.1/8.5/7.1 Informatica Data Quality IDQ Informatica Power Analyzer ETI Specialist SSIS Mapping Analyst Excel OLAP OLTP CUBES
  • Data Modeling Erwin 4.1/ Sybase Power Designer 12 TOAD
  • Business Intelligence Business Objects 6.5 ProClarity DataNomics Crystal Reports 9/10/11 Business Objects XI/6.5
  • Scheduling Tools Autosys Espresso 4.2 Informatica Powercenter Scheduler
  • Programming SQL PL/SQL UNIX Shell Scripting VBScript XML C
  • Databases DB Tools Oracle 10g/9i SQL Server 2008/2005/2000 SYBASE 12.5/11.0 IBM UDB DB2 8.0/7.0 Toad 9.7.2 Sybase Power Designer Embarcadero Rapid SQL 7.4.2
  • Operating Systems Windows 2000/XP Sun Solaris 5.10/5.5
  • Financial Applications Fortent Search Space Trade Link REM