Data Sql Server

Steven D Wright

** ***** **** **., ********, MA *1835-8279, Phone: 978-***-****, Cell: 978-***-****, abph94@r.postjobfree.com

Please See Personal Home Page: http://StevenDWright.home.comcast.net/

28 years hands-on experience in all aspects of the Information Technology.

S UMMARY

Skilled in Data Architecture, Data Warehousing, Transaction Processing,

Knowledge Representation, Ontology, Metadata Repositories, Enterprise

Integration, Performance Tuning, Storage Systems, Project Management,

Methodologies, Requirements Analysis, UML, XML, Executive Information

Systems, B2B Marketplaces, Business Intelligence.

S OFTWARE Oracle (15yrs), IBM DB2, SQL Server, MySQL, PostgreSQL, DB/Studio, ERwin (15yrs),

XML Schema, UML, Rational XDE, Rational Rose, Together Command Center, Java,

Visual Studio, .NET, C#, Visual Basic, C, COBOL (5yrs), FORTRAN (5yrs), PL/1,

PostScript, and several assemblers, LDAP, Sun Identity Server, SQL, JDBC, SQLJ,

Paradox, Forest & Trees, CaliberRM, Crystal Reports, Documentum, OpenText, eRoom,

Lotus Notes, UNIX, Windows, TSO, DOS/VM, TCP/IP, MS Office VBA, Access,

Project, Groupware, PM and CASE tools. Familiar with: Application Express (APEX),

EJB, Magic, Pascal, LISP, APL, Forth, dBase, R:Base, QBE, Focus, Informix, DBArtisan,

FOCAL, EDX, PAL III, BL/1, S, ViewPoint, CASE 2000, ALGOL, PL/M, OLE, DDE,

DMTF, WBEM, SMARTS, CIM, ACORD, HL7.

O BJECTIVE Lead Design & Delivery role in Enterprise Data Architecture & Modeling, Data

Warehousing, Database Tuning, Integrated Supply Chains, Knowledge Management or

Medical Informatics. Full-time, or long-term part-time DBA Maintenance Contract.

A SSOCIATIONS Mensa.

E XPERIENCE

Genalytics, Andover, MA

5/23/05 -

present

Lead Data Architect & DBA

Responsible for several multi-terabyte databases of every person in the U.S. using genetic algorithms for

predictive analytics & target marketing. Logical & physical schema design, selection & configuration of storage

arrays, recovery & upgrades, and database & application performance tuning. Built Metadata Repository.

Tools: Oracle 9i & 10g ASM, XDB, MySQL, PostgreSQL, Statspack, Java Stored Procedures, Application

Express (APEX), Regular Expression & Advanced Analytic SQL Functions, CASS, DPV, MDM.

Knowledge Management, Bradford, MA

8/12/02

5/22/05

Free Agent Contractor, Senior Data Architect, Chief Knowledge Officer

See

Gun-for-hire providing Data Architecture Design, Implementation & Tuning Services in short-to-long term

contracts

contracts. Contract history to follow

below

McKesson Health Solutions, Newton, MA

contract

11/29/04

Lead Data Architect

- 4/8/05

Technical Team Lead for the development of an Ontology & Information Model covering the Medical Services

domain, including semantics, classification taxonomy & speech acts. Ontology used to generate first -pass UML

models, Web Services XML Schemas, Canonical Data Model, Semantic Web (OWL), Repository Metadata,

ETL & BI Metadata, and Sarbanes-Oxley PO2 requirements.

Lead Data Architect for the design of McKesson s Heath Data Repository unifying medical data across

applications, services and enterprises. System based on agile meta-model driven by Metadata Repository.

Tools involved: Prot g, ER/Studio, OWL, HL7 RIM, Ascential, SOA, Oracle10g, SQL Server, BPEL4WS.

Steven D Wright Page 2

Phoenix Wealth Management, Hartford, CT

contract

10/18/04-

Enterprise Data Architect

11/12/04

Provided independent analysis of the impact and level of effort required to replace Policy Administration

System. Studied 31 impacted interfaces for level of ETL effort. Suggested technical architecture for batch and

