Benjamin Jeffery Holtzman
San Diego, CA 92122
Phone: 858-***-****
**********@*****.***
Objective:
To grow, thrive and love what I do as a Microsoft technology centric applications programmer.
Career Summary:
I’m a Microsoft technology oriented programmer. I’ve done a lot of work on the .Net platform, Visual Basic, C# and MS Office Platform Development and VBA. I’m a good problem solver and have a 100% success rate of solving each challenge I’ve been given. I work well in groups and have always made my deadlines.
Professional Experience:
SAIC San Diego, CA
Software Engineer II (Employee) 04/09 – Present
Part of a 2 person development team which developed a working proof of concept demo (JNMS Lite) as a product replacement for an extremely large legacy application in use by US military joint forces.
o Broke down development into 2 phases.
Resource gathering phase which included harvesting databases from a diverse set of sources. Resource generation which included creating bitmaps stencil set artwork from concept diagrams.
Software development phase which included creating MS Office application add-ins in C# to duplicate targeted functionality.
o Delivered functional and on time demo with less than 320 development man hours of labor (2 people, 29 days)
Fixed difficult upgrade issue for JNMS reporting. Fix allowed the reporting subsystem to migrate to MS Office 2007.
Documented application and work done.
(Environments) LAN, WAN, Remote Desktop using VNC Viewer, Tortius SVN, Dimensions SVN, Visual C#, VBA, Visio, Word, Excel, Access , MSI and Click Once.
SAIC San Diego, CA
Software Engineer (Employee) 11/08 – 04/09
Part of a 3 person development team.
Delivered multiple versions of a corrosion calculator to a major oil company.
o Wrote interface, Automation and GUI code to connect Excel with COM exposed calculator libraries.
o Application allowed client to plan and execute refinery campaigns with confidence of a successful outcome by:
Showing safe and unsafe crude mixtures.
Indicating a safe amount of time to run a campaign.
Indicating when and how long different temperatures should be used in different parts of the refinery.
Indicating if fouling conditions are going to occur or if they are likely to occur. (Fouling is bad, it’s very costly and time consuming to fix)
Visually mapping out temporal crude qualities.
Troubleshot MSI package issues of application components being deleted and installed at the wrong times.
Wrote XML reader / writer.
Documented application.
(Environments) LAN, WAN, Visual C#, VBA, Excel, Word, Access, XML and MSI.
Northrop Grumman San Diego, CA
Computer Programmer (Freelance) 04/08 – 11/08
Worked in group of 5 developers plus other project team members.
Created solutions for widely distributed application.
o In charge of database application programming.
o Resource generation for subset of required resources.
o Update scripts for database data manipulation over wide area networks.
o In house tool development.
Coded form presentation and behavior.
Innovated solutions for tool set limitations. FormDocs had a very limited scripting language that made certain project requirement unachievable when approached directly.
(Environments) LAN/WAN / Remote Desktop, Access/VBA Excel/VBA, FormDocs FAB, Visual Basic 2005, Visual Basic 2008, XSLT, SQL and SQL Server 2000.
Oviatt Consulting Services San Diego, CA
Computer Programmer (Freelance) 02/08 – 10/08
Developed, modified and debugged database applications for San Diego County and Arizona State homeless shelters.
Innovated solutions to work with tool set limitations while developing complex applications inside of MS Access.
o Created search applications to extend development environment organizational ability to show relevant resources inside form controls, tables, modules and class modules.
o Development version of largest database application was ~200mb with over 100 tables ~80 forms and ~50 modules/class modules.
o Developed barcode interface to allow quicker and more accurate data entry.
Addressed reporting issues to present shelter resources/services to case workers and management.
(Environments) LAN/WAN / Remote Desktop, Access/VBA Word/VBA and Visio.
Coaliance San Marcos, CA
Computer Programmer 06/07 – 11/07
Coded enterprise database and reporting applications for international restaurant group.
o Worked with cubes, metrics, data transformation, analysis and reporting tools in BIDS.
o Worked with SQL Server 2005 SP’s and running jobs.
o Developed email alerts for problem conditions.
Debugged legacy Access database application which allowed for direct PO generation.
Developed database documentation application which generates a word document detailing the SQL Server database system.
(Environments) LAN/WAN / Remote Desktop, Access/VBA Excel/VBA Word/VBA SQL Server 2005, T-SQL, SP, Visual Basic 2005 and C# 2005.
Sach’s Scientific San Diego, CA
Computer Programmer (Freelance) 03/07 – 10/07
Wrote an accounts reporting system which took reports from other systems and inserted them into an Excel workbook.
o Produces over 100 worksheets of complex 3 dimensional data.
o Saves over 60 man hours of labor each month. The reports it generates were previously put together by hand.
o Reduces errors to nothing.
o Produces a report that took 1.5 weeks to produce by hand in about 5 minutes.
Installed and trained staff on using the application.
Debugged on target systems.
Delivered the product to spec and on time.
Developed a good relationship with the client and won client’s confidence.
(Environments) WAN / Email / Onsite for training and install Excel 2003 / VBA and Access 2003 / VBA.
Icon International San Diego, CA
Computer Programmer 02/05 – 06/06
Wrote and implemented 8 applications to automatically create 20,000 high end product and country specific econometric forecasts annually with Access, Word and VBA. (All published)
Wrote and implemented application to automate the writing of estimated 100,000 timeline books.
Wrote and implemented a mission critical applications monitor which allowed programmers to respond and fix most problems within minutes of detection with Access, Outlook, VBA and remote desktop.
o This was an in-process innovation to allow me to reach a tight deadline of running and readying 25,000 titles for distribution to distributors in 2 weeks time. (It impressed the boss.)
Harvested, cleaned, formatted and made ready extremely large databases (i.e., British Library of Congress, US and International Patents, Medical Journals, Project Gutenberg, etc...) for book creation using Access, Excel and VBA.
(Environments) LAN/WAN / Remote Desktop, Access 2000 / VBA, Excel 2000 / VBA, Word, 2000/ VBA and Visual Basic 2005. Worked in large computer lab with around 50 computers and 2 programmers.
Computer Proficiency:
VB 2005/2008, C# 2005/2008, SSIS, SSAS, SSRS, SSNS, SSMS, VB6, VBA, SQL (Jet 4.0), T-SQL (SQL Server 2005), ADO.NET, DAO, ADODB, ASP.NET, HTML, XML, XSLT, VSTO, Java Script, Java JDK 1.6 (Studied, but no experience with), RTF, FAB (FormDocs), WinForms, XAML and WPF, Client Side Web Browser Automation/Integration.
Have a lot of experience programming MS Office Apps (Access, Excel and Word)
Have a lot of experience working in Windows XP/Vista
Have some experience programming MS Office Apps (Outlook and Visio)
Have some experience working in Windows 95/2000/ME and DOS Batch Scripting.
Universities Attended:
Orange Coast College & Cal State University Long Beach
Awards:
• Awarded President's List for achieving 4.0 GPA at Orange Coast College
• Received Dean's List for top 10% GPA at Cal State University Long Beach
Major:
Math / Computer Science Major
Customers:
US Military Joint Forces, British Petroleum, Los Angeles Police Department, Catalina Restaurant Corporation (Zensho), Daphne’s, Ace Parking, San Diego County and Arizona State Homeless Shelters and United Through Reading.
Publications:
40,000 annually produced country / product category specific econometric studies from work done at Icon International Inc. in connection with INSEAD (Fontainebleau, France). Estimated 100,000 Webster’s timeline books.
Personal Attributes:
I can solve difficult programming problems. I have a 100% success rate in meeting project requirements. I’m reliable. I enjoy what I do. I’m not above doing grunt work.
References:
Available upon request.