Data Architect, Data Warehousing Architect, ETL/Informatica Architect

Isaiah (Yeshayah) Artsy

** ************ *****

Nashua, NH 03062-2468

H & O: 603-***-**** Mobile: 603-***-**** email: ******@*****.***

CAREER SUMMARY:

Long experience in software design and development including products, infrastructure services, operating systems, applications, and integrated solutions at the enterprise and departmental levels.

Architecture roles: solution architect, product architect, Information/data architect (enterprise/departmental levels), data warehouse system architect, ETL/data migration architect, requirements architect, Data Modeler.

Technical development roles: developer, designer, modeler, project manager.

Recognized multiple times for innovative yet pragmatic designs and solutions; holds 3 patents.

Managed/mentored 2-14-person teams, managed various projects spanning 3-15 months

Extensive experience in full life-cycle software development, using various leading methodologies.

Technology expertise in Databases, Data Warehousing, Data / Process Modeling, Metadata Management

Extensive experience and skills in project management, business analysis, facilitation, leading requirements gathering and analysis, managing diverse stakeholders. OOAD (Object-Oriented Analysis & Design), Distributed Systems & Applications

Versatile, worked in different environments – product, research, advanced development, and consulting; with various companies – small startups, mid-size companies, and large enterprises.

Diverse industry experience, primarily Finance and Insurance, but also Pharmaceutical, Media, Engineering.

International experience – in addition to USA, worked in Israel, and with partners in France, UK & Ireland. Proficient in English and Hebrew, working knowledge of French. USA Citizen. Eligible to work in EU.

Strong analytical, communication, presentation, and facilitation skills

Positive ‘can do’ attitude, enthusiastic yet practical: “if it’s worth doing, we can do it! Follow me!”

Open to International contractual positions outside of USA (as well as in USA).

EDUCATION:

Ph.D. Computer Science, 1987, Univ. of Wisconsin-Madison; thesis: “A study of Fully Open Computing Systems” – designed open, customizable, client/server operating systems.

M.Sc. Computer Science, 1986, Univ. of Wisconsin-Madison; GPA 3.95/4.0.

MBA (MIS major) + BA Economics, 1981, Tel-Aviv University, Israel; graduated with honors.

CONSULTING CLIENTS – SOLUTION PROJECTS EXPERIENCE:

Developed solutions or consulted for leading companies in various industries:

Finance: Fleet Bank (Metadata Management for a DW project); Citibank (World-wide DW Design); JP Morgan (HR Data Mart, Investment Data Marts, HR DW); Morgan Stanley Dean Witter (Fund Management Web-based DW/Mart); Manulife Financial (Data Mart, Data Migration); Bank of America (IT long-term strategy, Information & Metadata Architecture); Fidelity Investments (Marketing DW, Institutional Investment DW Data Model, Data Integration Strategy, MDM/Reference Systems, Compliance DW, HR Enterprise Data Integration & Re-Engineering, Data Movement/Integration Center of Excellence, Employee Compliance, Data Integration, PaaS – Platform as a Service)

Insurance/Health Care: The Hartford/Hartford Life (Disability Data Mart; OFAC control system; ETL system; BI Application; Enterprise Data Warehouse); Liberty Mutual (Personal Market EDW); Harvard Pilgrim Health Care (EDW, Multi-Company Data Migration/Integration); Hanover Insurance (Property Insurance Applications); WellPoint (Health Insurance, enterprise and product integrated solutions)

Media/Services: Hearst (Sales Data Mart, Accounting/Marketing DW); Rohm and Haas (content distribution website); Oakleaf Waste Management (Services, Profitability, and Communication Warehouse); Premiere Global Inc (communication/telephony data warehouse)

Engineering: Semiconductor: Helix Technology (Equipment control distributed DW); Jet Engines: Pratt & Whitney (Engine utilization/maintenance DW); Helicopters: Sikorsky (HR Data Integration)

