MS Access Developer or Programmer Resume

Title
MS Access Developer or Programmer

Primary Skills
MS Access, Data Modeling, Database Archetecture, Database programming, Visual Basic for Application

Location
US-MD-Oxon Hill (will consider relocating)

Posted
May-07-09


SUMMARY
More than 12 years of IT experience as an MS Access developer, 10 of which as a Senior MS Access Developer. This includes design, development, implementation and testing of applications using MS Access, all versions, from 2.0 through 2007. 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.

SKILLS
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
RDBMS: MS Access 2003,2000,97,95,2.0 , SQL Server
Languages: VBA, Visual Basic Script, SQL, Transact SQL
Tools: Microsoft Word, MS Excel, SPSS, Crystal Reports, Active X
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. (No Oracle programming, though).
Robotic Testing and Documentation :
Large databases require huge amounts of testing. Some need this done robotically (by computer) to make
practical. Documenting the database is also aided by robotic techniques built into the program for fast,
efficient documentation. I create the robotic programs for your systems.
Other Important Skills
Tutoring: Professional tutor in MS Access, VBA, SQL, RDBMS, Data Modeling etc.
Professional speaker, writer, communicator, sign language interpreter for the deaf
Skilled accountant and businessman



EXPERIENCE
March 2009 - present
Freelance developer in MS Access, Teacher of MS Access, Data modeling, Database developement.

North Carolina Dept of DNR October 2008 - March 2009
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.

Wells Fargo March 2008 - July 2008
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.
Convergys March 30 to April 30
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.

Case Systems January 2008 - April 2008
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.

Coca Cola Headquarters Atlanta Georgia. December 2007 - January 2008
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.
Did their data modeling, table design, form design, manual etc. to give them a complete program mostly single handedly.
*\Was fed data from their SAP system.

Westlake Petrochemcial Company August 2007 - September 2007
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.

Wells Fargo, Columbia MD July 2007 - August 2007
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.

HUD, Washington DC May 2007 - June 07
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
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.
Environment: MS 2007, MS Access 2003, VBA, SQL, Crystal Reports, Excel spreadsheet, Windows NT

Swarovski Inc. Rhode Island March 2007 - April 2007
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

Washington Navy Yard, Washington, DC August 2006 - February 2007
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 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.
Environment: MS Access 2003, VBA, SQL, Crystal Reports, Excel, Windows NT

Armed Forces Retirement Home, Washington, DC June 2006 - July 2006
Senior Access Programmer, DBA
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

Nextel, Reston, VA April 2006 - May 2006
Senior Access Programmer, DBA
Created financial program in MS Access 2003 that enables to track and correct quirks in revenue collection and billing.
Managed Full cycle development from business modeling all way to report writing and manual creation.
Upgraded existing MS Access 2000 program to produce desired reports.
Analyzed code and made corrections.
Created error prevention throughout program (to make it idiot proof).
Managed creation of intelligent forms, self-testing and self-diagnostic software to ensure integrity of program and its data.
Created self-documentation to record sub routine execution for purpose of evaluation and manuals for both users and future programmers to use.
Trained users how to use program.
Environment: MS Access 2003/2000, VBA and VB Script, SQL, Crystal Reports, Excel, SPSS, Windows NT

Novartis Company, Morristown, NJ February 2006 - March 2006
Senior Access Programmer, DBA
Helped to develop a system to keep track of distribution of medicines that manufacture using MS Access VBA.
Created small programs for sale on Internet and Share Ware using MS Access.
Created VBA code and VB Script needed to take data from different sources and converted it to a uniform standard layout.
Contracted with companies that have projects too small to make a contract with an employment agency and have customers.
Did all projects in MS Access using VBA, SQL, Excel and other tools at disposal. Many are done concurrently.
Involved in making a financial program for a dance studio that track customers, programs, schedules, receipts and expenditures. Another project is Leonardo Pest Control Management system for use in pest control companies.
Environment: MS Access, VBA, SQL, Excel

Washington Metropolitan Area Transit Authority, Washington, DC July 2005 - January 2006
Senior Access Programmer, DBA
*\Created a financial database in Access 2003 to run their BikeNRide program. This was a solo project.
Created an employee discipline program that tracks errors and warnings sent.
Managed creation of program from scratch, from cradle to grave, to fulfill this need.
Environment: MS Access 2003, VBA, SQL, Excel, Windows NT

Aurora Flight Sciences, Bridgeport, WV April 2005 - June 2005 Senior Access Programmer, DBA
Created sophisticated Access 2003 Project. Program "CORE" (Customer Order Review and Entry) took text files of customer orders, parsed them line-by-line into tables. It extracted all-important data for analysis then entered data into a stand-alone program by automating keyboard to enter information.
Created entire MS Access program to read doc. files, parse contents, place contents into varies fields in a table and created reports from them.
Automated keyboard to place information into another off-the-shelf program.
Environment: MS Access 2003, VBA, VB Script, SQL, Excel, Windows NT

