## BIO
**<u>Microsoft Excel VBA Developer
</u>**
* Developing custom Microsoft Excel solutions since **1992**.
* Over 2 years contracting at **[login to view URL]** programming Excel VBA.
* 1-year contract at **Microsoft** programming custom tools in Excel VBA.
*"Greg’s Excel solutions have delivered a hugely positive impact on our process, data quality, and most importantly, our bottom line."* (Bob Arnold, **Microsoft** Senior Program Manager)
*"This definitely makes life easier!! Woohoo!!!"* (Elizabeth Brown, **Microsoft** Program Manager)
* Wrote and marketed 3 Microsoft Excel add-ins, "xlPrecision", "inspector text", and "The Formulator", which add powerful worksheet formula functions to Excel and make long, complex Excel formulas easier to read and edit.
* Over 3 years solving Microsoft Excel customers' problems, including Excel VBA (Visual Basic for Applications), as **Microsoft** Excel Product Support Professional. Promoted to escalation team, then to Washington State escalation lead. *That means I handled the most difficult Excel programming support cases, which even the other members of the escalation team were unable to resolve.*
* Developed spreadsheet applications for large restaurant's payroll and bookkeeping which provided more information, required less than 50% as much data entry, and reduced errors by over 50%.
* Designed and supported spreadsheet tools for restaurant managers.
* **Microsoft Certified Professional** in Excel and Excel VBA.
**<u>Visual Basic Programmer</u>**
* Wrote and marketed two software products as Visual Basic ActiveX DLLs.
* Over 2.5 years solving Visual Basic programmers' programming problems as **Microsoft** Visual Basic & Office Integration Support Professional.
* **Microsoft Certified Solution Developer**, VB4 & VB6.
**<u>Database Experience</u>
**
* Promoted to Washington State Microsoft Query Co-Lead, then to Washington State Query/DAO/ODBC Lead, in Microsoft Excel Product Support.
* Wrote the chapter on Data Access Objects (DAO) Security for the Microsoft Query training manual for Microsoft Excel 95 product support.
* Experience writing SQL statements and SQL Server stored procedures.
*"[Greg is] the ODBC expert [in Microsoft Excel Product Support]..."* (Tim Nevins, Microsoft Excel Product Support Team Manager)
**<u>Clear and Detailed Writer</u>
**
* Wrote help files, tutorials, and marketing copy for two software products.
* Wrote dozens of Microsoft Knowledge Base articles.
* Wrote copy for mail-order catalog.
*"...[Greg's] answers are VERY well-written..."* (John Macko, Microsoft customer)
**<u>Microsoft Certified</u>
**
* Achieved Microsoft Certified Solution Developer in 1997 and again in 2003.
* Microsoft Certified Professional since 1994.
**<u>Problem Solver</u>
**
* Over 9 years solving Microsoft customers' software problems as Microsoft product support professional.
*"[Greg] leads by seeing problems around [him] that need to be solved [and solving them]..."* (Steve Simunds, Microsoft Excel Product Support Team Manager)
*"Despite...a series of 'killer' questions, Mr. Lovern consistently provides valuable, insightful answers..."* (John Macko, Microsoft customer)
*"...his ability to troubleshoot and solve problems is outstanding."* (Ingrid Cox, Dining Room Manager, Duke's Restaurant)
*"...Greg was always the problem solver of the company."* (Jody Kuiper, Manager, Duke's Restaurant)
**<u>Customer-Focused</u>
**
* Excellent Microsoft Product Support customer surveys.
*"[Greg provided] the best support I have ever had from Microsoft."* (Microsoft customer survey response)
*"It is a delight that he often goes beyond the basic question, providing additional tips, tricks, and suggestions."* (John Macko, Microsoft customer)
*"His customer focus is strong...and he is very persistent in getting to the bottom of his customers' cases."* (Jim Cumming, Microsoft Developer Support Team Manager)
*"...excellent customer focus and impressive [customer] feedback..."* (Tom Kotowski, Microsoft Developer Support Team Manager)
*<u>**PROFESSIONAL CERTIFICATION**</u>*
<u>**Microsoft Certified Solution Developer (MCSD)**</u>
* 2003 (Visual Studio 6.0)
* 1997 (Visual Basic 4.0)
**<u>Microsoft Certified Professional (MCP)</u>**
* 1995 (Excel 5.0 VBA)
* 1994 (Excel 5.0)
**<u>View Greg Lovern's Microsoft Certified Professional Transcript here:</u>**
<u>**
**</u><a href= "https://mcp.microsoft.com/authenticate/validatemcp.aspx">https://mcp.microsoft.com/authenticate/validatemcp.aspx</a>
Transcript ID: 720428
Access Code: 4F9W5G7S (case sensitive)
*<u>**PROFESSIONAL EXPERIENCE**</u>*
**<u>March 2006 – Present: Software Development Contractor</u>**
Custom Excel VBA programming (and other software programming) for misc. clients.
Over 2 years contracting at [login to view URL], programming Excel VBA.
1-year contract at Microsoft programming custom tools in Excel VBA.
**<u>April 2003 - Present: Self-Employed Software Developer</u>**
Designed, programmed, wrote help files, tutorials, and marketing copy for, and marketed two Microsoft Excel add-ins.
**<u>August 1994 - April 2003: Microsoft</u>**
## Area of Expertise
* * *
**Microsoft Excel VBA
(also can work with any other VBA, including Outlook, Word, PowerPoint, Access, Project, & Visio)
**
* * *
**Visual Basic
**
* * *
**Active Data Objects (ADO)
(especially for database queries from Excel)
**
* * *
**Microsoft Certified Professional (MCP)
**
* * *
**Microsoft Certified Solution Developer (MCSD)
**
* * *