Data Management

WILLIAM G HERBERT

Data Analyst

**** ********* **., #***

Bloomfield Hills, MI 48301

Email: *******@*****.***

Phone: 248-***-****

PROFESSIONAL SUMMARY

Mr. Herbert has more than 20 years of professional experience as a Data Analyst, Systems Engineer and Algorithm Designer with a

recent focus on the automobile and steel industries. He has extensive experience working in the dotNet environment and in a variety of

database frameworks. He has developed numerous relational databases and mined data from those databases for many client purposes

including: Supply chain management, financial reporting, identification of lean manufacturing best practices, inventory tracking, detection

of warranty fraud and abuse, failure mode and effect analysis (FMEA), data modeling and vehicle algorithm design. Together with strong

written and oral presentation skills, Mr. Herbert is also experienced in data import/export (ETL), statistical analysis, construction of analytic

data cubes, hypothesis test/data reporting and the development of web-based reports. He is proficient in the use of semantic

technologies, including ontologies and semantic markup languages that enable machines to "understand" and better respond to complex

human requests and queries. His prior clients include Ford Motor Company, General Motors, Chrysler Corp., US Department of

Transportation, Eaton Corp and Severstal NA Steel Company. His education includes a B.A. in Mathematics, an M.S. in Applied Science,

and an M.S. in Computer Science and Engineering.

SPECIFIC AREAS OF EXPERTISE

Creation and tasking of large relational databases, tables and views to support complex business rules.

Complex SQL scripting, queries and database normalization methods

Statistical Analysis, Data Mining, Pattern Recognition, Regression, Classification, Clustering

Risk Analysis: Failure Modes and Effects Analysis (FMEA)

Modeling and visualization of complex physical systems and phenomena

Systems Analysis for development of lean manufacturing best practices

Development of Expert Systems (Decision Support Systems), Computer Tools and Intelligent Agents

Using ontology editors and taxonomy management systems to define and describe relationships among complex data objects

TECHNICAL SKILLS AND TOOLS USED

• • •

MS Visual Studio 2008 - 2012 Business Intelligence Semantic Technologies

• • •

MS dotNet Framework Dashboards Sensor Networks

• • •

MS SQL Server 2000 - 2012 Customer Relationship Management XML, RDF, OWL

• • •

ETL with MS SSIS & DTS Customer Lifetime Value Analysis SPARQL Query Language

• • •

MS SSAS Data Cubes Software Revision Control Semantic Markup Languages

• • •

MS SSRS Reports Matlab Object Oriented Dev. w C++

• • •

MS Excel/Pivot Tables Data Modeling Transportation Modeling

• • •

Relational DBs: MS SQL, PostgreSQL Eclipse IDE Microsimulation

• •

Oracle, MySQL Collaborative Team Software Tools: GPS Technologies

Confluence, JIRA

ADITTIONAL SKILLS

Experienced in planning and executing data mining and data analysis projects

Able to translate business requirements into technical specifications

Strong Analytical skills enable the development of solutions that address technical specifications

Experienced in communicating with client management as well as multi-function project technical resources

Critical thinking skills facilitate taking projects to the next level of excellence and innovation

1

Ability to multi-task while maintaining a strong focus on meeting deadlines

WORK EXPERIENCE

Senior Data Analyst/Systems Engineer, Cognometrics, 12/2003 – Present

Roles and Responsibilities:

Develop Intelligent Transportation Algorithms and simulation models

Develop AI/Expert Systems for decision support in scientific, business and behavioral domains

Create learning algorithms, design and implement computerized/intelligent tools and manage development projects

Set up, maintain and back up large SQL databases of automotive data and geographic information

Perform data mining, statistical analysis and scoring of large data collections

Conduct primary and secondary research

Write scientific papers, technical reports/documentation and training support materials

Develop propensity models for product design, customer relationship management and market research

Recent Projects

Developed SSRS Reports to optimize Ford Motor Global Supply Chain Management (11/2013 – 2/2015)

Created reports to Identify and classify production capabilities of all plants worldwide. Calculated plant capacities and upper limits of

