James Dionne

Work History

Work History
Jun 2008 - Present

Consultant for Maersk Inc, as Sr. Technical Architect

Knowledge Forward

Responsible for managing Oracle on Solaris and a Custom Invoice Error Tracking System.

Major accomplishments:

  • Designed and implemented custom ETL using shell scripts
  • Performed extensive performance monitoring and enhancement within the Oracle environment.
  • Maintained and enhanced custom Invoice Error Tracking System using HTML, Javascript, and Visual Basic
  • Created and Maintained project company web site using Microsoft Share Point

Knowledge Forward, Consultant for Maersk Inc, as Information Architect

August 2007 - June 2008

Responsible for managing DB2 on Solaris and add hoc data feeds for the Copenhagen Data Warehouse.

Major accomplishments:

  • Designed and implemented custom ETL using shell scripts
  • Performed extensive performance monitoring and enhancement within the DB2/Unix environment.
  • Coded mainframe add hoc reports
  • Coded mainframe processes to feed down stream applications
Sep 2000 - 2007

Sr. Data Warehouse Technical Architect

Consultant for Maersk inc

Responsible for the technical planning and implementation of the Maersk North American Data Warehouse. 

Major accomplishments:

  • Designed, configured, tuned, and monitored SQL Server 2000 environment for analytical reporting. 
  • Formed a reliable backup and recovery strategy. 
  • Created complex SQL Server 2000 DTS packages. 
  • Designed and implemented data models for intuitive and responsive analytical reporting. 
  • Created customized Microsoft Access user interfaces
  • Implemented Ascential DataStage version 7.1 and later 7.5. 
  • Created ETL standards to automate development, troubleshooting, and monitoring of jobs.
  • Designed, configured ,tuned, and monitored DB2 UDB v 8.2 environments.
  • Created the database standards.
  • Maintained Hyperion Essbase 6.5 cubes.
  • In-depth development using Hyperion Analyzer 5.x and 6.x.
  • Administration of all Hyperion environments.
  • Planned and implemented Windows 2003 64 bit clustered environment. 
  • Installed, configured, tuned SQL Server 2005 64 bit Active/Passive cluster.
  • Managed SQL Server Migration project from SQL Server 2000 to SQL Server 2005
  • Managed SQL DTS Migration project from SQL Server DTS jobs to SQL Server 2005 SSIS packages.
  • Maintained the Business Objects 6.5 and Business Objects XI repositories.
  • Managed all server operations including backups, software updates and hardware configurations for SQL Server 2000, SQL Server 2005, Hyperion Essbase, Hyperion Analyzer, Ascential DataStage, DB2 v 8.2 and Business Objects.
Mar 1999 - Aug 2000

Consultant for IBM

Computer Generated Solutions

Responsible for assessing the nature of the technical problem facing the IBM field technician and engaging in trouble shooting to isolate the exact problem.

Major accomplishments:

  • Mastered the IBM internal Data infrastructure.
  • Fine tuned the skill of speaking someone through technical repairs.
  • Guided technicians in configuring Windows 95, Windows 98 and Windows NT.
May 2000 - Aug 2000

Consultant for Bank of America

GE Capital

Responsible for maintaining Bank of America's EWAN desktops.

Major accomplishments:

  • Configured and installed new EWAN desktops
  • Performed trouble shooting exercises
  • Installed all software including proprietary bank applications for different departments
  • Performed complete relocation of systems and guaranteed system operation after the move.
Jun 1998 - Mar 1999

Computer Engineering Lap Technician

Stanly Community College

Responsible for lab stations and work stations used for class discussions and lab exercises.

Major  accomplishments:

  • Maintained all lab stations in working order. 
  • Maintained software updates.


Microsoft Certified Professional

  • SQL Server Design
  • SQL Server Administration

A+ Certified Computer Technician

Summary of Qualifications

A technical data warehouse architect fluent in Microsoft SQL Server and IBM DB2.  Skilled at visualizing the entire warehousing data stream and implementing the correct tools at all the critical junctures.  Very flexible to the business reporting needs being fluent in Business Objects, Hyperion Analyzer, custom Microsoft Access front ends, and one off add hoc reports.  Uses technology to multi-task including configuring automatic monitoring and notification for production environments and systems.  Very knowledgeable in dealing with the interaction of Microsoft Windows servers and the applications that run on them.  Can interact with any level of management or team member at any skill level and can be very project oriented. 

Major strengths:

Business Intelligence 

System Administration

Data Warehouse Technical Planning

Production Application Support

Data Warehouse Technical Implementation

Database Administration


  • Microsoft SQL Server 2000 (8+ years)
  • Microsoft SQL Server 2005 (3+ years)
  • IBM DB2 UDB (5+ years)
  • Asscential DataStage 7.5.1 (5+ years)
  • Microsoft SQL Server DTS (8+ years)
  • Microsoft SQL Server SSIS (3+ years)
  • Business Objects (5+ years)
  • Hyperion Analyzer (8+ years)
  • Microsoft Windows 2000 (8+ years)
  • Microsoft Windows 2003 (5+ years)
  • Sun Solaris 5.1 (1+ year)