Jonathan Mangin

• Associate Scrum Master
• Senior trainer developing, delivering, and sustaining end to end trainings for Azure DevOps 2019|2020|Services, Teams, Stages, SAP, Teamcenter/NX CAD, ISO 14971 Medical Device Risk Management, Tempus, and Scaled Agile (SAFe) implementation for user base of ~4,000
• Administrating training with Learn4U and Stages LMUs
• Assisting senior management with revisions to and communication of Unified Design Change procedures in the context of Engineering Change lifecycle management
• (These procedures must conform to Part 11 and FDA requirements, which includes successful adoption of these processes.)
• Operating as a SME for the integration of Azure DevOps Server|Services, Teamcenter, Tempus, NX (CAD software), SAP, and a collateral Incident Management System
• Established Work Breakdown Structure (WBS), iteration cadences, work item hierarchy and acceptance criteria for multiple teams in Azure DevOps
• Working in an Agile/Scrum/SAFe organization on a team that was an early adopter of Agile/Scrum/SAFe methodologies; assisting with organizational change to promote effect adoption
• Assisting teams create and design Agile/Scrum Kanban Boards; assist in Agile/Scrum trainings
• Performed major revisions to process documentation resources including Engineering Change process diagram
• Assist Risk Management senior management in training program creation and maintenance in order to improve present training materials and ensure compliance with ISO changes
• Assist users in creating cross project reports in Power BI for consolidated reporting of needed analytics
• Trainings developed in Captivate, Storyline, PowerPoint, and Vyond
• Coached teams in Agile practices and provided necessary training to create positive mindset to Agile methodologies.

∙ Office 2010|2013|2016|365 advanced training course production and delivery

∙ Training solutions for projects involving 750-5,000+ end users and VIPs (In-Person and VILT trainings (GoToMeeting, WebEx, Citrix, Adobe Connect, Skype, FuzeBox, Wire)

∙ Focus on intermediate to advanced Excel training solutions including table filtering; the creation, management, and granular filtering of pivot tables; nested IF statements; Consolidate, Scenario Manager, and Goal Seek use; sifting data using COUNTIFS, SUMIFS, SUMPRODUCT; Pivot Table filtering using Slicers and exporting Slicer filters to a dashboard sheet

∙ Linking tables as relational databases using the Query Editor and Power Query options (the latter for larger datasets) with DAX and MDX; Linking datasets in Pivot Tables using VLOOKUP; using formulas within Pivot Tables; changing how data is expressed in Pivot Tables with Calculated Fields and Columns and custom sorting; exporting data using GETPIVOTDATA

∙ Training program delivery through Articulate and creative use of ambient audio/visual tools

∙ Linking data using text functions (e.g., LEFT, MID, RIGHT) with VLOOKUP and INDEX/MATCH; preparing data with TRIM, CLEAN, UPPER, LOWER, PROPER and hyperlink management; Date prep (e.g. DATE, YEARFRAC, EDATE, FV, PV, IRR, NPER)

∙ Creating dashboard experience using content controls with Named Ranges, Data Validation, and INDIRECT, INDEX, MATCH, FIND, LEN functions; Subtotaling inside and outside of Pivot Tables

Co-Lead Project Manager on Windows 7/Office 2010/365 migration of approximately 700 end users

Developed and delivered training for 750 end users for Office 2010 applications, SharePoint 2010|2013|365, Adobe Acrobat Pro

Performed application remediation on 85+ applications (esp. those based on Excel, Access, VB6); involved Chartis related scripts