SUMMARY:

Over 20 years experience with large, complex development projects, and leading projects to successful and timely completion. Specific experience includes:

• Hands-on leadership of successful, on-time projects.
• Extensive experience in business and technical aspects of Data Warehousing and big data.
• Strong experience in Netezza, Informatica and DataStage ETL/ELT tools.
• Experience with a wide variety of platforms, languages, tools, applications, and machines,
• Instruction and mentoring of DW development staff.

CERTIFICATIONS:

• IBM Certified Specialist: Netezza Performance Software
• IBM Certified Solution Developer: InfoSphere DataStage 8.5
• IBM Initiate Master Data Service Technical Mastery
• IBM Infosphere Big Insights Technical Mastery

EXPERIENCE:

Confidential September 2011 – present
Netezza / Cyber security Analysis Consultant
DHS has an extensive cybersecurity/malware tracking and analysis program, on which General Dynamics is the prime contractor. Worked on tools, methods, and programs to build, replicate, analyze and report on multi-terabyte data warehouses of network traffic snapshots and malware tables. Used Netezza TwinFin DW appliances to search 5-to-20 terabyte tables with subsecond response times. Developed methods to statistically simulate very large malware tables. Provided Netezza consulting experience, analysis, design and implementation expertise to the malware archiving and analysis project, as well as other projects within the DHS / GD cybersecurity effort. Tools: IBM/Netezza Twin Fin Version 6, PostgreSQL, Linux.

Confidential, Merrimack NH March 2011 – August 2011
Netezza Consultant
Fidelity’s Fixed Income group is implementing a Monte-Carlo simulation system for measuring risk in large fixed-income portfolios. Consulted, designed, and implemented modules at all levels of the application, including data movement, calculations, transformations, and caching. Mentored Fidelity staff on Netezza and SQL best practices and performance tuning. Wrote and edited extensive documentation of statistical and transformation modules. Tools: IBM/Netezza Twin Fin Version 6, Netezza iClass, Linux

Confidential, Merrimack NH April 2010 – February 2011
Netezza Consultant
Fidelity is porting a number of their Oracle-based financial data warehouses to Netezza Twin-Fins. Consulted with several groups in Fidelity on Netezza DW architecture, disaster recovery, performance, workload management, and security issues. Designed, documented, and implemented disaster recovery, auditing, and monitoring and maintenance systems. Mentored Fidelity staff and gave web presentations on relevant Netezza technologies. Tools: Netezza Twin Fins, Linux, Informatica.

Confidential, Tyngsboro, MA February 2010 – present
Netezza Development Consultant
Design and development of functions to extend NZSQL, supporting Oracle-to-Netezza Twin Fin port. IQ Associates partners with Netezza to develop new NZSQL functions with the capabilities of special SQL functions that are part of the SQL versions of major RDBMS systems such as Oracle and SQL Server. IQ Associates’ clients are firms that are porting databases and data warehouses from traditional RDBMS platforms to Netezza DW appliances. Tools: Netezza Twin Fin, GNU C++ development environment, Eclipse.

Netezza Training March – April 2010 
Completed Netezza Data Warehouse Appliance Usage 5.0 and Netezza Appliance Advanced Concepts 5.0 certification courses. Courses cover appliance architecture, high availability, database administration, performance optimization, system tuning, workload management, and troubleshooting.

ConfidentialDetroit, MI August 2008 – March 2010 
ETL Architect
In a major information consolidation effort initiated by senior management, GMAC has undertaken a five year plan to bring all of their disparate business intelligence systems under one umbrella, called the Enterprise Data Warehouse (EDW). GMAC and Clarity have chosen ValueCap to staff and lead the architecture and development effort for this initiative. Responsibilities include architecture design, infrastructure requirements and planning, capacity planning, developer training, hardware planning, system installation, security, and tool selection, and all aspects of data warehouse planning and construction. Project uses Oracle 10g, Oracle Access Manager, Sun One WebServer, Weblogic 9.2 application server, HP Superdomes, IIS 8.1, Cognos 8.

ValueCap Systems/ IQ Associates, Confidential MA / Various Clients 2005 – ongoing
Developed and taught courses in ETL tools -- Informatica and IIS / DataStage. Clients included Knightsbridge Consulting, Hewlett-Packard Information Management Practice, ICC, and Assurant Health. Taught over 20 one-week courses since 2005.

Confidential, Columbus, Ohio February – March, 2008
Assessed ETL / Netezza environment for Abercrombie and Fitch, a clothing retailer. Abercrombie has a real-time business intelligence system that provides information to senior management as well as store managers. The system uses both WebSphere DataStage EE v. 8, DB2 / MF, and Netezza. Assessed Abercrombie’s ETL environment, including software development practices, code migration practices, configuration management, skills of ETL staff, and use of DataStage EE.

