PROFESSIONAL EXPERIENCE
Grainger, Lake Forest, IL
Oct 2011 - Dec 2011
Consulting Programmer-Analyst
Migrated web forms, web services, database objects and source code to
Windows Server 2008 servers for the Web Applications Development group.
- Built VMWare
developer workstation virtual machine images for SQL Server Integration Services,
IIS and FTP roles, Subversion source control, Visual Studio 2010,
Infragistics controls, and WPF / Silverlight development
- Added Active Directory user validation, request relay, and
base-64 encoded attachment features to a SMTP email web service in C#.NET
- Audited and reported on FTP and web server request logs to migrate
legacy sites and services from Windows Server 2000 to Windows Server 2008
- Authored SSIS
data transform packages to summarize web service use,
user account info, and Source Safe archive contents for data and
source code migration
- Wrote Source Safe
backup and time card automation macros in Excel 2010
- Designed a file and subversion archive search utility to identify
source files for conversion
- Converted the ASP.NET authentication model of several websites to
implement Active Directory roles
- Enhanced TSQL queries to optimize data search filters in SQL Server 2008
- Tested and fixed ASP.NET web form user interface issues in Visual Studio 2010
- Configured and documented secure FTPS
file transfer requirements
Nightingale-Conant, Niles, IL
Feb 2011 - Sep 2011
Senior Web Architect
Coded and maintained eCommerce web applications for a world leader in
personal development audio books.
- Designed and coded an affiliate referral sales reporting engine
in ASP.NET with Fusion Charts and interactive detail, accessing
Google Analytics,
Lyris and DirectTrack
web traffic data
- Created a web interface to configure promotion codes for web and
email campaigns saving hours of complex data entry each week
- Wrote an MP3 customer library web service for the
MediaFly WhiteBox
streaming audio application allowing users access to their digital
content via cell phone and other web-enabled devices
- Added installment payment, terms < conditions, and digital media
functionality to the shopping cart and product pages in VB.NET
- Streamlined SQL queries in Microsoft SQL Server Management Studio
with version control
- Designed a single page shopping cart plug-in for AJAX-enabled
user authentication, zip code lookup, and automatic cart population
with components in VB.NET and C#.NET
- Setup a build server and wrote a site update utility to archive
changed items by date
Marketing Innovators, Rosemont, IL
Jul 2010 - Dec 2010
Consulting Web Developer
Built a web service and web content for a highly respected HR incentive rewards company.
- Coded a generic middle tier webservice to implement debit card
functionality
- Supervised the implementation of card web services on five
public-facing sites
- Created a custom WinForms test-driven development (TDD) module in
Visual Studio 2010
- Wrote and maintained SQL queries in Microsoft
SQL Server Management Studio
- Authored a data-driven email reporting tool using ADO.NET, CSS
and the
Telerik RadEditor
- Improved the design and functionality of web forms in C#.NET,
JavaScript, CSS, AJAX, and Classic ASP
Astellas Pharma US, Inc., Deerfield, IL
Apr 2010 - June 2010
Consulting Programmer-Analyst
Streamlined an RFC intranet web form system to optimize UI and data integrity concerns.
- Managed code quality and deployment considerations with Microsoft
Visual Studio
unit testing and Team Foundation Server
(TFS) version control
- Reduced ASP.NET postback through
AJAX implementation and JavaScript
'chunky vs. chatty' data population, search and validation
- Used
LINQ to SQL persistence with
Microsoft SQL Server for user and request data
ORM
- Designed ASP.NET, JavaScript and CSS
components to show / hide and conditionally validate
hierarchical data structure dependencies
- Wrote Active Directory
LDAP query, data encryption, and
SMTP library functions in C#.NET to facilitate user data lookup,
authentication, and automated email alerts
- Optimized database, email and server access through
automated build scripts and loosely-coupled context-sensitive
configuration
- Utilized the Infragistics
WebHtmlEditor,
Telerik RadGrid, and RadDock ASP.NET Web UI components for
rich client interface design.
- Implemented ScrumWorks
and custom Projetrix
project management tools to track and prioritize a backlog of
system deliverables
JP Morgan Chase, Chicago, IL
Jan 2009 - Mar 2010
Senior Programmer-Analyst
Designed workflow components to automate government form lockbox processing.
- Worked on the Application Service Layer team in the
Treasury Services department
- Used NUnit and
Rhino Mocks with
Resharper for test-driven development (TDD) and
defect resolution in Visual Studio with Microsoft
TFS for version control
- Monitored
Cruise Control continuous integration and
NCover code coverage reports to resolve build issues and
testing concerns related to large-scale team coding efforts
- Generated code review artifacts and managed version conflict updates
with WinMerge
- Wrote and optimized a form data matching service in (Java)
J2EE 1.4.3 using the Eclipse
Ganymede IDE configured with
TeamPrise version control, the
TestNG unit test framework, and Apache
Maven build plug-ins
- Implemented serialized hierarchical field matching rules in the
Drools and
Drools.NET
business rule management system (BRMS) platform languages
- Automated deployment reports and
Spring.NET form mapping configuration using Excel macros
Man Investments / Glenwood Capital, LLC, Chicago, IL
Mar 2006 - Dec 2008
Reporting Programmer-Analyst
Developed internal reporting applications and process enhancements.
- Managed
Agile software development projects through definition of
requirements, planning and coordination of resources, coding,
testing and implementation
- Worked with object-oriented design experts and completed
Learning Tree .NET Best Practices and Design Patterns training,
successfully implementing test-driven development, .NET generics,
and common design patterns in subsequent projects
- Utilized
Microsoft Test and NUnit for
TDD and Resharper for code refactoring in Visual Studio with Microsoft
TFS and later
Subversion with
Ankh
for version control
- Configured
CruiseControl with
NAnt for continuous integration, and wrote custom remote service
deployment
COM components in C# utilizing Windows Management Instrumentation
(WMI) and
PsTools to roll-out software updates
- Wrote and implemented a nightly
Edgar Online
institutional ownership SEC data filing import service, web stock quote
service and synchronization utility in C#.Net 2005 with the
Infragistics UltraWinGrid control
- Used ScrumWorks,
HP Mercury TestDirector,
JIRA and
Sharepoint Portal Server to plan and track agile project
development and testing responsibilities
- Created a web-based survey automation tool in Microsoft C#.NET and
ASP.NET with offline data archiving capabilities
- Setup and customized ASP.NET content portal prototypes using the
Microsoft Community Starter Kit and
DotNetNuke web application
frameworks
- Introduced
Excel interoperability to the company's reporting client in C#
to deliver configurable offshore product marketing materials
- Added compression functionality to the project framework using the
SharpZipLib free open-source C# .NET library
- Automated product management and
RiskMetrics
spreadsheets using VBA in Excel 2003
- Researched a bug within a legacy Visual Basic 6.0 application and
wrote a server-side work-around using Transact SQL in SQL Server 2000
- Wrote code generation macros to simplify
NHibernate data mapping
- Developed internal reports with Crystal Reports XI and
Visual Studio .NET 2005
America's Sleep Network, Westmont, IL
Mar 2005 - Feb 2006
Healthcare Systems Developer-Analyst
Hired to help develop and promote a line of healthcare billing and scheduling applications.
- Implemented and enhanced two
UltraApps project management web sites using Active Server Pages
and Cascading Style Sheets (CSS) in Microsoft Visual InterDev
- Produced a computer-based training course for LynxIT Solution,
ASN's ASP-based handheld patient billing product using
Camtasia Studio, and Adobe Premiere
- Authored an interactive interface for CD-ROM materials in C++ and
Visual Basic 6.0
- Prototyped a product website using
JavaScript, CSS and DHTML
- Developed a patient demographics import utility in VB.NET
- Automated Alice 5
sleep study reporting using VBA macros in Microsoft Word
- Developed a shift-oriented technician scheduling system using
Windows Forms in Visual Basic, Microsoft Access, ADO, Crystal Reports,
and the
Wise Installation Toolkit
The Committee of Twelve, Chicago, IL
Jan 2004 - Mar 2007
Web Developer
Volunteered to add eCommerce functionality for Twelfth Night, Chicago's longest running private black tie masquerade ball, automating ticket payment collection for over half of the guests.
- Produced soundtracks for the party's individual events in
Magix Audio Studio
- Designed and maintained the CSS and eCommerce portions of
the party's web site www.12thnightmasque.com
- Setup an additional collaboration portal in
DotNetNuke at GoDaddy.com
- Created interactive DVD presentations of the event using
Adobe Premiere
- Authored the 2007 DVD in Sony DVD Architect
Banker's Life and Casualty, Chicago, IL
Nov 2004 - Jan 2005
Consulting Programmer-Analyst
Chosen to enhance the functionality of electronic forms, deliver online setup and registration, and recommend new technology purchases.
Impact: Accelerated results using low-overhead Agile software development, delivering data extraction, validation and export to over 4000 insurance agents.
- Managed IIS test site hosting and Agile DSDM project methodology,
involving several iterations with multiple builds each day, testing
rollouts over a local web, with online prioritization of feedback
- Conducted Agent laptop requirements research and negotiations
- Authored a time tracking database application, MDI Agent Workbench
prototype with online web mail delivery, and background FTP proof of
concept in VB.NET 2003
- Scripted installation through WSH and workflow optimization
using VBScript
- Created documentation and presentation graphics using Microsoft
Word, Excel, PowerPoint, Visio,
Adobe Acrobat Distiller, PhotoShop, ULead Video Studio, Cool 3D,
and TechSmith Camtasia Studio
- Performed graphic palette reduction and forms cleanup in
ULead Video Studio
- Used JavaScript for field validation and FDF format data extraction
in Adobe Acrobat Professional with Adobe Acrobat Reader support
- Developed additional document merge functionality in Java, iText
and PDFTK
- Authored a web-based FDF data archive utility in
IBASIC Professional
- Designed web layouts in Macromedia Dreamweaver
- Added HTML form validation and navigation, web form data
consolidation, and additional Acrobat functionality through JavaScript
- Worked with Access XP to provide links to Microsoft Outlook data
submissions from a ColdFusion script, data backup restore
functionality, decryption logic, and include file package
integration for IBASIC compilation
Nephrology Associates, Oak Park, IL
Jul 2001 - Aug 2004
Project Manager / Lead Programmer-Analyst
Signed on to develop and test business applications for this 40+ doctor nephrology group's billing operations in order to provide improved collections, accounting system enhancements, and patient care assessment feedback. Worked with vendors and service partners to automate over $1.7 million in supervision charges monthly and deliver regional quality improvement indicators based on third-party laboratory results. Built close working relationship with company executives and technology staff.
Impact: NANI has enjoyed uninterrupted cash flow, with over 50% of charge revenues generated through automated processes despite numerous internal and industry-wide changes in medical billing practices.
- Coded transaction modules working with Micromed NextGen EPM
and top service partners for Electronic Data Interchange
- Developed HIPAA-compliant
cross-platform portable data collection solutions in
AppForge Mobile VB for PalmOS and PocketPC PDA devices under the
guidance of the corporate technology committee
- Managed several code sets to ensure the proper formatting of NSF and
HIPAA X12N 837 electronic insurance claims and paper forms in Visual
Basic 6.0, VB.NET, Access 97 / XP, and SQL Server 2000
- Adapted explanation of benefits imports to the X12N 835 electronic
remittance specification
- Wrote encryption algorithms in Microsoft Access VBA, ActiveX, J2SE,
and 4th Dimension
- Automated spreadsheets for an accounts reconciliation database
tying together account activity, cash posting, and remittance to
provide an accurate daily snapshot of cash on hand
- Created a payroll system which imports time clock data from an
Oracle 8i database, supports timesheet entry, and calculates
salary/wage disbursements with paid time off accrual
- Outsourced the kidneyphysicians.com
website and trained staff in HTML design
International Woodwind, Chicago, IL
Aug 1998
Consulting Programmer-Analyst
Hired to help the proprietor of a musical instrument refurbishing business simplify eCommerce operations.
Impact: Reduced development costs by 75% while enabling more timely site updates.
- Wrote an instrument tracking system to update the inventory
web page HTML and graphics for
internationalwoodwind.com
- Tutored the owner in the use of FrontPage98 and FTP programs,
and provided system upgrades
Everest Healthcare, Westchester, IL
Jan 1998 - Jun 2001
Consulting Programmer-Analyst
Worked with a team of 9 technology consultants to provide billing, reporting and statistical analysis solutions for a major US healthcare service provider.
Impact: Enhanced efficiency and stability of dialysis operations which lead to a lucrative buy-out offer from Fresenius Medical Care, North America.
- Wrote a lab
results quality core indicators ETL system in MS Access and
SQL-Server, Crystal Reports and the
ProEssentials Graph and
PKWare PKZip control libraries
- Implemented Visual SourceSafe version control and
TotalAccess Analyzer testing
- Created a dialysis facility statistical analysis utility that interfaces two
Baxter databases
- Coded accounting transaction modules for a medical supply inventory
database
- Automated patient billing business processes with insurance verification
and contractually adjusted charges for accurate accounts receivable totals
Ernst & Young, Chicago, IL
Jan 1997 - Dec 1998
Consulting Programmer-Analyst / Phase One Design Team Principal
Collaborated with a group of over 50 contractors on an automotive insurance marketing application for Nationwide Insurance.
Impact: Consultants at Ernst & Young provided an extensible object-orient database system to run in all Nationwide Insurance call centers.
- Participated in initial business system specifications, custom
control architecture, project management, and test interface deployment
using the PowerSoft
PowerBuilder 5.0 object-oriented fourth generation
language (OOP 4GL) integrated development environment against an Oracle8
RDBMS
- Designed and scripted test applications using PowerBuilder, Visual
Basic 5.0, AutoDesk
3D Studio, Adobe PhotoShop 4.0, and
Rational Visual Test
- Used
Lotus Notes as a project tracking database, and PVCS for
version control
- Documented system features for roll-off to Nationwide?s internal
development team
Terraglyph Interactive Studios, Schaumburg, IL
Oct 1994 - Jan 1997
Manager of Technical Support / Database Administrator
Lead the technical support team for CD-ROM game customers in Windows 95, DOS 5.0 and Macintosh System 7.5 while developing database and marketing skills.
- Designed and maintained SQL Server and MS Access
relational databases
- Used Visual Basic 4.0, Crystal Reports, Borland C++ and macros
within Excel spreadsheets for data analysis and technical support
systems
- Incorporated Adobe Premiere non-linear video editing, PhotoShop, 3D
Studio, Microsoft Quick Basic, Excel, and Word in the design of
marketing presentations and database projects
Quaker Oats Company, Lombard, IL
Mar 1992 - Jul 1994
Reporting Representative
- Prepared account level financial reporting in
Microsoft Excel 3.0 - 5.0
- Supervised synchronization of customer data on an
AS400 WAN connection
- Used FOCUS and Informix with Microsoft QBASIC to parse and
summarize data output from internal DEC VAX VMS and IBM CICS
reporting applications
- Authored interactive quarterly report generation software in
Visual Basic 2.0
- Wrote instruction manuals and on-line tutorials to document
processes
Guitar Center, Chatsworth, CA
Oct 1990 - Sep 1991
Management Information Systems
Served as member of the inventory systems conversion team responsible
for keying product inventory data, generating bar-coded SKU tags from
a custom Prime Computer database, and providing systems training
to the Guitar Center sales force.
EDUCATION
Northwestern University
2003 - Present
Chicago and Evanston, Illinois Campuses
Continuing studies in Finance, Organizational Behavior,
Technology Project Management,
Digital Video Editing,
eCommerce Architecture, Advanced JAVA for Programmers,
and Web 2.0 XHTML
Tools and Technologies
DePaul University
2010
College of Computing and Digital Media - Chicago Loop Campus
Professional development course work in
Lightweight Java Web Development covering JSP (Java Server Pages),
Struts, JSF (JavaServer Faces), Hibernate, Spring and a survey of
other frameworks
ScrumAlliance.org
2006
Chicago, Illinois
Completed Scrum Master
Certification
Illinois Institute of Technology
Fall 1994
Wheaton, Illinois
Course work in Database Design - Included a term paper on
MS Access 2.0
The University of Iowa
Class of 1989
Iowa City, Iowa
Bachelor of Arts Degree
Double Major in Communication Studies and Music Composition
College of DuPage
(Student at Large)
Glen Ellyn, Illinois
Selected courses in Computer Programming, Mathematics, and Music