Information Technology Program Manager

Resume for JEFFREY A. HEDRINGTON, PMP, MBA, CSM

E-mail: ********@*****.*** Cell Phone: (608) 219 - 7156 CAREER SUMMARY

20+ years of leading and delivering sustained results and meaningful change for Fortune 500 firms across a wide range of industries including manufacturing, financial and insurance, retail, transportation and logistics, compliance and governance, product and software development, government, education, and engineering. Extensive experience in strategy and leading cross-functional, global business and technical teams to bring about change and improvement in strategy, process, and profitability – both as a leader and expert consultant. Information systems department management for PMO and Agile teams; business intelligence/data analysis; security, privacy, and governance; infrastructure and enterprise architecture; and application development and quality assurance. Adept in multiple programming languages. Emphasis in recent years has been on ERP Implementation, transformation, and change management programs with focus on data migration, integration, governance, and analytics workstreams. PROFESSIONAL EXPERIENCE

Madison Area Consulting, Wausau, WI Senior Program Manager, April 2019 – Present SAP Data & Analytics at Retail client. Implemented and managed Microsoft Fabric and Power BI self-service solution for reporting. Managed and lead Data Engineering, Business Analysis, and SAP Data Mapping teams on development, delivery, and business validation of 150 Power BI and legacy QlikView leadership dashboards and reports to support SAP ERP go-live and post go-live. Established processes to manage backlogs with Jira with roadmap for ongoing expansion of Enterprise Data Lake to reduce technical debt and facilitate 2025 dashboard and reporting development. SAP IT Program Manager at Military Defense contractor. Led SAP S/4 HANA Implementations across multiple legal entities and production sites. Program focused on data migrations from Infor/Baan and Epicor to SAP and business transformations. Enterprise Data Management (EDM) at Networking products client. Gathered customer and product Master Data Management (MDM) requirements with 100 interviews, supported with SAP S/4 Hana and Salesforce data analysis and requirements validation to determine problem scope, business impacts, and current state findings. Delivered short-list of MDM vendor tools, future state recommendations, and multi-year Enterprise Data Strategy / Roadmap / Implementation plan to improve Stewardship, Governance, Quality, Data Analysis, and Data Management to benefit multiple projects. Data Governance and Architecture PM at Food and Beverage client. Led Extract-Transform-Load (ETL) teams to make data available from 100s of sources (SAP S4 Hana, Salesforce, Oracle PLM); and led Power BI development teams to build senior level dashboards and manage the business with corporate KPIs. Strategy Planning PM led Merchandising Order Management / Sourcing and Strategy / Supply Chain programs on corporate strategy roadmap to double existing stores and grow organization. 30 projects in programs with heavy emphasis on product sourcing, purchase order management, capacity planning, productivity improvements, new warehouses and distribution centers, and capacity/productivity improvements to existing DCs. Stakeholders include senior leadership with SVP/VPs in finance, merchandising, strategy, supply chain, talent management / HR, IT, and logistics. Manufacturing Client PM led Merger and Acquisition infrastructure site migrations for North America manufacturing plants, warehouse, and administration offices. Full migration and replacement of all data centers, servers, software, and networks; shop floor, office computer and printers. Built factory model and efficiencies that reduced delivery schedule by 2 months and saved millions in support expenses. Improvements and asset management to ensure that Configuration Management Database (CMDB), Azure, Intune, and security products were accurate post-migration for users, PCs, and printers. NIST Security Monitoring and Alerting Design and Implementation with complete Incident Response Playbooks. Insurance Client PM led $15 million Guidewire Claim Center implementation. Emphasis on Requirements Gathering, Data Migration, Integration, and Business Reporting. Organization Change Management (readiness assessments, communication planning, sponsor roadmaps). Data extractions and database migrations from 6 separate legacy Claims and Policy systems to establish a single mature Enterprise Data Warehouse for business reporting and analytics along with data transformation and data validation from Oracle to Guidewire. Manufacturing Clients. Data Transformation and Software Implementations

• Packaging: .Net DevOps, Salesforce, and Workday HCM/LMS product selection and software implementations.

• Energy: Series of data center, server, and application migrations due to divestiture.