Fannie Mae Foundation, Herndon, VA August 2004 - November 2004
Senior Access Programmer, DBA
Created a master program in MS Access 2000 which verified results of eight other independent programs that did calculations on an SQL based database. Required 40,000 lines of code, hundreds of tables and queries.
Created a common data model for 8 programs referenced above.
Recreated all calculations performed in 8 programs in MS Access so as to verify accuracy of other programs.
Environment: MS Access 2000, SQL, VBA, SQL, Excel, Windows NT

Essex Technology Group, Nashville, TN January 2004 - July 2004
Senior Access Programmer, DBA
Constructed Wits inventory program for Essex Tech Group. This requires creation of an inventory database from scratch using MS Access 2000.
Managed entire implementation. This project was done in MS Access Project with SQL Server as a back end.
Created a database in MS 2000 with SQL Server back end for purpose of report writing and financial analysis. Many business reports were created.
Environment: MS Access, MS Project, SQL Server

Smith's Aerospace, Grand Rapids, MI December 2001 - December 2003
Senior Access Programmer
Designed and produced an MS Access database from scratch to develop input screens, Financial analysis screens and complex financial reports.
Managed Heavy Use of VBA, VB Script, data modeling, form, table, query and code module creation is a daily occurrence.
Served as head of project and designed it according to user's input.
Used Oracle, ADO and SQL Server as back end on several databases as an ODBC connection. (No Oracle programming, though). This program required writing 80 thousand lines of VBA code and just as many lines of SQL.
Built a report creator capable of producing over 250,000 varieties of sophisticated reports.
Automated Excel (using VBA from Access to open and control Excel) to produce very precisely formatted reports. 80 thousand lines of SQL and VBA had to be written.
Created completely from scratch, their Engineering Finance Database so as to enable very sophisticated report writing.
Took upon all management of program to ensure time-line of project.
Environment: MS Access, VBA, ADO, Oracle, SQL Server

Exemplar, Kansas City, MO May 2000 - June 2001
Senior Access Programmer, DBA
Corrected and enhanced existing MS Access 97 and Visual Basic software that uses ODBC connections with SQL Server back end.
Analyzed and corrected VBA code and SQL.
Performed complete diagnostic analysis of program, documentation of program's code.
Managed Diagram and catalogue code used in existing program.
Fixed problems in code and enhanced program.
Environment: MS Access 97, SQL Server, Visual Basic, ODBC, VBA, SQL

Skytel, Jackson, MS March 2001 - April 2001
Senior Access 2000 Programmer
Helped to finish a multi-million dollar project that records equipment sales and service to US Government.
Performed form, query, table and report design, data modeling, analysis, writing complex VBA, stored procedures and triggers. This is an Access Project, not an MDB file. It has SQL Server back end.
Helped existing project manager finish Access 2000 project.
Environment: MS Access, VBA, SQL Server


AARP, Washington, DC November 2000 - April 2001
Senior Access Programmer
Performed Database Conversion - converted older Access 97 Databases to Access 2000.
Managed extensive redevelopment and debugging of existing programs as required.
Converted old programs done in previous versions of Access to current version.
Recreated programs that were too poorly designed to use.
Environment: MS Access 2000/97, SQL, VBA, SQL, Excel, Windows NT

Lockheed Martin, Bethesda, MD June 2000 - October 2000
Senior Access 2000 Programmer
Managed continued development of database programs including design, data modeling and creation, testing and writing manuals. This development was in MS Access 2000 on an NT server.
Used VBA and SQL extensively in this project.
Did extensive analysis to correct, debug and redesign programs that were not working. Main program that was worked on kept track of all of letters of credit Lockheed Martin made throughout world. It required extensive rebuilding.
Managed entire project and created it using specifications given writing by management.
Environment: MS Access 2000, VBA, SQL, Windows NT 4.0

Soza & Company, Falls Church, VA September 1999 - October 2000
Senior Systems Engineer
Used Access 97, Visual Basic, SPSS, SQL Server 7.0, VBA, Excel and SQL.
Programmed VB projects, Access projects and programmed in SPSS and Excel for Department of Education.
Created complex reports requiring writing of 24 pages of VBA code for each report that then created a comma-delimited text file and an HTML .htm file for use in other programs.
Created a Visual Basic executable file that would automate Excel to produce spreadsheets from this information.
Environment: MS Access 97, Visual Basic, SPSS, SQL Server 7.0, VBA, Excel, SQL, HTML

