Brian Shore

** *** ***** *****

Madison, WI *****

phone: 608-***-**** email: adxesz@r.postjobfree.com

Employment History

Payroll and Benefits specialist, March, 2020 – present

Dept of Geography, UW-Madison, Madison, WI

Processing payroll and benefits information into the PeopleSoft HRMS / HCM payroll system. Using Cypress, JEMS, OBIEE and Wiser ETL system for hiring and funding data. Doing salary cost transfers including fringe costs. Providing Payroll and Benefits counseling for faculty, staff, and graduate student employees who are domestic or international. Administering the hiring process for student hourly, short-term staff, and graduate student appointments. Doing I-9 verifications using HireRight. Working with Office of Human Resources (OHR) and UW System Shared Services to resolve payroll and benefit issues. Escalate complicated questions and problems to L&S Payroll division and Office of Human Resources (https://hr.wisc.edu/). Member of University Staff Congress and Recreation & Well Being Advisory board.

IS Business Automation Senior, Business Analyst, LTE, August, 2019 – March, 2020

Dept of Corrections, State of Wisconsin, Madison, WI

Wrote Transact-SQL (T-SQL) queries to select data used by cloud based vendor software (Jail Tracker by Caliber Public Safety) to produce reports and forms analyzing youth prison population in the State. The software uses DevExpress for designing the reports and forms, and Visual Basic for scripts. Used MS SQL Server for testing queries. Worked with other Business Analysts to design the forms and reports. Increased my SQL knowledge by reading lessons from W3 Schools (https://www.w3schools.com/) and discussing topics on Stack Overflow (https://stackoverflow.com/).

IS System Development Services Senior, Software Tester in PeopleSoft, January, 2012 – May, 2018

Dept of Information Technology (DoIT), UW-Madison

Performed Regression Testing in the QA environment with end-to-end test plans for the UW System Administration’s HRS (Human Resource System). This is a large PeopleSoft HCM ERP system containing data on all UWSA employees consisting of Absence Management, Benefits, Finance, HR, Payroll, Time and Labor modules. Created and executed test cases. Did manual testing and automated some scripts using PTF (PeopleSoft Test Framework). Ran SQL queries with SQL Developer to select test data. Ensured that deliverables met the functional and technical specifications and requirements. Worked with Business Analysts and PeopleSoft developers to resolve test problems when they occurred. Used JIRA to track results and issues encountered. Used PeopleSoft Process Scheduler and Tivoli Workload Scheduler TWS to run batch test jobs in PeopleSoft. Updated WIKI and documentation about test outcomes, batch jobs and on-line scripts, methods, schedules, and results. Reviewed SIS (Student Information System) PeopleCode using Application Designer to see if it met documentation standards. Used Microsoft office products Word, Excel, Outlook, and Visio.

IS System Development Services Senior, Hyperion Report writer, June, 2011 – December, 2011

Dept of Information Technology (DoIT), UW Madison

Received training in and developed reports for (Enterprise Performance Management) Data Warehouse using Hyperion.

IS System Development Services Senior, mainframe programmer/analyst, 2006 – May, 2011

IS System Applications Programmer Entry, mainframe programmer/analyst, Feb 2000 - 2006

Dept of Information Technology (DoIT), UW Madison

Maintained IBM mainframe COBOL and SAS programs for the UW System Administration Payroll system and IADS Appointment System. Some programs used IMS files and some used embedded DB2 and SQL relational database queries. Developed JCL to run jobs. Developed test plans and executed them. Worked independently and as part of a team. Debugged COBOL programs using Display statements and an automated debugger. Used TSO, ISPF, and Panvalet editor. Wrote QMF queries and reports. Main SAS procedures used were Datasets, DB2EXT, Export, Format, Freq, Import, Print, Printto, Report, Sort, SQL, and Tabulate. Used MicroSoft office products Word, Excel, Outlook, and Visio. Wrote documentation for programs. Some of the program applications were:

-Employee Earning Statements, Leave Statements, Annual Benefit Statements, W2 and 1042 Statements.

-Income Continuation Insurance (ICI), SECC pledge forms, and annual OSHA report.

-Fiscal Year end and Calendar year end reporting and processing. -Employee pay raises.

IS System Applications Programmer Entry, mainframe programmer/analyst, July 1997 – Jan 2000 Dept of Information Technology (DoIT), UW Madison

Maintained mainframe SAS programs for UW System Administration. Provided reports for the Office of Policy Analysis and Research (OPAR) that analyzed student data such as demographics and retention. Worked on Y2K remediations.

Management Information Specialist 3, MicroFocus COBOL programmer, March 1996 – Sept 1996

Dept of Revenue, State of Wisconsin, Madison, WI

Worked on mainframe and MicroFocus COBOL programs and reports for the Delinquent Tax Section.

Lecturer, 1995, Fall semester, Aug 15, 1995 – Dec 31, 1995

Edgewood College, Math and Computer Science dept, Madison, WI

Taught “Intro to Computers” course for one semester. Taught students how to use PC’s and MicroSoft Office software for word processing, spreadsheets, databases, presentations, and email.

Teaching Assistant, 1994, Spring semester, Jan 1, 1994 – May 31, 1994

UW Madison, Computer Sciences dept, Madison, WI

Taught a lab section of the “Intro to Computers” course for one semester. Taught students how to use PC’s and MicroSoft Office software for word processing, spreadsheets, databases, presentations, and email.

Education

M.S., Information Systems

University of Wisconsin, Madison, WI. School of Business.

BBA, Information Systems

University of Wisconsin, Madison, WI. School of Business.

IT skill classes Training classes from Madison College Continuing Studies:

“WordPress Into” March, 2022.

Certificate - https://www.credly.com/badges/29f7b272-d1c6-44d5-86ae-d02d6dc384c5/public_url

“HTML and CSS Intro”, Fall, 2021.

“Java Programming: Intro”, July, 2018.

Certificate - https://www.credly.com/badges/3bc46a43-feb9-473e-a5f4-3677a63217e8/public_url

“Python Programming: Intro”, November, 2018.

Certificate - https://www.credly.com/badges/b98a9b64-bbeb-4a36-99d6-0df0bda9f8cd/public_url

Business Analysis and Technical classes

Asking Effective Questions During Requirements Elicitation by Joyce Onore. May 29, 2023.

https://www.linkedin.com/learning/certificates/5fa33b2ec08813bd5919b217d954682e53bf2dc8aabe62d8a630cbe0ab37c040

Business Analysis: Essential Tools and Techniques. By Jamie Champagne. May 20, 2023.

https://www.linkedin.com/learning/certificates/5cddbe0f1bdf55fd01a2a3366e5c0e0bf3b573714eae5dca16cebce085896da1?u=56745513

Reading Financial Statements. Corporate Finance Institute. May, 2023. Online course.

https://learn.corporatefinanceinstitute.com/course/learn-to-read-financial-statements-free-course

Certificate - http://credentials.corporatefinanceinstitute.com/05fd01f9-19e7-47e2-af40-3bf61f216a7a

Statistics Fundamentals. Corporate Finance Institute. April, 2023. Online course.

https://corporatefinanceinstitute.com/course/statistics-fundamentals/

Certificate - http://credentials.corporatefinanceinstitute.com/48517fbb-a33e-4ae0-a25a-1dc17ce1db4f

Root Cause Analysis by NewHorizons, April 20-21, 2023. Learned to apply several practical, systematic methods for analyzing incidents and problems to uncover root causes.

https://www.newhorizons.com/course-details/SKU60076NH

Certificate - https://www.credly.com/badges/601bca9d-a50d-46a3-b636-4d2a952429bb/public_url

White Belt Six Sigma Lean course and passed exam from Six Sigma Society. March 12, 2023. Covered basics of six sigma, DMAIC lifecycle and basics of Define, Measure and Improve phases. Certificate - Certificate - https://www.credential.net/fe28b4af-657b-4f94-b972-d23d83989299#gs.rt8sil

Data Analysis part of Google’s “Data Analytics” course on Coursera. July, 2022 - December, 2022. Topics covered included data types and structures, using data to solve problems, cleaning data. analyzing data using Excel and SQL, and database concepts.

Certificate - https://coursera.org/share/f618ed096c53e3d8b577636dffdb8b8f

Data storytelling with Visualizations part of the Google “Data Analytics” course. January, 2023. Covered how to visualize and present data findings, and an introduction to Tableau. Certificate - Certificate - https://coursera.org/share/48c8d9e81e048610d1705da7515297ff

Agile Scrum for Project Management. UW Continuing Studies. Oct 27-28, 2022. This class builds foundational knowledge of Scrum and equips you with skills to effectively manage, lead or be a member of a Scrum team. https://continuingstudies.wisc.edu/classes/agile-scrum/

Business Analysis Essentials BA-01. By New Horizons. November 11-12, 2021. Students learn how a business analyst supports the project throughout the solution development life cycle, from defining business needs and solution scope to validating that requirements have been met in the testing phase and ensuring the solution continues to provide value after implementation.

Certificate - https://www.credly.com/badges/b4399e54-10e7-4f16-8c5b-e03987f63035/public_url

Agile Fundamentals Training. By AgileTraining.co. August 20, 2021. Discovered the true nature of Agile and what it takes to become an Agile Professional, an Agile Team and an Agile Organization. https://www.agiletraining.co/free-agile-fundamentals-course/

Fundamentals of Project Management. UW Continuing Studies. June 23-24, 2021. Gain foundational knowledge and explore contemporary best practices in project management to build the personal knowledge, skills and confidence you need to effectively lead projects. https://continuingstudies.wisc.edu/classes/fundamentals-project-management/

Data Science and Machine Learning Fundamentals. Corporate Finance Institute. July 24, 2021. https://corporatefinanceinstitute.com/course/data-science-and-machine-learning/

Certificate - https://pdf.credential.net/uw7rmwpf.pdf

Introduction to Business Intelligence. Corporate Finance Institute. June 12, 2021. https://corporatefinanceinstitute.com/course/introduction-to-business-intelligence/

Certificate - http://credentials.corporatefinanceinstitute.com/74bfb0a6-e39b-4480-8ab0-cd2b72cd6ba7

Managing Time, Multiple Priorities, and Interruptions. UW Continuing Studies. February 25, 2021. Learned to identify behaviors and create strategies that helped manage multiple priorities and handle interruptions to be more effective at work.

https://continuingstudies.wisc.edu/classes/manage-time-priorities-interruptions/

Agile/Scrum Workshop. March 5, 2020. UW-Madison.

Learned about Scrum team roles, artifacts, techniques, and ceremonies..

https://www.talent.wisc.edu/Catalog/Default.aspx?CK=67260

Diversity classes and forums Understanding and Mitigating Bias to Enhance Inclusion. Binnu Palta Hill, Wisconsin School of Business's Chief Diversity and Inclusion Officer, UW-Madison. Feb 15, 2023. Discussed the origins of implicit bias and its role in our everyday lives. Using neuroscience and psychology research, engaged in a process of self-awareness about how unconscious bias affects us, others around us, and our ability to do our best work.

Diversity Forum. Sponsored by Division of Diversity, Equity & Educational Achievement, UW-Madison.

October 27-28, 2020. I listened to keynote and breakout sessions about diversity, equity and inclusion. https://diversity.wisc.edu/diversity-forum-2020-videos-resources/ November 14-25, 2022 https://diversity.wisc.edu/diversity-forum/ November 2-3, 2021. https://diversity.wisc.edu/diversity-forum-2021/

Intentionally Creating a Workplace Culture that Values Justice, Equity, Diversity, and Inclusion. Online session by Kelvin Alfaro. June 23, 2022.

HR related classes

“Coaching Circles Intro Course”, May 25, 2023. UW-Madison Professional Development.

https://hr.wisc.edu/professional-development/programs/coaching-circles/

“Listening for a Change: Skills for Inclusivity”, April 25, 2023. UW-Madison Continuing Studies. https://continuingstudies.wisc.edu/classes/listening-for-a-change/

Thrive@UW-Madison: Active Listening to Support Effective Communication. January 26, 2023.

https://hr.wisc.edu/professional-development/programs/thrive-at-uw/active-listening-to-support-effective-communication/

Thrive@UW-Madison: Thriving in a Time of Change. January 18, 2023.

https://hr.wisc.edu/professional-development/programs/thrive-at-uw/thriving-in-a-time-of-change/

Hostile and Intimidating Behavior Policies & Processes. November 17, 2022. https://hr.wisc.edu/hib/training/

Connect, Learn, and Grow: Fundamentals of Visual Communication. July 7, 2022.

https://today.wisc.edu/events/view/170850 https://www.talent.wisc.edu/Catalog/Default.aspx?CK=74090

Identify and resolve key problems. April 14, 2021.

https://hr.wisc.edu/professional-development/courses/identify-and-resolve-key-problems/

Modes of Conflict Management. Feb 18, 2021.

https://hr.wisc.edu/professional-development/programs/fully-prepared-to-lead/modes-of-conflict-management/

Time and Self-Management. Feb 3, 2021.

Project Management Basics. January 18, 2021.

EQ Skills & Strategies: Perspective Taking. Oct 15, 2020.

Conferences

IT Professionals Virtual Conference 2021. June 4, 2021. https://itproconf.wisc.edu/archive/presentations-2021/ IT Professionals Virtual Conference 2020. June 4, 2020. https://it.wisc.edu/news/registration-now-open-for-2020-it-professionals-conference/

Information & Technology Leadership Conference 2021. Nov 30, 2021. Information & Technology Leadership Conference 2020. Dec 1, 2020.

Cloud computing, Kubernetes, and Security. February 4, 2020. Middleton, WI.

Speakers from Angelbeat, AWS, SSH, Synercomm, and Trend Micro.Cloud computing, Kubernetes, and Security. February 4, 2020. Middleton, WI.

Speakers from Angelbeat, AWS, SSH, Synercomm, and Trend Micro.

https://www.eventbrite.com/e/angelbeat-madison-feb-4-amazon-cloud-containers-ai-security-deepfakes-registration-902********

MIDHEUG PeopleSoft Users conferences. 2014 – 2016, Middleton, WI.

I attended these annual conferences for PeopleSoft users in the Midwest. The Midwest Regional User Group (MIDHEUG) which includes Kansas, Illinois, Indiana, Iowa, Michigan, Minnesota, Missouri, Nebraska, North Dakota, Ohio, South Dakota, Wisconsin is a HEUG facilitated online community. It is used to interact with other higher education institutions in the region who use Oracle applications/technology.

https://www.heug.org/midheug

WI Illinois SAS Users Group (WIILSU) conferences. 2002—2008, Madison, WI

I attended several of these annual conferences for SAS users in WI and Illinois. http://www.wiilsu.org/

Contact this candidate