Skip Navigation Links
 
Joseph J. Estermann
 

626 Kickbusch Street
Wausau, WI 54403
(715) 842-9099
joseph@jmjetal.com

 
SUMMARY OF QUALIFICATIONS
An accomplished Software Developer specializing in Object-Oriented Analysis and Design with extensive experience in the full design life-cycle including: requirements definition, prototyping, proof-of-concept, design, testing, and maintenance.
  • Expertise in Object-Oriented Analysis/Design.
  • Strong knowledge of Relational Database Systems.
  • Demonstrated ability to lead and mentor individuals to maximize levels of productivity.
Top
 
TECHNICAL EXPERTISE
Software: Visual Studio, SQL Server, Oracle, My SQL, Access, Fiddler, Toad, SolidWorks, Lotus Notes, Word, Excel, Power Point, Visio, Project, IIS, FTP, Cygwin, FPDF, CVS, PHP Designer, Paint Shop Pro 7
Systems: Windows (3.1, 95, 98, NT, 2000, XP), AIX, SCO, UnixWare, OS/2, CDC (6600, 3100), IBM 3090, PDP 8, PDP 11, DOS
Concepts: OOA, OOD, UML, Component Based Development, Relational Databases, Data Warehousing
Languages: ASP.NET, ASP.NET AJAX, VB.NET, C, C++, MASM, PHP, JavaScript, CSS, HTML, PL/SQL, T-SQL, Korn Shell, VB 6.0, FORTRAN
Top
 
EDUCATION
University of Wisconsin-Madison Madison, WI 1978-1984 M.A., 5/90
Major: Mathematics
Minor: Theoretical Physics
 
Graduate Information:
  • Qualifying exam in Applied Mathematics passed in August 1982
  • All course work for the Ph.D. program completed.
  • M.A. awarded on basis of work done in pursuit of Ph.D.
University of Massachusetts-Lowell Lowell, MA 1973-1978 B.S., magna cum laude, 3/78
Major: Applied Mathematics
Minor: Computer Science
 
Holy Name Seminary Madison, WI 1964-1966 High School Diploma, 5/66
Top
 
TECHNICAL EXPERIENCE
TEK Systems – Grand Chute, WI 7/09-10/09
Developer
Assigned to Woods Equipment CE Division to provide troubleshoot problems with their systems.
 
Programmer Analyst
Assigned to Woods Equipment CE Division to provide enhancements to their systems.
  • Enhancement of Production Snap Shot and Production Logout Reports to provide additional user filters.
  • Enhancement of ECN (Engineering Change Notification) System to validate parts and/or cause codes against HFA before submission by engineers. Created and additional approval step together with appropriate e-mail notificiations.
  • Create a materials database and enhance existing SolidWorks macro that interfaces with ECN System to improve scrap factor calculations.
Woods Equipment – Mosinee, WI 10/07-7/09
Sr. CE Programmer/Analyst
Sole IT programmer/analyst for the Kronenwetter (Mosinee) facility.
  • Provide programming and systems support for product standardization and cost reduction projects.
  • Provide enhancement of current processes for engineering and other functional groups within the CE division.
  • Provide training of group members on new systems.
Accomplishments include:
  • Through the use of automation, integration of HFA, SolidWorks, etc., increased engineering productivity by 50%.
  • Engineering reporting systems reduced time spend by managers from hours to seconds.
  • Design and development of Production Reporting system to track orders through various phases of production.
  • Design and development of Work Order Anomaly system to reduce production errors.
  • Design and development of Data Integrity Monitoring system to eliminate problems with prints and phantom parts by bill.
  • Design and development of Excess Stock system.
  • Design and development of scheduled tasks to automate SQL Server scripts.
  • Maintenance of Engineering Services Web Server.
  • Installation, maintenance, and migration of engineering data to SQL Server.
  • Evaluation of ERP system.
  • Data migration to Infor SyteLine product.
Adecco – Appleton, WI 2/07-10/07
Programmer/Analyst
Provided support for applications in an engineering environment used to maintain BOM, drawings, and specifications. In particular, this involved troubleshooting malfunctioning applications, determining the root cause for failure, determine and implement a solution, and verify restoration of required functionality.
 
TEK Systems – Grand Chute, WI 12/06-2/07
Programmer/Analyst
Provided enhancements to a web-based Performance Appraisal System. The application was to be expanded from a limited usage to U.S. to an application used by employees worldwide. This involved writing new administrative screens and enhancing existing screens. Developed a multi-lingual support mechanism for Spanish and Chinese. Defined and created new database tables as well as modifying existing tables. Designed and tuned database queries. Assisted in the production rollout of system. Project was delivered on-time, on-budget, and according to specifications. Provided post-rollout support.
 