US Department of Education, VA June 2000 - September 2000
Access Developer
Created database for their government allotments of funds system known as FGAS.
Produced an Access 97 program to coordinate various projects so that team leaders could do their work in an orderly fashion. This enabled automatic emailing of information over Internet. Used Oracle as a source of data.
Redesigned and finished preexisting project. Documented it. Bullet proof it. Analyzed, documented it.
Environment: MS Access 97, Oracle

Burgess Electric, Nokesville, VA April 2000 - June 2000
Contract Developer, Project Manager
Worked part time (15 hours a week) developing a system in Access 2000 for Burgess Electric Company in Camp Spring to develop a program to help keep track of construction jobs, inventory and employee activities.
Created an accounting program to keep track of their receipts and billing. This was full-cycle development involving creation of a business model, data model, tables, forms, reports, screens, queries etc.
Managed project from its conception. Used Crystal Reports.
Created database from scratch according to specs derived from interviewing business owner.
Environment: MS Access 2000, Crystal Reports

Department of Justice, Fairfax, VA January 2000 - May 2000
Access Developer
Created sophisticated program for them to create reports about their personnel records.
Used VBA and SQL in an NT environment extensively.
Used Access 97. Used Oracle and SQL Server as back end.
Create user-friendly version to replace existing, nonfunctioning database.
Environment: MS Access 97, VBA, SQL, Oracle, SQL Server, Windows NT 4.0

Department of Education's RSA department, VA August 1999 - December 1999
Access Developer
* Produced several programs in MS Access, Visual Basic and SPSS that interacted with SQL server's tables and queries.
* Used VBA code to generate Excel Spreadsheets and HTML documents that displayed complex reports created with Access.
* Completed FGAS program that meted out federal funding to states.
* Did design, data modeling and development.
* Served as sole programmer for Access part of project.
* Environment: MS Access, VBA, Visual Basic, SPSS, HTML, MS Excel, SQL Server

US Small Business Administration: July 1998 - July 1999
Office of Inspector General SW, Washington, DC
Senior Systems Designer, Project Manager
* Served as sole project manager, programmer, developer, designer, data modeler and business modeler.
* Created several programs in Access 97 to automate offices.
* Created program specifically for their Investigations Division to record and keep track of their cases and investigations. This program recorded and tracked time worked on job for each agent and what cases agents were involved in and all details concerning these cases. It keeps track of all subjects of cases and all of aliases.
* Collected Records evidence. It has many complex forms that calculate statistics for their reporting needs.
* Automated MS Word with VBA & was a year long project.135 tables and 125 screens were needed for this project as well as hundreds of queries and code modules.
* Automated MS Word from MS Access to produce a variety of letters and subpoenas. This involved enabling users to create new form letters in MS Access that would display in MS Word for editing and printing.
* Interfaced program with LAN so that emails could be sent.
* Created a Subpoena tracking system for Investigations Division and Auditor's Division (one for each that works together).
* Developed another program for Legal Division to keep track of all of correspondence. Then another program for I&E division to make office paperless.
* Intermeshed all programs to create an environment where each division could do part of a coordinated work. These programs had to function as a single program. Hundreds of agents throughout U.S.A. used their laptop computers to interface with it, obtaining and entering information concerning suspects, evidence, timesheets and a plethora of other information.
* Managed extensive use of VBA, SQL, data modeling, database design and analysis, creation of forms and tables as required.
* Environment: MS Access 97, VBA, MS Word, SQL, LAN


Internal Revenue Service, New Carrolton, MD June 1998 - June 1998
Contract Developer
* Helped to develop a system to keep track of all internal documents and projects stemming from them in Access 97 in an NT environment.
* Created help system for program.
* Used VBA and SQL extensively as needed. Created help file system using Access Toolkit. Used Active X tools. Used Crystal Reports.
* Fulfilled requirements of lead programmer to help facilitate program's completion.
* Environment: MS Access 97, VBA, Active X, Crystal Reports, SQL, Windows NT 4.0

Hughes Company, Germantown, MD April 1998 - May 1998
Contract Developer, Project Manager
* Served as member of a team to help them keep track of repositioning of thousands of satellite dishes. Created front end and several reports in Access 97.
* Analyzed their data and removed redundant entries.
* Used VBA and SQL extensively. This was a small job that took only 38 hours of working hours over a weekend to help them in their emergency.
* Did data modeling for project as well. Used Crystal Reports.
* Created satellite tracking system and build reports.
* Environment: MS Access 97, VBA, SQL, Crystal Reports

