Mike Gagnon 22 Cherokee Avenue

Nashua, NH 03062-1847

(603) 889-3550 fax x11 12/20/2007 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, 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), 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:

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 2006-DEC 2007

(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.

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: