Geoffrey Clark
Portland, OR 97211
503-***-**** mobile
503-***-**** gvoice
**********@*****.***
http://www.linkedin.com/in/jofkuraaku
SUMMARY - I offer excellent analytical and data management skills focusing
on quality, coupled with solid business experience and insight. I value
proactive planning, long-term thinking, and clear communications.
EXPERIENCE - selected list; a complete history is available.
Senior Business Intelligence Manager, Con-way Freight
(Portland, OR / Ann Arbor, MI) - February 2010 to Septermber 2010
. Our team of BI analysts works with C level executives and functional
directors to clarify objectives, designing metrics to measure processes,
negotiate priorities, estimate timelines & set expectations, build &
maintain reports, dashboards & scorecards for:
. City Pickup & Delivery Operations Performance Management
. Linehaul Operations Simulation, Decision Support & Performance
Management
. Pricing Strategic Decision Support & Performance Management
. Sales Productivity Tools & Performance Management
. Marketing Segmentation & Customer Behavior Predictive Analysis
. Safety Policy Compliance & Performance Management
. We collaborate with & mentor our IT partners in these critical areas:
. Normalized, Integrated, low latency EDW design
. Clear, Usable, Comprehensive BI semantic layer
. Reliable, Scalable, High Performance, In-Memory BI operations
Awards & Recogntion:
. CIO100 Advanced Predictive Analytics and Strategy Execution Award
. Netezza in Action at Con-way Freight Case Study
Business Intelligence Manager, Con-way Freight
(Portland, OR / Ann Arbor, MI) - November 2007 to February 2010
. I lead a team of eight BI Analysts, mentoring them in BI and database
technologies, to prioritize and answer tough business questions
accurately and quickly.
. We collaborated with our IT team to design our data infrastructure,
implement that design in our EDW (Netezza), and design and build a
complete semantic layer in our BI tool suite (MicroStrategy).
. We listened to business users frustrated by data quality challenges, and
tracked issues back to the source, to be resolved through technology or
process improvement.
Awards & Recogntion:
. MicroStrategy Advanced Analytics at Con-way Freight Annoucement
. Third Place Manager, 2009 Voices Survey at Con-way Freight
Enterprise Project Manager, Con-way, Inc.
(Portland, OR / Ann Arbor, MI) - April 2007 to November 2007
. I participated in corporate strategy sessions, illustrating choices with
data visualizations.
. I responded to competitive challenges by creating monitoring reports
using regression analysis to help make time-critical pricing decisions.
. I led the technical evaluation of Business Intelligence tools through a
POC with our data.
Data Architect, Vector SCM (Portland, OR) - March 2004 to April 2007
. Our team transformed data into information. Through analysis and
business knowledge, we designed the integrated information infrastructure
all functions within the company.
. We created an integrated logical model describing our business, then
designed physical database structures with standards and architectural
knowledge.
. I formed and led a virtual, global and cross functional team of data
stewards, which identified issues, assessed risk, then prioritized and
resolved data quality issues.
Systems Analyst II, Vector SCM (Portland, OR) - October 2001 to March 2004
. I liaised between supply chain partners, including the client, 3PLs,
carriers, technology service companies and internal functional groups.
. I provided content design and requirements for high volume B2B interfaces
and application network were provided.
Systems Analyst I, Vector SCM (Portland, OR) - May 2001 to October 2001
. We collected, analyzed and rationalized data from multiple complex legacy
systems across GM's global divisions.
. I studied, selected and applied logistics industry data standards to our
data infrastructure.
. We defined and built global supply chain design, sourcing, visibility
compliance software.
Logistics Engineer, Vector SCM (Portland, OR) - July 2000 to May 2001
. We performed data analysis to generate business cases for improvement of
the General Motors global supply chain. Several examples follow.
. We modeled and optimized North American distribution networks,
synchronizing our model with transport route optimization models to form
a holistic solution ~ $1 million per year.
. We modeled and optimized the International Operations network, reducing
consolidation centers in Europe from seven to two ~ $20 million per year.
. We acquired and analyzed data on expedited shipments, re-engineered
processes, and implemented systems, the use of which reduced air charters
~ $12 million per year.
Breakbulk Agent, Expeditors International (Portland, OR) - September 1998
to January 1999
. I tracked global air cargo and related documents with airlines & freight
forwarders.
Assistant Customs Broker, Seino America (Renton, WA) - March 1997 to April
1998
. I prepared US Customs filings using the US Harmonized Tariff Schedule
(USHTS), monitored the clearance process, tracked global air cargo,
managed multi-mode cross-country transportation and related accounting.
. I worked closely with Japanese nationals.
EDUCATION - selected list; a complete history is available
Master of Business Administration (MBA), Portland State University, June
2000
Supply Chain Management & Logistics, International Finance, Cost-Based
Accounting.
Bachelor of Arts in Economics (BA), University of Washington, August 1996
Econometrics, Game Theory, Calculus, Chemistry, Physics, Astronomy,
History, and Japanese.
RELATED SKILLS
Operating Systems & Desktop tools:
. MS Widows (3.1, 95, 98, NT, XP, 7), DOS command line
. MS Office ('00 > '07) - Excel, Access, Word, Visio, Powerpoint, Outlook,
Project
. Mac OS X (10.3 > 10.6), UNIX command line
Relational Database Systems:
. Oracle (7i > 11g): Oracle standard SQL expert, Toad & SQL Developer, SQL
Loader
. Teradata (V2R3 > V2R6): ANSI standard SQL expert, SQL Assistant user
. Netezza (4.5.2 > 6.0): physical design for MPP, AQT and Aginity user
. ERwin (3.5 > 4.1 > 7.2): Logical model design & Business Process mapping,
Physical design, performance indexing and compression, DDL generation,
UDFs for data mapping.
Business Intelligence & Reporting Tools:
. MicroStrategy 8/9 Business Intelligence suite - all aspects, expert
. Tableau - expert
. Qlikview - evaluated
. Pentaho - evaluated
. Cognos - evaluated
. MS Access & MS Excel expert - Macros, Graphs, Formulas, Data Analysis
Functions
Modeling & Analytics Tools:
. Teradata Data Miner
. GIS systems - MapInfo, Google Earth, MS MapPoint
. GAMS (Generic Algebraic Modeling System) for optimization with CPLEX
. CAPS Supply Chain Designer and Transpro
. Multiple logistics vendor evaluations including Synquest, Descartes,
Inttra, and many other supply chain, logistics and transportation
systems.
Data & Standards:
. UN/EDIFACT standards - DELFOR, DELJIT, IFTSTA, IFTSAI, DESADV, RECADV
. ANSI/X12 standards - 830, 862, 856, 214, 315, and others
. ISO standards, including:
. iso31 uom
. iso3166 nations & subdivisions
. iso4217 currencies
. iso6709 geo location data
. UN/ECE - UN Location Codes
. WCO - Harmonized Tariff Schedule and product classification techniques
. NMFTA - Standard Carrier Alpha Codes (SCAC)
. SMC3 - NMFC Freight Classification
. SMC3 - Czarlite tariff, and other LTL tariff data
. IATA - Flight data (from OAG or Innovata), Dangerous Goods
. JOC - Ocean Sailing Schedules
. INCO - International Commercial Terms
Languages:
. English fluency
. Japanese proficiency
MEMBERSHIPS
VP Communications, DAMA Portland, October 2006 to April 2007
Nidan, Shotokan Karate of America, July 1995 to present