TSI Cable, Gaithersburg, MD January 1998 - March 1998
Contract Developer, Project Manager
* Designed, developed and implemented an application to store and invoice TSI's corporate cable-customers in Access 97. This included creating business model and data model. Customer Invoice Tracking System records all customer account information, payments received, current balance and prints detailed bills based upon customer's business category. This complex system adjusts for bill by prorating for unused portion of a month this program required extensive use of VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables.
* Used Crystal Reports.
* Environment: MS Access 97, VBA, SQL

Totality Software, Vienna, VA August 1997 - December 1997
Contract Developer (telecommuting)
* Created forms for two commercial projects done in Access 97. Each project took about forty hours to complete. This project required advanced knowledge of coding, making tables, standardizing nomenclature, creating sophisticated user friendly forms that calculated percentages and amounts automatically and transferred results into other forms.
* Used SQL and VBA extensively. Used Crystal Reports.
* Created few forms to help them enhance an existing project.
* Environment: MS Access 97, VBA, SQL, Crystal Reports

Teligent Corporation, Vienna, VA November 1997 - December 1997
Contract Developer
* Created over 170 complex reports and front-end interface to access in Access 97.
* Performed data analysis to eliminate duplicate and erroneous entries.
* Created over a hundred queries using advanced techniques.
* Designed and created a front-end process so reports and queries could be easily accessed. This program required extensive use of VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables.
* Used VB to create modules for specific tasks. Analyzed data and data model.
* Environment: MS Access 97, VBA, SQL, Visual Basic

Boeing Corporation, Falls Church, VA September 1997 - October 1997
Contract Developer, Project Manager
* Managed project to create a resume database to handle applicants.
* Designed and implemented database system in Access 97 single-handedly. Project required creating a front end that provided access to dozens of different reports and queries. Reports contained many sub-report objects and forms numbered over 50. System provided dynamic query capabilities for users performing ad-hoc queries.
* Used VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables extensively as required. Used Crystal Reports.
* Environment: MS Access 97, VBA, SQL, Crystal Reports

Kentucky Education Association, Lexington, KY June 1997 - August 1997
Contract Developer
* Created a database in Access 2.0 later manually converted to Access 97. This front-end project kept track of all of their retirees.
* Placed Filter buttons on form that enabled user to see records according to first letter of last name or district number or another associated number. Program printed out mailing labels and reports based upon information in database.
* Used VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables extensively as required.
* Did creation of business model. Managed project.
* Environment: MS Access 97/2.0, VBA, SQL

Worldwide Church of God, Bowie, MD January 1997 - May 1997
Contract Developer, Project Manager
* Designed and implemented a full-featured system for Pastor Garrett in Access 2.0 then manually converted to Access 97. This highly user-friendly program keeps track of all their members and enables church through queries and reports to obtain a large variety of statistics about congregation.
* Created over 40 reports and a dozen screens as well as an on-line help-file system. This program required extensive use of VBA, SQL, data modeling, business modeling, systems design and systems analysis, creation of forms and tables. Managed project.
* Created tables, forms and dozens of interactive reports that used user-input to define report's content. User could survey database to tell him extensive demographic information. Dozens of reports gave statistics on everything minister would have to know. It also recorded family information concerning marital status and names and ages of kids as well as who was in Sunday school. It kept track of telephone calls, baptisms, prayer lists and special needs. It kept track of who was single, who was divorced, who was a deacon and who was an elder. All lists were instantly available. This program is extremely user friendly and used colors and graphics to polish off its appearance. It features a complete custom help system to explain use of every form and button.
* Used VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables extensively as required. Later reengineered this product as a distributed Visual Basic program.
* Environment: MS Access 97/2.0, VBA, SQL, Visual Basic


David Arias Property Management, Beltsville, MD October 1996 - December 1996
Contract Developer, Project Manager
* Developed and installed a property manager's program to keep track of residents and lease payments in Access 97. This program enabled user to keep track of income and expenses for both single-family dwellings and multi-family units. It calculated profit for buildings over time.
* Created various reports as well as mailing lists that were based upon user input.
* Did full cycle including business model and data model. Managed project.
* Environment: MS Access 97

John Dobbs Software Development, Lorton, VA August 1996 - September 1996
Programmer
* Developed this system in VB with Access as its back end.
* Developed and implemented an inventory tracking system that kept track of supplies, usage and on-hand quantity in Access 95. This system consisted of eight screens and five reports. It featured a structured inventory usage process that kept an audit trail history of transactions for each inventory item. In addition it contained an end of year physical inventory process that reconciled end of year inventory with quantity on hand.
* Developed Names Tracking system, primarily as a convenient method to share names among two or more individuals. This system featured a graphics oriented menu, easy to use buttons that made finding a name easy and provided automatic extract capability to export to MS Word.
* Environment: MS Access 95, MS Word, VB

