Summary

• 18 years of IT experience as an MS Access developer, all of which were
• as a Senior MS Access Developer.
• . Previous experience in oil/gas industry.
• . Skilled with the design, development, implementation and testing of applications using MS Access, all versions, from 2.0 through 2010 . Expert in all aspect of MS Access development and programming,
• including VBA, VB Script, SQL, intelligent screen, data analysis, data mining, and code debugging.

Other Qualifications

• . Excellent written oral communication skills and very good problem solving and analytical skills.
• . Ability to establish strong relationships with business experts and user community.

PROFILE

• More than 18 years of IT experience as an MS Access developer, All of which were as a Senior
• MS Access Developer.
• This includes design, development, implementation and testing of applications using MS Access,
• all versions, from 2.0 through 2010. VBA, Visual Basic, Crystal Reports, ODBC, SQL, ActiveX,
• SPSS, MS Word, MS Excel and SQL Servers as back end under Windows NT environment with
• extensive experience in: stored procedures, triggers, data modeling, systems design and project
• management, data analyst, database administration, database documenter and tester. This is
• everything needed to begin and complete database projects to the utmost.
• Security Issues: I know how to secure databases. When I did the work for the Small Business
• Administration I placed 4 levels of security in the code to make sure data was seen only by those
• who should see it, manipulate it etc.
• When I was with the Washington Navy Yard I secured a dozen databases from unsafe
• expressions to make them function with alternate code. This required extensive rebuilding of
• some of the databases.
• I have worked successfully with teradata over an SQL server on a few occasions.
• About Teradata: Used on some of the larger databases for Smiths Aerospace, the Dept.
• of Justice and the Dept. of Education. Dealt with it on the SQL server. Was particularly
• adept at speeding up the data flow. In one instance it would normally take 20 minutes for
• data to download. Through advanced techniques that were developed, it was brought
• down to 1 minutes.
• . I am their Robohelp specialist after passing a training course and creating Robohelp productions.

CORE COMPETENCIES

• Expert in all aspect of MS Access development and programming, including VBA, VB Script,
• SQL, intelligent screen, data analysis, data mining, code debugging, and etc.
• Office automation of MS Word, Excel and Outlook.
• Robohelp developer.

TECHNICAL SKILLS

• RDBMS: MS Access 2010, 2007, 2003,2000,97,95,2.0, SQL Server
• Languages: VBA, Visual Basic Script, SQL, Transact SQL
• Tools: MS Access, Microsoft Word, MS Excel, SPSS, Crystal Reports, Active X,
• Robohelp, Outlook

Operating Systems: MS-DOS, Windows NT 4.0/98/95/3.51/3.11/3.1 Used Oracle, ADO and SQL

• Server as back end on several databases as an ODBC connection.
• Robotic Testing and Documentation: Large databases require huge amounts of testing. Some need
• this done robotically by computer to make it practical. Documenting the database is also aided by
• robotic techniques built into the program for fast and efficient documentation. I create the robotic
• programs for your systems.
• Robohelp: professional having passing a training course and created Robohelp projects.

INDUSTRY EXPERIENCE

Companies who have hired me:

• B3 Solutions: CACI: . North Carolina Dept of DNR: . Wells Fargo: . Convergy: . Coca Cola Headquarters
• Westlake Petrochemical Company: . Washington Metropolitan Area Transit Authority
• Aurora Flight Sciences: . Fannie Mae: . Essex Technology: HUD: . Swarovski Inc: . Washington Navy Yard: . Novartis: . Smiths Aerospace: . Exemplar: . Skytel: . AARP: . Lockheed Martin
• US Small Business Administration and others

PROFESSIONAL EXPERIENCE:

Confidential

Senior MS Access developer.

• Working full time to create their database to record activities with USDA and other major projects.
• I work independently with managers to construct the database entirely from scratch using my own skills as a data modeler, designer, code writer, report writer, screen designer etc. to manufacture an entire database.

Confidential

MS Access Developer/Manager

• Working full time to create their financial database with MS Access.
• I am automating MS Word and Winzip to send letters to patients, facilities and others as well as scheduling examinations, recording medical files into bmp images, etc.
• Freelancing MS Access projects using E lance and other sources. November 2010 May 2010

Confidential

MS Access developer

Creating miscellaneous MS Access programs as needed.

Confidential

MS Access Developer/Manager

• Created complex MS Access program in MS Access 2003 to reverse engineer a web program for the FBI
• The program required advanced MS Access, VBA and programming skills to convert what was on an SQL server to MS Access.
• I was responsible for reading the server's sql and examine the forms to put into the MS Access
• program.

Confidential

Senior MS Access Developer

• Performing miscellaneous advancement, repair and maintenance on over 20 different databases using MS Access 2003 and conversion to Access 2007.
• Documenting databases for transfer to a later Oracle database. My automating the process I saved North Carolina at least 6 months off this project's length.

