Senior Peoplesoft Consultant

Summary:

More than ten years of experience with the PeopleSoft HR and Financials Applications, most recently Version 9.0: HRMS, General Ledger, Asset Management, Accounts Receivable, Expenses, Accounts Payable, Purchasing, Inventory, Projects, Workflow and PeopleSoft Security.

Development Tools: Application Designer, Application Engine, Excel CI, People Code and Tree Manager.

Integrations Tools: Application Messaging Component Interface.

Administrative Tools: Process Scheduler, Data Mover and PS Workflow.

Reporting Tools: PS nVision, SQR, PS Query and Crystal Reports.

MS Office: Excel, Word, Powerpoint, Visio.

SKILLS:

PeopleSoft HRMS Peoplesoft Developer senior member of the HRMS applications support team providing support of a production PeopleSoft HRMS v9.0 environment, including HR, Payroll, Benefits Administration, Global Payroll, Time and Labor.

Vast PeopleSoft HRMS development experience includes analyzing, designing, coding, stress, regression testing, troubleshooting and integration.

PeopleSoft T&L and Payroll implementation, functional and technical support for the systems.

implementing and maintaining applications and modules that improve processes.

Special expertise in benefits processes with programming and support experience in

PeopleSoft, Dun & Bradstreet applications.

PeopleSoft Financials V.6, V.7, V.8, V.9 General Ledger, Asset Management, Accounts Receivable, Expenses, Accounts Payable, Purchasing, Inventory, Projects and PS Security, MS Office.

EXPERIENCE:

07/07 – Present ASSURED GUARANTY CO. New York, NY

PeopleSoft Sr. Programmer Analyst

Environment utilized: PeopleSoft 9.X, PeopleSoft 8.X, Tools/ /PeopleCode/Crystal Reports/SQR/Excel

CI, Reports/ Nvision Reports/SQL/MICROSOFT SQL Server.

HR:

Designed and developed Technical and Functional specs for Payroll Interface (Ceridian to PeopleSoft).

Also designed and developed Technical and Functional specs for Payroll Interface (ADP to PeopleSoft).

Participated in setup of the Time and Labor application for the PeopleSoft Implementation for AGC. This includes Reporting Elapsed Time, Approving Time, Adjusting Time, Labor Distribution and Dilution and Integration with a Global Payroll system and integration with PeopleSoft Financial.

Developed Component interfaces to bring data in PeopleSoft HR tables from legacy systems.

Developed functional and technical specifications for Compensatory Time and Schedules and Forecasting

Participated in customization of Time and Labor that facilitates the management, planning, reporting, approving of time, calendar and schedule creation and usage from one global web-based application.

Participated in customization of payroll application - compensates time reporters for their payable time and, at the end of the pay run, sends labor-related costs back to Time and Labor, where they are distributed across payable time and made available to the PeopleSoft Projects and Expenses applications.

Involved in the design strategy and implementation of conversion the data from 8.9 to 9.0 HR,

Utilizing Excel CI

Involved in design, development, enhancement and maintenance of PeopleSoft HR, Base Benefits and Payroll

Written conversion reports using SQR to load data into PeopleSoft Payroll tables.

Written DMS scripts for data conversion using data mover. Developed PS queries, SQR reports and Crystal Reports as per the requirements and provided support and knowledge transfer to functional team.

General Ledger:

Designed, developed and implemented Technical specs for Combo Edit Rules.

Defined Allocation steps and Allocation groups – to ensure proper allocation between business units and departments.

Developed consolidation and equitization rules as per the requirements (Subsidiary Ownership and Minority Interest set.)

Nvision Reports – created new and modified existing Nvision reports.

Customized GL Activity report

Customized Workflow for Journal approval.

Implemented security for all GL, Asset Management, HR and AP users, defined Roles and Permissions Lists.

Asset Management:

Modified delivered SQRs (Depreciations).

Loaded AM data from PS 8.8 to PS 9.0 utilizing Component Interface ExcelToCI.

Loaded AM data from BNA (Legacy System) to PS 9.0 utilizing Component Interface ExcelToCI.

Accounts Payables:

