Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

Joy Guenzler

Chatham

Summary

Seasoned Business Intelligence Analyst with background in converting complex data into actionable insights to drive decision-making processes. Skilled in analyzing trends, crafting detailed reports, and enhancing business operations through technology solutions. Demonstrated ability to work collaboratively across teams to implement improvements, leading to increased efficiency and productivity.

Overview

18
18
years of professional experience

Work History

EPM Developer

Springfield Clinic
Springfield
02.2022 - Current
  • Utilized advanced technical skills and expertise to troubleshoot complex problems and implement solutions.
  • Document requirements for Oracle Cloud EPM pods and cubes.
  • Create end user documentation.
  • Updated and maintained databases with current information.
  • Create BI Publisher reporting in Oracle Cloud ERP, SCM, and HCM using SQL for Oracle.
  • Work closely with Finance partners to create and maintain planning cubes and reporting.
  • Create business rules, and apply them to data using GRVY language.
  • Obtained and verified data accuracy with the help of SmartView Excel plugin.

Information Technology Support Associate

University of Illinois System
Springfield
08.2015 - 02.2022
  • Managed and applied patches to the Oracle Database that the CBORD TPS System utilized.
  • Uploaded monetary data into university carding system using .CSV formats.
  • Created and maintained reports in SAP Crystal Reports, utilizing SQL for Oracle.
  • Installed and maintained card reader equipment associated with the card reader system.
  • Maintained Excel spreadsheets for daily financial transaction reporting.
  • Collaborated with the Networking department to maintain Point of Sale equipment.
  • Created university identification cards for students and staff.

Stay at Home Mother

Self-employeed
Byron
09.2008 - 08.2015
  • Made choice based on necessity of medical care for eldest child during early years.

Annual Giving Officer

Prairie State Legal Services
Rockford
02.2007 - 09.2008
  • Managed annual giving campaigns for 11 legal aid offices.
  • Analyzed donation metrics and presented findings to each office's board of directors monthly.
  • Represented administrative offices during donor-focused events.
  • Contributed to development of marketing strategies for annual campaigns.
  • Oversaw direct mailing operations for annual giving campaigns.
  • Coordinated volunteers to assemble direct mail materials.
  • Created reporting using SAP Crystal Reports.

Education

Master of Science - Management Information Systems

University of Illinois At Springfield
Springfield, IL
05-2022

Bachelor of Science - Psychology

Bemidji State University
Bemidji, MN
05-1993

Skills

  • SQL mastery
  • Programming
  • Process documentation
  • Team collaboration
  • Database management
  • Cloud computing
  • SAP Crystal Reports
  • BI Publisher
  • Oracle Cloud ERP
  • Oracle Cloud HCM
  • Oracle Cloud SCM
  • Oracle Cloud EPM
  • SmartView for Excel
  • Pivot Tables

Affiliations

  • Computer and console gaming
  • Building Gaming PCs
  • Horseback riding

Timeline

EPM Developer

Springfield Clinic
02.2022 - Current

Information Technology Support Associate

University of Illinois System
08.2015 - 02.2022

Stay at Home Mother

Self-employeed
09.2008 - 08.2015

Annual Giving Officer

Prairie State Legal Services
02.2007 - 09.2008

Master of Science - Management Information Systems

University of Illinois At Springfield

Bachelor of Science - Psychology

Bemidji State University

Similar Profiles

CREATE PROFILE
Joy Guenzler