Customer Service Quality Control

DAVID BOCIAN

P.O. Box ****

Plainfield, IL *****

Cell: 815-***-****

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

LinkedIn: http://www.linkedin.com/in/davidbocian

David Bocian brings a powerful set of skills to bear on any IT challenge. His expert-level mastery of the IBM System i (AS400) platform dovetails with a broad knowledge of RPG in all its iterations. Working comfortably on numerous other systems and in many other programming languages, David can move seamlessly across environments. His ability to automate processes stems from his focus on problem solving – leading to cost savings at multiple points within any production chain. A gifted teacher, David is able to translate complex concepts to end users, train other IT professionals, and bring both together as a cohesive working team. BS in Computer Science from Illinois State University.

Career Highlights

* Experience in shipping, receiving, inventory control, quality control, sales, purchasing, payroll, accounts payable, accounts receivable, general ledger, scheduling.

* Expert at using SQL rather than a high-level language for all file functions, including adding / changing / deleting records, changing file and field definitions, etc.

* Self-taught on SQL and RPG embedded-SQL, OPNQRYF, commitment control and journaling, authorization lists, data queues, sockets programming.

TECHNICAL SUMMARY

Languages

SQL, RPG (III, IV, ILE, /free), CLP, LANSA, C++, PERL, COBOL

Software Packages

CIMS, ICS FormSprint, ASC SEQUEL & ViewPoint, Abstract/Probe, Help/Systems Robot, Hawkeye Pathfinder, Microsoft Word & Excel

Experienced at

Subfiles, commands, System i security, authorization lists, IBM Client/Access data transfer, Computer-Telephony Integration (CTI), data queues, journaling and commitment control, sockets programming, Integrated File System (IFS)

Hardware

IBM System i (iSeries; AS400), Windows NT/XP

WORK EXPERIENCE

Midwest Suburban Publishing Tinley Park, IL

(2010 – 2011) Independent Contractor

Hardware: VAX and PCs; Languages: COBOL and PERL

* Successfully supported a UNIX environment despite having no previous experience and limited training.

* Supported existing processes during period of development for new system.

* Reduced user downtime by refining file transfer process, bringing processing time down to 1.5 minutes instead of 60+ minutes, thus making files available sooner.

Kirtley Technology Corp. Darien, IL

(2006 – 2009) Senior Programmer / Analyst

Hardware: System i (AS400); Software package: CIMS; Language: RPG III, CLP, and SQL

* Provided primary on-site support and/or phone support for a variety of client school districts.

* Saved thousands of dollars in bank charges and fees while reducing loss due to fraud by implementing positive pay reconciliation for payroll and A/P.

* Reduced clerical work load by 2.5 hours per week through the elimination of user intervention by automating the printing of a daily attendance report on a PC platform.

Founders Group, Inc. Worth, IL

(2003 – 2006) Senior Programmer / Analyst

Hardware: System i (AS400); Languages: RPG III, RPG IV, RIG ILE, RPG /free, CLP, SQL, and LANSA

* Provided customers 24 hour access to their accounts without increasing staff and related costs by implementing internet banking using sockets programming techniques.

* Improved database security and data integrity using DB2 file constraints and triggers.

Lyons Township High School La Grange, IL

(2002) Independent Consultant

(2001 – 2002) Information Services Coordinator

Hardware: System i (AS400); Software package: CIMS; Languages: RPG III, CLP, and SQL

* Saved $15,000 annually in labor and forms by migrating native AS400 applications to the network as webpages.

* Worked with Chief Information Officer to provide direction for department and district computing needs.

Enesco Group, Inc. Itasca, IL

(1998 – 2001) Project Leader

Hardware: System i (AS400); Languages: RPG III, RPG IV, RPG ILE, CLP, and SQL

* Allowed Customer Service to reduce headcount by approximately 10% with the implementation of Computer-Telephony Integration (CTI).

* Dramatically increased productivity of International Shipping Dept. by creating Customs Invoicing application that allowed for more flexibility in generating the required forms.

* Saved shipping costs, lost product, and customer loyalty all while reducing warehouse headcount via print-and-apply ASN shipping labels.

New Resources Corporation Peoria, IL

(1995 – 1998) Consulting Department Manager

(concurrent) Senior Consultant

Hardware: System i (AS400); Languages: RPG III, CLP, and SQL

* Managed eight employees placed at various locations while also functioning as a billing consultant.

* Interviewed prospective employees.

* Reduced errors during the installation of new software releases by automating the process and giving control to the software vendor.

American Software & Hardware Distributors, Inc. Urbana, IL

(1994 – 1995) Senior Programmer / Analyst

Hardware: System i (AS400); Software package: J.D. Edwards; Languages: RPG III, CLP, and SQL

* Reduced shipping costs through new shipping software.

* Improved order accuracy to over 99% with a comparable increase in inventory control by integrating bar-coding into Quality Control process.

* Expanded customer service to 24 hours by implementing an order processing system that allowed the placing and tracking of orders via PCs (pre-internet).

Daubert Industries, Inc. Westchester, IL

(1990 – 1994) Programmer / Analyst

Hardware: System i (AS400); Software package: HFA; Languages: RPG III, CLP and SQL

* Improved plant operations with a flexible scheduling system.

* Member of multi-department team to improve shipping performance.

* Developed and maintained the rules for MAC-PAC's Expert Configurator (a knowledge-based expert system).

Viskase Corporation Bedford Park, IL

(1988 – 1990) Programmer / Analyst

Hardware: IBM 4341, Wang VS-100, PCs, System i (AS400); Languages: PL/1, COBOL, QuickBASIC, RPG III, and CLP

* Only programmer to work on every platform (mainframe, midrange, PC) and in every language (PL/I, COBOL, QuickBasic, RPG) utilized within the company.

Beltone Electronics Chicago, IL

(1987) Programmer Intern

Hardware: IBM 4341; Language: COBOL

Other Notables

* Trained IT professionals in SQL, Query, ASC SEQUEL, and subfile programming.

* Conceived and developed a process to facilitate the removal of all duplicate objects, test objects, one-shot programs, orphaned files, etc.

* Created a command function to dynamically replace a test environment with current production data, allowing for more accurate testing. This process allowed flexibility and control over the test environment while reducing the potential for mistakes with production data.

Contact this candidate