Termipest Inc, Oxon Hill, MD January 1996 - July 1996
Developer, Project Manager
* Designed and developed a complete system for own company to keep track of customers, pesticide usage and solicitation.
* Kept track of all of his customers and everything that they ordered. It keeps track of invoices, pesticides used, employee information, deadlines and more. It features complete help system that is custom made for program.
* Did total design and development including business and data model. Managed project.

Termipest Inc, Oxon Hill, MD 1978 - 1999
President
* Operated pest Control Company for 25 years. Managed employees over that time.
* Managed all aspects of business including bookkeeping, marketing, advertising, business promotions, public relations training and testing of employees, etc.

EDUCATION
AA in Business Administration 197
North Carolina Dept of DNR October 6, 08 to March 31, 09 (6 month contract)
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. This required hundreds of lines of sophisticated code to automate the documentation process. Each query, form, report, control, function and sub routine had to be recorded and put into perspective so that written specs could be made as to what the 26 different databases were doing individually and how they interacted with each other.
March 2009 to present
Frelance projects in MS Access
MS Access instructor, Data modeling instructor
Wells Fargo March 2008 - July 2008
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.
Convergys March 30 to April 30
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.

Case Systems January 2008 - April 2008
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.

Coca Cola Headquarters Atlanta Georgia. December 2007 - January 2008
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. Did their data modeling, table design, form design, manual etc. to give them a complete program mostly single handedly. Was fed data from their SAP system.
Westlake Petrochemcial Company August 2007 - September 2007
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.
Wells Fargo, Columbia MD July 2007 - August 2007Senior 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.
HUD, Washington DC May 2007 - June 07
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 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. Environment: MS 2007, MS Access 2003, VBA, SQL, Crystal Reports, Excel spreadsheet, Windows NT
Swarovski Inc. Rhode Island March 2007 - April 2007
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

Washington Navy Yard, Washington, DC August 2006 - February 2007
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 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 needed. Environment: MS Access 2003, VBA, SQL, Crystal Reports, Excel, Windows NT
Armed Forces Retirement Home, Washington, DC June 2006 - July 2006
Senior Access Programmer, DBA
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
Nextel, Reston, VA April 2006 - May 2006
Senior Access Programmer, DBA
Created financial program in MS Access 2003 that enables to track and correct quirks in revenue collection and billing.
Managed Full cycle development from business modeling all way to report writing and manual creation. Upgraded existing MS Access 2000 program to produce desired reports. Analyzed code and made corrections. Created error prevention throughout program (to make it idiot proof).
Managed creation of intelligent forms, self-testing and self-diagnostic software to ensure integrity of program and its data. Created self-documentation to record sub routine execution for purpose of evaluation and manuals for both users and future programmers to use. Trained users how to use program.
Environment: MS Access 2003/2000, VBA and VB Script, SQL, Crystal Reports, Excel, SPSS, Windows NT
Novartis Company, Morristown, NJ February 2006 - March 2006
Senior Access Programmer, DBA Helped to develop a system to keep track of distribution of medicines that manufacture using MS Access VBA. Created small programs for sale on Internet and Share Ware using MS Access. Created VBA code and VB Script needed to take data from different sources and converted it to a uniform standard layout. Contracted with companies that have projects too small to make a contract with an employment agency and have customers. Did all projects in MS Access using VBA, SQL, Excel and other tools at disposal. Many are done concurrently. Involved in making a financial program for a dance studio that track customers, programs, schedules, receipts and expenditures. Another project is Leonardo Pest Control Management system for use in pest control companies.
Environment: MS Access, VBA, SQL, Excel
Washington Metropolitan Area Transit Authority, Washington, DC July 2005 - January 2006
Senior Access Programmer, DBA Created a financial database in Access 2003 to run their BikeNRide program. This was a solo project. Created an employee discipline program that tracks errors and warnings sent. Managed creation of program from scratch, from cradle to grave, to fulfill this need. Environment: MS Access 2003, VBA, SQL, Excel, Windows NT