real-time interfaces employing Service Oriented Architecture.

Provided the level of effort needed for the creation of a Canonical Data Model representing a fusion of

AdminServer DB, the ACORD Standard and Phoenix data requirements. Provided the level of effort needed

and technical architecture for an Operational Data Store.

Tools involved: ERwin, ACORD Standard, AdminServer, SeeBeyond, Cognos, SOA, DB2, SQL Server,

Software AG Tamino.

Houghton Mifflin Company, Boston, MA

contract

4/1/04-

Enterprise Data Architect

10/1/04

Designing Enterprise Schema for Digital Publishing applications across 8 Divisions leading an EAI effort.

Documented current and future technology stacks. Integrated schema spans relational, content management and

XML stores and technology. Taxonomies, educational content life -cycles, knowledge representation, student

assessment, and psychometrics. Positioning company for the advent of the W3C Semantic Web.

Initiated and led an evaluation of tools to extend and scale Adobe InDesign & InCopy Creative Suite to

enterprise levels. Technologies: XMP, Woodwing SmartConnector, K -4, PlanSystem3, EMC Documentum.

Performed an internal audit of the company s Information Architecture in accordance with the Sarbanes -Oxley

Act using IT Governance Institute's Control Objectives for Information and related Technology (CobiT PO2).

Tools used: Documentum, Oracle 9i, SQL Server, Prot g, ERwin, KLEEN, Turbo XML, XMP, Brio,

VB.NET, C#, eclipse.

Blue Cross Blue Shield of Massachusetts, Boston, MA

contract

12/1/03-

Sr. Data Architect

2/29/04

Responsible for LDAP schema & DIT design for the security migration from Netegrity s SiteMinder to Sun s

Identity Server on Directory Server. Created UML class diagrams of LDAP meta -schema, IETF RFC

objectClasses, Identity Server objectClasses, and Blue Cross objectClasses and DIT structure and relationships.

JPMorgan/American Century, Kansas City, MO

contract

7/8/03-

Software & Data Architect

9/25/03

Responsible for delivering the plans of a Data Center separation and move from the software and database

reengineering perspective. Total assets of $7.5 billion in various controlled funds. Reengineering must prepare

for 900% increase in scale and transfer from CA Advantage Gen to J2EE.

Coded proof-of-concept that SQL reengineering can prevent CPU upgrade, saving $1 -2 million.

Tools used: CA Advantage Gen (TI IEF, Cool:Gen), IBM DB2 UDB, ER/Studio, COBOL, WebSphere.

Steven D Wright Page 3

TJX (TJMaxx, Home Goods, Marshalls), Westborough, MA

contract

6/4/03-

Database Tuning Expert

7/3/03

Brought in to solve extreme problems related to scalability and concurrency. By the third day instituted

adjustments that increased performance of a key query by 2,526% and improved performance of many other

database commands. By end of month every SQL command was reduced to sub -second execution. Typical

performance improvement was over 1,000% per query. Eliminated severe deadlocking issues.

Before moving on to next assignment provided client with a 25 -page document detailing lessons learned and

plans for further tuning of the database and recommendations for reengineering their application.

Tools used: IBM DB2 UDB v7.2, Lawson Accounts Payable, CA AllFusion ERwin Data Modeler.

Hong Kong & Shanghai Banking Corporation (HSBC), NYC & Buffalo, New York 14203

contract

8/12/02-

Data Warehousing Architect

4/14/03

Design and built a Financial Data Warehouse for Federal Regulatory Reporting and analysis of North American

Operations including the Caymans, Mexico, Canada, etc. (HSBC is the world s second largest bank.) Designed

to incorporate 43 separate transactional systems. This is N. America s first major data warehouse. Staging,

Historic ODS, Data Warehouse, and Regulatory Data Mart; federated configuration.

Design and built a Metadata Repository & custom-ETL facility for over 5,000 user-driven Business Rules.

Contract was extended 3 times beyond the initial design phase so I could drive the development and tuning

phases and 5-year design perspective. System was delivered on-time and per specifications.

Tools used: CA AllFusion ERwin Data Modeler, IBM DB2 UDB v7.2, DB2 Information Catalog, ETI*Extract,

