Page *

Dan Victor

Sr. IT Business Solutions Architect / Process Analyst / Data Engineer / BPM

I have over twenty years of Fortune 500 experience with multiple international corporations, spanning many diversified industries. My approach is highly adaptive and well suited for diverse, complex business environments. Top skills include interpersonal communications, analytical thinking, problem solving, (“troubleshooting”), root cause analysis, and a proven track record of providing solutions for long-standing processing and procedural problems. EXPERIENCE

Abbott Laboratories, Lake Forest, IL 06/2021 – 3/2022 Sr. IT Business Process Analyst / Process Engineer - Quality Systems

• Performed Quality Systems Process Analysis, analyzed Current State, identified Root Cause, provided Future State, Gap Analysis, and Roadmap.

• Worked with locations in the US, Wiesbaden, Germany, and Madrid, Spain.

• Translated and refined requirements from off-shore offices.

• Functioned as Liaison between IT and Global Business Process Owners/Business Users.

• Interpreted Quality Requirements, redefined SOPs, and interfaced with programmers.

• Produced and facilitated UAT with off-shore offices.

• Analyzed and redesigned Power APPs and Power BI interfaces.

• Trained IT personnel on various Microsoft Office Applications.

• Designed and produced Excel Pivot Tables, Dashboards, PowerPoint, and interactive reporting tools/apps for upper management.

ThermoFisher Scientific (Remote) 10/2020–12/2020

Sr. IT Business Systems Analyst / Process Engineer / Power BI Analyst

• Analyzed Power BI Dashboards and other reporting tools and applications.

• Facilitated Focus Group/Walkthrough/Requirements Gathering with teams and individuals.

• Researched VOC feedback regarding Current State functionality for attaining actionable data.

• Led Change Management initiative to enable all teams faster, more reliable, concise reporting.

• Produced Current State swim lanes defining tools and processes used by reps, managers and directors.

• Redefined best practices for content management and IT governance.

• Streamlined processes and workflows, eliminating wasted time and effort.

• Modified Power BI front end design for ease of use and increased clarity.

• Provided Future State diagrams and SOPs to address report processing gaps and new requirements.

• Redesigned output reports, depending on Audience; Upper Management, Acct Managers, Sales Reps, etc. Job Search 08/2019–09/2020

Searching for job and then the COVID-19 pandemic hit. AbbVie Pharmaceutical R & D 01/2019–07/2019

Sr. IT Business Systems Analyst / Process Analyst / Commodity III / EI3

• Analyzed processes and provided Root Cause and Gap Analysis for security implementation of a new global installation of ASPIRE Financial System.

• Formulated and enhanced data governance procedures and best practices.

• Worked with Change Management to transition into new Financial System.

• Provided Active Directory research and user support regarding access and system permissions questions.

• Produced weekly PowerPoint Security Access Reports for upper management.

• Designed and maintained SharePoint site with self-contained InfoPath input/maintenance screens.

• Created Excel Macro-driven, formatting, configuration and processing workbooks and updated SOPs.

• Generated Dashboards and Pivot Tables with focused (BI) reporting capabilities.

• Devised secure, quick access, information validation tools using limited system provided data and Excel.

• First on team to upgrade to Office 365; interacted with Service Desk to fine tune prior to team upgrade. Page 2

Wells Fargo Bank (Remote) 02/2017–08/2018

Sr. IT Business Systems Analyst / Process Engineer / Cyber Security

• Interacted with multiple technical and business project teams and LOBs to facilitate Change Management to enhanced, more stringent, tighter security at all levels.

• Compiled and maintained RACI chart and coordinated participation.

• Developed As-Is and To-Be diagrams utilizing with Visio, IBM Blueworks Live and TIBCO.

• Determined processes and SOPs required for verification, sign-off and ‘evidence’.

• Detailed Gap Analysis for IT Data and Application Disaster Recovery processes.

• Site Administrator for SharePoint (including InfoPath) for site construction, functionality and reporting.

• Trained users on SharePoint, Excel (Pivot Tables) and PowerPoint.

• Supervised EACO System with technical and business personnel.

• Designed EXCEL reports, Pivot Tables, PowerPoint Presentations, etc. for upper management.

• Facilitated daily meetings as interim Scrum Master, using JIRA.

• Provided BPM process modeling and mentorship.

Discover Financial / Discover Card & Bank 07/2016 –12/2016 Sr. IT Business Process Engineer / Systems Analyst - Operational Effectiveness / VOC

• Met with stakeholders, managers, SMEs in each line of business (LOB) to determine current state processes and procedures, future state needs and gap analysis.

• Redefined/restructured LOB procedures, to create interconnected process flows with automated transitions and reporting.

