Access Database Developer - Computer Software Programming Resume Sea
Access   Database Developer - Computer Software Programming Resume Sea
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

Access / Database Developer Resume


Desired Industry: Computer Software/Programming SpiderID: 53288
Desired Job Location: Denver, Colorado Date Posted: 8/4/2011
Type of Position: Contractor Availability Date: 8/15/2011
Desired Wage: 50/hr
U.S. Work Authorization: Yes
Job Level: Experienced with over 2 years experience Willing to Travel: Yes, 25-50%
Highest Degree Attained: Bachelors Willing to Relocate: No


Objective:
Access / Database Developer


Experience:
Rocky Mountain Arsenal Remediation Project
Commerce City, CO
Access Developer 01/2011 – 8/2011
* Provided the Project Management Control division of the Rocky Mountain Arsenal Remediation Venture Office with the capability to calculate employee bonuses in accordance with company requirements by developing and successfully implementing an Access 2007/MS SQL client-server solution that integrated preexisting isolated multiple data stores including Excel flat files, Access, and MS SQL databases as well as
** Documenting existing systems, processes, and developing a plan to integrate disparate unconnected systems
** Developing a database mechanism to provide a audit trail to source data in order to meet legal requirements

Reed Group
Westminster, CO
Access Developer 11/2010 – 01/2011
* Supported critical Access / MS SQL database during program transition
** Added automatic PDF document generation via automation

National Renewable Energy Laboratory
Golden, CO
Scientific Modeling Specialist 11/2009 – 10/2010
* Enhanced the ability of the Strategic Energy Application Center to track the impact of new energy technologies with respect to market penetration, benefits, and environmental impact by developing an N-Tier VB.Net\MS SQL server application that:
** Consolidated the existing Excel worksheets received as reports from 3rd party contractors into one data store which serves as a single access point for all metrics regarding new energy technologies
** Minimized the time required to collate data for report and graphs by developing a reporting tool that allows users to slice and dice data and produce standard reports and ad-hoc graphs
** Provides data version tracking that ensure that all graphs and reports produced by the application have a data trail leading back to the original source documents

Family illness 5/2009 – 9/2009

Digital Theater Systems – Contract Project
Agoura Hills, CA
Access/Excel VBA Developer 11/2008 – 03/2009
* Enhanced the ability of DTS to accurately bill for royalty bearing license amendments by extending the capability of the current license tracking system to include the tracking of subsidiary license amendments and the generation of license agreements via Access / Excel Automation
* Converted License Royalty Tracking database from Access 2003 to Access 2007 to determine the cost-effectiveness of the conversion and its impact on the user experience

Team Disney Anaheim – Contract Project
Anaheim, CA
Access Developer 9/2008 – 9/2008
* Migrated safety tracking and guest claims databases to Access 2007
** Decomposed minimally documented Disney safety and guest claims databases in order to identify and document the processes by which injury claim reports are generated
** Identified the source data for generating the final reports and the primary keys within the source data
** Developed the data flow and relational diagrams identifying how the data is appended and/or modified to provide the detail required in the final report output.

Alcoa Fastening Systems – Contract Project
Carson, CA
Access Developer 2/2008 – 4/2008
* Reduced the time required to track part shortages from several hours to a matter of minutes by developing, implementing parts shortage-tracking database system for Alcoa’s Continuous Supply Logistics Program by converting the pre-existing Excel spreadsheet based system to an Access/MS SQL client-server system
** Simplified the formatting of data prior to importation into the database system via the creation of Excel VBA macros
** Created a user-friendly interface that allows user to quickly import, view, and generate reports in a spreadsheet format in a timely matter, which enabled them to respond rapidly to part shortages, while providing users a secure and robust platform in which to maintain the data

Toyota Motor Sales, USA, Inc. – Contract Project
Torrance, CA
Access Developer 12/2007 – 12/2007
* Improved the ability of Lexus Link Technology Division to track and correlate customer OnStar service metrics in order to improve the customer experience by providing users the ability to import customer OnStar Metrics data into an SQL database through modification of format files, stored procedures and existing Excel formatting macros to correct import errors

Mercury Insurance Inc. – Contract Project
Brea, CA
Access Developer 8/2007 – 11/2007
* Reduced outstanding incident tickets to less than 20-days outstanding as well as increased user-satisfaction by responding quickly and effectively in providing practical and cost-effective solutions to users experiencing problems with existing Access databases
* Enhanced productivity of Mercury Business Systems Team by developing, implementing user requested changes to existing Access databases, including the enhancement of a 4000 user plus roster database

Yahoo Inc. – Contract Project
Burbank, CA
Database Consultant 6/2007 – 7/2007
* Enhanced the ability of the Yahoo Marketplace Operations Team to monitor Marketplace metrics associated with the launch of Quality Based Pricing by designing, implementing an Access/MySQL application that consolidated data sources into one database and that incorporated a user interface that allows users to slice, dice, and export the resulting dataset

