Ewan Grantham
San Antonio, TX 78258 -  [Send email to request phone number] 72-8884
[Send email using form at bottom]

 
Skills
Experienced in working with multiple development teams in multiple locations to
define and implement standards for an enterprise Data Architecture
Architecture experience with Oracle, DB2 and SQL Server in Large Transactional
Systems as well as for Data Warehouses
Extensive experience with creating conceptual, logical, and physical models
using various tools (ERwin, Oracle Designer, PowerDesigner, Rational
Rose/Software Architect) as appropriate
Knowledgeable in applying RUP and CMMI best practices to insure quality and
promote efficiency
Have contributed to Open Source projects (coLinux and argoUML), and familiar
with many additional technologies that can be leveraged as appropriate for a
project

Experience
June 2002 – Aug 2009: Senior Data Architect, Southwest Research Institute, San
Antonio, TX
Responsibilities in this position included: 
Requirements gathering and design of the enterprise architecture to be used for
the VHA's Pharmacy Replacement System
Responsible for working with the PMO to develop and conduct Trade Studies for
the evaluation and selection of Data Modeling tools and Meta Data Repository
tools
Design of the conceptual, logical, and physical database models and procedures
to support a combination of Oracle, Cache, and SQL Server systems
Mentoring of client staff on technical and functional subjects
Use of Rational Software Architect as well as other Rational Tools in a
UCM-compliant setup to document the requirements and design of the system 
Use of ERwin and Oracle Designer to document the design of the various database
models and implementations

This position involved work as the Senior Data Architect on an effort utilizing
60 employees as well as over 100 client representatives to re-engineer the
Pharmacy process for a government organization with over 150 facilities
nationwide. I was responsible for developing a conceptual architecture, to
develop standards to promote best practices based on the Zachman Framework and
the RUP methodology, to  design and conduct trade studies for Data Modeling and
Meta Data repository tools, and to assist the client in writing SOWs and
evaluating RFPs related to those tools. While my main focus was on the data needs
and database design, I was also involved with working across teams to facilitate
user interfaces and mid-tier designs that would optimize the databases being
used. Technologies worked with include Rational ClearCase, Rational ClearQuest,
Rational RequisitePro, Rational Rose, Rational Repository, Oracle Designer,
ERwin, Hibernate, MS Project, MS Outlook, Sharepoint, PowerPoint, TOAD,  Oracle
(9 - 11i), SQL Server (2000), Cache.

September 1993 – June 2002: Independent Consultant based out of Andover, MN
Responsibilities in this position included: 
System Architecture and Design using the RUP methodology and UML documentation ,
as well as the TOGAF and/or Zachman Framework (depending on the project) to guide
the development of the architecture
Mentoring of client staff in both DBA and development positions 
Development of standards based on industry best practices for the design,
implementation, and maintenance of Meta Data repositories
Design and performance of user acceptance testing plans

