20+ years assisting companies domestically
and internationally in Data & Database Management, Systems &
Information Integration, Data Architecture, along with some technical line management
& Management Consulting. Extensive hands-on
designing, implementing and supporting both centralized and distributed
applications on diverse platforms; emphasis on design for Performance, Availability,
Scalability and Integration. Strong
familiarity with Financial Services, Cap. Mkts.
Enterprise Data/DB Arch., Info.
Integration Arch., Manager DBA, Snr. Data Arch. role in distributed environment.
Database Managers, TP
monitors, Application Servers:
DB2® Enterprise 9.1 for Linux, UNIX, and Windows
(LUW), including DPF; familiarity with UDB’s predecessors
back to OS/2 EE DBM (1988); Beta user (’06) and GA user (‘06-‘07) of DB2 Enterprise 9.1 for LUW with DFP,
using new features of table (range) partitioning, data row compression; implemented
V8.2 new features of HADR, Q Replication, Automatic Storage;
DB2 9.5 Beta User (’07); IBM BCU methodology for Scalable Data Warehousing
DB2 for z/OS, DB2
Connect, CICS/DB2 attachment, IBM, CA, and BMC 3rd Party Tools and
IBM WebSphere Application
Server V6, CICS, IMS DB/DC
Intelligence/Data Warehousing (BI/DW), Enterprise Information Integration (EII),
Hands-on use /
Formal Training / Certification / Working knowledge of: Capabilities of various BI/DW, Enterprise
Information Integration and Middleware technologies and product capabilities,
over a dozen years:
Integrator (WII) 8.2/ DB2 II; WebSphere MQ 6;
IBM DPROP/R; Various middleware e.g. Message-Oriented Middleware (MOM); WebSphere
MQ 6, including WS
MQ AMI 1.2
Web Services: DB2 UDB as producer
of Web Services; DB2 UDB as consumer via SOAP UDF’s; familiarity with J2EE Development paradigm; XML,
Java connectivity to RDBMS (JDBC, SQLJ)
architectural frameworks, methodologies, standards, toolsets and products over
time, including: Informatica PowerCenter, MicroStrategy DSS Agent/Architect,
Business Objects, IBM DB2 DW Center, etc.
IBM z/OS and predecessors
back to MVS/370, Linux (2.4, 2.6 kernels), various UNIX on and off over
DB2 UDB System
Monitor (Snapshot and Event Monitors), Visual Explain / Statistics Advisor, DB2PM
V8/DB2PE V2.1, OMEGAMON, TMON, STROBE, RLF, QMF Governor
Design tools, CASE, Metadata
(DBArtisan, etc.), BACHMAN Re-Engineering Product set, TI’s IEF, ADW, LBMS
Jersey City, NJ, 02/07-06/07
Ent. Arch. – Database
Architect in the database domain (DB2 9 for Linux, Unix); reviewed application
designs; applying the feature/function of database and platform technologies to
diverse application requirements. Integration
of DB technology into the broader technical architecture of the Firm, leveraging
capabilities of the platform layer below, while providing services to the middleware
and layers above. Developed and
disseminated best practices in the database domain. Worked with DBAs and Application team leads to
enhance the performance of major databases and re-factor databases and their applications
to be resilient to change (business changes, growing volumes, performance,
included: Review and advise on the Data
Models for core Positions and Balances; Trades
For Firm Wide
Application Monitoring Infrastructure app on DB2 9 (Linux). used by all Firm apps
globally, designed ODS and DW Architecture exploiting interplay of complex DBMS
data structures (MDC and new table (range) partitioning capabilities) for
concurrent high-INSERT, analytics, and seamless data rotation from current
period (ODS) to history (DW) i.e. Roll-Out / Roll-In, using inter-process
communications across DB2 instances to maximize data availability.
major Funds Availability application recommending and implementing instance,
database configuration, design enhancements, and SQL changes yielding over 100%
performance and throughput improvement.
Headstrong Inc. (prev. James Martin)
New York NY, 02/06 – 02/07
Chief Data Arch., DW & BI Grp (F/T)
For Morgan Stanley’s
ISG, Data and DB Architect charged with re-architecting and re-platforming
Trade Settlements from DB2 for z/OS Data Warehouse, to new DB2
Enterprise 9.1 for Linux with Database Partitioning Feature (DFP), IBM’s MPP implementation
on Distr. Platforms; Open and Settled Trades,
partitioned with DPF, both within, across clustered LINUX SMP servers. Prepared Technical Architecture, methodology /
Proof of Concept and benchmark testing for very high throughput mission-critical
back-office Firm-Wide system for migration from mainframe. Understood to be among the largest known clustered
Enterprise 9 implementations, per IBM.
Utilized major features of new DB2
Enterprise 9: viz. data row compression,
Table/Range Partitioning, etc.
Govt. entities (Austr.)
from NY, NY, 2H/2005
LUW DBA Cons./Arch.(Linux)
For national Medical Insurance Co
(below, 2003), implemented and tested WebSphere Information Integrator 8.2’s
new Q Replication (incl. setup of WebSphere MQ 6 Server
and creation of required MQ objects across servers) for data
distribution/consolidation, business continuity, and as alternative to DB2’s traditional
SQL-based Replication. Benchmarked the two for comparative
performance, achieving triple throughput.
For same client, setup, testing
and evaluation of DB2 V8.2’s new HADR failover
feature, incorporating server role switching, failover of primary server, auto
client re-route (ACR); part of broader Review of Best Practices for High
Availability/DR, including log shipping, remote disk and/or log mirroring,
intelligent storage sub-system mirroring; advised client on pros and cons of HADR vs. new Q Replication for
failover/standby for this customer’s Availability requirements.
For Transportation client
developed procedure to decompose externally supplied XML files to untagged
relational data for later database manipulation. Used DB2 UDB V8 XML
Extender’s Collection-based access and storage method, RDB Node Mapping and
V6 to generate XML-related artifacts; tested XML document movement between relational
tables and WebSphere
MQ 6 message queues.
IBM Global Services, IBM Global Finance
Armonk, NY, 11/04-05/05
Snr. DB2 UDB Perf. Cons.
For IBM’s largest application, technical
lead for DB2 for z/OS
Performance/CPU Cost reduction project. Introduced
comprehensive performance analysis, reporting and tuning regimen, including install
and setup of DB2PE V2 and hands-on loading of its Performance Database with
detailed Accounting data, aggregated weekly, anticipating later use of MQT’s prior
to incorporation in upcoming V8; introduced
Buffer Pool Analyzer for buffer pool sizing and DB2 object placement.
With IBM Software Group’s Optimizer
Development, introduced new Statistics
Advisor tool for advanced statistics collection, query optimization of poor
data access paths (now part of Visual Explain V8,
and RUNSTATS in DB2 UDB for
z/OS V8); provided guidance on all performance-related issues relating to
both this critical application, and associated downstream Data Warehousing offshoots
(UDB on AIX, WIN); including install and benchmarking of both DB2’s new Q Replication with WebSphere MQ 6 and
DB2 Information Integrator, later re-branded WebSphere Information Integrator.
Ind. Automation Corp (NYSE)
New York, NY, 05/04-11/04
Snr. DB2 UDB DBA Cons.
For next generation NYSE trading floor
system, provided database support in multi-tier, distributed environment, with Java-based
Linux clients submitting to WebSphere Application
Server (WAS), executing remotely via DB2 Enterprise Connect against DB2 for z/OS. “Extreme Availability” environment required
duplexing of all components, including the database itself, RDBMS (SYSPLEX),
and WAS (“dual stack” concept). Designed
for platform independence, including usage of new application callable database
Utility interface via new Stored Procedure presenting consistent SQL interface
for invocation of systems commands, utilities..
With IBM Software Group Development,
tested performance, failover, availability and identification of overheads of WAS
stress-testing transactions to DB2 DataSharing Parallel Sysplex. Concurrent evaluation of strategy and
identification of deliverables to port 3-Tier server DBMS to DB2 UDB ESE
(LINUX) in anticipation of mid-stream change of platform.
Govt. entities (Austr.)
NY, NY, 2003
DB2 UDB D/W Cons.
For various Government entities designed
systems to extract operational data from DB2 for z/OS to DB2 UDB
ESE to populate data marts in clustered SMP environments, including
hands-on migration of DB2 UDB ESE
from V7 to V8.1; design of databases; establishment of formal performance
monitoring regimen with historical storage of data from then new V8 Snapshot Monitor
Table Functions, and Event Monitor Write To Table data, for historical trend analysis,
reporting and performance management.
For national Medical Insurance Co.,
SQL Replication, exploiting new cursor cross loader, utilizing Federated
database and associated object definitions to implement same (wrapper, server,
mapping and nickname for source, in target DB), as appropriate. This Federation functionality now part of the
re-branded WebSphere Information Integrator 8.2
product set (now WebSphere
Database Systems, Inc.
York, NY, 01/01-12/02
and Futures trader.
Stock and futures trader –
indexes, currencies, energy (for self)
(Mgt. Cons.Svcs) Svcs)
York, NY, 03/00-12/00
Cons., DW & BI Practice (F/T)
At PwC Management Cons. Financial
Svcs Vertical, worked with clients on applicability of appropriate tools for
various Data Warehousing architectural components (database design, data
acquisition, data management and storage, data delivery, data access, metadata
management, etc.) in a formal, methodology-based environment; Extensively researched critical Information
Integration and EAI technologies (messaging, hub/spoke, integration brokers),
and emerging e-Business inter-operability standards; viz. inter-enterprise
communications via well-defined interfaces, formats and protocols: the emerging
XML-based technologies SOAP, WSDL, UDDI (i.e. current Web
Services paradigm). Investigated and
advised on impact of XML on reduction of proprietary API’S required for
information integration, its value as mechanism for data interchange,
application integration and as new abstracted layer in emerging SOA paradigm.
Life Insurance Co.
York, NY, 03/98-11/99
DB2 DBA Cons.
Database support of the Firm’s various
DB2 for z/OS environments; incl. DB design, performance and change management.
Systemhouse (now EDS)
York, NY, 04/97-03/98
Sys. Integn., D/W Practice (F/T) Warehouse Practice
Advised clients on industry
developments in BI/Data Warehousing, incl. design techniques for Enterprise Data
Warehousing (EDW) vs. functional Data Marts, the painful debate between the two
competing design approaches (Inmon and IBM’s EDW vs. Kimball’s conforming Data
Marts etc.); methods for Data Mart consolidation; DW /DM design (Star Schema,
Snowflake, 3NF etc.), development and implementation methodologies; emerging technologies:
the new object/relational (“universal”) database servers, proprietary MDDB
products, ODS, applicability of various categories of OLAP tools (ROLAP, MOLAP),
exploitation of parallelism, novel architectures (NUMA, MPP), interoperability issues
in distributed environments. Prepared Customer
RFP’s, presentations, new business development and service offerings. Took lead in promotion of IBM’s then new Universal
DB2 UDB V5 on diverse distributed platforms, including parallelized version
(“EEE”, now DPF) within IBM’s Global Systems Integrator (GSI) program.
Hitachi Data Systems (HDS)
Seth. Korea, 04/1996
Consultant Performance Review
For HDS client, Samsung Heavy
Industries in Seth. Korea, formal performance review of poorly performing new Accounting
System. Top-down evaluation of all
aspects impacting DB2/MVS performance; system-wide MVS Performance, DASD
contention etc. through to individual SQL’s.
Sys. Integn Architect/ DBA Mgr.
For nation’s largest IT user,
worked within Integration Services team to implement Enterprise-Wide
Architecture for the entire Corporation, a proto-SOA, targeting application
inter-operability and sharing of “Databases of Record” (Customer, Product,
etc.), maintained by “System(s) of Record”; identified, designed and
implemented middleware solution required to concurrently develop and integrate
multiple huge new core business “building blocks” (Customer Billing, Service
Delivery, Product, Network) sharing both data and process across platforms on a
Implemented a solution connecting
these building blocks: OS, H/W platform, and language-independent architecture,
isolated presentation, data and process layers with “contract definition”, (an
IDL), contract registration, and well-defined application contract invocation
i.e. networked service invocation via well-defined interfaces, formats and
protocols for application inter-operability on heterogeneous platforms,
implemented as a separately abstracted layer, transparent to app. developers. This contract-based architecture has now
morphed into the XML/HTTP-based enabling technologies (SOAP, WSDL) and services
(contracts) defined in service registries (UDDI); Information understood and
delivered as a contract/service.
Hanover Bank (now JPM Chase)
York, NY, 1989-1992
DB2 DBA Cons.
For the Trust Bank, introduced, established
and implemented new DB2/MVS Environment for conversion of Global Custody system
from VSAM to DB2. Setup multiple testing
environments, and seamless migration of objects between same (absent modern
automated tools). Wrote all standards
for entire environment: naming
conventions, object migration, SQL programming techniques for performance,
mentored and formally taught staff, guided the Bank through the new RI features
of DB2 V2, complex Recovery/Restart issues in a High Availability global environment,
and introduced the new DB2 Package Bind feature, later published in leading
industry Journal (see Publications). The
application was an early user of BACHMAN Re-Engineering Product Set; single
Repository for all logical / physical database design products. Generated all DDL, including incremental, from
the tool for transfer to the mainframe.
Bankers Trust Co. (now Deutsche Bank)
New York, NY, 1988-1989
Snr. DB2 DBA/Modeling Cons.
For Global Custody, Data
Analysis, Data modeling and re-design of Bank's Master Trust system being re-engineered
Loaded complex SMF performance-related
DB2/MVS data into user tables for problem analysis, resolution and historical
trend identification of system usage. This
functionality now included by IBM into its DB2PE product.
IBM Consulting Services
Purchase, NY, 1988
DB2 Perf. Specialist Cons.
For IBM client (MONY), QA review
of 3rd Party Conversion to DB2: tuning of DB2 sub-system application with
DB2PM; CICS/DB2 Attachment; SQL code reviews; mentoring of staff on Access Path
Selection, efficient database design.
York, NY, 1987-88
Systems Programmer Cons.
As DB2 Systems Programmer, performed
installation, upgrade and migration of DB2/MVS to V1.2. Installed DB2PM V1.
Lynch and Co.
York, NY, 1985-87
DBA and DA (F/T)
As Manager of Database
Administration and Data Admin., recommended adoption of, and initiated
implementation of then new DB2/MVS product within the company, providing
overall direction concerning the establishment of DB2 in both Operational and
Informational environments; formulated standards, guidelines and procedures for
DB design and administration, application design, program development,
operation and recovery strategies, security and authorization, performance
monitoring and tuning. Introduced formal
IBM Application/Database Design Review process for critical, OLTP systems; initiated
implementation of DB2 extensibility into Corporate Data Dictionary, enabling
generation of DB2 DDL from that product from day one; at same time, started Greater New York DB2 Users
Group, 1985-1988 (First in Tri-State Region)
Concurrently with ongoing
Name/Address “Householding” exercise, took initiative to consolidate entire
Householded, demographics-enriched account Name & Address Master of some 7M
accounts, integrating all accounts under a common Customer, and Household,
respectively. Again, Customer and this
time also Household-centric approach as a new business value proposition, a new
way of doing business. Designed, and
loaded a “proto” DB2 Data Warehouse of this data serving needs of diverse
departments (Ops., Mktg., Compliance) as prototype for a Customer Information
System, and for stress/volume testing of the then new DB2 product. Organized and led a team, conducted a major
on-line transaction performance benchmark against this DB2 database. As Manager, trained and mentored staff,
conducted staff Performance Reviews.
SELECTED Industry Achievements
Instructor, Codd and Date, Inc. (inventors of relational model for RDBMS)
Design/Development for Performance; DB2 Recovery/Restart courses
book High-Performance Client/Server
(named back cover), Loosley/Douglas, pub. Wiley, NY, 1998
Database Programming and Design Magazine (now Intelligent Enterprise)
Founder and Coordinator
Greater New York DB2 Users Group, 1985-1988 (First
in Tri-State Region) aka “Merill Lynch DB2 Users
Financial Computer and Automation Conference (FINCOM), New York, NY
Share Guide (ASG), Adelaide, Australia, (Best Speaker, Applications Enabling
Database Administrator - DB2 9 DBA for Linux,
UNIX and Windows
Database Administrator - DB2 UDB V8.1 for
Linux, UNIX and Windows
Solutions Expert - DB2 UDB V5 for UNIX, WIN
Database Admin (1998)
Graduate Diploma of Computing Studies, University of Melbourne,
Bachelor of Economics (Honors Degree), Monash University, Australia