John Thompson

Current

• Senior Consultant, Lab Services, TES Domain at Cognos, an IBM Company

Past

• Senior BI Solutions Architect at Overrride Web Productions
• Senior BI Architect at Marriott Vacation Club
• Cognos BI Architect, Data Warehouse Architect, ETL and SQL DBA / Programmer at DOVER Corporation, Datamax O'niel

• Senior DBA, Data Modeler at Vanguard Fire & Casualty
• Data Architect , Net Branch Banking at Alternative Mortgage Funding Corporation
• System Engineer, Sever Ops at NASA, Boeing Consultant

see less...

3 more...

Education

• Virginia Commonwealth University

Recommended

4 people have recommended John

Connections

47 connections

Industry

Information Technology and Services

John Thompson’s Summary

John’s breadth of knowledge in Corporate Performance Management, Database Platform Architecture/Development and DW Relational Paradigms, and Business Process has come from 16 years educating and upwardly challenging himself by succeeding in a multitude of industries including Hi-tech Manufacturing, Financial-Services, Mortgage Banking, Insurance, Aerospace (NASA), Health Care (NIH), Consulting, Defense, Academia, and many Public and Government sectors.
He has played key roles in major projects and initiatives, all of which he considers to be great diverse experiences. John’s peers will call him a mentor, very bright, a team builder, a troubleshooter, and a “big picture” achiever with the ability to delegate and/or prioritize tasks effectively as well as roll up his sleeves and perform in the trenches.

John Thompson’s Specialties:

Solutions Architect adept in Troubleshooting enterprise DW/BI systems, design complex Proof of Concept models and BI apps,author advanced RFPs. Business Case & Data Analysis/ Modeling ER/Dimensional,Data Quality,MSSQL,Oracle,MySQL,Sybase,AS400, Cognos 7-8,IBM Websphere,Datastage,Data Manager(Decision Stream),SSIS.Full SDLC App Dev & BI Analytics EDM/MDM,Data Warehouse optimization HW/VM+DDS/ODS.

John Thompson’s Experience

• Senior Consultant, Lab Services, TES Domain

  Cognos, an IBM Company

  (Public Company; 10,001 or more employees; IBM; Computer Software industry)

  November 2007 — Present (1 year 1 month)

  Senior Consultant with IBM Cognos North Americas TES Services; a part of IBM's esteemed IOD (Information on Demand) for CPM, Financial Planning, and other associated products to leverage superior resources for world class and magic quadrant leader solutions.

• Senior BI Solutions Architect

  Overrride Web Productions

  (Privately Held; 11-50 employees; Marketing and Advertising industry)

  October 2004 — February 2008 (3 years 5 months)

  Consultant to Override Web and Media Productions assisting in RFP bids, requirements gathering, gap analysis, proof of concept, and creative OLTP and OLAP solutions for rich data cetric web enabled media that have involved: case studies, behavior modeling, ER OLTP modeling, Dimensional modeling, ETL & SQL programming, Business Intelligence tool selection, BI architecture, application development and full life cycle iterative deployment, Skilled in n-tier architectures, and SOA component architectures; gateways, portals, application servers, web server technologies: IIS, .NET, J2EE, JBOSS, BEA Web Logic, IBM WebSphere / Crossworlds, Cognos 8 BI, Informatica, Oracle 10g, MySQL, SQL Server 2005, SQL Anywhere, Solaris, Linux, Tomcat, Datastage, Data Manager, Terradata, OpenLDAP, Eclipse, Pentaho BI Suite, Hyperion, Rational Unified Process, WSDL, SOAP, UML, RFID, XML schemas, PowerDesigner, CBIP.

• Senior BI Architect

  Marriott Vacation Club

  (Public Company; 5001-10,000 employees; Hospitality industry)

  January 2007 — November 2007 (11 months)

  Lead Cognos Solutions Architect and KPI Reporting Developer; Data Architect and DW modeler providing the client with full SDLC Cognos 8 POC through UAT and Production BI implementation

• Cognos BI Architect, Data Warehouse Architect, ETL and SQL DBA / Programmer

  DOVER Corporation, Datamax O'niel

  (Public Company; 501-1000 employees; DOV; Logistics and Supply Chain industry)

  January 2006 — February 2007 (1 year 2 months)

  SQL Server 2000/2005, Sybase SQL Anywhere, Titanium OLTP support of manufacturing ERP and MRP systems and all supplemental systems attached: Supply Chain, CRM, Accounting, Engineering, Billing of Materials, application and Database support. Tasked with implementing a Decision Support System to provide analytics to upper management and department personnel. Determine the BI Application objectives, Analyze external data sources, develop and refine logical data model, Define Reporting Requirements , Create metadata models, Design data warehouse: Staging/ODS/DDS from ERP/MRP source system, and other heterogeneous data sources including over 120 disparate dbs, Design of OLAP Multidimensional data stores ,design ETL Process Flow per LOB, integration and regression test ETL, Build the application program framework and author rich reports (Cognos 8 BI)

• Senior DBA, Data Modeler

  Vanguard Fire & Casualty

  (Privately Held; 201-500 employees; Insurance industry)

  December 2005 — April 2006 (5 months)

  Participate in the Business Case Analysis, Logical and Physical Design and Implementation of SQL Server OLTP and Multidimentional schemas for databases in SOA Insurance Underwriting and Quoting System, Claims Management System, and functional Business Intelligence. Support of Information Data Warehouse supporting Decision Support System for corporation. Secondary actor in upgrade to Cognos 8 Business Intelligence Suite from Cognos 7.

• Data Architect , Net Branch Banking

  Alternative Mortgage Funding Corporation

  (Privately Held; 501-1000 employees; Banking industry)

  2001 — 2005 (4 years)

  Data Analysis, Data Modeling/Mapping, DBA, Manage SQL Server 2000; Design & Co-Author new innovative way for collaboration between FNMA and Real Estate parties utilizing secure internet application and portal for data object sharing at multiple access levels, as well as ad-hoc dimensional reporting capabilities. Performed Data Mapping and Data Modeling for finalized Database Designs. Responsible for incorporating process controls with governing compliance policies for Sarbanes Oxley § (302,404), HUD, and RESPA § 494.

• System Engineer, Sever Ops

  NASA, Boeing Consultant

  (Government Agency; 5001-10,000 employees; Aviation & Aerospace industry)

  1997 — 1998 (1 year)

John Thompson’s Education

• Virginia Commonwealth University

  1991 — 1995

Additional Information

John Thompson’s Groups:

•    Business Intelligence Group

John Thompson’s Contact Settings

Interested In:

• job inquiries
• expertise requests
• reference requests
• getting back in touch