Aurora Flight Sciences, Bridgeport, WV April 2005 - June 2005
Senior Access Programmer, DBA
Created sophisticated Access 2003 Project. Program "CORE" (Customer Order Review and Entry) took text files of customer orders, parsed them line-by-line into tables. It extracted all-important data for analysis then entered data into a stand-alone program by automating keyboard to enter information.
Created entire MS Access program to read doc. files, parse contents, place contents into varies fields in a table and created reports from them.
Automated keyboard to place information into another off-the-shelf program.
Environment: MS Access 2003, VBA, VB Script, SQL, Excel, Windows NT
Fannie Mae Foundation, Herndon, VA August 2004 - November 2004
Senior Access Programmer, DBA
Created a master program in MS Access 2000 which verified results of eight other independent programs that did calculations on an SQL based database. Required 40,000 lines of code, hundreds of tables and queries.
Created a common data model for 8 programs referenced above. Recreated all calculations performed in 8 programs in MS Access so as to verify accuracy of other programs. Environment: MS Access 2000, SQL, VBA, SQL, Excel, Windows NT Essex Technology Group, Nashville, TN January 2004 - July 2004
Senior Access Programmer, DBA
Constructed Wits inventory program for Essex Tech Group. This requires creation of an inventory database from scratch using MS Access 2000. Managed entire implementation. This project was done in MS Access Project with SQL Server as a back end. Created a database in MS 2000 with SQL Server back end for purpose of report writing and financial analysis. Many business reports were created.
Environment: MS Access, MS Project, SQL Server
Smith's Aerospace, Grand Rapids, MI December 2001 - December 2003
Senior Access Programmer
Designed and produced an MS Access database from scratch to develop input screens, Financial analysis screens and complex financial reports. Managed Heavy use of VBA, VB Script, data modeling, form, table, query and code module creation is a daily occurrence. Served as head of project and designed it according to user's input. Used Oracle, ADO and SQL Server as back end on several databases as an ODBC connection. (No Oracle programming, though). This program required writing 80 thousand lines of VBA code and just as many lines of SQL. Built a report creator capable of producing over 250,000 varieties of sophisticated reports. Automated Excel (using VBA from Access to open and control Excel) to produce very precisely formatted reports. 80 thousand lines of SQL and VBA had to be written. Created completely from scratch, their Engineering Finance Database so as to enable very sophisticated report writing. Took upon all management of program to ensure time-line of project. Environment: MS Access, VBA, ADO, Oracle, SQL Server

