Summary of Professional Experience

Confidential

Senior Consultant

Implementation

• PeopleSoft EPM 9.1 Data Warehouse for General Ledger, Accounts Receivable,
• HCM HR, Payroll , EPM, PeopleSoft Pension System. PeopleTools 8.51

Confidential

Development and Support

• PeopleSoft EPM 9.1 Financials, Supply Chain Management. PeopleTools 8.51

Confidential

Senior Consultant

• PeopleSoft 9.0 Human Capital Management

Confidential

Senior Consultant

• PeopleSoft 8.9 Human Capital Management, Financials

Confidential

Consultant

• EPM 8.9, PeopleSoft 8.9
• EPM Financials, Account Payable,
• PO Requisition,
• Human Capital Management

Confidential

Senior Consultant

Development

• PeopleSoft 7.5 PeopleSoft Financials, Planning and Budgeting, SQR

Confidential

Project Senior Consultant

Worked on the implementation of the Enterprise Performance Data Warehouse for PERS of Mississippi to support Pension Management and Analytical reporting capability. Identified and loaded delivered Account receivable facts which includes PS F AR ACCOUNT LN, PS F AR TRAN, PS F AR AGING. Identified and loaded delivered General Ledger facts which includes PS F JOURNAL, PS F LEDGER. Developed dimension and fact DataStage jobs for identified Pension areas of Employer, Member, Recipient, Financial and Operational Performance. Designed and created custom PeopleSoft records and sub records that facilitated the development of the afore-mentioned Facts and dimensions. Fully tested and documented all objects and processes and migrated related projects.

Confidential

Senior EPM Consultant

Worked with the EPM team to identify FSCM dimension and fact dependencies in EPM 9.1 including common dimensions, global and local dimensions, General ledger and KK facts, Account payable and account receivable facts, Project grant contracts facts, Requisition PO and Inventory facts. Designed, developed and deployed custom position funding fact and custom Roster Staffing fact which included type-2 dimension lookup logic for BI position reporting and BI staffing reporting respectively in EPM 9.1 / DataStage 8.5. Generated test plans, scripted and executed exhaustive unit tests and documented test results. Participated in the implementation of changed data capture jobs for various FSCM tables in EPM 9.1 / DataStage 8.5 including soft deletes on PS BI LINE, PS CA DETAIL PROJ, PS CNTRCT LINE, PS DEPT TBL, PS GL ACCT TBL, PS JRNL HEADER, PS KK BUDGET HDR, PS KK BUDGET LN and soft deletes on dependent dimension and hard delete on related fact tables. Designed and created custom PeopleSoft Tables and view to support this development. Thoroughly analyzed and tested reporting data for accuracy and migrated all related projects

Confidential

Senior Consultant

Analyzed requirements and determined resolutions for PeopleSoft Operational Data Warehouse Reporting in Human Capital Management modules. Documented the functional and technical design specifications for newly added views and documented changes to existing views. Determined, designed and created pertinent PeopleSoft objects including fields, PeopleSoft records, Audit tables, PeopleSoft triggers, PeopleSoft SQL objects and materialized views that enabled warehouse data migration using the incremental load approach. Designed and created efficient Ascencial DataStage jobs that load OWS and OWE tables for the operational data warehouse reporting using best practices. Thoroughly analyzed and tested reporting data for accuracy.

Confidential

Senior Consultant

Interfaced with end-users to gather requirements, analyzed and determined resolutions for PeopleSoft EPM Data Warehouse in both the Human Capital Management and the Financials modules. This included eliciting the functional design documents and generating the technical design specifications. Designed and created necessary PeopleSoft EPM objects including fields, records and views that facilitated data migration into the EPM warehouse. Designed and created tuned Ascencial DataStage jobs that load HCM data into the EPM data warehouse using best practices and validating data load for accuracy. Automated the Tree flattening process using core delivered functionality and configured and customized other object to suit business needs. Performed On-Call duties during the twelve hour nightly data-load batch processing.

Confidential

Senior Consultant

Provided leadership for the maintenance of the City of Minneapolis EPM 9.0. Financials Data Warehouse for Accounts Payable, General Ledger and Profitability and ESA modules. Validated loaded EPM Warehouse data and addressed any and all load issues. Created efficient DataStage jobs to address required reporting data for daily business operation needs and modified exiting jobs to ensure data load accuracy. Tuned poor performing DataStage jobs to shorten data load interval, which included adding proper indexing to various tables and adding incremental logic to various existing jobs. Participated in applying updates and fixes to the PeopleSoft EPM 9.0 system. Provided best-practice guidance for EPM Warehouse standardizations and best-practice resolutions to EPM data related issues. Mentored developers and end users on PeopleSoft EPM warehouse tools in the areas of DataStage load and DataStage environment management PeopleTools and PS Query scripting. Provided day-to-day EPM production support as needed.

Confidential

Project Documentation IBM PeopleSoft Practice

Project Documentation IBM PeopleSoft Practice

Harvested, Analyzed, Cleaned and cataloged PeopleSoft Practice Reports, Interfaces, Conversions and Extensions Customizations for internal reference by PeopleSoft practice consultants. Participated in EPM practice proposal meetings including business value added proposal research, analysis, documentation and client sales presentation for MetLife .

Confidential

Senior Consultant

• Adapted legacy systems accounts payable PeopleSoft PS Query data in the EPM Financials environment. Scripted additional required accounts payable PeopleSoft PS Query in the EPM Financial environment to facilitate further end-user decision-making processes. Analyzed and created the Source to Target maps from legacy SAP databases to the EPM warehouse for PO custom nVision and Crystal reports. This includes the PO Requisition header and detail tables Goods received header and detail tables and payment header and detail tables and also created and built the associated custom tables in the warehouse environment and propagated them throughout various environments. Developed custom DataStage ETL jobs to load some base reporting tables from legacy systems into the EPM warehouse.
• Assisted in administering security access for end-users in the EPM Warehouse. Assisted in developing EPM Warehouse nVision and Crystal report rendering which includes reports process definitions, reports process control page creation and registration, and report security access grants. Troubleshot NiSource warehouse Materialized View load-time poor performance and recommended a strategy that served as the architectural road map that ultimately satisfactorily improved the F A warehouse reporting tables load interval.

Technical Skills