• Food and Beverage: Systems Integrator selection, strategy, and project planning for Vistex into SAP integration. Jeffrey A. Hedrington, PMP Page 2

Financial Services Client. Responsible for $5 million remote worker enablement for full workforce of 10,000 people.

• Migrated Office 365 (Outlook and applications) from on-premises to the cloud -- including all shared mailboxes, distribution groups/lists, and conference rooms. Decommissioned on-premises Exchange servers.

• Implementation of Teams, SharePoint, and OneDrive. Converted Skype and Zoom to Teams. Deployed Mobile applications via Edge Browser, Azure Information Protection (AIP), and App Proxy. Deployed Teams Softphones in multiple call centers and improved networking by replacing routers and access points at 160 field locations. Modified Salesforce and Workday HCM/LMS to integrate with mobile apps.

• Led organizational change management including technical and user training, Service Now support documents, knowledge areas, and user request self-serve forms. Emphasis on security, privacy, governance process and policy. Built out unified communication team to support Teams/SharePoint/OneDrive operations.

• Implemented DevOps practices to shorten SDLC, provide continuous delivery, simplify transition to support operations.

• Enabled digital communications / document workflow automation to improve print and mail operations as a foundation for sending all corporate documents and statements to customers. Weinbrenner Shoe Company, Merrill, WI Director of Information Technology (CIO), June 2018 to April 2019

• Senior IT leader at manufacturing company: responsible for strategic direction, leadership, procurement, and corporate oversight across multiple technology and functional domains. Emphasis on IT, HR, and Finance workgroups.

• Managed a diverse team of staff, consultants, and cloud-based service groups to accomplish project and solution delivery. Ensured infrastructure stability, introduction of new system capabilities, and vision to support growth strategy.

• Implemented DevOps practices to develop and maintain a growing portfolio of applications, processes, and infrastructure to support all business operations.

• Architect and implementation for E-commerce portals. EDI, Infor M3 ERP Financial Management Systems (FMS), and Customer Relationship Management (CRM). Increased EDI and E-commerce customers by 40% in first 6 months.

• Established multi-year strategic plan for Infor upgrades with Salesforce and Business Intelligence implementations in 2019 to support increased sales, manufacturing, distribution, and organizational growth. Madison Area Consulting, Madison, WI and Wausau, WI Senior Program Manager, May 2009 to June 2018 Senior Program Manager – Financial Services and Health Care Clients.

• American Red Cross Program Manager Disaster Relief: (Oracle ERP Financials and Inventory, Transportation Management, Fleet ERV Tracking) replacing paper systems with mobile applications for product ordering / tracking.

• Banking: Program manager for Enterprise Allegations Platform. Managed $12 million budget, with 16 projects and 175 full-time technical resources using Agile/Scrum for application development and PeopleSoft integration. Heavy emphasis on governance and data analytics for risk management and loss prevention.

• Health Care: Program manager for case management, service provider education, and business intelligence to mitigate fraud, waste, and abuse risks. Built Tableau and SAS for data analytics and case research dashboards.

• Financial Services: Program Manager for Technical Architects, Database Administrators, and Business Intelligence developers in establishing Informatica, Hadoop and Tableau infrastructure (servers, security, and admin / development tools) for DEV, QA, and PROD environments. Migrated business processes that used SAS to adopt newer Business Intelligence and Data Analysis Hadoop and Tableau technologies and gain operational efficiencies. Coordinated training for Informatica, Hadoop, and Tableau for technology and business departments. Established Agile/Scrum methodology for Extract-Transform-Load (ETL) development and legacy reporting improvements. Senior Program Manager – Catalog/Online Retail, School Specialty

• Managed $5 million Telephony / Customer Care Call Center system migrations from Avaya to Genesys/ININ’s Customer Interaction Center at three corporate offices and 12 satellite offices. Integrated business solution and process improvements with Oracle ERP / Financials, Workday HCM/LMS and Salesforce. Implemented call center analytics and Oracle database upgrades. Delivered under budget & ahead of schedule before critical sales season.

