ectSenior Software Developer/Architect

Joe Mellem is a veteran software consultant with extensive experience in

Automation, Networking, Data Communication, RDBMS Data Modeling and SQL. He

possesses an extraordinary expertise in the Q/A, design and implementation

of Business, Real-Time and Process Control computer systems. He has

exceptional proficiency in PowerBuilder, C/C++, SQL, PL/SQL, Embedded

SQL/C, Pro*C/C++, MS Access and Basic, FORTRAN and Korn-shell scripts.

Mr. Mellem is a consultant accustomed to working on multiple projects

simultaneously with tight deadlines. He was instrumental as a platform

expert in solving a critical software problem for GM Truck & Bus assembly

in Ft. Wayne, Indiana, allowing the plant to launch on schedule.

He played a key role in creating the K-Mart Partners Information Network,

an online access system for vendors to query their product inventories and

sales in real-time, providing critical market feedback.

Mr. Mellem had a primary role in creating a networked Vehicle Emission

Testing System for certifying compliance with EPA and CARB clean air

standards that was crucial for DaimlerChrysler to meet production

schedules. He designed and implemented an RDBMS in Sybase with their

PowerDesigner tool and programmed the client/server client in PowerBuilder

and utilized HP-UX with Embedded SQL/C to implement the server components.

Joe redesigned software algorithms at Motorola that achieved 300% increase

in production volume and quality in the manufacture of their Temperature

Compensated Crystal Oscillators used in mobile radios and cellular

telephones.

Joe also developed a network based Engine Calibration System for General

Motors which was used at the Buick Engineering Center in Flint, MI and at

the Chevrolet Engineering Laboratory at the Milford Proving Grounds in

Milford, MI, allowing the engineers in the Power Train departments to

achieve a 10-fold increase in engine calibration development productivity.

Mr. Mellem is a professional IT consultant with strong design and

development skills, high-pressure work environment experience and a list of

successful projects. He is a visionary; an innovative, abstract thinker

with the ability to conceptualize complex problems and synthesize them into

small, simple tasks and deliver results.

CONTACT INFORMATION

Joe Mellem

1925 Argentine Road

Howell, MI 48843

415-***-**** GV

248-***-**** Mobile

**@*********.***

TECHNICAL SKILLS

Programming Languages

PowerBuilder(5.0 - 12.5.2) w/ PFC and custom frameworks

Visual C++, C#, Pro*C/C++,

Visual BASIC, BASIC

FORTRAN IV/77, Pascal, Assembler Languages

OCX/ActiveX, OLE, DDE Integration

Relational Databases and Utilities

Sybase SQL Server (ASE and ASA)

Sybase Data Architect, PowerDesigner

Oracle PL/SQL and Pro*C - 8i/9i/10g/11g,

SQL Server 2000, Access 95/2000

IBM's DB2, Informix,

H-P Image/Query, Allbase

Embarcadero's Rapid SQL and DBArtisan

Quest Software's TOAD

Embedded SQL/C

O. S. and Utilities

Microsoft Windows 7/XP/Server NT/2000/2003

Microsoft Office 95 to 2013

Visual Studio .Net/2003/2008/2010/2013

UNIX, Korn-Shell, C-Shell

Crystal Reports, Infomaker

Source Control and Versioning

MS Team Foundation Server 2012

Borland StarTeam

Microsoft Visual Source Safe

Merant PVCS

PowerBuilder Native

Subversion

Remote Control

Citrix Presentation Server

Microsoft Terminal Services

Remote Desktop Protocol

Communication and Control

Network Communications Programming

Serial Data Communications Programming

Real-Time Process Control

Hardware and Software troubleshooting

PROFESSIONAL EXPERIENCE

Varian Medical Systems, July 2014 thru November, 2014

PowerBuilder 12.1, Oracle 10g, Windows 7, TFS Source Control, Oracle

VM, IBM Rational

Leader of team to fix bugs and modify the Aria Cancer Patient Treatment EHR

applications at the UPMC Cancer Center in Pittsburgh, PA.

Interfaced with client and customer management.

Setup developer workstations with PowerBuilder, Oracle VM and Database, VPN

and RDP.

Programmed PowerBuilder defect remediation and documentation.

