Lead Master Data Management Architect / Sr. Data Modeler / Sr. ETL Engineer - Consultant
Ford Motor Company (APCO Division)
July 2008 – PresentTechnology: 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.
|