Arthur W. Little
Senior Software Engineer / VBA Developer
(925) 786-3515
http://www.linkedin.com/pub/arthur-little/5/8b8/870
January 14,
2010
Summary
I am seeking a software
developer/analyst position in the San Francisco Bay area. My software
development skills, mathematical, financial, and accounting background,
business acumen and motivation have allowed me to work successfully with all
levels of personnel. I have always been
creative and successful in new environments by leveraging new or existing
technologies with a strong work ethic. I am very motivated and anxious to put
my experience to work meeting new challenges.
While I have an
extensive background in database design and reporting, I have spent most of the
past seven years designing, developing, maintaining, and documenting
first-class, very user-friendly, and extremely successful MS Excel/VBA
applications. I have recently utilized my VBA and database skills by designing
and developing a complex MS Access financial projection application.
Skills
Languages: VBA, Visual Basic 5/6, HTML, JavaScript, PL/SQL, SQL*Plus, TOAD, SQL
Navigator, SQL*Loader, SQLTalk, Perl, MS
C++, SQLWindows, Informix-NewEra, SQR, Borland C/C++, APL, JCL and COBOL.
Development Tools: MS Excel, Access, Project, Word, Visio, PowerPoint,
UML, BusinessObjects, Crystal Reports, MS Visual Studio/Visual Studio.net,
Visual SourceSafe, System Architect, ERWin, Logic Gem, CASE:W, ProtoGen and
Label Matrix.
DBMSs: Oracle, Gupta SQLBase, Sybase SQL Server, Access,
Rbase and Paradox.
Business Applications: Order processing, Financial and Business reporting,
Customer Relationship Management, E-Commerce, Physical goods fulfillment
processing, Lease accounting and depreciation, Corporate tax planning and
analysis, Auditing, Statistical analysis, Multiple family mortgage analysis,
Collateralized Mortgage Obligation analysis, Computer simulation.
§ Seven years of current
experience utilizing VBA within MS Excel, Access, Word, Project, and Visio.
§ Recent experience using
PL/SQL, SQL*Plus, TOAD, and SQL Navigator.
§ Designing and developing
client/server or multi-tiered applications from 1988 to 2001.
§ Five years of experience
developing applications specifically in Visual Basic 5/6.
§ Participating in or leading
joint application development (JAD) sessions using UML diagrams when
appropriate.
§ Managing software projects
using MS Project.
§ Debugging or validating
database issues using SQL*Plus, WINTALK, or SQLTalk.
§ Providing management and
ad-hoc reports using packages such as Crystal Reports and PowerPoint.
§ Using modeling tools such as
ERwin and System Architect.
§ Building complete
applications in C, C++, COBOL, SQLWindows, and APL.
§ Working in Unix and Windows 95/98/2000/NT/XP/Vista environments.
I am well versed in the core
functions of SQL and normalization. I have very strong analytical skills and a
deep understanding of SQL and the relational model. My RDBMS experience
can be summarized as follows:
|
Location |
RDBMS |
Programming
Language |
Interface Program |
2004 - 2004 |
Charles Schwab |
Oracle |
PL/SQL |
TOAD, SQL Navigator,
SQL*Plus |
1999 - 2001 |
ReleaseNow.com |
Oracle |
VB6 |
SQL*Plus and WinSQL |
1996 - 1998 |
3Com |
(Gupta) SQLBase |
SQLWindows |
WinTalk |
1995 - 1995 |
Charles Schwab |
Oracle |
SQLWindows |
SQL*Plus and SQL*Loader |
1993 - 1994 |
Robertson Stephens |
(Sybase) SQL Server |
C++ |
ISQL |
1988 - 1992 |
Price Waterhouse |
(Gupta) SQLBase |
SQLWindows |
SQLTalk |
Education
BS
degree, Management Information Science and BA, Applied Mathematics, California
State University Sacramento
(double major, cum laude)
Work Experience:
August 2009 – December 2009
THINKNICITY –
VBA Developer – Designing
and implementing MS Office applications with extensive use of VBA (subset of
VB6) code.
·
Developed a 40 table MS Access Five-Year Product Strategy plan at Foster’s Group in St. Helena, CA.
·
VBA code creates and maintains multiple scenarios for volumes and
blends by product line for wineries in the group.
·
In August, assisted Triton Container/Perot
Systems in San Francisco by correcting VBA code upgraded to Excel 2007.
September 2005 – June
2009
R&W Capital -
Software Developer/Analyst
– Providing software analysis and development.
·
Full-time contract with UBS Investment Bank,
Exchange Traded Derivatives department in
·
Primary designer and developer of user-friendly Excel/VBA applications
that process data files and reports to and from UBS clients, including Barclays
Global Investors, Goldman Sachs Assets Management, Deutsche Asset Management,
Mellon Capital Management, State Street Global Advisors, Bridgewater
Associates, TwinFields Capital Management, Clarke Capital Management, Suncorp
Group, and Caxton Associates.
There are 10 extremely successful Excel/VBA
applications at UBS that I designed in collaboration with business
stakeholders, developed, documented, and maintained. My creative interfaces to
internal data have promoted straight through processing. Documentation includes
Word documents, HTML, compiled HTML, and PowerPoint presentations. All
applications, their prior versions, summary notes, and user documentation are
available to authorized users via a menu system that I developed. Applications
make extensive use of VBA code. Primary users are located in Chicago, Stamford,
London, and Sydney. Super-users can maintain client-related tables and have
access to additional documentation.
September 2003 –
September 2005
TEXSOURCE -
Software Developer/Analyst
– Providing software analysis and development.
·
Contracted with UBS Investment Bank in
·
Additional work includes designing, developing, and maintaining a new
Excel/VBA application to process files received from Bloomberg. The application summarizes trades, consolidates by
client, and prepares an e-mail for each client.
·
Full or part-time work based on requirements.
May 2004 – December
2004
GLOTEL –
Contractor/Software Analyst
– Preparing financial reports and providing software automation.
·
Full-time contract with Charles Schwab.
·
Assembled Excel based reports, such as the Monthly Business Report and
the Transfer Of Accounts Dashboard, from Oracle database
sources using TOAD, SQL Navigator, reports, and personal contacts.
·
Increased the timeliness and accuracy of reports through VBA
automation.
·
Located many of the data sources and provided PL/SQL scripts for two
new executive dashboards.
April 2004 – May 2004
THINKNICITY –
Visio Macros Developer –
Designing and implementing enhancements to existing MS Visio screens.
·
Full-time, short term contract with Simpson
Manufacturing in
·
Created and modified Visio VBA code, templates, masters, and stencil.
December 2002 – May
2003
HARRIS AND ASSOCIATES -
Programmer/Analyst –
Designing new software applications and extending existing capabilities of
project staffing applications for the Bay Area District Headquarters of the California
Department of Transportation (Caltrans).
·
Modified and developed new Excel VBA applications, including interfaces
with MS Project.
·
Developed new MS Project applications, including VBA interfaces with
Excel.
April 2002 - June 2002
RELEVANT BUSINESS SYSTEMS -
Programmer/Analyst –
Developing functional specifications, technical specifications, and software
applications for an Enterprise Resource Planning system.
·
Developed mostly technical specification for nineteen software programs
to be included in Relevant’s INFIMACS II® ERP products.
·
Programmed five new INFIMACS programs using Informix-NewEra 4GL.
April 1995 - June
2001
RELEASENOW.COM -
Consulting Manager/Senior Software Engineer – Analyzing,
designing, and programming primarily Visual Basic software solutions to support
on-line sales of ReleaseNow partners.
·
Analyzed, designed, programmed and maintained integrated VB/CGI
applications for box delivery of products from outside fulfillment houses such
as GlobalWare. These include Orders, Shipping Confirmations,
Backorders, Inventory, and automated customer and internal emails.
·
Designed and programmed tools to create and view multi-paged Excel
reports and CSV files from VB applications using Excel's COM object model and
the (VB6) File System Object. Utilized these tools to created accounting and
tracking reports from an Oracle 8 database.
·
Assisted in the conversion of selected reports to BusinessObjects.
CLIENT
SERVER DESIGNS (Acquired by ReleaseNow.com April 1999) -
Independent Consulting in
the
Consulting Manager
- Building turn-key, SQLWindow and Visual Basic
applications. Assisting
other development teams in migrating to client/server architecture. Assisting clients with
business requirements and database designs using Unified Modeling Language
diagrams. Clients include:
·
Responsible for maintenance and enhancement of SQLWindows applications
for Repairs and Contracted Software Fulfillments. Designed, programmed, and implemented barcode
integration and Y2K compliance for each of these applications.
·
Project lead for a portion of the conversion from ASK/MANMAN to
SAP. Conducted JAD sessions with
developers and business analysts to meet business requirements and develop
project plans.
·
Assisted in the conversion of SQLWindows applications to ClearLogistics
(Clarify, Inc.).
·
Created new SQR reports and translated existing non-PostScript Windows
reports to Unix/PostScript.
Firstwave
Technologies (formerly Brock International)
·
Participated in JAD sessions to define requirements for new software
versions using OMT sequence and state transition diagrams (essentially UML
diagrams) in System Architect.
·
Extended the capabilities of a CRM application using SQLWindows code.
·
Wrote "Legacy Data Download Specifications" for the Custom
Broker Project, including Oracle database modification scripts and SQL*Loader
scripts.
SELF EMPLOYED -
Independent Software Engineer/Analyst
·
Designed, programmed, and implemented a SQLWindows Tax Calendar
application for the
·
Completed two phases of modifications to SalesTrak, a commercial sales
tracking system by Aurum Software. My work included the addition of fax and
e-mail capabilities. Aurum was acquired by Baan, SSA GT, and Infor Global Solutions.
July 1992 - December
1994
TERRACE SYSTEMS CORPORATION -
Senior Developer/Consulting Manager -
Analyzing and developing C++ and SQLWindows client/server applications.
·
Assisted in the design, development and implementation of an on-line
customer tracking system for BancBoston Robertson
Stephens. Operational reporting from
the SQL Server database included customers, investments, companies, proposed
mergers, employees, and relationships. Utilized ProtoGen to generate portions
of the C++ code and manually developed the remaining code.
·
Designed and implemented various management reports using Crystal
Reports.
·
Active participant in the development of Terrace’s Threshold class
library for SQLWindows.
April 1988 - June 1992
PRICE WATERHOUSE TECHNOLOGY CENTRE -
(Currently
PricewaterhouseCoopers Global Technology Centre -
Software Engineer/Manager in Tax Technology Group 1991 – 1992
Software
Engineer/Manager in System
Support Group 1988 - 1991
·
Analyzed artificial intelligence and other new technologies.
·
Designed and programmed a hypertext COBRA questionnaire in the C
language.
·
Team member programming and developing an International Assignee Tax
Service planning and tracking system using SQLWindows client/server technology.
·
Developed and maintained the database and applications used by the