Client-focused MS-Access Database Developer
with experience designing and maintaining customized data management
solutions.
SUMMARY OF QUALIFICATIONS:
BIRTHPLACE: Washington, D.C. USA
TECHNICAL SKILLS:
LANGUAGES: VB 6.0, VBA, ActiveX/ADO, ASP 3.0, HTML, VAX COBOL/DCL
PLATFORMS: Windows 2000/NT/98, IIS 5.0/DEC VAX Mini-Mainframe
OTHER: Crystal Reports, Windows API, Visual Source Safe, DOS Batch scripts
DOD SECRET CLEARANCE, 2002
– present
PROFESSIONAL EXPERIENCE:
KNOWLOGY CONSULTING, MS-Access Developer, Falls Church, VA. 2/2008 - present PART-TIME
Develop and implement various databases and software programs using
MS-Access and Visual Basic. SQL, reports
creation/editing, forms design, code-behind forms using VBA, macros.
BLACKSTONE TECHNOLOGIES, Software Systems Engineer, Reston, VA. 7/2007 – 12/2007
CLIENT: Office Of the Comptroller of the Currency, Washington DC.
Implemented Independent Verification & Validation SDLC Estimation and Scope tool using Microsoft Excel. Designed, tested and debugged “proof-of-concept” and enhanced application using Excel VBA add-in and template. Made use of complex VLOOKUP formulas, conditional formatting, VBA functions, classes and cell true/false logic.
ENVIRONMENT: Win2000 Pro, Excel 2000,
Sharepoint
E. R. WILLIAMS, INC., Falls Church, VA - Systems Analyst - 12/2006 – 3/2007
Responsible for modification and maintenance of contracts management database using Access front-end, SQL/Server back-end. Creation and modification of SQL views and stored procedures that drive Access objects and modules. Visual Source Safe to track versions of database. VBA coding of functions and procedures for various reports, forms, modules including use of ADO connections to remote back-end. Daily SQL-to-Excel Reports. Responsible for tracking new release info and advising users in problem-solving the database.
ENVIRONMENT: Microsoft Office 2000,
SQL Server 7, WinXP Pro, Visual Source Safe, some VB.NET.
THE COMPUTER MERCHANT LTD, 95 Longwater Circle, Norwell, MA 8/2006 - 11/2006
CLIENT: COMPUTER SCIENCES CORP, 9110 Fairview Pkwy, Falls Church, VA.
Database creation/maintenance using MS-Access 2003. SQL writing, reports editing, Excel/Access VBA programming and macros on a variety of databases for the CSC Federal Reporting Division. Determine user requirements, perform maintenance/enhancements for financial databases including bug fixes, custom reports, identifying problems. Responsible for backup/restore/security of databases. User training through PowerPoint slides. Applied Windows User Security to databases.
Accomplishments:
• Created Unbilled Revenue Collections
database, with user tracking, search criteria ability,
record edit tracking ability for managers.
COMSYS, 9737 Washington Blvd. Gaithersburg, MD.20878 5/2006 - 8/2006
Client: Northrop Grumman, Hoffman Bldg 2, Alexandria, VA. – DOD INTERIM CLEARANCE.
Database creation/maintenance using MS-Access 2003. SQL writing, reports editing, Word merges, Excel VBA macro scripts/programming, extensive Access VBA coding on a variety of databases for the Army Human Resources Center. Perform diagnostic and preventive maintenance for variety of user databases, bug fixes, enhancements, custom reports, identifying problems and devising solutions. ADO database connectivity for some databases.
Accomplishments:
• creation of TDY event-tracking Access db for Deputy Chief of Staff of Ops
• refining seamless Word merges from Access databases
• tightening up code and script events, improve GUI screens/functionality
• addition of ad-hoc search (by field) and edit capability to dbs
ENVIRONMENT: Microsoft Office 2003, MS-Access
2003, Win 2000
INNOVATIVE SYSTEMS GROUP, 100 E. Sybelia Ave, Chicago, IL. - 12/2005 – 5/2006
MS-ACCESS DEVELOPER/CONSULTANT
Client: Lockheed/Martin, Bethesda MD. - Lockheed/Martin clearance granted.
Database reports creation/development/migration
using Oracle, Crystal Reports 9, MS- Access 2003. SQL writing,
reports editing, light VBA code.
NRI STAFFING, 10780 Parkridge Blvd. Reston, VA - 8/2005 – 12/2005
IT DEVELOPER
Client: DC Quality Trust for Disabled Persons, Washington, DC
Design, develop, test and implement SQL Server back-end, intranet front-end survey database for monitoring and tracking of mentally disabled persons.
Environment: WIN/NT, SQL Server, VBA,
ASP, Javascript, HTML
SYTEL/TECH-TEAM GLOBAL, 6430 Rockledge Dr. Rockville, MD - 08/2004 - 6/2005
MS-ACCESS SENIOR PROGRAMMER/ANALYST/DBA
Client: FAA AIO-10, Washington, DC
Modify and maintain existing Financial Management System for AIO offices using MS-Access. Enhance existing forms, screens, macros, reports, queries and source code from user specifications. Responsible for all database systems maintenance and backup and user support on a daily basis. ADO connectivity used for recordset updates.
Strengthened existing Access FACTS system source code, forms, reports and queries with error-trapping, additional queries, report logic and heightened security on client/server.
Created AIO-10 equipment inventory database in Access
• Modified and maintained Work-Based-Schedule in FACTS reports
• Created live scoreboard calculators showing present budget obligations, commitments, monthly reports
Environment: Win2000 Professional, MS-Access,
SQL, PowerPoint, VBA
ASPEN SYSTEMS, 2277 Rockledge Dr. Rockville, MD - 07/2000 - 03/2004
ACCESS/VB DEVELOPER/SYSTEMS ANALYST III (FULL TIME CONSULTANT) -
2 years 9 months
CLIENT: DEPARTMENT OF JUSTICE, ANTITRUST DIVISION, Washington, D.C.
Supplied custom, high-quality data management solutions and support for
Litigation Unit Case Managers using MS Access 2000,
DAO connectivity, VB 6.0, SQL and Windows 2000 in a client/server environment.
• Analyze requests and develop browser-based solutions (IIS, ASP) for internal operations.
• Provide logical database design, VB 6.0 and HTML front-ends, reports, macros, extensive SQL queries,
query/report wizards, and source code. Built Access 2000 back-end database tables.
• Provided day-to-day user support for existing and new applications.
KEY ACCOMPLISHMENTS:
• Contributed to improved litigation support operations/management by constructing successful Access ADO-automated expense tracking and trial budgeting database applications.
Environment: MS Access 2000, ADO, DAO, VB 6.0, SQL, HTML, ASP 3.0, IIS 5.0, Win 2000
EATON & CO., Alexandria, VA; - 6 Months
HIREKNOWLEDGE/MACSPECIALISTS, Washington, D.C.; 1 year 5 months
Created and maintained customized database solutions using
Access/VBA, SQL, Crystal Reports 8.0 and Excel. Constructed
database tables, wrote queries, macros and source code and
designed front-end screens. Provided dependable Helpdesk support.
KEY ACCOMPLISHMENTS:
• Significantly improved existing database usability by
resolving design and source code inconsistencies.
• Provided day-to-day user support
FEDERATION OF AMERICAN SOCIETIES FOR EXPERIMENTAL BIOLOGY (FASEB), 02/1997 – 12/1997 Rockville, MD; 11 months
DATABASE PRODUCTION COORDINATOR
Devised cost-effective custom database solutions in client/server and browser-based environments.
• Fulfilled custom mailing list and other ad hoc requests and user support.
• Modified Informix SQL programs for in-house mailing lists and directories.
• Resolved user issues with MS Office. Created user documentation in HTML.
KEY ACCOMPLISHMENTS:
• Engineered custom Access/VBA/Excel applications,
spreadsheet macros, DOS batch scripts and other automated
solutions to enhance information access, processing speed and MS Office functionality.
Environment: MS Access, Excel, SQL, VBA,
Crystal Reports, HTML
GRASSROOTS SYSTEMS INC., Washington, D.C.; 12/1995 - 06/1996
DEVELOPER/TECH SUPPORT/POLITICAL CAMPAIGN SOFTWARE; 6 months
Supported campaign tracking applications for new and existing Congressional and lobbyist clientele. Developed custom reports, screens and database tables as well as code modules and patches.
KEY ACCOMPLISHMENT:
• Enhanced product and expanded client base, by identifying/resolving client problems and translating client needs into innovative features.
• Converted core software deliverables from DOS GUI to WIndows GUI
using Visual Basic 5 Professional for WIndows.
Environment: FoxPro 5.0, DOS
BRAINBENCH.COM CERTIFICATION – MS-ACCESS 2003 FUNDAMENTALS - 11/4/2005 -- Transcript ID#: 5056239
FCC, THE WASHINGTON TIMES, REPUBLICAN NATIONAL COMMITTEE
• Designed, developed and implemented VAX COBOL-based applications that included screens, reports and search capabilities on selected criteria.
• MCSD Training/Exam Prep - VB 6.0/SQL Server 6.5/Windows Architecture (1999)
• Access 7.0 for Win 95 Certificate (1997)
Montgomery College, Takoma Park, MD
Business Information Sciences Program,
1994 – 1996
Strayer College, Wash. D.C. – Summer 2002
Intro to Oracle PL/SQL
Intro to C++