John Lynch

About John Lynch

Thirty years as a Data Strategist bringing passion and commitment to designing and delivering strategic corporate data integration solutions and transforming corporate data assets into corporate information assets. Significant understanding of complex data and enterprise architectures ranging across a broad spectrum of industries including P&C and Commercial Insurance, Health Care Payer, Medical Risk Management, Banking, Investments, Manufacturing and Telecommunications. Strong analytical, technical, presentation and interpersonal skills along with solid organizational skills. Expert level of understanding and adherence to the tenets of Ralph Kimball in construction of data integration solutions, data warehouse and business intelligence infastructures.Extensive delivery of flexible, sustainable and effective data integration and information system solutions to clients. Extensive knowledge of transactional, operational and decision support systems spanning multiple platforms, applications and technologies. Broad experience with a variety of host data systems and expert abilities in data warehousing, data modeling, SDLC processes, business intelligence and reporting, operational data stores (ODS), capacity planning, data strategy, disaster recovery and performance tuning. Extensive experience with Enterprise Application Integration (EAI) technologies and services, Enterprise Information Integration (EII) technologies, Corporate Metadata Strategy and the use of Extract Transform and Load (ETL) processes in support of corporate data integration requirements. Solid understanding of business process workflow and methodologies. Excellent Troubleshooting techniques, a highly pro-active team player with excellent verbal and written communication skills placing emphasis on schedule, delivery and teamwork. Expert at risk identification, developing QA and test plans. Driven to succeed and to make clients successful.Specialties: MDM,BI, EA & Cloud.

Experience

1. Sr Solutions Architect, Data Engineering & Analytics

   Biogen

   Apr 2015 — Present · Cambridge, MA, US

   SR. Architect DEA - Data Engineering and AnalyticsData Strategist working with Digital Quantitative Medicine, Master Data Management, and cloud based data solutions, including Denodo, Snowflake & Informatica. Built an internal Snowflake DB practice evangelizing the product through multiple presentations, including customer, application and ARB presentations. Wrote data standards documents and related topical articles on Time Travel, Data Sharing, Json, IICS and others. Completed multiple Snowflake POC’s including Mobility, HR AD, Commercial DB and others. Responsible for multiple employee and contractor reports. Delivered 10.1 - 10.3 Informatica MDM repatforming. Delivered LMS Data Repository.SR. Architect R&D IT Technical Lead for delivery of R&D IT SaaS Projects for Clinical, Research, Safety, Regulatory, Medical, and Digital Quantitative Medicine. Lead Migration & Reports Team for Sum Total/Isotrain Migration to cloud based SAP Success Factors system.Lead Migration Team for Migration of on-premise Watson Sample System to IMS/BSI cloud based sample system. Lead Reporting Team for major Business Objects reporting enhancement of QUMAS.Team Architect for CTS - SmartTrials - cloud based data hub technology for clinical trials reporting. Technical Lead - Architect for STARS 2.0 Cloud Based Adverse Event System Migration of 1.0 to 2.0. Technical Lead for OCRDC re-platforming from Biogen on-prem to IQVIA SaaSTechnical Lead for Steeprock HCO/HCP system conversionTechnical Lead for Parexel BRIM to GRIT 5.1 - 6.1 cloud migration.DEA - PO & T – Technical Lead the Snowflake Serialization project for PO & T.DEA – PO & T– Technical Lead the Snowflake End to End Supply Chain Analytics project (VCP) for PO & T.DEA – Corporate HR – Technical Lead for development of People Analytics POC

Education

• Bowdoin College

  BA, Government & Studio Art

  1978 — 1982

Skills

• Healthcare Technology
• Healthcare IT
• Data Warehousing
• Oracle
• Healthcare Information Technology
• Enterprise Architecture
• Data Quality
• Soa
• Data Governance
• Business Intelligence
• Etl
• Data Integration
• Sdlc
• Data Modeling
• Project Planning
• Hipaa
• Master Data Management
• Solution Architecture
• Database Design
• Business Analysis
• Requirements Analysis
• Integration
• Architecture
• Analytics
• Databases
• Data Management
• Informatica
• Db2
• Vendor Management
• Data Warehouse Architecture
• Software Project Management
• IT Strategy
• Microsoft Sql Server
• Enterprise Software
• Business Process
• Crm