• Managed EDI migration of Customers (Walmart, Amazon) and Suppliers from IBM Sterling to Mond Coreflex EDI Service providers. Managed AIX to Linux server migrations and retirement of legacy servers for applications and business intelligence. Projects delivered under budget by $500,000 and ahead of schedule. Senior Program Manager – Product Manufacturer/Distribution, SC Johnson

• Managed Product Information Management (PIM) requirements gathering and RFPs, design, development, testing, and deployment to extract SAP ERP Operations brand and product information into Informatica Data Warehouses to populate Riversand Product Information Management (PMI) and Salsify product content management solutions.

• Project established technical infrastructure and business process groundwork for further efforts with Master Data Management (MDM). Implementation leveraged GDSN and WorldSync industry standard data pools / exchanges. Jeffrey A. Hedrington, PMP Page 3

Enterprise Data Management (EDM) Program Manager at American Family Insurance

• Managed Enterprise Data Management (EDM) program and affiliated projects using Scrum for largest corporate program focused on multi-state new product development / deployed and organizational data analytics. Ensuring delivery of EDM program, Oracle database upgrades, Guidewire Claim Center installation and Oracle PeopleSoft ERP integrations. Extensive work with stakeholders and division management to align business needs with business and technical resource capacity. Expanded program/project metrics to provide comprehensive status and metrics for test results, defects, and change requests to Senior Management Steering Committees. Guided Technical Architects in Hadoop and Greenplum implementations.

• Developed Business Analytics (BA) / Business Intelligence (BI) pipeline management process around portfolio management / intake process, change request control, defect management, and release management to better manage program work efforts and improve visibility to Data Management efforts.

• Developed and implemented BA Systems Development Life Cycle (SDLC) and related Responsible, Accountable, Supportive, Consulted, and Informed (RASCI) model for enterprise data projects. SDLC and RASCI models were completed to incorporate Business Rule / Business Requirements, Data Quality and Data Profiling, Testing Strategy, and Education / Deployment and Product Launch activities. Integrated Business Analytics into DevOps processes. Senior Program Manager - IT Security and Infrastructure at State of Wisconsin DOA

• Managed several enterprise-wide IT Security, Regulatory Compliance, and Infrastructure project initiatives including Network Access Control (NAC) / Identity Services Engine (ISE), Data Loss Prevention (DLP), and Multi-Factor Authentication (MFA) within an Enterprise Project Management Office and using PMO and Scrum best practices. Projects were part of an integrated multiple year Security/Regulatory Compliance/Infrastructure Program supporting multiple State of Wisconsin agencies. Managed Desktop/Laptop/Tablet/Phone Endpoint hardening and analysis projects including operating system and server upgrades at 25 state agencies. Integration of multiple systems with PeopleSoft. Senior Program Manager – IT Infrastructure and Networking at Wisconsin Department of Children and Families (DCF)

• Completed projects for Two-Factor Authentication, Network Access Security, Enterprise Unified Communications (UC / VoIP), and secure Wireless network deployments (WLAN and NAC) at 8 state agency buildings. Coordinated installations (server, phone, voice, data, and videoconferencing) for a Milwaukee building under construction with integration with already existing state office buildings.

• Completed Network Consolidation project (application inventory, testing, training, and environment transitions) to convert state employees from agency/legacy servers to DCF infrastructure for Windows 7, Office 2010, and VDI deployment.

• Vendor management and program management for Fiscal Year Infrastructure Service Level Agreements (SLAs). Program Manager / Technical Architect. Health Insurance at Humana

• Led Health Care Reform (HCR) / Affordable Care Act (ACA) Qualified Health Plan (QHP) Federally Facilitated Exchange (FFE); State Based Exchange (SBE); State Partnership Exchange (SPE) product application processes.

• Worked directly with Federal and multiple States: Office of Commissioner of Insurance (OCI) and Health Insurance Exchange (HIX) offices focusing on EDI integration, data testing, quality assurance, and regulatory compliance.

• Completed business and technical analysis of Federal and State HIPPA / EDI Companion Guides with an emphasis on 820 Payment and 834 Enrollment processing: Defined business data requirements, planned application development, built Operational Data Stores, and coordinated integrated testing in preparation for open enrollment.