Pharmaceutical: Johnson & Johnson (Clinical Trials DB); Bayer Instruments (DW/ ETL Architecture)

RFID/Supply-Chain: OAT Systems (Enterprise RFID application, DW/BI product, customized ETL)

CORE ARCHITECTURE/DESIGN SKILLS:

Used extensively the Kimball and Inmon DW design and modeling methodologies, and variants thereof

Familiar with and used various development methodologies such as Agile/Scrum, RAD, RUP, IE, and PMI Framework (and formerly also OOSE, OMT, Shlaer-Melor, Yourdon SSAD methodologies).

Used and customized OOA UML/Use Case-based requirements gathering, analysis, and modeling

Familiar with and supported SOA, J2EE, and event-driven application architectures

Extensive experience (> 15 years) in modeling databases, service interfaces, canonical models, and info flows at an enterprise and single-system scope, at the conceptual, logical, and physical levels

CORE SOFTWARE and TOOL SKILLS:

Databases: Oracle 7/8i/9i/10g/11g, DB2, MS SQL Server 7/2000/2005 (also Sybase 11, PostgreSQL)

Programming/Development Languages: SQL, PL/SQL, T-SQL; PERL; XML, XSD, UML; C/C++, Java

ETL/BI tools: Informatica Power Center 3.5/5.2/6/7/8.1/ 8.5/8.6/9.1/9.5/9.6.1, Business Objects Data Integrator 11.5, OBIEE 11g, SQL Server 2005 Reporting, Integration and Analytical Services, Business Objects, Cognos Power Play, Microstrategy

DB/Modeling tools: Power Designer, ERwin + ModelMart/Manager, XMLspy, SQL Navigator, TOAD, Enterprise Manager

PROFESSIONAL WORK HISTORY:

ARTSY Y-CASE Inc. Nashua NH, November 2001-Present – Owner, Principal, Chief Architect

Have provided software development and technical leadership services to >2-dozen projects

Have designed and rapidly developed sophisticated solutions as pragmatic, easy-to-manage systems.

Filled the roles of Information and Data Architect & Modeler (enterprise and single-system level), Data Warehouse (DW) Architect, ETL Architect, Tech-Lead, and Sr. Developer

Worked with top management (SVP, CTO, CIO), client directors and program managers, project managers, peer architects, and developers; managed and mentored junior team members.

Focusing on Database/Data Integration solutions and Business Intelligence / Data Warehousing solutions.

Specific Projects, Roles, and Responsibilities:

Sikorsky Aircrafts (Stratford, CT), Sept 2016-Present, Sr. ETL Architect, Informatica Specialist: Review/Re-architect HR Data Integration/Migration subsystem; architected, designed and hands-on coded an auto data validation/testing system[Informatica Power Center 9.6.1, Oracle 11g, PL/SQL].

Fidelity Investments (NH & Ireland), March 2014-Aug 2016 - multiple projects - Sr. ETL & Data Architect: Data Quality/Testing/Enhancing and help bring to Production the ETL system I architected for HR Enterprise MDM, Design/Hands-on develop extensions; Design, Model and Implement enterprise Audit-Balance-Control (ABC); Data standardization, modeling, and governance; Informatica templates; Training Jr. developers/QA, Migrate/Enhance ETL from multiple sources and Web Services API/RESTful API into a Data Warehouse; Migrate to and Contribute to an Enterprise Data Integration Platform as a Service (PaaS) [Informatica Power Center 9.5, Power Center 9.6.1, REST API, Power Designer, Oracle 11g, PL/SQL]

Fidelity Investments (RI), Nov. 2013-March 2014, Sr. Data Modeler: Enterprise Data Integration System – Employee + Financial Trading Compliance, Conceptual/Logical modeling and data integration, data standards & governance [Power Designer, Oracle 11g, PL/SQL]

Fidelity Investments (NH), July-October 2013, Sr. ETL Architect: Designed an Enterprise Data Movement/Integration Center of Excellence; developed a Reference Architecture, Shared Objects, Data Quality, Audit-Balance Control (ABC) [Informatica Power Center 9, Oracle 11g, PL/SQL]

