Summary of Relevant Experience:

• Over fifteen years of experience in the field of applications development using ALL versions of Microsoft Access beginning with Access 1.0; complimented with six years of Visual Basic and over two years experience with both Oracle and Sequel Server.
• Solid background includes analysis, design and testing throughout the development life cycle on a diversity of systems.
• Three years of project management experience on both web and network based applications

Professional Experience:

Confidential (12/2008- current) Programmer Analyst II

Hanover, MD

Assumed the lead role in transitioning the Traffic Engineering and Design Development (TEDD) project database, PMII, from an Access 2007 platform to .NET and Oracle. The PMII system is used to track status and cost analysis information for each Traffic Engineering project throughout the State of Maryland from Design Request (DR) through construction and completion. This transition solved the data sharing restrictions of the previous Access version enabling view, data and eDR (Electronic Design Request) access to all 7 State Highway Administration district offices. Overall costs to the Traffic Engineering Department was reduced by as much as 30% within the first quarter of PMII going online. Main benefits of the system includes enhanced productivity and efficiency in handling projects. Main duties include performing journey level work designing, developing, testing, implementing and maintaining applications systems and programs using third generation or other generally accepted computer-programming languages. Areas of specialty includes: experience with Microsoft Access, ASP.NET, ORACLE, SQL Server, Visual Basic and .NET Technologies. Duties include, but are not limited to:

• Consulting with system users to plan, develop, evaluate and revise applications systems
• Prepare conceptual designs of proposed new or revised applications systems outlining the purpose of the system, software components, hardware requirements
• Prepare cost analysis and alternative solutions
• Code programs using third generation or other generally accepted computer programming languages
• Evaluate and use specialty software to perform utility routines including debugging, editing and sorting functions
• Perform emergency maintenance on applications systems and programs as required
• Supervise contract personnel (Programmer Analysts, Database & System Developers)
• Design and chair presentation meetings for top management, and systems users
• Perform informal testing for new software rollouts.

Confidential (11/2007-9/2008) Business Systems Consultant III

Columbia, MD

This position serves as a resource providing support, leadership, direct involvement and guidance to operations and projects within Wells Fargo Corporate Trust Services division. Role involves being an internal consultant between technology and business groups by using quality tools and process definition/improvement to re-engineer processes for greater efficiencies.

• Act as liaison between the business area and technical organization
• Plan, conduct and direct the analysis of complex business problems to be solved within the Collateral Integration IT Project Team.
• Work with manager and user groups to provide training, resolve questions, assess user needs and recommend changes.
• Prepare specification for business requirements.
• Develop test plan components and test scripts.
• Provide support, leadership and guidance to operations and projects.
• Manage Collateral Integration Projects.
• Write Visual Basic for Application (VBA) algorithms to support database projects.
• Design new and enhance existing Access databases as needed.
• Assist business units with their Access database needs.
• Designed queries connecting via ODBC to Oracle and SQL databases to analyze data and to collect reporting information.
• Reverse engineered Access databases to gain knowledge on functionality of existing systems for network drive migration.
• Reverse engineered Oracle database reports for data review and revision.
• Run batch updates for multiple data on Oracle database system.

Confidential (5/2007-11/2007) Business Systems Consultant

Confidential Columbia, MD

Worked as a consultant within the Structured Products Group within the Corporate Trust Services business of Wells Fargo Bank, N.A. Designed new and enhanced existing Access Databases as requested by the manager.

• Designed queries connecting via ODBC to Oracle and SQL databases to analyze data and to collect reporting information.
• Reverse engineered Access databases to gain knowledge on functionality of existing systems for network drive migration.
• Write Visual Basic for Application (VBA) algorithms to support Access databases

Confidential (2/2007-5/2007) Database Programmer

Confidential Baltimore, MD

Assumed lead design role of the Environmental Systems Database built using Microsoft Access 2000.

• Performed systems and requirements analysis.
• Wrote custom functions and sub routines using Visual Basic for Application (VBA) to enhance system performance and use.
• Enhanced structure and built graphical user interfaces.
• Performed reverse engineering tasks to aid in knowledge transfer of existing system
• Wrote user documents and manuals to include data dictionary.
• Created system documentation in accordance with the SDLC methodology.

Confidential (4/2004-1/2007) Systems Engineer

Confidential NY

Built the Enterprise Management System (EMS) using Microsoft Access XP, Microsoft Visio, and HTML Help Workshop. The Enterprise Management System (EMS) software was built specifically to meet the unique requirements of the Department of Systems Engineering (DSE) at the Army’s West Point Academy. It is a scalable solution (end state will eventually be Oracle) that integrates DSE’s Budget, Personnel, Research and Cadet Information systems into one comprehensive management application. This position required extensive travel, Project Management and the ability to work independently and remotely.

