PeopleSoft EPM - DataStage Developer

Michael Dean

**** **** **** **. ******, Id ***** C: 208-***-**** abupwc@r.postjobfree.com

IBM DataStage ETL Developer

Nine years of professional experience in server systems analysis, application integration, and

Infrastructure/database design from a business operations perspective. Three years of experience using

PeopleSoft Campus Solutions, OBIEE, IBM DataStage, Oracle EPM, and Oracle Database

technologies. Strong experience administrating DataStage 8.1 and 8.5, PeopleSoft Portal, which

includes, development, security, integration with third party applications, performance testing, and

content design.. Very strong experience training end users, administrative staff, and faculty on using

web technologies and end user applications. Experience using most major programming languages,

operating hardware, software, and operating systems (complete list available upon request). Skills

Include:

IBM DataStage 8.1 - 8.5 Oracle SQL Developer and SQL+

• •

Oracle EPM People Tools

• •

OBIEE 10g/11g PL/SQL, XML/XSL, HTML, CSS,.Net

• •

Oracle 10g/11g Database VM Ware ESX 3.5+

• •

PeopleSoft Portal Administration Windows Server, REL, SuSe

• •

Experience

WASHINGTON STATE UNIVERSITY, Pullman, WA 4/2010 – Present

IBM DataStage ETL Developer

Currently Lead ETL Developer in three member team responsible for all data warehousing

technologies including DataStage ETL, OBIEE, and Oracle EPM. Was sole developer/administrator

for the entire environment for six months before team was complete. Prepared all three systems for go

live date in 2012.

Member of three person team responsible for conversion of existing WSU portal to campus wide

PeopleSoft Portal implementation in spring of 2010. Duties include daily application maintenance and

trouble shooting, content creation, role creation, content security, user account administration, and

other duties as assigned. Some of those duties included designing and configuring OBIEE.

Key projects/roles:

Serve as Lead DataStage ETL developer on WSU campus which provides services to more than

•

40,000 users.

Design, develop, modify, build, test and implement custom ETL jobs for OBIEE go live

•

Modify, build, test, and tune ETL jobs delivered by Oracle for PeopleSoft implementation go live

•

Lead in guiding hosting provider to improve performance by replacing dated hardware and

•

inappropriate architecture

Converted all legacy WSU content to new PeopleSoft Portal environment.

•

Developed and tested Jmeter scripts in a variety of usage scenarios to assist Oracle On Demand in

•

performance tuning for the production portal hardware and software.

Created new and original pagelet content to enhance functionality and usability of the new portal.

•

Provided development support to auxiliary departments using XSLT and HTML to transform their

•

data feeds into usable pagelets for their constituent audience.

Created Oracle BI publisher/Oracle BI Answers interface tables, interactive reports, and end user

•

dashboards as a part of the WSU evaluation process before purchase.

•

UNIVERSITY OF IDAHO, Moscow, ID 8/2003 – 4/2010

IT Manager/Integration Analyst/Portal

Administrator

More than 6 years of managing technical staff, developing web applications, designing and

maintaining server solutions, integrating and interfacing disparate enterprise information systems, and

training end users. Here are a few highlights.

Key projects:

Service manager for the my.uidaho.edu web portal

•

Key member of integration/installation team that brought this system to U of I campus

•

Manage day to day operations with the portal

•

Sole developer of channels, content, and security

•

Created and maintained policy and procedures for content and design change

•

Served as head of IT for all Auxiliary Services departments

•

Responsible for creating and maintaining IT policy and procedure for Auxiliary Services

•

Primary server systems technician for VMware ESX 3.5i environment and standalone servers

•

hosting Parking, Bookstore, Conferencing and Web Apps

Primary technical lead for Ticket Office, Bookstore, and Parking POS Enterprise Systems’ data

•

integration, installation, and maintenance

Created and maintain database software between the Banner Financial System and AIMS parking

•

application which enables real-time billing and accounting for parking services

Migrated the bookstores POS system to new hardware and assisted ITS in remodeling their security

•

to ensure data security

Designed websites for 20+ professional conferences, Parking Services, and Auxiliary IT using

•

ASP.net, JavaScript, CSS, and HTML

Responsible for purchase of all IT equipment for Auxiliary Services based on a proven ability to

•

understand current technology and proper system integration practices

Provided comprehensive written and personal end user training for parking POS system, U of I

•

web portal and bookstore POS system

•

Education & Training

SFCC, Spokane, WA 2001-2003

Field of Study – Computer Tech

UNIVERSITY OF IDAHO, Moscow, ID 2003-2009

Field of Study – Computer Science

Contact this candidate