David Dierauer Email & Phone Number

Lansing, Michigan, United States

• Worked as a technical lead responsible for guiding multiple development teams in software design and implementation.• Worked independently as an experienced developer on special projects (e.g.: projects benefitting from my deep knowledge of the billing system, or needing to be completed quickly).• Met regularly with stakeholders in multiple departments within the company to assess project requirements and give feedback on level of development effort.• Produced project documents for developers and management, such as use case documentation, scoping/feasibility analysis, post-release result measurement, etc.• Continued to mentor developers on our team.• Moved to the Business Intelligence department in April 2022 to bring my strong familiarity with the billing system, and my development experience, to a team that was starting over after the founding department head left the company. In this role, I became more familiar with data warehousing, BI reporting, and ETL. My main focus over the last year was to improve data loading, and especially alerting of ETL failures or data anomalies.

Lansing, Michigan, United States

• Worked as a senior member on a rapidly-expanding development team responsible for writing a new web interface to LW's virtual host provisioning system, as well as maintaining multiple existing other applications.• Initiated and developed standards for unit testing for both the existing codebase, and new code.• Authored and maintained coding standards for the development team.• Started a new junior developer mentoring program to help the company build out the team rapidly and effectively. I was responsible for assigning tasks from our bugs and feature requests that would gradually introduce the juniors to Perl, our coding standards, and our applications, and incrementally increase their knowledge and competence.• Introduced routine code reviews for developers of all levels, and facilitated department-wide meetings to discuss programming principles illustrated by various reviews.

Lansing, Michigan, United States

• Worked as part of a small team of programmers responsible for creating, maintaining and improving various applications to support operations of a fast-growing web-hosting company.• Maintained and expanded functionality of web applications for internal billing and helpdesk systems, and customer-facing "control panel" application.• Developed a new CRM system for sales and support to use for tracking leads and managing communications with current customers, integrating the new application with several other existing internal systems.• Architected a brand new structure for tracking the company's product offerings, allowing for flexible pricing, separate prices for different tiers of product options, and further automation of our custom shopping cart code.• Following the product system, I led the effort to bill our customers with actual invoices, broken down into line items corresponding to the pricing of the products and their options, and including charges for a specific time period. (The previous system — based on the idea of "2 credits" being the equivalent of a month of service — was insufficiently flexible for the more complex products LW was beginning to sell.)• Created and maintained object-oriented perl modules, upgrading existing code as appropriate to conform to best practices.• Performed various light Linux system administration and MySQL/PostgreSQL database administration tasks.

Pittsburgh, Pennsylvania, United States

• Worked as part of a distributed team supporting large, complex web applications such as a tax management system for US counties, and a bond auction site. Also was responsible for modifying their issue-tracking software (using PHP) to better suit GSG requirements.

Lansing, Michigan, United States

• Worked on a large project implementing a new Medicaid Management Information System (MMIS) for the State of Michigan.• Wrote PL/SQL stored procedures and other custom software to perform complex data translations, managing inputs and outputs between flat files and other data sources and the Oracle 10g backend database.

New York City Metropolitan Area

• Improved and enhanced the custom web application used to manage operational issues at a home health care company, including improving application performance through database query optimizations and mod_perl/Apache tuning techniques.• Developed and maintained multi-interface reports (HTML, PDF, Excel) using a custom XML-based report configuration system and complex SQL and PL/SQL queries.

East Lansing, Michigan, United States

• Worked as part of a team of programmers responsible for maintaining and improving the billing and customer care system for the subscribers of a large regional ISP/telecomm provider, including bringing legacy Perl code into compliance with programming best practices while fixing bugs and enhancing functionality as requested.

East Lansing, Michigan, United States

• Managed and maintained the web site for a trade association, converting documents from a variety of formats into HTML 4.0 and PDF files, creating and editing graphics using Adobe Photoshop.• Automated repetitive tasks using Perl.

Lansing, Michigan, United States

• Provided reference service to clients both in person and over the phone.• Wrote, designed and edited instructional and informational materials for patrons and staff, in both print and online formats, working closely with the library publications office.• Served on small committee responsible for a major redesign of the library's web site.

Master Of Library & Information Science - Mlis, Library And Information Science

Specialized in Academic Reference Librarianship.

Bachelor Of Arts (Ba), Linguistics

Graduated Summa cum laude (with highest honors), with a 3.88 GPA (out of 4.0).

Computer Science

Took computer science coursework to facilitate career move into software development.