Projects worked on included:
Data Architecture and Technical Lead activities for US Bank (August 2001 to June
2002). Project included work to bring various projects into full system control
using Rational ClearCase and ClearQuest with UCM; developing designs for new
systems using Rational RequisitePro and Rational Rose; and implementing new
client-facing systems using IBM WebSphere (4.01 Enterprise) and Visual Age for
Java while populating back-end systems through MQ-Series to both Mainframe and
Unix-based versions of DB2 UDB. Work also involved the setup and maintenance of
several SQL Server 2000 and MS Access databases. Project was implemented
following the Rational RUP E-Business Roadmap. Technologies worked with include
Rational ClearCase, Rational ClearQuest, Rational RequisitePro, Rational Rose,
Rational RUP, Rational Repository, Oracle Designer, COBOL,Crystal Reports, MS
Access, IBM WebSphere, IBM Visual Age for Java, DB2 UDB, Perl (mainly for
ClearQuest hooks and ClearCase triggers), MS Project 2000, SQL Server 2000, TOAD,
AIX, Windows 2000 and Windows XP. 
Data Architecture and Technical Lead (October 2000 to August 2001) for Marvin
Windows in re-engineering their systems from an OpenVMS and terminal architecture
to a Windows 2000 Terminal Server and mixed-client architecture. Additionally was
responsible for leading the conversion of their Oracle HR from 10.7 to 11i. Work
involved creating design documents, performing trade studies and evaluation test
plans, and coding in Oracle Developer (Forms and Reports), Perl and PL/SQL of
various programs to support evaluations and the system conversion. Work was
performed following the XP methodology using coaches and paired programming
techniques. Technologies worked with included ActiveBatch (Unix/VMS/Windows
Scheduler), Crystal Reports, Oracle HR (10.7 and 11i), Oracle DB (various
versions of 8i), Oracle Designer and Oracle Developer 6i, JDeveloper, TOAD, SQL
Navigator, ActiveState Komodo (Perl), Javascript, PL/SQL (Various tools),
Microsoft Visio, UWIN (UNIX under Windows).
Data Architecture and Technical Lead (March 1999 – August 2000) of an
internationally distributed system for the collection and maintenance of medical
data by the DoD. This involved assisting in the design of the overall system
architecture, creating work plans and reporting progress against them, and
selecting and specifying development and design tools to implement the system.
Was also involved in coding two proof-of-concept prototypes (one using Oracle
OCI, the other using Pro*C++) to pull data from an Oracle database to be parsed
into XML. It was then distributed through a COM/DCOM publish-and-subscribe
event-driven interface to other databases that then read the XML and prepare the
correct messages to place the data into those databases. I was also responsible
for insuring that transactions met HIPAA requirements for privacy and auditing.
Technologies involved include Oracle 8 and 8i, TOAD, Oracle Designer, Informix,
Crystal Reports, Paradox, Visual C++ (5 and 6), COM/DCOM, JDeveloper (EJB
creation), Rational Rose (including 2000)/UML, Rational RUP, IIS, Windows NT 4
Workstation, Windows 98, Windows NT 4 Server, Windows 2000 Professional and XML.


Data Architecture and Technical Lead (September 1998 – March 1999) for a
package-enabled re-engineering project for QWest. This involved assisting in the
design of the overall system architecture, installing and configuring packages,
and working to implement changes and enhancements to the package. The system
serves 850 users in 14 states using Windows NT Terminal server and other thin
clients through the Web to access a system of Oracle Financials and Clarify
modules working together through the use of CrossWorlds middleware and IBM MQ
Series transaction queuing. Technologies used include Oracle 7 (7.3.3 and 7.3.4)
and Oracle 8 (8.0.5) running on several Sun Solaris 2.6 systems, Clarify 5 and 6
(ClearSales, ClearSupport, ClearLogistics, ClearContracts), Java and JavaBeans,
IBM MQ Series, CrossWorlds, Rational Rose, Oracle Financials 10.7 using
SmartClient and NCA (AR, INV, GL, AP, PO), SQL*Loader, TOAD, Windows NT 4
Workstation, Windows NT 4 Server, Windows NT Terminal Server.
The re-engineering of several existing systems to support improved throughput,
design and implementation of a corporate data warehouse (March 1998 – September
1998). Additionally responsible for project management of the teams involved in
these efforts, mentoring of DBAs and Developers, and presentations of plans and
produced systems to upper management. Technologies used include Oracle 7 (7.3.2
and 7.3.3), Oracle 8 (8.03 and 8.04), AIX, Windows NT, Windows 95, Designer 2000
(1.3.2 and 2.1), Developer 2000 (1.x and 2.x), PeopleSoft, Visual J++, and
Microsoft Project.
Designing and implementing parallel server/three-tier architecture system for
Blue Cross/Blue Shield Minnesota (September 1997 – March 1998). Involved database
design and implementation in a mixed Oracle 7.3/8.04 environment, working with
the programming team to determine necessary changes to enhance throughput and
responsiveness, mentoring other DBAs on new technologies and approaches, and
architectural planning for expansion of the system. Technologies used include
Oracle 7 (7.3.2 and 7.3.3), Oracle 8 (including 8.04), Sun Solaris, Enterprise
Manager (1.3 and 1.4), Windows NT, MacOS (7.5.x and 7.6.x), Designer/2000
(1.3.2), Developer/2000, Magna, Java, CGI/Perl, Encina and MS Project.
Designing and implementing several systems to create a single point-of-entry
system for accounting and workflow at Graco (March 1997 – September 1997).
Included creating work plans and presentations for implementation as well as
coding and DBA work. Was responsible for documenting and presenting proposed
changes and additions to the underlying technical architecture to upper
management. Technologies used include Oracle Financials (AP, AR, GL) (10.5,
10.7), Oracle 7 (7.1 – 7.3.2), AIX, Designer 2000 (1.3.2), Developer 2000, and MS
Project.
Designing the technical architecture for QWest’s ISP service (January 1997 –
March 1997). This included database design as well as front-end and back-end
programs and interfaces necessary for the business. Was responsible for
documenting and presenting proposed changes and additions to upper management.
Also involved with implementation (coding and DBA work) of the pilot of this
architecture. Technologies used include Lotus Notes/Domino, HTML, CGI/Perl,
Codewarrior Gold 11, Visual C++ (4 and 5), Oracle 7, Designer 2000, PowerPoint,
MS Word (7 and 8) and MS Project. Front-end platforms were PCs, Macs, and Sun
Workstations (Sun OS and Solaris) talking to an application server. The
application servers then brokered requests for functionality, and data requests
were then passed to the centralized customer database (Oracle 7) or the billing
database (Sybase 11).
Project management and DBA/Design work for Nortel to tie their various systems
together for a single workflow system (August 1996 – December 1996). Technologies
used included Sybase (10 and 11), PowerBuilder (4 and 5), S-Designor, Cobol,
Windows (3.11 and 95), HTML, CGI/Perl, Java, Sybase and Intersolv ODBC drivers,
Novell 3.12 and 4.x, Clarify (ClearSupport, ClearLogistics), and Microsoft Access
(2, 95, and 97). Front-ends were PC's talking to MVS-based and UNIX-based
systems. 
The design and implementation of a system for Blue Cross/Blue Shield Minnesota
to allow data about patients, doctors, and clinics to be shared and updated
between the corporate office and remote clinics (May 1996 – August 1996).
Technologies used included ORACLE 7, DB2, COBOL, Platinum, UNIX (HPUX), Designer
2000, Windows NT, MacOS 7.5.x, HTML and HLP templates for MS Word, Visual C++,
Oracle and Intersolv ODBC drivers. Platforms for the front-ends were Macintosh
and Windows-based PCs talking to MVS-based and UNIX-based systems. 

