Andy Oppel
Data Architect, Database Administrator, Technical Manager
WORK
EXPERIENCE:
Blue Shield of California, Sr. Data Modeler,
12/31/07 - Present
Ceridian, Principal Data
Architect, 9/03 – 12/07
1fb.net, inc. (Subsidiary
of First Financial Bank
MBH Solutions, Inc.
(Formerly Concur Technologies HR Products Division),
Data Base Group Manager, 10/00 – 7/31/01
GeoWorks, Senior Oracle Database Administrator /
Database Architect, 8/99 – 10/00
Oracle Corporation, Managing Principal Consultant,
3/98 – 8/99
Triadigm International, Senior Consultant, 2/97 -
2/98
Levi Strauss & Co., Architect, DBA Manager,
Project Manager, Designer, 12/79 - 2/97
Maryland Casualty Company, Senior
Programmer/Analyst, 12/78 - 12/79
Equitable Trust Company, Data Base
Programmer/Analyst, 9/77 - 12/78
SKILLS HIGHLIGHT:
Database
Products
Oracle 7/8/8i/9i/10g (Oracle 9i Database
Administrator Certified Associate), Microsoft SQL Server, MySql
, Sybase, MS Access, IMS DB/DC, DB2
Other Products
SAS, SPSS, CA-TELON,
Microsoft Office, Visio, Vantive, ER/Studio, PowerDesigner Data Architect
Operating
Systems
Solaris, HP UX, Linux, Windows 95/98/NT/2000, MVS, DOS/VSE, PC DOS
Programming
Languages
SQL, PL/SQL, Transact SQL, Unix
and NT Shell Scripting, COBOL, PL/1, BASIC, FORTRAN
Management/Leadership
Skills
Program/Group Manager,
Project Manager, Project Leader, Lead Database Engineer
Life Cycle
Expertise
Information Engineering,
Process Modeling, System Architecture Planning and Design, Software Design
Documentation
Specialty
Skills
Data architecture, Data
modeling, Database application tuning, Middleware architecture design
Methodologies
AIM, CDM, Knowledgeware,
SDM/70, LBMS
Applications
Insurance, Banking, Medical Research, Payroll,
Benefits, Human Resources, Statistical Analysis, Manufacturing, Distribution,
Financial, Order Entry, Inventory Modeling, Advertising, Customer
Care/Workflow, Wireless Messaging, Human Resources
Hardware
Sun SPARC, HP 9000, NT
Servers, IBM mainframe, IBM compatible PCs,
PROJECT EXPERIENCE
12/07 – Present
Blue Shield of California,
Sr. Data Modeler
·
Development of ODS and hybid (relational and
dimensional) EDW models for large BI project, including the Membership, Claim,
Capitation, Plan/Project, Provider, Geography, Finance and Reference subject
areas; Assisted UAT team with using the
installed physical model, including complex SQL query writing
·
Development of enterprise conceptual and logical
data models with focus on Provider and Group/Subscriber/Member subject areas.
·
Modeling and mapping of Provider ODS model
from 17 source application systems
·
Enhancement of data models for existing
transactional and analytical databases
·
Incorporation of legacy databases into
enterprise data model
·
Oversight of the ERwin Model Manager
Repository
09/03 – 12/07
Ceridian, Principal Data
Architect
·
Development of enterprise data model for OLTP
and OLAP applications.
·
Provide database design advice to development
projects; review data models and database designs for all projects
·
Manage Enterprise Data Architecture project,
to deliver:
o Standards
for logical and physical database design, database programming, change
management, and tools
o Logical
and physical data models for OLTP and OLAP applications
o Common
code values
·
Create data models for key projects (e.g.
Operational Data Store – Customer Master Data, Single Sign On, HR/Payroll Data
Warehouse)
·
Facilitate data architects' roundtable for
presentation/discussion of common issues and ratification of proposed standards
08/01 – 09/03
1fb.net, inc. (Subsidiary
of First Financial
·
Development and implementation of a corporate
operational data model.
·
Database design for a financial website and a
college information web site.
·
Maintenance of Oracle databases for all
environments (development through production)
·
Assist/mentor Junior Oracle DBA as required.
·
Advise management on security,
backup/recovery, fault tolerance and disaster recovery issues.
10/00 – 7/01
MBH Solutions, Inc.
(Formerly Concur Technologies HR Productions Division), Database Group Manager:
· Manage one entry
level DBA
·
Manage QA team of four
· Design database
design solutions for new product releases
· Assist with
customer service database issues
·
Lead DBA for Oracle, Sybase and MS SQL Server
databases (software installs, schema changes, backup/recovery, tuning)
·
Solaris administration for all Development
and QA Sun servers
· Maintain all
development, test and QA database servers (NT and Solaris) and series of jobs
to refresh table structures and data
· Personally
designed and developed a series of scripts and SQL procedures to compare
databases and identify data discrepancies
· Taught database
design class for employees
8/99 – 10/00
GeoWorks, Senior Oracle Database Administrator /
Database Architect
Design and management of Oracle database environment, including:
· Provide logical and physical
database designs (Oracle and MySql) for development engineers.
·
Design and
implementation of Data Warehouse for Marketing.
·
Assist
development and QA engineers with tuning and troubleshooting.
·
Installation
and configuration of Staging Server with Staging and Data Warehouse databases.
·
Backup and
recovery of Production, Development, Data Warehouse and Staging Databases.
·
Maintenance of
legacy Sybase and Microsoft SQL Server Databases.
·
Overall
administration of Oracle databases.
·
Training and
coaching an Assistant DBA.
2/98 – 8/99
Oracle Corporation, Managing Principal Consultant
Wide variety of consulting assignments, including
the following:
· Design of an E-Commerce site
for financial funds administration
· Development of the
replication architecture for a web publishing site for a financial services
firm
· Management of production
support efforts for a large customer care application (wireless
telecommunications company with 1500 concurrent users), including significant
tuning of both the database and the application
· Installation of Oracle
Financials, Release 11
· Installation and
configuration of the Oracle Application Server (versions 3.x and 4.x)
· Installation and
configuration of the Oracle Server (versions 7.3.x, 8.0.x and 8i)
· Installation of the Oracle
Internet Commerce Server
· Teaching courses such as Oracle 8
New Features, Oracle Designer and Oracle Internet Commerce Server
Administration
· Evaluation of database
configuration and database performance tuning
· Conversion of MS SQL Server
procedures to Oracle PL/SQL procedures
1/83 – Present
Instructor of two
courses: "Concepts of Database
Management Systems" and "Introduction To
Database Management Systems". Over
50 semesters of teaching experience with these two courses. Students come from a wide variety of
backgrounds, with about 50% having previous work experience in data
processing. Instructor reviews have
always been excellent. Received “Honored Instructor” award in 2000.
2/97 - 2/98
Triadigm International, Senior Consultant
Year 2000 Project, Pacific
Project Management Office,
Pacific
12/79 - 2/97
Levi Strauss & Co., Architect, DBA Manager,
Project Manager, Designer, Programmer
Senior Architect (12/95 –
2/97). Responsibility for the overall design and
architecture of a major software release involving 16 separate projects on
diverse platforms and technologies.
Manager, Data Base
Management Systems (2/94 - 11/95). Responsibility for all data base management systems (PC through
Mainframe), a large corporate database utilizing Oracle and DB2, migration to
client/server technologies, and for providing leadership for a staff of 6
employees and 4 consultants.
Acting Program Manager with
responsibility for four to six direct reports and 20 to 40 indirect reports
working on a variety of diverse application development projects. Also
served as the Project Manager for two projects:
Sundries Inventory and Project Accounting.
Manager of Integrated Data
Delivery (Data Base Administration) on an interim basis (6 months) with 10
direct reports (6 employees, 4 contractors).
Database Administrator for multiple large DB2 and
Oracle databases.
Release Architect for LABS
Releases 2 and 4. Responsibilities
included coordinating the activities of the development project teams and
support staff, negotiating post-staging design changes, conducting a weekly
Technical Forum meeting with the developers, participating in problem isolation
and resolution, and assisting the Release Manager as needed.
Project leader in LeviLink
systems responsible for maintenance and enhancement of the Model Stock
Management (MSM) system with a staff of 4.
Completed numerous new enhancements and converted the system to VS COBOL
II and Endevor. Also provided technical
support to other LeviLink projects and served as the Telon and CICS trainer for
the IR Department.
Designer and project leader
of MSM system (an online retail inventory control, analysis and replenishment
order system). System consisted of 100 online
CICS/COBOL programs with 10 batch COBOL programs. The entire system was designed and developed
using technology new to LS&CO. (Telon and DB2), and installed in 8 months
using a staff ranging from 3 to 6. Staff members had no prior Telon or DB2
experience. Personally wrote about 25% of
the programs.
Designer of a PC based order
entry system in compiler BASIC. Managed a project team of 8 developers, none of whom had previous
BASIC or PC experience. This
system operated as a standalone order entry system with burst transmission of
completed orders to the mainframe for final processing. This system cut the cost of processing orders
by more than 90%.
Managed a maintenance
project for a personal computer based retail inventory tracking system (RIMS).
Senior Requirements Manager
(8/82 - 1/84), managed various projects in the requirements and design
alternatives phases of development. This
included evaluations of vendor software, systems development procedures and
alternative technical strategies.
Programmer/Analyst (12/79 -
8/82), provided systems designs and produced programs for major financial
systems and subsystems using COBOL and IMS DB/DC.
12/78 - 12/79
Maryland Casualty Company, Senior Programmer/Analyst
Maintained
IMS DB/DC system on an IBM 3031 under OS/MFT. Designed and implemented IMS applications: data base design, screen design, control
block generations, program design, coding and testing.
Designed and implemented a
policy writing system on IBM 5110 micro-computers using BASIC. Also, designed, coded and implemented an
interface system on the mainframe using COBOL, IMS/DC, and specialized
mainframe hardware to read and write IBM 5510 diskettes. Trained user personnel in
system operation.
9/77 - 12/78
Equitable Trust Company, Data Base
Programmer/Analyst
Managed
one programmer and one project assistant.
Maintained vendor and in-house developed software; performed IMS control
block generations, data base tuning, data base modeling and data base
recoveries. Participated
in IMS data base and application development efforts.
7/74 - 9/77
Analyzed, designed and coded
medical research data collection systems.
Provided statistical analyses using software packages
and custom programs. Supervised
one data clerk
PUBLICATIONS
Databases Demystified (author), McGraw-Hill/Osborne, 2004
SQL Demystified (author),
McGraw-Hill/Osborne, 2005
EDUCATION
BA in Computer Science,
Numerous technical training classes and seminars.
Address:
Home/Work
Phone: (510) 864-2299
E-mail: andy@andyoppel.com