Kristin Van Deusen IT Co-Op Presentation IT Services Application - - PowerPoint PPT Presentation

kristin van deusen it co op presentation
SMART_READER_LITE
LIVE PREVIEW

Kristin Van Deusen IT Co-Op Presentation IT Services Application - - PowerPoint PPT Presentation

Kristin Van Deusen IT Co-Op Presentation IT Services Application Developer Enterprise Data Management April 29th 2016 About Me n Born and Raised in California n From Cleveland Area (Hudson) n First Co/Op and First Co/Op with Marathon n IT


slide-1
SLIDE 1

Kristin Van Deusen IT Co-Op Presentation

IT Services – Application Developer Enterprise Data Management April 29th 2016

slide-2
SLIDE 2

About Me

n Born and Raised in California n From Cleveland Area (Hudson) n First Co/Op and First Co/Op with Marathon n IT Enterprise Data Management Department

§ Supervisor: Sue Anderbery § Mentor: Shawn Mestelske

slide-3
SLIDE 3

Education

n Second Year at The University of Cincinnati n Major: Computer Science §Minor: Information Technology

– Software Development, Web Development and Mobile Applications Development

slide-4
SLIDE 4

Prior Experience

n Experience In:

§ HTML/HTML5 § CSS § MATLAB § Python § C++ § Swift

Play Game

High Scores Info

T I L E S L I D E G A M E

slide-5
SLIDE 5

Overview of Co-Op Projects

n Application Metrics Reporting Solution

§ The main objective focuses on defining metrics and reporting tools related to support, stability, usage, and performance of key application platforms for IT EDM.

n Business Objects Support

§ By offering BOBJ Support, I was able to help users resolve their issues and maintain data integrity.

n Business Objects Upgrade (SAP Release 2)

§ Part of Business Object’s capabilities relies on the upgrades within the system.

slide-6
SLIDE 6

Application Metrics Reporting Solution

6

n Created A Dashboard to Display Remedy Ticketing Information, PPM and BOBJ Audit Data

§ Effectively Organized Visual Representation of Data that’s Easily Shared and Accessible

slide-7
SLIDE 7

Application Metrics Reporting Solution

7

n Remedy Ticketing Information is entered through the Remedy Application

slide-8
SLIDE 8

Application Metrics Reporting Solution

8

n The information is then gathered and stored in a SQL Database

slide-9
SLIDE 9

Application Metrics Reporting Solution

9

n Created a Remedy Universe in the Information Design Tool.

slide-10
SLIDE 10

Application Metrics Reporting Solution

10

n Acquired Existing PPM and Business Objects Audit Universes

slide-11
SLIDE 11

Application Metrics Reporting Solution

11

n Utilized queries to pull in relevant reporting data and create a Web Intelligence Dashboard.

slide-12
SLIDE 12

Application Metrics Reporting Solution

12

slide-13
SLIDE 13

Application Metrics Reporting Solution

13

n Completed Definition Decision Support Package

slide-14
SLIDE 14

Business Objects Support

14

n Completed Migration Requests for individuals across each Business Area.

slide-15
SLIDE 15

Business Objects Support

15

n Configured security profiles using the Information Design Tool.

slide-16
SLIDE 16

n Validated and resolve issues within reports to maintain data integrity.

Business Objects Support

16

=If( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/1bdb8d95d922385ca3f6e893f17dbff8")) Then ("SFSFSessionHandlingLogoutQueryResult_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/5a52e1da585d3bf3a780dc9220646cf1")) Then ("SFSFSessionHandlingLoginQueryResult_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/74fcc02b6fad3d449b9b5478604366d3")) Then ("SFSFQueryHandlingSubmitJobQueryResponse_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/88b752be08043c47b34e74d96d33b0a4")) Then ("SFSFQueryHandlingGetJobResultEmbeddedQueryResponse_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/d37fef5f91cd3d3aa8dc01b9156ccb6c")) Then ("SFSFQueryHandlingGetJobStatusQueryResponse_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/6f890e531f6d3bdcbb90dbddd159fd22")) Then ("SFSFJobApplicationStatusUpdateRequestConfirmation_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/12c5ca64f2a43af59cc15a37c19eeb7d")) Then ("SFSFCandidateUserIdUpdateRequestConfirmation_Out") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://ICO/d1e902b5899538d5a80dfdeab98a892d")) Then ("MailNotification_Async_Out ") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://IFLOW/MPAC_MPCtoAristotle")) Then ("MPCtoAristotle") ElseIf( Match([Query 1].[PI Scenario Identifi (0SM_SCENL)].[PI Scenario Identifi (0SM_SCENL) - Key];"dir://IFLOW/MPAC_SPDWYtoAristotle")) Then ("SPDWYtoAristotle")

slide-17
SLIDE 17

Business Objects Support

17

n Created and set up BOBJ access for Speedway Test IDs.

slide-18
SLIDE 18

Business Objects Upgrade (SAP Release 2)

18

n Created and Pulled in Test Cases and Test Sets in HPQC for each Testing Group

slide-19
SLIDE 19

Business Objects Upgrade (SAP Release 2)

19

n Performed and revised BOBJ Post-Upgrade Validation Test Cases.

slide-20
SLIDE 20

Business Objects Upgrade (SAP Release 2)

20

n Gave BOBJ Upgraded Features Presentation to The Enterprise Reporting & Analytics CoP

slide-21
SLIDE 21

n Created a Web Application that increased the performance of the

  • nboarding process using Visual Studio (C#, .NET, CSS, HTML)

Hackathon Project

21

slide-22
SLIDE 22

Hackathon Project

22

slide-23
SLIDE 23

Knowledge Gained During Co-Op Term

n Business Objects

§ Web Intelligence § Information Design Tool

n Microsoft SQL Server n Remedy n PPM/Project Management n Microsoft SharePoint n ODBC Drivers n Project Lifecycle Development

§ General Decision Support Package

slide-24
SLIDE 24

The Marathon Co-Op Experience

n Things I Enjoyed about Marathon

§ Opportunity to Work in Teams § Responsible for Tasks Outside Skillset § Assigned Real Projects § Opportunities to Get Involved

n Potential Improvements for Marathon

§ Provide Skill Workshops/Training

– SQL, Visual Studio, Excel, etc.

§ Increase Exposure to Other Areas of IT

n What Universities Can Improve On

§ Assign Documentation as Part of Project Development § Provide Courses about Different Types of IT

slide-25
SLIDE 25

Questions?