Arthur W. Little Senior Software Engineer / Analyst 400 Jeannie Court Danville, CA 94526 (925) 837-4730 ArthurWLittle@yahoo.com Website: http://arthurwlittle.tripod.com OBJECTIVES: Software engineering, management, or consulting position in the San Francisco Bay Area, the Chicago Area, or elsewhere. SUMMARY: I have very strong skills in application analysis, design, implementation and testing, database architecture, and SQL. These skills, along with my personal motivation and experience, would lead to success in a challenging work environment. I have many years of professional experience working with all levels of personnel. I work well either with others or alone to develop and maintain software throughout its life cycle. I have experience in client/server architecture since 1988. I utilize the Unified Modeling Language (UML) for object-oriented analysis and design. In recent years, I have developed software mostly in VB 6.0 and Oracle, but I have always been creative, innovative, and able to adapt to new environments and technologies. I have recently utilized my VBA and database skills by designing and developing a complex MS Access financial projection application. EDUCATION: BS degree, Management Information Science and BA, Applied Mathematics, California State University Sacramento (double major, cum laude) BUSINESS APPLICATIONS: 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, Artificial Intelligence. DBMSs: Oracle, SQLBase, Access, Rbase and Paradox. 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. Professional References Available Upon Request. PROFESSIONAL EXPERIENCE: August 2009 – December 2009 THINKNICITY – San Francisco, CA 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 - 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. 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. * Currently part-time work based on additional requirements. * 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 allowed data file transfers for this application from 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 templates, masters, and stencil. * Modified Visio objects through VBA code or by modifying attributes. 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 Caltrans. * Modified and developed new Excel VBA applications, including interfaces with MS Project. * Developed new MS Project applications, including VBA interfaces with Excel. * The State’s budget crisis caused the elimination of this position. April 2002 - June 2002 RELEVANT BUSINESS SYSTEMS - San Ramon, CA. Programmer/Analyst - Developing specifications and software applications for an Enterprise Resource Planning system. April 1999 - June 2001 RELEASENOW.COM - San Carlos, CA. Consulting Manager/Senior Software Engineer - Analyzing, designing, and programming software solutions that support on-line sales of ReleaseNow partners. April 1995 - April 1999 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 VB applications using object-oriented techniques for analysis, design, and software construction. 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 Firstwave Technologies (formerly Brock International) Charles Schwab Meta-Software December 1994 - April 1995 SELF EMPLOYED - Danville, CA. Independent Software Engineer/Analyst Clients include: Price Waterhouse Aurum Software July 1992 - December 1994 TERRACE SYSTEMS CORPORATION - San Francisco, CA. Senior Developer/Consulting Manager - Analyzing and developing C++ and SQLWindows client/server applications. May 1988 - June 1992 PRICE WATERHOUSE TECHNOLOGY CENTRE - Menlo Park, CA. Software Engineer/Manager in Tax Technology Group 1991 - 1992 Software Engineer/Manager in System Support Group, 1988 - 1991 April 1973 - May 1988 PRICE WATERHOUSE - San Francisco, CA. Software Developer/Manager in Management Consultant Services 1987 - 1988 Software Developer/Consultant in Management Consultant Services 1975 - 1987 Programmer, Management Consultant Services 1973 - 1975