Visual Basic Information Technology

Glenn P. Bowlsby

**** *** **** ****** **

Moultrie GA 31768

Cell: 971-***-****

E-mail: *****.*******@*****.***

CAREER SUMMARY

** ***** ** ********* ********* analysis at the Washington Department of Enterprise Services in the Print & Imaging Division.

Point of contact and subject matter expert in the department on technical issues; always looking to create and improve performance metrics to determine new processes and follow through with testing, training and implementation to ensure success.

Estimating project and task completion accurately by defining activities with customer input, estimating resources and durations, developing schedules and automating tasks.

CAREER EXPERIENCE

Ricoh, Assigned to Oregon State Printing and Distribution–Salem, OR

Customer Liaison MS Operations Jul 2014 to Current

First developed a Visual Basic Applications that can automate any job that has a schema.ini, and template folder without having to change the Visual Basic program.

Second I developed a Visual Basic program to split an access file into multiple parts, and copies the parts to the Watch Server reducing the load.

Third created a text file splitter with a GUI interface to show the difference of Perl script requiring an interpreter installed and launching from command line, versus a GUI that can be clicked on.

Fourth created a reprinter program that can send files to watch by listing individual records, or a group of records.

I have made changes to several jobs to show managers a new way of thinking, and collaborating with others on new processes.

Created a solution where customer can have complete control of the Planet Press Design software, and Oregon Publishing & Distribution controls the watch servers and printing. It was a huge success for the agency that tested it, and working with the executive managers to move forward. This project has state wide potential to allow customers to control their documents.

Showed customer how the custom data selection can be used with their current mainframe output so customer would not have to change their internal data processing.

Created a program that does not require user intervention to process data for an Invoice job.

Provides proof of concepts for various internal task to align all users into a unified work flow.

Washington State Department of Enterprise Services, Print & Imaging Division–Tumwater, WA

Information Applications Specialist 2/ DBA Manager Jul 2000 to May 2014

Operations Analysis/ Management and Training:

Investigate “spoiled jobs” requiring analysis of what went wrong and recommending changes to processes and implementing new processes, as a result there was a reduction of 66% in processing time on seventeen different jobs helping customers reduce their cost, while increasing work flow by automating jobs.

Collect various customers, co-workers, and management feedback to create reports on the performance of department operations developing metrics to determine if course correction is needed. Work with the bindery, copy center, data center, CSR’s, managers and customers to ensure we are efficient in every aspect of the jobs, and the flow. Provided training materials and before implementing final changes, work with all employees to test new processes.

During changes at USPS, gathered information needed, responsible for testing alternative software solutions and evaluating if software solutions met data processing needs and presented roadmaps to management on how to implement changes.

After gathering all information from the USPS, and vendors, create training documents, and then in the preparation of the mail process and the upcoming changes trained new employees on Postal Regulations and Processing standards.

Created graphs showing how many jobs are in process, per day, week, and month including an average number of records per job as well.

Interviewed candidates for new positions at Department of Printing.

Maintain inventory of printer and mailing supplies.

Technical Responsibilities:

Created a database called Status which has a PIFM (Production Information from Mailing) report. Illustrates where a job was in the mailing/variable department. Including information: if we were waiting for pieces, customers’ approval, proofs, or data for any given job used in the daily production meeting.

Importing customers’ files into templates in Microsoft Access and SQL Databases for processing through address cleansing and Presort software using Business Objects programs and in house written programs to automate Business Objects Software.

Installing updates for Microsoft and Business Objects Software.

Created automatic forms that require little human editing.

Wrote Visual Basic Program to automate repeating jobs.

Performing monthly backups using tapes, CD/DVD, and floppies.

Helping troubleshoot computers in Mailing/Variable departments

Used Windows 3.1 through Windows 10 and various Windows Servers.

Used open source software when applicable Such as DosBox due to an incompatible program used in Windows XP, but wouldn’t work in Windows 7 64. DosBox was used until another solution was available.

Hotel Software Systems – Portland, OR Jan 1999 to Jan 2000

Information Technology System Specialist

Installed multiple computers and terminals at Hotels across the United States.

Installed and configured call accounting systems using Caldera Linux in Dbase.

Setup and configured Credit Card transaction through Hotel Software System program

