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 - most recently Agile-Scrum, DV2.0 (Data Vault 2.0).
• Technology expertise in Databases, Data Warehousing, Data / Process Modeling, Metadata Management
• Extensive experience and skills in project management, business/system analysis, facilitation.
• Recent experience with DB/DW design & dev on AWS, RDS, & Redshift and ETL using Talend Open Studio.
• 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.

TECHNICAL SKILLS:

Databases: Oracle 7/8i/9i/10g/11g, AWS/Redshift, DB2, MySQL, MS SQL Server, (also Sybase 11, PostgreSQL); Hive;

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, Talend Open Studio, OBIEE 11g, SQL Server 2005 Reporting, Integration and Analytical Services, Business Objects, Cognos Power Play, Microstrategy; Podium Data Marketplace, WhereScape;

DB/Modeling tools: Power Designer, ERwin + ModelMart/Manager, E/R Studio, Data Vault 2.0 Modeling & Methodology, XMLspy, Oracle SQL Developer & Modeler, SQL Navigator, TOAD, Enterprise Manager

PROFESSIONAL EXPERIENCE:

Confidential, Nashua NH

Owner, Principal, Chief Architect

Responsibilities:

• Confidential Business and System and Data Analyst for a health analytical & reporting services group, responsible for requirements gathering, analysis, design, and hands-on development ETL Code & testing MSSQL, T-SQL coding, WhereScape
• Sr. Warehouse / ETL Architect: Helped with DW/ETL Architecture, design and prototype hands-on development for various POC and RFP solutions, tool evaluation AWS, AWS/RDS, MySQL, AWS/Redshift, Data Vault 2.0 Design, Modeling & Dev., REST API, Oracle 11g, Oracle SQL Developer, Oracle SQL Modeler, JSON, SQL coding
• Data Engineer (effectively ETL Architect/developer) for a Data Lake Data Mart, data integration of dozens of sources (consumer and commercial loans, mortgages, credit/debit cards, brokerage and saving accounts, etc.) - including design and hands-on development of workflows, help with Dimensional Data Modeling and testing Podium Data, SQL, Hive, Pig Latin
• Data Engineer (effectively Requirements architect, Data Architect & modeler & developer, ETL Architect & developer for a cloud-based Data Lake & flexible Data Warehouse for B2C Reporting, including Data Modeling, Database & ETL hands-on development, testing, managing and mentoring junior resources, and support for reporting AWS/Redshift, Data Vault modeling/development, SQL, E/R Studio, Aginity, SQL Workbench/J, JSON modeling and ingestion, Highly Agile process, Talend Studion, SAP Hybris
• Sr. 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 .
• 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; 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, JSON, Power Designer, Oracle 11g, PL/SQL
• Enterprise Data Integration System - Employee + Financial Trading Compliance, Conceptual/Logical modeling and data integration, data standards & governance Power Designer, Oracle 11g, PL/SQL
• Designed an Enterprise Data Movement/Integration Center of Excellence; developed a Architecture, Shared Objects, Data Quality, Audit-Balance Control (ABC) Informatica Power Center 9, Oracle 11g, PL/SQL
• 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
• 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
• Sr. Data Architect: Led and participate in the design of a multi-phase enterprise MDM/ 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
• 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
• 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 .
• , 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
• 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 ;

Confidential

ETL/Informatica Tech Lead/Developer

Responsibilities:

• 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
• Sr. Logical Data Modeler in a Enterprise Data Warehouse, multi-company data migration integration Oracle 9i, Teradata, ERwin
• 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
• Confidential, 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
• 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
• 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
• Confidential 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

Confidential, Burlington MA

Engineering Director

Responsibilities:

• 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

Confidential, Manhattan NY

Technology Manager and Director of Web Business Intelligence

Responsibilities:

• Helped define technical direction/partnerships for Web Business Intelligence
• Managed and provided technical leadership to 2 web-development (B2B) projects:
• Web-based int’l financial fund analysis and decision system
• Web-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.
• A data mart and a web-based sales analytical system + a sales/marketing/accounting DW
• An HR data mart and analytical application + a “renovated” HR data warehouse
• A revised data mart for investment banking and equity asset analysis
• Provided guru support to other projects and practices in DW, Enterprise modeling, and BI

Confidential, Nashua NH

Principal

Responsibilities:

• Led and participated in 3 data warehousing and metadata management projects
• A metadata management subsystem of a new financial/marketing data warehouse
• A data warehouse for testing/simulating diagnostic blood analyzers & metadata facility
• Overall architecture and technical strategy of a global, geographically dispersed DW.
• Helped Parallogic define technical direction and establish partnerships.

Confidential, MA

Chief Technology Officer (CTO) & VP Technology

Responsibilities:

• 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

Confidential

Senior Architect

Responsibilities:

• 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

Confidential, Littleton MA

Project Leader, Software Development

Responsibilities:

• Managed the Repository Information Model product definition and development
• Contributed to DEC Repository and related standards committees

Confidential, Littleton MA

Principal Software Engineer

Responsibilities:

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