Click here for a Microsoft Word version
Benjamin M Hudgins
A self-motivated, highly organized and goal oriented achiever with over 18 years of experience as an Information Systems/Applications Development professional. Employed as a Database Administrator, Web Designer/Developer, Access/Excel VBA Developer, Programmer/Analyst, Project Manager, Network Administrator, and Technical Support Technician. Microsoft Certified Professional in Excel Visual Basic for Applications. Excellent writer and communicator. Working in the field for 18 years has given me extensive experience with users and strong interpersonal skills.
Database Administrator/Web Designer
New York, NY; October 2006 – present
Following my successful automation of the Global Technology Infrastructure group’s desktop-based reporting process (April – September, 2006; see below), I was kept on to oversee the transition of this reporting model to a web-based approach. Using SQL Server 2005, I designed and implemented a data mart that takes daily feeds from several upstream databases through the use of SQL Server Integration Services (SSIS). The resulting data then feeds a large suite of canned reports that I created for a Microsoft Reporting Services (MSRS) web front end. In addition to this Report Manager, I also designed several data models for use with an MSRS adhoc Report Builder. Besides working with these SQL Server 2005 tools, I also wrote several smaller, offshoot ASP pages that handled requests for user accounts, data entry specific to the data mart, and a job role reclassification project.
Access/Excel VBA Developer
New York, NY; April 2006 – September 2006
I was contracted by the Global Technology Infrastructure group to automate their daily Project and Program reporting process. The original process was manually intensive and used a non-rationalized Access database with several front end macros. The results of these macros would be copied and pasted into Excel, wherein they would then be manually modified and formatted. I redesigned and rationalized the database, then automated the entire end-to-end reporting process using Access VBA, reducing the runtime from 5 hours to 20 minutes. All exporting, modification, and formatting of the final Excel end products were included in this automation through the use of OLE.
Access/Excel VBA Developer JPMorganChase New York, NY; August 2005 – March 2006
I was brought in by the Interface Planning Group to normalize their Access database design and automate their biweekly reporting system. Using Access VBA, Excel VBA and OLE, I created an easy to use system that allowed the team to import data from raw Excel spreadsheets into Access, wherein several ETL processes were performed. The team could then run reports directly from the Access front end. The queries for these reports were performed in Access and then the results were then formatted and exported to Excel using OLE.
ASP/JavaScript Developer JPMorganChase New York, NY; February 2004 – July 2005
Several of the applications I developed for JPMorganChase were chosen to be transitioned from desktop-based to web-based. I was brought in as both a subject matter expert and a developer. After initial requirements gathering, I used my knowledge from the initial development efforts to streamline the transition and develop new web-based front-ends (using ASP and JavaScript), as well as data retrieval procedures for these new web pages.
ASP/JavaScript Developer
Freelance Charity Work for RestaurantsAgainstHunger
New York, NY; October 2004
Restaurants Against Hunger is a charity associated with the France-based Action Against Hunger network. The website was designed to track reservations, list participating restaurants, and except applications from volunteers. I designed and implemented the code for the website using ASP, JavaScript, and JMail. The website itself tracked several hundred restaurants in 6 major cities. While I was not compensated for this work, it was quite satisfying.
Access/Excel VBA Developer
New York, NY; November 2002 – February 2004
As a member of JP Morgan Chase’s TIGER Team (Tool for Integration of Global Expense Reporting), I was called upon to develop multiple applications in both Access and Excel. In many instances, it was necessary to create applications that utilized both platforms using OLE. This included several global applications, such as GLRS (General Ledger Reconciliation and Substantiation), Reloc (used to track relocation expenses and saves), Ptrack (used to track Project based expenses and saves) and many application used to handle BAU operations. In many cases, I was the project manager for the entire lifecycle of the application, from the initial requirements gathering stage, through development and testing, to final implementation.
Access/Excel VBA Developer
New York, NY; February 2002 – November 2002
My chief responsibility as a member of the Vendor Management Office was the automation of their monthly reporting process, as well as the design, development, and implementation of a consultant-tracking system written in Access using VBA. This system allowed the team to report on the entire life cycle of a consultant, from their first interview through their appointment to a position at JP Morgan Chase. The system tracked about 3000 consultants, including their hourly rates, contract dates, and market rate comparisons as well as complete historical data.
Access VBA/Web Developer
Morgan Stanley Dean Witter
New York, NY; April 2000-December 2001
I was brought in by MSDW to redevelop an application that consisted of an Access VBA front end linked to a Sybase back end via ODBC. Made several improvements to this tool, including specialized reports and an engine to generate ad hoc reports from Sybase using ODBC. Created a utility to automatically create DSN and ODBC connections as well as several on demand Access VBA applications. I also created many dynamic web pages using CGI/Perl and JavaScript. Several of these pages were linked to a Sybase backend, allowing users to enter data through a web front end.
Access/Excel VBA Developer
New York, NY; May 1996-March 2000
While working at JP Morgan designed and developed hundreds of reports for Morgan’s compensation team, replacing time consuming manual work with fast, automated processes. Several of the add-ins and utilities I designed and developed are now used throughout the firm, both here in the United States and overseas. These utilities include HTML-based help documentation that can be launched directly from Excel. Created several models that use ODBC to interact with Access databases as well as SQL scripting utilities. Was recognized as "the go to man" for Excel and Access projects and questions, be they simple functionality questions or extensive project designs and implementations, not only by my immediate team, but by other departments within Morgan. Was given sole responsibility for the design, development, testing, and distribution of several global applications, including the Data Collection Tool. This application became an integral part of Morgan’s compensation, handling over $3 billion in transactions. Took several trips overseas to demonstrate and give instruction on this and other application to employees in JP Morgan’s London office. My initial 3-month assignment JP Morgan was continually extended due to my skills and expertise. Skill set has also expanded while at the firm, as Business Objects became their primary data retrieval and reporting tool. Designed numerous applications using Business Objects queries. The results of these queries were used by my Excel applications to provide coherent reporting for my users.
Excel VBA Developer
Computer Aid/DuPont
Wilmington, DE; December 1995-May 1996
As the sole member of the Special Projects group, designed and developed spreadsheet and database handling applications for my clients in several different programming languages, including Excel VBA and Lotus 123 for DOS, as well as other mainstream software packages, such as Access. Most important project at DuPont was an Excel spreadsheet system that tracked over $100 million in data during their compensation season. Was primary source of Excel knowledge for the compensation group.
Desktop Support Tech
Computer Aid/DuPont
Wilmington, DE; May 1995-December 1995
While employed by CAI as a Desktop/Second Level Helpdesk Technician, performed installations and handled the configuration of various software packages, including MS Office, Reflection communications products, Norton Anti-Virus, and many others. Trouble shot problems with those packages, in addition to setting up and configuring users with Ethernet or Token Ring TCP/IP addresses before connecting their new machines to networks using Novell 3.x software.
Excel VBA Developer/Network Administrator
Philadelphia, PA; May 1989-May 1995
During my employ at WXPN as an applications developer, designed many spreadsheet and database applications for the station’s business, music and membership departments using dBase III and Excel. Was also Network Administrator for WXPN’s 10-station local area network and instructed staff in the use of the network applications and other software. Supervised work-study staff and performed computer support as needed, including software installation, instruction, and trouble shooting. During my 6 year tenure, the station saw an $800,000 increase in annual revenue as a direct result of my efforts, finally topping $1 million in membership revenue for the first time in the station’s history.
- BA - English, University of Pennsylvania, Philadelphia, PA, 1992
- Knowledge of SQL Server 2005, Microsoft Reporting Services, SQL Server Integration Services, Microsoft Report Manager, Microsoft Report Builder, ASP, JavaScript, HTML, Visual Basic, Access VBA, Excel VBA, Powerpoint VBA, Oracle, Sybase, Business Objects
- Microsoft Certified Professional in Excel Visual Basic for Applications