JMJ Et.Al. - Wausau, WI 2/03-Present
Chief Scientist
Client:  Nazareth Studio (pro bono)
Project: Pricing Manager (VB.NET)
The client, a monastic group, produced hand written religious icons and sold reproductions of the originals. The costs of producing the reproductions consisted of both fixed and variable costs. The problem was how to determine a just price that would recover the costs and provide income. I researched various pricing algorithms and consulted with a colleague in the University’s economics department. Given the lack of historical data a Cost-Plus Pricing algorithm was selected. A database was created to maintain fixed costs, variable costs, products, and bill of materials for each product. An interface was created to allow CRUD on all tables, change pricing parameters on per product basis, a graphic display of the relation between costs and profit, what if scenarios, and the ability to set both retail and wholesale prices.
Project: Site Migration/Renovation (PHP)
Nazareth Studio had originally contracted with a company that went out of business before their web site could be created. Friends of the Institute were asked assist in migrating and completing the site. After about six months the central component: the gallery was not completed. The gallery was the critical catalog component of the website. I was asked to assist. I met with the client and discussed the problem and her goals/vision. I implemented the following steps:
  1. Placed a freeze on all non-essential development.
  2. Scanned the web site and created a visual diagram of the site showing all links, graphics, pages, etc. and identified all missing and/or broken components.
  3. Created a project plan using MS Project to manage tasks and resources.
  4. Established a three-silo environment: development silo (local to each developer’s workstation), a test silo for to check proper interfacing between components and allow the client to approve components, and a production silo which was the live web site.
  5. Established change management protocols.
The selection of how to implement the gallery was a critical decision; I researched this problem. The final solution was to use Gallery v1 (G1) from menalto.com. I then modified G to provide the standard Nazareth Studio look and feel, provide prices, provided an order form, and a call to a shopping cart application (E-Mals).
Project: Site Upgrade (PHP)
Nazareth Studio’s time constraint in the project above forced the use of G1 API. There was another version, G2, which used a MySQL backend. A migration of the site to G2 was accomplished. In doing so, the pricing data is no longer hard coded but read from a MySQL table. The interface to G2 uses Smarty templates to isolate the presentation from the business logic which, in turn, interfaces to the core G2 API. A new business logic module that that accesses MySQL through the core API services was being written. This module exposes services for Smarty to control the presentation. Additional functionality is planned:
 
Client:  Institute of St. Joseph (pro bono)
Project: Information Manager (PHP)
Responsible for providing a secure web application to track information about the members (addresses, phone, etc.) and progress of the members toward their final vows.
Project: Web Site (ASP.NET)
Responsible for providing public web access to learn about what the Institute of St. Joseph and its activities. Adminisrative pages to allow user to update much of the content.
 
Client:  SkyPixMedia (ASP.NET)
Project: Prototype
The client was a pilot who took pictures from a small plane. He wanted the ability to pan and zoom the properties he had photographed. He requested a prototype.Two approaches were taken.

The first approach was to slice and dice the original image into a series of smaller overlapping images at three different levels of magnification using PERL and C. The interface consisted of an image with navigation arrows. Each photograph needed processing before placed into the application. The interface looked out of date. Maintenance was going to high.

The second approach was to leave the original images intact and manipulate them on the client side. The main part of the application was a series of frames. One frame contained the working image, another contained a reduced version of the image and served as a locator, a third frame contained meta-data such as information about the property and additional links (other frames contained menus and tools). The major issue was how to keep the three frames synchronized. For example, panning or zooming the working image required updating the locator. DynAPI was selected to provide the DHTML support needed for the working and locator images. The application was served using ASP.NET. The various events that occurred in the client browser triggered update events that were handled by JavaScript on the client side or requests to the server depending on the nature of the event.

 
Client:  Self
Project: Gradebook and Class Website (ASP.NET)
Created a database to manage student data, evaluations, grades, and a second database to manage courses, lecture topics, schedules, etc. to support my university activities. Application consulted database and provided all web pages that needed updates on a daily basis. Application produced a manifest of new pages and command file to push new pages to the university’s server. Application also provided reports of student and class progress and assigned grades. Each semester additional functionality was added and some existing objects were refactored.
 
Clients:  Christian Evangelical Revival Church & Ministries, Bubba's Bayou (HTML)
Project: Web Site
Simple web sites
 
COMPUWARE - Wausau, WI 1/00-5/02
Sr. Staff Analyst
Completed Compuware project management course.

Managed data conversion team. This was part of project consisting of consultants from several different companies chartered to migrate claims data from a main frame system (IMS, VSAM, and DB2) to an Oracle based client server system. Prepared project plans and progress reports for Compuware and the senior project manager (IBM).