production under a variety of assumptions, forecasts and scenarios for retail and wholesale demand, product mix, plant staffing and

capacity constraints. Provided consulting, technical support and best practice recommendations to the Global Capacity Management

Report Development Team Developed SSRS tools for management of production scenarios.

Tools used: MS SSRS and Excel Pivot Tables.

Quality Control/Web Deployment of all Ford Motor Capacity Management reports (3/2014 – 2/2015)

Responsible for deployment to the Ford Motor Web Portal of all Corporate Global Capacity Management SSRS Reports. Developed and

maintained HTML pages for the formatting and display of reports. Created, implemented and administered quality control standards for

report development and deployment. Quality control included creation of SQL scripts to be used by all developers to test the accuracy of

report data. Developed diagnostic queries/reports to troubleshoot reporting scenarios. Created and maintained a version controlled

inventory of all corporate capacity management reports

Tools used: dotNet framework using MS SSRS and HTML. AccuRev version control

Created a Web-Based, Dashboard Expense Reporting System for Severstal NA (1/2013 - 11/2013)

Developed and implemented a system to allow finance managers and line production managers to monitor, via a web-based report,

current status of all expenditures as compared to plans and forecasts. The system was constructed to automatically access corporate

databases to refresh the dashboard databases, and to provide a summary dashboard report with two levels of drill-down capability: 1)

from the corporate level to the Business unit level, and 2) from the business unit level to the discrete expense line item.

Tools used: dotNet framework utilizing MS SSIS and SSRS.

Created an Analytic Cube to evaluate Severstal NA Corporate Shipping Function efficiency (5/2012 - 3/2013)

Developed a Data Warehouse using a Fact/Dimension Model that describes the Corporate Shipping function in terms of metrics including:

Products, Orders, Inventory Location and Shipments. Created ETL packages to import data, and SQL stored procedures to assemble data

into Fact and Dimension tables. Developed Work-In-Process and Shipment Cubes and exported Cube data into Excel Pivot tables for use

by end users. Tools used: MS SSAS cubes, MS Excel Pivot Tables.

Created a Prototype Semantic Database of Severstal NA Steel Products (4/2012 - 12/2012)

This research project involved the creation of a database and an ontology that described the products, product characteristics and

relationships among a small subset of Severstal steel products. The project also included a query function. Semantic definitions in the

ontology gave meaning and definition to the database elements. Because these meanings could be incorporated into queries, users could

easily and intuitively construct more powerful queries than possible with traditional relational databases that consist entirely of opaque

data. Tools used: Ontology, Protege Ontology Editor, Semantic Markup Language, SPARQL query language, PostgreSQL database.

Data Analysis to Detect Fraud and Abuse of Chrysler Corporation Warranty Program (5/2011 - 1/2012)

Reviewed Chrysler's dealer warranty program and performed statistical analysis of operational data to detect aberrant dealer behavior and

reduce warranty cost. Performed statistical sampling of labor and parts cost for various repair groups to determine whether use patterns

fell within anticipated and acceptable ranges. Evaluated dealers and corporate warranty processors with respect to financial performance,

efficiency and error rates. Evaluated warranty data to assess adherence to lean manufacturing principles. Tools used: MS Access,

MS Excel, Pivot Tables, MS Visio, Minitab.

2

Search Engine Optimization, Research and Technical Writing for AB Marketers (5/2010 - 3/2011)

Conducted research and analysis regarding the development of marketing copy and the identification and placement of keywords to

improve the ranking of the company's online advertising placements with respect to Internet queries and searches. Investigated global

and local search volume and cost per click metrics to identify optimum keywords for high rankings in selected product categories.

Incorporated keywords into sample copy. In support of this work, conducted extensive research into current methodologies for discovery

and ranking of web-based data. Tools used: Google PageRank, MS Excel

Analysis/Improvement of Heavy Truck Crash Avoidance System (FMEA) for Eaton Corp (4/2009 - 12/2009)

Using FMEA methodology, performed data mining, data analysis, and data modeling to identify causes of high incidence of crash warning

