Mike Gagnon
22 Cherokee Avenue

+1 603-889-3550 (office)
+1 603-689-5202 (mobile)
Nashua, NH 03062-1847

+1 877-889-3550 (fax-to-email)
07/14/2009
mike@gagnon-software.com

Expertise:

Applications: Data Quality; Data Warehousing; Sales Process Automation; CRM; Marketing & Political Campaign Software; Decision Support Systems; Custom Add-On Software; Time Recording & Data Collection; Database Systems; Real-Time; Multi-Tasking; Hardware/Software Installations; Loan Evaluation; Statistical Process Control;

Roles: Technical Lead, Data Quality Expert/Architect, Account Management, Consultant, Data Analyst, Data Architect, Software Design, Software Development, Project Management;

Hardware: PCs (Intel based), SUN (10K, 5K, Sparc), IBM SP2, IBM Mainframes, DEC VAX, DEC PDP-11/70, HP1000.

OS and Platforms: Unix (Sun), Unix (AIX), Unix (SCO), Unix (BSD), Linux (RedHat), MS WinXP/2000/2003, MS-DOS, VMS, RSX-11M/M+, RTE-A, MVS/TSO, CMS, JCL, Roscoe/RPF, MVS/OS, OpenStep

Communications: TCP/IP, Novell Netware, Banyan Vines, IBM PC Lan, PC/NFS, RS-232C;

Languages: C/C++, Java, Objective C, LISP, Pascal, RAIL, Basic, COBOL, FORTRAN, PL/1, HTML, dBase III+;

4GLs/Tools: Oracle SQL & PL/SQL, DB2, MS Access, MS SQL-Server, PROC, DYL260, Dbase IV, Visual Basic, Visual C/C++, FoxPro for Windows, Data Junction, FrontPage, Paradox (PAL), Clipper

Data Quality Suites: Trillium Software, Group 1 Software, FirstLogic;

ETL environments: Ab Initio, Informatica,

CASE: Visio, ERWin, EasyCase for Windows, Visible Systems, Designer 2000

Other: Clearcase, PVCS, SCCS, RCS, CVS, Unix Scripting (ksh, csh, sh, bash), DOS Scripting,
MS Office (Word, Excel, Project, Powerpoint);

ConTRACT / CONsulting History:

Citrix Systems, Fort Lauderdale FL

SEP 2008-MAR 2009

(MS Remote Desktop Software Provider)

·        Trillium Software Expert/Architect:  Interviewed and gathered requirements from business users and technical staff across enterprise for data quality needs that can be supported by new Trillium 11.5 version. Reviewed existing Version 7 Trillium implementation. Architected, designed, and implemented Trillium 11.5 ETL business contact data quality solution to support real-time, as well as initial, small, and maintenance batch operations for worldwide customer and prospect data management including de-duplication and interactive matching.  Prepared requirements and design specifications.  Estimated level of effort based on actual work to meet requirements.

Tools:

TS Quality Version 11.5 (Discovery/Quality/Insight), PCs, MS Windows Server/XP (DOS scripting), MS Office, Word/Visio/Powerpoint/Access/Excel, MS SQL Server 2000, Vantive

 

Southwest Airlines/IBM, Dallas TX

Jul 2008-AUG 2008

(Domestic US Airline)

·        Trillium Software & NCOA Expert/Architect:  Interviewed staff. Reviewed existing version 7 Trillium implementation. Gathered Trillium and NCOA requirements for Siebel implementation.  Prepared requirements and design specifications.  Estimated work to meet requirements.

Tools:

TS Quality Version 11, Trillium Siebel Connector for Version 11, PCs, MS Windows Server/XP (DOS scripting), MS Office, Word/Visio/Powerpoint/Access/Excel

 

Confidential Client, Fort Erie, Ontario, Canada

JUL 2008

(international non-profit direct marketer)

·        Strategic Business/Marketing Consultant:  Interviewed management across enterprise.  Identified opportunities for improved automation.  Advised client on hardware, software, and commercial data opportunities. Composed and presented proposal to improve operations and ROI.

Tools:

PCs, MS Windows XP, MS Office

 

Arcapita/IBM Global Services, Atlanta GA

SEP 2007-DEC 2007

(International Investment Company and International Technology Services Provider)

·        Trillium Software Expert/Consultant:  Gathered requirements.  Estimated work to meet requirements.  Advised client on hardware and software infrastructure dependancies.  Installed Trillium Software packages.  Identified next generation DQ software anomalies.  Profiled client contact data.  Created base offline international and domestic data routing, US cleansing, and business contact matching process.

Tools:

TS Quality Version 10, Trillium Siebel Connector for Version 10, Trillium Discovery for Version 10, TS On Demand, PCs, MS Windows Server/XP (DOS scripting), MS Office, Visio/Powerpoint/Access/Excel, Oracle, Siebel Financial Services

 

Bank of Montreal/Adastra Corporation, Toronto ON, Canada

JUL 2007

(Large Residential and Commercial Bank)

·        Contact Data Quality / Trillium Software Trainer:  Developed in 2 weeks and conducted 3 day best practices course for using Trillium and Ab Initio to improve contact data quality in support of BMO Financial’s ongoing projects.  There were 19 attendees.

Tools:

Trillium 6v0, PCs, MS Windows XP (DOS scripting), MS Office, Visio, Powerpoint/Access/Excel/Project

 

New Hampshire Right to Life, Merrimack NH

DEC 2008-JUN 2009
DEC 2006-JUL 2008

(Non-profit Issue Advocate)

·        Development Chairman/Database Solutions Provider:  Conceived, designed, developed and implemented operational database and contact data quality systems solution for non-profit political and community advocacy group, for the purpose of contact management, event management, fundraising, issue tracking and contact notification.  Managed Newsletter Production.  Conceived, created and presented multi-option growth development / campaign presentation to major donors.

Tools:

PCs, MS Windows XP (DOS scripting), MS Office, Visio, Powerpoint/Access/Excel/Project

 

Philips Medical Systems, Andover MA

MAY 2006 – FEB 2007

(Medical Equipment Manufacturer)

·        Data Quality / Trillium Software Expert:  (1) Designed and developed business name and address cleansing and matching process for 2.2 million business name and address contacts for OneSAP StayClean project using Trillium batch software suite in accord with the requirements for the online Trillium Software Data Quality Connector for SAP offering on Windows 2003 Server & AIX including online configuration deployment, network configuration, SAP Configuration, as well as installation of online and offline components. The project included US and Canadian data, as well as Canada Post data and is expandable to all other countries supported by Trillium.   (2) Advise Philips on standard data quality industry techniques to ensure implemented data quality rules are applicable and auditable.

·        Data Warehousing and Data Integration Expert:  (3) Advised Philips on data integration/ETL software product capabilities to include Ab Initio/Trillium, Informatica/QAS, Datastage/Qualitystage, and Business Objects/Firstlogic

Tools:

Trillium 7v7, Trillium Data Quality Connector for SAP, PCs, MS Windows 2003 & XP (DOS scripting), MS Office, Visio, Access/Excel/Project, AIX/scripting, SAP 6.4 WAS, ECC 5.0, Lotus Notes

 

Bellsouth / Siebel Professional Services

FEB 2006 - APR 2006

(Large Telecommunications Services Provider)

·        Data Quality / Trillium Software Expert:  Designed and developed name and address cleansing and individual matching process for 24 million record residential and business customer base initial load in support of Siebel UCM project using Trillium batch software suite in accord with the requirements for the Trillium Siebel Connector offering on Windows 2003 Server.

Tools:

Trillium 7v6, PCs, MS Windows 2003 & XP, MS Office, Visio, Oracle 10i

 

Canadian Imperial Bank of Commerce, Toronto ON, Canada

APR 2005 - OCT 2005

(Large Residential and Investment Bank)

·        Data Quality Expert / Trillium & Group 1 Software Technical Lead:  Design and development of international data quality real-time (SOA)
1) Corporate customer cleasing and matching solution to support BASEL as well as
2) Anti-money-laundering cleansing and matching solution and
3) Enterprise wide - international data quality initiative using
Trillium Webservices offering and Trillium batch software with Java, Solaris (ksh) and Oracle/SQL; based on UPU Standards, CASS, SERP, et. al.  Volume of effort reflects internal and external sources of 17 million contacts.

Tools:

PCs, MS Windows XP, MS Project, MS Office, Visio, Oracle 9i/10i, ErWin, Solaris (ksh),
Trillium 7v5 & 7v6 (Webservices), Java

 

Starwood Hotels and Resorts Worldwide, Inc, White Plains NY

SEP 2004 - MAR 2005

(International Hotel and Property Management Company)

·        Trillium Technical Lead:  Designed and developed world wide data quality real-time guest profiling Trillium solution using Trillium Webservices offering and batch software with Java, Linux (bash) and Oracle/SQL; based on UPU Standards, CASS, SERP, AMAS, et. al.  Volume of effort reflects internal sources of 40 million contacts.

·        Trillium and Data Warehousing Consultant: Analyzed data and user requirements; Advised client regarding Trillium software capabilities; Estimated implementation effort for Guest Profiler Phase 3;

Tools:

PCs, MS Windows XP, MS Project, MS Office, Visio, Oracle 9i/10i, ErWin, Linux (bash),
Trillium v7.5 (Webservices), Java

 

IBM & The Gap, San Francisco, CA

Apr 2004 - SEP 2004

(Large Computer Systems and Services Provider & Large Clothing Retailer (respectively))

·        Trillium and Data Warehousing Consultant: Analyzed data and user requirements; Advised client on data augmentation and Trillium software capabilities; Estimated implementation effort;  Served as Technical Lead and single implementer of contact data quality effort completed within 4 months including design, development, and documentation for 340 million record, 40 feed, data and piped parallel, batch, initial and incremental load; email, telephone, name & address hygiene, and matching, scripted ETL processes to populate and select candidates from ODS schema at address, household, and individual level using the Trillium Software System v7.0-7.5, Oracle 9i SQL, and Unix Korn Shell.

Tools:

PCs, MS Windows 2000, IBM/AIX , Oracle 9i, MS Office, Visio, Unix Korn Shell scripting, Trillium v7.0-7.5

 

AAA Mid-Atlantic, Philadelphia, PA

MAR. 2002

(Automobile Emergency Road Service and Insurance Provider)

·        Data Quality and Data Warehousing Consultant:  Advised client on general conceptual design for data warehouse ETL integrated with contact data quality tools given the specific options and features of Group 1 Software’s implementation on the MVS/JCL platform.

Tools:

PCs, Windows XP, MS Office (Word, Excel, Project), Group 1 Software, MVS/JCL, Trillium, Ab Initio

 

American Management Association, Saranac Lake, NY

May. 2001 – Sep. 2001

(Non-profit organization which provides Domestic and International Management Training)

·        Trillium Expert and Data Warehouse Consultant / Technical Lead: Specified, designed, developed, and implemented contact cleansing and consolidation solution using the Trillium tool suite, Oracle, and UNIX to support AMA Customer Relationship Management needs. Developed data warehousing data quality CRM solution in 16 weeks which included initial and incremental loads, parallel processing implementation of business oriented, name and address cleansing components for 8 basic source systems as well as multiple-matching, consolidation, and survivorship for sites and individuals, reporting, data loading, and data propagation. Composed high-level technical design documentation (DFDs); Wrote numerous (>30) Unix scripts and PL/SQL software components; Installed Trillium software; Configured and generated rules to meet custom requirements; Estimated system requirements needed for solution; Advised Client on (and implemented) standard data warehousing practices and techniques.

Tools:

PCs, Windows 2000/98/95, MS Office (Word, Excel, Outlook) Lotus Notes, Visio; exceed,
Sun/Solaris: Oracle PL/SQL, Trillium, Unix (sed, awk, perl) scripting

 

AT&T Broadband/MediaOne, Lowell, MA

Nov. 1998 – Mar 2001

(Video, High Speed Data, and Telephony Cable System Services Provider)

·        Technical Lead / Development Lead: Performed analysis, design, development, quality assurance, and management of dimensional data warehouse development effort implemented in snowflake schema within 3 terabytes over multiple SUN systems (ue10k, ue5k), to support corporate marketing effort.  Work included: all external feeds, contact dimensions, quality assurance, Trillium (data cleansing & matching) & Ab Initio (parallel & piped processing ETL tool) technical support.  Completed deliverables included:


·        20 sets of business requirements

·        26 sets of technical specs

·        65 data cleansing projects

·        14 prototypes (3 major matching processes)

·        100+ Production Ab Initio Graphs/Scripts

·        30 Production Procedure Documents

·        management of 9 member team

·        recruitment of 4 team members

·        all test/data reviews

·        all USPS standardization & CASS, name and address matching, householding/matching, ssn, driver’s license, email address, phone numbers

·        18 source system feeds

·        9 external feeds including: Acxiom: NCOA, Telesource, Infobase demographics; Claritas: Census Block Variables, Microvision profiling, segmentation, & distribution, Nielsen Data, ADI,

·        marketing campaign bus. requirements analysis,

·        local expert & admin on installation, configuration, & use of Trillium, Ab Initio/Trillium Interface, Designer 2000, and Unix Scripting;

·        net change repository creation,

·        on-line repository validation, et. al.. 


·        Recipient of “CampaignOne Superstar Award” from MediaOne

·        Estimate work for MDC Process involving address matching of cable network with Trillium.

·        Researched and analyzed relevancy to marketing of available data from Acxiom, Claritas, Convergys/ICOMS Subscriber Management System, CSG SMS/CCS Vantage, and CableData SMS/OLR.

Tools:

PCs, Win95/98, MS Access, Designer 2000, MS Office (Word, Excel, Project), Visio; exceed, Sun/Solaris: Oracle PL/SQL, Trillium, Ab Initio, Unix Scripting, AS400

 

Anderson Consulting, San Ramon, CA

Nov. 1999

(Consulting Services Provider)

·        Trillium, Ab Initio, & Data Warehouse Expert Consultant:  Advised client on functional design of data warehouse, Ab Initio ETL integrated with Trillium contact data quality tool suite to implement specific client cleansing and matching features for a web-based investment services provider (E-Trade).

Tools:

PCs, Win98, MS Office (Word, Excel, Project), Visio; Exceed, Trillium, Ab Initio

 

TF Software LLC, Merrimack, NH

Apr. 1998 – Oct. 1998

(Y2K Problem Encapsulation Solution Software Developer)

·        Technical lead / Manager: Composed high-level technical design documentation (DFDs, Requirements & Functional Specs) of Y2K problem encapsulation solution for VAX/VMS systems.  Evaluated and redesigned "Customs" components of Y2K problem encapsulation software including Date Warp, Bridge, Data Converter, File Viewer, File & Stream Layout Engine, Century Protector, Date Miner, et. al.  Coordinated/Managed efforts of 5 person implementation team including development, QA, and documentation.  Researched Data Junction capabilities and OpenStep/Objective C platform and capabilities for effect on product development.

Tools:

PCs, Windows 95, WinNT, MS Access, MS C/C++, Nmake, MS Office (Word), Visio, Data Junction Enterprise Edition, OpenStep/DR2, Objective C, CVS, VAX/VMS

 

Epsilon, Burlington, MA

Jan 1996 – Mar. 1998

(Direct Mail, Marketing, & Fundraising Services System Provider)

·        Problem Solver/Data Quality/Data Warehouse Consultant: Designed and implemented several proprietary multi-terabyte database applications (including a data collection and decision support system); Troubleshooted system problems and software bugs; Performed project management; and Provided operations services for over 12+ of client’s largest accounts on hardware platforms ranging from IBM Mainframe to PCs to Sun Workstations to an IBM SP2 parallel processor, and associated software platforms: TSO, CMS, Unix, Windows, relying on external (Firstlogic, Group1) and internally developed (Xsystem) proprietary CRM tool sets.

·        Developed many database application enhancements using FORTRAN, C, Oracle, and various utilities such as Syncsort, to support new feeds and functions for many accounts.

·        Performed quality assurance for several projects.

·        Developed several database conversion applications including implementations of Group1 dupe checking and address parsing, proprietary Xsystem database environment, and Oracle based ‘Donorwise’ application.

Tools:

IBM Mainframe, JCL, CMS, TSO, FORTRAN, C/C++, Syncsort, Group1 & Xsystem Utilities, PCs, Windows 3.11, WinNT, Windows 95, MS Access, SQL, Unix, Oracle, IBM SP2, AIX, XWindows, Firstlogic, Epsilon Parallel Infrastructure, Unix Scripts & Shells, Exceed, Extra, MS Project, Visio, MS Office (Word, Excel), SUN Solaris

 

Raytheon, Marlboro, MA

Jun 1995 - Dec 1995

(Vessel Traffic Systems branch of Transportation Systems)

·        Developed several enhancements to support pirate detection in Raytheon Vessel Transport System product on SUN Workstations using C & Interleaf for Malaysia Project.

Tools:

SUN Workstations, Open Windows, C, Interleaf

 

InterQual Inc, Marlboro, MA

Mar 1995 - May 1995

(Medical Information Systems)

·        Designed and estimated internal, integrated, MIS enterprise wide software on networked PCs across multiple sites using EasyCase & MS Access.  Developed medical review database software using MS Access.

Tools:

PC Compatibles, MS Windows, EasyCase for Windows, MS Office, MS Access.

 

SHL Systemhouse, Marlboro, MA

Nov 1994 - Mar 1995

(Custom Software Systems Integration & Development)

·        Developed management reporting interface software on integrated PC & DEC minicomputer network platform using MS Access and MS SQL Server, etc. for Farm Credit Bank project.

Tools:

PC Compatibles, MS Windows, MS Office, MS SQL Server, MS Access.

 

Sybase Inc, Burlington, MA

Oct 1994 - Nov 1994

(Database Software)

·        Developed production release makefiles and other configuration management tools on NT using nmake, etc. for internal SSM Project

Tools:

PC Compatibles, MS DOS, Windows 32s, NT, MS Visual C nmake, Borland C 4.0 for Windows

 


Mike Gagnon for State Senate Political Campaign, Nashua, NH

July. 1994 - Sep 1994
July. 1996 – Sep 1996