Exemplar, Kansas City, MO May 2000 - June 2001
Senior Access Programmer, DBA
Corrected and enhanced existing MS Access 97 and Visual Basic software that uses ODBC connections with SQL Server back end. Analyzed and corrected VBA code and SQL.
Performed complete diagnostic analysis of program, documentation of program's code.
Managed Diagram and catalogue code used in existing program. Fixed problems in code and enhanced program. Environment: MS Access 97, SQL Server, Visual Basic, ODBC, VBA, SQL
Skytel, Jackson, MS March 2001 - April 2001
Senior Access 2000 Programmer
Helped to finish a multi-million dollar project that records equipment sales and service to US Government. Performed form, query, table and report design, data modeling, analysis, writing complex VBA, stored procedures and triggers. This is an Access Project, not an MDB file. It has SQL Server back end. Helped existing project manager finish Access 2000 project. Environment: MS Access, VBA, SQL Server
AARP, Washington, DC November 2000 - April 2001
Senior Access Programmer
Performed Database Conversion - converted older Access 97 Databases to Access 2000. Managed extensive redevelopment and debugging of existing programs as required. Converted old programs done in previous versions of Access to current version. Recreated programs that were too poorly designed to use.
Environment: MS Access 2000/97, SQL, VBA, SQL, Excel, Windows NT
Lockheed Martin, Bethesda, MD June 2000 - October 2000
Senior Access 2000 Programmer
Managed continued development of database programs including design, data modeling and creation, testing and writing manuals. This development was in MS Access 2000 on an NT server. Used VBA and SQL extensively in this project. Did extensive analysis to correct, debug and redesign programs that were not working. Main program that was worked on kept track of all of letters of credit Lockheed Martin made throughout world. It required extensive rebuilding. Managed entire project and created it using specifications given writing by management. Environment: MS Access 2000, VBA, SQL, Windows NT 4.0
Soza & Company, Falls Church, VA September 1999 - October 2000
Senior Systems Engineer
Used Access 97, Visual Basic, SPSS, SQL Server 7.0, VBA, Excel and SQL. Programmed VB projects, Access projects and programmed in SPSS and Excel for Department of Education.
Created complex reports requiring writing of 24 pages of VBA code for each report that then created a comma-delimited text file and an HTML .htm file for use in other programs. Created a Visual Basic executable file that would automate Excel to produce spreadsheets from this information.
Environment: MS Access 97, Visual Basic, SPSS, SQL Server 7.0, VBA, Excel, SQL, HTML
US Department of Education, VA June 2000 - September 2000
Access Developer
Created database for their government allotments of funds system known as FGAS.
Produced an Access 97 program to coordinate various projects so that team leaders could do their work in an orderly fashion. This enabled automatic emailing of information over Internet. Used Oracle as a source of data. Redesigned and finished preexisting project. Documented it. Bullet proof it. Analyzed, documented it. Environment: MS Access 97, Oracle
Burgess Electric, Nokesville, VA April 2000 - June 2000
Contract Developer, Project Manager
Worked part time (15 hours a week) developing a system in Access 2000 for Burgess Electric Company in Camp Spring to develop a program to help keep track of construction jobs, inventory and employee activities. Created an accounting program to keep track of their receipts and billing. This was full-cycle development involving creation of a business model, data model, tables, forms, reports, screens, queries etc. Managed project from its conception. Used Crystal Reports.
Created database from scratch according to specs derived from interviewing business owner.
Environment: MS Access 2000, Crystal Reports
Department of Justice, Fairfax, VA January 2000 - May 2000
Access Developer
Created sophisticated program for them to create reports about their personnel records. Used VBA and SQL in an NT environment extensively. Used Access 97. Used Oracle and SQL Server as back end.
Create user-friendly version to replace existing, nonfunctioning database. Environment: MS Access 97, VBA, SQL, Oracle, SQL Server, Windows NT 4.0
Department of Education's RSA department, VA August 1999 - December 1999
Access Developer
Produced several programs in MS Access, Visual Basic and SPSS that interacted with SQL server's tables and queries.
Used VBA code to generate Excel Spreadsheets and HTML documents that displayed complex reports created with Access. Completed FGAS program that meted out federal funding to states.
Did design, data modeling and development. Served as sole programmer for Access part of project.
Environment: MS Access, VBA, Visual Basic, SPSS, HTML, MS Excel, SQL Server US Small Business Administration: July 1998 - July 1999 Office of Inspector General SW, Washington, DC
Senior Systems Designer, Project Manager
* Served as sole project manager, programmer, developer, designer, data modeler and business modeler. Created several programs in Access 97 to automate offices. Created program specifically for their Investigations Division to record and keep track of their cases and investigations. This program recorded and tracked time worked on job for each agent and what cases agents were involved in and all details concerning these cases. It keeps track of all subjects of cases and all of aliases. Collected Records evidence. It has many complex forms that calculate statistics for their reporting needs. Automated MS Word with VBA & was a year long project.135 tables and 125 screens were needed for this project as well as hundreds of queries and code modules. Automated MS Word from MS Access to produce a variety of letters and subpoenas. This involved enabling users to create new form letters in MS Access that would display in MS Word for editing and printing. Interfaced program with LAN so that emails could be sent.
Created a Subpoena tracking system for Investigations Division and Auditor's Division (one for each that works together). Developed another program for Legal Division to keep track of all of correspondence. Then another program for I&E division to make office paperless. Intermeshed all programs to create an environment where each division could do part of a coordinated work. These programs had to function as a single program. Hundreds of agents throughout U.S.A. used their laptop computers to interface with it, obtaining and entering information concerning suspects, evidence, timesheets and a plethora of other information. Managed extensive use of VBA, SQL, data modeling, database design and analysis, creation of forms and tables as required.
Environment: MS Access 97, VBA, MS Word, SQL, LAN
Internal Revenue Service, New Carrolton, MD June 1998 - June 1998
Contract Developer
Helped to develop a system to keep track of all internal documents and projects stemming from them in Access 97 in an NT environment. Created help system for program. Used VBA and SQL extensively as needed. Created help file system using Access Toolkit. Used Active X tools. Used Crystal Reports. Fulfilled requirements of lead programmer to help facilitate program's completion.
Environment: MS Access 97, VBA, Active X, Crystal Reports, SQL, Windows NT 4.0 Hughes Company, Germantown, MD April 1998 - May 1998 Contract Developer, Project Manager
Served as member of a team to help them keep track of repositioning of thousands of satellite dishes. Created front end and several reports in Access 97. Analyzed their data and removed redundant entries.
Used VBA and SQL extensively. This was a small job that took only 38 hours of working hours over a weekend to help them in their emergency. Did data modeling for project as well. Used Crystal Reports.
Created satellite tracking system and build reports. Environment: MS Access 97, VBA, SQL, Crystal Reports
TSI Cable, Gaithersburg, MD January 1998 - March 1998
Contract Developer, Project Manager
Designed, developed and implemented an application to store and invoice TSI's corporate cable-customers in Access 97. This included creating business model and data model. Customer Invoice Tracking System records all customer account information, payments received, current balance and prints detailed bills based upon customer's business category. This complex system adjusts for bill by prorating for unused portion of a month this program required extensive use of VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables.
Used Crystal Reports. Environment: MS Access 97, VBA, SQL