alerts detected during Eaton's Integrated Vehicle-Based Safety Systems (IVBSS) Field Operational Test. Used a fusion of vehicle state

sensor data, radar and lane sensing camera data, Eaton proprietary time-sequence visualization tools and SQL databases. Identified

sources and causes of crash warning alerts in terms of: equipment design/performance failures, environmental conditions and driver

behavior. Recommended corrective actions, and monitored vehicle performance after adjustment to determine whether faults had been

corrected. Tools used: MS SQL2005/2008, MS DTS, Matlab, MS Excel, Pivot Tables, Google Earth

Transportation Modeling for the U.S. Dept of Transportation’s Federal Highway Administration – (03/2008 - 03/2009)

Developed an Intelligent Software tool that modeled and simulated the behavior of autonomous driving vehicles (i.e. vehicles equipped

with automated lane-keeping) within the FHWA TRANSIMS System (Transportation Analysis and Simulation System) an open-source

transportation modeling tool that allows transportation researchers to simulate and investigate the performance of traffic networks in major

U.S. cities. Tools used: C++, Eclipse Integrated Development Environment, Software Revision Control (TortoiseSVN

Subversion), MS Visio

Conducted several Research & Development and Data Analysis Projects for General Motors (4/2004 - 02/2009)

• Database Development and Analysis

Utilized NAVTEQ map data and GM naturalistic driving data to create and administer a GIS relational database. Wrote

o

SQL scripts and developed algorithms to extract key data elements. Developed an expert system that inferred the geometry of

Michigan roads. Tools used: MS SQL, MS DTS, MS Excel, MapQuest, GPS

Administered, maintained and conducted data mining on a large database of naturalistic driving data. Imported/created

o

new tables and performed database backup. Created SQL queries to extract, analyze and score data to provide support to

various GM research initiatives. Tools used MS SQL Server, MS SQL

• Member of the Project Team that developed the General Motors Forward Crash Warning system

Performed data mining, statistical analysis, predictive modeling. Used map databases, GPS data and, from the CANBus, a

fusion of vehicle state data, radar data, lane sensing camera data to create algorithms for path prediction and forward crash

warning. Coauthored several scientific papers and the project final report submitted to National Highway Traffic and Safety

Administration (NHTSA). Tools used: MS SQL, Matlab/Toolboxes, MS Excel, Pivot Tables, V-Tool (GM proprietary

time-sequence visualization tool), CANBus vehicle data acquisition system

• Developed an Eye Gaze Classifier that measures driver distraction

Created an intelligent agent that uses driver steering input and vehicle state data to measure and categorize driver

distraction and exposure to rear-end crash warning situations. Performed pattern recognition analysis, SQL programming

and statistical analysis. Coauthored a scientific paper on study results. Tools used: MS SQL, Matlab

• Developed a Parking Lot Identifier that identifies low-speed driving zones

Created an intelligent vehicle control that detects a driving environment and prevents the resumption of an earlier-

established cruise control speed setting when it would be unsafe to do so. (GM patent applied for). Tools used: MS SQL,

Matlab, C++.

Senior Software Developer, Tixon Corporation, 6/1986 – 12/2003

Roles and responsibilities

Researched revenue collection data history for various fines, penalties and user fees in selected U.S. municipalities.

Researched state and municipal codes to determine authorized collection enforcement options in these municipalities.

Identified potential collection increases based on proper collection enforcement and efficient billing and collection processing.

Developed and implemented proprietary software packages to realize target collection levels.

EDUCATION

B.A., Mathematics, Hofstra University, New York

M.S., Applied Science, Adelphi University, New York

Concentration: Applied Mathematics

M.S., Computer Science and Engineering, Oakland University, Rochester, Michigan

Concentration: Data Mining, Data Modeling, Intelligent Systems

MILITARY

3

Veteran - U.S. Army Paratrooper, 82 Airborne Division

AWARDS AND ACHIEVEMENTS

2010 U.S. Patent Application for Intelligent Vehicle Component designed for General Motors Corp

2008 Vespucci Institute Scholar

National Mathematics Honor Society (KME)

4

Contact this candidate