Certified PeopleSoft EPM Consultant
Resume:
Brad Upton
Certified PeopleSoft EPM Consultant
Broomfield, CO 80020
********@*****.***
303-***-**** (cell)
Overview
As a consultant for Oracle Corporation, Mr. Upton successfully completed Data Warehouse/Business Intelligence implementations for a number of clients in the public sector space, specializing in PeopleSoft EPM Campus Solutions, Financials and HCM Warehouses. He has also owned his own consulting firm, sub-contracting with Accenture, BearingPoint, IBM and TEKsystems on Data Warehouse implementations.
Mr. Upton also worked for PeopleSoft as a consultant for 4 years, specializing in Enterprise Performance Management (EPM), which includes Data Warehousing, Business Intelligence and Analytic Applications. He successfully completed implementation projects for a number of Fortune 500 companies. He also earned PeopleSoft certification in the EPM practice.
Professional Summary
More than 30 years experience in Information Technology as a developer, consultant and technical lead, specializing in Data Warehousing and Business Intelligence applications.
More than 25 separate Data Warehouse projects, spanning a variety of industries.
16 years experience working with the PeopleSoft EPM product.
17 years total PeopleSoft experience.
17 years experience with Oracle Databases and SQL.
8 years experience designing and developing ETL jobs, using IBM (Ascential) DataStage.
Primary focus is on product quality and customer service.
Professional History
Data Warehouse/Business Intelligence Experience
University of Texas System Administration
Fort Worth, TX
Data Warehouse Analyst
Jan 15 – Mar 15
Mr. Upton was responsible for developing and customizing delivered Peoplesoft EPM objects, IBM (Ascential) DataStage ETL jobs and SQL for multiple campus locations. He was also responsible for monitoring jobs in the production environment, writing technical specifications, testing, verifying data and troubleshooting. The environment is an EPM 9.1 implementation with DataStage 8.1 and 8.5.
Oracle Corporation
Redwood Shores, CA
Sr Principal Consultant - Business Intelligence/Enterprise Performance Management
Jul 10 – Oct 14
Mr. Upton was responsible for implementing data warehouse and business intelligence systems for Oracle clients in the public sector and higher education space, specializing in PeopleSoft EPM Campus Solutions, Financials and HCM Warehouses. This includes developing and customizing delivered Peoplesoft EPM objects, IBM (Ascential) DataStage ETL jobs and SQL. He was also responsible for writing technical specifications, testing, verifying data and troubleshooting. He was involved in EPM 9.x implementations at many Oracle clients, including USDA (LA), Bellevue University (NE), Bowling Green State University (OH), University of Akron (OH) and MD Anderson Cancer Center (TX).
University of Wisconsin / Accenture
Madison, WI
EPM Consultant/ETL Developer
Dec 09 – Jun 10
Mr. Upton was an analyst and developer on an implementation of PeopleSoft EPM 9 at the University of Wisconsin in Madison, WI. He customized the delivered IBM (Ascential) DataStage ETL jobs and SQL, developed new IBM (Ascential) DataStage jobs and SQL and developed new objects using PeopleTools. He was also responsible for writing technical specifications, testing, verifying data and troubleshooting.
State of Kansas / Accenture
Topeka, KS
EPM Consultant/ETL Developer
Sep 09 – Nov 09
Mr. Upton was an analyst and developer on an implementation of PeopleSoft EPM 9 at the State of Kansas in Topeka, KS. He customized the delivered IBM (Ascential) DataStage ETL jobs and SQL, developed new IBM (Ascential) DataStage jobs and SQL and developed new objects using PeopleTools. He was also responsible for testing, verifying data and troubleshooting.
Bonneville Power Administration (Dept of Energy) / TEKsystems
Portland, OR
EPM Consultant/ETL Developer
Apr 07 – Jun 09
Mr. Upton was an analyst and developer on an implementation of the PeopleSoft EPM 8.9 ESA Warehouse at Bonneville Power Administration in Portland, OR. He customized the delivered Data Marts, Application Engine programs, IBM (Ascential) DataStage ETL jobs and SQL, developed new Application Engine programs, IBM (Ascential) DataStage jobs and SQL and developed new objects using PeopleTools. He was also responsible for testing, verifying data and troubleshooting.
Hawaiian Telcom / BearingPoint
Honolulu, HI
EPM Consultant
Aug 05 – Apr 07
Mr. Upton was the technical lead, contracting for BearingPoint on a PeopleSoft EPM 8.9 implementation at Hawaiian Telcom in Honolulu, HI. He was responsible for the technical design and development of a custom Sales Incentive Management application that included the development of Application Engine programs and SQL to process the data from three source systems for reporting and check processing. He was responsible for coordination with the teams from the three source systems, the ETL team to bring the data in to the application and the client. He was also responsible for database design, populating the database, verifying data, testing and troubleshooting.
BearingPoint
Boston, MA
EPM Consultant
Feb 05 – Aug 05
Mr. Upton was a developer on an internal PeopleSoft EPM 8.8 ESA Warehouse implementation, contracting for BearingPoint in Boston, MA. The project included customizing Application Engine programs and SQL, creating new Application Engine programs and SQL, and setting up metadata. He was also responsible for populating the database, verifying data, testing and troubleshooting.
Bank of New York / BearingPoint
New York City, NY
EPM Consultant
Jul 04 – Nov 04
Mr. Upton was the technical lead, contracting for BearingPoint on a PeopleSoft EPM 8.8 Financial Services Warehouse implementation at The Bank of New York in New York City, NY. The project required three custom Data Marts using custom source data, defined by BNY. Source data included Financial, Activity Based Management and Funds Transfer Pricing information. He made major customizations to the delivered Profitability Data Mart and developed two new Data Marts, which included adding multiple dimension tables, modifying and creating fact tables, customizing delivered Application Engine programs and SQL, creating new Application Engine programs and SQL, and setting up metadata. He was also responsible for database design, populating the database, verifying data and troubleshooting.
Bonneville Power Administration (Dept of Energy) / IBM
Portland, OR
EPM Consultant
Mar 04 – Jul 04
Mr. Upton was the technical lead, contracting for IBM on a PeopleSoft EPM 8.8 Financial Warehouse implementation at Bonneville Power Administration in Portland, OR. He made major customizations to the delivered Data Mart, including adding multiple dimension tables, modifying the GL fact table, customizing delivered Application Engine programs and SQL, creating new Application Engine programs and SQL, and setting up metadata. He was also responsible for database design, populating the database, verifying data and troubleshooting.
Maricopa County / CIBER
Phoenix, AZ
EPM Consultant
Aug 03 – Mar 04
Mr. Upton was instrumental in implementing a PeopleSoft EPM 8.8 HR Warehouse at Maricopa County in Phoenix, AZ by supporting the core warehouse processing, including Informatica ETL jobs and Data Loader, troubleshooting and validating converted data.
CoorsTek
Golden, CO
Senior Systems Analyst
Mar 02 – Aug 03
Mr. Upton was a Senior Systems Analyst, responsible for customizing and supporting CoorsTek’s PeopleSoft EPM 8.3 and Supply Chain Management 8.4 (SCM) systems, in a manufacturing and financials environment. He was also responsible for customizing delivered Microstrategy reports used in the Supply Chain Warehouse.
PeopleSoft, Inc
Pleasanton, CA
EPM Consultant
Jul 98 - Mar 02
Mr. Upton was a PeopleSoft consultant, specializing in the Enterprise Performance Management (EPM) product (data warehousing / business analytics). He was involved in EPM 7.x and 8.x implementations at many PeopleSoft clients, including Ford, Merck, Sprint and Honeywell.
Art Van Furniture
Warren, MI
Application Development Manager
Oct 95 - Jun 98
Mr. Upton was the Application Development Manager, using PeopleSoft and UniData products in a retail environment. He was responsible for all software development in an environment that supported multiple software packages and databases, including PeopleSoft 5.12 Payroll and General Ledger. He was responsible for supporting and customizing the Redbrick Data Warehouse and designing reports using Brio's OLAP tool.
Education
Lake Superior State College Sault Ste Marie, MI
1979-1981 Associate Degree in Business Data Processing
Ferris State College Big Rapids, MI
1974-1976 Major: Accounting
Training
Oracle BI Suite EE 10g: Reports and Dashboards
Oracle BI Suite EE 10g: Build Repositories
Oracle BI Applications 7.9: Develop a Data Warehouse
Oracle BI Suite EE 11g: Reports and Dashboards
Oracle BI 11g R1: Build Repositories
Oracle Data Integrator 11g: Integration and Administration
Oracle Data Integrator 11g: Advanced Integration and Development
Oracle BI Applications 11g: Implementation using ODI
DataStage ETL Training
PeopleSoft Technical Academy
PeopleSoft EPM Academy
PeopleSoft Training
Technical Skills
Languages:
Application Engine
SQL
Peoplecode
DBMS:
Oracle
SQLServer
Operating Systems:
UNIX
Windows
Tools:
Oracle Data Integrator 11g
PeopleTools 7x, 8x and 9x
IBM (Ascential) DataStage ETL 7.5, 8.1 and 8.5
Oracle BI Suite EE (OBIEE) 10g/11g
SQL Developer
TOAD
Contact this candidate