Home Ford Motor Co
PDF Print E-mail

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

Ford Motor Company (APCO Division)

July 2008 – Present

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.

 
 

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.