Home United Parcel Service
PDF Print E-mail

Enterprise BI Data Warehouse Architect / ETL Engineer

United Parcel Service (UPS) (Consultant)

May 2003 – May 2004


Sql Server 2005/2008, SSIS, BizTalk, Visual C#.NET, PHP, Visual Basic, .NET, ASP.NET, ADO.NET, XML, SQL, T-SQL, Team System Foundation


  • Designed BI system that uncovered $180,000 of lost sales revenue.
  • Designed Sales Lead Measurement Initiative BI database System that directly increased revenue and customer retention rates by 20%.
  • Engineered Cold Fusion and SQL Server real-time package tracking and intelligent routing systems handling 3.35 Terabytes of live transactional data.
  • Automated SQL Profiler to trace database activity and find inefficient queries. Analysis of execution plans, disk I/O, DBA instance statistics and redesign of code improved system response times by an average of 50 %.
  • Integral developer on the OLAP/BI team, established data granularity standards, designed and built star and snowflake dimensional models during Customer Volume and Behavior Analysis Tool architecture and implementation.
  • Analyzed upper management’s informational needs to calculate Sales, Operational and Financial KPI’s.
  • Led meetings to conform facts and common objects among disparate databases and implemented a standardized international Decision Support System reducing future maintenance and administration costs by 15%.
  • Involved in Full Life Cycle development of Small Segment Acquisition and Sales business opportunity, built and coded complex T-SQL, PL/SQL, SQL, Embedded SQL, XML, J Script programs and DTS packages for the ETL processes.
  • Adhered to proven incremental development methodology for design of Data Warehouses and XP (Extreme Programming) like methodology of rapid deployments, small incremental changes and real-time testing of designs and code providing benefits to UPS end-users virtually the moment I started there and also kept projects focused.
 

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.