I am a certified software developer with extensive skills and over 20 years experience in database development and a broad range of computer applications. I have very strong analytical and problem-solving skills I am meticulous, organized, collaborative, an outstanding trainer, and work well with all levels of users. I have been recognized by past employers and clients for excellence in both performance and character.
RelevantSkills:
Able to communicate with clients on all levels of the development cycle
Strong experience programming with MS ACCESS VBA
Create application and data reports as necessary to support internal or client requests
Train /instruct users on software applications
Developing complex solutions in VBA
Writing, coding, testing portable VBA code modules in MS ACCESS
Strong analytical skills
Create ad hoc customized desktop systems for handling the creation and manipulation of data
Enhance and test new applications
Convert external data to MS ACCESS
Connect to SQL server with MS ACCESS using ADO or ODBC
Complete lifecycle of software development from concept to delivery
Work History:
Software Consultant--
Confidential
Projects have included:
design, modify, and program MS Access Database using queries, macros, forms,
import, extract data from text files using VBA, and then importing the data into SQL server.
build custom functions, queries, forms, and reports using VBA
data analysis by creating pivot charts and tables.
import/export data to EXCEL spreadsheets from MS ACCESS
create complex dynamic queries using VBA
create reports for management by exporting the data to MS EXCEL
extrapolate data from text files into SQL server using MS ACCESS VBA
define what needs to be done in order to meet the business requirements.
gather detailed information about the business requirements for the project
improve functionality of existing databases using VBA
redesigned a new program into MS Access 2010, from a previous program that was written in Paradox. This saved the client an average of 98,000 a year
Confidential
Software Consultant /Owner
Projects have included:
Converted a manufacturing system in that existed in EXCEL to an ACCESS database.
There was a greater increase in efficiency in retrieving the information.
Generation of timely reports that reflected all stages of material accounting.
Better control of the entire manufacturing process
Converted pay scale from EXCEL to ACCESS.
Information was sorted and cataloged and then exported back to EXCEL.
Compared top-executive salaries to like positions in other companies.
There was a great savings of time for the HR department.
Allowed sales personal to track information about each student and what classes they took.
Generated mass-mailings to each student.
Allowed the tracking and generation of new classes.
Generated thousands of dollars in income for the company.
MS ACCESS VBA Application Specialist
Confidential
Projects have included:
Writing, coding, testing portable VBA code modules in ACCESS
Record set creation via dynamic queries in VBA code
Imported Text files into a SQL database using VB.Net
Ability to import and manipulate data via complex queries, using ODBC connections
Updated existing ACCESS database systems.
Interfaced with SQL server.
Imported EXCEL spreadsheets into ACCESS and created related tables.
Developed tools that enabled the manager to manage the finances in a timely manner.
Documentation of database design and implementation
Privacy Policy