(New Hampshire State Senate)

·        Candidate: Developed strategic campaign plan; developed campaign organization; Fundraised; Created campaign literature; Purchased campaign supplies; Researched opposition; Created and issued press releases; Interviewed by Press, Radio, & TV staff; Engaged in meet the voters events; Completed financial reports required by the State of New Hampshire;  (Unprecedented 4 week campaign resulting in marginal loss by < 2% after original candidate backed out due to medical issues).

·        Computer Wonk: Paradox for Windows database development; Converted and merged voter lists; Generated walk lists and mailing labels.

Tools:

PC Compatibles, MS-Windows, MS DOS, Paradox for Windows, MS Word for Windows.

 

Accusoft Corporation, Westboro, MA

Mar. 1994 - July 1994

(Imaging Software)

·        Development of Imaging Software Library API products in FoxPro for Windows w/Demo, and Clipper w/Demo.

Tools:

PC Compatibles, MS-Windows, MS DOS, MS C 6.0A, Clipper 5.2c w/Tech. Ref. Supl., Blinker, FoxPro for Windows, FoxPro Library Construction Kit, MS Visual C/C++

 

Acumen Financial, Cambridge, MA

Mar. 1994 - May 1994

(Financial Planning Software)

·        Development of data entry program using Visual Basic and CodeBasic

Tools:

PC Compatibles, MS-Windows, MS Visual Basic, Sequiter CodeBasic 5.1

 

Silent Client, Wilmington, MA

Dec. 1993

(Contract Consulting Placement)

·        Development in Advanced Revelation on Automated Contract Consulting Procurement System

Tools:

PC Compatibles, MS-DOS, Advanced Revelation

 

Paul Revere Insurance, Worcester, MA

Dec. 1993

(Corporate Insurance Services)

·        Consultant on Btrieve requirements and timing analysis

Tools:

PC Compatibles, MS-DOS 5.0, C, Btrieve

 

Kronos Incorporated, Waltham, MA

Dec. 1991 - Nov. 1993

(Specializes in Time Recording and Data Collection)

·        Problem Solver: Wrote, designed, specified, quoted, and developed custom software to modify and provide major enhancements to base product lines for client. (35+ customizations).  Recruited and staffed contract software development team for client.  Worked directly with client's internal custom software group, R&D group, sales force, and 19 of client's customers.

Tools:

PC Compatibles, MS-DOS 5.0, Borland C, Turbo C, Brief, Clipper, Codebase 4.5, Optech Sort, Word for Windows, Excel, Novell Netware, CCMail, SCO UNIX, GNU C and GNU make, VI, FTP, RCS, Usenet, Zortech C, Rational DOS Extender, DOS16M Debugger, VAX/VMS, C. Customized Client Product lines included: TKC, KCC, KSM, KAP, CVT, multiple-platforms (DOS, UNIX, VMS).

 

Advanced Electronics Interconnect Center, Inc., No. Andover, MA

Feb. 1993 - Sep. 1993

(Specializes in Environmental Information Dissemination)

·        Problem Solver: Proposed, developed, and delivered major enhancements and rewrite of CFC-LINK product, including conversion from Dbase to Clipper, on-line help, encrypted database, authorization keys, multiple products, and several other features.

Tools:

PC Compatibles, MS-DOS 5.0, Clipper 5.2, CA-Tools, Dbase III+, Word for Windows, Brief

 

Garber Travel, Boston, MA

Mar. 1993

(Specializes in Travel and Entertainment Retail Industry)

·        Researched and built prototype upgrade from Ver 5 to Ver 6 internal Garber BBS based on Gallacticomm BBS Software.

Tools:

PC Compatibles (386&286), MS-DOS 5.0, Brief, Gallacticomm BBS Ver. 6 w/Add-Ons.

 

Grinnell Research Incorporated, Cranston, RI

Mar. 1992 - Sep. 1992

(Specializes in Commercial Pipe-Flow Systems)

·        Consultant: Enhanced internal document control library software system.  Evaluated alternative options.  Quoted alternative proposals.  Wrote additional software to add missing functionality, upgrade to Clipper 5.01, and fix bugs.  Application consisted of 5,000+ lines of Clipper code.

Tools:

PC Compatibles (386&286), MS-DOS 5.0, Brief, Clipper, Paradox, Word for Windows.

 

Ektron Applied Imaging, A Kodak Company, Crosby Drive, Bedford, MA 03101

Oct 1991 - Jan. 1992

(Ektron specializes in Imaging Equipment for Currency Inspection)

