Manager Developer

Nagarjun Reddy

*********.*******@*****.***

Contact No: 505-***-****

Technical summary

> Having 8 years of experience in IT, all of which in PeopleSoft ERP

> Involved in Implementation and Development support Projects and Have

handful of experience in PeopleSoft Application Design, Development,

Upgrade and Offshore Support

> Experienced in Application Development using People Tools and has

knowledge of Application Designer, People Code, Component Interface,

Application Engine, PS Query and SQR reports and is well conversant

with PS HCM and PeopleSoft Financial applications

> Has working knowledge of retrofitting the customizations during

upgrades

> Experience in functional aspects of PeopleSoft HCM in Core HR,

Benefits and NA Payroll and PeopleSoft Financials in PO, AR, Billing,

AM, MM, RM and GL modules

> Developed reports for these modules using PS Queries, SQR and BI

Publisher by translating client business requirements into technical

specifications

> Experience in PeopleSoft HCM and Financials application testing

> Sound experience in troubleshooting issues using a methodical and

analytical approach to problem solving and focused on customer

satisfaction and is committed to quality and process

> Worked on mapping functional requirements to technical requirements.

> Developed and modified People Code to implement specific business

rules and validations to enable the system to perform the business

process

> Excellent conceptual, analytical, client facing and communication

skills complemented by solid practical experience

> Developed an application engine program using File Layouts to load New

Hire interface file with all New Hired employees' information after

each day and load them into the people soft tables.

> Applied bundles & patches for the enhancements

> Worked on interface programs for migrating data from other systems to

People Soft

> Involved in documentation of technical specifications, developing test

cases and technical design

> Involved in analysis, customization and implementation of

HR/Benefits/Payroll modules using PeopleSoft 8.8 and Oracle 9i

> Ability to work with client to identify data sources and their

availability, data extraction, processing, program construction, and

testing skills, proficient with multiple extraction, transformation

and load tools

> Experience interacting with End Users and Customers to gathering

requirements

> Proficient in administering Jobs in Process Scheduler

> An intelligent and responsible software developer, fast learner, good

technical abilities and skills developed by a strong work ethic and

self-learning

Technical Expertise:

OPERATING SYSTEMS : Windows NT/ 95/ 98/ 2000

ERPs : PeopleSoft HCM/FSCM (8x, 9.x)

LANG/ TECH : C, C++, HTML, SQL Plus and PL-SQL

DATABASES : Oracle 9i/ 10g, 11g and MS SQL Server

TOOLS : Application Designer, People

Code, Application Engine, Application Package,

Component Interface, File Layout, IB, Process

Scheduler, SQR, PS Query, BI Publisher, Configuration

Manager, Tree Manager, Query Manager, Process

Scheduler, Process Monitor, Security Administrator and

Utilities

Professional Experience:

Astute Business Solutions Pvt Ltd

March 2006 - April2014

UBI Soft Oct 2013 - Apr

2014

PeopleSoft Developer

Ubisoft Entertainment S.A. is a French multinational video game developer

and publisher, headquartered in Montreuil-sous-Bois, France. It has

specific expertise working with PeopleSoft Enterprise Applications to keep

the business operating a peak performance levels.

Upgrade Responsibilities:

The project is an upgrade of FSCM 9.0 to 9.2 along with streamlining of

customizations and testing of all new 9.2 features.

Activities involved are:

. Created and modified Components, Pages, Records, Fields, Process

Definitions and registering Components in Portal, Menu and Permission

Lists

. Compare Report reviews and impact analysis of customizations

. Development and retrofitting customized SQR and online PeopleSoft

objects such as Fields and Translate values, Record, Pages, Component,

Menus, PeopleCode, AE, SQL, CI, App Packages, App Messages, Service

Operations, Jobs, Job Definitions, Process Definitions etc...

. Create projects to migrate customized objects

. Retrofitting of SQRs / BI Publisher /nVision reports in the new

version

. Reapplying PeopleCode customizations

. Involved in design, setup and configuration of the application,

reports and interfaces

. Retrofitted and applied customizations to delivered SQR's(PO_dispatch)

. Developed ad-hoc reports and ad-hoc queries developed Run Control

Pages as per requirements and attached to menu to run SQRs for the

developed sqrs

. Involved in Vanilla compare to find out level of customization

. Verify and validate PeopleSoft Object upgrades

. Verify and validate correctness of customizations brought over in the

upgrade

. Involved in running Upgrade Compare Reports between Demo database and

Copy of production before we do the upgrade copy

. Used Application up grader to migrate objects from Demo to Target

instance. Modified customized SQR reports in version 9.0 to make it

version 9.2 compatible and to accommodate the new key structure

. Extensively used Process scheduler for setting up the reports to run

at specific time and used Process Monitor to monitor the status of

reports. Created Permission lists, users, roles and assigned roles to

users through Maintain Security

. Upgrading, Support and Troubleshooting Technical & Functional issues

. Test the non-PeopleSoft Objects like SQR and Crystal reports

. Attend project status meetings to review project progress and present

risks including issues and constraints that are impeding or may impede

project performance. Provide recommendations for risk mitigation

