About Me


I have been a professional computer programmer for almost 30 years. My main areas of expertise are in database applications and programming tools. Lately, I've also spent quite a lot of time in the specific field of reporting, which also includes some work on building data warehouses. My current programming language of choice is C#.Net.

Although I have a full-time day job, I've been taking on part-time consulting work. I generally have about ten hours per week available, which works well for small projects. In the past year, I've been doing a lot of work on the Office Open XML File Formats. In particular, I was a major contributor on the PowerTools for Open XML and wrote a couple of blog posts in connection with that.

My interests are varied, so expect to see a wide range of information here.

author: bmcclellan | Posted On Friday, April 24, 2009 6:59 AM | Feedback (0)

Resume


Robert G. McClellan

Denver, Colorado

Title: Senior Developer

Summary

  • Over 20 years experience in database design and applications, database reporting, project management and contract work.
  • Strong communication and interpersonal skills with special abilities to bridge the gap between technical and non-technical personnel.
  • Dependable, thorough, and self-motivated with the ability to acquire new skills quickly on the job.
  • Extensive “hobby” programming of games using DirectX, .NET, Windows Presentation Foundation and other systems.

Education

Bachelor of Science in Information Technology                         2003

University of Phoenix, Denver, Colorado

Professional Experience

Software Developer Consultant

Consultant for Microsoft, through consulting companies                            2007-present

  • Created sample applications in connection with the Office Open XML standard for both Windows and Linux.
  • Design and development work on the OpenXML PowerTools for PowerShell.

Reporting Engineer

Hannover Life Re, Denver, CO (was Scottish Re)                                     2007-present

  • Developed and implemented a small data warehouse using Microsoft SSIS (SQL Server Integration Services).
  • Created several Business Objects universes (self-taught skill).
  • Developed dozens of reports using Microsoft Reporting Services and Business Objects.

Reporting Engineer

Consultant for Scottish Re, Denver, CO

(Placed through Apex Systems, Inc.)                                                             2006-2007

  • Developed reports using Microsoft Reporting Services with extensive creation and correction of SQL stored procedures to support reports.

Business Reporting Analyst

Dell, Inc., Round Rock, TX                                                                             2005-2006

  • Participated as a key team member in a business improvement process (similar to Six Sigma) resulting in multi-million dollar annual savings.
  • Developed a customized data processing and reporting system from SQL data sources using stored procedures, Microsoft OLAP, MDX queries, Microsoft Reporting Services and C#.Net web interfaces.

Database and Reporting Developer

Consultant for Dell, Inc., Round Rock, TX                                                      2004-2005
(Placed through Paladin Consulting, Dallas, TX)

  • Developed customized reporting systems from large SQL data sources using stored procedures, Microsoft Reporting Services and C#.Net web interfaces.

Senior Software Engineer

PowerVista Software, Denver, CO                                                                 1993-2005

  • Designed and implemented a sophisticated database application development tool using C++ and various SQL database products. Worked with a small team through multiple iterations of the development life cycle including support of old versions and product installation packages.
  • Wrote hundreds of pages of user documentation using Microsoft Word with style sheets and also converted to Windows Help format for online documentation.
  • Managed the company as a whole with two other major owners including finances, strategic planning and hiring.

Software Engineer

Independent Consultant                                                                                   1987-1993

  • Handled projects through the full life cycle of analysis, design, implementation, testing and installation.
  • Developed software programming tools allowing cross-platform programming for MSDOS and Unix using the C programming language and various database products.
  • Created a simulator for a hand-held computer using the C programming language that would allow debugging in a Microsoft Windows environment before loading the program onto the hand-held.

Programmer/Manager

Illinois Business Consultants                                                                            1982-1987

  • Created software development tools using assembly language and C on Apple II and IBM PC computers.
  • Converted an educational game program from Apple II assembly language to run on the IBM PC using the C programming language with some assembly language.
  • Promoted to lead designer for software development tools.

Computer Skills

Computer Languages:   C++, SQL, C, Active X/COM, DirectX, Microsoft Foundation Classes (MFC), Visual Basic, C#.Net, Assembly Language, Windows Presentation Foundation.

Web Languages:             HTML, ASP, ASP.Net, Javascript.

Software:                         Microsoft Office, Visual SourceSafe, QuickBooks.

Operating Systems:       MSDOS, Windows, Unix.

Database Systems:         Microsoft SQL Server 2005 including Integration Services, Microsoft OLAP and MDX.

Reporting Systems:       Microsoft Reporting Services, Business Objects.

Awards

Cross Functional MVP of the Quarter (Dell, Inc.)                                                    2005

 

author: bmcclellan | Posted On Friday, April 24, 2009 6:58 AM | Feedback (1)