Developed number of Component Interfaces to migrate data from PS 8.8 to PS 9.0.

Developed new SQR and Crystal Reports for VAT and 1099 reporting.

Customized layout of the bank check as well as the layout of Positive Pay file

02/01 – 07/07 CUSHMAN & WAKEFIELD New York, NY

Lead Analyst of Corporate Accounting Systems

Responsible for the analysis, design, creation, functional/program specifications, implementation, testing,

debugging and maintenance of the PeopleSoft Financials General Ledger, Accounts Payable, Expenses,

Accounts Receivable, Asset Management and HR modules. Participated in development and maintenance of

various PeopleSoft systems and subsystems. Developed complex stored procedures for Crystal Reports and implemented system security.

Environment utilized: PeopleSoft 8.9.X, PeopleSoft 7.X, Tools/ /PeopleCode/Crystal Reports/Windows NT 4.X/ SQR/SQL/MICROSOFT SQL Server 2000, MS Office.

HR:

Involved in setup of Schedules and Forecasting

There are three scheduling environments that an organization is likely to encounter – fixed, rotating and dynamic.

Time Collection Device (TCD) – T&L System

Time and Labor’s time collection process enables you to control how the system collects and sends time-related information to and from third-party, time-collection device.

Analyzing data collected from both punched and elapsed time data from any TCD for processing through Time and Labor. Sending setup data to these devices for improved performance and flexibility. Setup data, such as time reporter and supervisor information, task detail, and restriction rules, are synchronized with the clock system. After time is reported using a TCD, Time and Labor can apply rules to the clock data and process it for the purposes of scheduling, reporting, and time management.

Wrote specs for customization of Global Payroll PeopleSoft System (South American Unit - Brazil and Argentina) which included the management, planning, reporting (Crystal Reports, Queries and Component Interfaces) , calendar and schedule creation.

Participated in customization of Compensatory Time - compensates time reporters for their payable time.

Analyzed data for Canadian tax forms (NR4 and T4061) and Mexican tax forms.

Customized Crystal Reports for Canadian and Mexican tax forms.

Accounts Receivables:

Designed and developed Technical specs for Customizations of Accounts Receivables system.

Developed and customized Aging Reports (summery and detail by business unit and account).

Created a new Customer Statement.

Participated in troubleshooting of AR UPDATE application engine process, which is used to

process and update customer balances and history information, item information and activity.

Developed AP to AR interface: AP Vouchers with a distribution to Accounts Receivable that are posted to AP and subsequently ‘Closed’, ‘Un-posted’ or ‘Re-posted’. Such subsequent changes to AP vouchers must be captured by AR.

Developed EX to AR interface: When a user selects a Client Reimbursable Recovery/Billing Option which contains one of the pre-defined AR account codes, the system will prompt employees to enter AR transaction data.

Accounts Payables:

Customized layout of the bank check as well as the layout of Positive Pay file.

Customized the Pay Cycle by adding a step to the Pay Cycle process for Positive Pay file.

Implemented security for all AP users, defined Roles and Permissions Lists.

Worked on customization for Open Item GL: When an Open Item GL account is entered on a voucher,

the system will require the user to enter an Open Item Key.

EXPERIENCE:

As delivered the system does not allow the user to validate against a prompt table for all possible Open Item Key values for the particular Item Account entered.

Setup ACH processing to handle direct deposit from BONY to employee banks.

After the pay cycle is run, the ACH payment file should automatically be generated. Payments are transmitted via BONY to the appropriate banks.

Expenses:

Customized all inquiry pages related to expense sheets would require that this rate be shown as well. Percentages of 100%, 50% and 0% will be pre-set to appear in the drop-down.

Check UserID and EMPLID on expense report. If they are different, the employee is a delegate and the Submit button should be disabled. If the same, the employee should be able to submit expense reports.

When entering an expense with Client Reimbursable ‘DFC’ Billing Type or Managed Building Reimbursable ‘MBR’ Billing Type the user will be prompted that they must enter accounting information before they can click on Done. The user must click on the Accounting Entries link and enter AR Business Unit, Customer ID and Entry Reason and Department before they can successfully click on the save button. Account number will default based on the Billing Type Setup to account 1xxxxx for Client Reimbursable (DFC) or account 2xxxxx for Managed Building Reimbursable (MBR).

