Peoplesoft Consultant/Manager

Manoj Suvarna

Peoplesoft/Oracle Applications (HRMS/Financials)

Home Tel# - 609-***-****

Cell# - 732-***-****

E-Mail - **********@*******.*** and ***********@*****.***

Summary :

Peoplesoft Financials/SCM and HRMS/HCM Technical Manager/Consultant with

over 17 years experience in Application upgrades, Implementations, Tools

upgrades, Tax upgrades, Bundles, Fixes, Customizations in multiple versions

(from version 6 through version 9.1) at various clients. Proficient with

Change Assistant, DataMover and STAT tool for upgrades and migrations.

Excellent overall knowledge, with the ability to effectively co-ordinate

activities between Technical and Functional departments, during

upgrades/implementations and also while providing general support. Highly

flexible, having also worked as a Security Admin, Workflow Admin,

Programmer and Custom Developer (in both Peoplesoft and Oracle) at various

clients over the years. Ability to multi-task efficiently with excellent

people and communication skills.

Education :

MBA, Finance, Monmouth University, NJ (1989-1991)

Bachelor of Science, Mechanical Engineering, Bangalore University, India

(1983 - 1988)

Product Training and Certification:

PeopleSoft Certified Training :

Peopletools/Application Designer, Application/Tools Upgrade (Change

Assistant), Peoplecode, Application Engine, SQR, Crystal/Query, HR,

Benefits, Payroll, Time and Labor, Pension Administration, Financials

Applications (GL, AP, AR, T&E, TR, Asset Management), Workflow and

Security.

Oracle Certified Training :

Applications Developer, Oracle DBA Course Certification, Oracle Financial

Applications (GL,AP,AR, Inventory, Budgets), PL/SQL, SQL Loader, Oracle

Developer/Discover Tool.

Other Skills : Databases (DB2, Informix, SQL Server, Access).

Project Management, Excellent Communication Skills, Well versed in

Legal/Compliance/Audit matters related to Oracle/Peoplesoft Applications.

Professional Experience :

2007 to Present : Vista/Aegis Tech Inc. Peoplesoft Technical Consultant.

Client Name - Nomura Securities Inc.

Peoplesoft Financials versions 8.8 and 9.1.

Multi-level support to the Peoplesoft Financials/SCM modules like General

Ledger, Treasury, Accounts Payable, Travel & Expense, Purchasing, Asset

Management and Attestation Modules. Peopletools Upgrade Specialist for both

Financials/SCM and HR systems. Peoplesoft Security Administrator and

Workflow Administrator.

Worked with the internal/offshore team during migration tasks via the STAT

tool. Created and ran PL/SQL scripts to archive large amounts of data.

Also created scripts and used the Oracle PL/SQL loader to convert and load

text data into Financial mainframe instances.

Worked with the internal team to follow and maintain Sarbannes-Oxley (SOX)

audit related regulations specific to Peoplesoft, regarding reconciliation

of roles/access and segregation of tasks.

1997 to 2007 : Cherryroad Technologies, Inc. (Multiple clients)

PeopleSoft/Oracle Project Lead during the implementation and/or Upgrade at

the following clients.

- University of Delaware, DE

Peoplesoft Specialist during the separate Application Upgrade of both the

HRMS/Payroll and the Financials systems to version 8.8 SP1.

Effectively coordinated activities between the Technical team

(DBAs/System Admins/Developers) and the Functional teams

(Financials/HR/Payroll), while managing all the Change Assistant steps

during the Initial Moves/Test Moves and Final Move to Production.

Downloaded and Applied fixes, bundles and Tax upgrades as needed.

- NJ Turnpike/Parkway Administration

Implemented PS version 8.8 SP1 HRMS, Payroll, Pension and Time &

Labor.

Converted and loaded legacy data into PeopleSoft in an Oracle

instance.

Created SQRs to convert and load HRMS, Payroll, and Pension data.

Performed customizations and modifications to PeopleSoft as

required.

Built and Executed Time & Labor Rules.

- Board of Pensions, Philadelphia (Conversion) and Mercedes/Benz, NJ

(Upgrade)

Implemented PS version 8.8 HRMS, Payroll, and Pension Administration at

the Board of Pension and remotely performed the upgrade from version 8.0

to version 8.8 at Mercedes-Benz, simultaneously, in a DB2/UDB

environment.

- Hoffman LaRoche, New Jersey

Led the internal team through the upgrade of PeopleSoft HRMS/Payroll from

7.5 to 8.3

and then again from version 8.3 to 8.8 SP1, for various client sites in

London, Bermuda, Ireland, and various branches in the U.S