• Created IBM Blueworks Live and Visio process flows and swim lanes as well as RACI charts, Change Management and Risk Assessment documentation and expanded Voice of the Customer knowledge base.

• Incorporated the user’s needs into the design of the InfoPath/SharePoint screens/views.

• Designed InfoPath (SharePoint) View Templates (screens) to include BI functionality and automatic verification for each LOB.

• Wrote training materials and updated SOP’s for InfoPath users and developers. Advocate Aurora Health (Remote and On Site) 06/2015 – 05/2016 Sr. IT Business Process Analyst / Systems Analyst / ERP Reporting Engineer

• Key role in major upgrade of financial system for the Advocate Aurora Health Care network of 15 hospitals, 150 clinics and 90 pharmacies.

• Led Change Management efforts to transition to new all-encompassing financial system.

• Analyzed conversion and data migration for accuracy, completeness and consistency.

• Provided analysis of problems, errors, and gaps in data and functionality.

• Developed training materials, instructions, guidelines, templates and SOPs.

• Wrote and trained users on the Morrisey ‘flavor’ of Crystal Reports. Previous Consulting Positions (Available Upon Request) 2000 – 2015 Multiple Industries and Corporations

Technical Background / Training

APPs MS Excel (Pivot Tables/Dashboards/, PowerPoint, SharePoint eMail Gmail, GroupWise, Mozilla Thunderbird, Lotus, MS Outlook CFR 21 Part 11 & 820 Electronic Records & Signatures GxP (GCP, GLP, GMP) Federal Standards for Best Practices Internet Browsers Google Chrome, Edge, IE, Mozilla Fire Fox, Opera Methodologies AGILE, SDLC, Six Sigma (DMAIC, etc.), Waterfall Pharmacovigilance Adverse Effects Reporting/Prevention Programming Languages CQ/CS, Crystal Reports, IQ, SMART, SQL, TANGO, UniBASIC Process Mapping APPs IBM Blueworks Live, TIBCO, Visio Six-Sigma Green Belt Chicago Deming Association - Six Sigma Master’s Program Tools Active Directory, EACO, JIRA, Lync, Teams, WebEx Page 3

Overall by COMPANY

AGILE Discover Financial, Riverside Publishing, Wells Fargo Bank Asset Management C. Beck & Associates, McDonald’s Corporation Automating Processes Abbott Labs, Fast Heat Element Mfg., McDonald's, Trustmark Insurance BPM & UML Abbott Labs, Cigna, Lincoln Financial, McDonald’s, Wells Fargo BI (Business intelligence) Abbott, Lincoln Financial Group, McDonald’s, OSG, ThermoFisher, Change Management Abbott Labs, Abbvie, ACE, Cigna, Hospira, LFG, LTD, McDonald’s Configuration Management ACE, Cigna, Hospira, LTD, McDonald’s, OSG, ThermoFisher CRM and Sales Analysis Fast Heat Element Mfg., OSG, C Beck Customer Facing All

Cyber Security Abbvie, OSG/Sossner, Wells Fargo Bank Distribution ACE, LTD, OSG/Sossner

ERP & MRP Advocate Aurora Health, Fast Heat, McDonald’s, LTD, OSG InfoPath (Power BI) Abbvie, Discover Financial, Wells Fargo Insurance IT Processing Allstate, Cigna, Trustmark Logistics LTD, OSG/Sossner

Manufacturing Fast Heat, OSG/Sossner

Metrics Analysis C Beck, Fast Heat, OSG, ThermoFisher, Trustmark, Wells Fargo PMO ACE, Lincoln Financial, LTD, OSG, Riverside Publishing, Wells Fargo Process Analysis Abbott, ACE, Cigna, Discover, LTD, LFG, McDonald’s, Wells Fargo Process Improvement ACE, C Beck, Fast Heat, LTD, LFG, McDonald’s, Wells Fargo RACI Abbott Labs, AbbVie, Discover Financial, Wells Fargo Quality Systems Abbott Labs, Abbvie,

Regulatory Affairs (RA) Abbott Labs, Abbvie, Hospira Root Cause Analysis Multiple

SharePoint Abbott Labs, Cigna, Discover Bank, Lincoln Financial, Wells Fargo Six-Sigma Abbott, ACE, Cigna, Discover, LFG, LTD, McDonald’s, Wells Fargo Supply Chain/ Procurement C Beck, Fast Heat, OSG/Sossner, LTD, Trustmark Swim Lanes Abbott, Ace, Cigna, LFG, McDonald's, ThermoFisher, Wells Fargo System Testing Abbott Labs, Abbvie R&D, Hospira, Riverside Publishing UAT Multiple

User Training Multiple