State of Michigan, Lansing, MI - May 2013 - July 2014; Application

Architect/Technical Lead

PowerBuilder 11.5 & 12.5.2, Visual Studio TSF 2012, Word 2013 OLE

Automation,

Oracle 11g, SQL Developer, PL/SQL, PuTTY, Unix Scripts

Application Architect and Sr. PowerBuilder Developer providing direction

and standards for upgrading the on-line applications for the State of

Michigan Department of Treasury.

Writing and maintaining PL/SQL stored procedures.

Re-Architected and programmed several framework objects achieving enhanced

execution, stability, reliability, reuse and maintainability.

Created an independent Logon object with encryption and security

features with the ability to be dropped into all of the Collections

Department's applications without modification.

Re-Architected and programmed a Batch Print system from Word.Basic with DDE

to PowerBuilder with Ole Automation supporting multiple concurrent

processes to print thousands of various collection letters per day to

debtors and their cohorts.

Conducted code reviews of all on-line application development and

maintenance with sign-off authority.

Installed and setup Visual Studio Team Foundation Server for source code

control. Designed and administered a feature based branching scheme which

allows multiple versions of applications to be developed simultaneously.

Department of Defense -- Remote Nov 2012 - April 2013; Principal Software

Engineer

PowerBuilder 12, Visual-C, Pro*C, Oracle 10g

Secret clearance

Providing architectural and application support for Department of Navy.

Writing PowerScript, and SQL Stored Procedures.

Guiding direction of network communication infrastructure.

State of Michigan, Lansing, MI - Jan 2012 - Sep 2012; Sr. Software

Developer

PowerBuilder 9.0, PowerTools, Sybase ASE15.0, ASE 12.5;

DBArtisan 8.53,

MS Office 2010, Bugzilla

Writing PowerBuilder modules for the migration of mainframe based

applications.

Writing Sybase ASE stored procedures, triggers and scripts.

Creating Project Charter, Functional Design, System Design and other PMO

documents.

Interfacing with customer designing system functions.

Writing new functionality into existing PowerTools framework.

Aiding in the migration from PowerBuilder to .Net platform.

Resolving Change Requests to the production system and tracking same in

Bugzilla.

Farmers Insurance, Grand Rapids, MI - Jan, 2011 - Dec. 2011; PowerBuilder

12.2 Lead Developer

PowerBuilder 11.5/12.1, Informix, DB2, Visual Studio

.Net/Visio/Excel/Word 2007,

IIS, ASP.Net, Web Services, WSDL, XML, OCX/OLE.

Converting existing PowerBuilder 11 applications to PowerBuilder 12 to

deliver and consume Web Services, WCF and WPF.

Creating WSDL and XML, deploying applications to Microsoft IIS.

Converting PFC functions to be compatible with Web Services.

Creating Custom Framework Classes to support Web Service development.

Develop SQL utilizing complex joins, grouping and sorting of tables to

facilitate the creation of nested reports.

Created a dynamicAdmin Utility to facilitate department administration of

parameter and message tables.

Consulted on.Net programming and debugging.

Federal Home Loan Bank, San Francisco, CA - May, 2010 - Nov.,

2010;Consultant

PowerBuilder 11.5, Oracle 9i/11g, Visual Studio .Net/Visio/Excel/Word 2007,

OCX/OLE.

Maintain production system for Security Safekeeping.

Rewrote a faxing subsystem to debug; delivering 100 times throughput

improvement.

Discovered and documented processing bugs in fax hardware system.

Modified production tables to support new reports.

Modified production reports adding new options and columns.

Automated the reconciliation of daily financial transaction discrepancies.

Produced Excel spreadsheets of raw FTP securities transactions.

Integrated OCX components for FAX/Email and data encryption functions.

Oversee and verify the delivery of data in new formats to/from fiduciary

banks.

Manage and maintain public/private encryption keys.

Troubleshoot and remediate Biztalk and AppWorx scheduled processes.

Create Oracle 9i/11g stored procedures and triggers to implement business

logic.

Abbott Laboratories, Columbus, OH - March, 2009 - January, 2010;

Consultant/Lead Developer

PowerBuilder 11.5, SQL Server 7/2005, Oracle 9i/10g, TOAD, Visual

