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.

 
 

Knowledgy SQL RSS

SearchSQLServer: Expert advice on database development
Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more.
SearchSQLServer.com
  • Utilize SSAS for data predictions and classification using Excel
    Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007. Useful reading for users who are not typically creating data mining algorithms and SAS/SCL programmers

  • The sqlcmd utility in SQL Server
    The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures. Robert Sheldon provides a guide to getting started using sqlcmd in interactive mode, and shows you have to use sqlcmd in Management Studio.

  • Top 10 SQL Server Tips of 2008
    Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data conversions, these are the most viewed SearchSQLServer.com tips of the year.