·        Technical Support: Performed PC platform system management.  Wrote 17 page proposal containing costs, merits, and demerits concerning upgrade plans for client's networked PC platform.  Upgraded PC Hardware and Software platform to work with network and become maintainable.  Wrote 5 additional operating procedure documents.

Tools:

PC Compatibles (386&286) (NEC, NCR, Datapro, Compaq, IBM, Zenith...), Cabletron, 1xxx & 2xxx series network cards, PC/NFS, Lifeline Mail & Backup, MS-DOS 5.0, Windows, Word for Windows, Excel, Grammatik, Procomm Plus, CDC Orchestrator Payroll, Schema, Viewlogic, CUPL, dV/dT, MicroTek X C for 68K, 68K X Assembler, FastCAD, Brief, McAfee Virus Utilities, Norton 6.0, Paradox 3.5.

 

Software Services of America, 790 Turnpike Street, North Andover, MA

Feb.  1991 - June 1991

(SSA was an established name in Banking Software developing software for IBM's Consumer Transaction Platform)

·        Developed Consumer Loans evaluation software for IBM CT product. (approximately 6000 lines of code) .

·        Investigated problems with CT platform.

Tools:

IBM PC,  MS-DOS,  PC-LAN,  FBSS,  CT,  Brief,  PVCS,  Polyshell Utilities (sed,  grep, ...)

 


SNAP Software, Inc., 175 Canal Street, Manchester, NH 03101

July 1991
Jan.  1991 - Feb. 1991

(SNAP is a leading vendor of Sales and Marketing Database Software)

·        Made modifications to custom reporting software.

·        Developed custom sales tracking report software package for SNAP customers.

Tools:

IBM PC,  MS-DOS,  Brief,  Btrieve,  C,  CScape,  PVCS,  Polymake,  SNAP


Employment History:

 

Group 1 Software, Inc., Lanham, MD 20706

May. 2002 - MaR 2004

(Leading Data Quality Software Products Provider)

·        Senior Consultant for Professional Services: Lead technical effort for 12 major client engagements including Columbia House, State of Arkansas, Concord Group Insurance, Lilly Software Associates, GEICO, ANICO, Starwood Hotels, as well as 23 sales support engagements including VISA; Conceived, promoted, estimated, analyzed data, designed, developed, implemented, and documented enterprise wide data-quality multi-terabyte batch and real-time data warehousing solutions; Lead team, trained staff, specified, implemented, tested, documented, developed and supported data quality solutions that included Data Quality Assessments (w/ROI), as well as the creation of initial load and ongoing maintenance of ETL solutions for star, snowflake, and ODS schemas.  Served as high profile advisor to product development on requirements for next generation data quality solutions.

·        Expert with DataSight, Dispatcher4, List Conversion Plus, Code-1 Plus (US, Canada & International), Geographic Coding Plus, GeoTax, Merge/Purge Plus, Business Merge/Purge Plus, Mailstream Plus, SortStream Canada, Generalized Selection Plus, and HotData.  Installation, configuration, and application of all Group 1 Software products.

·        Trained with Informatica, Group 1 Software product suite, “Consulting Skills”, and “Sales for Group 1 Software”.

Tools:

PCs, MS Windows 2000, MS-DOS, Sun/Solaris, MS IIS, Oracle, DB2, MS SQL Server, MS Office, Visio, Adobe Acrobat Writer, java, C, Evoke - Axio, Group 1 Software Products, Informatica, MKSNT, Net Express COBOL, Visual Basic, HTML, Unix scripting, MS Project, ERWin

 

SNAP Software, Inc., 175 Canal Street, Manchester, NH 03101

Feb. 1990 - Jan. 1991

Manager of Technical Services / Customer Software Development Manager

Managed and expanded, revenue generating, technical services department providing software development consulting and technical support services to external and internal customers.  Utilized and coordinated 8+ software  contractors and internal staff.  Responsibilities and accomplishments included:

·        Data conversion and report software development services,

·        Software development in support for strategic alliances (Money Market Directories, Computer Intelligence),

·        R&D support for temporary SNAP product workarounds

·        Support for pre and post sales activity, and

·        Responding to internal PC support requests (including Novell Netware installation).

v  Doubled revenue received from external customers.  Quadrupled workload handled by department.

v  Implemented an appropriate software engineering methodology / life cycle.

v  Quoted 90%, spec'd 70%,  and developed 40% of all custom software.

v  Department completed 60+ software engineering projects

v  Tracked projects using Timeline and Current software packages.

Tools:

IBM PC,  MS-DOS,  Novell Netware,  Banyan Vines,  Brief,  Btrieve,  C,  Carbon Copy,  Carbon Copy Express,  CCmail,  CScape,  Current,  dBase III+,  DesqView,  Fastback,  Lotus 123,  MS Excel, MS Windows,  MS Word for Windows,  Norton Utilities,  OPTech Sort,  Paradox 3.5,  PROC ,  PVCS,  Procomm,  SNAP,  Superkey,  SCAN (McAffee Assoc. virus detection s/w),  Timeline

 

Gagnon Software, Inc., Nashua, NH 03062

Feb. 1991 - Present

(Gagnon Software is an independent software consulting company specializing in contact data quality)

·        Market, sell, recruit, manage, and perform software development and data analysis services

·        Maintain company network and software infrastructure

·        Accounting

·        Develop appropriate contracts, forms, marketing literature, and business plan.

·        Research new technology, e.g. Data Quality and ETL tools, Java, CASE, Expert Systems, Linux, Informatica

·        Research and address legal, tax requirements, and business trends.

Tools:

PCs, MS Windows XP/98/NT/95, MS-DOS, Red Hat Linux, MS FrontPage, MS PWS and IIS, Visible Systems Analyst, Erwin, C++, Oracle PL/SQL, MS Access, MS Office, FoxPro, Visio, QuickBooks, Omnipage & Paperport,  Adobe Acrobat Writer, Linux

 

MODICON, An AEG Company, 1 High Street, North Andover, Mass.

Feb. 1987 - Feb. 1990

(Modicon is a leading vendor of programmable controllers; computer systems supporting analog and
 digital data acquisition in real time for commercial manufacturing and process control applications)

Senior Engineer, Software/Firmware

·        Developed software for Event Alarm Reporting System (EARS) MMI.  EARS communicates over several different types of networks (Token-Ring Modbus+, Modbus, ModbusII, Serial) to monitor the state of I/O modules in multiple PLCs, runs on an IBM PC, consists of 6,000 lines of C code, uses FlashTools windowing and dBase III+ support tools.

·        Developed software & firmware, documented, managed, tested, and controlled alpha site release of Application Executive library (AE01), loadable and ROM-based, real-time, process control software (e.g. Lead/Lag, Ramp/Soak,...).  Wrote 100 page feasibility study, 145 page functional spec., 33,000 lines of C code, 39 page test plan/procedures document.

·        Maintained firmware (bug fixing) & managed project for J892 and J812, RS232C ASCII drop (9,600 lines of code, 45 pages  documentation).  This real time, state driven, interrupt handling, embedded system performed data acquisition via OURBUS on I/O modules, communicated over 2 RS232 compatible Serial ports, processed formatted ASCII read and write operations, and communicated across HDLC link to programmable controller according to proprietary Master/Slave protocol.

·        Designed, developed, tested, documented, provided technical guidance to 3 person support team, and analyzed performance, for P892 (single board J892 replacement) and and S993 RS232C ASCII drop firmware.  Ported code from Coprocessor (VRTX  based) and from Intel "MDS Blue Box", RMX environment.  Deliverables included drops, 24,500 lines of Assembly code, 95 page functional spec.,

·        Wrote automated testing feasibility study (15 page document).  Developed testing prototype software using C and Modcom IIc.

Tools:

IBM PC,  MS-DOS,  PC/NFS,  Brief,  C,  Fastback,  Framework II,  dBase III+,  Flashtools,  Greenleaf Comm.,  Labtech Data Acquisition System,  Lotus 123,  Modcom IIc,  Norton Utilities,  PKWare,  PLM,  Polymake, Polytools,  Procomm,  PVCS,  Quicksilver dBase compiler,  Sidekick,  

 

Intel 80x8x Assembly,  984 Ladder Logic,  Modbus,  ModbusII,  Modbus+,  OURBUS,  RS-232C,  HP Serial Data Analyzer, HP Logic Data Analyzer,  Microcosm,  Oscilloscopes,  Intel MDS,  Pulse/Function Generators, 82588 lan chip,  82530 Serial chip

 

Automatix, Inc., 1000 Tech Park Drive, Billerica, Mass.

April 1986 - Dec. 1986

(Automatix is a leading edge vendor of custom vision and robotic systems supporting manufacturing and quality control operations)

Senior Engineer (Software)

·        Tested software and coordinated personnel for integration, and bug fixing activities on the Automatix/BOC flexible gaging project consisting of over 250 source files.

·        Developed statistical process control state-driven menu interface, consisting of 5,330 lines of code.

·        Developed character based graphics system for use with AYDIN terminal and Automatix controller (2,750 lines of code, 36 pages of documentation).

·        Reviewed applications software library.  Composed with committee "RAIL Software Guidelines and Conventions" document for applications software (75 pages).

Tools:

Automatix Controllers (Motorola 68K based), RAIL,  VAX/UNIX BSD 4.2,  SCCS,  NROFF

 

ITP Boston, Inc., 30 Spinelli Place, Cambridge, Mass.

March 1985 - April 1986

(ITP was a leading edge vendor of Computer Integrated Manufacturing, CIM, Software Packages)

Software Engineer / HP Systems Manager

·        Developed cell/center level, multi-tasking, factory automation application software which used interprocess communication, and consisted of:

+ System Start up /Shutdown /
   Resource management and
   Failure detection

+ System log
+ alarm monitor
+ Operating system interface

 

   User interface:

+ Dynamic status displays,
+ Cell & center control operations,
+ Part program maintenance operations

+ Editors,
+ Report generation,
+ Operator login;

+ Enhancements to
   clock/calendar processing

(114 pages of design, 31,000 lines of code),

 

·        Performed HP1000 & HP600 system management functions, e.g. backups,  hard disk reconfiguration.  Specified computer hardware requirements.  Created development support system.

Tools:

HP1000/ RTE-A, Pascal,  HP600,  VAX/VMS,  IBM PC/XT Data Flow Diagrams

 

RCA, GSD, Automated Systems, P.O. Box 588, Rte. 62, Burlington, MA

June 1983 - March 1985

(RCS GSD was a vendor of Database and Automated Testing Software Products for the Military)

Software Engineering, Member Technical Staff

·        Composed plant wide 191 page "Software Engineering Standards & Practices" document.  Merged military standards,  software engineering techniques, methodology, and conventional design /development wisdom.

·        Member of Artificial Intelligence Advisory Committee.  Reviewed expert systems with respect to C662I requirements.

·        Designed real-time, relational data base manager (MCS) for Maneuver Control Systems, military intelligence systems field application project, (174 page document).  Delivered to Ford Aerospace.

·        Modified design, coded, implemented, documented, and tested data base query subsystem of (TCAC) Tactical Command and Communications, military intelligence database systems project running in multi-tasking, overlayed, interprocess communication environment (7,000 lines of code)

Tools:

DEC PDP-11/70 RSX-11M/M+, FORTRAN,  VAX/VMS DCL,  MASS-11

 

Interactive Systems Incorporated, 131 Middlesex Turnpike, Burlington, MA

June 1982 - May 1983

(ISI was a vendor of Accounting Software Solutions for businesses)

Software Programmer

·        Developed/Maintained Purchase Order Entry, Financial Management, Payroll software product offerings, and custom application software .

Tools:

DEC  VAX/VMS DCL,  COBOL,  DEC 20/TOPS 20 DCL,  COBOL,  DEC 10 COBOL

 

Raytheon, MSD, IPS, West Andover, MA

Dec. 1979 - June 1982

(Raytheon is a large military contracting vendor of Missile Systems and other products)

Software Programmer/ Production Control Specialist

·        Developed/Maintained inventory control application software.  Submitted, Monitored, and Recovered, if encountered ABnormal END, scheduled computer jobs in production control environment.

Tools:

IBM 370/168 MVS/OS,  TSO,  Basic,  COBOL,  DYL260,  FORTRAN,  JCL,  PL/1,  ROSCOE/RPF

 

Education:

University of Lowell, 1 University Ave., Lowell, Mass.
Graduated 1983, BSCS, Cum Laude, Recipient of Dean's Award in Computer Science
College
of Computer Science - completed 20% towards MSCS
Continuing Education - completed 70% towards ASME

 

RED HAT Training, 1801 Varsity Drive, Raleigh, NC
RH133 RedHat Linux System Adminstration
RH253 RH253 Red Hat Linux Networking and Security Administration

 

Ab Initio                                                                                 Informatica, PowerCenter 6 Basics

 

Trillium & Trillium DQ Connector for SAP

 

Additional Information:

Past Professional Affiliations:                                    NHHTC (NH High Tech Council)
SWANH (Software Association of New Hampshire)        New Hampshire Free Lancers

Military Experience:
Military Police Co. 26th Div., Comm. Armory, Boston, MA                      Oct. 1978 - Sept. 1979
            Military Policeman (Reserve Duty) - Sgt.
A Troop 3rd/5th Calvary, Ft. Lewis, Wash.                                             July 1975 - June 1978
            Radio Operator (Active Duty) - SP4.
HHC 2nd/75th Rangers Infantry, Ft. Lewis, Wash.
            Morse Code Radio Operator (Active Duty) - SP4.

Previous Security Clearance Held:     TS/SBI

References: Letters of Reference can be made available upon request.


Member number: 6943
Additional Contact information is available on the Profile Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 2009 Software Contractors' Guild, 3 Country Club Dr, #303,Manchester NH USA 03102