• Facilitated business analysis and data requirements definitions for Health Care Reform with Actuarial department, reviewing integration related to database grades, HIPPA/EDI, and Federal Data Hub management.

• Managed critical dependencies between multiple projects across a multi-tiered program structure / implemented video conferencing and led virtual teams in 8 geographic locations using Scrum / Agile Development.

• All completed work was developed as repeatable processes with the expectation that Health Insurance Exchange product applications are annual renewals. This work was also leveraged for Medicare/Medicaid certifications. PMO / IT Program Manager / Technical Architect, Transportation at Schneider National, Green Bay, WI

• Defined cloud computing, disaster recovery, security, and enterprise content management (ECM) / data strategies with execution plans and implementation.

• Coordinated change requests and defect resolution teams using Scrum for Oracle ERP: ODS database, Transportation Management, and Finance Services products to improve system stability, reliability, and performance.

• Coordinated Technical Services infrastructure projects into a program strategy and project portfolio. Project manager for technical services projects in GIS tracking, logistics, videoconferencing, Learning Management Systems (LMS), Workday HCM implementations, cloud computing with Office 365, offshore help desk, server replacements, Windows XP to Windows 7 transitions, and Oracle database upgrades.

• Led several project managers and acted as methodology and technical advisor on several peer managed projects.

• Improved maturity in Program Management and Project Management practices within PMO department and IT. Jeffrey A. Hedrington, PMP Page 4

Program Manager / Technical Architect at CUNA Mutual Group, Madison, WI

• Program management to deploy Pershing broker-dealer financial investment service solutions. Developed multi- phase project plans, obtained budget / resource approvals, and managed to completion 8 concurrent projects with multi-year budget over $5 million. Projects were brought in on time and under budget by roughly 20%. Expected revenue enhancement of $98 million. Planned 2012 and 2013 project phases continued to run on schedule and revenue expectations were met through effective knowledge transfer.

• Use Agile Scrum process and projects to gather business data requirements, workflow definition, vendor and contract management, change management, process and product education, integration development, develop data models, develop test cases, and provide quality assurance.

• Projects created operational efficiencies for advisors and back office to allow financial advisors to manage and grow their book of business through additional product offerings and improved tools.

• Onsite and remote management of resources in Wisconsin, business owners, TCOE, and IT Agile / Scrum development in Iowa, a remote testing center in India, along with vendors in multiple locations.

• Guided all project phases and projects through a comprehensive Governance / Project Tollgate model. Program Manager / Technical Architect at Covance, Madison, WI

• Projects consisted of new functionality testing, regression testing, quality assurance, and deployment for a commercial product software release used by toxicology reporting labs at multiple sites worldwide.

• Led Agile Scrum teams in packaged software installation, system configuration, lab equipment testing, data testing, and site certification to deploy eight sites in England, France, Germany, and China; installed Wireless technology at facilities; and deployed new Citrix mobility to all sites through LANDesk rollouts.

• Developed multi-phase project plans, obtained budget and resource approvals, and managed to completion 6 concurrent projects with a $1 million budget and aggressive deployment dates.

• Projects were brought in on time and under budget by roughly 20%.

• Onsite and remote management of business and quality assurance resources in 8 geographic locations.

• Guided all projects through a comprehensive Governance / Project Tollgate model of Initiation Phase, Requirements Phase, High-Level Design Phase, Detailed Design and Planning Phase, Build and Test Phase; and Deploy, Turnover, and Closure Phase. Made improvements to PMO governance model.

• Developed project plans and obtained budget and resource approvals for two future software package and database updates, then transitioned project plans to company project managers to close contract. Program Manager / Technical Architect at Gordon Flesch Company, Madison WI

• Led and managed an ERP system vendor selection and implementation multi-phase program. Documented business needs, workflows, and requirements to replace all core business systems with Digital Gateway e-automate with integration into and expansion of Oracle / PeopleSoft financial and business systems.

• Developed request for proposal (RFP) and software requirements specification (SRS), managed the vendor selection process to ensure fair analysis and unbiased selection, negotiated vendor contracts, established quality assurance practices, and developed implementation plans.

