Peningo Systems, Inc.
Resume of Candidate: PEN-131
Rate: email us at sales@peningo.com for rate information
Peoplesoft Software Consultant
Pen131
PeopleSoft Real Estate (Property Management) Consultant with 5 years of experience.
Summary
A dynamic, resourceful, organized, and dedicated Information technologist with 20 years of industry experience. A team
leader with a proven ability to assess, develop, and execute strategy in regards to software development. Highly
proficient in custom software development and the implemention/customization of COTS applications. Involved in 20+
implementations of PeopleSoft Financials ranging from versions 5 to 9.1. Involvement included playing critical roles in the
sales, scoping, design, implementation, testing, and support of PeopleSoft Financials. Roles played include functional
lead, technical lead, project manager, and independent consultant. Knowledgeable of the business processes delivered
with the PeopleSoft Financials, Supply Chain Management, and Asset Life Cycle Management suite of products as well as
the technologies used for data management, security, report writing, interfaces, and custom development. Proficient in
rapid application development tools such as Oracle Forms and Visual Basic. Extremely knowledgeable of RDBMs such as
Oracle, DB2 and SQL Server including database design, build, and support. Emphasis placed on system performance
during implementation and customization by optimizing at both the database and application layers as well as the utilization
of data reduction techniques such as data archival/deletion. Worked for clients in a variety of industries such as
Government Contracting, Manufacturing, Finance, Telecommunications, Hospitality, Paper, Professional Services, Health
Care, Software, Publishing, Real Estate, and Motor Sports.
Computer Experience
PeopleSoft: Financials 6.0, 7.0, 7.5, 8.0, 8.4, 8.8, 8.9, 9.1 (General Ledger, Payables, Purchasing, Receivables, Billing,
Contracts, Order Management, Asset Management, Real Estate Management, Project Costing, Expenses, Inventory,
Commitment Control), PeopleTools, nVision, Upgrade Assistant, Crystal Reports
Databases: Oracle, DB2, SQL Server, UDB
Languages: SQR, COBOL II, Peoplecode, PL/SQL, Visual Basic 6.0, Unix shell scripting, REXX, JCL
Software: Maestro, Autosys, CA-7, SqlPlus, Command Center, Oracle Forms, Oracle Reports, Cognos Impromptu, IMS,
CICS, TSO/ISPF, CA11, QMF, Fileaid, Dialog Manager, Omegamon for MVS/DB2, ChangePoint.
Education
University of Maryland
Masters of Business Administration, May 1996
Masters of Science (MIS), May 1996
Stevens Institute of Technology
Bachelor of Engineering (Electrical Engineering), May 1991
Professional Experience
03/01 – Present
Client: Savannah River Nuclear Solutions, Savannah River Site, SC 02/10 - Present
PeopleSoft financials lead for the v9.1 implementation of PeopleSoft Financials Supply Chain Management at the
Department of Energy Savannah River Site.
• Financials Lead for a team of functional consultants tasked to retire legacy mainframe applications to be replaced by
v9.1 of PeopleSoft FSCM application. Modules to be implemented in the primary phase included Project Costing and
General Ledger.
• Involved in all phases of the SDLC. Led discovery session of legacy system to determine fit gaps between existing
functionality and that delivered by v9.1 of PeopleSoft Financials.
• Assisted in the creation of a RICE (Reports, Interfaces, Conversions, and Extensions) list to between manage
implementation scope.
• Conducted Fit Gap sessions with end user community for the implementation of Contract, Billing, AR, General Ledger,
Project Costing. Authored a fit gap document recording gaps that exist between the current and future state systems.
• Developed extensions (customizations) required to support functionality required by business users not delivered
by PeopleSoft Financials.
• Provided training of finished product to end users.
• Supported client during the first month end close of the new PeopleSoft system.
Environment: PeopleSoft Financials 9.1 (PC, CO, BI, AR, GL, AP, PO, IN)
Client: Lockheed Martin, Cherry Hill, NJ 05/07 – 12/09
PeopleSoft functional/technical consultant for leading Government Contracting Company operating in a highly customized
PeopleSoft financials environment.
• Responsible for implementation, testing, and rollout of Contracts to Cash functionality to support fixed price
contracts for a division of Lockheed Martin.
• Customized Project Costing and Contracts module for Lockheed Martin to facilitate recording, pricing, and reporting
of project related (direct and indirect) expenditures for fixed price, cost plus, and time & materials contracts.
• Customized Billing/AR application to facilitate the transmittal and storage of electronic and paper invoices as well as
modification of the payment predictor for efficient processing of payments.
• Developed SQR reports to provide project related financial reporting for management and department personnel.
• Performance tuning team lead responsible for batch run time and online response time reductions for both delivered
and customized processes.
• Resolved PeopleSoft Asset Management module integration issues with PeopleSoft Project Costing and third party
procurement systems.
• Performance tuned heavily customized PeopleSoft processes with excessive runtimes. Performance tuning results
achieved through a combination of process re-engineering, program (SQR and Application Engine) redesign and database
modifications.
• Architected an archiving strategy to be utilized for the Lockheed high data volume environment. High data volumes
were adversely affecting the batch runtimes. A portion of the solution involved the utilization of a Production Reporting
environment.
• Architected nVision environment for the development, running, and distribution of reports. Developed nVision
reports using instance hook functionality to enhance the look and feel of reports.
• Conducted training to functional and technical end user staff on functionality of the PeopleSoft modules, process and
data flows, and reporting customizations. Conducted training for technical staff on PeopleSoft technologies such as SQR,
Application Engine, and PeopleCode.
Environment: PeopleSoft Financials 8.8, 8.9 (PC, CO, AM, BI, AR, GL)
Client: DuPont Fabros, Washington DC 05/08 – 11/08
Implemented MRI Commercial Property Management Software for leading Data Center property management company.
• Performed requirements gathering with DuPont staff to understand and document current state business processes.
• Configured MRI Commercial Management out of the box software to work for DuPont Fabros business practices.
• Performed an automated load of the Chart of Accounts, historic Ledger activity, and outstanding disbursements.
• Worked with CFO and CAO to facilitate a reorganization of the Chart of Accounts during implementation of MRI.
• Configured FAS13 standard within MRI for DuPont leases.
• Customized existing and developed new reports using the MRI delivered report writing tool.
• Provided month end post-implementation closing support.
Client: Global Signal Corp, Sarasota, FL 06/05 – 04/07
PeopleSoft functional lead for various Financials projects within a v8.8 (AR, BI, PO, AP, GL, AM) environment for a Real
Estate Lease Management firm.
• Functional Lead for implementation of v8.8 PeopleSoft Billing and AR. Resolved numerous functional and technical
issues during upgrade as Global Signal was one of first set of customers to implement v8.8 version of PS Financials.
• Was the Techno/Functional Lead for a full PeopleSoft Real Estate Management v.9.0 implementation. The systems was
100% operational on the test servers. Since the client was running PeopleSoft 8.8 and needed to upgrade to PeopleSoft
9.0, the client decided to implement another Real Estate Management system, Intuit MRI. Led the full Technical and
Functional implementation of MRI.
• Lead for Sarbanes Oxley securitization initiative within Financials environment. Conducted design sessions to
develop Security Roles for assignment to individual operators to facilitate separation of duties. Audit tables developed to
track security changes made within PeopleSoft system. Developed reports to display security changes to internal and
external auditors. Securitization performed at PeopleSoft application, File System, and Database layers.
• Customized PeopleSoft Financials to conform to FAS13 (Straight Line) and FAS143 (Asset Retirement Obligation).
Customization required the development of Application Engines for the generation of accounting entries to conform to the
accounting rules required by the FASB standards.
• Developed custom algorithms within PeopleSoft AR application engines for auto-maintenance and payment
prediction of open items.
• Provided production support for issues related to PeopleSoft General Ledger, Asset Management, Billing, Accounts
Receivable, and Accounts Payable.
• Developed custom PeopleSoft AR dunning reports, customer statements, Invoices, and AP check utilizing Crystal
report and SQR technologies.
• Developed customized PeopleSoft reports utilizing SQR and nVision for financial and management reporting.
• Provided functional training to staffers covering all custom and delivered processes within PeopleSoft application.
Environment: PeopleSoft Financials 8.8 (AR, BI, AP, GL, AM), SQL Server 2000.
Client: International Speedway Corp, Daytona Beach, FL 02/05 – 05/05
PeopleSoft functional lead for Financials (AR, BI, PO, AP, GL, PC, AM) upgrade from v8.0 to v8.8. Responsible for providing
fit gap analysis, modification of customizations, system testing, training, and Production preparation for go-live.
• Created and presented fit gap document for end users highlighting incremental functionality by PeopleSoft module
delivered for v8.4 and v8.8. Incremental functionality was singled out for inclusion/exclusion with upgrade.
• Performed cleanup of AM transactional data resulting from conversion issues and subsequent user error.
• Validated compare reports to determine viability of keeping or removing existing customizations.
• Developed test scripts and system tested Financials v8.8 application including customizations. Resolved any
functional setup and technical issues discovered during system testing.
• Provided end user training on new functionality delivered by upgrade.
Environment: PeopleSoft Financials 8.8 (BI, AR, AP, GL, AM, PC), Oracle 9.2
Client: Harcourt Inc., Orlando, FL 12/04 – 01/05
PeopleSoft functional lead for implementation of PeopleSoft Purchasing and Accounts Payable for leading publishing
company.
• Resolved numerous functional and technical issues within AP and PO PeopleSoft modules relating to stability,
performance, and faulty business processes.
• Setup procurement workflow for Requisitions and Purchase orders as well as Commitment Control within Procure to
Pay PeopleSoft applications.
• Configured Accounts Payable to utilize Payment Matching and generation of annual 1099s.
• Applied bundles to Purchasing in-order to resolve numerous issues within module. Application of bundles involved
QA of all objects as well as system testing prior to release into Production.
• Loaded budget data into General Ledger against which Commitment control validation was being performed.
Configured commitment control to ensure commitments and actual expenditures did not exceed set budget.
• Provided general production support for AR, BI, PO, AP, GL, AM, and PC modules.
Environment: PeopleSoft Financials 8.4 (BI, AR, AP, PO, GL, PC, AM), Sql Server 2000
Client: Marriott Vacation Club Intl., Lakeland, FL 12/03 – 12/04
PeopleSoft functional lead for Sarbanes Oxley assessment performed on PSAR PeopleSoft application comprised of BI, AR,
AP, and GL modules. Initiative involved fortifying the security and functional control weakness inherent with the custom
version of PeopleSoft v7.5. Additional requirement involved the creation of audit reports that provided accountability for
financial transactions and accounting entries.
• Identified material control weaknesses related to data access, segregation of duties, and auditability of transactions
flowing through heavily customized PeopleSoft Financials application. Resolved all material weaknesses through a
combination of delivered PeopleSoft workflow as well as developing a bolt on Security module to v7.5 PeopleSoft.
• Implemented a Role-based architecture on a PeopleSoft v7.5 platform to mirror functionality provided by v8.0. Roles
designed to mirror the organizational job functions. Design of Roles, assignment of permission to Roles, and assignment
of Operators to Roles accomplished through conducting design/review sessions with end user community. Inheritance of
permission through Roles a key requirement of Sarbanes Oxley compliance.
• Developed audit reports to document all logons to the PeopleSoft Oracle database including Operator id and time of
logon. Audited all data manipulation of application data by the use of Oracle SQL. Oracle audit required due to PeopleSoft
application security being bypassed through direct user logon to the Oracle database. All SQLs submitted at the database
level emailed to a distribution list with an audit trail including the Operator id, OS user id, and Machine IP address used to
manipulate data.
• Restructured Oracle security to better protect against direct access of PeopleSoft data by bypassing of Application
layer. Security included creation of synonyms, removal of database links, and inheritance of permission through roles.
• Architected a security plan to protect the Unix and NT file servers resident to PeopleSoft programs, reports, nVision
reports, and other sensitive data.
• Highlighted major security issues within credit card payment management system and provided recommendations for
a more secure architecture.
• Supported heavily customized application by providing functional and technical support for custom enhancements as
well as production support.
Environment: PeopleSoft Financials 7.53 (BI, AR, AP, GL), Oracle 8.1.6
Client: Freddie Mac, McLean, VA 05/03 – 12/03
Functional lead for implementation of PeopleSoft AR/BI from a legacy AR/BI system (Goldbill).
• Architected functional framework of AR/BI including Charge Ids, Distribution Codes, and Entry Types.
• Customized Billing interface to allow assessed fees from external pricing systems to be invoiced by PeopleSoft
Billing.
• Developed conversion/transformation program to load open items and customers from legacy AR system.
• Developed custom inbound/outbound interfaces, and processes utilizing application engine programs.
• Developed custom reports utilizing Application Engine and Crystal Report technologies including Freddie Mac’s
Statement and Invoice.
• Customized Payment predictor algorithms to match Freddie Mac payment receipt business model.
• Performance tuned delivered and custom application engine programs including ar_update.
Environment: PeopleSoft Financials 8.0 SP3 (AR, BI, GL), Peopletools 8.19, UDB, Control Center, Crystal Reports
Client: HIP, New York, NY 02/03 – 04/03
Functional Lead for client’s 8.0 SP3 PeopleSoft Financials environment (General Ledger, Accounts Payable, Purchasing,
and Asset Management). Fixed numerous upgrade related function and technical issues.
• Configured functional setup for Accounts Payable, General Ledger, Purchasing, Asset Management.
• Trained end users on proper use of new v8.0 environment. End user training helped reduce data-related issues.
• Modified customized inbound PO interface SQR to conform to Peopletools v8.1 architecture.
• Fixed improper setup of Usetax within AP module. Developed SQR to identify and fix incorrectly booked Usetax
accounting entries.
• Configured GL allocations for HIP to distribute shared expenses over a range of departments and products.
• Fixed data integrity issues within the PeopleSoft General Ledger data model.
Environment: PeopleSoft Financials 8.0 SP3 (GL, AP, PO, AM), Peopletools 8.1.8, Oracle 8.1.7
Client: Marriott Intl., Bethesda, MD 09/02 – 01/03
Reporting lead for Marriott International's Financial reporting team. Developed applications that interfaced with
PeopleSoft and Maestro Scheduling tool to augment the capabilities and effectiveness of Marriott Intl.'s financial
reporting. Applications utilized the following technologies; SQR, Unix Shell Script, Visual Basic, and Oracle stored
procedures. Provided PeopleSoft expertise to resolve numerous production related issues within the GL module.
• Developed nVision and SQR reports to support the operational reporting required for Marriott Intl.
• Developed Visual Basic application to manage Marriott's nVision reporting architecture. Developed architecture of
20 NT servers to facilitate Marriott's nVision reporting on a nightly basis. Integrated VB application to PeopleSoft Oracle
database for metric reporting utilizing a back-end Access database for control parameters.
• Developed Visual Basic application to inventory Marriott’s PeopleSoft scheduled batch processes (SQRs, Shell
Scripts, Cobol, nVision) stored on Maestro scheduling tool. Architected data model within Oracle database utilizing SQRs
and Unix Shell Scripts to facilitate the transformation and load. Developed a Visual Basic GUI front-end application to
access Oracle database utilizing ADO programming.
Environment: PeopleSoft Financials GL v7.0, SQR, Unix, nVision, Maestro, Oracle 8.1.7, Visual Basic 6.0, ADO
Client: Toyota Motor Manufacturing North America, Elanger, KY 05/02 – 09/02
Security and Reporting lead for upgrade of PeopleSoft from v7.53 to v8.4. Upgrade of PeopleSoft Financials included GL,
AP, PO, AR, BI, AM, and PC.
• Responsible for upgrade of Toyota's PeopleSoft Security and nVision including web-enabling of Toyota's existing
nVision architecture as well as integration with Report Manager, PeopleSoft Security, and Microsoft Outlook.
• Resolved all upgrade script issues by determining whether issues caused by Toyota customization or flawed upgrade
script.
• Redesigned existing security architecture to eliminate redundancy and promote modularity of permission lists.
• Debugged and resolved issues with PeopleSoft upgrade application engine programs and datamover conversion
scripts during upgrade from v7.5 to v8.4. Provided functional and technical guidance during upgrade of GL, AP, PO, AR,
and BI from v7.5 to v8.4.
• Conducted and documented a fit gap analysis to highlight the functional and technical difference between v7.53 and
v8.4 PeopleSoft Security and nVision.
• Conducted a technical audit of Toyota’s security environment to document issues caused by the Peopletools
conversion scripts and highlight inefficiencies. Documented and subsequently fixed all conversion script issues. Audit
included PeopleSoft security elements such as operator ids, workflow users, permission lists, roles, row level security,
and menu items.
• Architected v8.4 nVision environment including the creation of Process Schedulers utilizing the PSADMIN tool, sizing
of the Report Repository, and integration with PeopleSoft security to provide access control to financially sensitive data.
Setup report repository and SMTP mail server to facilitate nVision integration to Peoplesoft v8 web architecture and email.
Environment: PeopleSoft Financials 8.4, Oracle 8.1.7, Unix
Client: Berlin Packaging, Chicago, IL 03/02 – 05/02
Functional Procurement and Inventory lead with primary responsibility to resolve the cost accounting issues created by
use of heavily customized PeopleSoft’s Supply Chain modules (IN, PO, OM, AP, AR, BI, GL)
• Identified erroneously booked accounting entries within the AP, IN, and OM modules including identification of
processes creating the erroneous entries. Developed fixes for improper entries as well as fixes to the custom and
delivered processes causing the accounting issues.
• Performance tuned various supply chain processes within PeopleSoft Order Management, Purchasing, and Inventory.
• Developed custom SQR report to facilitate financial and supply chain reporting.
Environment: PeopleSoft Financials/Distribution/Manufacturing 8.0 SP2 (IN, PO, OM, AP, AR, BI, GL), SqlServer 8.0
Client: Avendra LLC, Gaithersburg, MD 03/01 – 12/01
Architected and developed a custom Oracle Forms application for a leading procurement company within the hospitality
industry.
• Conducted functional design/review sessions with end-user community.
• Architected the entity relationship diagram and the physical table structures for the application.
• Developed graphical front end using Oracle Forms 6i employing PL/SQL within the forms to apply business logic.
• Created batch programs as Oracle stored procedures and triggers using PL/SQL to apply business logic to
transactional tables and ensure data integrity.
• Designed physical Oracle tablespace, table, and datafile structures to minimize fragmentation, improve SQL response
times, and facilitate quicker backups.
• Developed Unix shell scripts and utilized the Unix cron tool to automate the loading of files into the database.
• Performance tuned application by optimizing PL/SQL, SQL, Indexes, and Oracle instance.
• Facilitated data warehousing of large tables by enabling the partitioning feature of Oracle 8i.
• Developed PL/SQL interfaces to connect the custom application (PURS) with external applications.
• Created and performance tuned Cognos Impromptu reports.
• Conducted end user training for new application (PURS).
Environment: Oracle Forms 6.0, Oracle 8.1.7, Solaris 2.8, PL/SQL, Cognos Impromptu, Unix Shell scripts
Corio, Inc. – Atlanta, GA 01/00 – 03/01
Clients: Network Oil, Houston, TX; Xcelerate Corp, Fort Lauderdale, FL; Webmethods, Fairfax, VA; ZDNet, Boston, MA;
Livelink, New York, NY, Adknowledge Corp. 01/00 – 03/01
Functional and Technical Lead for PeopleSoft Financials implementations for small to mid-size companies. Clients were
provided PeopleSoft financial applications within a hosted environment using either a Citrix or VPN solution for
connectivity. Project managed 6 full life cycle PeopleSoft implementations using a rapid implementation methodology.
PeopleSoft implementation cycles times ranged from 4-12 weeks. Applications included Billing, Accounts Receivable,
Procurement, Payables, General Ledger, Budgets, Asset Management, and Expenses. Played multiple roles during sales,
implementation, and support cycles. Managed client relationship during and after implementation to maintain a high level
of customer satisfaction while trying to attain project profitability.
• Provided functional and technical PeopleSoft expertise during client presentations within sales cycle.
• Implemented business process redesign, data migration from legacy systems, development of customizations and
interfaces, testing, and end-user training.
• Migrated data from legacy applications to PeopleSoft through manual data entry, Oracle SQL Loader, PeopleSoft Excel
journal spreadsheet upload, custom SQR, or Import Manager. Legacy applications included Quickbooks, Great Plains, and
PeachTree. Migrations involved the data transfer of Ledger balances, open receivables and payables, customer and
vendor master data, and physical assets. Data exported from delivered legacy system reports into an Excel spreadsheet.
Data validated and transformed prior to load into PeopleSoft.
• Developed customizations to vanilla PeopleSoft that included creating/modifying Cobols, SQRs, nVision reports,
Panels, Menues, Peoplecode, Crystal reports, and SQL queries (Query Manager).
• Developed nVision and Crystal Reports to satisfy client’s business requirements or to replace client’s existing legacy
reports.
• Conducted functional end-user PeopleSoft training for PeopleSoft modules implemented at client site.
Environment: PeopleSoft 8.12, 7.53 (GL, BI, AR, PO, AP, AM), Oracle 8.0.4, Solaris 2.6, nVision, Crystal Reports, SQR, Cobol,
Peopletools, Process Scheduler, Application Engine, Changepoint.
Ernst & Young – Washington D.C. 06/98 – 12/99
Implemented large-scale PeopleSoft solutions for fortune 100 clients. Involved during planning, development,
implementation, and support phases of 2 full PeopleSoft implementation life cycles.
Client: Marriot Intl., Bethesda, MD 12/98 – 12/99
Technical Lead for the development and performance tuning of customized financial management reports and PeopleSoft
GL processes. The key technologies used for financial reporting were nVision and SQR.
• Managed the nVision performance tuning team for Ernst & Young at Marriott Intl.
• Managed the design, development, and rollout of custom reports using SQR and nVision technologies.
• Developed a batch nVision application using SQR to automate the submission of nVision reports to 20 NT servers.
Application interacted with the PeopleSoft process scheduler by using the PSPRCSRQST table for the submission of
nVision reports. Application utilized algorithms to balance load and maximize throughput.
• Developed a Visual Basic application to manage the 20 NT servers used for running nVision reports. Visual Basic
application wrote to a backend MS Access database.
• Performance tuned mission critical nVision reports to run on a HP/UX-Oracle platform in under 1 minute/instance.
Performance tuning of nVision reports included the setting of the nVision Performance tuning options, re-writing of the
nVision report for efficient SQL creation, the creation of summary ledgers, the creation/modification of Indexes on the
physical table structures, utilizing an efficient selector table strategy, and the development of a year-to-date ledger.
• Integrated nVision with a distribution and report archiving product using a combination of Visual Basic scripts and
Unix shell scripts.
• Conducted a technical fit-gap analysis during upgrade of PeopleSoft 6.0 to 7.5.
Environment: PeopleSoft 7.0 (GL), Oracle 8.0.4, Solaris 2.6, nVision, Visual Basic, Crystal Reports, SQR, Peopletools
Client: Sprint Intl., Overland Park, KS 06/98 – 12/98
Senior Consultant responsible for customizing Sprint’s PeopleSoft General Ledger to allow for recording of business
transactions within the Telecom industry.
• Configured the PeopleSoft General Ledger for Sprint’s business rules including setup of Combo Edits and
Allocations.
• Created a combo edit explosion strategy for Sprint that included the scheduling of Tree changes, truncation of
Combo_Data table prior to explosion, creation of dummy Business Unit/Ledger combinations, and the dropping of indexes
on the Combo_Data table prior to explosion.
• Provided mainframe/DB2 expertise during system setup and interface development.
• Developed JCL batch jobs to integrate the mainframe, PeopleSoft, and Sprint’s scheduling tool (CA7).
• Optimized GL Cobol (GLPJEDIT, GLPALLOC) processes to run with speed and efficiency. Optimized processes by
creating new indexes on the underlying physical table structures, and the seeding of the selector tables utilized in the
various GL processes.
Environment: PeopleSoft 6.0 (GL), Peopletools, DB2, nVision, Cobol, M
 | |  | |  | |  | |  | |  | |  |