Higher-Ed Banner Architect – Scott Padberg

Description

31 Years as Higher-Ed Banner Architect

IT consultant with more than 27 years of experience in a complex higher education setting. He has wide ranging expertise in a variety of IT disciplines including team management, database design, programming, Business Intelligence, and architecture design. He is an analytical and conceptual thinker who effectively partners with both technical and functional stakeholders at all levels in an organization to assess opportunities, facilitate strategic decisions, and drive successful implementations.

Work Experience

Technical Team Lead / Data Warehouse / ODS Architect

ULTIMATE CONSULTING

Lebanon, GA

April 2014 to Present

Lebanon, GA 

  • Banner ODS optimization and customization
  • Specializing in IT consulting services for Higher Education 
  • Technical Team Lead / Architect – Enterprise Data Warehouse group, 4/2014-present 
  • Working as contract employee with University of South Carolina system as technical team lead and data 
    warehouse / Business Intelligence architect. 
  • Designed/developed data warehouse reporting structures to support functional reporting 
    requirements 
  • Designed/developed custom solution for date-tracked history reporting 
  • Managed data delivery team 
  • Designed/developed Cognos Framework Manager models, Transformer models and OLAP cubes 
  • Coded Oracle PL/SQL procedures, functions, and packages for ETL processes

Business Intelligence Architect / Developer

UNIVERSITY OF ALABAMA AT BIRMINGHAM

Birmingham, AL

September 2013 to Present 

  • Hired by the university post retirement to develop various components and solutions utilizing IBM Cognos 
  • 10.2 product suite to support and enable new Business Intelligence initiatives. 
  • Designed/developed star schema to support a key Business Intelligence initiative 
  • Designed/developed Cognos Framework Manager models, Transformer models and OLAP cubes 
  • Designed/developed Report Studio drill-through and drill-across reports 
  • Coded Oracle PL/SQL procedures, functions, and packages for ETL processes and other tasks

Owner and Independent Contractor

DiCon IT Solutions, LLC

Hoover, AL

July 2013 to Present

7/2013-present 
Current clients: 
Inventure Renewables, Inc – Tuscaloosa, AL 
A Tuscaloosa-based renewable fuels research company 

  • Developed and implemented a comprehensive IT strategy for the company 
  • Designed and implemented network infrastructure for newly-acquired 64,000 sq ft facility: 
  • Completed build-out of private local area network for analytics lab 
    • Installed/configured core hardware and services (switches, firewall/threat management 
      device, servers, network storage, network printing, uninterruptible backup power, 
      workstation configuration, VLANs, VPN, user accounts) 
    • Installed/configured wireless network to cover entire facility (private and guest 
      networks) 
    • Migrated website and email to new hosting service 
    • Configured cloud backup services 
    • Provided end user training and tutoring 
    • Coordinated installation/configuration of business Internet service and IP phones
    • Provide general IT support and consultation (retainer) 
       
  • Meng Analysis – Seattle, WA 
    A nationally recognized Value Engineering and Architecture firm 

    • Provided extensive support and programming for the Facility Condition Assessment 
      database currently utilized by dozens of city and county government clients in the Greater 
      Seattle area 
    • Built reports, tables, views, code modules, and data entry forms utilizing MS ACCESS 2010 
      front-end database 
    • Designed and coded custom Budget Modelling module to detail predicted cyclical facility 
      component renewals, track proposed budget expenditures, and provide a “sandbox” for users to experiment with various budgeting scenarios

IT System Architect

UNIVERSITY OF ALABAMA AT BIRMINGHAM

Birmingham, AL

May 2012 to June 2013

  • Promoted to new role as Architect in support of Identity Management and related solutions. Lead effort to design next-generation Identity Management solutions and build technical/operations team to support this 
    effort. 
  • Identified and researched IdM solution providers. 
  • Documented detailed functional requirements, computing ROI and TCO. 
  • Composed and issued RFQ documents. 
  • Designed technical architecture to consolidate functionality of seven independent card systems into a 
    single, campus-wide smart card, resulting in an estimated $300K annual cost savings (effort began during previous position).

Director

Office of Technology and Information Services

