Sales Sql Server

Peter Ayers

Email: abqq0r@r.postjobfree.com

Address: **** ** ***** ***

City: Portland

State: OR

Zip: 97266

Country: USA

Phone: 503-***-****

Skill Level: Experienced

Salary Range: $80,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Peter Ayers

7941 SE 103rd Avenue, Portland, OR 97266 * Phone:503-***-**** * Email: abqq0r@r.postjobfree.com

Objective: Business Support utilizing my extensive programming background.

Skills: Access Development. Expert-level experience in all phases of Access-based application development for over 14 years, including database design and implementation, design and development of forms, reports, queries, VBA, and using Access as a front-end to other database systems via ODBC and ADO. Troubleshoot, support, maintain and new development for various Access-based applications. Integrate and control Excel applications in Microsoft Access via VBA.

Excel Applications. Projects utilizing VBA coding to automate complex Excel applications. Used Excel functions to farm data from large scale spreadsheets. Created interactive charts and reports.

Database Systems and Applications. Outstanding skills in designing user-friendly applications by carefully assessing the users' needs and tailoring the forms to the user's skill level. Very strong knowledge of SQL across several database systems: SQL Server, DB2, Oracle. Strong knowledge of logical relational database design. Created training materials and conducted user training classes.

Experience:

Tuality Healthcare 2010 - 2012 Database Analyst

Built Access 2003 database program to manage healthcare services for a non-profit agency supporting health care for migrant workers.

Upgraded to Access 2010.

The client was using an application that was unreliable, losing critical data and was difficult to use.

I redesigned the application to provide absolute security to all data, improved overall ease of use and provided many additional functions that greatly increased the productivity of the staff that used the application and depended on it to manage their daily activities.

AT&T Wireless 2008 - 2009 Access Program Developer

Created a tracking program to manage all cell towers within Oregon, Washington and

Alaska, including all equipment, maintenance scheduling and contracts.

Merged numerous Excel spreadsheets to provide a coordinated application.

Converted the Excel spreadsheets to an Access application that was easier for various staff members to manage.

Providence Health Plan 2007 - 2008 Access Program Developer

Created Access2003 program that imported a pharmaceutical text file from Argus source, analyzed complex conditional data, produced Medicare compliance letters and stored data for long-term retrieval.

Produced automated periodic reports from stored data.

Trained users of the system.

Benson Industries 2007 Access and SQL Server Programmer

Created interactive applications in Access2003 linking to SQL Server 2000 data source.

Converted Access front end to WEB using HTML, ASP, VBScript and VB.net.

Created tutorials to assist users of the applications.

The client assembles curtain wall panels for large building projects from component parts that are imported from various locations. The application I created managed the inventory of individual parts and the schedule of panel assembly enabling the optimum work flow based on available parts needed for the various panels.

Cedar Sinai Park 1988-2008 Computer Programming Consultant

Developed and maintain complex, relational database program tracking demographics

of 23,000+ donors, residents and relatives of this assisted living and nursing facility.

Originally developed in dBaseIII.

Converted programs to Access95 then to Access2003.

Developed Access2003 programs that interface with other proprietary applications:

RaisersEdge by Blackbaud

CoWorker by Continuex

Direct deposit programs by USBank

Provided ongoing training and support for program users.

As an on call consultant, I worked with a variety of applications involving fund raising, patient census, activity scheduling and banking. Although most of the projects utilized database programs, many required interface with other types of applications such as spreadsheets, word processing and graphics.

Serbaco, Inc. 2006 Access Programmer

Converted Paradox business and accounting program to Access2000.

Integrated functions that had been done with Word documents and Excel into the Access program to greatly simplify creation of proposals, purchase orders, invoices and accounting reports.

Household International 2000 - 2001 Visual Basic, Excel, Access Programmer

Created VB, Access and Excel automation programs that interacted with mainframe screens.

Automated Excel and proprietary applications to enhance speed of data exchange and reporting for marketing and collection activities.

Created VB marketing application that interfaced with mainframe screens, prompted sales agents, validated requirements and reported on sales.

Conducted agent training and accounting follow-through.

The client was using a complex Excel application to schedule monthly telemarketing workloads at six remote sites. This was taking a staff member six to eight hours to complete. By automating with VBA coding, the task was completed in less than an hour with greater accuracy.

Wells Fargo Bank 2000 Access, Excel Programmer

Created Access97 applications that download data from DB2 and Oracle mainframe source files using pass-through queries, to create daily and monthly reports that track collection efforts.

Data is also exported to Excel for reports and pivot tables.

New Edge Networks 2000 Access Programmer

Created an Access2000 accounting application. Program automates the entry of complex invoices and transfers data to an Oracle accounts payable module. Also complex reports using Access and Crystal Reports 7.

IBM Global Services/Fred Meyer/QFC Food Centers 1999 Foxpro/Access Programmer

Converted Foxpro programs to Access 97 including Y2K remediation.

Modified and enhanced Visual Basic 5 applications.

Supported and modified 20 applications while company merger changed operating system, network layout, and equipment.

Industrial Design Corporation (IDC). 1992-1995 Foxpro Programmer

Developed an estimating program that enabled a single operator to estimate the cost of a billion dollar computer chip facility in minutes. This task formerly required 36 to 60 man/weeks by a team of engineers, designers and estimators.

Converted program to Foxpro2.6 MAC.

Conducted training classes and phone support for users of this software.

Rick's Custom Fencing 1990-1991 Foxbase Programmer

Developed cash receipts and estimating program in FoxBase that was networked between all stores and the home office.

Enabled sales representatives to instantly estimate the cost of fencing and decking installations and produce sales receipts and schedule installations.

Foxbase 1.1 and Novell network.

Oregon State University 1988-1989 Database Programming

Working through staffing agencies, I created, modified and maintained database programs for Oregon State University, City of Tigard and other firms.

Also program documentation, desktop publishing and program testing assignments.

Various database design projects for individual clients.

Sotware: Database Application Programming:

Access1.1 - Access2010

Visual Basic 5 and 6

SQL Server 2005

Crystal Reports 7.0

FoxBase, Foxpro2, Foxpro2.6 (DOS, Windows, Mac), Visual FoxPro5 and 6

Desktop Publishing:

Pagemaker 7.0

Spreadsheet:

Excel 95 - Excel 2007

Lotus

QuatroPro

Word Processing:

Word 95 - Word 2007

WordPerfect

Web Design:

Adobe Dreamweaver CS3

Microsoft Front Page

PHP5

MySQL5.5

Education: Rensselaer Polytechnic Institute, Troy, New York, B.S. (Building Construction)

Activities: President, Portland Access User Group, 2000 - 2001 Updated 11/3/12

Contact this candidate