Experience:
|
Diversified Onsite Consultants
Aug 2002 -Dec 2002 - Sacramento, CA
* Working as Access programmer developing and upgrading existing and new databases for various clients on an offsite basis using MS Access 2000/2002(XP)
* Developed and updated Access database for Bender Warehouse in Woodland, CA to track down their inventory/parts shipment
* Designed and developed a statistical Access database to track down performance of various employees/pickers for warehousing operations at Mountain People's Warehouse in Auburn, CA.
Bank of America
April 2002 - Sept 2002 - Rancho Cordova, CA
* Worked through TekSystems. as Access programmer developing and upgrading existing databases for Customer Real Estate Division
* Created interactive incentive reports on a daily basis for upper management
* Created complex Access Reports using data migrated from IBM AS/400 , SQL 6.5/7.0 and Oracle 8.
* Created complex queries on Access 97 and Access 2000 using Access queries and SQL views utilizing ODBC.
* Analyzed, tested, redesigned and documented existing Access databases. Resolved problems with client/server applications.
* Trained end-users in the use of customized application.
* Provided automation for Banking applications.
Dept. Of Justice
Dec 2000 - Present - Sacramento, CA
* Worked through Ballyntine, Inc. as Access programmer on a continuous off-site telecommute basis
* Modified existing personnel and training database systems using Access 97/2000
* Produced updated specialized reports for personnel requirements
* Provided in-house database training on software use
* Developed group-level and user-level security for existing applications
* Analyzed, designed and documented all Access databases using FMS software.
AT&T Wireless
Feb 2001 - Nov 2001 - Rancho Cordova, CA
* Worked through The Maxim Group as programmer/web designer for the Asset Tracking Division of AT&T Wireless
* Modified and maintained National Inventory Database using Access 97/2000, SQL 7/2000, Oracle 7/8, VB 6, ActiveX, ODBC, OOP, DAO, and ADO in a client-server environment.
* Converted Access Reports into Excel spreadsheets using VBA
* Designed macros and automated spreadsheets in Excel VBA
* Migrated data constantly and automatically from Oracle and SQL databases.
* Provided user-friendly interfaces on Access 97/2000 for data found on MP5 systems.
* Provided Detail and Summary Reports to National Switch Administration and National Inventory Management
* Update and Maintain National Web Page for surplus equipment
* Trained end-users on the use of customized applications.
Newspaper Industry Communication Center (The NICC)
Sep 2000 - Feb 2001 - Sacramento, CA
* Worked through RHI Consulting as programmer/consultant reporting to Vice-President for Operations
* Designed and maintained professional report generation program using VB 6, Access 2000, ActiveX, ADO, MS Query, OOP, ODBC, and SQL 7 in a client-server environment.
* Prepared specialized accounting and inventory reports in Access, Excel VBA and Crystal Reports.
* Automated and interfaced MS Outlook with Excel and Access using Excel VBA
* Automated Report submission to various clients and to National Headquarters using Excel VBA and MS Outlook.
* Analyzed, designed, tested, documented and resolved problems on existing and new client/server applications.
* Worked with a variety of people from upper management to rank and file employees all of which are final end-users
* Trained employees on all levels in the use of customized software.
Orchard Supply Hardware/Sears Stores
Aug 2000 - Oct 2000 - San Jose, CA
* Worked part-time through The Maxim Group as programmer/analyst to modify/update existing MS Access 97 accounting package using Access VBA, ActiveX DLL, Visio, ODBC, and MS Query.
* Interfaced Access 97 with Excel spreadsheets using VBA for accounting purposes and as attachments for email
* Designed, tested, documented and debugged existing and new accounting applications in Access and Excel VBA.
* Provided support for help desk/user status database
Sutter Health Biomedical Research Center
Apr 2000- Aug 2000 - Sacramento, CA
* Worked through Kenda Systems as programmer/analyst to update existing Billing/Equipment Monitoring database using Access 97, VBA, DAO, and VB 6.
* Performed program conversion between various languages using C++, VSAM, VB and DOS.
* Performed data conversion from Lawson Systems to MS Access.
* Performed application conversions from Excel 97 to Excel 2000 using VBA
New Boston Systems
May 1999 - Dec 1999 - Sacramento, CA
* Worked on several on-going projects as programmer/analyst using MS Access, VB, Excel VBA and DAO.
* Developed and modified budget analysis programs for the Prison Industry Authority
* Provided technical documentation for Department of General Services Surplus Inventory project. Assisted in the preparation of specifications for the said project in MS Access using System Development Life Cycles.
* Analyzed the Injured Workers project for the State of Nevada and provided recommendations using Visual FoxPro.
* Developed and modified Box Office program for the City of Sacramento converting the database from dBase III to MS Access 97
Dept. of Alcohol and Drug Programs
Feb 1999 - May 1999 - Sacramento, CA
* Worked through AccountTemps as conversion specialist to mainly convert existing Corel Office suites into MS Office Suites using WordPerfect, Quattro Pro, Lotus 1-2-3, MS Word, Excel, Access, VB and macros.
* Converting existing Lotus 1-2-3 macros into Excel using VBA.
* Provided support for Budget Analysis program using MS Access, VB, Excel, Lotus, DAO, ODBC, and ActiveX.
Cirrus Logic, Inc.
July 1994 - Dec 1999 - Fremont, CA
* Worked initially through AccountTemps as accounting assistant but was converted to full-time later as application developer
* Developed programs in MS Access 2.0 and 97, Visual Foxpro 3 and Visual Basic 4 to streamline operations for the credit department.
* Provided in house training and support in various computer software like Word, Excel, Powerpoint, Access, Paradox, WinFax, Lotus Notes, 1-2-3, ODBC, MS Query and Laplink.
* Prepared specialized reports using Excel VBA and Crystal Reports 4.
* Responsible for developing the website for the department's intranet.
* Responsible for the recommendation, installation and testing of varrious computer software packages like D & B Dunslink, Graydon, B of A Bamtract Provided interface between AS/400 files, SAP/R3 and IBM Win95 files
Gans-Tire West Co., Inc.
Jul 1990 - Jul 1994 - Hayward, CA
* Initially hired as administrative assistant but was promoted later to systems analyst
* Entered freight billing information, provided shipping documents, scheduled pick-ups and delivery, answered phones and prepared Letters of Credit
* Developed in house programs in dBase IV and Foxpro 2.0
* Provided in-house training and support for employees on various computer software packages like MS Works, Word, Excel and ACCPAC.
GuthMiller Trucking, Inc.
Aug 1985 - Jul 1990 - Union City, CA
* Initially hired as data entry clerk but was promoted later to systems analyst
* Entered freight billing information, FCS (fuel check system) cash advances and credit limits.
* Developed programs in MAI Basic Four and dBase III
* Maintained existing programs written in MAI Basic Four language
* Provided support and training for new and existing personnel on computer |
Professional Skills
|
Software
* Windows 95/98/Me/2000 and DOS
* MS Office, Word, Excel, PowerPoint, Access, Publisher, Outlook, FrontPage ,Visio
* Visual Basic for Applications (VBA)
* Crystal Reports
* Lotus WordPro and 1-2-3
* Corel WordPerfect and Quattro Pro
* Oracle 7 and 8.
* Internet Explorer and Netscape Navigator
* Reflections FTP and WinFTP
Languages
* SQL 7 and 2000, Views and Stored Procedures, DTS
* MS Access 2000/97 VBA, MDB's and ADP's
* Visual Basic 6
* DAO, ADO, Object-oriented Programming, ActiveX DLL
* Client-Server applications, data extraction, data warehousing
* ODBC, OLE automation
* FTP, HTML
* Full System Development Life Cycles
Misc. skills
* General Accounting principles, G/L, A/P, and A/R
* B of A BamTract, Dunn & Bradstreet, Letters of Credit
* AS/400 and SAP/R3
|