. Prepare and issue requested project status reports covering all

assigned pending and current project activities

Development Environment: PeopleSoft (FSCM 9.0, 9.2), People Tools 8.50,

8.53, Oracle11g

People Tools used: Application Designer, PeopleCode, Application Engine,

Application Packages, App Messages, CI, SQL, Process Scheduler Manager, BI

Publisher and SQR

PeopleSoft Test Framework

June 2013 - Sept 2013

PeopleSoft Developer

PeopleSoft Test Framework (PTF), PTF automates various tasks within the

PeopleSoft application,

Primarily functional testing. Automating functional testing enables testers

to execute more tests with greater accuracy during a shorter time. Test

assets (tests and test cases) are stored in a database as Application

Designer objects. As a result, test assets are PeopleTools-managed objects,

which can be managed along with other PeopleTools-managed objects through

PeopleSoft Lifecycle Management

Implementation Responsibilities:

PTF comes with one default test case, our requirement was to generate

multiple test cases for different test types like test, shell test etc,

the design differs for each type.

Search component whose functionality is simulation of PTF tool, to make

user easy to search the specific test script related details.

If no parameters are defined it displays all the test scripts details

related to the environment.

Activities involved are:

. Created New PeopleSoft Objects like Fields, Records, Pages, Menus, and

Components

. Worked on online PeopleCode to meet the customizations, validations

and dynamic sqls etc

. Developed New SQR's to Create or Update Test Cases(Test and Shell

Test)

. Developed a Modal PTF in PIA using PeopleCode

Development Environment: PeopleSoft FSCM 9.2, People Tools 8.53,

Oracle11g

People Tools used: Application Designer, PeopleCode, SQR and Process

Scheduler

DSNY

Mar 2012 to May 2013

PeopleSoft Developer

Sanitation Department of New York City (DSNY), Implementing PeopleSoft HCM

and FSCM application and is Integrating PeopleSoft with Java using web

services.

Responsibilities:

. Created Technical Specs for the requirements and undergone the

development and testing for the same

. Developed asynchronous Integration between objects in HCM and FSCM

using integration Broker

. Developed a custom page(Additional Employee details of NYC) under

JOB_DATA component

. Customized the PERSONAL_DATA and JOB_DATA component to meet client

requirement

. Applied customizations to Work Order page

. Creating and Testing Component Interface

. Creating Component Interface People Code and executing it through

Application Engine Program

. Developed Application Engine Programs to populate Job data and Job

Related custom data

. Transferring Data from Flat file to Database using Application Engine

Program Through Component Interface Object

. Created New PeopleSoft Objects like Fields, Records, Pages, Menus, and

Components

. Customized HR, payroll menus, enquiry pages as per the user

requirement so that user can view more information

. Customized SQL Views, records and People Code functions like SQL Exec,

Scroll Select etc

. Involved in setup of SetID table, Company Information, Establishments,

Location, Department, Salary plan, Job Code and Pay Group tables for

HRMS System

. Maintaining PeopleSoft user security using user profiles, roles &

permission lists

. Developed various PS queries in order to help the client day-to-day

activity

1. Sanitation Worker's Holyday List

2. Sanitation Worker's Sunday List

3. Officers Chart List

4. BORO's Snow Vehicle's List

5. Dressable Equipment's for Garage/Boro

6. Down Vehicle list of Garage/Boro

. Testing of the developed Applications and interfaces

. Involved in Data mapping between the two systems

. Worked extensively on Application Engine, Application Designer, People

Code, Application Package, Integration Broker, Fusion(SoapUI), CI, PS

Query, BI Publisher

. Done with the New Development and enhancements to the existing

functionality

. Done the peer-review for the developments, UTP Preparation and

documentation

Development Environment: PeopleSoft HCM/FSCM 9.1, People Tools 8.52,

Oracle11g

People Tools used: Application Designer, PeopleCode, Application Engine,

Application Packages, App Messages, CI, IB, SOAP, Process Scheduler Manager

and BI Publisher

Gregg Appliances, Inc

Aug 2011 to Feb 2012

Astute Business Solutions, India

PeopleSoft Developer

Gregg Appliances Inc is a publicly owned and operated appliance and

electronics retailer in the Midwest, Northeast, and Southeast United States

and is implementing HRMS 9.1 and the project involves development work from

offshore.

Responsibilities:

. Developed conversion programs using SQR for loading employee's data

into PeopleSoft HRMS system for Payroll Deduction Life Cycle from

MetLife Insurance

. Developed conversion programs using Application Engine for writing

file of employees who are Eligible for MetLife Auto & Home policy

based on employee status code

. Developed XML Reports using Application Engine.

. Developed SQR which generates report based on program run status.

. Created New PeopleSoft Objects like Fields, Records, Pages, Menus, and

Components.

. Creating and running sql scripts to perform select and deletes on Base

and Non-Base tables.

. Performance review and testing of conversion programs as per the

design documents.

Development Environment: PeopleSoft HRMS (9.1), People Tools (8.51),

Oracle 10g

People Tools used: Application Designer, Application Engine, PeopleCode,

Process Scheduler Manager and SQR