Business Objects, FRS FiRE, Hyperion Enterprise, OS/390, RS6000, AIX, Unix script. Hierarchy bridge table

for organizational and historic transitive closure.

OneSource Information Services, 300 Baker Ave., Concord, Massachusetts

9/17/01-

5/17/02

Lead Information Architect

Information Architect, Compiled all schemas across the company, and designed the meta -models for new

metadata-driven software environment. Became familiar with ADO.NET s unique meta -model for

heterogeneous access over many data sources feeding disconnected DataSets. Designed Content Repository

employing entity-attribute-value triples and tuned the database for subsecond performance.

Team Lead, Led a team in the design of the compan y s new Data Dictionary and Content Repository with ETL

and taxonomic integration. Tools used: Visual Studio, Microsoft .Net Framework, C#, XML, UML, Visio,

Rational XDE, Erwin, Oracle8i, SQL Server 2000.

NaviSite, 400 Minuteman Rd., Andover, Massachusetts

2/26/01-

7/31/01

Chief Software Architect

Information Architect, Drove the design patterns and schema of new intellectual property for an Operations

Support System (OSS) with SNMP monitoring and automated application provisioning under variable demand

in a shared, dynamically scalable, high availability architecture. C#, .NET, ER/Studio, DBArtisan, SQL Server,

CISCO.

Enterprise Schema, Event Correlation & Workflow Architect, Researched A.I. algorithms used in root-

cause fault analysis, and technologies used in emergency workflow and workforce management over 3,000

servers. Evaluated reuse vs. build vs. buy decisions. Directed company towards adoption of Distributed

Management Task Force (DMTF) Web-Based Enterprise Management (WBEM) and the Common Information

Model (CIM) standards and technologies. Selected product with integrated auto-discovery of network topology

(layers 2,3,4), monitor deployment, root-cause & impact analysis.

Steven D Wright Page 4

Perot Systems Corp.; Time LLC, 101 Main St., Cambridge Massachusetts

5/12/97-

1/9/01

Perot acquired Nets Inc team in a bid against IBM

Systems Integration Advisor (Technical Director level)

Information/Data Architect, Responsible for the technical solution for the management, storage, access,

navigation, movement, and transformation of data. Created the ER schema & UML domain model & d ata layer

of several major multimillion-dollar digital marketplaces, including W.W.Grainger and PNC Bank. ERwin,

Rose, Oracle.

Labs Technologist, Conceived, developed & benchmarked new technology prototypes for next generation

intellectual property. Specifically focused on models employing dynamic metadata, supply-chain workflows,

legacy integration, and contractual relations. Oracle9i AS.

Labs Eval Leader, Led team evaluations of commercial products for corporate standards. Led 9 -SWE, 9-

month evaluation of UML modeling tools: Rational Rose, Together, SA2001, GDPro, Platinum Plus, Visio,

StructureBuilder.

B2B Strategic Advisor, Projected the topology of the emerging EC marketplace. Researched and solved issues

dealing with metadata, ontology & epistemology. Made presentations to Gardner Group, Seybold, META

Group, and Forrester. META Group stated my design was 6 months ahead of all other B2Bs.

Nets Inc., Five Cambridge Center, Cambridge Massachusetts (acquired by Perot Systems)

1/1/97-

5/9/97

Founded by Jim Manzi (from Lotus) as world s leading B2B provider

Principal Systems Architect/Information Architecture

Enterprise Data Architect, Crafted Data Model for representation & navigation of complex manufacturer

product data & commerce artifacts across all industries under a unified ontology, semantics, taxonomy &

structural representation. ERwin, Rational Rose, Oracle, Informix, EDI.

Information Architect, Responsible for the product selection, policy & design methodologies of all data

repositories and flows.

Ideon Group (acquired by CUC, now Cendant), 10450 S.W. Nimbus Rd., Portland, Oregon

4/95-

11/96 Director of Software Engineering

Data Warehouse & Executive Information System, Designed & implemented EIS and Data Warehouse.

Lawson Financials, Unix, Oracle, ODBC, MS-Query, OLE, Excel, VBA, Pivot tables.