Studio .Net,

Visio/Excel/Word 2003, OCX/OLE, C# .Net.

Lead developer on Electronic Receiving System to scan FDA regulated devices

returned for repair and dispatch them to the proper repair process queue

and initiate the update of SAP inventory status.

Perform analysis and design of Unit and Validation Test Scripts.

Create an interface with Camstar Manufacturing Systems turnkey factory MES

software.

Interface with Abbott Nutrition's Customer Service application for device

R&R.

Integrated OCX components for FAX/Email and data encryption.

Produce Excel spreadsheets of Abbott OEM Device History.

Create a standalone Manufacturing Scheduling and Setup system to allocate

assembly lines for various devices as required for new production.

Create a standalone utility to produce Lifetime Device History Records in

PDF format for single or multiple device serial numbers.

Create stored procedures to implement business logic.

Participated in the full SDLC design of new software components.

Demonstrate new functionality of software to factory management

representatives and participate in the analysis of feedback and design

of modifications.

Consulted on C#/.Net programming and debugging.

Exel Corporation, Livonia, MI - July, 2008 - November, 2008; Consultant

PowerBuilder 7.02, DBArtisan 8.53, Sybase ASE 12.5, OCX/OLE.

Performed analysis, design and programming of PowerBuilder programs,

Sybase tables,procedures and triggers.

Modified existing PowerBuilder programs.

Created custom PowerBuilder User Objects to support business model.

Created ETL routines using PowerBuilder and Sybase stored procedures for

EDI files.

Created triggers to support business model.

Used DBArtisan to create and modify tables, stored procedures, triggers and

reports in Sybase 12.5.

Used Word 2003 and Excel 2003 to edit functional design and to produce code

documentation.

Integrated OCX/OLE functions to produce and edit MSWord documents.

Abbott Laboratories, Columbus, OH - August, 2007 - July, 2008; Consultant

PowerBzuilder 9/10, SQL Server 7/2005, Oracle 9i/10g, TOAD, Visual

Studio .Net

Visio/Excel/Word 2003, OCX/OLE.

Performed analysis and design of Unit and Validation Test Scripts.

Created Functional Decomposition Diagrams of existing software applications

for analysis and documentation.

Created Object Oriented Framework for the company's PowerBuilder

application development.

Performed Project Analysis and Estimation for FDA Remediation project.

Programmed new and retro functionality for FDA Regulated Medical Device

manufacture and history reporting.

Utilized PowerBuilder 9 and 10 to add new functionality and to modify

existing code in an FDA Regulated Manufacturing Facility.

Integrated OCX/OLE functions to produce and edit MW Word documents.

Steel Dynamics, Inc., Columbia City, IN - Jan., 2007 - Aug., 2007;

Consultant/Lead Developer

Visual Studio .Net 2003, VisualC++, Oracle 8i/9i/10g, Oracle

Pro*C/C++, MSMQ,

TOAD.

Lead developer on all C projects.

PowerBuilder 10.2, Windows Command Shell scripting.

Authored Dynamic Libraries of C functions and integrated them into

PowerBuilder.

Wrote extensive Embedded SQL/C routines in Visual C++ and Oracle Pro*C/C++.

Successfully converted a production Steel Mill Control System software

package from Visual C 6.0 to Visual Studio .Net 2003 (3,485 source

files in 69 projects and 127 batch files.)

Assisted and trained plant engineers in testing and operation of the

software.

F. Dohmen Company/Jasrx, Milwaukee, WI - Apr., 2006 - Jan., 2007;

Consultant

PowerBuilder 10.2, Sybase ASA 9.02, Data Architect 9.0, Visual

C++,

Windows XP Pro, OCX/OLE

Wrote enhancements to the company's Pharmacy Management Software.

Wrote Sybase ASA 9.02 stored procedures and functions.

Wrote Embedded SQL/C functions using Visual Studio .Net 2003/Visual C++.

Wrote Visual C++ external libraries to be called by PowerBuilder routines.

Integrated OCX/OLE functions to produce and edit MW Word documents.

Visual Source Safe.

KidSmart Software Company, Southfield, MI -Feb., 2006 to Apr., 2006;