Toyota Motor Sales, USA, Inc. (Multiple Assignments)
Torrance, CA
Access Developer 4/2007 – 5/2007
* Streamlined the process by which claims are processed by the CAD Accessory Supply and CAD Quality departments by replacing Excel sheet based system with a database solution that provided users the ability to look up claims, properly disposition them, and have the updated data immediately available to Toyota Customer Services, as well as reduced input errors by providing a user-friendly interface that performed data validation
Project Coordinator / Systems Analyst 12/2006 – 4/2007
* Managed SQL Client-Server Information System Project for Lexus Link Advanced Technology Department to create system that tracks a Lexus Link equipped vehicle from the factory to its final sale
** Coordinated between stake-holders and IS department and developed detailed project plan and proposal for the Lexus Link Voice of the Customer Information System
** Developed T-SQL stored procedures, database tables, and format files for data importation into SQL server database
** Developed an Access front-end to facilitate the importation of data files into the SQL Server backend
Access Developer 8/2006 – 11/2006 * Reduced the time required for Toyota Customer Service to track payments to suppliers by modifying existing Access database so that users could quickly reconcile invoice payments
* Enhanced the ability of the Toyota Lexus Link Advanced Technology Department to accurately and efficiently track Lexus Link On-Star subscriptions and enrollments by designing, implementing Access databases for Lexus Customer Satisfaction Analog Sunset Campaign and redesigned Lexus Link Subscriber Enrollment database
Access Developer 3/2006 – 6/2006
* Upgraded the ability of the Toyota Customer Services Department to track incoming warranty repair parts and shipments to part vendors by developing inventory tracking system for Parts Recovery Center to permit Toyota Central Part Receiving Center to track parts returned
* Supported Toyota Customer Services departmental goals of tracking and resolving supplier claims by redesigning existing VDC Claims, Price Variance, and Supplier Claims database systems through
** Normalization – removing redundant tables, queries
** Consolidating and redesigning forms
** Converting all macros to VBA code, adding error trapping, upgrading databases to Access 2003
** Adding user-requested enhancements such as multiple search criteria functionality

Kaiser Permanente – Contract Project
Pasadena, CA
MS Access Analyst 1/2004 – 11/2005
* Developed complex queries, Excel VBA macros and created monthly management exception reports using Access, Excel, VBA, SQL
* Developed Access databases, with Excel automation that reconciled Revenue Accts, provided analytical support including development of a Reconciliation database allowing users to perform automatic and manual reconciliation
* Administered departmental MS Access databases including establishing workgroup security
* Supported departmental goals of minimizing revenue leakage from daily operations and reporting findings to departmental managers through the development of new databases and the enhancement of existing ones
* Through the use of Microsoft Access and Excel distributed monthly exception reports to regional managers and their subordinates

Mt. Sierra College
Attended College – BS in Computer Information Technology 1/2000 – 2/2003

Cordell Inc.
La Verne, CA
Senior Technician 3/1990 – 5/2001
* Improved bottom line by replacing paper-based customer and product-tracking systems by developing, implementing MS Access solutions:
** Designed, implemented and administered hardware configuration, invoice, production, receiver, in/out-warranty repair, shipment, customer service tracking MS Access applications
* Awarded Employee of Year 1998, Manager’s Award 1997


Education:
B.S. Computer Information Technology
Mt. Sierra College
Monrovia, CA 91016
* Areas of study – Database design/implementation, SDLC methodologies, project management, technical presentation
* Dean’s List, President’s List, graduated Summa Cum Laude

A.A. Electronics
Pasadena City College
Pasadena, CA 91106
* Microwave theory, transmission lines, AC, DC network analysis, microcomputers, digital logic
* Graduated - Administrative Honors


Skills:
Core Competencies

* Client\Server and N-Tier application development (including Access\MS SQL Server 2005/2008, VB.Net\MS SQL Server 2008)
* VB.Net application development
* Proficient in all versions of Access from Access 2.0 to Access 2007
* VBA, SQL, ADO, DAO, T-SQL
* Excel Automation (VB.Net, Access)
* Database Migration
* Advanced Access and Excel report development skills including pivot tables, spreadsheet reporting, Microsoft Query, parameterized queries, Access crosstab reports
* SDLC, Systems Analysis, User requirements gathering


Additional Information:
Profile Summary

Accomplished Senior Database Developer with ten plus years successfully developing, enhancing, and administrating small to large scale Access and Access/Client Server and N-Tier applications for Fortune 500 companies including Kaiser Permanente, Alcoa, Yahoo, DTS, Toyota, Disney, Mercury Insurance,National Renewable Energy Laboratory (NREL), Reed Group, Rocky Mountain Arsenal


Reference:
Available upon request.


Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


    





© 2021 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links