Worked on C&W requirements that the Expenses module produce a print-able, all-purpose Expense Report listing detailed expense line information missing from the delivered Expense Report EXC4500. Additionally, CWEX4600 crystal report was customized from EX4600 Expenses Transactions by Department to include Report Name.

When using Hotel Wizard to itemize hotel bills, the employees need to categorize transactions from the hotel bill. C&W policy states that laundry, movies, gift shop and spa-type of expenses are personal expenses. Hence, when itemizing hotel bill, employees must click on the ‘Personal Expense’ checkbox for any of these items.

General Ledger:

Developed an Application Engine program to load Budget Data from OutlookSoft to PeoleSoft General Ledger.

Modified Journal Entry page to include two customized fields. Customized Trial Balance report, Ledger vs. Journal Integrity Report, GLS7501 report (to capture operator ID in the journal entry, print at the header level).

Developed and customized GL Activity Reports by Account and Department ID.

Developed new GL Activity reports for our users in South America by AltAccount and by Contract.

Asset Management:

Modified delivered SQRs (Depreciations).

10/89 – 02/01 COLUMBIA HOUSE COMPANY New York, NY

Lead Programmer Analyst of Corporate Accounting Systems

Responsible for the analysis, design, creation, functional/program specifications, implementation,

testing, debugging and maintenance. Solely responsible for converting a major subsidiaries OS/MVS/CICS/COBOL/VSAM, Accounting System to PEOPLESOFT/WINDOWS NT/INFORMIX System. Currently converted the General Ledger and Accounts Payable System that are in final completion. PeopleSoft has replaced the legacy Dun & Bradstreet Package. This entailed expert customization techniques defining various user requirements, resulting in a New "Chart of Accounts" for the General Ledger, Accounts Payable System, The Purchase Order System supports twenty three (23) divisions which is in the analysis phase of this conversion. This was developed using PeopleSoft 7.X, 6.X/PeopleCode/ PeopleTools/SQR/SQL/Windows NT 4.X/INFORMIX. Also support the D&B Accounts Payable Version 5.2, 5.3 and General Ledger Version 2.3. Responsible for:

EXPERIENCE:

Accounts Payable system upgrade from 5.2 to 5.3.

Modifying JCL and programs accounting to company standards.

Code on and off-line portions, then test them.

Write programs using COBOL, CICS, and VSAM to support D&B, to provide detailed reports about specific functions of the system.

Keep post year records on file that document transactions.

Allow particular transactions to be recovered.

Provide listings by department of transactions and maintain/resolve ABENDS.

As Senior Programmer Analyst on the Royalty System, this is an on-line System that tracks contract information and payment due to the recording artist, responsibilities include:

Logging in and keeping track of all contracts and music recorded by each artist.

Created screens utilizing CICS, DB2, and CSP4GL that display artist's name, company, type of

contract, data to be paid.

The system is based on profits of records (Sales).

Also track free units vs, invoice units.

04/88 – 09/89 EQUITABLE LIFE ASSURANCE COMPANY New York, NY

Programmer Analyst

As Programmer Analyst in the Payroll Department, worked on a Tessaract Package utilizing

COBOL, CICS, and VSAM files. Responsible for special projects such as U.S. Savings Bonds, a

1099 Tax Reporting System, and a W2/W4 Mailing System. Projects were comprised of "on-line"

systems that were utilized for the input of data as well as "off-line" systems those were responsible

for reporting to the users of the Payroll Department. Reports included the status of each bond holder,

forms and statements were created on a monthly basis for customers to be informed of their bond

holdings, earnings or tax status.

10/87 – 03/88 PARAGON CONSULTING COMPANY New York, NY

Programmer Analyst

Responsible for writing technical specs, coding and testing of custom reports for AT&T,

Education: BS in Computer Science. Polytech Institute of Tashkent, Uzbekistan.

References will be furnished upon request.

Contact this candidate