Resumé

Experienced application programmer specialized in workflow, information management and reporting with SQL and Lotus Notes.

Currently finishing a year-long program at The Career Institute of American International College for Enterprise Solution Developer and Digital 3D Design certificates, studying front and back end technologies.

Proven technical expertise complements communication skills, whether the need is application design and execution, documentation, training, or sitting down with client users to hash out quality applications that meet needs rather than just stated wants.  Self-motivated, innovative thinker consistently stretching abilities, expanding knowledge and making coworkers’ jobs easier and more efficient.

Technical Summary

* Databases: Oracle, SQL Server, MySQL, Lotus Notes, Ingres

* Languages: C#, Java, SQL, LotusScript, Flash Actionscript, HTML & CSS

* Other Software: Visual Studio, Eclipse, Tuxedo, DB Artisan, WebEx, Lotus Sametime, Adobe Dreamweaver, Photoshop, Illustrator, InDesign, Flash, Premiere Pro, After Effects, Encore, Autodesk 3DSMax, MS Office, Lotus 1-2-3

Career History

Houghton Mifflin Company * Boston, Massachusetts  * 1996 – March 2007
Business Information Systems Group/Business Application Technology, Senior Application Architect

Developed and maintained in-house Sales Force Automation suite of Notes and back-end SQL applications that supplied over 400 traveling textbook marketing/sales people with timely order status and territorial management data, publication catalog sampling, distributed sales material and presentations via replication, and maintained secure Travel & Expense databases.

* Wrote documentation and training materials for the above and many other applications, conducted user training for same.
* Co-created Material Master workflow database to track over 80K (at this time) large and small detail changes, handling over 500 fields, modularly architected in data design to accommodate unique functioning for divisional requirements and manage significantly changing procedural requirements as use of the application broadened.
* Conducted regular usage review, permission revision, and archiving using self-developed in-house tools.
* Complete revamp of Change Request Management IT DB workflowing coordination and signoff, with design emphasis on keeping header clean and compact, rarely used detail fields no more than one click deep, central navigation via Calendar view so that scheduled changes and completion status were visible at a glance.

IRI Software * Waltham, MA * 1996
Notes Development/Administration Contractor

* Redesign of QA workflow (bugs) application under Notes 3.3; new forms, code including lookups and keyword validations, macro buttons, and supporting documentation for users. Helped administer domain split.

Infocellular, * Wayland, MA  * 1995
Oracle/Tuxedo/UNIX Programmer Contractor

* Design and documentation of distributed tri-level client/server Inventory Control C module for national cellular telephone seller, employing Process Layer/Data Layer contracts and services.

Massachusetts Institute of Technology * Cambridge, MA * 1994 - 1995
Ingres/VAX VMS Programmer Contractor

* Enhancement and redesign of 4GL (ABF) accounts receivable application for Technical Licensing Office, utilities application for Physical Plant, employing SQL coding, Embedded C.

Gillette South Boston * Boston, MA * 1993 - 1994
Ingres/VAX VMS Programmer Contractor

* Designed and tested dynamic SQL programs for parameter-driven marketing/retail report system, using embedded C; Enhanced 4GL (ABF) front end: user could choose customer/ retail/ product criteria. Back end creates keyed tables for efficient SQL procedures.
* Developed Report-Writer code for 30+ system reports plus ad hoc requests.
* Analysis and enhancement of existing SQL code using Query Execution Plans.

Lotus Development Corporation * Cambridge, MA * 1985-1992
Associate Programmer Analyst  * 1990-1992

* Systematized name, email address and password protocols for database systems.
* Created Record Duplication process for database system; researched user's needs to create more efficient and swift completion of process.
* Devised network distributed text database system - "Notes" to deliver reports to users; eliminated time-consuming multiple paper and email copies.
* Created automated backup for SQL Server, including full-dress testing of recovery procedures.
* Wrote complete documentation for SQL Server System Maintenance: DB Administration, Reports, Backup, Recovery, Daily Maintenance, while developing same systems.

SPR Coordinator  * 1987-1990

* Supported and redesigned Ingres Equel-C application per user's needs and priorities, tested and implemented during project cycles; Planned and executed simplification of 3 Ingres databases into master; including field mapping and data conversion, directory and batch procedure makeover; reduced daily support time from 2+ hours to 15 minutes daily.

* Wrote documentation for VAX/VMS accounts, batch files and databases, ops & maintenance.

Data Entry Clerk  * 1985-1987

* Responsible for all data input of software projects.
* Increasing responsibility for Ingres report completion and report- writing.

Education