Grant’s Current Projects:

Currently I have some projects I’m working on for completion in the next several months:

  • An article series on Software Psychology which will lead to a book.
  • Completion of my OLAP cube book for managers and users.
  • A video course on OLAP cubes.
  • Release of many of the small but useful software tools that I have developed as free tools.
  • Release of some commercial software that I have under development.

Major Projects and Accomplishments – AT&T

2010:(Started late 2010)

  • Provided .NET C# Windows and ASP.NET development services with IronSpeed and DevExpress components.
  • Provided SQL Server database and OLAP Cube development services.

2011:

  • Dundas Dashboards.
    • Evaluated dashboard vendors and recommended Dundas.
    • Created Data Core Dashboard POC.
    • Created 17 prototype and production dashboards.
    • Enhanced dashboards with Silverlight scripts.
  • Developed department OLAP cube standards.
  • Provided .NET development services – C# in Windows forms and ASP.Net web forms.
    • With IronSpeed and DevExpress components.
  • Provided SQL Server database and OLAP Cube development services.
  • SharePoint 2007 administration and dashboard and report integration.
  • IronSpeed training.

2012:

  • Created Two Training Videos:
    • Introduction to OLAP Cubes.
    • Excel Pivot Tables with OLAP Cubes.
    • Both were added to the corporate learning course systems (LSO).
  • Delivered OLAP Cube and Excel Pivot Table training sessions.
  • ERD – Engineering Rules Database.
    • Developed KPI/KCI data dictionary for network engineers.
    • C# in ASP.NET with DevExpress components.
  • LTE OLAP Cube.
    • Crash 6-week project to put the most critical LTE network KPIs into an OLAP cube.
    • Complete with ETL in SSIS and load status reporting cube.
  • EBT – Engineering Budget Tool.
    • C# in ASP.NET with DevExpress components.
    • Financial tracking tool replacing Excel spreadsheets to track network component budgeting and financial planning.
    • Built additional components in Windows forms:
      • Excel spreadsheet data loader to SQL Server database.
        • Automated with extensive data cleaning functions.
      • Excel-like data editing tool with data export capabilities.
    • Aspire Web Application Framework.
      • C# in ASP.NET with DevExpress components.
      • Modular components including a custom dashboard.
      • Database driven.
      • Used to power the EBT application.
    • Provided .NET development services – C# in Windows forms and ASP.Net web forms.
      • With DevExpress and custom built components.
    • Provided SQL Server database and OLAP Cube development services.
    • LogiXML training.
    • iRise training.

2013:

  • DnF Charts Tool Application System.
    • Provides semi-automated construction of complex performance charts via a wizard interface for network engineers and managers.
    • C# in Windows forms with DevExpress components.
    • Click-Once web deployment for the Builder/Editor component.
    • Web ASP.NET chart viewer.
  • Chart Manager provides management of hundreds of charts in a database repository.
    • ETL in SSIS for Training Dashboard (LogiXML).
    • Built in Microsoft SSIS with SQL Server 2008 R2 and Oracle database tables.Accumulates individual training completion data for summary on Training Dashboard.
  • Provided .NET development services – C# in Windows forms and ASP.Net web forms.
    • With DevExpress and custom built components.
  • Provided SQL Server database and OLAP Cube development services.