Summary of qualifications

• Experienced in Microsoft Office, particularly Access and Excel including extensive programming with Visual Basic and querying using SQL.
• Over 12 years' experience in database administration, report design, business analysis, productivity measurement, quality improvement identification and implementation, and activity-based costing.
• Experienced in linking database content to websites, using HTML, Cold Fusion, and Crystal Reports.

Professional experience

Confidential

Data Analyst

• Member of team that developed two Access 2007/2010 databases for Document Compliance DC and Remediation Process Tracking RPT . The DC database receives input of Client Information, Product Information, and Compliance Rules in order to determine which Clients have Contracts for Products and/or Services with JPMC which are not in Compliance with corporate Rules regarding Documentation of Terms and Conditions. The RPT db receives the output of the DC db and assigns Clients that are out of Compliance to JPMC associates for review and remediation of compliance deficiencies, tracking incremental steps toward achieving compliance.

Confidential

Access Database Developer

• Developed an Access 2010 database that reports product pricing based on plant, material, product group and transportation requirements, using VBA code and SQL queries. The database imports daily updates from Unicode files and generates reports filtered by Headquarters, Customer, Sales Representative, or Product Price List. The database also generates Error Reports tracking data mismatches in the extract files for Quality Control purposes.
• The database updates overnight using Windows7 Task Scheduler, importing the SAP extract files, then creating two Sales Organization-specific databases which are exported to different network drives for use by those organizations.
• Split the Access database into a client-server format, with SQL Server storing the data tables on the server side.

Confidential

Data Analyst/DBA

• Designed, developed and maintained four new Access 2002/2003 databases, and upgraded the Usage Terminations database. The new databases are a New Contract Mail Log, a Contract Performance Tracking database, Data Terminations Charge Calculator, and Contract Reject Summary. All but the last are split databases, with the back-end residing on a shared network drive. The front-end contains code which verifies that the user has the latest version, that they are authorized to use the database, and that they are not opening the front-end file on a network drive. All of the databases are extensively queried using SQL.

Confidential

Access Database Developer

• Designed and developed the Cost Reporting Access 2003 database. The imports Accounts Payable data from a dozen separate hospitals' accounting systems into Access to allow reporting both on an individual hospital level and at a system-wide level. The database imports its data from a variety of file formats, including Excel, csv, txt, and dat. using VBA, and is queried using SQL.

Confidential

Process Manager

Designed and developed an Access 2002 databases for the Contract Management group. The database automatically imports data from Excel files and displays it in several formats for manual validation. The display forms perform calculations on each record displayed, and updates, using VBA, the calculations as the user changes the values of fields on the form when appropriate. The form only displays the fields necessary for validating each type of customer account and/or geographic location. The databases have over 20 reports each supported by SQL queries, some of Confidential

Access Database Developer.

• Designed and developed an Access 2000 database that uses Visual Basic to import client information from Excel spreadsheets and generate reports on that data displaying a variety of views.

Confidential

Hardware Sales Analyst.

• Generated monthly sales reports using Access and Excel, also developed additional reports using these databases.
• Converted/upgraded several Access 97 databases to Access 2000.

Confidential

Access VBA Programmer.

• Modified existing Visual Basic code in an Access database to automate the process of inputting data downloaded from several supplier websites in Comma Separated Values .csv format.

Confidential

Excel VBA Programmer/Developer.

• Designed and developed an Excel spreadsheet with Visual Basic code to be downloaded from client's Website to the customer's computer for the purpose of Offline Ordering. The VB code automatically imports a CSV data file to Excel spreadsheet, reformats it for ease of customer view and use, and limits input to a select number of fields for ordering. After the customer completes their order, the program uploads the order to the client's Website.

Confidential

Database Administrator and Website Developer.

• Created and maintained four Access databases supporting E911Police/Fire Emergency systems Y2K upgrade projects. These databases tracked all Motorola-built E911 systems worldwide, categorizing them according to their Y2K readiness/need for Y2K upgrade. It further itemized the equipment at each customer location, identified customer and Motorola contacts, and captured upgrade costs per site if applicable.
• Co-developed and maintained four Websites linked to the Access databases using HTML and Cold Fusion, and Crystal Reports for real-time, dynamic reporting and graph generation.
• Associate Member, Process Measurement and Admin Team.
• Developer/Administrator for Activity Based Costing Process Management Team, utilizing Excel, Access, and Word. Organizer/Site Manager for three Project Miracles team-building sessions at locations in Wisconsin and Florida. Coordinated travel and lodging for participants, and consulted on program content for these weeklong courses.