We provide IT Staff Augmentation Services!

Sql Consultant Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • Microsoft Access Database / VBA / SQL Developer experienced in Financial, Operations, logistics, MRP systems, supply chain design and implementation

TECHNICAL SKILLS:

  • MySQL, Office 365
  • Access Database development, 1998, 2000, 2003, 2007, 2010, 2013, 2016 Access
  • Visual Basic for Access Database development
  • HTML/FrontPage for web page development, 1996 / 2002
  • Office - Word, Excel, Visual Basic, PowerPoint, Microsoft Project.

PROFESSIONAL EXPERIENCE:

SQL Consultant

Confidential

Responsibilities:

  • Repaired and maintained 6 “Mission Critical” Microsoft Access databased linked to over 90 tables in SQL server databases in the Finance organization of an international Consumer product manufacturing company
  • Microsoft Access / VBA Consultant - Developed a Training Tracking database for a large Pharmaceutical manufacturing company.
  • Microsoft Access /VBA Consultant - Developed a SAGE 300 SQL linked Invoicing system for a U.S. Navy subcontractor
  • Developed a Project / Budget Tracking Database for a construction company
SQL Consultant

Confidential

Responsibilities:

  • Developed an algorithm for dramatically improving ability of LED manufacturing process to hit the desired color target. The Patent application is completed. Established a complete and effective supply chain and associated software (Tensoft Fabless Semiconductor Manufacturing / Great plains).
  • Improved a legacy MS Access system to include links to Tensoft and Great Plains financial information.
SQL Consultant

Confidential

Responsibilities:

  • Developed a Quality system using Flow charts on VISIO and an Access Database as well as a custom Excel VBA program that calculates FIT rates.
SQL Consultant

Confidential

Responsibilities:

  • Created an Access database to track and report customer visits and action items to be shared by the team.
  • Created an Excel / Access structure to allow the sales team to develop forecasts and send them in to headquarters for easy integration into the Access Database.
  • Developed an Access Database that used the forecast, backlog, shipping and other data to give management a “Dashboard” look at the state of the company.
  • Developed database systems using Microsoft Access capable of Downloading data from vendors
  • Order entry
  • Order processing
  • RMA response
  • Purchasing PR to PO
  • Incoming material tracking
  • Report generation (Bookings, Billings, Sales, Distributor sales, order acknowledgement, Invoices, packing sheets, and others), forecast entry and tracking
  • PCNS, export of reports to Sales Reps and Sales Managers, Yield reports to engieeers, …

We'd love your feedback!