Mike - Consultant technique PEOPLESOFT

PeopleSoft EPM 8.9, EW, Balanced Scorecard Implementation
• Developed rapid prototype of KPI and Scorecard models to demonstrate functionality to users.
• Developed 64 KPIs (KPI Manager) incorporating both financial (GL) and non-financial metrics (HR Headcount, FTE, HR Transactions), primarily focused around (PWC) Saratoga HR Metrics definitions.
• Setup/configuration of all Scorecard, Strategy Trees/Components, KPI definitions, data elements, etc.
• Utilization of new 8.9 features such as Hierarchical KPIs using department-level rollups.
• Setup and configuration of all EPM base metadata, OWE data modeling, record metadata, tablemaps, datamaps,
calculated fields/expressions, models, scenarios, jobs, jobstreams, filters, constraints, dimension security.
• Analyzed and developed fixes and/or customizations to delivered AE Engines (KPI Analyze) and online pages.
• Worked with ETL team to analyze requirements and troubleshoot Ascential DataStage delivered mappings.
• Developed custom pages/processes (AE) to automate security role and dimension security assignment.

PeopleSoft EPM 8.9, EW, FSI, DataMart Pre-Sales Prototype

Worked on combined IBM/Unilog/Oracle France pre-sales prototype for EPM 8.9 (FSI) customer.
• used cash flow generator to generate future cash flows and balances for instruments
• built FI_RECON/PF_RECON rules for Instrument-Level reconcilliation (with GL), and a custom process (AE) which generates an adjustment/correcting entry for any imbalances to the PF Journal Entry page.
• built various Cognos PowerPlay cubes (based on delivered data marts) for Account Level profitability analysis and several Cognos ReportNet Reports (Framework Manager, Cognos Connection, Report Studio)
• built Allocation Manger rules for various cost, ftp, shadow accounting rules
• built custom component/pages for Instrument-level Tranche/Portfolio management
• used the Currency Conversion tool to convert all data to base currencies
• built custom Average Daily Balance process (AE) to calculate 2 types of ADB, based on instrument balances
• some exposure to Cognos ReportNet and Ascential DataStage/MetaStage ETL tool.

PeopleSoft 8.8 EPM, EW, ESA DataMart/Data Warehouse Implementation
Customized ESA Warehouse (Enterprise Services Automation) Implementation, GL, AP, Contracts, Projects, Expenses with external HR and CRM (Siebel) system data.
• Responsible for design/build for EPM DataMart solutions for Leadership Management Reporting and Global Operations Reporting.
• ODS and Data Loading - Understanding of client’s various source system feeds (Siebel, HR, FIN), data mapping/cleansing of source data, generating and maintaining (Informatica) ETL mappings to transform data to load ODS.
• Logical and physical data model designs using ERWin data modeling tool. Other technical documentation of all customization, metadata configuration, user procedures and processes.
• Application Engine and EPM Enterprise Warehouse technical design and build tools.
• Optimization and tuning of (Oracle) SQL to perform loads within batch window.

Independent/Contract Experience

PeopleSoft EPM 8.9, HCM Developer, HR Warehouse/DataMart Upgrade, Cognos Cube Developer
• PeopleSoft ePerformance 8.9, Technical Design and Development of custom Manager Dashboard providing single integrated view of manager documents with statuses, stages, etc. – incorporated with Manager Self-Service functionality.
• Fit/gap and Upgrade of client’s existing EPM v8.3 System data model (with customizations), HR Warehouse/DataMart to v8.9. Data Modelling – Warehouse/DataMarts, OW-S to OW-E to MDW data flow. Implementation of asynchronous HR to EPM data refresh (near real-time data warehouse for OW-S) iusing IBM’s Q Replication tool.
• Complete end-to-end design/build of Cognos Cubes – workforce and action cubes. Used PowerPlay Transformer with IQD/SQL data sources, with Cognos Batch scripting to automate the build process, role-based row-level cube security
• Developed Utility Program to Migrate and Convert 8.3 HCM/EPM PS Queries to 8.9 – mapping old tables/fields to new based on EPM completely redesigned data models. Developed Utility Program to validate DB2 (mainframe) data loads (JCL) into EPM-OWS layer accounting for default values, structure differences between HR and EPM tables.
• Troubleshooting and support of HCM/EPM Security, application fixes (online and batch), tuning, enhancements, PS queries and other issues.
• Provided knowledge transfer / training to Technical Support staff and knowledge workers.

PeopleSoft 8.4 FIN/CRM Developer, PeopleSoft

