Dian D. Chapman

Contact Dian
References
Technical Vitae

Consulting Work
See Recent Projects


Overview
       

A Technical Consultant with 19 years of computer experience and 13 years on the Internet; experienced in graphic design, computer training, solution providing, software development, technical writing/editing, beta/QA testing, hardware/software technical support, database development/management, web development, and document and project management.

I enjoy staying on the cutting edge of technology. Having a wide variety of talents, skills and abilities means I can get the job done.


Awards

Microsoft MVP (Most Valuable Professional) annual awards, 1995–2006

MSO Certified (Microsoft Office Specialist) 2001–2006

CompuServe CSP (CompuServe Support Partner), 1996–1998

Microsoft sponsored attendance at exclusive MVP Summits, 1996–2006


Professional
Memberships

MSDN (Microsoft Developer's Network)

Microsoft beta team member, active since 1996

TechNet

 

Summary of
Qualifications
           
Former technical graphic designer, mastering numerous applications including Ventura Publisher, Word Perfect, Corel Suite, MS Office; software developer/solution provider using WordBasic, MS Office VBA and VisualBasic, specializing in OLE/ADO automation with custom database design; beta tester/quality assurance using PVCS, Visual Source Safe, custom Outlook newsgroups, developed QA system using Word and Outlook; Internet/Intranet developer using Visual InterDev, HomeSite (HomeSite 4.0 beta tester), Dreamweaver 3 through 8, Flash, Fireworks, PSP, FrontPage, notepad; experienced using DHTML, JavaScript, VBScript, XML, ASP, ADO, PWS, IIS, basic knowledge of CGI with Perl and SQL Server; Technical Support Supervisor; high-end hardware/software Technical Consultant (escalation engineer); commercially published technical writer; editor of online Ezine; instructor of MS Word advanced skills and VBA programming; project manager utilizing MS Project and Visio; can/has quickly become proficient with numerous software applications, development tools, technologies and operating systems; moonlights as MVP technical support specialist for Microsoft's Internet newsgroups and various list servers, including several of her own; assisted with Microsoft application support as CompuServe Support Partner; individual TechNet subscriber; individual MSDN Universal subscriber; and Microsoft beta team member. Teaches Microsoft Office courses through CSI and, formerly, through Eclectic Academy.
 

Employment
           
Jan/02–
Present

MouseTrax Computing Solutions/Consulting
Technical Consultant, Programmer, Tech Editor/Writer, Instructor

  • Various in-house and telecommuting projects (samples) for clients providing: technical support, technical writing, Microsoft Office VBA development, documentation workflow analysis and enhancement, Word document automation with database connectivity, instructor for Microsoft applications and operating systems, web design/development and webmaster services.

  • Authored/developed three technical eBook courses of her own on advanced Word subjects and VBA programming.

  • Technical Editor for Wiley Publishing. Edited Word 2007 Bible and Office 2007 Bible.

  • Editor-in-Chief of TechTrax Ezine, a premiere online magazine, which boasts over 13,000 confirmed subscribers and members.

  • Owner of several free user support groups: Word VBA, Word Doc Design, Excel VBA, Outlook Advanced and Office 2007.

  • Part-time Microsoft Office Specialist course instructor through Computer Systems Institute (CSI), on-site in Chicagoland.

  • Former Instructor for Eclectic Academy, teaching three advanced Word courses.

 

Chicago, IL

 
Jun/00–
Dec/01

Morningstar, Inc.
Project Manager/Infrastructure Group (Position Dissolved)

  • Webmaster/designer of intranet technical documentation site; involving compilation of process details from groups, management and programmers; compose text to be used by, and equally understood by, developers, support staff and management; design site, build illustrations and publish in timely manner
  • Take on management of new projects related to the Infrastructure team, as necessary
  • Order/track all web infrastructure equipment
  • Built a more efficient equipment ordering system using Office VBA
  • Managed 80+ person departmental office move, utilizing Visio and Project, liaised with department managers regarding web reporting needs and coordinated solutions
  • Built custom VBA/ADO reporting solution to quickly obtain SQL-structured data from servers
  • Managed off-site cache provider project
  • Self-trained to become software licensing expert
  • Built software licensing tracking system

Chicago, IL
Mar/00–
Jun/00

Computer Adaptive Technologies (now Promissor)
Technical Project Manager (Contract Position)

  • Took over technical end of a failing project and successfully established 200 computerized testing centers (200 Linux servers, 800 NT workstations) across the US within 3 month time frame
  • Lead weekly conferences with Dell engineers to build automated ordering process
  • Negotiated and established automated purchasing/shipping process with video vendor
  • Quality checked NT workstation and Linux server images and approve necessary changes
  • Composed various technical Statements of Work for Unisys onsite technicians
  • Handled all inventory, purchasing and shipping for computers, servers, video equipment, cables and software images, involving six vendors
  • Simultaneously liaised with numerous eSuites and computer/video installers to verify successful installations, as well as troubleshoot installation problems
  • Compiled and verified site IPs and subnet masks for installs
  • Designed/developed an automated document management process to lessen time spent on paperwork
  • Created automated, daily status reports on all site's operational status


Evanston, IL
 
Oct/99–
Jan/00

Morningstar Associates, LLC
Web Quality Assurance/Beta Tester (Contract Position)

  • Beta tested new web investment offering
  • Maintained/used PVCS software for bug tracking
  • Drill down bugs and liaised with developers and designers for solutions
  • Developed Word VBA automated analysis forms for outside beta testers, which resulted in better tester feedback

 

Chicago, IL
 
Feb/88–
Oct/99

Ibbotson Associates (Various Positions)

1997–1999
Technical Consultant (Escalation Engineer)

  • Handled escalated client software/technical support issues over the phone and in person
  • Acted as beta tester and liaison between client needs and programmers
  • Integrated, designed, edited, and maintain Intranet site
  • Developed custom software solutions as needed for colleagues and clients
  • Conducted technical training classes for support and sales staff as needed

1996–1997
Supervisor/Retail Support Services (Help Desk Supervisor)

  • Handled escalated client support calls
  • Designed, developed, implemented Outlook newsgroup system for software bug tracking
  • Managed support group of five
  • Coordinated and produced technical documentation and online help manuals

1994–1996
Designer/OLE Automation Specialist (WB/VB Programmer)

  • Developed financial software automated reporting processes using WordBasic and VisualBasic
  • Designed, developed custom databases for client seminar registration using VisualBasic, Access
  • Developed custom solutions as needed for colleagues and clients
  • Conducted technical training classes for support staff as needed

1990–1994
Technical Graphic Designer

  • Designed, produced, maintained numerous, large financial textbooks
  • Designed, produced, maintained numerous software manuals and online help files
  • Designed, produced, maintained numerous training and sales presentations and brochures
  • Editor, writer, designer of monthly office newsletter
1988–1990
Executive Secretary/Marketing Assistant
  • Administrative Assistant to Vice President/Marketing
  • Provided additional secretarial support to president and various executives, as needed

 

Chicago, IL
 

Education
       

Microsoft Corporation/Redmond, Chicago & Internet
Various continuing training sessions in technical/systems support and software/Internet/intranet development from 1995 to the present.

Micron University/Internet
Various self-study, online courses. Received 27 different software course certificates during 2001 for applications, development and systems.

Edward Tufte Design Courses/Chicago
Visual Explanations, The Visual Display of Quantitative Information, Presenting Data and Information.

Robert Morris Business College/Chicago
Administrative Assistant degree

 


Publications
         

Technical Editor for Wiley Publishing's Word 2007 Bible and Office 2007 Bible.

Editor-in-Chief and technical writer for TechTrax Ezine, with over 13,000 subscribers
http://www.mousetrax.com/techtrax/

Contributing Author of numerous technical tutorials for Computor Companion Magazine http://www.computorcompanion.com

Contributing Author of numerous technical tutorials for All 'Bout Computers Ezine
http://www.personal-computer-tutor.com/abc/

Author of numerous technical tutorials for MouseTrax TechPage
http://www.mousetrax.com/techpage.html

Author of several Advanced Word training eBooks
http://www.mousetrax.com/techcourses.html

Technical Contributing Author for InPark Magazine
http://www.inparkmagazine.com

 

 

References
           

Bill Gates

David Montgomery,
Former Boss

Carl Gargula, Former Boss

Microsoft MVP Supervisor

Professional Colleague

Colleague/Student

 

 

MVP Award 1996

MVP Award 1997

MVP Award 1998–99

MVP Award 2002

   

Back to Dian's bio