Wayne Rogaczewski Email & Phone Number

Lexington-Fayette Urban County Government (Lfucg), Lexington, Ky.

• Interviewed functional users and reviewed client pain points with v8.9 processes and demonstrated additional functionality that is available in v9.2 that had not been previously deployed. • Developed recommendations to resolve pain points and to implement additional functionality for Future State Processing.• Documented changes to Billing and Receivables configuration.• Documented changes to Banking set up and new configuration for Treasury Cash and Deal Management.• Develop test scenarios and test script matrix including Interface Bill transactions from Grants/Projects.• Direct client in SIT and UAT Testing and resolve testing issues.

American Fidelity Assurance, Oklahoma City, Ok

• Performed fit-gap analysis of client requirements to 9.2 functionality.• Developed AR and Billing Future State Business Process Maps.• Developed AR and Billing Future State Functional Design deliverables.

Columbus, Ohio Area

AR/Billing/Revenue Lead – Implement Department of Transportation Agency into State of Ohio’s OAKS PeopleSoft Instance - IBM Implementation Partner• Interviewed functional users to document current state business processes. • Reviewed previous customizations and identified how customizations will impact the agency• Directed client in documenting future state processes, documenting requirements and conductied fit-gap analysis.• Developed alternative solution recommendations to satisfy requirements identified as gaps.• Developed design document and set up configuration.

• Met with functional users to document current state business processes. • Met with functional users to develop business requirements and establish functionality tobe implemented for initial phase of project• Reviewed existing interfaces to identify modifications needed to integrate Mexico specific data • Assisted project team in developing list of data requirements needed to be implemented in upstreamsystems that had to be completed be able to feed the Mexico specific Factura and VAT data to PeopleSoft. • Met with functional and technical team regrading receiving bank statement files in MT940 or BAI2 format to load customer payments

Newark, De.

• Interview process owners to document current state processes. • Direct client in documenting functional requirements and fit/gap • Develop functional specifications for Bank Statement Import, ACH and Wire Payments using Financial Gateway • Develop functional specifications for loading item supplier and replenishment information• Develop and document configuration for additional features

Houston, Tx

PeopleSoft Financials Consultant - Oceaneering FSCM 9.2 Upgrade Financials Team /Subject Matter Expert (AR/Treasury CM/EX)• Responsible for testing and preparation of test documentation for AR,Cash Management and Expense modules. • Responsible for configuration of AR functionality not previously deployed: Customer Hierarchy, Condition Monitor, Payment Predictor. • Responsible for preparing functional specifications for Receivables and Treasury WorkCenters to document the My Work, Links, Queries and Reports to be set up.• Responsible for configuration of AR and Treasury WorkCenters including design of user/role/permission list security.

Washington Gas - Springfield, Va.

• PeopleSoft 9.2 Upgrade project• Interviewed functional users to document current state business processes. • Reviewed previous customizations and identified customizations to drop or retrofit to 9.2• Directed client in documenting future state processes.• Developed functional specification documentation for interfaces and reports.• Developed functional specification documentation for enhancement to add solar billing integration within PeopleSoft • Directed client in documenting configuration and performing set up.• Directed client in development of test scripts for integration testing and user acceptance testing.• Provided post go-live production support.

Westar Energy - Topeka, Ks>

• Interview process owners to document current state processes. • Direct client in documenting functional requirements, interfaces, conversions and reports • Direct client in documenting future state processes• Develop functional specifications for Bank Statement, ACH and Wire Payments for bank integration using Financial Gateway • Directed client in developement and execution of test plans, scenarios and scripts• Directed client in development of SOX complient security roles and permission lists.• Provided post go-live support.

• Interviewed process owners to document current state processes. • Directed client in documenting functional requirements, interfaces, conversions and reports • Directed client in documenting future state processes.• Directed client in developement and execution of test plans, scenarios and scripts• Directed client in development of SOX complient security roles and permission lists.• Provided post go-live support.

Denver, Colorado

• Directed client in documenting functional requirements, interfaces, conversions and reports • Directed client in documenting future state processes.• Configured ePro Approval Workflow • Directed client in developement and execution of test plans, scenarios and scripts• Provided post go-live support.

Washington Dc

• Interviewed functional users to document current state payables, receivables and cash transaction business processes. • Directed client in documenting requirements traceability matrix for payments, receivables and cash transaction processing.• Directed client in documenting future state vision for payables, receivables and cash management processing.

• Interviewed Ramsey functional users to document existing business processes and use of system functionality. • Reviewed current system configuration and other documentation to compare to functional requirements.• Prepared assessment document stating functionality that should be implemented and recommendation for additional modules to be implemented to support client’s Procure-to-Pay business processes.

• Directed functional team in documented existing business processes. • Documented AP/ePro/Purchasing functional requirements.• Conducted fit-gap analysis assessment of existing functionality vs. delivered functionality.• Created Set Up Manager Project for Financial Module configuration.• Set up AP/ePro/PO Business Units and configuration tables using set up manager. • Developed specifications for customizations to existing invoice image management system to integrate with PeopleSoft Vendors, Chartfields and Sale/Use Tax functionality and to export approved invoice into AP via Voucher Build process.• Developed specifications for Vendor, Vouchers and Payment conversion. • Assisted end user with revising business procedures including identification of internal controls.• Designed and developed security permission lists and roles.• Worked with external auditing consultants to resolve SOD conflicts found in security roles/permissions that were discovered by their software.• Developed PSQueries to identify potential SOD violations in new role/permission development and role assignment to user profiles for post go-live use.• Developed and Integrated and UAT test plans and test scripts.