Fidelity Investments, (NH) Aug. 2012-Aug. 2013, Sr. ETL Architect & Tech Lead: Responsible for the ETL Architecture, Design, and hands-on development of a complex HR system data integration, QA/Validation), MDM-like services; actively contributed to the data model and requirements analysis, data stds & governance [Informatica Power Center 9, Oracle 11g, PL/SQL]

Fidelity Investments (NH-MA), April-Sept. 2012, Sr. Data/ETL Architect: & Tech Lead Responsible for the ETL/Data Architecture, Design, and hands-on development of 1st phase of an enterprise Compliance & Risk Forensic Testing DW; contribute to the overall architecture and OBIEE implementation [OBIEE 11g, Oracle 11g, PL/SQL, Informatica Power Center 9, MS-Access, Agile/Scrum development]

Fidelity Investments (RI), Oct. 2010-April 2012, Sr. Data Architect: Led and participate in the design of a multi-phase enterprise MDM/Reference system and a trading-automation system. Responsibilities included Data Modeling (conceptual, logical, physical), ETL Design and hads-on development in PL/SQL; Data analysis, Consolidation & Integration of > dozen source systems; Support of XSD design; Help BA's with requirements gathering & analysis [ERwin, Power Designer, XML Spy, XSD, Oracle 11g, PL/SQL]

WellPoint, Sept. 2009-Aug. 2010, Enterprise Information Architect (+ Project Data Architect): Responsible for Enterprise new initiatives’ data and flow architecture & design, including canonical model, conceptual and logical data models, data layouts, mappings. Led data integration, and data quality and governance [ERwin, Power Designer, XML Spy, XSD, Canonical Model]

Hanover Insurance, Apr.-Sept. 2009, Data Architect: Responsible for Database and Web Service/XML XSD architecture, design, and implementation supporting new/re-engineered Property Insurance applications; worked with and contributed to a company standard canonical model [DB2, ERwin, XML Spy, XSD, WSDL, ACORD, Canonical Model].

Hartford Life, Aug. 2007-May 2009, ETL Tech Lead/Architect (and Data/Metadata Architect), for a multi-phase, enterprise Data Warehouse: designed all aspects of the system architecture across multiple staging subsystems, lead a team of 5-13 developers, worked closely with client’s BA’s and DBA’s, hands-on developed critical & complex ETL components and functions, QA Auto-Testing processes, as well as templates for developers; mentored junior developers [Oracle 10g, Informatica Power Center 8.1 & 8.5, TOAD, ERwin, PL/SQL, Kalido].

Fidelity Investment, Mar.-June 2008 (concurr.), Sr. Data Architect/Logical Data Modeler on 2 initiatives: 1) integrated data warehouse supporting institutional investment asset mgmt; 2) enterprise strategy & technical roadmap for customer data integration [Power Designer 12]

Fidelity Investment, June-Sept. 2007, Sr. Information/Database Architect, a revamped Marketing DW development project for supporting retirement services reporting, analysis and campaign management: Responsible for data modeling and database design, helped with ETL and overall project architecture [Oracle 10g, Power Designer, Informatica Power Center 8.1];

Concurrently: Premiere Global, ETL/Informatica Tech Lead/Developer on a Communication/ Telephony Data Warehouse [Oracle 10g, Informatica Power Center 8.1, TOAD]

Oakleaf Waste Management, Jan.–July 2007, Data/Database & Business Requirements Architect (and de-facto Data Warehouse Architect) for a multi-phase data warehouse project for supporting Service, Profitability, and Communication reporting and analysis; responsible for the back-end architecture, design, data modeling, and hands-on database/ ETL development, helped with project management, requirements gathering and analysis, performance tuning and testing [MS SQL Server 2005 database and ETL/Reporting Services, T-SQL, ERwin]

