Paul Wehr

(note: relocatable to anywhere in the mid-west at my expense)
Looking for this document in Microsoft Word format? Open Word, select File->Open, and enter http://informationsoftworks.com/resume.php, and press "Ok"

March 2009 - Present -- Client: Huron Valley Physicians Assocation

• Design and Implement claims Data Warehouse, including Hardware, installation of operating system, SQL database server, ETL environment and support applications.
• Fully automated loading of 32 source data feeds using cron and perl
• System includes probability-based fuzzy-match system for tracking patients between health carriers' databases

August 2004 - Present -- Client: Dempsey, Inc., Ann Arbor, Michigan

• Server configuration and Desktop support
• Business process automation: used Perl to parse PDF rate quote documents from vendors and automatically assemble aggregate Excel summary

December 2008 - February 2009 -- Client: Thomson-Reuters, Ann Arbor, Michigan

• Refactored SAS programs to supporting the Treatment Cost Calculator product to support arbitrary customers, be 92% less code, and 12x faster
• Presented novel data-access mechanism that would eliminate 85% of manual labor required to produce estimates
• Introduced simple mechanism for converting XML documents to PDF using XSLT and Apache FOP
• Tools used: SAS 9.1, subversion, xslt, Apache FOP, 7zip, perl, MySQL Workbench, Confluence Wiki, Sharepoint

June 2007 - July 2008 -- Client: ITC Transmission, Ann Arbor, Michigan

• Data Warehouse Architect - Re-designed existing prototype warehouse to support Sarbanes-Oxley compliance and full data reproducibility in a transactional environment
• Wrote ETL and validation programs for complex (MV90, XML) data sources using perl, DBD::Oracle, Oracle 8i/10g and TOAD
• Trained staff in use of Crystal Reports Enterprise for warehouse reporting
• Developed web-based data-entry screens in PHP and oci8
• SCM: Subversion and Surround SCM, Data Modler: Erwin

February 2008 - June 2008 -- Client: Arbor Research, Ann Arbor, Michigan

• Created and tuned a system to match patient identities from separate ESRD and Cancer databases, using Microsoft SQL Server and SAS
• Project completed 30% under budget.

March 2007 - July 2007 -- Client: University of Michigan Kidney Epidemiology and Cost Center, Ann Arbor, Michigan

• Re-engineered patient matching system using Oracle 10g, Oracle SQL Developer, and SAS 9
• New system is significantly simpler (is <10% of the old systems code base), 80% faster, evaluates 80% more identification fields, and is much more flexible in design.
• Project completed 40% under budget.

Mar 2005 - May 2007 -- Client: SportStat, LLC, Troy, Michigan

• Implemented Java-based SMS-SMPP (cell phone text messaging) gateway to update PostegreSQL SQL database server based on content of incoming messages
• Set up batch scripts to convert wmv (mpeg2) video to 3gp (cell phone) and flv (Adobe Macromedia Flash) formats
• Used perl, and LWP to scrape high school data from state athletic association websites
• Created automated script to create interactive DVD with nested menus based on video on MySQL database server

July 2003 - January 2007 -- Client: Pfizer Global Research, Ann Arbor, Michigan/Groton, Connecticut

• Project Manager and Warehouse Architect for the "Virtual Study File" Data Warehouse, supporting pre-clinical Biostatistics FDA reporting, using Oracle, TOAD, PL/SQL, SAS ETL, and Samba, to access data sources on Windows, HP-UX, Solaris and VMS platforms
• Ported comprehensive statistical package written in C from it's native VMS platform to HP-UX and Solaris using gmake, and gcc
• Developed new relational data model using Kimball star warehouse schema, targeting Business Objects data mart
• Tightened internal data integrity of existing Oracle database schema through implementation of new sequences, triggers, foreign keys, unique indexes and other constraints using SQL*Plus and PL/SQL on Oracle RDBMS
• Enhanced Web interface using ASP scripts accessing Oracle database with IIS on Windows NT server
• Developed client-server, web-based Java Applet GUI for interactive data quality review
• Developed ETL job scheduler using bash shell scripting, cron, grep, Javascript, Perl, CGI, and DBD::Oracle on HPUX Unix
• All development followed corporate system development methodology in compliance with CFR part 11, including Unit, System, Integration, Performance and User Acceptance testing.
• Installed (download, cross-compile, install) a2ps on HPUX to allow text reports to be delivered via PDF
• Installed SSL, SSH, and CVS on HPUX server to support secure access to remote X11 tunneling and SourceForge CVS code library

Mar 2005 - Oct 2005 -- Client: HealthPlus of Michigan

• Created automated, customized Provider Group performance reports on CD-ROM using Perl, PDF::Reuse, HTTP, HTML, LWP, mkisofs and zip

Oct 2004 - Feb 2005 -- Client: GE Consumer Finance, Canton, Ohio

• Developed automated reports in SAS to query Oracle databases containing account information for 33M accounts.
• Designed, implemented and installed comprehensive Mainframe data QA system using x3270 emulator, SQLite, and SAS
• Guided staff on simplifying and automating dozens of key business system reports in Excel, Business Objects, SAS and MS/Access
• Recommended modifications to Oracle SQL data warehouse design and Solaris-based SAS ETL process that would improve performance by at least 1000x
• Made recommendations on where to spend hardware budget to improve performance

