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
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.
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.
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, …