Arthur W. Little
Senior Software Engineer / VBA Developer
Danville, CA 94526
(925) 786-3515
Email: ArthurWLittle@yahoo.com
Website: http://arthurwlittle.tripod.com
LinkedIn Profile: http://www.linkedin.com/in/arthurwlittle May 29, 2014
Summary
When my current contract
ends, I will seek opportunities in the San Francisco Bay Area or the Phoenix
area. My software development skills, mathematical, financial, and accounting
background, business acumen and motivation allow me to work effectively with
all levels of personnel. I am very motivated and anxious to put my experience
to work meeting new challenges.
Although I have an
extensive background in database design and reporting, I have invested most of
the past ten years analyzing, designing, developing, maintaining, and
documenting first-class, very user-friendly, and extremely successful MS Excel/VBA
applications. In 2010, I expanded my VBA and database skills by designing and
developing a complex financial projection application in MS Access.
Skills
Languages: VBA, VB.NET, Visual Basic 5/6, T-SQL, PL/SQL, SQL*Plus, TOAD, SQL
Navigator, SQL*Loader, SQLTalk,
SQLWindows, APL, JavaScript, Informix-NewEra, SQR, HTML/CSS, C/C++, Perl.
Development Tools: MS Excel, Visual Studio, Scope, SSIS, SSAS, Access,
Project, Word, Visio, PowerPoint, UML, BusinessObjects, Crystal Reports, Visual
SourceSafe, System Architect, ERWin, CASE:W, ProtoGen.
DBMSs: MS SQL Server, Oracle, Gupta SQLBase, Sybase SQL
Server, MS Access, Rbase and Paradox.
Business Applications: Advertising, Pricing, Order processing, Financial
and Business reporting, Customer Relationship Management, E-Commerce, Physical
goods fulfillment processing, Lease accounting and depreciation, Corporate tax
planning, Auditing, Statistical analysis, Multiple family mortgage analysis,
Collateralized Mortgage Obligation analysis.
§ Twelve years of current
experience utilizing VBA within MS Excel, Access, Word, Project, and Visio.
§ Current experience using MS
SQL Server Management Studio, Visual Studio, SQL Server Integration Services,
and SSAS.
§ 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/7 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 |
2012 - 2014 |
Microsoft Corporation |
MS SQL Server |
Transact-SQL |
Visual Studio, Scope, SQL
Server Management Studio, SSIS, SSAS |
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:
May 2010 – present
Microsoft Corporation (via PT Systems) – San Francisco, CA
Software Developer/Analyst
– Full-time contracting to provide SQL processing and VBA software development.
·
Lead developer for
a MS Excel/VBA pricing application that generates rate cards for web-based
advertising in 25 markets. I have consistently enhanced the project and
delivered monthly pricing reports, including sophisticated graphs and bubble
charts with trend lines.
·
Assumed additional
responsibilities in September, 2012, to extract, transform, and load MS SQL
Server data using SQL Server Integration Services (SSIS) and (SSAS) for a
project that provides bid guidance for advertising auctions.
August 2009 – December 2009
THINKNICITY – San Francisco,
CA
VBA Developer – Designing
and implementing MS Office applications with extensive use of VBA 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.
·
All short-term
contract work was completed in December 2009.
September 2005 – June
2009
R&W Capital - Chicago, IL
Software Developer/Analyst
– Providing software analysis and development.
·
Full-time contract
with UBS Investment Bank, Exchange Traded
Derivatives department in Chicago.
·
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 (now
BlackRock), 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.
I
designed 10 extremely successful Excel/VBA applications at UBS 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
UBS Investment Bank (via TEXSOURCE) – Chicago, IL (Telecommuting from Danville, CA).
Software Developer/Analyst
– Providing software analysis and development.
·
Enhance VBA Excel
applications for managed trading accounts. The initial project extended the use
of Monte Carlo techniques, and follow-up projects for the Chicago and Sydney
offices have expanded data transfers and reports to include additional clients.
·
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
Charles Schwab (via GLOTEL) – San
Francisco, CA
Contractor/Software Analyst
– Preparing financial reports and providing software automation.
·
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
Simpson Manufacturing (via THINKNICITY) – Dublin, CA
Visio Macros Developer –
Designing and implementing enhancements to existing MS Visio screens.
·
Created and modified Visio VBA code, templates, masters, and stencil.
December 2002 – May
2003
Harris and Associates - Concord,
CA.
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 - San
Ramon, CA.
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 - San Carlos,
CA. (ReleaseNow.com
is no longer in operation.)
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) - Alameda, CA.
Independent Consulting in the San Francisco
Bay Area.
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 - Danville, CA.
Independent Software Engineer/Analyst
·
Designed, programmed, and implemented a SQLWindows Tax Calendar
application for the San Francisco office of PricewaterhouseCoopers. Concurrently, translated the client’s APL
database into a Gupta SQL database.
·
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 - San Francisco, CA.
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 - Menlo
Park, CA.
(Currently
PricewaterhouseCoopers Global Technology Centre - San Jose, CA)
Software Engineer/Manager in System Support Group 1988 - 1991
Software
Engineer/Manager in Tax Technology
Group 1991 – 1992
·
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 San
Jose office to collect, calculate, and report semiconductor industry
statistics. Reports from this
application to trade associations, including the World Semiconductor Trade Statistics
organization (WSTS), provided the data for the industry’s closely watched and highly
publicized book-to-bill ratio.