Application/Portal Security, Cognos PowerPlay/OLAP
Cognos Cube Design and Build
• Responsible for all aspects of client’s Cognos Reporting solution from requirements gathering, design specifications, prototype(s), build
• Design and build of Cognos PowerPlay for DataMart-level Reporting Solution
• Generated complex extract scripts (Oracle SQL) to select, extract and transform data as Cognos data sources. Final extract program written in SQR.
• Design Dimension and Fact sources for a 9 analysis cubes.

Security Design, Implementation and Administration: Responsibilities included the implementation PeopleSoft Application Security for Financials, CRM and Portal Modules, including:
• worked with client requirements to develop PeopleSoft application security design
• design and implementation (load) of all Permission Lists, Roles, and Operators
• generation and migration of portal content references and security
• implementation of User Synch (EIP) including customizations

CRM/FIN Developer: Responsible for the development of various customizations including:
• design/build of customer facing e-modules (custom e-billing) incorporating row-level security
• CRM design, configuration and development for 360-degree, consumer and case searches, optimization and custom 360-degree activities view page, customized delivered application classes.
• Developed and maintained a custom AP to Billing interface program (AE)

Senior Consultant for PeopleSoft Global Services (6 years)

PeopleSoft 8.3 EPM EW/Data Warehouse + Benchmark
Michael played a lead technical role at a multi-billion dollar financial institution in Paris, France implementing PeopleSoft EPM 8.3 (Enterprise Warehouse).
• Designed and developed ‘bolt-on’ modules/customizations to meet very specific customer requirements while integrating the solutions within the EPM metadata driven framework.
• Played role on client’s Reporting Tools Benchmark primarily involved with building of sample data, expansion of data, and simulation of processing for specific timeframe.
• Assisted with design and analysis of customer requirements, conducted fit/gap analysis of needs with EPM’s CRM and FSI data model. Designed and implemented customizations of data warehouse and data mart data models to meet specific client requirements.
• Benchmarking PeopleSoft EPM to meet client requirements for ETL, Rule Processing (Data Manager), and Data Mart builds - on DB2/UDB and AIX - meeting all requirements.
• Played key role in the development of Benchmark prototype, data model, ETL, Data Manager Rules, and Data Mart Builder Processes.

PeopleSoft 8.0 EPM EW and Financials Implementation
Michael played a technical role at a large Canadian financial institution where he was responsible for implementing Financials and EPM on version 8.
• Installation and setup of Informatica / PowerCenter (ETL) server and client tools
• Informatica development guidelines and standards
• PeopleTools Development and Change Control Standards
• Application and migration of Development changes and Updates and Fixes using AU Tool.
• Assisted client in their Reporting Tools Selection Process

PeopleSoft EPM EW/ABM Implementation - Technical Lead
Michael played a technical lead role in implementing PS ABM and EW at a major Utility co.
• Assisted client in development and design of ABM functional model.
• Built all model components in PeopleSoft’s ABM product (Ledger to Resource Mappings, Resources, Activities, Cost Objects, Drivers, Pointers, Implicit Pointers, etc.). This included any preliminary setup of metadata required by EW (Record, Tablemaps, Filter, Constraints).
• Built child models based on original model.
• Developed Data Manager Rules to Post results to PF_LEDGER.
• Acted as liaison between ABM Team and Financials team to coordinate ETL mappings and updating the Warehouse with Financials Information relevant for ABM.
• Assisted in designing report specification from ABM output.

PeopleSoft EPM 7.5 / EW / Technical Lead, Informatica

Michael played a Technical Lead role in the implementation of PS EPM at a large financial institution in the United States.
• Developed and designed custom ETL mappings (using Informatica) from various legacy systems throughout the organization - performing significant data conversions and data mapping/cleansing of source data and loading them into PeopleSoft’s ODS/Enterprise Warehouse tables.
• Developed ETL project schedules and resource plans, assigned roles and responsibilities to programmers and managed the day-to-day tasks ensuring that milestones being achieved.
• Provided team members technical guidance in using Informatica ETL tool and in how to use Informatica to populate PS Enterprise Warehouse tables.

PeopleSoft Financials / HRMS v7.5 - Technical +

Troubleshooting + Performance + Row-Level Security
Michael has worked with several clients implementing PS Security.
• Designed and developed a custom row-level security solution (based on Department Level) for a Public Sector organization.
• Coordinated and implemented PS Security Operators, Roles and Permission Lists for a large Insurance company.
• Implemented PS Fast Security views in HR/Payroll.