Sql Server Data Analyst
Resume:
Allen Beechick
**** ********* **., ****** ** ****2
**********@*****.***
SUMMARY
MS Excel, including pivot tables, graphs, charts, statistical analysis, complex formulas and macros
MS Access, including VBA and macros, designing tables and forms and reports, converting, pass-through queries, developing relational database applications as stand alone or as using SQL Server back end
MS SQL Server, including queries, views, stored procedures, converting from legacy databases, normalized database design
Working knowledge of C#, C++, ASP.NET, PHP, Perl, Javascript, HTML, XML
Microsoft Certified Programmer
Other skills include gathering business requirements, aggregating data from diverse tables and databases, building a data warehouse, debugging data anomalies, converting from legacy databases such as FileMaker and Paradox, automating processes with macros and Task Scheduler.
EXPERIENCE
Access Programmer contracted to Integrated Resources (Pomona CA) from August 23, 2021 to March 31, 2023
Maintain and modify an existing Access application, relying heavily on VBA (Visual Basic for Applications) just as Excel does.
Data Analyst, Excel and Access Programmer, 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 and email them automatically. Also used MS Access to automate reports with VBA code. Designed and created a new Access database to track patient surveys, where some questions asked varied according to some questions answered, making for dynamic interaction.
Replicon Administrator and Access Programmer at Hamner-Jewell and Associates (Arroyo Grande CA), 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 and Access Programmer at Pacifica Graduate Institute (Montecito CA), August 13, 2012 To April 7, 2016
Tracked student data with MS SQL Server, PowerCAMPUS, and Visual Studio. Created a data warehouse and reports based upon it using SQL Server Reporting Services. Assisted users with reports and Excel. Created Access databases, two of which were converted from FileMaker. With Visual Studio 4.5 created a Wix Package Installer using XML.
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 2007 and Excel 2007, importing/exporting data from one to the other, and automated creating charts. Created XML files using VBA code. Linked Excel to Sharepoint data.
Database Programmer at Pacific Capital Bancorp, February 20, 2001 To April 23, 2009
At Pacific Capital Bancorp in Santa Barbara (parent company for Santa Barbara Bank and Trust) 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 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. The most complicated reports drew data from several tables simultaneously for any given time period. In order to provide such flexibility, used VBA code to create the SQL statements, to create the queries with joins and unions, and to modify the labels and financial formulas on the report itself. In this manner, a few basic reports were adapted to an infinite array of possibilities. Data was linked to an Oracle back end as well as to FoxPro tables.
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. Also used a VB 6.0 program as a guide for coding conventions. 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. Designed table structure, complicated forms with interdependent calculations, and reports with flexible user-selected criteria.
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 VBA code.
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. Converted data from Dataflex. Synchronized data from laptops in the field with data on the office server. Documented in PowerPoint and gave group presentations using PowerPoint. Final database had 443 objects and 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 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. Used Lotus Notes. Co-workers expressed gratitude because they could now understand the "black box" of the old 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, design queries, forms, and reports. Debugged and wrote enhancements to current workload scheduling application which draws upon 150 tables and queries. Converted four Paradox databases to SQL and Access. Converted Access tables to MS SQL Server tables. Wrote queries and stored procedures in Microsoft SQL server. Used three versions of Access. Used ODBC to connect to Microsoft SQL Server back end.
Contact this candidate