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.