Code For Excel And Outlook
Greater New York City Area
- Current
-
- Owner at Code For Excel And Outlook
- Past
-
- Service Support Coordinator at Sterling Testing Systems (currently Sterling Infosystems)
- Service Support Coordinator at Sterling Testing Systems, Inc
- Service Support Coordinator at Sterling Info Systems
- Service Support Coordinator at Sterling Infosystems
- Education
-
- Jamestown Community College
- City University of New York-Hunter College
- Recommended
-
2 people have recommended Jimmy - Connections
-
30
connections
- Industry
- Computer Software
- Websites
Jimmy Pena’s Summary
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
Jimmy Pena’s Specialties:
Excel VBA, metrics, data aggregation and analysis, application development, add-ins, automated reporting
Jimmy Pena’s Experience
-
Owner
Code For Excel And Outlook
(Computer Software industry)
November 2007 — Present (1 year 9 months)
MS Office application development, VBA code samples
-
Service Support Coordinator
Sterling Testing Systems (currently Sterling Infosystems)
(Computer Software industry)
2001 — 2008 (7 years)
-
Service Support Coordinator
Sterling Testing Systems, Inc
(Computer Software industry)
2001 — 2008 (7 years)
-
Service Support Coordinator
Sterling Info Systems
(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
-
Service Support Coordinator
Sterling Infosystems
(Computer Software industry)
2001 — 2008 (7 years)
Jimmy Pena’s Education
-
Jamestown Community College
A.S. , Computer Science , 2008 — 2010 (expected)
-
City University of New York-Hunter College
B.A. , Philosophy , 1994 — 2002
Additional Information
Jimmy Pena’s Websites:
Jimmy Pena’s Interests:
(VBA) programming, end user training, application development, reading books on VBA/Java/HTML
Jimmy Pena’s Groups:
PMI member, 2007-2008
-
Microsoft Excel Users -
Excel Developers -
Excel and VBA Users -
Sterling Infosystems (formerly Sterling Testing Systems) Alumni Association
Jimmy Pena’s Honors:
Brainbench Excel 2003 Master Level, awarded 2005
Jimmy Pena’s Contact Settings
Interested In:
- career opportunities
- consulting offers
- new ventures
- job inquiries
- expertise requests
- business deals
- reference requests