Apr 1999 - Dec 2002 -- Client: Blue Care Network of Michigan

• Designed, implemented and installed a turn-key 500GB Data Warehouse containing 10M Members, and 100M+ claims using only a 110V outlet and a 100BaseT ethernet port
• Created Web-based OLAP system in HTML and Javascript with Apache, Linux, MS/Access and ODBC to replace Crystal Enterprise reports
• Designed and implemented a custom data replication system from DB/2 IXF export files to PostgreSQL using CRON, FTP, perl and SQL
• Provided Unix (Linux) administrator services: installed and configured Linux, SCSI RAID5, CIFS, Windows/NT, Apache, PostgreSQL, Samba, SMTP, ssh, XFree86, and VNC
• Developed complex custom SQL analyses using DB2 on MVS Mainframe

Apr 2000 - Nov 2000 -- Client: Pfizer Global Research, Ann Arbor, Michigan

• Used SAS and SQL to implement source-to-target ETL modules for loading into Oracle RDBMS as specified in Erwin data modeller
• Proposed and implemented relational database architectural design to support Cognos OLAP Cubes

March 2000 - Sep 2000 -- Client: Univera Health Care

• Rewrote SAS analysis programs for HEDIS reporting, on SunOS Unix, reducing code set 94%
• Initiated modification to enterprise network firewall, allowing remote X11 session forwarding

Nov 1996 - Mar 1999: -- STATPROBE, Inc. - Manager, Clinical Information Systems

• Management and mentoring for a staff of 4-7 direct-reporting SAS analysts
• Developed specialized reporting system for printing clinical edit checks in triplicate using only SAS software
• Developed SAS listing, summary, and Biostatistical analysis programs for clinical research on Windows/NT and Novell NetWare

Jun 1995 - Oct 1996: -- Parke-Davis/Warner-Lambert - Clinical Programmer/Analyst

• Developed SAS listing, summary, and Biostatistical analysis programs for clinical research on HPUX Unix, Windows and MVS TSO/JCL Mainframe

April 1993-Jun 1995: -- Parke-Davis/Warner-Lambert - Contract Programmer

• Created a device-independent output driver system for SAS reports (%PRINT) providing ODS-like functionality 5 years before ODS
• Developed a GUI application in SAS/AF for tracking employee's post-graduate education
• Implemented a standard SAS macro library with and indexed reference manual to facilitate coding efficiency and reliability.

Sep 1992-Apr 1993: -- Biopharmaceutical Research Consultants Inc. - Programmer

• Developed listing and summary reports in SAS for pharmaceutical research
• Supported staff in use of IBM-PC and PC applications

Aug 1991-Sep 1992: -- Parke-Davis/Warner-Lambert - Clinical Applications Programmer

• Created custom enhanced-format reporting tool using Xerox DJDE Mainframe printer commands
• Created an interactive division-wide mail system on MVS using ISPF dialog manager

May 1991 - Mar 2001: -- Washtenaw Community College - Math Instructor

• CIS 283 - "Programming the Web"
• MTH 191 - "Calculus I"
• MTH 192 - "Calculus II"
• MTH 197 - "Linear Algebra"
• MTH 179 - "General Trigonometry"
• MTH 169 - "Intermediate Algebra"

Intermotive Technologies (formerly Batten Engineering)
Summer 1987 & 1988: Programmer/Consultant

• Developed a comprehensive software package for storage and analysis of cylinder head airflow test data

Siko Products, Inc.
Summer 1986: Digital Circuit Analyst

• Responsible for circuit layout, assembly and analysis of digital position indicators (used in industrial robotics)

Operating Systems

Programming Languages

Interface Standards/Protocols

Applications/Servers (configuration and maintenance)

University of Michigan School of Education
Sep 1986 - Aug 1990: Bachelor of Science in Education, Mathematics major, Physical Sciences minor

• SAS Certified Professional
• 97th percentile in "Linux Administration" (brainbench.com)
• 92nd percentile in "SQL (ANSI)" (brainbench.com)
• 98th percentile in "perl" (brainbench.com)

• Implemented complete SOHO network including DHCP, DNS, Apache, SSH, LPR, and Samba
• Implemented and configured IPTables-based security firewall on Intel Linux
• Implemented Amazon associate website using DHTML, XHTML, Javascript, PHP and XML SOAP
• Installed Web-based IMAP mail client over secure web site (HTTPS) for remote mail access
• Set up scripts to extract and transcode video on Tivo to appear on a website in a format watchable on Palm or iPod hand-held
• Developed radioactive decay calculation and printing application for the University of Michigan Hospital Nuclear Pharmacy (in 4k)
• Developed aircraft rental and maintenance software for the University of Michigan Flyers.
• Developed Web-based mash-up of available missions for Angel Flight Mid-Atlantic
• Independently developed ray-tracing software in 4 languages (perl, C++, SAS, basic)