Development Team Manager

PowerBuilder 9.0, Sybase SQL Anywhere 9.0, DataArchitect 8.0.

PowerBuilder routines using a custom in-house framework.

Utilized Sybase ASA 9.0 database.

Used Sybase Data Architect to maintain and update database schema.

Windows Server 2003 and Windows NT 4.0 Terminal Services Edition.

Installed and configured servers.

Setup and configured Remote Desktop services.

Citrix MetaFrame Presentation Manager XP.

Installed and configured servers for Internet access to PowerBuilder

applications.

Windows Exchange Server 2003.

Setup Exchange 2003 and migrated existing Exchange Server 2000 accounts.

International Medical Group, Indianapolis, IN - Nov., 2005 to Feb., 2006 ;

Consultant

PowerBuilder 6.5, SQL Server 2000.

Wrote PowerBuilder reports and T-SQL stored procedures.

Created test data and scenarios for new table designs.

Wrote an application to support a new line of business.

Designed a PowerBuilder interface to MS Outlook 2003.

Affiliated Computer Services, (ACS) E. Lansing, MI - Apr., 2005 to Nov.,

2005 ; Consultant

PowerBuilder 10, EAServer 5.2, DB2, Sybase SQL Anywhere 9.0 Java,

Oracle 10g.

Designed GUI and documentation for a Medicaid Management Information

System.

QA'ed Functional Design specifications and created Detail Design

specifications.

Created PowerBuilder 10 objects and enhancements to the proprietary

framework.

Wrote SQL scripts and stored procedures.

Owens-Illinois, Toledo, OH - Apr., 2004 to Mar., 2005; Consultant

Sybase ASE 11.5, SQL Server 2000, Oracle 10g, PowerBuilder 6.5, DBArtisan,

C,

Unix Shell Scripts.

Performed extensive Sybase ASE T-SQL programming which was instrumental

in the migration of HR/Payroll/Benefits System from SmartStream to Oracle

HRMS.

Trained on Oracle HRMS and ReportSmith.

Migrated SmartStream data to WorkBrain Business Objects/Crystal Reports

IX.

Wrote and maintained various Unix shell scripts.

Created auxiliary databases and maintained HR/Payroll/Benefits system.

Analyzed and mapped data structures for migration.

Wrote Sybase T-SQL stored procedures and PowerBuilder applications to

support

productionHR/Payroll/Benefits operations.

Created Ad-Hoc SQL reports to help verify migration success..

Develop andconfigure business rules for automated reconciliation of

financial data.

Apply scripting to support business requirements.

Help identify outlyers and exceptions in automation process to refine and

fine tune.

Ensure ETL mappings provide correct data and business rules are applied

correctly.

Monitor reconciliation performance and adjust rules as required.

Assist with production support and release activities.

Conductvarious tests to validate business rule setup.

Review TLM loads to ensure expected results.

Query databases to review data inputs and outputs.

Review data mappings for file loads into TLM.

Provide status updates as required.

Chrysler Corporation, Sterling Hts., MI - Feb., 1993 to Mar.,

2004;Development/Technical Lead

MS Windows- PowerBuilder, PowerDesigner, C#/.Net + Crystal Reports, VC++,

AccessSQL, OCX/OLE; Sun Solaris - C, Ksh, Embedded SQL/C, T-SQL;

Sql Server 7/2000, Sybase ASE 11, DB2;

HP-UX - C, Ksh, FORTRAN 77, T-SQL, Allbase/Informix, DB2, TCP/IP,

Berkley sockets; HP-1000 Real Time Executive - FORTRAN 77, Assembler.

Direct vendor.

Integrated OCX/ActiveX control for Serial DataComm over RS-232/RS-485.

Programmed barcode scanners and RFID readers for tracking vehicles in

facility.

Programmed Data Communication to/from IBM Mainframe via DB2, SNA and FTP.

Configured and administered TCP/IP, NFS, NS/9000 and NS/1000 network.

DBA/Data Modeler for Sybase ASE 11 and Allbase/Informix databases.

Generated and installed operating systems.

Trained users and provided assistance with complex tasks.

Setup and program Horiba analytical instruments, CPi process I/O

controller.