• Documented existing procurement and sourcing business processes. • Documented eProcurement/Purchasing/Accounts Payable/Strategic Sourcing/ functional requirements.• Conducted fit-gap analysis assessment of existing functionality vs. delivered functionality.• Configured ePro, Purchasing, Strategic Sourcing Business Unit, Common and Product Set Up tables.• Developed specifications for requisition, purchase order and receiver conversion.• Developed specifications for customizations and requisition approval workflow.• Designed and developed security permission lists and roles.• Developed and executed test plan and test scripts.• Assisted client in defining item master and creating item catalog.• Defined client specific user training agenda for custom UPK training materials. • Developed custom queries for requisition, purchase order, receivers, • Developed custom queries for item catalog information. • Provided post go-live production support

• Documented existing AR and Billing business processes.• Conducted fit-gap analysis and assessment of existing functionality vs. functionality delivered with 9.0• Identified client customizations which need to be re-applied or retired.• Identified 9.0 functionality for potential future use.• Developed design document for configuration set up.

• Security Team Lead for US implementation of 8.8 on DB2 Database.• Integrated cross module activities related to security.• Coordination of overall team activities and communications per project plan.• Setup and maintained employee and supplier Portals. • Configured Portal menu structure and content.• Developed and setup SOX compliant roles and permission lists for operator security and to assure Separation of Duties.• Developed specifications for initial load and interface of operator IDs from Employee Database including assignment of baseline roles, user preferences and procurement authorizations. • Developed specifications for translation of version 7.5 classes to 8.8 roles. • Developed functional specifications for custom Security Request process to replace manual Security Administration activities. • Designed process to allow users to request security roles, route requests for approval and automated assignment of role and user preferences upon approval.

• Developed and executed test cases and scripts to confirm delivered functionality of Accounts Receivable/Billing on Oracle Database.• Developed and executed test cases and scripts to confirm customizations, interfaces and conversions.• Functional team member for testing of Procure to Pay (AP/PO) customizations, interfaces and conversions.

• Functional Lead for implementation of version 8.8 Accounts Receivable on Oracle Database. • Developed and maintain business models and requirements.• Designed future state business processes and transactions.• Application setup and configuration.• Developed and executed test cases and scripts.• Analyzed and designed custom queries/custom reports.• Developed and setup SOX compliant roles and permissions for operator security.• Developed training strategies utilizing PeopleSoft UPK. • Developed end user training and desktop procedures.

• Functional Lead for implementation of version 8.2 AP and Purchasing with Workflow on Sybase Database. • Document business processes and requirements, fit gap analysis, workflow approvals and work flow routings. • Setup of AP and Purchasing configuration tables and workflow routing.• Develop specifications for customizations and conversions of vendor and item master. • Develop acceptance test plans for integrated testing of Purchasing and AP modules to GL.• Develop business process re-engineering, detailed design of new process flows, specifications for custom program development and testing.• Define and set up workflow roles and routing for requisition and PO approval.• Develop and administer Security for all AP/Purchasing and Requisition users.• Define Roles, Permissions and assignment of Routings.• Develop user training documentation and desk-top procedures and conducted training sessions.

• Functional/Tech Lead for upgrade from Version 7.5 to 8.1. on MS SQLServer Database. Modules included: AP/AR/AM/BI/GL/INV/PO/OM.• Perform fit-gap analysis and documented requirements to utilize additional functionality and identify which client customizations needed to be re-applied. • Applied changes to records and views, components, pages, Application Engine, PeopleCode, SQR’s, PSQuery and Crystal Reports related to existing client processes for Order Management, AR/Billing, Requisition Load, PO, Receivers, Matching, Inventory, GL, AM.• Created SQL scripts to apply additional configuration.• Upgraded custom Crystal reports to new versions .• Created test scripts and executed unit and system integrated testing.• Updated user training and desk-top procedures.• Administered Security for all AP/Purchasing and Requisition users. • Define Roles, Permissions and assignment of Routings.• Post-implementation support to resolve Pay Cycle and match error problems.

• Technical team member supporting upgrade from Version 7.5 to Version 8.0 on DB2 Database. Modules included: AP/AR/Billing/Inventory/Purchasing/Order Management.• Developed Component Interfaces for real time synchronous integration to external web based system related to Order Management. • Created of views, components, pages component interface objects to support CreateKey, GetKey, FindKey, Property Info Collection.• Developed interfaces included Order Status, Shipment Status, Customer, Bill-to, Ship-to, Product and Item info to 3rd Party Webstore System.

• Technical team member supporting AP/PO Version 7.5. on Oracle. Modules included: AP/Purchasing• Created or altered of tables and panels and the development of PeopleCode to support enhancements to the accounts payable and purchasing modules.• Provided post-implementation support to resolve data integrity issues and resolve match errors preventing supplier payments. • Developed SQL scripts to clean-up data AP and PO data.• Modified SQR and PSQuery/Crystal reports.

• Managed Financials Team on implementation of Version 7.5 on Oracle database. Modules included: GL/AP/AR/Billing/Inventory/Purchasing/Order Management.• Supported client in business process re-engineering, detailed design of new process flows, custom program development and testing. • Supported the client's Global Implementation Strategy for buy/sell relationship of new domestic and foreign business units Version 7.0. • Support client in the implementation of an interim global strategy to support the buy/sell relationship and international tax issues of new domestic and foreign business units via the development of custom queries, reports and journal entries.