WebMaster, Inter&Intranet, Netscape Enterprise Server, HP -UX, T1, Java, MS VJ++

Enterprise Data Architect, Credit Card Security Services, ERwin, Oracle.

Steven D Wright Page 5

AT&T, 8000 Baymeadows Way, Jacksonville, Florida

4/85-4/95

Data Warehousing Manager, Conceived, promoted, designed, implemented and managed many of AT&T s

primary data warehouses and multi-terabyte data stores tracking AT&T s campaign against MCI & Sprint.

Coordinated multi-gigabyte data flows through multiple mainframe, PBX, mini, SMP and PC platforms.

Selected, trained & led knowledgeworker teams across US & Canada. Extensive database tuning and protocol

stack architecting. Unix script, Oracle, SQL*Net, TCP/IP, LanManager, Windows, DDE, OLA, VBA.

Value Added Market Intelligence System: Strategic AT&T Data Warehouse to produce statistical analysis

and graphs of distribution & time -series utilization for major 800 number customers. Warehouse held full

geographics, demographics & psychographics of everyone in the United Sates. Coordinated implementation

between Bell Laboratories and AT&T. Full responsi bility for code maintenance & operation. Pyramid RISC

SMP, Unix. Code is written in C & S-Plus, korn shell, yacc, lex, ifs, Unix B-trees, ttu, SCCS, Writers

Workbench (tbl, nroff, troff, etc.) and PostScript.

AT&T Market Research: Designed and implemented a market research system and Data Warehouse and

numerous other Data Warehouses across the U.S. AT&T also sold my Data Warehouse solution to the second

largest telephony company in Canada.

Executive Information System: Design & implemented four generations of EIS for the President and VPs.

Employed touch-screen neo-ISDN telephony, Balanced ScoreCard integration to all strategic systems. On e EIS

system managed a massive reengineering project. Design was used as the basis for the system that won AT&T

the Malcom Baldrige Quality Award.

Information Center: Led department that established methods, policies, practices and procedures related th e

use of Personal Computers at AT&T. Coordinated operation of team supporting hundreds of PCs and networks.

Set PC policies & standards and supervised all PC purchase orders. Designated top -echelon support for problem

resolution of systems involving PCs.

Government Services: Participated in the design of a statewide network for Electronic Funds Transfer of

government services. SmartCards, CAT scanners, ATMs.

WB&TS, 25 Columbia Heights, Brooklyn, New York; Wallkill, N.Y.

1978-

1985

End User Services: Responsible for international PC & LAN product selection.

Application Generator, Senior System Designer: Designed 4GL application generator & DBMS for use in

Foreign Branches. Description: bootstrapped from OO threaded interpretive kernel to extensible Logo-like

language. Non-procedural visual specifications are interactively mapped to an object datastore via Jackson JSD

methodology. In retrospect, it s very much like today s Oracle10g APEX.

Fourth Generation Services: Trained and supervised manageme nt in the construction of the following systems:

Accounting, Purchasing, Receiving, Inventory, Personnel; and tracking of Labor, Vehicles, Equipment, Food &

Utilities. Created MRP for the Computer Manufacturing department.

Magazine Distribution System, Chief Programmer: Headed a chief programming team in the development of

order & distribution system, using COBOL, EDL, MTM & ISAM on IBM S/1.

Systems Analyst/Designer: Pioneered use of Structured Analysis & Design methodologies. Proposed interim

change in manual operations resulting in over 40% reduction of accounting workload and 20% improvement in

accuracy.

Advanced Computing, Orange Park, Florida

1975-

1978

Corporate Secretary & Treasurer: family owned service bureau. Serviced of all CPAs in Jacksonville, Fla.

Manager of Payroll Services: Responsible for maintenance, operation and security of Fortran payroll program

and clients. Monitor tax laws across 13 states.

Manager of Application Services: Created client applications using RAD. PR1ME BL/1 4GL. Revised

programs and trained users in company changeover from computer service bureau to time -share services.

Excellent references will be furnished upon request.

REFERENCES More details at: http://stevendwright.home.comcast.net/

Contact this candidate