• Designed and developed the Enterprise Management System.
• Performed requirements analysis.
• Designed and developed a configuration management system using Microsoft Visio to track data points, main tables and key relationships to aid DSE’s technical staff in administering the system.
• Performed reverse engineering tasks using Microsoft Visio.
• Created project plan to track all information gathered to include duration, and resource requirements for the EMS using Microsoft Project.
• Performed project management duties to include production control, project deliverables and scheduling using Microsoft Project.
• Assisted in authoring user manuals and system documentation.
• Designed and developed a context sensitive help file system using Microsoft HTML Help Workshop.
• Created a user group and role driven security system to control user access and permissions unique to the Department of Systems Engineering.
• Created extensive VBA algorithms (functions, sub-routines and class modules) to control dynamic system updates, GUI’s and reports.
• Provided project estimates to determine production costs and “time-to-market”.
• Implemented, integrated and tested all developed systems (EMS consists of four separate modules, each meeting the needs of a specific department).
• Provided production support and troubleshooting to enhance system performance.
• Chaired demo meetings and conferences to provide monthly status reports.

Confidential (9/2006-10/2006) Systems Analyst

Confidential,Bethesda, MD

Worked within the Enabling Systems IT unit which provides support skills for modifying and maintaining existing MS Access and Excel Databases (VB-coded) and other systems in order to meet Marriott’s internal Financial Business Units requirements. In addition, Enabling Systems also provides production support including troubleshooting and timely problem resolution.

• Acted as a supporting programmer analyst for systems development life cycle.
• Leveraged learned business process knowledge against technical expertise for appropriate systems solutions.
• Created systems documentation for portfolio of currently-supported applications.
• Provided high-level estimates for enhancement and break/fix work efforts for review by manager and customer.
• Assisted in systems disaster recovery efforts and testing.
• Established and maintained priorities for multiple projects and requests.

Confidential (1/2004-8/2006) Programmer Analyst

Confidential, Baltimore, MD

Involved in several Access 2000 design and development tasks within CitiFinancial\'s regulatory compliance group. The Compliance Organization within CitiFinancial, Inc. operates multiple database applications used to automate numerous processes within the organization, developed using Microsoft Access 2000

• Performed requirements analysis and system design.
• Conducted an extensive reverse engineering effort using Microsoft Visio to aid in knowledge transfer, documentation and rendering systems within the scope of the System Development Life Cycle process.
• Created Visual Basic for Application modules to quantify data for automatic export into preformatted Excel spreadsheet reports.
• Performed routine maintenance of the Jet Database Engine to maintain and improve database performance.
• Created a back up and recovery system tailored to CitiFinancial’s Continuation Of Business (COB Plan).
• Managed the “Quality Control Helpdesk”.

Confidential (9/2003-1/2004) Programmer Analyst

Confidential, McLean, VA

Assumed lead design role of the Resource Allocation Management System built using Microsoft Access 2000.

• Performed systems and requirements analysis.
• Wrote custom functions and sub routines using Visual Basic for Application to enhance system performance and use.
• Met with various user and tech groups to identify possible data overlaps or links to existing resources to enhance dynamic reporting.

Confidential (9/2000-9/2003) Systems Engineer

Confidential, Washington, DC

Assumed lead design role on several ongoing Access 97, Access 2000 and Access XP database development projects, including systems housed at government agencies such as ATF, DEA and Health & Human Services.

• Development of custom user menus and technical design preparation for transitioning these systems for replication and deployment in a runtime environment using Office Developer Edition tools (ODE).
• Retrieved and normalized data from numerous sources for migration.
• Created customized setup programs for developed applications deployment.
• Created service pack programs using VB/VBA, VBScript and ASP to update existing systems currently in place.
• Created Visual Basic executables to update and enhance deployed applications.
• Produced technical instructions and system requirements documents for developed applications.
• Built a comprehensive Management Information System for an international law firm to house and disperse information regarding FCC licenses for the varying transmission towers (radio, TV, Cellular, and Aux etc.), call signs and parent companies.

Confidential (10/1996-9/2000) Programmer Analyst

Confidential. Washington, DC

Supported the US Customs Service project in Washington, DC on several Microsoft Access 2.0/97 database and Visual Basic development tasks.

• Performed identification, analysis, migration, and redevelopment of mainframe databases and applications from a UNIX and Informix platform to Novell and Windows NT Local Area Networks.
• Developed Graphic User Interfaces (GUI’s) to enhance usability of migrated data, and trained users.
• Created customized setup programs for rapid applications deployment.
• Used Visual Basic for GUI development on established Access databases.
• Received letter of commendation award for technical support from the Assistant Commissioner-Office of Investigations, US Customs.

Education:
Applied Information Technology
Arts & Sciences, A.A.S.
Computer Information Technology

Primary Functional Areas:
Systems Analysis & Design
Applications Development

Languages:
Visual Basic/Visual Basic for Apps (VBA), Access Basic, BASIC, C, C++, HTML, MS SQL, SQL, Pascal

Additional Training:
XML Training, Keystone Learning Systems (CBT), Washington DC, 2001
Oracle 7 Database Administration, US Customs HQ (CBT), Washington DC, 1999
Windows NT 4 Optimization, US Customs HQ (CBT), Washington DC, 1998
Basic Aircraft Technology, Continental Data Graphics, Culver City, California, 1986
Life Support Technician, US Air Force, Chanute AFB., Illinois, 1984