IT and data governance expert identifying taxonomies and metadata
Resume:
John Simmons
Tel: 617-***-****
Email: *****@****-*****.***
LinkedIn: https://www.linkedin.com/in/john-simmons-4230621/
Experience:
InfoMedia Inc., Millis, MA May 1991 – Present
Senior Consultant
Moderna Therapeutics, Norwood, MA Feb. 2023 – Present
IT Consultant
Led cross functional teams through an audit and data integrity assessment of the 36 various integrated laboratory instruments and systems such as Chromeleon, LabVantage, SpectraMax, Osmotech, MasterCycler and others.
Defined strategy, operational tactics, and accountabilities for team members.
Manage dashboard of 300 Quality systems record – Deviations, CAPAs, etc.
Partnered with senior level staff and provided critical input into the planning process for the projects: scheduling, risk identification and mitigation, and KPI development.
Monitored and measured performance, provided project management expertise and support for quality control activities related to the projects or program.
Accountable for the accuracy, timeliness, and quality of project data and respective reports for senior stakeholders.
TScan Therapeutics, Waltham, MA Sept. 2021 – Dec. 2022
IT Consultant
Developed business process documentation and procedures used in managing chain of custody for gene therapy products.
Prepared business requirements used to configure and customize the Vineti Personalized Therapy Management® (PTM) cell therapy platform.
Organized daily stand ups for managing day to day application development and configuration.
Prepared project plan to manage the rollout of the chain of custody system used by the Quality Assurance and Supply Chain organizations.
Provided strategic and tactical labeling expertise to the QA and Supply Chain teams while ensuring compliance with applicable regulatory requirements.
Provided direction to Global Labeling Compliance, as required, to support internal and external (i.e., Regulatory Authority) requirements and support audits/inspections as a labeling subject matter expert.
Biogen, Cambridge, MA Mar. 2019 – Aug.
Project Manager \ Business Analyst
Concurrently managed seven data migration and five system electronic archival projects for the Research and Development business unit.
Prepared and reported project status to corporate executives and reduced risk mitigation.
Prepared project plans and templates for system decommissioning that included database, servers, clusters, interfaces, web portals, procedures and IT document retirements in a global GxP environment for a pharmaceutical client.
Working in a matrix organization, managed projects deliverables from various departments such as Information Technology, Network Services, Records Management, Information Governance, Change Management and Legal.
Prepared source and target data mappings and business requirements for document and data migrations.
Defined and developed new business processes for data archival, hardware retirement and systems retirements in accordance to enterprise data governance standards.
Authored SDLC deliverables for review, including specifications, migration plans and reports in a validated GxP environment.
bluebird bio, Cambridge, MA Nov. 2018 – Jan. 2019
Project Manager
Developed global corporate implementation plans of the Vineti System (SaaS) used to manage gene therapy product creation and logistics.
Interfaced with the internal software development team to identify integration opportunities between Vineti and Oracle Financials.
Prepared requirement specifications and data mappings for identified integration points.
Prepared project plans for rollout of hardware and software application to numerous sites in the United States, France, Germany, Italy and the United Kingdom.
Gilead Sciences, Foster City, CA Mar. 2018– Sept. 2018
Project Manager
Prepared current business process documents for a pharmaceutical client.
Managed upgrade of a Veeva Vault Electronic Master File (eTMF).
Streamlined business processes for use with new Veeva ETMF solution.
Prepared the project plan and managed the software development including risk mitigation and Issue / RAID Logs.
Prepared user acceptance test plans to validate GXP requirements for electronic signatures, time stamping, record storage and retrieval for clinical data.
Created RFP documents for selection and procurement of hardware servers for use with Veeva application.
Managed user accept testing for GxP validation.
Managed project that interfaced application to Oracle Master Data Management tool.
Leach Garner, Attleboro, MA May 2015 – Jan. 2018
Sr. Technical ERP Consultant
Implemented Master Data Management Module (Infor) that controlled production planning, preventative maintenance and service inspection data for the enterprise in a high-volume manufacturing environment.
Created a SQL Server data warehouse that integrated information from their global based Syteline ERP systems for use for aggregate financial reporting.
Automated the generation of Customs Declaration documentation based on the Harmonized Tariff Schedule Structures and Classifications using SQL and Progress/OpenEdge.
Re-architected database schema to eliminate data redundancy.
Fresenius Medical Care, Lexington, MA Jan. 2015 – April 2015
Sr. Enterprise Architect
Developed Logical and Physical data warehouse models using ERwin and Enterprise Architect for the CrownWeb Data Store System.
Integrated the Oracle 11g database schema and objects via an enterprise service bus to capture various XML structures to control processing of monthly clinical reporting to the federal government.
Prepared the functional and technical specification document sets identifying the Informatica ETL transformation and business rules.
Developed ETL routines using Informatica PowerCenter 9.1.
Prepared the project plan and managed the software development.
Altisource Labs, Boston, MA May 2014 – Nov. 2014
Sr. Enterprise Architect
Designed and deployed a MySQL, ERWin and Visio based solution for the control and creation of ERD’s for the corporation.
Evaluated in house developed routines that were written in OpenEdge 11.2, to correct performance issues. Reviewed and redesigned database structures to adhere to 3rd form normalization.
Reviewed and recommended design strategies with CIO and senior management staff. Set up testing and document repositories using JIRA and Confluence.
Citizens Bank, Cranston, RI Nov. 2012 – Apr. 2014
Technical Project Manager
Provided project management expertise using Agile and Waterfall methodologies in order to plan, organize, control and deliver multiple business level projects within the Program portfolio.
Integrated 50 sources systems to a business data warehouse for processing mortgage applications based on the DB2, SQL, Teradata and DataStage environments with a SAS front end for use as a business intelligence tool.
Implemented a Master Data Management application to control customer and mortgage data.
Created a 2007 SharePoint based repository that controlled project documentation such as project plans, requirements, meeting minutes, architectural designs, business process diagrams and workflows.
Plan International USA, Warwick, RI Jan. 2011 – Oct. 2012
Sr. Technical Consultant
Prepared system architecture and business process documentation sets identifying Plan’s current integration with internal and external systems.
Evaluated CRM Packages and reporting tools to identify the best tool to meet customer’s needs, which included customization requirements to the base application.
Created Progress and T-SQL routines that processed sales order data via web services from external vendors using internal credit card and EFT processors using web services.
Developed ETL integration routines using JAD techniques to migrate data from a SQL Server database to Salesforce.com (SFDC) application.
Developed policies for IT Production schedules, database mirroring and online backup procedures.
Prepared business plans and taxonomy for internal document application based on SharePoint 2010.
Novartis Institutes for Biomedical Research, Cambridge, MA May 2010 – Dec. 2010
Sr. Project Manager/ Business Analyst
Worked with Legal & Patents department to identify and scan all paper files to electronic format. Statement of Work (SOW) and the project plan documents were prepared to perform physical and electronic inventories of documents.
Identified and documented current business processes and application architecture roadmap document. Internal patent management applications were reconciled to data from the US Patent & Trademark Office (USPTO).
Integrated Memotech System via service bus that exchanged XML data with USPTO.
Facilitated meetings with the Legal & Patents department to prepare the functional requirements that included taxonomy, metadata, workflow and other data governance entities.
Designed and developed a central staging repository used to store the electronic documents prior to ingestion into Documentum.
Raytheon Company, Billerica, MA June 2009 – March 2010
Sr. Technical Consultant
Defined and managed a custom business intelligence solution for Raytheon that measured scheduled vs. actual variances for many of their military programs.
Re-architected SQL Server databases to significantly eliminate redundant data.
Created dimensional data models using ERWin and T-SQL.
These Analysis Cubes imported data from SAP and APEX and were integrated into existing .Net applications and SharePoint 2007.
Developed integration feeds from APEX using SSIS.
In addition, financial reports were developed using SSRS 2008 leveraging MDX, T-SQL and SQL Server 2008.
Developed functional requirements as well as managed development and quality assurance activities using a full SDLC.
Grantham Mayo & van Otterloo, Boston, MA Nov. 2008 – May 2009
Sr. Project Manager
Performed business unit Interviews in order to prepare the functional requirements and document taxonomy for the Enterprise Content Management System.
Identified bottlenecks with the current business processes and recommended new streamlined processes.
Prepared project plans to control the project using Microsoft Project.
Created RFI and RFP documents, which were given to vendors in order to select a comprehensive solution.
Configured and managed the development a Proof-of-Concept application using SharePoint 2007. Prepared and presented project status reports to corporate level management.
GTECH Corporation, Providence, RI Feb. 2008 – Oct. 2008
Technical Project Manager
As project manager, I created project plans for a marketing business intelligence application using DataStage ETL toolkit accessing DB2/Teradata source data with reports and dashboards developed with Business Objects.
Performed hardware reviews to identify processing bottlenecks and organized the replacement and conversion of legacy hardware.
Created test plans to identify performance benefits from newly installed hardware.
Coordinated and monitored product specification, development, quality assurance of this software application using a full SDLC.
Prepared Business Objects training curriculum documentation as well as facilitate training programs.
Prepared and presented biweekly project status including resource, asset and finance commitments to CIO and other upper-level management.
This marketing product has been successfully implemented at two sites with the project being completed on time and 60% under budget.
Boston Public Schools, Boston, MA Mar. 2006 – Dec. 2007
Enterprise Architect
As Technical Architect coordinated and successfully implemented 15 systems integration projects as a direct report to the CIO.
Prepared budgets, work breakdown structures and staffing requirements for all projects using the PRINCE 2 Methodology standard.
Presented and reviewed monthly project status and milestone achievements to upper-level management. Monitored project status and identified and resolved project bottlenecks with technical and business staff.
Developed Enterprise Service Bus used for data integration between School District and State Agencies using the School Interoperability Framework (SIF).
Performed digital inventory of all structured and unstructured content.
Identified redundant data servers, databases and tables that reside in Microsoft SQL Server Databases.
Created dimensional data models for data warehouse solutions using ERWin and T-SQL.
Developed ETL procedures using DTS and SSIS to create a data repository for end user and state mandated reporting.
Prepared recommendations on cost effective business intelligence, identification of both structured and unstructured BPS data content, created document and electronic taxonomies and programming /database standards.
Legion Insurance Company, Philadelphia, PA Aug. 2005 – Feb. 2006
Enterprise Architect
Developed the technical design of the Enterprise Data Management (EDM) System, a .NET/SQL based system solution based on Service Oriented Architecture (SOA).
Redesigned business processes through workflow tools, which included the intelligent scanning of 7.8 million documents.
Systems was used to collaborate with in-house colleagues, as well as external entities such as outside counsel, state regulators and customers to review documents and emails pertaining to arbitrations, litigations and audits.
Hewlett Packard, Inc, Littleton, MA Jan. 2003 – July 2005
Sr. Technical Consultant
Managed the development, customization and deployment of a multinational integrated ERP application.
Created Enterprise Service Bus used to data exchange between manufacturing facilities and the corporate SAP ERP system.
Created dimensional data cubes and ETL scripts to load Cognos schema from Oracle source databases. Significant systems integration developed for integration to other applications, such as SAP, Clarify and Siebel.
Bankers Systems, Inc, St. Cloud, MN Nov. 2001 – Dec. 2002
Project Manager
Prepared the Statement of Work (SOW), Project Initiation Package (PIP) and Budget for this $1.5 million dollar project using the PRINCE2 Project Methodology.
Reviewed current business processes and consolidated and streamlined them for developing and distributing legal financial forms using Sigmalink, an XML web-based content management system.
Tracked and monitored issues and notified project sponsors of impact to the project.
Integrated system with their corporate ERP System (SAP), to update Order Processing and Labor Tracking.
The Gillette Company, Boston, MA Sept. 1994 – Oct. 2001
Sr. Technical Consultant
Responsible for the centralization, custom development and global implementation of MFG/PRO to meet the company’s business needs for integration to 20 plants world-wide.
Integrated Manufacturing Execution Systems used for driving high volume production scheduling and Internet reporting applications.
Prepared the security procedure and process documents to support all developed systems and interfaces. Advised upper-level management on appropriate courses of action in which their IT solutions should follow.
Partners Healthcare System, Boston, MA May 1996 – June 1999
Sr. Technical Consultant
Directed, designed and developed a real time medical imaging system that transmitted full motion diagnostic images to and from remote locations such as Massachusetts General Hospital and Brigham and Womens Hospital.
Patient scheduling and billing information were generated from this application and integrated into their current hospital environment.
Education:
Boston University, Boston, MA
B.A. in Computer Science and Biology
Graduate certificates in Project Management, Database Design, Software Development and Systems Engineering
Babson College, Wellesley, MA
Graduate certificates in Systems Design, Systems Analysis, Program and Project Management
Progress Software – Webspeed, HTML and Java Development
Contact this candidate