CircleK

Oct 2010 to July 2011

Astute Business Solutions, India

PeopleSoft Developer

Circle K is the largest company-owned convenience store chain in the U.S,

and second in overall number of U.S. stores. Circle K's success in the

convenience retailing industry spans more than 50 years.

Responsibilities:

. Retrofitted SQR's to incorporate the functionality in the upgraded

version: Payroll summary, Report promotions/demotions, Payroll money

order data, Set environment, Part time percentages, cost center

report, life rates, load one time pay adj from flat file, custom -

prompt for dates, create file for ckmgrbs from spreadsheet data.

. Involved in design and development of conversion programs using SQR

for transferring of data from legacy system to PeopleSoft HRMS

. Reapplied SQR customizations for modules like North American Payroll,

Time and Labor, Benefits Administration, eProfile (self service

applications) etc.

. Task monitoring, Status reporting On Daily and Weekly Basis.

. Testing of all retrofitted and customized SQR's.

. Retrofitting and Generating Of SQR.

1) Part time working full time.

2) Update calendars with runids from flat file.

3) Import tax data.

4) Payroll money order data.

5) Equal Employee Opportunity (EEO).

6) Update sal plan/grade.

Development Environment: PeopleSoft HRMS (9.0, 9.1), People Tools (8.48,

8.50), Oracle 10g.

People Tools used: Application Designer, Process Scheduler Manager and SQR

Wynn Resorts Dec-

2008 to Sep-2010

Astute Business Solutions, India

PeopleSoft Developer

Wynn Resorts is a global leader in resorts and Hotels. Astute provides

PeopleSoft Apps DBA and Application development support to Wynn from

offshore.

The project was an upgrade of FSCM 8.8 to 9.0 along with streamlining of

customizations and testing of all new 9.0 features.

Responsibilities:

. Development, Enhancement and Customization of People Code programs

. Development of new online objects and Queries

. Troubleshooting various issues related to Voucher posting and payment

posting.

. Customization of existing Interfaces, Reports and Queries to suit

client requirements.

. Development of new SQR and Application Engine programs for

interfacing.

. Running SQL's to change the voucher origin for the specified voucher.

. Running of interim refresh job for every quarter.

Development Environment: Windows 2000/ SQL Server, PeopleSoft FSCM (8.8,

9.0), People Tools (8.44, 8.50)

People Tools used: Application Designer, PeopleCode, Application Engine,

Component Intfc, Process Scheduler Manager and SQR

RBTT Global Limited Jan-2007 to

Nov-2008

Astute Business Solutions, India

PeopleSoft Developer

This was a PeopleSoft HRMS 8.8 Implementation Project for RBTT through

Astute Business Solutions. The project responsibilities included

development of SQR reports and the development of a custom bolt-on

application called Keyword Search Application, which provided a single page

on which a search on the database can be conducted for the various modules

implemented in PeopleSoft.

Responsibilities:

. Generated SQR's for Employee Nationality Details.

. Created New PeopleSoft Objects like Fields, Records, Pages, Menus, and

Components.

. Developed People code to get Employee Leave Date in Absence Monitory

Module.

1. Employee Absence History and Leave Break History.

. Inbounding Data from Legacy System to PeopleSoft Database Using Excel

to CI.

. Developed an AE Program to Get Employees Job data related to Self

Service Module.

. AE Program for Employee Degree from CSV File.

1. Loaded the Data From CSV File To Database

. Customization and Generating Of SQR.

1. Passport Exp Details.

2. Termination Report.

3. Allowance Reports

4. Residence Report.

Development Environment: Microsoft SQL Server 2000, PeopleSoft HRMS (8.8),

People Tools (8.48)

People Tools used: Application Designer, Application Engine, PeopleCode,

CI, File Layouts, Process Scheduler Manager and SQR

Broadcom Corporation March 2006 to Dec

2006

Astute Business Solutions, India

PeopleSoft Developer

Broadcom Corporation is an American fabless in the wireless and broadband

communication business. Broadcom Corporation was originated in 1991 and

headquartered in Irvine, California.

The project was an upgrade of HRMS 8.8 to 9.0 along with streamlining of

customizations and testing of all new 9.0 features.

Responsibilities:

. Apply customizations: Create SQR, Component interfaces and to fulfill

the requirement of the latest needs on HCM 9.0.

. Generated SQR's on Related to Time and Labor Module.

1. Transfer Employees, Approve Transfer, Assign Work Schedule,

Full/Part Time Status, Location Change

. Developing inbound and outbound interface programs using Application

Engine and Component Interface based on given data flow diagrams.

. Developed People code customizations on Employee Reported Time (Start

Time, End Time) and Location Change on Manager Self Service Module.

. Customized The CI For Civil Id Of The Employee.

1. Mapping the Civil Id Data Using CI.

. Tested and Migrated developed objects to Production Database

Development Environment: Microsoft SQL Server 2000, PeopleSoft HRMS

(8.8/9.0), People Tools (8.48, 8.50)

People Tools used: Application Designer, Application Engine, PeopleCode,

CI, File Layouts, Process Scheduler Manager and SQR

Contact this candidate