Design and implementation of a complete Loan Processing system for USAA FSB
(August 1995 – May 1996). This system also had to integrate with legacy systems
for the insurance products and other banking products the client offers.
Technologies used included Oracle 7, DB2, COBOL, Fortran, UNIX (AIX), Designer
2000, Developer 2000, MS Visual C++, Windows NT, OS/2, MacOS 7.5.x, HTML and HLP
templates for MS Word 6 and 7, Java, some VRML, Oracle and Intersolv ODBC
drivers, Smalltalk VSE 3.0 and 3.1.x, PARTS, WindowBuilder, and TOPLink.
Front-end platforms were Macintosh, OS/2 and Windows-based PCs talking to
MVS-based and UNIX-based systems. 
Designing and implementing front-end interfaces to Blue Cross/Blue Shield
Minnesota's Data Warehouses, integrating enabling technologies to support a
distributed environment, and creating on-line documentation for the Warehouses
and supporting systems (October 1994 – July 1995). Technologies used included
Oracle 7, DB2, UNIX (HP/UX and Solaris), MS Access 95, PowerBuilder, Andyne SQL,
MS FoxPro, MS Visual C++, Novell NetWare, Windows NT, HTML and HLP templates for
MS Word 6, IconAuthor for CBT on system, Oracle and Intersolv ODBC drivers, and
SQL*Net 2. Platforms for the front-ends were Macintosh and Windows-based PCs
talking to MVS-based and UNIX-based systems. 
Coding to create interfaces for Windows and OS/2 clients talking to UNIX-based
(primarily HP/UX) ORACLE systems for Fortis (October 1993 – October 1994).
Interfaces supported both LAN-based and dial-in connections. Programming was done
using MS Visual C++, PowerBuilder, MS Access 2 (Windows) and Borland C++ for OS/2
(OS/2). 