Designed and wrote Vehicle Emissions Test System for gov't compliance.

Caterpillar Corp., Peoria, IL - Oct., 2000 to Jan., 2001; Primary

Consultant

HP-1000 hardware, RTE-A Real-Time Executive; FORTRAN 77.

Windows 2000, Visual Studio 2003,VC++.

Horiba Analytical Instruments and control software; CPi process I/O

controller.

Direct vendor.

Generated new RTE-A O.S.

Modified a Catalyst Testing System written in FORTRAN and MACRO to utilize

the new version of the O.S.

Rewrote RS-232 serial data communications to use TCP/IP protocol.

Wrote PC client VC++ application to migrate data from H-P system.

McDonalds Corporation, Oakbrook, IL - Nov., 1994 to Apr., 1995; Consultant

SCO UNIX, MSDOS, MS Windows, Novell Netware, VC++.

Designed diagnostic and corrective tools for a POScash register database.

Wrote support programs for Help Desk engineers to automate the repair of

data tables.

Level III Help Desk problem solver.

Auto Alliance, Flatrock, MI - 1993 to 1995; Primary Consultant

HP-1000 Real Time Executive, MSDOS, MS Windows dBase III, FORTRAN 77,

MS Access 2.0. CPi process I/O controller.

Direct vendor.

Configured and programmed process control I/O equipment.

Modified and maintained real-time analytical process control software.

Administered and configured SQL Anywhere RDBMS.

Wrote routines to Upload/Download vehicle parameters from Test Cell to PC.

Produced reports from test results for engineering and government

compliance.

Honda Canada, Alliston, ON Canada - 1993 to 1995; On-Call Consultant

HP/9000 HPUX Real Time UNIX, C. CPi process I/O controller.

Modified and installed Vehicle Emission Test Software.

Kmart Corp., Troy, MI - Jan., 1992 to Jan., 1993; Lead Software Developer

IBM/PC, OS/2, DOS/Windows, Object Oriented Design and Programming.

LEVEL-5 Object Expert System, C, VC++, VisualBasic, ToolBookand EDA/SQL.

Designed and developed a Retail POS Information Distribution System.

Used Level 5 Object to prototype a GUI front end to Client/Server DB2

database.

Accessed DB2, TerraData, IMS and other data on MVS/VM system using EDA/SQL.

Used C/C++ to develop speed critical algorithms.

Used Visual Basic and ToolBook as GUI development tools.

Utilized SDLC remote dial-up, HLLAPI/LU 6.2 network and COAX/LU 6.2 local

connections.

Ford Dealer Computer Services, Detroit, MI - Apr., 1991 to Dec., 1992;

Developer

TI mini/Unix, C; PC hardware, MS-DOS, C andMacro Assembler.

Async, Bi-Sync and LU 6.2 communication protocols.

Specified, designed and prototyped program and hardware for Bi-Sync and

LU 6.2 comm.

Designed and coded major update to Online Dealer Services application.

American Steel Foundries, Granite City, IL - Oct. 1990 to July 1991;

Primary Consultant

HP-1000/2100 - RTE-A and RTE-II Real-Time Executive Operating Systems;

FORTRAN 66/77.

Direct Vendor.

Migrated Railroad Car Stress Test System from HP-2100 platform to current

revision of HP hardware.

Migrated FORTRAN/66 programs to FORTRAN/77.

Resolved Real-Time idiosyncrasies between operating systems.

Rewrote all low-level I/O functions and access to O.S. libraries

Reprogrammed obsolete functions from old operating system.

Programmed custom graphics output with IEEE library.

IAD Worldwide, Clawson, MI - Apr. 1990 to Sept. 1990; Primary Consultant

HP-9000 - HP-UX operating system, BASIC, C

Analyzed and modified Automotive Design3-D CMM software.

Configured and tested systems.

Motorola Corp., Schaumburg, IL - Oct. 1988 to Mar. 1990;

Consultant/Development Lead

HP-9000 - HP-UX Operating System, HP- RMBasic, C

Direct vendor.

Generated and installed HP-UX operating systems.

Setup and configured UNIX Workstation Network.

Implemented programming standards.

Trained programming staff in Texas Instruments Teamwork CASE Tools.

