Barbara J. Reagan

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

Uniontown, OH 44685

abmo5y@r.postjobfree.com

Home: 330-***-****

Cell: 330-***-****

SUMMARY

. Results-driven Problem-Solver with 20+ years of being a relied upon team

player, customer service provider, contributing where needed and meeting

deadlines.

TECHNICAL SKILLS

Software: Microsoft Office (Word, Access 2007, Excel

(Pivot tables, Vlookup, If statements),

PowerPoint, Outlook), MS Internet Explorer,

Dreamweaver, HTML, SAS, SQL Server 2000,

Enterprise Manager, TSO, SPF, Business

Objects, File-Aid, CICS, BM204, RACF, VSAM,

WordPerfect, WEBEX

Code Types: T-SQL, HTML, JCL, IBM Basic, SAS

Operating Systems: Microsoft Windows NT and up

Database: Familiar with SQL based databases (SQL Server

2000), mainframe files including VSAM.

Hardware: Worked on Intel XEON system and IBM Mainframe,

Citrix

PROFESSIONAL HIGHLIGHTS

2009-Present

COMSYS, Independence, OH

Consultant at AultCare, Canton, OH (October 2009 - Present)

. Help Desk for web inquiries including password reset, account creation,

log in issues

. Update current website using Dreamweaver, HTML, PHP, SQL

. Update Intranet using Dreamweaver, Oracle Portal, SQL

1988-2009

YRCW, Inc., Overland Park, KS / Roadway Express, Inc., Akron, OH

Operations Specialist/Engineer II (April 2006 - April 2009)

Dreamweaver

. Create & maintain statistical web pages using Dreamweaver and SQL Server.

. Redesign Average load pages in Dreamweaver for new freight flow network.

. Create additional web pages using Dreamweaver for reporting of key

financial statistics when new system not available.

. Convert Cargo Claims and Shipment Exception reports from mainframe to

intranet.

. Monitor error reports sent to Outlook folder and correct web pages using

Dreamweaver.

. Partner with IT to obtain data when needed.

. Using Dreamweaver, SQL, SAS and Excel, test pages and data for accuracy.

Excel

. Create pivot tables in Excel for data export from SQL database for use by

other departments.

. Design ad hoc analysis and reports as needed using Excel.

SQL

. Create new tables on SQL Server.

. FTP data from Mainframe to SQL Server using JCL program.

. Create Data Transformation Service (DTS) packages to move SQL text file

into SQL table.

. Audit SQL queries for other department Analysts. Make corrections as

necessary.

. Write SQL query to obtain number of picked up and delivered shipments in

a set time frame for Project Management.

. Write SQL query to obtain specific customer information for a set time

frame for co-worker.

. Write SQL query to obtain over time hours by day of week for specific

terminals and time frame for Regional Facility Manager.

SAS

. Assist Customer Engineering and Field Engineering with JCL and SAS

programming.

. Utilizing SAS and JCL programming skills to access data from mainframe

for analysis. Promote programs to run in production environment. Send

release forms to Operations Technology to upload final product.

. Assist Accounts Payable with SAS programming problems. Creator of

program was no longer with the company and when the program variables

were changed the data was incorrect. Program user in Kansas faxed

programming section to me and I sent a solution to the problem.

Additional

. 6 Month assignment with Roadway Reverse Logistics warehouse managers and

customers to maintain Data Warehouse using Oracle report forms, entered

customer, dealer, price and parts information.

. Supported Customer Service due to call overload: answered calls from

customers and entered shipment information onto Intranet forms which

updated M204 database so Terminal Dispatcher could send a driver to pick

up customer freight.

. Answer Field Management's questions regarding Average load statistics and

calculation. End users included general office staff, 14 Area Directors

of Operations and 32 Regional Facility Managers.

. Facilitate with end user to implement improvements & changes by

partnering with Operations Planning Manager to develop new average load

pages to support new freight flow.

. Trained and Assisted I&E Analyst in the restatement of data in 2007.

Answered questions regarding consequences due to suggested programming

changes.

Income & Expense (I&E) Analyst Sr. / Specialist (September 2000 - April

2006)

. Responsible for the profit/loss report final process for over 300 field

terminals which included monitoring systems in the mainframe JCL runs,

troubleshooting and ensuring successful runs by monitoring JCL sysouts

with data rolling up to area, district, division and total company.

. Lead the I&E report web design team. -

o Change venue from BM204 to Intranet.

o Partner with IT to ensure historical functionality including

drilling into detail and accounting format.

o Create Excel spreadsheet mock ups of layouts for Web pages

including data map.

o Test pages for functionality and data integrity using SAS, IBM

Basic and Excel.

o Coordinate I&E department testing. Maintain Excel spreadsheet

of errors. Report findings to IT lead.

o As end user, responsible for the line descriptions, column data

type and calculations. This was maintained via text files that

were downloaded, sent to me, edited and returned for loading.

. Liaison to the IT Security department -

o Served as point of contact for user id issues, departmental SOX

compliance, & audit access to departmental files.

o Reset Mainframe passwords, approved access to I&E databases.

. Maintained RACF security access on restricted user mainframe files.

. Collaborate with IT department:

o to solve system failures & errors; recommend & implement system

improvements. Systems constantly monitored during closing

cycle (10 business days). System failures solved ASAP due to

immovable report deadline. System improvements were when time

permitted, upgrades made immediately if business requirement

changed. Total time spent 20-40% depending on other job duties.

. Updated existing JCL and IBM Basic programming for the density study

group.

. Write programs using JCL and SAS for General Accounting to use in

distribution of accruals.

. Restate two years of I&E and general ledger data from Period to Monthly

detail.

. Maintain integrity of historical data. Terminal level data is summarized

to regional, district, division and total company level. The

summarization was stored in files used for analysis purposes. Upon

closing or realigning any one of these levels, the data had to be

manipulated and restated using a combination of SAS and IBM Basic

programming.

. Create ad hoc analysis & reports as required using SAS and/or Excel.

. Design weekly and monthly reports using IBM Basic and SAS, and download

reports to Excel for distribution.

. Answer Field Management's questions regarding monthly reports.

. Consolidated District information in Excel spreadsheet for District

Secretary to eliminate manual typing of terminal level detail.

. Assist other Analysts with programming questions.

. Assume part of Payroll Analyst functions until replacement trained.

. Assist Department Manager with PC issues (missing tool bar, proof-read

memos, etc.)

Income & Expense Analyst / Analyst Sr. (May 1997 - September 2000)

. Rail Analyst - document, maintain, design & improve programs and

processes for the Intermodal cost & payment structure. Oversee payment of

rail companies.

. Trouble-shoot JCL, CList, SAS and IBM Basic programming and data errors

for assistants running payment process.

. Maintain rail rate tables. Create ad hoc analysis & reports as needed

using JCL, SAS, IBM Basic and Excel. Create ad hoc analysis & reports

using JCL, IBM Basic, Excel.

. Answer Field management questions regarding line haul cost and rail

issues.

. Work with Risk Management to determine actual miles for excess insurance

report.

Income & Expense Line Haul Ocean Assistant June 1994 - May 1997

Income & Expense Freight Cost Assistant July 1991 - June 1994

Accounts Payable Assistant March 1988 - July 1991

EDUCATION

. Bachelor of Science; Natural Science The University of Akron, Akron, OH

Areas of study include Mathematics, Physics, Chemistry & Engineering

. 2008 Continuing Education classes in Dreamweaver, Photoshop

. 2009 Continuing Education classes in Access levels I & II

Contact this candidate