Home ING Financial
PDF Print E-mail

Senior SQL Business Intelligence Systems Architect - Consultant

ING Financial Services

Sept 2007 – July 2008

Sql Server 2005/2008, SSIS, Proclarity, Visual PHP, Visual Basic, VB.NET, ASP.NET, ADO.NET, XML, SQL, T-SQL, Visual Studio 2005, Team System Foundation, Analysis Services, MDX, Reporting Services, Clustering, Replication

  • Designed and implemented large-scale global data warehouse and associated data marts for the ING Financial system.
  • Developed ETL framework standard for automating SSIS development which increased employee productivity over 100%
  • Developed financial business intelligence data mining dashboards accessing multidimensional database cubes mining 1.5 terabytes of real time stock market data.
  • Developed automated data capture processes and systems for regulatory reporting, operations analysis, governmental compliance reducing manual operating expenses $150,000 - $250,000 annually.
  • Took lead role in writing the DRM (Data Reference Model document) for the data warehouse architecture.