Manager Project

Stephen M. Clerk

*** * ********; Redondo Beach, CA.; 90277

310-***-****; ******@***.***;

Professional Summary:

1. Over 15 years of BI/DW related experience and most recently 6 years of

functional BI management experience. As a Department Manager, create

and lead teams of ETL - Informatica developers, BI - Business Objects

specialists, and architects.

2. Responsible for Client Interface with internal customers. Developed

requirements definition and managed full lifecycle application

development with continuous involvement of internal customers. Have

delivered several large scale projects.

3. Possess strong technical understanding of dimensional data modeling,

design and architecture principles.

a. Experience leading facilitated sessions with business and

technology representatives in order to design and/or modify

various data warehouse models.

b. Worked with Ralph Kimball on 2 data warehouse projects in Los

Angeles

c. Proficient with both 3rd normal form and Star Schema data

modeling techniques including snowflake schema, cube design, ODS

and Dimensional or Aggregate structures.

d. Several years of experience with ERWIN.

e. Developed Data Governance procedures and served on the Data

Governance Committee.

4. Several years of analyst and ETL development experience using

INFORMATICA and Sagent Technology.

5. Experience with ORACLE, SQL Server, TOAD, and Enterprise Manager.

Professional Work History:

2006 - 2009: Department Manager - Data Warehouse Yamaha Motor:

. Manage and lead a data warehouse and business intelligence team. The

team consists of Analysts, Architects, ETL developers, and

presentation object developers.

o Develop and maintain strong relationships with internal

customers who are senior functional management - up to President

level.

o Direct departmental activities and manage staff for full

lifecycle BI project development.

o Perform project planning, develop and manage budgets, staffing

plans, conduct performance reviews and development plans.

Resume for: Stephen M. Clerk page 2

2004 - 2006 Enterprise Analytics Manager - Ameriquest Mortgage:

. Manage and lead a business intelligence team. The team consists of

ETL developers, presentation object programmers and data modeler.

. Performed extensive interviews of executives (V.P. level) and

management in order to develop a requirements definition for submarts.

. Manage the development of the dimensional database design to meet all

requirements defined in the Analysis phase.

. Oversee the development and maintenance of the dimensional model in

Erwin;

. Perform QA activities at the database level using TOAD to validate

accuracy;

2002 - 2004 Lead DW Architect Boeing - ConneXion by Boeing:

. Performed extensive interviews of executives (V.P. level) and

management in order to develop a requirements definition for the

Enterprise-Level Data Warehouse.

. Performed Source Data Analysis to develop data definition and

availability to support the defined requirements.

. Developed the dimensional database design to meet all requirements

defined in the Analysis phase.

2000 - 2002 Principal Consultant Sagent Technology:

. Performed lead DW architect and project management responsibilities

for Sagent's client companies.

. Responsibilities included interfacing with C-level and senior

management of medium sized businesses to perform pre-sales

presentations and post-sales requirements definition.

. Developed dimensional database design solutions.

1998 -1999 BI Sales Executive IBM:

. Performed Solution based sales for large corporations in the US

southwestern district. Sales responsibilities included Professional

Services, hardware and software.

Resume for: Stephen M. Clerk

page 3

1993 -1997 Project Manager and Lead Datawarehouse Architect Sequent

Computer

. Worked with Ralph Kimball on datawarehouse projects in Los Angeles

thus acquiring outstanding dimensional database design skills.

. Performed design of Data Warehousing Architecture and Management of

activities for project teams between 2 to 20 consultants. Developed

the datawarehousing methodology for the DSS practice at Sequent.

. Taught dimensional modeling class to new data warehouse consultants

and to external clients like New York Life.

. Managed the development of datawarehouses in an ORACLE / UNIX

environment. Typical engagements lasted 6 to 9 months.

1992 - 1993 Senior Manager SHL Systemhouse Inc

1990 - 1992 Manager of Information Technology Consulting Price

Waterhouse - LA

1988 - 1990 Technical Computing Analyst EXXON Chemical Company - New

Jersey

1982 - 1988 Manufacturing Systems Engineer McDonnell Douglas Co.- St.

Louis

Education:

1994 Certification of Proficiency in C/UNIX

University of California at Los Angeles

1981 Master of Business Administration

Operations Research and Finance

University of Missouri

1979 Bachelor of Science in Chemical Engineering

University of Missouri

Contact this candidate