We provide IT Staff Augmentation Services!

Data Analyst Resume Profile

  • Please accept this application for an expert in MS Access. With nearly 20 years of solid experience, I have created extreme programs for major international companies and government institutions. I have never, ever left a job before it was finished. Stability is my hallmark, especially with government jobs which need this assurance. I emphasize saving you money because I usually do the work of 7 professions by myself.
  • Areas of Expertise:
  • Full cycle development in MS Access. Design, data modeling, forms, reports, queries, VBA, Sql, Testing, gathering of specs, presentation of program. I am a professional quality speaker and accomplished writer. Excel.

Confidential

MS Access Developer

Did the following: 1 Technical Writing 2 Database Architecture 3 Data Modeling 4 Programming 5 Testing 6 Documentation 7 Data analysis and reporting Created their financial database.

Confidential

Worked full time to create their financial database with MS Access. I automated MS Word and Winzip to send letters to patients, facilities and others as well as scheduling examinations, recording medical files into bmp images, etc.

Confidential

  • Dept of Commerce, Ronald Reagan Building Washington DC
  • MS Access developer: Created miscellaneous MS Access programs as needed.

Confidential

Created complex MS Access program in MS Access 2003 to reverse engineer a web program for the FBI. The program required advanced MS Access, VBA and programming skills to convert what was on an SQL server to MS Access. I was responsible for reading the server's sql and examine the forms to put into the MS Access program.

Confidential

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.

Confidential

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.

Confidential

  • 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.

Confidential

  • 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

Confidential

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.

Hire Now