Enterprise BI Data Warehouse Architect / ETL Engineer

United Parcel Service (UPS) (Consultant)

May 2003 – May 2004

• 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.