Home Ford Motor Co

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

Lead Master Data Management Architect / Sr. Data Modeler / Sr. ETL Engineer - Consultant

Ford Motor Company (APCO Division)

July 2008 – Nov 2008

Technology: Sql Server 2005/2008, SSIS, ERwin, T-SQL, SQL, ETL, OLTP, OLAP, MOLAP, PL/SQL, Visual Studio, VB, Team System for Database Professional, XML, SMO, SQLCMD, Business Objects XI, Crystal Reports, all Embarcedero DB tools, Clustering, Replication

  • Model, design and roll out Ford’s first centralized Master Data Management (MDM) database repository integrating finance, manufacturing, customer, accounting, dealership, warranty, service, sales and marketing lines of business.

  • Completed database will reduce application development time, eliminate data anomalies and redundancies, reduce administration and maintenance costs, increase performance and is projected to lower operating expenses saving $500,000 - $650,000 annually.

  • Engineered data mining MOLAP systems to mine data from international data stores for knowledge discovery and customer trending to discover new areas for cross market selling and increasing revenue.

  • Develop ETL processes for collecting, consolidating, aggregating, quality-assuring, persisting, matching and distributing data throughout the enterprise and ensure consistency and control in the ongoing maintenance and use of this information.

  • Reverse engineer legacy databases; integrate all existing data models, data flows and data dictionaries into new Meta-Data Repository.

  • Conduct interviews with end-users and subject matter experts to gather and document data requirements and translate business rules into normalized conceptual, logical and denormalized physical data models.

  • Responsible for change control management, daily development/test database roll outs, security, data access, data names and definitions.

  • Conduct conformed facts and data model review meetings and act as liaison between development teams and business stakeholders.