Trained all hotel staff including managers and night auditors on new systems and changes.

Trained new Hotel Software Systems employees on installation of computers and software

Performed Routine backups of Hotel Data before transferring to new computer.

Transferred data from old computers using null modems to new system.

Apex Mailing Service – Tumwater, WA Aug Aug 1997 to Jan 1999

Information Technology Technician

Process multiple jobs using PostalSoft software.

Imported and maintained customers’ databases.

Created scripts with Alpha 4 Database program to automate tasks.

EDUCATION

Bates Technical College – Tacoma, WA, Sept 1994 Jun 1996

59 Semester Hours focused on Computer report programming.

The nineteenth month course in computer programming at Bates Technical College used both Desktop and Mainframes compilers, the compilers used during the course were, RPG, AS/400, Mainframe and Desktop Cobol, Microsoft C, JCL, and Power Builder.

Certifications:

Washington State Certified in Microsoft Access Level 3 June 2010

TECHNICAL SKILLS SUMMARY

Industries: Printing, Mailing, and worked as a tester at Intel DuPont Washington.

Applications: MS Visio, MS Office, Open Office, Star Office, Evolution, Entourage, Final Cut Pro, Ulead Video Studio, Pinnacle Video Studio, Print Shop Mail 98, Planet Press version 3-7, Planet Press Connect, Planet Press Watch, Planet Press Workflow, Adobe Acrobat Professional, Business Objects ACE, Merge/Purge, Presort, Label Studio, Data Junction, and Name Chop

Languages: Visual Basic 6, .Net and Express Version, SQL, Learning Perl

Databases: Alpha 4, Access 9x/2000, XP, 2007, 2010, 2013, Microsoft SQL 2000

Operating Systems: Windows 9X/NT/2000/XP/2K3, Vista, Windows 7, Windows 8, Windows 10, Mac OS Panther, Tiger, Leopard, Various Linux Operating Systems.

SKILLS MATRIX

Bates Technical College – Tacoma, WA, Sept 1994 Jun 1996

59 Semester Hours focused on Computer report programming.

The nineteenth month course in computer programming at Bates Technical College used both Desktop and Mainframes compilers, the compilers used during the course were, RPG, AS/400, Mainframe and Desktop Cobol, Microsoft C, JCL, and Power Builder.

Certifications:

Washington State Certified in Microsoft Access Level 3 June 2010

Spending seventeen and a half years in the printing and mailing industry Working for the State and Private sector, I gained the knowledge and experience needed to lead teams and work on projects myself.

Employed with Ricoh assigned to Oregon State Department of Administration, Publishing and Distribution, I have developed and deployed an Automation process for their jobs where a user enters information in a GUI (Graphical User Interface), to process jobs from data import through the Watch Server. This program can handle batch processing, so user can enter multiple jobs and let Visual Basic handle all the processing. Visual Basic program will also email the customer the proof file, if user selected to do so.

Working for Department of Printing before it merge into Department of Enterprise Services, Printing and Imaging, I have for the last fourteen years improved processes for the Printing and Distribution of various documents, newsletters, fliers, brochures, postcards, statements and other print required by our customers. Created various programs to help reduce mistakes with job processing.

I also worked for Apex Mailing services for one and a half years doing much of the same work as with Dept. of Enterprise Service.

.

Having used Microsoft products since Office 95, the last 19 years I used all versions of Microsoft Office and Windows including Office 2016 and Windows 10. Having written VBA (Visual Basic Application) In Microsoft Access to improve data processing which has been converted from Access 95 through Office 2016.

Learning Visio 2013 to map out data processing, so find a better flow from customer to end product.

Started to train in Active Perl and how Visual Basic and Perl can work together to automate jobs further.

I documented the job flow in my area, and created desk manuals for repeating jobs, so that anyone new or old would be able to perform the job duties as needed.

Working with the Olympia BMEU in Tumwater Washington from my Apex Mailing days and also Department of Enterprise Services to provide information and training to co-workers and managers.

Configuring with our programmers help, the IMB (Intelligent Mail Barcode) process to create a unique serial for each of the database our customer sends. The program also allows us to add different mailer ID’s if need be, which helped us pass the full service requirements.

Setting the NCOA Software on the servers provided by our IT department.

Contact this candidate