- XL Capital, Connecticut

Converted legacy data into PS 8 SP1 HRMS, Payroll for client sites in

Bermuda, London

- Mercedes/Benz, New Jersey

Led the project team through the successful upgrade of PeopleSoft HRMS

and Payroll from version 7.5 to 8.0 in a DB2/UDB database. Effectively

coordinated activities of the DBA and technical and functional

consultants during the upgrade process.

- Datastudy Inc, New Jersey

Part of the team that successfully completed the Financial Upgrade from

version 7 to 8.0.

- Philadelphia Housing Authority, Philadelphia

Converted legacy data during the implementation of PeopleSoft 7.5 Human

Resources, Benefits, Payroll, and Time and Labor for the Public Sector in

an Oracle database. Managed all data conversion aspects of the project,

converting HR/Payroll/Benefits/Time and Labor data from the client's

legacy system into PeopleSoft.

Created and modified panels, records, fields, and PeopleCode per the

client's requirements.

- Delaware Transit Corporation, Delaware

Provided post-live production support of PeopleSoft 7.5 Human Resources,

Benefits, and Payroll. Successfully researched and resolved problems

related to SQR/Crystal reports, panel modifications, tax updates, etc.

- Revlon, New Jersey

Led the implementation of the Concur/Seeker 3.0 Open Enrollment Benefits

Administration web-based product. Conducted the analysis, created

specifications, and developed Unix scripts and Oracle PL/SQL procedures

to enable the client to transfer Human Resources and Benefits data back

and forth on a nightly basis between their mainframe (Cyborg) system and

the front end (Seeker) database.

- New York Public Library

Conducted an in-depth analysis to troubleshoot and fix problems at a

major city library after the client had upgraded (on their own) from

PeopleSoft 6.0 to 7.5, on an Informix database.

- Brown Brothers Harriman, NY

Assisted with the upgrade from PeopleSoft Human Resources and Benefits

Administration 7.0 to 7.5 in a DB2 environment.

- NIKU Corp, California

Led a three-member team of programmers in the development and release of

NIKU 4.0 Resource Management Internet-based software. Gathered and

identified requirements to enable the client to upgrade to a newer

version of their product. Modified seed/metadata and developed PL/SQL

scripts to complete the upgrade on time and under budget.

- Bottomline/IFAW, Boston

Supported the implementation of Oracle 11.0.1 Accounts Payable. Modified

the application setup in order to enable the client to access specific

information from the front-end. Enabled the client to set up the check-

printing system.

- Delaware State Pension, DE

Assisted in the implementation of PeopleSoft 7.5 Pension Administration.

Designed, developed, modified, and successfully tested the panels,

records, fields and SQR to generate complex annual reports including a

comprehensive pension benefit statement for all active employees, an

annual billing statement showing the calculation of pension costs for all

firemen and an online file consisting of retiree/refund information.

(1099 IRS file and Moore Business Forms).

- NJ Manufacturers, NJ

Managed the technical team during the successful implementation of

PeopleSoft 7.5 HRMS and Payroll in an AS 400 environment on a DB2

platform. Used a combination of SQR scripts and Import Manager to

effectively convert the client's data from a legacy system to the

PeopleSoft database format.

- Global Marketing, Long Island, NY

Led the technical team during the successful implementation of Oracle

General Ledger 10.7- SC.16.1, for a direct mail marketer. Conducted in-

depth analysis to map and convert General Ledger Account numbers and

corresponding data. Used SQL*Loader and developed comprehensive PL/SQL

scripts to extract, convert, and upload General Ledger data from the

legacy system to the Oracle GL database. Created user-friendly forms

using Developer 2000 to enable the client to maintain and update the

cross-reference mapping table on an ongoing basis.

1996 to 1997: Cogniva, Inc. Project Lead.

Led a team of four during the development of an Estimation software tool

for a large construction company with Oracle 7.3 as the Database and

Visual Basic 5.0 as the front end. Designed and developed the Labor and

Materials database (Oracle) using PL/SQL and a GUI front-end using Visual

Basic 5.0. Developed an in-house Multilevel Traceability Matrix as an

inspection tool to trace test cases through different stages of

system/software requirements, design and code.

1992 to 1996 : Aqua-X, Inc. Project Engineer.

Managed various federal, state, and private construction and environmental

projects for a construction/conservation company based in NY. Estimated and

managed projects in NY, NJ, and PA including labor management, sub-

contractor hire and supervision, and quality control. Utilized PERT and CPM

techniques to maintain control of multiple projects.

References : Available upon request.

Contact this candidate