Harvard Pilgrim Health-Care, Dec. 2006–Jan. 2007, Sr. Logical Data Modeler in a Enterprise Data Warehouse, multi-company data migration integration [Oracle 9i, Teradata, ERwin]

Pratt & Whitney (UTC), May–Nov. 2006, Architect, Designer, DB + ETL implementer of a jet engine utilization and maintenance DW: responsible for system/solution architecture, design and ETL development; helped with requirements analysis, database design, ETL hands-on coding and testing [Oracle 9i, Oracle 10g, TOAD, Erwin, Business Objects Data Integrator 11.5]

Liberty Mutual, Dec. 2005–May 2006, Application Architect & ETL Lead in an Enterprise Data Warehouse project: Responsible for the ETL Architecture & design, helped with the overall DB and system solution architecture, lead the business analysis and development team [DB2, Teradata, Microstrategy, Informatica Power Center 7, ERwin]

Bank of America (CRM Group), Aug-Dec. 2005, Sr. Database & BI Architect: Information & Metadata solution Architecture and IT Strategy; worked with BoA staff to define requirements and alternate solutions [Oracle 9i/10g, Microstrategy, PowerDesigner, Service Oriented Architecture, Visio]

OAT Systems, July 2004–Aug 2005, Sr. Database, BI, and Product Architect: Worked closely with the CTO & VP Engineering, helped specifying the next generation RFID-EPC software products and customized solutions, provided database and business intelligence architectural expertise in support of various database/BI projects; also performed and lead overall system design; database modeling; database & ETL processes hands-on implementation, testing and optimization; analytical and reporting applications design and implementation [Oracle 9i, SQL Server 2000, PostgreSQL, TOAD, SQL Navigator, PL/SQL, Cognos Power Play, Cognos ReportNet, Microstrategy, RFID middleware, Erwin 4, PowerDesigner, Windows XP]

ManuLife (John Hancock), April-July 2004, Sr. Database/ETL Architect and Tech Lead: Involved in Oracle-to-SQL Server migration, re-engineering Data Mart systems, converting legacy ETL scripts to Informatica Power Center [Oracle 9i, SQL Server 2000, PL/SQL, T-SQL, Informatica Power Center 6.2, Enterprise Manager, TOAD, Erwin, Model Mart]

Johnson & Johnson, Jan.–April 2004, Sr. Database and ETL designer/implementer, developing a new portal-based, globally accessible Clinical Trials Registry based on new European standard; also proposed corrections/improvements to the standard [Oracle 9i, Informatica Power Center 6.1, PL/SQL, Erwin 4, Epicentric, HP-UX]

Hartford Life, Jan. 2002–Feb. 2004, DB and DW Architect, Data Modeler, ETL Designer and Developer on multiple initiatives:

1) led ETL + DB design and development effort (incl. data modeling, hands-on programming, testing, tuning) of a Disability Insurance Data Mart/ Warehousing project, designed and developed an ETL auto-testing facility and helped with project management; turned a 3rd-party failing project into a success, reducing significantly budget and time. [HP-UX /Windows, Oracle 8i, ERwin, SQL NAV, PL/SQL, Informatica Power Center, Business Objects].

2) Designed and implemented a fully automated ETL + file management and control client system for a security compliance (OFAC) system, helped with project management, requirements gathering and analysis [Oracle 8i, ERwin, Informatica Power Center, SQL NAV, PL/SQL, FTP, PERL, UML]. My novel design/implementation reduced project budget by about 42%.

3) As a senior ETL designer and developer, helped a Data Warehousing project, integrating legacy and new insurance claims systems [Oracle 8i/9, Informatica Power Center, PL/SQL].

4) Architected, designed, and implemented an automated DB/ETL facility to extract, calculate and refresh sophisticated Disability Insurance normative/statistical information [Oracle 8, Informatica Power Center, PL/SQL, ERwin].

Concurrently, South Connecticut State University, Sept. 2002–May 2003, Adjunct Professor, Computer Science Dept.: Taught fundamental data structures and algorithms (BA); advanced database design and implementation (MA).

