|
WCG Systems, inc. (ID: 792702)
|
|
|
Programming & Databases
|
|
Earnings (Year):
$0
|
|
|
|
|
Summary
|
| Member Since: |
November 12, 2005 | 0 quotes in last 30 days
| Last Signed in: October 14, 2008
|
| Location: |
Dallas, Georgia | United States |
| Would work on site: |
Yes |
| Earnings (All Time): |
$0 |
Earnings by Skill (Year): |
| Programming & Databases |
$0 |
| Database Administration |
$0 |
| Database Design |
$0 |
| Embedded Development |
$0 |
| Programming |
$0 |
| Smart Phone Applications |
$0 |
|
Feedback |
| Rate: |
Min. Rate: $15.00 | Min. Budget: $0.00 |
Work Terms |
| Industries: |
Education, Health Care, Professional Services, Technology & Internet, Utilities |
|
|
Highlights
|
|
Automated flat-file import to MS-Access with VBA-created Excel graphs:
This application graphically trends process parameters from worldwide locations for the purpose of detecting potential process-critical degradation over time. Written in MS-Access version 2003 and VBA 6 for the front-end with a Windows 2003 Server networked backend, the application is a relational database that automates the import of records by querying flat files from various ODBC data sources, eliminating redundant data, analyzing and updating key fields and creating Excel graphs on-the-fly via VBA. The application reduces more than 8 hours of manual data retrieval and manipulation to less than 5 minutes and can be recalled without modification at any time. Trending is per parameter per location over time and detailed instructions for use as well as proof of unit testing were provided.
ISO-compliant MS-Access label system:
This application provides full in-house label service to a world-class medical device manufacturer and includes ISO-compliance, multi-color graphics, barcoding, error-free user input, transaction audit trails and version control. Recently converted to MS-Access 2000 from Access 97 OSR-2, this application uses extensive VBA coding and numerous SQL structures to provide a multi-user, multi-station front-end with a shared backend over a 100Mbps Windows 2003 Server network. User input is implemented via barcodes read from work order documentation allowing for error-free lookup of data from SAP via ODBC. The application also produces label drawings with signatures and has separate development, released and archived label system control depending upon department login. It also redirects print jobs on-the-fly to networked label printers depending upon label stock by modifying a reports prtDevNames and prtDevMode properties. Usage of barcode symbologies 39 and 128 subsets B and C meet the HIBCC standard including check characters. Product recalls due to errant labels were reduced to 0% with this application. All code is documented and is written using the Reddick naming convention and an SRS, SDD and VV&T were provided for each revision.
Automated background translation of Outlook to MS-Access:
This application replaces the manual operation of printing, reading and re-entering incoming delivery requests as e-mails in Outlook into MS-Access and placing the printed e-mails on a physical desk next to a drivers name for the purpose of assigning a request to a driver for a small-size Atlanta delivery company. Written in VBA 6 and MS-Access 2003 with a front and backend, this application poles an Outlook inbox and tests incoming e-mails for specific criteria and if met appends the parsed e-mail into an automated relational database to track all delivery requests. Appends are completed periodically in the background at which time a visual representation for each request is displayed on the virtual desktop as an MS-Access form which can be dragged and dropped via mouse over another form representing a specific driver. The database then treats the dropped form as an assignment. This closely replicates the manual method. Each form is a template and uses VBA event code referencing its Windows handle. This application eliminated one position from the dispatch office.
Applicable Embedded work:
Automated hydraulic, pneumatic, mechanical and electronic product test equipment by programming C code; Programmed servo-hydraulic controllers using PID and scripting language for use in failure analysis; Automated the processing of data by programming inline software interrupts in x86 Assembly within C code to control test equipment as well as read, record, process, post and print RS-232/RS-422/RS-485 data; Implemented FIFO and LIFO memory usage; Benchmarked all applications; Authored instructions and software validations for audits; Programmed in 65XX Assembly to draw fast wire-frame graphics; Programmed PIC18F84 and other microcontrollers in conjunction with non-volatile RAM and 3x4 keypad for the generation of a visible disk directory to 2x16 dot matrix LCD display; Programmed 3-axis platform for deposition control by using stepping motors and controllers;
|
|
Skills
|
| Years of Experience: |
No information provided |
| Highest degree: |
Master's Degree |
| Software Skills: |
No information provided |
| Additional Skills: |
DAO
ADO
Excel
LabVIEW
AutoLISP
Pascal
Basic
DOS
GUI Design
Data Recovery
Reverse Engineering
PocketPC
Assembly: 8, 16 and 32 bit including M68HC11, x86, 68000, PIC, 6502/10
Embedded Linux
UNIX
Java
Java Servlets
Java Applets
Java Beans
JavaScript
JDBC |
| Tested Skills: |
 |
| The Freelancer has not taken any Skill Tests. |
|
|
Work Terms
|
|
No information provided
|
|
|
| |
|
|
|
|
|
<
|
The Freelancer has not uploaded images.
|
>
|
|
|
|
My Account URL
|
|
Contact this Freelancer Now!
The Freelancer has opted to hide his/her contact information.
|
|
Instant Messenger
|
|
The Freelancer has not entered IM information.
|
|
Global Region
|
| Country: |
|
United States |
| GMT: |
|
|
| Local Time: |
|
|
|
|
|
|
|
| Profile |
|
|
|