August 2005 to April 2012

  • Promoted to lead newly created comprehensive Information Technology services unit.
  • Manage application development, reporting, help desk, data integrity, and infrastructure functions, providing a wide variety of custom Information Technology solutions and information services for strategic decision support.
  • Direct projects providing customer service and technology consulting. Interface with stakeholder’s management team and functional users to define project requirements. Manage design and delivery of end-to-end solutions.
  • Translate organizational objectives into tactical plans and systems. 
  • Managed/directed team of eleven full-time employees. 
  • Responsible for $800K operating budget. 
  • Directed conversion of over 100 existing web-based applications and reports from mainframe legacy 
    system foundation to Ellucian (Sungard) Banner ERP system. 
  • Instituted new procedures for data delivery – established secure portal for data request and delivery to constituents, servicing over 500 requests annually utilizing Cognos BI and native PL/SQL. 
  • Conceptualized and performed extensive design work on the enterprise data mart, including 
    development of packages, procedures, views, and dimensional models exposed to Cognos BI. 
  • Served as primary administrator of Cognos BI system for campus. 
  • Created a reporting system to provide real-time comparative activity reports by market segment, 
    building underlying data structures and parameterized drill-down report dashboards in Cognos BI. 
  • Managed infrastructure and desktop support team. 
  • Managed the acquisition and implementation of campus-wide pay for copy/print system. 
  • Created new position for Identity Management and data integrity. 
  • Directed development of the UAB academic alert system. 
  • Led ongoing technical development and management of the campus card E-Commerce system used for service access, declining balance debit, cardholder identification, and physical security. 
  • Served on campus-wide committee to establish PCI standards for campus merchants. 
  • Assisted in the development or curriculum for online FERPA course.

Director for Systems Design and Development

Office of Technology and Research

September 1993 to July 2005

  • Promoted by Vice President to establish strategic and tactical Information Technology infrastructure for the division.
  • Designed the scope of services, created and implemented server infrastructure, and hired 
    staff to provide end-user support. 
  • Managed team of two full-time and two part-time employees. 
  • Responsible for $150K operating budget. 
  • Acted as Network Administrator, installing and maintaining server infrastructure. 
  • Established new help desk operation to support approximately 200 users and over 500 nodes. 
  • Created and managed a division-wide user support committee by identifying and training 
    departmental contacts to provide first-response end user support. 
  • Established a computer lab for instructor-led and computer based training for commonly used 
    software. 
  • Scheduled, organized, and conducted organized software training sessions for staff. 
  • Provided operations and programming support for an automated interactive voice response system to provide touch-tone access to class registration, application information, and fee payment. 
  • Implemented new Microsoft Exchange infrastructure for division, and performed the conversion from existing mail and calendar system.

Systems Analyst

Office of Enrollment Management

August 1991 to August 1993

  • Promoted to Systems Analyst with emphasis on data analysis, reporting, and conversion of departmental 
    software system. 
  • Designed systems and methods for producing timed, dynamic correspondence to prospects. 
  • Assumed a lead role in the conversion of departmental minicomputer software system to a new 
    mainframe system, including user needs assessment, database content, screen layout, program 
    specification, and data flow analyses. 
  • Wrote application programs in COBOL, Microsoft ACCESS, SAS, Pascal, FoxPro, IBM Script, and IBM 
    JCL. 
  • Served as liaison between functional side users and technical developers in central computing 
    services.

Assistant Director – Computer Operations

Office of Undergraduate Admissions

July 1986 to July 1991

  • Administered all aspects of departmental mini-computer system – programming, maintenance, backups, 
    terminal installation, magnetic tape processing, upgrades, interfaces with campus mainframe. 
  • Maintained existing applications and wrote new applications in COBOL. 
  • Designed and wrote a set of routines using machine language and COBOL to correct data entry errors and convert mailing addresses from upper-case to mixed case. 
  • Designed and wrote a PC-based system for data collection used in constructing the campus class 
    schedule. 
  • Supervised office staff of six employees. 
     

Technology 
Systems/Software: Oracle 11g db, Sungard Banner, Oracle11g PL/SQL, Sungard Operational Data 
Store, IBM Cognos 10.2 (Report Studio, Analysis Studio, Query Studio, 
Framework Manager, Transformer, Administration & Security), BlackBoard 
Transaction System, UniPrint, Microsoft Office, Microsoft Office VBA, Microsoft SQL 
server, Microsoft Active Directory, Microsoft Windows Server 20xx, Novell 
eDirectory, Micorsoft Exchange server, Microsoft IIS, LDAP, Oracle Discoverer, 
Microsoft SQL, TCP/IP, DHCP, VLANs, VPN, IBM Mainframe technologies

Education

Bachelor of Science in Business

UNIVERSITY OF ALABAMA AT BIRMINGHAM

Birmingham, AL

1986

Additional Information

  • ITIL v3 Foundations Certified E-Commerce Systems 
  • Team Management Stakeholder Relationships 
  • Strategic Planning Systems Integration 
  • IT Service Delivery Identity Management 
  • Software System Design Data Warehousing 
  • Business Intelligence IBM Cognos 10.2