Home United Parcel Service

Spotlight Module Content with Image

 

Newsflash 4

Knowledgy Solutions of Atlanta, Ga opens offices in New York!

 

Predictive Analysis with SQL Server 2008

Predictive Analysis with SQL Server 2008I've always found predictive analysis and data mining to be interesting and fun. I feel like a child walking through a cave amazed at the disoveries they are finding. So I couldn't wait to play around with the new predictive analysis tools in SQL Server 2008 Analysis Services. SSAS provides a complete data mining platform that is easy and fun to use. Organizations can use SSAS to infuse insight and prediction into everyday business decisions. The 2007 Office system uses Pervasive delivery through the Data Mining Add-Ins. These tools are a blast to use and will help you uncover knowledge hidden in your data. The comprehensive development environment and extensible range of innovative data mining algorithms combined with the enterprise-level scalability and manageability of SQL Server Analysis Services makes SQL Server 2008 an ideal and easy way to bring the benefits of predictive analysis to your enterprise. The predictive analysis capabilities of MSSQL 2008 makes it easy to incorporate intelligence into reporting, data integration, OLAP analysis, and business performance monitoring. It will help your business drive increased business agility, create a tangible competitive advantage and bottom line, grow revenues. The ability to extend the data mining technologies of SQL Server through custom algorithms and visualizations, together with the ability to embed predictive functionality into line-of-business applications makes SQL Server 2008 a powerful platform for introducing predictive analysis into existing business processes to add insight and recommendations into every operation.

 

Per-Se Technologies

DBA / Database DeveloperPer-Se Technologies (formerly Medaphis Corporation)Aug 1998 - Sept 2000DBA providing administration and security services, SQL, T-SQL and PL/SQL development, complex query development, performance analysis and SQL optimization for over 100 Oracle and SQL Server database instances reporting and ad hoc querying.
Ulti Clocks content
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.