Craig O’Connor craig@dataworks-consulting.com
Data Architect 7472 Palm Avenue
Sebastopol, CA 95472
(707) 823-3490
Experience:
Data
Works, Sebastopol, CA
(9/2005-present) Principal Consultant
(see below)
Provide consulting
services:
Mentoring &
Training - Data & Process modeling, Database Administration, SQL, Standards
& Best Practices
Architectural
Planning & Review – Design validation, Software & Server Configuration,
Security, Capacity Planning, Disaster Recovery, Master Data Services
Database Analysis
& Design - Data & Process Modeling, Business Rules
Database
Administration - Installation & Upgrades, Configuration & Settings,
Performance Tuning, Replication, Clustering, Data Recovery
SQL Programming –
T-SQL, Stored Procedures, Functions, Triggers, SSIS, ETL
Reporting Solutions –
SSAS, SSRS, Power BI, Cognos, Business Objects, Microsoft
Access
Council On Aging, Santa Rosa, CA
Design and deliver redesigned cloud based Meals On Wheels management system.
Upsize
Microsoft Access application data to Azure.
Keegan & Coppin
Company, Inc.,
Santa Rosa, CA
Design and deliver redesigned cloud based property
management system.
Upsize
Microsoft Access application data to Azure.
BioMarin Pharmaceutical
Inc.,
San Rafael, CA
Implement SSIS based ETL.
Work with Commercial Operations team to publish analytics to
Salesforce, Tableau, and Power BI.
Work with team to formalize standards and implement
development and database best practices.
Kendall-Jackson Winery, Santa Rosa, CA
Implement SSIS based ETL.
Work with Business Intelligence team to improve query
performance with Power BI and Business Objects
Work with team to formalize standards and implement
development best practices.
Work with administration group to implement solid state disk
technology to improve SQL Server performance.
Gap Inc., Petaluma, CA
Design and deliver a Cognos based dashboard portal to provide visibility into CommercialWare order processing information.
Provide SQL Server ETL architecture and implement
performance tuning solutions.
Paradise Ridge Winery, Santa Rosa, CA
Provide database setup and performance tuning
recommendations.
WorkforceLogic,
Sonoma, CA
Helped design and build a SQL Server & Cognos based data warehouse as a product for approximately 30
staffing clients including Google, Yahoo, Facebook, Sony, as well as for internal use by Nelson
Family of Companies.
Recommend and implement hardware and software, and provide
architectural roadmap for meeting dashboard and reporting needs.
Authored company data
warehouse design and ETL standards.
Gourmet Mushrooms Inc.,
Sebastopol, CA
Helped design and build a SQL Server data warehouse leveraging
SSIS, SSAS, and Microsoft Access integrating data from production, accounting,
and environmental data collection systems.
Upsize Microsoft Access applications to SQL Server.
American AgCredit, Santa Rosa, CA
Provide database environment setup and performance tuning
recommendations.
Title Nine, Emeryville, CA
Provide support and planning for database upgrades to SQL
Server 2005.
Develop custom queries against CommercialWare order processing system.
Provide database tuning recommendations, advice on company
reporting strategy.
TravelSmith, Novato, CA
Provide support and strategic advice for data warehouse
enhancements, and selecting enterprise reporting tools.
Design and deliver SQL Server & Cognos based company executive dashboard and data warehouse
solution.
Performance tuning and application refactoring to better
utilizing existing hardware.
Introduce SQL coding standards, and database change
management policy and procedures.
UC Davis, Bodega Marine
Lab,
Bodega Bay, CA
Provide database environment planning recommendations.
Tune database backup plans and enable failure notification.
Stantec, Petaluma, CA
Upsize Microsoft Access applications to SQL Server.
Design database system to manage company users, hardware,
and software.
Gilleran Energy Management, Santa Rosa, CA
Provide architectural design advice for new energy solution.
Athleta, Petaluma, CA
Design and deliver a SQL Server & Cognos based data warehouse / enterprise reporting solution to
host CommercialWare, and other related company information.
Research, recommend, and implement hardware and software,
and provide strategic advice for data warehouse.
Mentor for data
administration and SQL programming.
Camp Counselors USA,
Sausalito, CA
Setup and maintain database replication sites in several
countries as part of company administration team.
Intuit, Inc., Santa Rosa, CA
(7/2004-9/2005) Senior Database Analyst
Database lead in new
product development team using .NET and Microsoft SQL Server & Sybase iAnywhere.
Driver for data and
process modeling, business rules, and workflow within development team working
under Agile methodology.
Responsible for
application database tier for administration, change management, data security,
and performance.
Member of corporate
data infrastructure group standardizing information storage practices across
product offerings including: QuickBooks, Quicken, and Turbo Tax.
Legacy Marketing Group, Enterprise Database Management, Petaluma, CA
(11/2003-7/2004) Lead Database Administrator
Lead database
architect/administrator for development database environment involving .NET,
ASP, Java, VB; 3rd party applications: Macola, Ceridian, AWD,
Fortis, CA Unicenter Suite.
Supervised and
mentored five database administrators supporting 24x7 environment
Legacy Marketing Group, Database Management, Petaluma, CA
(5/2001-11/2003) Senior Database Architect
Participate in design,
ETL programming, and support of corporate data warehouse system involving
Analysis Services, Business Objects, Cognos, and Crystal Server
Mentor for data and
process modeling, database administration practices, SQL programming
Authored company
database design and coding standards
Team lead for
definition of disaster recovery, installation, security, audit policy and procedures
Legacy Marketing Group, Petaluma, CA
(4/2001-5/2001) Independent Consultant
SQL Server
administration mentor
Assist with database
architecture, SQL programming, and database administration
Necentives
Professional Services, Netcentives Inc., Healdsburg, CA
(12/1999-4/2001) Senior Consultant (see below)
ElecCheck, Honolulu, HI
(2/2001-3/2001) Data
modeler for an Oracle based custom check processing system
Custom Loyalty Network, Netcentives, Inc., San Francisco, CA
(10/1999–4/2001)
Provided database expertise on various web integration projects: Alta Vista, American Express, AOL
Advantage,
Citibank, ClickRewards, CoolSavings, Dotz, Inktomi, Lycos, Post Communications
Netcentives,
Inc., San Francisco, CA
(10/1999-1/2001)
Defined internal SQL design and coding standards.
Developed and
delivered internal data modeling training course
Evaluated and
recommended solutions for enterprise reporting
Assist in defining
and testing internal network security architecture
Legacy Marketing Group, Petaluma, CA
(6/1999-4/2001) Data
architect for a project team conducting analysis, design, and implementation in
upgrading a COBOL insurance application to a three-tiered Java based intranet
system using SilverStream with SQL Server
backend. Managed data model, business
rules, stored procedure and trigger coding. Conducted onsite data modeling and
SQL Server training.
(4/2000-5/2000) Performance
tuning of UNIX file to SQL Server data warehouse batch processes
Simpson Timber, Shelton, WA
(4/1998-6/1999)
Analysis, design, and implementation for mainframe lumber system to be
converted to PowerBuilder client/server application
Panttaja Consulting Group, Inc., Healdsburg, CA
(7/1995-12/1999) Senior
Consultant (see below)
Actel, Sunnyvale, CA
(1/1998-2/1998) Integrated automated Email facility to web
site on NT
Netcentives, San Francisco, CA
(12/1997-1/1998)
Assisted project team with database design and PowerBuilder coding
Masonic Lodge, San Francisco, CA
(6/1996-6/1997)
Developed integrated trigger and stored procedures solutions around
customization of third party client/server application on NT
Tandem
Computers,
Cupertino, CA
(7/1997-9/1997) Designed and lead technical project to build
an Informix-Universal Server based Intranet web site on NT for the
Strategy& New Ventures group to manage the corporate contract pipeline
Tandem
Computers,
Cupertino, CA
(6/1996-6/1997)
Database architect for Informix data driven web site on NT providing Intranet,
Extranet, Internet access to general knowledge base on company products for the
Tandem Marketing department and Tandem Partners
Informix, Menlo Park, CA
(3/1997-4/1997) Provided design and architecture recommendations
for the Informix database driven Internet site
Illustra, Oakland, CA
(3/1997-4/1997) Developed course materials for the object
relational Web DataBlade class
Montgomery Securities, San Francisco, CA
(2/1997-3/1997) Performance tuning UNIX Illustra
based web site
Co-op
Communications,
Greenbrae, CA
(2/1996-5/1996)
Conducted analysis for reengineering effort for their existing cooperative marketing
funds tracking system. Assisted with
performance tuning on Netware Sybase installation.
San Francisco Opera, San Francisco, CA
(3/1996-4/1996) Data modeling and performance tuning for UNIX
based Sybase ticketing system
Simpson Timber, Arcata, CA
(7/1995-6/1996)
Database design and programming role using PowerBuilder, ERwin,
and SQL Server on NT, for a lumber mill automation system
North
American Mortgage Company, Santa Rosa, CA
(2/1994-7/1995) Database Administrator
Lead database
administrator for Sybase and Microsoft SQL Server installations. Tested and recommended hardware and software
for corporate client/server systems.
(2/1993-2/1994) Senior Programmer/Analyst
Lead
designer/developer of an IT management system using PowerBuilder, ERwin and SQL Server.
The system provided on-line task queuing, hour tracking and
charge-backs, change management, job run documentation, and scheduling for all
systems.
(5/1990-2/1993) Programmer/Analyst
Designed and
implemented an on-line CICS information tracking system designed to complement
the existing loan servicing system by eliminating manual tracking and improving
coordination between four related departments
(4/1989-5/1990) System Analyst
Member of a project
team conducting analysis, design, maintenance of the company mainframe loan
origination system
Franklin Resources, San Mateo, CA
(1/1994-2/1994) Contract Programmer
Assisting with reporting requirements using in-house reporting tool
California State University, Rohnert Park, CA
(9/1986-6/1988) Systems Operator
Responsible for
backups, account management and special requests on university mainframe and
UNIX systems
Con-Soft
Software,
Rohnert Park, CA
(6/1985-3/1986) Programmer
Developed an
invoicing module to integrate with the company's accounting software product
for the construction industry, the Job Coster
Expertise:
Databases: Microsoft SQL Server, Sybase
ASA/ASE, Informix, Oracle, Illustra, DB2, MySQL,
Microsoft Access, Paradox
Database Tools: Red-Gate, SentryOne
Modeling: ERwin
Data Modeler, BPwin Process Modeler, Power Designer,
Data Architect
Languages: SQL, Transact-SQL, SSIS/DTS,
MDX, DAX, Visual Basic, Java, JavaScript, HTML, C/C++, COBOL
Web: IIS, DreamWeaver, FrontPage
Imaging: Photoshop, Fireworks
Education:
B.S. Computer
Science, California State
University,
Rohnert Park, 1988
Minor Mathematics,
1998
Minor Environmental Studies,
Energy Management & Design, 1998
Professional Certifications:
|
SQL
Server Specialist, 2006 NT
Workstation Specialist, 1999 NT
Server Specialist, 1998 Informix
DataBlade Professional, 1997 Sybase
Professional Database Administrator, 1995 |
|
Other Certifications:
4rd Degree
Black Belt Aikido, 2009
CPR, American Red
Cross, 2005
Professional Training:
Cognos BI, Report Studios,
2007 
Cognos BI, Meta Modeling,
2006
Sybase iAnywhere Fundamentals, 2004
Writing Effective Use Cases by Alistair Cockburn, 2004
AllFusion Process Modeler (BPwin), Computer Associates, 2003
SQL Server 2000
Administration, Microsoft, 2003
Oracle Performance
Tuning, Oracle, 2000
Java Programming, Sun
Microsystems, 1999
SilverStream Programming, SilverStream University, 1999
Informix Dynamic
Server Performance Tuning, Informix, 1997
Presentations:
Informix
User Conference, Moscone Center, San Francisco, CA, 1997
“Building
High-Performance Web Applications”
Publications:
Informix Tech Notes Volume 7, Issue 3, 1997, “Building
High-Performance Web Applications”
Informix
Dynamic Server with Universal Data Option: Best Practices, 1998, Ch. 11
"Designing High-Performance Web
Applications", ISBN: 0-13-911074-7
Professional Affiliations:
Member,
SQL Server Worldwide User Group (SSWUG)
Member,
Professional Association for SQL Server (PASS)
Member,
Data Management Association (DAMA)
Other Affiliations:
Owner
& Photographer, Picture This Photography, Sebastopol, CA
Member,
Aikikai Foundation, Tokyo, Japan
Member,
Iwama
Shinshin Aiki Suren Kai, Ibaraki Prefecture,
Japan
References:
Provided
upon request