Allen Beechick

**** ******* **. ***. *, Santa Barbara CA 93101

805-***-**** cell

adjq73@r.postjobfree.com

SUMMARY

Microsoft Certified Programmer

Expert in Visual Basic for Applications (VBA) in Excel, Access, and Visual Basic. Wrote Excel macros to automate pivot tables, charts, and interfacing with MS Access.

Designed Excel tools for programmers in VBA, market and sell them on the web (http://www.aislebyaisle.com/access/exceltool.htm and http://www.aislebyaisle.com/em/excelcalendar.htm )

Known as the Excel guru, fellow workers come to me to write macros to automate their work.

Working knowledge of VB Script, Python, C#, C++, Java, RESTful services

EXPERIENCE

Data Analyst at Inland Empire Health Plan (Rancho Cucamonga CA), October 23, 2017 to February 18, 2020

Created queries with Microsoft SQL Server (using temp tables, common table expressions, cursors, pivot as necessary). Turned query results into reports in Excel. Used Excel VBA code to format reports automatically. Also used MS Access to automate reports with VBA code.

Replicon Administrator at Hamner-Jewell and Associates, November 21, 2016 to March 17, 2017

Administered the online Replicon application that tracks employee time, employee expenses, and project management. Diagnosed Replicon issues and arrived at solutions. Created a dozen reports, such as project status reports, from Replicon and formatted some of these reports in Excel automatically with macros. Completed a task list of 60 items. Created two Access databases. The job ended when the work ended.

SQL Programmer at Pacifica Graduate Institute, August 13, 2012 To April 7, 2016

Tracked student data with MS SQL Server, PowerCAMPUS, SSIS, SSRS, C# and Visual Studio. Created a data warehouse and reports based upon it. Assisted users with reports and Excel. Created Access databases. Converted FileMaker Pro databases to Access.

Excel and Access Programmer at Autodesk, July 6, 2009 To August 10, 2012

Developed a pricing model for 130 Autodesk products across 30 geographical regions with various licensing models. Wrote macros in Access and Excel, and imported/exported data from one to the other.

Programmer at Pacific Capital Bancorp, February 20, 2001 To April 23, 2009

At Pacific Capital Bancorp in Santa Barbara I developed an optimal indexing strategy for the data warehouse, created a data dictionary to track the conversion of source tables/fields to destination tables/fields, and wrote complicated SQL queries. Used Business Objects to create reports. Also used MS SQL Server, DB2 SQL tools, Access, Excel, Visual Basic for Applications (VBA) macros. Known as the Excel guru, fellow workers came to me to write macros to automate their work.

Access Programmer at Federal Home Loan Bank, June 21, 2000 To December 12, 2000

Contracted through Computer Resources Group to Federal Home Loan Bank in San Francisco, the Financial Forecasting and Analysis department. Revised and developed complicated financial reports in several Access databases. Exported data from Access to Excel, automatically formatted the Excel spreadsheet, and automatically created Excel charts controlled from Access.

Access Programmer at Artesyn Solutions, May 11, 2000 To June 9, 2000

Contracted through BCSI to Artesyn Solutions in Lincoln. Debugged and completed a data collection program in Access with a SQL Server 7.0 back end. Heavy coding in VBA and SQL stored procedures. Successfully completed the project in a much shorter time than anyone expected.

Access Programmer at County of Santa Barbara, January 18, 2000 To April 28, 2000

Contracted through Comdyn to County of Santa Barbara. Created Access program with extensive VBA coding to track permits, as well as to track employee performance in the permit approval process.

Excel Programmer at Firemans Fund Insurance, December 7, 1999 To January 14, 2000

Contracted through NSP to Firemans Fund Insurance in Novato. Created Excel macros using VBA to create pivot tables and bubble charts dynamically based on user-selected criteria. Wrote 4000 lines of code in VBA.

Access Programmer at California Department of Food and Agriculture, February 1, 1999 To November 30, 1999

Contracted through Dapru (New Boston Systems) to California Department of Food and Agriculture in Sacramento. Provided business analysis, designed and created an Access application from the ground up. Extensive VBA coding.

Access Programmer at Integral Vision, September 22, 1998 To January 31, 1999

Worked for Integral Vision in Lafayette which is contracted to Caltrans. Enhanced an existing comprehensive project management application in Access. This program is used to organize projects such as rebuilding the Bay Bridge. Intensive VBA programming. A team effort.

Access and Excel Programmer at MedAmerica, September 7, 1998 to November 20, 1998 (concurrent with Integral Vision job)

Contracted through Trattner Network to MedAmerica in Oakland. Provided initial analysis, designed database structure, and developed Access application to track hospital and physician statistics. Used VBA code to construct SQL statements behind the scenes, making queries easier for the user. Interfaced Access with Excel.

Conversion Programmer at Bank of America, March 23, 1998 To August 26, 1998

Contracted through Chen & McGinley to Bank of America corporate offices in Concord. Converted Paradox and Excel costing analysis program to Access. Heavy on analysis, documentation and debugging. Co-workers expressed gratitude because they could now understand the "black box" of the old spreadsheets and programs.

Access Programmer at Pacific Bell, January 20, 1997 To March 22, 1998

Contracted through Computer Resources Group to Pacific Bell in Sacramento. Access programmer, designed queries, forms, and reports for a workload scheduling application.

Excel Programmer at Aegis Mortgage, July 1997 to August 1997 (concurrent with Pacific Bell job)

Contracted through Comms People to Aegis Mortgage in San Francisco. Converted Lotus macros and spreadsheets to Excel VBA macros. Worked off-site part time.

Excel Programmer at Chevron, August 19, 1996 to January 17, 1997

Contracted through Gateway Group to Chevron in Walnut Creek. Designed an Excel program in VBA to interface with Business Objects. Created interface for user to choose selection criteria. Based on the selected criteria, the program extracted data from multiple tables on the server and created charts. Produced 200 pages of VBA code. Programmed every detail of the charts, using VBA, even down to such details as the color of one point on the chart.

Excel and Paradox Programmer at DataQuest, April 4, 1996 to August 9, 1996

Contracted through Application Resources to DataQuest in San Jose. Duties include:

Excel: Re-wrote Excel program in VBA to make it run faster and to create a friendly user interface. Reduced a 3-hour process to 15 minutes.

Paradox: Maintain and debug Paradox programs in DOS and Windows. Maintaining the Paradox programs involves tracking the use of over 50 tables and understanding the numerous queries performed upon them.

Excel Programmer at PG&E, March 27, 1996 to April 3, 1996

Contracted through Knauer Consulting to PG&E in San Francisco. Modified an Excel program that involved calculations and charting. Used VBA to control custom menus, calculations, and the appearance of the charts. The end result was added flexibility and functionality.

Excel Programmer at Anthem Health, July 1995 to March 26, 1996

Worked at Anthem Health in Sacramento. Maintained large physician database, working on mainframe, Excel, Access, and Paradox for Windows, transferring data back and forth between these programs. Highlights include:

Excel: imported Dbase, Paradox, and Access files, manipulated them within Excel using macros and VBA, producing visually pleasing reports. Devised a solution to running out of memory when using multiple dialog boxes, superior to Microsoft's own suggested solutions. Designed and completed several complicated Excel spreadsheets according to specs given by supervisor.

Access: queried large physician database according to different criteria such as tax identification number or medical specialty. Used macros and VBA code to control user interface.

Contact this candidate