Don B.

Don B.

Expert Developer VBA/Database 20 yrs.

Des Plaines , United States

Experience: 25 Years

Don

Des Plaines , United States

Expert Developer VBA/Database 20 yrs.

96000 USD / Year

  • Immediate: Available

25 Years

Now you can Instantly Chat with Don!

About Me

I really like to make applications that help Managers and Owners focus on the data and information they really want. Uploading data, Data Cleaning, Reports with clean clear dashboard design.

...

Show More

Portfolio Projects

Description

  • Writing Business Process documents.
  • Requirement gathering with business
  • Data Analysis and intelligence reports.
  • Project Management
  • Six Sigma process improvement for Fed Ex shipping.
  • Writing Technical Specifications for new/change application changes.
  • Troubleshooting day to day issues for the operations teams.
  • Production support for in-house development.

Six week rotation on night shift (5 pm to 10 pm) support

Oracle 10g, Catalyst 8.1, VBA, Access, Visio, Toad, ABAP, IDOC, XML,SQL.

Show More Show Less

Description

Application developer VBA - Access 2007, SQL

Project: Automate PC setup by using SMS oracle backend and employee data.

  • Gather the requirements and document Functional/Technical specifications.
  • Design the application.
  • Write the application.
  • Security to complement network security
  • Generate PC setup instructions for tech.
  • Keep inventory for new and expired PCs.

Show More Show Less

Description

Global project to combine all data into one useable venue.

  • Writing team process and testing guidelines from consensus building.
  • Analyzing data at the field level between multiple legacy systems. DB2, SQL 2005 and Oracle
  • Creating Excel reports on metrics of production and accuracy of data
  • Determining correct data from comparison and interviewing users.
  • Standardizing processes for repeatable results and accuracy.
  • Personally responsible for 95?curacy for data upload.
  • Organize processes for incremental changes in the future.
  • Directed team on approaches to test the Excel spreadsheets for data integrity before uploading data into system.
  • Data integrity testing for upload and reports.

Tools: Oracle, DB2, Access, VBA, SQL Explorer, TOAD, Excel, Load Runner, SQL

Show More Show Less

Description

  • Created Excel reports and worksheets to maintain the login ids from across a Citrix system (many servers) needed to be combined and deliver one login per user for the new Sun Solaris Unix system.
  • Created testing scripts on system for redundancy.
  • Tools: VBA in Excel, VB 6,SQL
  • OS: Sun Solaris, Windows XP, Citrix

Show More Show Less