Senior Ms Access Developer Resume Profile
Washington, DC
Business experience: Operated my own company Termipest Inc. for 20 years. I have the verve of an entrepreneur and understand business firsthand. I get the job done because I am a hard worker.
Capacities: MS Access full cycle development Data modeling Gathering of specifications User manuals Forms, Queries, Reports, SQL, VBA, Testing, Presentations and training.
MS Access Developer
I created several very important databases for them that they needed to run their company. One of them stored data on feedback from their customers. Responsibilities: 1 Technical Writing 2 Database Architecture 3 Data Modeling 4 Programming 5 Testing 6 Documentation 7 Data analysis and reporting Created their financial database.
Senior MS Access Developer
- Performed miscellaneous advancement, repair and maintenance on over 20 different databases using MS Access 2003 and conversion to Access 2007.
- Documented databases for transfer to a later Oracle database. By automating the process I saved North Carolina at least 6 months off this project's length.
- 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. I had to track the efficacy and efficiency of their telephone answerers for the length of time used for each call and how well they did by survey.
- Convergys March 08 to April 08 Financial Institution
- 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.
- 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.
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 and database plan and flow chart, did data analysis.
- Maintained and adjust an Excel spreadsheet.
- 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.
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.
Confidential
- Senior Access Programmer, DBA, Data Analyst 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.
Confidential
Senior Access Programmer, DBA, Data Analyst
- 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. Envolved in making a financial program for a dance studio that track customers, programs, schedules, receipts and expenditures. Did data analysis
Senior Access Programmer, DBA, Data Analyst
- 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.
Confidential
- Senior Access Programmer, DBA, Data Analyst
- Constructed Wits inventory program for Essex Tech Group. This requires creation of an inventory database from scratch using MS Access 2000.
Confidential
Senior Access Programmer, Data Analyst
- 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.