Arthur W. Little Excel / Access / SQL / VBA Developer 400 Jeannie Court Danville, CA 94526 (925) 786-3515 Email: arthurwlittle@gmail.com Website: http://arthurwlittle.tripod.com LinkedIn Profile: http://www.linkedin.com/in/arthurwlittle June 16, 2019 SUMMARY I am seeking short-term application development opportunities in the San Francisco area and long-term opportunities in the Phoenix area. My 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. I have worked with relational databases since 1988. However, I have invested a major portion of my time during the past eighteen years developing Visual Basic for Applications (VBA) projects within MS Office. I have designed, developed, documented, and maintained very successful, user-friendly VBA applications primarily in Excel and Access, but also in PowerPoint, Visio, Word, and Project. HISTORICAL SKILLS Languages: VBA, Visual Basic 5/6, VB.NET, 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, Access, Visual Studio, SSIS, SSAS, Project, Word, Visio, PowerPoint, Scope, 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: Cash Flow Analysis, Financial and Business reporting, Advertising, Pricing, Order processing, 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. * Eighteen years of current experience utilizing VBA within MS Excel, Access, PowerPoint, 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 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 ADODB, SSMS, 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 applications in C, C++, COBOL, SQLWindows, and APL. * Working in pre-2002 Unix and all Windows (95 through 8) Operating Systems. I am well versed in all of the core functions of SQL and normalization. I have very strong analytical skills and a deep understanding of SQL and the relational model. In addition to MS Access, my RDBMS experience can be summarized as follows: Programming Location RDBMS Language Interface Program 2012-2015 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, WinSQL 1996-1998 3Com (Gupta) SQLBase SQLWindows,SQR WinTalk 1995-1995 Charles Schwab Oracle SQLWindows SQL*Plus, 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 October 2017 – June 2018 (Additional follow-up projects contracted in 2019 at Ross Stores) Ross Stores (via Modis/Adecco) - Dublin, CA. Database Analyst/Developer - Store Operations department: Provided additional documentation for previous work in Access and Excel and resolved problems associated with external data anomalies. Completed 11/1/2017. Excel Developer - Compensation department (HR): Designed and implemented enhancements and corrections to Excel/VBA based compensation analysis applications created by other developers. Completed 1/19/2018, except for anticipated revisions in April or May. January 2016 – July 2016 (follow-up projects: December 2016 – March 2017, May 2017) Ross Stores (via Adecco) - Dublin, CA. Excel/VBA Developer – Short-term contract designing and developing Excel/VBA applications for the Human Resources department at Ross Stores. Database Analyst/Developer – Follow-up contract at Ross Stores designing and developing MS Access and Excel applications for the Store Operations department. Database Analyst – After completing all projects, I departed for 4 months before being asked to return in December, 2016 when I successfully designed and developed new Access/Excel/SQL/VBA applications. I created Excel templates that contain parameters and SQL statements to extract Access data into top-level worksheets and VBA code to drill-down the data. I returned in May to import data from Interactive Voice Response (IVR) CSV files into Access and provide new reports. October 2015 – December 2015 Ernst & Young (via enableIT) – San Francisco / Century City, CA Software Developer/Analyst – Short-term contract to provide Excel/Access/PowerPoint/VBA development and analysis. May 2010– July 2015 Microsoft Corporation (via PT Systems) – San Francisco, CA Software Developer/Analyst – Full-time contract to develop and maintain software for display advertising. August 2009 – December 2009 THINKNICITY – San Francisco, CA VBA Developer – Designing and implementing MS Office applications with extensive use of VBA code. (Contract at Foster’s Group in St. Helena, CA, to develop a 40 table MS Access Five-Year Product Strategy plan) (Contract to 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 solutions. (Full-time on-site contract with UBS Investment Bank, Exchange Traded Derivatives department in Chicago) September 2003 – September 2005 TEXSOURCE - Stamford, CT (Telecommuting from Danville, CA). Software Developer/Analyst – Providing software analysis and solutions. (Part-time contract with UBS Investment Bank, Exchange Traded Derivatives department, Chicago) May 2004 – December 2004 GLOTEL – San Francisco, CA Contractor/Software Analyst – Preparing financial reports and providing software automation (Full-time contract with Charles Schwab) 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) 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. April 2002 - June 2002 RELEVANT BUSINESS SYSTEMS - San Ramon, CA. Programmer/Analyst - Developing technical 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 primarily Visual Basic software solutions to 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 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. December 1994 - April 1995 SELF EMPLOYED - Danville, CA. Independent Software Engineer/Analyst 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 WORLD 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 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 June 1966 – May 1970 UNITED STATES ARMY - Washington, DC. Chief, Administrative Services Division / Captain - U.S. Army Headquarters, 7/17th Air Cavalry Squadron and 1st Aviation Brigade, Vietnam. Liaison Officer/Officer In Charge / Lieutenant - U.S. Army Returnee Reassignment Station, Charleston AFB, SC.