Project Data

TOM JOHNSTON

Cell: 618-***-****

********@*****.***

http://wwwcom/in/virtualdatabase

INFORMATION TECHNOLOGY DIRECTOR

Clearly articulating value proposition and developing strategic, consultative,

IT business solutions as a solutions architect and technical strategist.

Over 18 years experience in architecture of database management strategies, applications analysis, development, and implementation of IT-enabled customer systems linkages. Project management leadership roles with corporate clients include The Federal Reserve Bank, NIKE, Bank of America, ING, Genentech, and University of Iowa. Adept in business consulting, multi-platform integration, budget management, pre-sales, and cross-team collaboration.

Enterprise Architecture & Software Strategy

Metrics, Testing, Root-Cause Analysis

Data and Application Integration

Database Administration &Replication

SQL Forms, Oracle v.7 thru 11i, DB2

Microsoft SqlServer 2005/2008

SSIS

Technology/Business Linkage Planning

Model-Driven Architectures

Budgeting/ Leadership/ Collaboration

PROFESSIONAL EXPERIENCE:

Silo Fusion

(May 2009 -Present)

Solutions Architect/Data Architect/Data Modeler

Federal Reserve Bank

Data Architect for Treasury Relations and Systems Support (TRASS). Architecture for interoperability between numerous banks as well as architecture support for transition architecture encompassing migration and amalgamation of I.T. processing.

NIKE

Utilizing Teiid and EDS (Jboss AS) to create a common view of data. Also leveraged existing previously created Erwin models to use Logical Names and Business terminology at the data access layer. Architecture gave MDM, SOA and single view of data to the enterprise. Included multiple RDBMS flavors in addition to SAP

Customs & Border Protection POC

Proof of Concept to migrate VLDB (petabyte) systems (CA/Datacom) to Oracle. A meta-data gathering and driven approach was proven as well as a methodology to iteratively migrate data through a meta-data driven, scalable, and extensible solution.

United States Army

Research and development for futures program to move certain programs forward technically. Meta-data (MDM-lite) driven enterprise integrations were my key component and contribution.

Integration of many relational datasource platforms in addition to many products such as SAP, Peoplesoft, SalesForce.com.

Meta MATRIX /Red Hat

(Jan 2001-May 2009)

St. Louis, MO Data Architect/Data Modeler/Manager ConsultingPractice

Manage consulting group (team of 12) for Federal Consulting. Direct IT strategy in the design, code and implementation of customer-facing engagements, leveraging SQL, and PL-SQL; steer $2 million consulting engagements. Manage project budget and 10++ direct reports.

Designed a single source scalable data warehouse solution for data manipulation across Sybase Informix, SQL Server, and Oracle; managed architecture of the database management strategy and systems design.

Responsible for architecture of a Model-Driven enterprise system for a metadata repository project, used MetaMatrix suite of products for data analysis, database administration, and replication of virtual and physical layers. Also responsible for architecture for product being OEM’d as SAP NetWeaver product.

Analyze business processes, perform feasibility analysis; define product functionality, and cost/budget parameters for architecture of enterprise database infrastructure for transactional and decision support systems.

Drive pre-project scoping exercises to determine timelines, in & out scope items; design, develop, validate, and manage project interdependencies, data recovery, and integrity controls.

Negotiate (RFQ/RFP/RFIs) proposals, and SLAs/Service Level Agreements, forge new business solutions, and collaborate in consulting, acquisition, pre-sales, and systems installation.

Managed all installations of Oracle, SqlServer 2005-2008 (including SSIS), DB2, Red Brick, Informix, Sybase as well as any 'client' database that needed to be installed for testing.

Wesley Jessen

(Jul 2000-Nov 2000) Chicago, IL

Oracle DBA

Hired to collaborate in the migration of PeopleSoft from SAP; integral member of a multi-disciplinary project team; deliverables enhanced efficiency in planning, resource utilization, and budget forecasting.

Migrated company to a scalable application, integrating HP-UX environment with Windows/NT, and Citrix; oversaw implementation, migration, and system analysis integral to organizational readiness initiatives.

Performed prototyping and design activities for the system; conducted user acceptance testing, ensuring complete system functionality, configuration, support, and product delivery.

Managed full life-cycle deployment, including cross-collaboration, gathering business requirements, managing project scope, quality, deliverables, conceptual, logical and physical architecture designs.

Conducted business analysis, project reviews and feasibility determination, created specifications documents, managed change control, QA review and systems analysis.

Led kick-off meetings with all developers and project stakeholders. Defined and presented the project, team members’ roles, key deliverables and communication processes.

PROFESSIONAL EXPERIENCE (Continued):

Watlow Electric

(Apr 2000-Jun 2000) St. Louis, MO

Oracle DBA

Built an Oracle Repository to provide a robust e-Commerce/BTB environment.; led the architectural design, and development; significantly uplifted transactional data processing within client/server databases.

Performed project reviews, audits, and validations; conducted project management briefings, and prepared reports to reflect project status, schedule trends, and project uncertainties.

Resolved internal process deficiencies through due diligence, data management, collection, and deployment of an application that increased batch processing for extracting, posting, and tracking revenue activity.

Southwestern Bell Yellow Pages

(Jan 1999-Apr 2000) St. Louis, MO

Oracle DBA

Accountable for key technical deliverables throughout large scale management of data intensive environments. Managed three Oracle production processes on VMS.

Documented and resolved complex technical issues related to design functionality in the Data Warehouse system, resulting in faster access to critical information.

Identified system strengths/deficiencies, coordinated testing framework and a production database on HP-UX and a PowerMart running Oracle 8 on NT.

Other Related Experience:

Oracle DBA, Monsanto, St. Louis, MO, (Nov 1998-Jan 1999)

Oracle DBA, Typotronics, St. Louis, MO (Aug 1998-Nov 1998)

Oracle DBA, Jefferson Smurfit, Co.St. Louis, MO (Jun 1998-Aug 1998)

Oracle DBA, Ralston Purina, St. Louis, MO (Dec 1994-Apr 1998)

DB Analyst/Developer Independent Consultant (May 1994-Dec 1994)

Additional information at LinkedIn: http://www.linkedin.com/in/virtualdatabase

TECHNICAL EXPERTISE

Languages:

SQL, PL-SQL

Operating Systems:

Windows, HP-UX, Solaris, SCO Unix, AIX, RHEL

Database:

Oracle (5-11), SQL Server, DB2 (UDB)

Tools:

MetaMatrix, EDS, TeiiD, Business Objects, Crystal Reports, Informatica, MicroStrategy, InetSoft Reports

Open Office, Jasper, SQL*Plus, SQL*Forms 2.3 and 3.0, Gupta SQL, Excel, MS Word

Additional Hardware/Software Skills:

IBM PC 586/486/386, Hewlett Packard G 55, Solaris 3000,4000,4500, AT&T 6300 Workstations, DEC/DEC VAX, IBM Microsoft Virtual Server 3910, Apple Macintosh, IBM RS/6000, CYBER (4000 and 910), and RAID architecture storage devices, PowerBuilder, SQL*MENU, SQL Reportwriter, CHAMELEON, Oracle Pre-Compilers, dBASE X, TIPS, RIO, OMG, WebLogic 7, WebLogic 8.1, JBoss, WebSphere, R:BASE 5000

Contact this candidate