Confidential, Chicago, IL and Dallas, TX February – August, 2007
Principal Consultant, ETL/ Data Warehousing
Health Care Services Corporation consists of the Blue Cross / Blue Shield organizations in Illinois, Texas, Oklahoma, and New Mexico. HCSC also provides claims processing services for other BCBS organizations throughout the United States. Worked on matching HCSC’s business needs to technical requirements. Designed and wrote ETL jobs to implement and test a new data warehouse used for claims adjudication. Managed development of Custom C++ code for detailed source and target table comparison and monitoring data integrity. Instructed and mentored development staff on custom operators and other advanced DS topics. Developed DS shared containers to handle complex lookup tasks and promote software modularity. Technologies: Informatica 7.1, DataStage EE 7.5, IBM AIX, DB2.

Confidential (formerly National Association of Securities Dealers), Rockville, MD January, 2007
Data Warehousing Consultant
Consulted with senior FINRA business representatives and technical staff, designed and wrote software to implement an innovative high-volume, high-performance securities trade-tracking system which used DataStage EE and Netezza Performance Server. This project involved extensive investigation of performance issues involved in combining Oracle, DataStage, and Netezza capabilities. Technologies: DataStage 7.5, Solaris parallel servers, Netezza DW appliances and software, Oracle and DB2

Confidential, Beverly, MA June 2006-January, 2007 
Data Warehousing Consultant, DW Architect
Following the recommendations contained in ValueCap’s assessment (see below), EIC undertook a complete re-architecting of their Data Warehousing environment. EIC selected ValueCap as the vendor to build the Homeowners Data Mart, which forms the foundation for all of EIC’s future DW development. Managed the project, hired additional consulting resources, interviewed business representatives to determine business meaning of data fields, analyzed sources, collected requirements, evaluated and developed SDLC standards, developed ETL designs, and performed or supervised all aspects of enterprise data mart development. Technologies: Informatica PowerCenter 7.1 and 8, Business Objects 5.1.6 and XI, SQL Server 7 and 2000, MS Access, VBA.

Confidential, Charlotte, NC March-April, 2006 
Data Warehousing Consultant
Performance enhancements, maintenance, and bugfixes on ETL code for loading the Maersk data warehouse. Consulted on plans to move ETL code base from DataStage Server Edition to DataStage Enterprise Edition. Technologies: Windows Server, SQL Server, DataStage Server edition

Confidential, Beverly, MA October-November, 2005 
Data Warehousing Consultant
Performed assessment of the EIC data warehousing environment. Evaluated procedures, skills, architecture, technology infrastructure, and tools. Conducted extensive (over 45) interviews, from individual contributors to C-level management, to analyze gaps and make recommendations for technology, best practices, training, and organization. Compiled extensive documentation, and presentation for senior management. Technologies: Informatica PowerCenter 7.1 and 8, Business Objects 5.1.6 and XI, SQL Server 7 and 2000, MS Access.

Confidential, Hartford, CT 2004 to 2005
DataStage Architect
Performed overhaul and extension of a DataStage-based data integration system. Worked with business representatives to translate business needs into technical requirements. Managed upgrade of DataStage PX from 6.0 to 7.5. Managed development team to re-engineer PX jobs based on business requirements. Conducted Advanced DataStage PX training for Hartford Life Employees. Technologies: Ascential DataStage PX 6.0 to 7.5.

Confidential, St. Louis, MO 2004
DataStage Architect (employed by Knightsbridge Solutions)
Architected, designed, and developed the A. G. Edwards operational data store. Gathered and analyzed requirements, produced data mappings, analyzed and documented data sources. Specified and documented production procedures, wrote the Production Support Agreement. Produced and gave presentations on ETL architecture and production issues. Technologies: Ascential DataStage Server 7.x.

Confidential, Morris Plains, NJ 2004
Data Warehousing Consultant (employed by Knightsbridge Solutions) 
Assessed the Pfizer CHC data warehousing environment. Conducted extensive interviews of business representatives to understand gaps between business needs and DW capabilities. Recommended changes to meet business needs, avoid data proliferation and siloing, improve maintainability, and conform to DW best practices.
Technologies: Informatica, Oracle

Confidential, Minneapolis, MN 2003
DataStage Consultant
Working through Ascential Software’s consulting organization. Provided Wells Fargo with tools used to port legacy DataStage PX 6.x/7.x/Orchestrate software to new hardware platform. 
Technologies: Ascential DataStage PX, Orchestrate, UNIX scripting, Perl, SQL.

Confidential, Arlington, MA 2003
Consultant, Java Software Architect
Accordare markets Reflector, a tool for monitoring and validating XML-based business-to-business transactions. Added to Reflector the ability to parse and validate XML embedded in MIME multipart messages and SOAP messages, enhanced the monitoring GUI. Wrote software to adapt the Reflector for use as an electronic document qualification system. Technologies: Java servlets, XML, MIME messaging, SOAP, HTTP, inter-process communications, Tomcat and other J2EE tools.

Confidential, Minneapolis, MN 2003
DataStage Consultant
Working through Ascential Software’s consulting organization, advised two groups within Target’s IT organization on optimal use of DataStage Parallel Extender for building data warehouses to do data mining and scoring of Target’s customer base. Based on advice, one group undertook a half million dollar hardware upgrade. Technologies: DataStage PX, UNIX shell programming, SQL, C

