Imagination at work.

Manager: Amit AgarwalJuly 21, 2014

FMP Summer Internship 2014Molly McWilliams

2

Molly McWilliams

FMP Internship | 21 July 2014

Pennsylvania State UniversityFinance B.S., Economics B.S.Class of 2016

Penn State Women’s Water PoloTravel Team Member

Penn State Investment AssociationAnalyst, Industrial Goods Sector

HometownErie, Pennsylvania

InterestsTravel, sports, reading, watching movies

Current AssignmentGSS Risk InternSpecific Area: Risk Analytics ValidationManager: Amit Agarwal

2010 20112012

2013+Standardize process

Store audited data in Excel

Modeling automation

Reset

CMR Automation Overview

FMP Internship | 21 July 2014

Focus on establishing sustainable processes

Background

PM/Fin. (LDM)J. Steger-Parker

Tech. ModelingN. Christopher

Key contacts

LDM ITS. Shah

MWHR ITK. Davis

Durability Eng.A. Tomasik

IT PMA. Peterson

Dedicated teams driving automation execution

Inputs enable automationData

InputsRepositor

yKey

Projects

3

Loco Status

MWHR/ Mileage

In service dates

OH schedule

Contract start/end

Loco Datamart

(LDM)

• Creates single repository for required inputs

• Eliminates duplication of tasks

• Allows for repeatable, auditable process to exist

Billing

Tech. Modelin

gFinancial Modelin

g

MWHRs

Loco Databas

e

Key benefits of automation

Summer projects focus areas

Functional OwnersTechnical Owners

4

Locomotive status

FMP Internship | 21 July 2014

Loco status overview

Project objectives

• Ensure data in LDM ties to CMR audited files• Manually adjust status and contract start/end

in LDM• Work with IT team to manually adjust as

required

What is loco status?Loco status tracked daily as active or non-active to help derive loco count, an input used for billing and CMR process.Why is it important?• Enables Billing and CMR modeling

automation

Business impact Next steps

Operational activity in field

LDM Loco Datamart

eServices Data Warehouse

LDM UIMonthly

Team collects operational status data,

loads to LDM

LDM automatically updated

1

2

3 Built manual CMR loco count for 3 customersSnapshot built critical for CMR modeling project

Tested IT enhancements pre-releaseID’d bug impacting gross loco count accuracy

Validated CMR net loco count for 3 customersUpdated status of 80,640 locos in LDM

1

2

3 Eliminate need for manual report adjustmentsShare ‘lessons learned’ to fix future snapshots

Complete validation of gross loco count reportEnsure report ready to use in CMR modeling

Complete validation of 3 additional customersPrioritized based on need for future CMRs

5

Megawatt hours

FMP Internship | 21 July 2014

• Obtain CMR audited files with MWHR PIT-a)

readings• Validate & store CMR PIT readings in LDM user

interface• Reconcile accuracy of reports used as CMR

output(a-Point In Time = most recent MWHR reading)

Business impact

1

2

3

Next steps

Built single repository for 2013 PIT readingsClosed 8,850 MWHR readings for 9 customers

What is a Megawatt Hour (MWHR)?Indicator of locomotive usage, collected each time locomotive enters service shopsWhy is it important?• Indicator for future overhauls on

locos• Used for deriving overhaul schedule• Enables CMR modeling automation

LDM Loco Datamart

Data Warehous

e

MWHR Report

Operational activity in field

Update readings in MWHR UI

DE downloads SAS report for modeling

MWHR overview

Project objectives

Validated 4 LDM MWHR reports used for CMRsEnsured accuracy in report logic

Identified MWHR report logic errorsPartnered with IT to implement SAS fixes 1

2

3 Work with KTZ CMR team to validate readingsAdd KTZ 2013 PIT readings to repository

Validation of LDM reportsDocument reports and purpose for CMR team

Develop ongoing validation processIT to own executing validation prior to each CMR

6

Key takeaways

FMP Internship | 21 July 2014

Effectively communicating with management and executives

Obtaining buy-in while interacting with a cross-functional team

Developing an operational understanding of the business

Building relationships with the risk team, FMPs, and fellow interns

7

Questions?

FMP Internship | 21 July 2014