Confidential

Senior MS Access Developer, DBA

Completed a very short but very important financial database for Wells Fargo where I had to use MS Access to build a database for a very complex business application. I automated Access with Excel using VBA code to extract information from dozens of Excel files and import them into MS Access in a very special way.

Confidential

MS Access Developer

. Short-term contract, but a vital one, to enable them to finish a billion dollar contract on time with DuPont. It was a financial database to do their payroll. Access 2003, reporting, heavy use of VBA etc. were required as well as VBScript. I was the right man for the job.

Confidential

Senior MS Access Developer Senior Database Developer

• Developed an existing system made in Access 03 to remove bugs and enhance performance.
• Redoing the data model and annotating code.
• Making Excel spread sheet to mimic all mathematical functions in the database.
• Continuing support: Case Systems is a global company.
• Used VBA, VB Script, Data modeling, full cycle development.
• Another satisfied customer for a very short project

Confidential

Senior MS Access Developer Senior Database Developer

• Developed their entire database program to determine their profits for each of their products and customers for their company worldwide.
• It was a short work, but put in 88 hours of overtime to meet their deadline.
• Done in MS Access 2003, wrote huge amounts of VBA code and VB Script to order their data for reports. Was fed data from their SAP system.
• Did their data modeling, table design, form design, manual etc. to give them a complete program mostly single handedly.

Confidential

Senior MS Access Developer Senior Database Developer

• Short project using MS Access 2003.
• Created a database to give reports about the efficiency of their welders so they may keep track of the quality of their workers.
• Was responsible for all aspects of the development and production.
• VBA and VB Script were used extensively.

Confidential

Senior MS Access Developer, DBA

• In this very short-term project created their logical model for the database, which satisfied their government accounting requirements.
• VBA and VB Script were used extensively.

Confidential

Senior MS Access Developer, DBA

• Wrote queries for two small programs in MS 2007.
• Checked data integrity, Created business model, which means communicating with the users and defining their needs. Created Data model and database plan and flow chart, did data analysis.
• Maintained and adjust an Excel spreadsheet.
• Test and debug the program.
• Analyzed the code and make corrections.
• Programmed Excel using VBA code and wrote formulas.
• Designed to help them keep track of over 700 buildings and programs associated with them.
• Test and debug program.
• A lot of skill in knowing about financial matters was involved. I did their data analyses as only an experienced businessman could base upon my Business Administration degree.

Environment: MS 2007, MS Access 2003, VBA, SQL, Crystal Reports, Excel spreadsheet, Windows NT

Confidential

Senior MS Access Developer, DBA

• Created financial program for their bookkeeping dept that compared month, year income for all general ledger categories.
• Used Access 2003, SQL, VBA. This was a short, 160-hour project.
• Designed tables, forms, queries and reports using VBA, SQL, Crystal Reports, Excel, SPSS and other tools.
• Wrote all necessary VBA, VB Script and SQL code that the program needs
• Five different programs, all involving sales and bookkeeping, were involved.
• Test and debug the program. Analyzed the code and make corrections.
• Created error prevention throughout the program to make it idiot proof .
• Created intelligent forms. Created self-testing and self-diagnostic software to ensure the integrity of the program and its data Created programs from start to finish.

Environment: MS Access 2003, VBA, SQL, Excel, Windows NT

Confidential

Senior MS Access Developer, DBA

• Upgraded and rebuilt existing programs to bring them up to professional standards and to make them compliant with MCI security restrictions having to do with unsafe code.
• Used Access 2003. Performed lot of work in business modeling, created specs, managed project, checked data integrity, done business model and data model, created forms, reports, queries, manuals, data analysis etc.
• Designed tables, forms, queries and reports using VBA, SQL, Crystal Reports, Excel, SPSS and other tools. Designed custom security when needed.
• Wrote all necessary VBA, VB Script and SQL code that program needs. Did data analysis.

Environment: MS Access 2003, VBA, SQL, Crystal Reports, Excel, Windows NT

Confidential

Senior Access Programmer, DBA, Data Analyst

• Created a financial program in MS Access 2003 that records all of their resident data for retirement home. This is a data migration program that takes records from their old data from various resources and puts it into new relational format.
• Created a data stream to place data into predefined structure for exportation. Created program that will read table definitions as detailed on an Excel spreadsheet and cause Access to automatically create those tables.
• Designed a program to thoroughly check formatting of all fields to be sent to other programs during data migration.
• Checked data integrity.
• Created business model that means communicating with users and defining their needs.
• Performed creation of Data model and database plan and flow chart.
• Designed tables, forms, queries and reports using VBA, SQL, Crystal Reports, Excel, SPSS and other tools.
• Designed custom security when needed.
• Wrote all necessary VBA, VBScript and SQL code that program needs. Tested and debugged program.

Environment: MS Access 2003, VBA, SQL, Crystal Reports, Excel, SPSS, Windows NT