• Led Agile Scrum / DevOps for data conversion, data integration / interface development, Agile Scrum for custom software and internal software development, Quality Assurance. Dean Health Plan, Madison, WI Technical Services Manager, May, 2007 to May, 2009

• Responsible for planning and staffing, enterprise architecture, implementation management, and testing / quality assurance practices in $50M HP Metavance medical claims and membership enrollment enhanced functionality and mainframe replacement project.

• Established data governance, data quality, and HIPPA compliance organizational and department standards.

• Responsible for medical insurance application development using Scrum, consultant management, vendor management, IT governance, process standardization, and testing / quality assurance.

• Managed team of 15 technical services resources: server upgrades, Oracle and SQL database upgrades and administration, Informatica data warehousing, application integration for Metavance claims processing and financials, Autosys batch scheduling, Siebel, ERP Microsoft Dynamics, HP Quality Center, Business Objects, Crystal Reports, Workday HCM/LMS, call center integrations, Windows and Unix environment management, and HIPAA / EDI in health insurance industry.

• Established standard ITSM policies and ITIL procedures. Implementation of all 6 ITIL process groups (Configuration Management, Change Management, Release Management, Incident Management, Problem Management, Service Desk).

Jeffrey A. Hedrington, PMP Page 5

Roundy’s Supermarkets, Milwaukee, WI Information Technology Manager, November 2005 to May, 2007

• Managed a team of 16 Informatica data warehousing (DW), Java, and Net implementation experts and multiple outside consultants to integrate Retalix retail pricing, product warehousing systems, Oracle ERP / Financial Systems, Kronos, Direct EDI, and JDA intelligent order management to transform business and improve profitability.

• Revised business processes and technical approaches to integrate all purchased applications.

• Used Agile / Scrum methodology for all business intelligence (BI) and application development work.

• Established formal methodologies (PMO) and standardization with metrics in project planning and tracking, business requirements tracking with cost controls (ROI, TCO, CBA), data governance, data modeling, database upgrades, use case and object modeling, and quality assurance.

• Facilitated IT training in project management, database management systems, systems analysis and design, and technical software development to grow skills of managers and development teams. Madison Area Consulting, Madison WI Program Manager, Aug. 1998 – Nov. 2005 Program Manager / Technical Architect at EFunds, Milwaukee, WI. June 2005 – November 2005 (6-month contract)

• Established a product management / development methodology and quality assurance / testing methodologies for offshore application development to support Payment Card Industry (PCI) processing.

• Managed 25 technical and implementation resources to develop and enhance electronic funds transfer (EFT) applications for major customer accounts. Managed DB2 and SQL Server Database Administrators, Java (Struts and web browsers), and SOAP server (XML and Web Services) analysts, architects, developers, and testing.

• Established and used Agile / Scrum methodology with object modeling for application development work. Established a formal process for development, testing, and implementation of ODS database and application deployments in multiple customer sites running under multiple platforms.

Program Manager / Technical Architect at Johnson Controls, Milwaukee, WI April 2003 – June 2005 (contract to hire)

• Managed 25 DBAs, .NET, and Java developers and 8 quality assurance TCOE in commercial product line development, alpha and beta testing, and product roll out implementations. Managed infrastructure, data access services, user interface, frameworks, and quality assurance. Used Six Sigma techniques for metrics and process improvements. Made significant use of consultants and offshore development / testing.

• Led object modeling using Rational Unified Process to for product design, testing, and implementation using Java user interface and frameworks, C# for data access level, and SQL Server databases. Program Manager at State of Wisconsin, Department of Administration (DOA) and Workforce Development (DWD), September 1999 to April, 2003 (contracts)

• Managed several implementation projects to replace financial systems and establish agency data warehouses. Led object-oriented analysis and design (OOAD) to convert mainframes to servers, using browser-based, object architecture, Rational Unified Process (RUP) methodology, and DB2/Oracle/VB.NET integration. ETL data conversion and DBMS migration. Systems architect for Oracle high-volume processing, file exchange processing, and database upgrades. Program Manager at Northwestern Mutual Life, Milwaukee, WI February 1999 – September 1999 (6-month contract)

