Team Lead Business Knowledge and Solutions Architect - Consultant

May 2004 – Oct 2004

Oracle, Sql Server 2000, DTS, ERwin, Toad

LabLynx client, U.S. Alcohol Tobacco and Firearms (ATF): Engineered automated Informatica Extraction, Transformation and Load (ETL) systems, cleansing routines and data mining forensics from heterogeneous databases into SQL Server and Oracle data warehouses.
SQL, T-SQL, PL/SQL, ActiveX, ASP, ADO, OLE DB, XML, ODBC, VB, VB Script code written using Query Analyzer, Toad, Visual Studio and Procedure Builder IDEs’ and Data Transformation Services (DTS) to run ETL systems and Business Intelligence Web Services. Actuate and Active Reports used for reporting.
Performance tuned conceptual data models and implemented physical designs, improving query execution times, in some cases, from 10 hours down to 15 minutes.
Conducted Sql Injection penetration testing and auditing on internet mortgage loan web servers and web sites.
Used CA’s Erwin and Embarcadero’s ER Studio data modeling tools to engineer logical, conceptual and physical DB2, Oracle and SQL Server relational databases and MS Analysis Services multi-dimensional databases.
Traced long running queries, investigated execution plans then performance tuned indexing, partitioning, parallel execution, bulk loading techniques and re-engineered SQL, T-SQL, PL/SQL packages, procedures, functions and triggers increasing data access performance of middleware applications (ASP, ADO, VB, VBScript, OLE DB).

SearchSQLServer: Expert advice on database development

Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more.

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.