Designed and developed the blueprint for the overall conversion architecture. Designed, developed, and maintained the tools required to facilitate the data migration. These tools included the metadata repository, layout scanners, mapping tool, and code generator. Developed a system interface using PL/SQL from Oracle to external main frame systems. Installed and maintained Oracle staging area and test sites.

Designed and developed Impact Analysis Tool. This tool was used to facilitate the decommissioning/migration of a corporate data warehouse and systems by providing a graphical display of main frame job dependencies with the ability to browse job chains. The tool was written using Visual Basic 6.0, MS Access and MS Excel.
 
WAUSAU INSURANCE COMPANIES - Wausau, WI 1/91-12/99
Technical Lead
Essential duties included:
  • Evaluation of new and emerging technologies which have included: groupware, internet/intranet, imaging, object oriented techniques, I-CASE, natural language, neural networks, and fuzzy logic.
  • Provide technical briefings, consultation, strategic recommendations to senior IS management.
  • Designated language expert/consultant for C, C++, HTML, X, Motif, Smalltalk, Visual C++, Visual Basic, Lotus Notes, IEF, and UNIX shell scripting.
  • Mentor for all aspects of object oriented technologies.
  • Presentation of seminars to IS associates, including: Principles of Client/Server Architecture, Client/Server models, Object Technology, Component-based Development, and Guiding Principles for a Corporate Warehouse.
  • Technical evaluations which included: Domino web technologies, Essbase, IEF, and Java.
Significant assignments:
  • Data warehousing technical advisor charged with developing a high level technical architecture to support current and future warehousing activities. This included extraction, transformation, staging, loading, information access, decision support, reporting, metadata repository, operational data stores, data modeling, audit, and controls.
  • Corporate technology advisor, which encompassed Data Warehousing, Internet/Intranet, and Lotus Notes.
  • Technical consultant and member of Competitive Intelligence Oversight Committee.
  • Technical and language consultant to ECLIPS (Electronic Commercial Lines Insurance Processing System) project, a distributed system, using C, MASM and BASIC on the PC side; C, BASIC, Korn shells and Oracle on the AIX side; COBOL and DB2 on the main frame side.
Significant projects managed:
  • An Alternative COBOL CPE/Development Environment which sought to off-load existing on-line and batch COBOL development, maintenance, and testing to desktops and NT 4.0 servers. Data stores included the DB/2, CICS, and IMS data.
  • IEF/Composer application development and infrastructure support staffing requirements (star point teams). This project sought to leverage the existing application portfolio. Appointed IEF/Composer Development Coordinator responsible for monitoring all aspects of pilot development projects, vendor contact, and advising IS management. Developed IEF/Composer project tracking database using Lotus Notes. Coordinated all training for developers and infrastructure support members.
  • IEF/Arranger Prototype application using VB 4 and Oracle to bring main frame data into Excel.
  • Go2Notes, a document migration, publishing, and content manager for Lotus Notes and Domino (web delivery) created to deploy internal reference manuals. The system became the primary means of delivery for policy and procedures manuals, reference and rating manuals, and underwriting manuals. The online delivery of approximately 200 internal manuals resulted in the elimination of costs associated with the printing and distribution of paper copies. Personally designed and developed the application using Visual Basic, Notes APIs, MS Word, OLE automation (written in C++), and MS Access.
  • Balanced Scorecards System, a Lotus Notes application for the Customer Service Business Center. The system translated vision and strategy into a tool which effectively communicated strategic intent and motivated and tracked performance against established goals. Requirements of the system included various levels of security and ability to deploy to the Intranet. The system also employed LotusScript and MS Word OLE to complete the functionality.
  • Co-Manager: Natural Language Pilot to provide an English language query front-end to an Oracle database.
  • Neural Network prototype for Cash Flow.
  • Automated Login Program from AIX to main frame.
SELF-EMPLOYED - Wausau, WI 9/87-7/94
Independent Consultant
Designed and developed custom interactive systems for clients using BASIC, Assembler, and Btrieve in DOS stand-alone or Novell Netware mode. These included: Service Call Maintenance System; Sales Analysis Package; Chiropractic Office Patient Management System; Radiology Clinic Patient Management System; General Loan Amortization Program; and Lock Master Keying Program. Development languages include: MASM, BASIC PDS, C, and Btrieve. Supported environments include DOS, Windows 3.1, Novell Netware and Novell Unixware.
 
ASEC – Burlington, MA 3/78-6/78
Scientific Programmer
Performed data analysis, reduction and manipulation of data in support of projects with the Air Force Geophysics Laboratory's Analysis and Simulation Branch. These projects involved writing, updating, and documenting programs (FORTRAN) for power spectrum analysis and fade rate/duration of messages from communications satellites, atmospheric analysis, and statistical analysis of large scale data.
 
Top
 
TEACHING EXPERIENCE
UNIVERSITY OF WISCONSIN -- MARATHON COUNTY - Wausau, WI 8/03-8/06
Lecturer
Courses taught: Basic Mathematics, Elementary Algebra, Introduction to College Algebra, Quantitative Reasoning, College Algebra, Trigonometry, Pre-Calculus, Topics in Finite Mathematics, Elementary Statistics, Calculus & Analytic Geometry III, and Differential Equations.
 
VITERBO UNIVERSITY - La Crosse, WI 5/04-8/04
Lecturer
Courses taught: Elementary Statistics (Marshfield & Wausau sites).
 
UNIVERSITY OF WISCONSIN -- MARATHON COUNTY - Wausau, WI 9/92-12/92
Associate Lecturer
Courses taught: FORTRAN.
 
MT. SCENARIO COLLEGE - Ladysmith, WI 10/92-12/92
Lecturer
Courses taught: Probability & Statistics..
 
UNIVERSITY OF WISCONSIN -- MARATHON COUNTY - Wausau, WI 1/88-12/90
Lecturer
Courses taught: Introduction to College Algebra, College Algebra, Trigonometry, Calculus and Related Topics I, Calculus I & II, Introduction to Fourier Analysis, and Linear Algebra & Differential Equations. In addition, due to colleagues sudden illness, taught the last half of Astronomy 100/200, conducted the labs, and operated the planetarium. Member of Curriculum Committee and Academic Honors Committees.
 
UNIVERSITY OF WISCONSIN -- MARATHON COUNTY - Wausau, WI 9/85-6/87
Instructor
Courses taught: Introduction to College Algebra, College Algebra, Trigonometry, Calculus and Related Topics I, Calculus I & II, Introduction to Fourier Analysis, and Linear Algebra & Differential Equations. In addition, due to colleagues sudden illness, taught the last half of Astronomy 100/200, conducted the labs, and operated the planetarium. Member of Curriculum Committee and Academic Honors Committees.
 
LAWRENCE UNIVERSITY - Appleton, WI 9/84-6/85
Instructor
Courses taught: Calculus I & III, Applied Calculus I & II, and Elementary Statistics. Conducted a tutorial in the Foundations of Geometry. Provided significant technical assistance in the modification and installation of multidimensional scaling (KYST) program on the University's computer.
 
UNIVERSITY OF WISCONSIN -- MADISON - Madison, WI 9/78-6/84
Teaching Assistant
Courses taught: College Algebra and Trigonometry. Discussions led: Calculus I, II, & III.
 
US ARMY INTELLIGENCE SCHOOL - Ft. Devens, MA 2/75-4/77
Instructor
Civil service (GS-856-09) position. While assigned to the Advanced Electronic Theory Branch, Advanced Electronic Maintenance Division, instructed military and civilian personnel in advanced electronic circuit topics including amplifier theory, feedback theory, operational amplifiers, and solid state theory. Additional duties included technical analysis of materials prepared and/or presented by other instructors for accuracy, completeness, and educational value, review and updating of lesson plans, preparation of examinations, and interviewing students on their academic progress. While assigned to the Systems Branch, Basic Electronics Maintenance Division, instructed military and civilian personnel in basic theory of electronic circuits and their applications. Primary areas of instruction included a sixty hour course in digital logic systems and a fifty-six hour course covering the theory of operation, troubleshooting, repair, and alignment of magnetic recorders. The most significant achievement was the preparation (in collaboration with another instructor) of twenty-three audio visual lessons to teach the operation, function and detailed circuit analysis of the AN/GLQ-3 Countermeasures System. These lessons were designed to permit individual pacing of students and also as remedial and refresher lessons.
 
US ARMY SECURITY AGENCY TRAINING CENTER - Ft. Devens, MA 3/71-2/75
Instructor
While on active military duty, instructed civilian and military personnel in electronic circuit theory. The most significant achievement was the writing of the lesson plan for a sixty hour course on digital logic systems. This included the preparation of examinations, the instructional strategies, of experiments, student workbook, and the selection of training aids.
 
Top
 
AWARDS / DISTINCTIONS
  • Invited Address (AI & Neural Networks) 1997 Central Wisconsin Institute of Internal Auditors.
  • Invited address (Neural Networks) 1993 AI Symposium, St. Norbert's College.
  • UW Centers System 1989 Summer Grant (Characterization of Quantum Harmonic Potentials from their Spectrum).
  • Military decorations include Bronze Star, Army Commendation Medal, and Vietnam Service Medal.
Top
 
RESEARCH INTERESTS
  • Artificial Intelligence, in particular, Genetic Programming and Complex Adaptive Systems.
  • Formal Systems and Compiler Construction.
Top