
Code For Excel And Outlook
Greater New York City Area

Code For Excel And Outlook
Greater New York City Area
I have been programming in Excel and Outlook for several years. I write macros for Excel and Outlook to integrate with other Office programs such as Word and Access. I am also fluent in PowerPoint. My personal website http://www.codeforexcelandoutlook.com/ has samples of my work. I am looking for a position which primarily focuses on Office integration and automation using VBA. Independent contracting and consulting is also available for automated projects, spreadsheet design and best practices, and tutoring.
Author of six free Excel add-ins, available from my website.
Microsoft Excel 2003 – 11 years
• Advanced Data Analysis (lookups, arrays, filters)
• VBA Programming, Application (add-in) Development & Maintenance
• Automated charting, reporting, database import/export
• Bullet-proof UIs for data collection & management
• End user training & tutorial writing
• Ad-hoc reports with PivotTables
Microsoft Word 2003 – 5 years
• Automated mail merge w/ Outlook, Excel
• Form design & password-protected fill-in forms
Microsoft Outlook 2003 – 7 years
• Automate complex email routing & response processor using VBA
• Hands-off file attachment processing (i.e. import daily XLS to MDB)
Microsoft Access 2003 – 2 years
• Build/edit tables & queries
• Import/export data to and from Excel
• Table normalization
Microsoft PowerPoint 2003 – 4 years
• Creating basic presentations
Working knowledge of: MS Project, HTML, PHP, CSS, Java, VB .NET
Excel VBA, metrics, data aggregation and analysis, application development, add-ins, automated reporting
(Computer Software industry)
November 2007 — Present (1 year 9 months)
MS Office application development, VBA code samples
(Computer Software industry)
2001 — 2008 (7 years)
(Computer Software industry)
2001 — 2008 (7 years)
(Security and Investigations industry)
July 2001 — November 2008 (7 years 5 months)
Email support, troubleshooting technical issues, problem analysis, write SOP and improve existing processes, end user training, Excel add-in and macro development, manage Access database import from Excel
(Computer Software industry)
2001 — 2008 (7 years)
A.S. , Computer Science , 2008 — 2010 (expected)
B.A. , Philosophy , 1994 — 2002
(VBA) programming, end user training, application development, reading books on VBA/Java/HTML
PMI member, 2007-2008
Brainbench Excel 2003 Master Level, awarded 2005