Arthur W. Little

Senior Software Engineer / VBA Developer

400 Jeannie Court

Danville, CA 94526

(925) 786-3515

ArthurWLittle@yahoo.com

http://www.linkedin.com/pub/arthur-little/5/8b8/870

November 15, 2009

 

Summary

I am seeking a software analyst/developer position in the San Francisco Bay area.

 

My 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.

 

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 and COBOL.

Development Tools: Excel, MS 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 with extensive use of VB6 code in MS Excel, 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 – present 

THINKNICITY – San Francisco, CA

VBA Developer – Designing and implementing MS Office applications with extensive use of VBA (subset of VB6) code.

·         Current contract at Foster’s Group in St. Helena, CA, to develop a 40 table MS Access Five-Year Product Strategy plan.

·         VBA code creates and maintains multiple scenarios for volumes and blends by product line for all 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 - 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, 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 - Stamford, CT (Telecommuting from Danville, CA).

Software Developer/Analyst – Providing software analysis and development.

·         Contracted with UBS Investment Bank in Chicago to 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 

GLOTEL – San Francisco, CA

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 – San Francisco, CA

Visio Macros Developer – Designing and implementing enhancements to existing MS Visio screens.

·         Full-time, short term contract with Simpson Manufacturing in Dublin, CA.

·         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:

3Com Corporation

·         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.

Charles Schwab

·         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.

 

December 1994 - April 1995

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 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 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.