Totality Software, Vienna, VA August 1997 - December 1997
Contract Developer (telecommuting)
Created forms for two commercial projects done in Access 97. Each project took about forty hours to complete. This project required advanced knowledge of coding, making tables, standardizing nomenclature, creating sophisticated user friendly forms that calculated percentages and amounts automatically and transferred results into other forms. Used SQL and VBA extensively. Used Crystal Reports. Created few forms to help them enhance an existing project. Environment: MS Access 97, VBA, SQL, Crystal Reports
Teligent Corporation, Vienna, VA November 1997 - December 1997
Contract Developer
Created over 170 complex reports and front-end interface to access in Access 97.
Performed data analysis to eliminate duplicate and erroneous entries.
Created over a hundred queries using advanced techniques.
Designed and created a front-end process so reports and queries could be easily accessed. This program required extensive use of VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables.
Used VB to create modules for specific tasks. Analyzed data and data model.
Environment: MS Access 97, VBA, SQL, Visual Basic
Boeing Corporation, Falls Church, VA September 1997 - October 1997
Contract Developer, Project Manager
Managed project to create a resume database to handle applicants.
Designed and implemented database system in Access 97 single-handedly. Project required creating a front end that provided access to dozens of different reports and queries. Reports contained many sub-report objects and forms numbered over 50. System provided dynamic query capabilities for users performing ad-hoc queries. Used VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables extensively as required. Used Crystal Reports. Environment: MS Access 97, VBA, SQL, Crystal Reports
Kentucky Education Association, Lexington, KY June 1997 - August 1997
Contract Developer
Created a database in Access 2.0 later manually converted to Access 97. This front-end project kept track of all of their retirees. Placed Filter buttons on form that enabled user to see records according to first letter of last name or district number or another associated number. Program printed out mailing labels and reports based upon information in database. Used VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables extensively as required. Did creation of business model. Managed project. Environment: MS Access 97/2.0, VBA, SQL
Worldwide Church of God, Bowie, MD January 1997 - May 1997
Contract Developer, Project Manager
Designed and implemented a full-featured system for Pastor Garrett in Access 2.0 then manually converted to Access 97. This highly user-friendly program keeps track of all their members and enables church through queries and reports to obtain a large variety of statistics about congregation.
Created over 40 reports and a dozen screens as well as an on-line help-file system. This program required extensive use of VBA, SQL, data modeling, business modeling, systems design and systems analysis, creation of forms and tables. Managed project. Created tables, forms and dozens of interactive reports that used user-input to define report's content. User could survey database to tell him extensive demographic information. Dozens of reports gave statistics on everything minister would have to know. It also recorded family information concerning marital status and names and ages of kids as well as who was in Sunday school. It kept track of telephone calls, baptisms, prayer lists and special needs. It kept track of who was single, who was divorced, who was a deacon and who was an elder. All lists were instantly available. This program is extremely user friendly and used colors and graphics to polish off its appearance. It features a complete custom help system to explain use of every form and button. Used VBA, SQL, data modeling, systems design and systems analysis, creation of forms and tables extensively as required. Later reengineered this product as a distributed Visual Basic program.Environment: MS Access 97/2.0, VBA, SQL, Visual Basic
David Arias Property Management, Beltsville, MD October 1996 - December 1996
Contract Developer, Project ManagerDeveloped and installed a property manager's program to keep track of residents and lease payments in Access 97. This program enabled user to keep track of income and expenses for both single-family dwellings and multi-family units. It calculated profit for buildings over time. Created various reports as well as mailing lists that were based upon user input. Did full cycle including business model and data model. Managed project.
Environment: MS Access 97
John Dobbs Software Development, Lorton, VA August 1996 - September 1996
Programmer
Developed this system in VB with Access as its back end. Developed and implemented an inventory tracking system that kept track of supplies, usage and on-hand quantity in Access 95. This system consisted of eight screens and five reports. It featured a structured inventory usage process that kept an audit trail history of transactions for each inventory item. In addition it contained an end of year physical inventory process that reconciled end of year inventory with quantity on hand.
Developed Names Tracking system, primarily as a convenient method to share names among two or more individuals. This system featured a graphics oriented menu, easy to use buttons that made finding a name easy and provided automatic extract capability to export to MS Word.
Environment: MS Access 95, MS Word, VB
Termipest Inc, Oxon Hill, MD January 1996 - July 1996
Developer, Project Manager
Designed and developed a complete system for own company to keep track of customers, pesticide usage and solicitation. Kept track of all of his customers and everything that they ordered. It keeps track of invoices, pesticides used, employee information, deadlines and more. It features complete help system that is custom made for program. Did total design and development including business and data model. Managed project.
EDUCATION
Degree in Business Administration 1978 Prince Georges Community College, Largo, Extensive self training in MS Access, VBA, SQL, etc.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Oxon Hill, MD | Resumes in Maryland

View other MS Access Developer or Programmer resumes, Programmer / Developer resumes