Confidential (formerly National Association of Securities Dealers), Rockville, MD 2002
ETL Consultant
Designed and implemented the “Vista Summaries” ETL system to summarize stock trading data, for the purpose of detecting illegal trading activity. Used DataStage Parallel Extender/ Orchestrate, SQL, and UNIX shell programming. The project was implemented on a Solaris box with four processors and an Oracle DB. Technologies: DataStage PX, Orchestrate, SQL, UNIX shell programming, Oracle 9i.

Torrent Systems/Ascential Software, Westborough, MA 2000 – 2002
Manager, Advanced Development
Hands-on manager of engine development for Orchestrate, Torrent’s high-performance computing framework, and integration of Orchestrate with DataStage, Ascential’s data integration platform. Orchestrate is written in C++ and Java, runs on all major UNIX platforms, and supports Windows clients. Led integration of Torrent Orchestrate and Ascential DataStage engines, following Ascential’s acquisition of Torrent in November 2001.

Led the DataStage/Orchestrate engine group, comprised of 9 engineers and two tech writers. Development and maintenance of kernel of DataStage, a platform for enterprise application integration, data integration, and ETL. New development included adding Unicode support, porting the kernel to Windows, and supporting Web Services.

Confidential 1995 – 2000
Waltham, MA
Project Manager/System Architect
Managed, architected, designed and implemented software for distributed, voice-enabled application systems. Utilized RAD tools, CORBA, COM/DCOM, ActiveX, and XML. Coded in Java using Visual J++ and Visual C++/ MFC on Windows NT and C++/QT on Linux. Projects included:

• BabelChat: Led a team of engineers to develop a multilingual chatroom incorporating speech recognition, speech synthesis, TTS, machine translation and animated avatars,
• Physician’s Assistant for Continuous Transcription and Structure (PhACTS): Directed a team of engineers that built PhACTS, a voice-enabled medical reporting application that allows physicians to dictate medical reports, using natural speech, and automatically structures the document in XML using natural language processing,
• NIST-MED: Architected and developed an ISR voice-enabled, structured medical reporting system. Utilized RAD methodology and tools, CORBA, ActiveX, distributed object technologies, SGML, HTML, object-oriented design and development, object-oriented databases.

Independent Software Consultant 1994 – 1995
Developed Software in Visual C++/MFC under Windows.
Designed and developed an information-retrieval system used to produce a hypertext publication for a big-six accounting firm in a Client Server environment. The system enables a richly linked HTML document to be automatically generated from source documents. Coded in Visual C++/MFC under Windows (Context Media – Boston, MA). Developed C++ routines for a real-time multi-channel noise-canceling system under US Army and NASA Small Business Innovation Research contracts. Coded in Visual C++/MFC under Windows. Signal Separation Technologies – Annandale, VA.

International Media Research Foundation, Tokyo, Japan 1992 – 1994
Principal Researcher, Senior Research Administrator
Designed and coded client software for a sound understanding software environment. Utilized DSP, Sound Source Separation, Auditory Scene Analysis, Spectrograms, digital filtering and synthesizing. Supervised 6 software developers investigating media technology issues involving perceptual modeling, education, design, and mathematics. Developed software to explore parallels between sound source separation and other perceptual modeling systems. Designed and coded a Macintosh-based audio editor with time and frequency-domain editing capabilities including the GUI. Ported freeware UNIX server software from IRIX to Ultrix.

Confidential, Cambridge, MA 1986 – 1992
Research Assistant
Completed doctoral thesis on the emulation of human rhythm perception. The thesis project was a program that tracked the rhythm of live musical performances. Applications of this work include automatic transcription, synchronization, and multimedia editing systems. Ported a very large knowledge base (Cyc) from Symbolics Lisp Machines to Macintosh. Developed a Mac-style editor/interface. Consultant for Cyc Project, MCC and Thinking Machines, Inc. – Summer, 1990. Developed programs to implement new methods of text compression in an MPP environment for a Document Retrieval System.

TECHNICAL SKILLS:

• Databases: Oracle, SQL Server, DB2, Teradata, MS Access, Netezza Cluster Technologies: Hadoop, Map/Reduce
• ETL Tools: Informatica Power Center, DataStage/QualityStage Server and PX/EE Reporting Tools: Business Objects
• Languages: C, C++, SQL, PL/SQL, COBOL, Java, JavaScript, Visual Basic, Visual C++, Visual J++, HTML, XML, JavaBeans, J2EE, ActiveX, Python
• Shells/Scripting: Bourne, C, Korn, Bash, PERL, TCL, Python
• Utilities: ClearCase, UNIX Shell Scripting, eXceed, ODBC, Emacs
• Hardware: Sun, HP, Compaq, IBM, SMP MPP, Netezza
• OS: AIX, UNIX, HP-UX, Linux, Sun Solaris, Windows

EDUCATION:

Confidential, Ph. D. Media Arts and Sciences, Confidential Media Laboratory

Confidential, BA, MA, Mathematics, Graduated summa cum laude, with high honors in Mathematics.