• Project management, feasibility documentation, and contract negotiations for life insurance and underwriting requirement bill management, Oracle / Peoplesoft ERP/CRM implementations, and medical vendor E-commerce implementation. Facilitated business process engineering for $10M PeopleSoft underwriting project. Project Director at Great Lakes Higher Education Guaranty Corporation August 1998 – February 1999 (6-month contract)

• Managed 70 IS consulting professionals on 140,000-hour project with 15 subprojects for lending application ODS data conversion and systems integration. Project planning / tracking, resource staffing, executive status reporting, and technical architecture reviews. Developed pricing models, vendor negotiations, Statements of Work (SOW), executive presentations, and service level agreements (SLA) for a professional services organization. Famous Footwear, Madison, WI IT Senior Manager for Application Development. May 1996 – August 1998

• Established formal methodologies (PMO) for project planning, project tracking, data modeling, use case and object modeling, metrics, and business requirements tracking. Migrated IT department from midrange computing to Object- Oriented technologies. Trained staff in systems analysis and project management.

• Managed $6 million project with multiple contract and vendor negotiations to evaluate, select, and replace entire infrastructure (hardware, operating systems, and applications) at 850 plus chain retail stores.

• Department manager leading 15 project managers, database administrators, business analysts, and technical developers in retail store systems ODS and software application implementations: ERP Infor /, Point of Sale (POS), sales audit, credit/check authorization, credit settlement, Kronos time and attendance, office and enterprise document management, logistics, merchandising models and pricing. Jeffrey A. Hedrington, PMP Page 6

University of Wisconsin, Eau Claire, WI MIS Faculty, College of Business. August 1992 - May 1996

• Developed curriculum and instructed courses in database management systems, project management, systems analysis design, and application development.

• Authored and reviewed multiple project management, database management systems, systems analysis and design, and application development textbooks for use in universities and technical colleges. National Information Systems, Eau Claire, WI Software Development Director May 1988 - Aug 1992

• Department manager and enterprise architect leading 15 systems analysts and technical resources to develop, test, and deploy integrated medical, inventory control, and financial business reporting systems.

• Managed software development, database administration, software support, training, and desktop publishing departments. Unix / AIX, Network systems administrator.

• Implemented a PMO / SDLC methodology and established a quality assurance process. Enterprise-wide planner for Human Resources, Product Development, Education, and Facilities Infrastructure. The Pillsbury Company, Minneapolis, MN Project Manager and Technical Architect September 1987 - May 1988

• Project manager and technical lead for software development and ODS database design projects for Financial and Operations Accounting, Invoicing and Distribution, Marketing systems, Plant Operations, and Plant Manufacturing. Midwest Federal, Minneapolis, MN Project Manager and Technical Architect January 1983 – September 1987

• Project manager and implementation leader in five acquisition mergers and complete database conversion projects. Application development and implementation lead for on-line financial and banking systems: Savings/Checking/Cash Card, 401K, Electronic Funds Transfer, and Demand Deposit.

• Led database selection committee and financial systems software selection committee for enterprise-wide deployment. Ladish Company, Cudahy, WI Systems Analyst January 1982 – January 1983

• Designed and developed manufacturing software applications for metallurgical engineering and testing for aerospace and military systems.

EDUCATION

University of Minnesota, Minneapolis, MN Degree Earned: June 1987 Master of Business Administration (MBA) in Management Information Systems: Emphasis on Finance, Data Engineering and Analysis, Program/Project Management and Systems Analysis. University of Wisconsin - Eau Claire, Eau Claire, WI Degree Earned: December 1981 Bachelor of Business Administration (BBA) in Management Information Systems: Programming Languages, Data Base Management Systems, Project Management, Systems Analysis and Design. PROFESSIONAL CERTIFICATIONS

• Project Management Institute (PMI) – Project Management Professional (PMP / PMBOK)

• Certified Scrum Master (CSM)

• Data Governance, CobIT, and ITIL Foundation Courses/ IT Governance

• AHIP’s Center for Insurance Education – HIPAA Professional Certification

• Institute for Professional Development (IPD): Principles of Instruction Design, Advanced Instructional Design, and Instructional Design for Online

Contact this candidate