Foliage Software Systems, Burlington MA, Dec. 2000-October 2001 - Engineering Director

Participated in Engineering Management, including planning, staffing, and recruiting.

Project Manager and architect/data modeler on a Data Warehouse for analytical and operational applications monitoring and diagnosing semiconductor equipment for Helix Technology, the world leader in developing semiconductor fab equipment

Helped the design and provided technical contributions to a project developing a Distributed Data Collection System from semiconductor fabs

Context Integration, Manhattan NY (Jan. 1998-Feb. 2000), Burlington MA (Feb.-Dec. 2000)

Technology Manager and Director of Web Business Intelligence

Helped define technical direction/partnerships for Web Business Intelligence

Managed and provided technical leadership to 2 web-development (B2B) projects:

oWeb-based int’l financial fund analysis and decision system

oWeb-based paint & decoration information and trading system (design patented)

Managed 5 Web Business Intelligence projects (web-enabled Data Warehouse/Data Mart, OLAP), on which also filled the roles of architect, data modeler, or back-end developer.

oA data mart and a web-based sales analytical system + a sales/marketing/accounting DW

oAn HR data mart and analytical application + a “renovated” HR data warehouse

oA revised data mart for investment banking and equity asset analysis

Provided guru support to other projects and practices in DW, Enterprise modeling, and BI

ARTSY Y-CASE, Nashua NH - Principal; and Parallogic, Inc., VP Technology; 1996-97

Led and participated in 3 data warehousing and metadata management projects

oA metadata management subsystem of a new financial/marketing data warehouse

oA data warehouse for testing/simulating diagnostic blood analyzers & metadata facility

oOverall architecture and technical strategy of a global, geographically dispersed DW.

Helped Parallogic define technical direction and establish partnerships.

Bull Worldwide Information Systems & Transtar Software Billerica MA & Paris France

Chief Technology Officer (CTO) & VP Technology, Transtar Software, July 1994-May 1996

Defined technical/strategic vision, responsible for the overall products architecture and its metadata models; helped marketing and sales in USA and France.

Collaborated with Engineering and helped the development teams with product designs.

Worked w/international partners to develop innovative metadata products & models.

Represented Transtar in conferences, partnership discussions, and standards committees

Senior Architect, CASE Repository Group, Bull, Jan. 1993-July 1994

Led architecture specification of the initial product (metadata repository for CASE tool integration), contributed to product design,, metadata model

Represented Bull in conferences and standards committees

Digital Equipment Corporation, Littleton MA and Nashua NH

Project Leader, Software Development Environments, Nashua NH, Jan. 1991-Dec. 1992

Managed the Repository Information Model product definition and development

Contributed to DEC Repository and related standards committees

Principal Software Engineer, Distributed Sys. Advanced Dev., Littleton MA, 1987- Dec. 1990

Participated in and co-led the architecture, design and hands-on developed object-oriented, distributed applications and infrastructure services (granted 2 patents)

OTHER PROFESSIONAL ACHIEVEMENTS:

3-dozen technical articles/presentations in professional journals and conferences.

2 USA and International patents in the area of distributed object-oriented systems:

“Locating mobile objects in a distributed computer system,” patent 5325524, issued 1994, http://www.patentstorm.us/patents/5325524.html

“Routing objects on action paths in a distributed computing system,” patent 5701484, issued 1997, http://www.bigpatents.com/pnum/5701484

1 patent in the area of interactive web-based design and coloring, 2000-1 (“Interactive Decorating System,” patent # 200123674 - http://www.freepatentsonline.com/200********.html. or http://www.wipo.int/pctdb/en/wo.jsp?wo=200*******

Contributed to a patent for designing data warehouse and metadata-based ETL system (“Method and Apparatus for Automatically Populating a Data Warehouse System,” patent 6167405 - http://www.patentmonkey.com/PM/patentid/6167405.aspx

Contact this candidate