David Stemm Email & Phone Number

Naperville

• Senior Manager of new ALM project/team to transition company into a modified agile environment, including introducing an entire new tool set. Transitioned the planning, design, coding, QA and CI/CD build/deploy pipeline to move to the Atlassian suite of tools (Bitbucket, Jira, Confluence, Bamboo). Managed the implementation of the new software, processes and workflows as well as the conversion from the existing system. Also played the role of System Admin for the entire suite of tools.• Managed a team of developers on several projects to enhance and customize a cloud based vendor management system. Was responsible for overall development as well as mentoring and performing code reviews for the team. Technologies used include Java, Struts, Tomcat, MongoDB

• Managed and developed with a team that worked on projects and enhancements to a web based party management system. The system allowed direct sales consultants to manage all aspects of their business. Major enhancements included theme shows (allowing consultants to choose what type of show they want to host) and an email wizard, which gave the client the ability to create their own custom email templates. All development used Java, Servlets, JSP, Hibernate and J2EE running Jboss with MS SQL Server as the backend.• Developed REST services passing JSON objects to interact with the client environment.• In addition, my team was responsible for all aspects of the production environment. Provided 24-hour support and maintenance for all application servers. Performed all code reviews, final testing, merges and deployments for anything related to production. I was also responsible for all client interaction. Used Maven and Jenkins for all builds and deployments.

• Lead the development for internationalizing the web based system for various countries and languages. Created technical specs and lead the team in developing the system based on those specs. Performed all code reviews and mentored team members.• Developed web based Order Management system that allowed consultants to enter their party orders and submit to the home office. Technologies included Java, Servlets, JSP, JSTL, JSON

•Developer on a portal conversion project for a large insurance company. Converted existing JSP/Servlet/Struts site into separate JSR 168 compliant portlets. Technologies used included Java 1.4, IBM WebSphere Portal Server 5.1, RAD 6.0, DB2, Struts 1.1 and JSP.•Led the development of a web-based Tank Car Accident Database project that consisted of converting 30 years of data stored in an Access database into an internet accessible application with querying capabilities. The application runs on WAS 6.0 using SQL Server 2000 and was developed RAD 6.0, Java 1.4.2, Struts 1.2.4, JSP and JSTL.•Ongoing maintenance of an online book selling application used mainly by schools and libraries. Development is in Java and JSP and uses WSAD 5.1.2 as the development environment with DB2 as the database. Recent enhancement included a “De-Dupe” functionality, which flags the search results of logged-in users indicating if that book belongs to the Schools collection of previously ordered books.

Client: Blue Cross Blue Shield Chicago, ILRole: Lead Developer• Lead developer for a series of web-based projects. All four projects are based on Java, JSP, and Struts using WSAD and deployed to WebSphere Application Server.• Managed all aspects of the projects, including requirements, design, coding, testing, deployment and maintenance.• Integrated with Interwoven as the content management system to display dynamic content. Created JSP Custom tags to display the content and to display lists of documents of a certain type.• Created a web based application for Senior Citizens to apply for Medicare Supplement coverage. Data was collected into an XML file which was then passed to an Actuate template to convert it to a pdf file and stream it back to the user.• Developed an online provider search application. Created the search criteria, SQL and online form that allowed the users to search by the providers location, specialty, name, etc. and get back a list of providers.

Clients include Carlson Marketing, ABN AMRO, I-Many, Magnify, and Blue Cross Blue Shield of Illinois (Health Care Service Corporation). See below for a description of each client.

Client: Magnify, Inc. Chicago, IL Role: Lead Developer • Lead developer of a web-based data mining application that used Java, JSP, Tomcat, Struts, JSTL, and SQL Server 2000. Application was designed to report potential fraudulent cases for an insurance company.• Reports were displayed using Crystal Reports and had to integrate Crystal Server reports into the application. • Coordinated the design, coding, testing and implementation of the project.

Client: I-Many, Inc. Aurora, IL Role: Developer• Developed XML and Java based reports for a Government Pricing product to allow pharmaceutical companies to calculate various pricing formulas. • Embedded SQL queries into XML to populate the reports and designed custom Java classes to create HTML-based reports.

Client: ABN AMRO Chicago, IL Role: Lead Developer/Team Leader• Designed a user-customizable portal for customers of an online financial services application.• Installed and administered the application server and database using IBM WebSphere and Oracle. • Coded portal components using Java Server Pages, SilverStream Director, Struts, Tiles, and XML/XSL. Components included weather, stocks, news and company highlights.• Created a framework for the system that included the data access objects (DAO), a logging resource, a caching facility and several helper classes.• Enhanced and launched a financial services auto-enrollment application using Java, SilverStream ePortal, IBM WebSphere and Oracle. • Coordinated the development effort and updated existing code to production quality standards. • Fine-tuned the application’s performance by implementing caching methods and improving the database access.

Client: Carlson Marketing Rosemont, IL Role: Lead Web Developer• Maintained and enhanced a web-based human performance management software system using Java Servlets and SilverStream’s J2EE Application Server and Page Designer with Oracle as the backend.• Refactored SilverStream proprietary code into efficient and modular Java classes using well-known design patterns. • Created stored procedures in PL/SQL to process batch transactions that reduced processing time from over two hours to under five minutes.• Documented the functionality of the existing system while applying enhancements and bug fixes.• Coordinated development effort with offsite staff by assigning tasks, performing code reviews, and gathering requirement and technical documents.

• Member of an elite internal consulting team that acted as a liaison between R&D and the consultants in the field. • Provided technical assistance and support on new technologies to field consultants.• Managed and developed the corporate intranet portal using SilverStream (Novell) eXtend Platform and J2EE technologies, including JSP, Servlets, Struts, Tiles, JavaBeans, XML/XSL, and using SQL Server as the database.• Performed project based and advisory consulting to SilverStream customers.• Coordinated development staff in support and enhancement of server-side business objects for a distributed data entry and reporting tool written in PowerBuilder and using SQL Server as the database.

• Designed, coded and tested a graphical user interface using PowerBuilder Foundation Class library. • Extracted business requirements from existing application. • Developed Oracle database, including tables, indexes, users, security, etc. using ERwin and coded stored procedures with PL/SQL. • Created business objects in PowerBuilder allowing users to produce and design adhoc reports.• Designed and created Microsoft Access database and front-end interface to allow users to track and compare data sent to and received from an outside vendor. • Created audit program to compare the incoming and outgoing data.

• Researched, coded, and tested changes to all date related fields for a Year 2000 project that converted and updated OS/VS COBOL programs into structured COBOL/370 modules. • Designed and developed several Microsoft Access databases to facilitate in testing. The database captured screenshots of a mainframe screen for a before and after comparison.

• Analyzed, designed, coded, tested, and implemented business specifications for converting and enhancing an old CICS/Assembler online application using COBOL/370, CICS, and DB2.• Responsible for the “scoring” of a credit file, which was used to determine an individuals credit rating.