January 1992 – September 1993: Coopers and Lybrand, Minneapolis, MN.
Led a project developing and implementing a client-server based data warehouse
for Wausau Insurance in Wisconsin. The system used a multi-processor UNIX
Database server fronted by departmental RS/6000 boxes and serving PC-based
clients. RDBMS was Oracle 7 while the client-programming tool was a Smalltalk
(ParcPlace) product. Responsibilities included designing the infrastructure (LAN
and WAN capabilities), system design, and front-end integration. Developing and
presenting seminars in Client-Server design and implementation, C and C++
languages, PowerBuilder (2 and 3), the UNIX operating system, and Oracle and
Sybase Databases. 
Led a project designing Client-Server applications for a major Measurement and
Controls corporation in Minneapolis using Progress and Sybase in both a UNIX
environment and in a Novell LAN environment, PCs running Windows NT, Windows 3.1
and/or DOS, and Novell 3.11 and included overall architecture design and
direction. In addition, was responsible for writing several applications in MS
Access and Borland C++ under Windows to support custom needs, and training of
staff in C++. 
Design and programming work for Pillsbury in Minneapolis using Oracle on UNIX
(HP-UX), OS/2, PowerBuilder, Novell 2.2 and 3.11, and DOS-based platforms in a
Client-Server model. Other work included programming in C for the OS/2
environment to create front-ends to current applications, and some C++
programming in DOS and Windows for specialized user front-ends and integration of
systems. 
Design work for a University in Michigan's Business Education Department, and
design and programming work for a Pharmaceutical Company in New Hampshire.
Hardware platforms include HP 9000 827 and 847 UNIX boxes, DG/AViiON's, SUN
SPARCstation, IBM Model 95's, and several 386 and 486 clone systems. Software on
both systems was Oracle and Oracle Financials (AP, AR, GL, and FA) with a
PowerBuilder front end.

Other Work Experience
February 1990 -- January 1992: Senior Application Engineer. Shared Resource
Management, Mpls., MN. 
April 1989 -- January 1990: Project Manager. Centec Advanced Technologies,
Jackson, Mississippi. 
April 1988 -- April 1989: System Administrator. Mississippi Department of
Corrections, Jackson, Mississippi. 
July 1985 -- April 1988: Consultant/Analyst. Creative Computer Technologies,
Jackson, Mississippi. 

Education
March 2005: Obtained PMP Certification.
September 2001: Fundamentals of Rational ClearCase and Unified Change
Management, Rational ClearCase Administration, Rational ClearQuest Administration
– Rational University.
September 1999: Fundamentals of Rational Rose – Rational University.
January 1983 - May 1984, January 1987 - December 1987: Mississippi College,
Clinton, Mississippi. Major: Computer Science. Minor: Mass Communications Degree:
Bachelor of Science in Computer Science (with Distinction), December, 1987. 
September 1980 - May 1982: University of Denver, Denver, Colorado. Major: Mass
Communications, Minor: Computer Science.

Selected Interviews and Publications
Interviews:
Tooling Up - "ORACLE Magazine", July/August 1998
Manage Globally, Act Locally - "ORACLE Magazine", March/April 1998

Publications:
Contributing Author - Essential Blogging, O'Reilly, August 2002
Technical Reviewer, Operating Systems Concepts, Prentice-Hall, March 1999
ActiveX/Visual J++ Overview, PowerBuilder and Java Journal, February 1997
Contributing Author - SAMS Publishing's Microsoft Office 95 Unleashed.
Softcover, Jan. 1996
Contributing Author - SAMS Publishing's Access 95 Unleashed. Softcover, Dec.
1995
Contributing Author - SAMS Publishing’s Electronic Publishing Unleashed.
Softcover, Nov. 1995
Contributing Author - SAMS Publishing’s Windows 95 Unleashed. Softcover, Sept.
1995
Contributing Author - QUE Publishing’s Killer Windows 95, Sept. 1995
New Multimedia Applets - Article in Windows 95 Journal, Sept. 1995
Contributing Author - SAMS Publishing’s Windows 95 Programming Unleashed.
Softcover, August 1995
Multimedia Columnist, Windows 95 Journal, September 1995 issue to September 1996
issue.
Design Considerations for Client-Server Projects, Building Blocks of
Client-Server Design - Articles for "From the Summit", Coopers & Lybrand customer
newsletter, October 1993 and January 1994