Developed a Temperature Compensated Crystal Oscillator (TCXO) Calibration

System with CASE modeling.

Designed algorithms for programming/calibrating TCXO's.

Programmed Environmental Chambers, Frequency Mixers and Counter/Timers to

produce TCXO's for various radios and cellular telephones resulting in a

300% increase in production.

Motorola Corp., Schaumburg, IL - Sept. 1988 to Nov. 1988;

Consultant/Development Lead

HP-1000 - RTE-A Real-Time Executive; FORTRAN 77, PASCAL.

Provided HP-1000/RTE expertise and training.

Streamlined radio order processing factory link.

Streamlined maintenance of system programs reducing build time from

12 hours to 2 hours.

Designed database for order processing.

GM Truck & Bus, Ft. Wayne, IN - Apr. 1988 to Aug. 1988; Consultant

HP-1000 - RTE-A Real-Time Executive; FORTRAN 77.

Provided HP-1000/RTE expertise on GMT-400 project.

Provided problem analysis of factory MAP network.

Troubleshooter for Cell Controller malfunctions.

Daily verification and monitoring of 25 Cell Controllers and PLC status on

VAX/VMS Area Controller.

Setup and maintenance of Ungermann-Bass Net/1 terminal network.

Placed contract personnel. Brokered used mini-computer equipment.

General Motors Research, Milford, MI - Jan. 1987 to Mar. 1988;

Consultant/Dev.Manager

HP-1000 - RTE-A Real-Time Executive; FORTRAN 77.

Direct vendor.

Designed vehicle Electro-Magnetic Interference and Compatibility testing

system.

Interfaced analog and digital instrumentation.

Trained technicians in system usage. Sub-contracted programmers.

Placed contract personnel.

Brokered used mini-computer equipment.

Chevrolet Engineering, Milford, MI - Jan. 1986 to Dec. 1986;

Consultant/Dev.Manager

HP-1000 - FORTRAN, ASSEMBLER.

Direct vendor.

Customized the network based Engine Calibration System that I developed

at Buick, increasing Powertrain Engineer productivity x10.

Trained engineers in system usage. Implemented programming standards.

Maintained and customized corporate Vehicle Emissions Test software.

Liaison to G.M. Corporate Vehicle Emissions Laboratory.

Analyzed and specified vendor hardware for main-frame replacement.

Placed contract personnel.

Brokered used mini-computer equipment.

Dow Chemical, Midland, MI - Jul. 1985 to December, 1985; Primary

Consultant/Development Lead

HP-1000 - FORTRAN, ASSEMBLER.

Direct vendor.

Programmed an experiment to determine release rates of water soluble

agricultural compounds.

Programmed control of valves and Liquid Chromatograph instrumentation.

U. S. Steel, Rogers City, MI - January, 1985 to Jun. 1985; Primary

Consultant/Development Lead

HP-1000 - FORTRAN and Assembler.

Direct vendor.

Designed and coded Power Monitoring and Control system.

Designed and coded Preventative Maintenance Scheduling system.

Taught RTE operating system.

Placed contract personnel.

Buick Engineering Lab, Flint, MI - May 1981 to Dec. 1984, Primary

Consultant/Development Lead

HP-1000 - RTE-IV/RTE-6VM, FORTRAN/77, C, Assembler,

Image/1000 Database

Direct vendor.

Designed a network based Engine Calibration System increasing Powertrain

Engineer productivity 10 fold.

Implemented programming standards and developed a custom software library.

Maintained Modal and Bag Vehicle Emissions Test Software.

Programmed Embedded Software for the Motorola 6801 based GMCM engine

controller.

Programmed HP-1000 to IBM-370 communications using RS-232 and LU 6.1

HLLAPI.

Designed a Cruise-Control Simulator using a Burke-Porter Electric

Dynamometer.

Designed the Vehicle Emission Test Scheduling System.

Designed the Test Equipment PM Scheduling System.

Designed the Engineering Lab Real-Time Network.

Generated and maintained RTE operating systems.

Installed and configured minicomputer and pre-IBM-PC microcomputer systems.

Trained staff engineers on system and application software.

Placed contract personnel.

Brokered used mini-computer equipment.

Contact this candidate