Ram Kumar Sunki Reddy

*** **** ** *****: 978-***-****

Shrewsbury, MA 01545 Email: accm0m@r.postjobfree.com

SUMMARY:

• Over 10 yrs of experience in PeopleSoft HRMS (HR, ELM, BENEFITS, PAYROLL, Recruiting and

T&L), Financials (GL, AP, AR, AM, and EXP).

• Experienced in various releases of PeopleSoft/Oracle database implementations, Mergers,

platform migrations, upgrades, production support, Security administration, performance

tuning, monitoring and working with development tools.

• Experienced in install, configuring and managing backend components – web server,

application server, process scheduler, and database servers.

• Experienced in troubleshooting, applying bundles, patches, fixes and tax updates.

Extensively used Change Assistant, UPGRADE ASSISTANT, Change impact analyzer and

DATA MOVER for PeopleSoft upgrades and patches.

• Substantial experience in design and development of SQRs, Application Engines, Component interface,

Peoplecode, Application Package, Integration Broker, PS Queries and PeopleSoft application troubleshooting.

• Experienced in working with in house and hosted environments.

• Experienced in OBIEE

SKILLS:

PeopleSoft Skill Set: Application Designer, PeopleCode, Process Scheduler, Query/Tree

Manager/Connected queries, Application Package, SQR, Security, Workflow, Crystal Reports, Data

Mover, Import Manager, Business Process Designer, PeopleCode Debugger, Upgrade Assistant,

Component Interface, Application Engine, Application Message, Change Assistant, Integration Broker,

Change impact analyzer, Performance Monitor, XML Publisher, Peoplesoft App and webserver

administration, UPK.

OBIEE Skillset: Security, Migrations, ETL, Dashboards, Reports

Languages: C, C++, JAVA 2.0, PL/SQL, VB, Assembly Languages (8085, 8086, 68000), J2EE, JSP,

SERVLET, J2ME, COBOL

Databases: ORACLE, SQLServer, ODBC, JDBC, TM/1, Object store, Sybase, MS Access

Scripting: HTML, CGI, Perl 5.0, Java Script, WML, VXML, XML, XSL

Application Servers: Tuxedo

Web Servers: Weblogic Server, Apache

O/S: UNIX [HP-UX, Sun Solaris SCO], Windows, Linux

EXPERIENCE:

Senior Programmer Analyst/Peoplesoft Admin/OBIEE Admin Oct 2007 – Present

Client: Citizens Bank (RBS America)

Modules: HR, Recruiting, Payroll, Time and Labor and Profile Management

• Configured new ELM environment application version 9.2 and tools version 8.53.

• Configured the integration between the HCM and ELM.

• Synced the data between HCM and ELM.

• Configured SSO between HCM and ELM.

• Configured SES for ELM.

• Performed upgrades from HRMS 8.8 to 9 and from 9 to 9.1

• Performed tools upgrade from 8.47 to 8.48, 8.48 to 8.49, 8.49 to 8.51 and 8.51 to 8.52

• Managed OBIEE security at the dashboard level and also applied RLS security from Peoplesoft

• Managed OBIEE Migrations

• Performed ETL changes to the delivered ETLs to make sure all the data is being populated to the

datawarehouse

• Managed the DAC server to schedule the ETLs

• Involved in fit/gap analysis during all upgrades

• Installed, configured and managed Peoplesoft infrastructure for production and non-production

environments.

• Extensively involved in performance tuning (database, appserver, webserver)

• Performed all code migrations for all development.

• Developed scripts and processes to monitor different components of application.

• Performed database backups and refreshes

• Redesigned and developed Peoplesoft security by implementing role based access.

• Created scripts for automatic transmission of interfaces to external and internal vendors.

• Resolved data issues during upgrades.

• Applied tax updates.

• Provided functional/technical support by researching the issue and providing the solutions.

• Developed new interfaces using SQR, App Engines, and Component interface.

• Designed and developed processes to scramble data for test environments.

• Created database triggers for auditing purpose.

• Designed and developed processes for Payroll and Time & Labor data archival.

• Provided support for deploying UPK content.

• Configured and managed Peoplesoft Performance Monitor.

Infrastructure was hosted with initially with CSC and then with Oracle. Worked closely

•

with the hosting providers in planning the architecture.

Extensively involved in the change of hosting vendor from CSC to Oracle.

•

• Extensively involved in interviewing business users to obtain requirements, writing technical specifications

and documenting application development.

Trained other team members to support the application.

•

Integrated external vendors like Resume Mirror, ChoicePoint (Lexus Nexis), FADV,

•

Mohamine, PSYNC, Talent Tech

Extensively worked on Peoplesoft infrastructure move from one vendor to other.

•

Developed programs to generate metrics on database statistics and usage.

•

Conducted performance test using automated tools.

•

Involved in remediation of issues identified from external and internal audits.

•

Extensively worked on tuning performance issues for Payroll, Time & Labor and

•

Recruiting processes.

Analyzed and resolved data integrity issues related to Payroll and Time & Labor.

•

Provided on call support.

•

Senior Programmer Analyst/Peoplesoft Admin Oct 2005 – Oct 2007

Client: Duke Energy

Project: Peoplesoft HRMS Upgrade

As part of a team, involved in upgrade of HRMS 8.3 application to HRMS 8.9. This was a two-

step upgrade. First platform migration of DB2 to Oracle and then upgraded the application

version.

• Involved in installing Peoplesoft version 8.9 and setting up the app servers and web servers for the

application.

• Involved in Fit/Gap analysis.

• Involved in the platform migration from DB2 to Oracle 10G.

• Resolved the tablespace issues while migrating from DB2 to Oracle.

• Tuned data conversion scripts, programs and processes to expedite upgrade process.

• Performed upgrade activities using Change Assistant .

• Involved in tuning the appserver and webserver to improve the performance.

• Involved in setting up the environment for System and Load testing.

• Developed SQR to interface with oracle DB (financials) and capture data for People Soft AP Vendor.

• Designed, developed and automated number of HR tasks that are specific to the client business

requirements.

• Developed Messaging between Peoplesoft Financial and PeopleSoft HRMS modules.

• Developed Messaging to send employee information to the Portal.

• Created different environments for development, System testing and production.

• Involved in setting up the Integration Broker for Application Messaging.

• Implemented PeopleSoft security.

• Designed and developed global HR, Benefits, and Payroll modules to accommodate country and region

specific regulatory requirements and business critical needs that are not covered by PeopleSoft delivered.

Development of this module involved creating of new records, pages, components, menus and extensive use of

complex People Code to enforce business rules and calculate benefits entitlement as of date.

• Designed and developed an interface to a third party system using PeopleSoft integration tools.

• Fine-tuned the HRMS application and number of programs to improve the performance.

• Trained business users in the use of PeopleSoft custom modules.

• Conducted system test and assisted Business users during user acceptance testing.

• Worked on Post Production Issues.

ENVIRONMENT: People Tools 8.47, HRMS Application 8.9, Oracle 10G, PL/SQL, SQR, Tuxedo/Jolt,

Weblogic 8.1, Windows 2003, OS/390 DB2

Senior Programmer Analyst Mar 2004 – Sep 2005

Client: Boston Scientific Corp.

Project: Production Support

• Involved in Fit/Gap analysis of Upgrade process from version 8.3 to 8.9.

• Involved in installing Peoplesoft version 8.9 and setting up the app servers and web servers for the

application.

• Involved in People Tools Upgrade from Version 8.17 to 8.20 using Upgrade Assistant

• Researched and resolved the post Tools Upgrade issues.

• Tuned a number of batch processes to improve performance. In some cases, process time was

improved from a few hours to minutes.

• Assisted business users with setup of PeopleSoft security by developing some reports which was

served the foundation for total security revamping. This process was developed as part of

Sarbanes Oxley act compliancy requirement.

• Involved in applying the BenAdmin bundle #2 to fix production issue of duplicate rows.

• Designed and developed a Component Interface and App Engine to automate the transfer of employees

from one location to another location along with change in departments. Helped business analysts in setting up the

department security for the new location.

• Designed and developed a Component Interface and App Engine to load mass salary changes as a part of

federal requirement. This process was robust and it served the purpose all the global users. Made modifications to

delivered mass salary changes functionality to fit the purpose of the Business. This also served as the input to the

component interface. This process saved a lot of man hours.

• Involved in building the application servers as the database was moved to new server and upgraded from 8i

to 9i.

• Involved in upgrading Oracle client on all the users terminals while changing the TNS names entries.

• Involved in testing and making it sure the database connections were working as the new production was in

9i environment and the other test environments were in 8i version.

• Involved in developing test scripts for user testing for Oracle upgrade from 8i to 9i.

• Designed and developed a Component Interface and App Engine to Interface Costa Rica Payroll between

Peoplesoft and Exactus (Payroll system).

• Designed and developed an Interface between Peoplesoft and Talx using an SQR. Talx is a third party

vendor who provides services for unemployment claims and employment verification. This interface got the data

from Peoplesoft and ADP (Payroll system). This process involved lot of complex programming logic and creating

Panels for setup data.

• Assisted the users in setting up the FTP and PGP to send the interface files to various vendors.

• Designed and developed an interface between peoplesoft and Kronos. This interface creates a file which has

all the hourly employee information. The kronos team uses this file for setting up all the hourly employees into

kronos.

• Designed and developed programs to audit the Year End merit review process. This process compares

Peoplesoft data and the data in the CSV files which are created by the Payroll Interface process. This process strips

out the No Merit Rows from the CSV files which were creating a lot of problem when loading the CSV files into

ADP. All of these kick outs were written to a log file for further review by the business.

• Designed and developed a Component Interface and App Engine to load new hires from a spread sheet

when there was a merger with another company.

• Designed and developed Component Interface and App Engine to load ABBR row for all the employees

into the system.

• Designed and developed a Component Interface and App Engine to load a new row into Department table

for a change in department names, also load a new row into Job for all those employees who are in that department.

• Designed and developed a Component Interface and App Engine to load Dependents benefit information.

• Developed new Components, Pages, and Records to build a custom process to monitor the Competencies of

the employees.

• Involved in documenting all the processes which does not have documentation. This involved lot of

research of the programs created by others.

• Helped the Analysts to get information from the database for their analysis.

• Modified custom SQRS to fix production Issues.

• Wrote a SQR to give all the Permission lists a PeopleSoft user has, sorted by Job title.

• Tuned the queries which took long time to execute.

• Created new queries as per the user’s request.

• Researched and found solutions to Break/fix Application production issues.

• Conducted system test and assisted business analysts during acceptance testing.

• Extensively involved in interviewing business users to obtain requirements, writing technical specifications

and documenting application development.

ENVIRONMENT: People Tools 8.17/8.20, HRMS Application 8.3, Oracle 8i, PL/SQL, SQR, Tuxedo/Jolt

6.5, Weblogic, Windows 2000

Senior Programmer Analyst May 2003 – Jan 2004

Client: Staples Inc

Project: Consolidation of Canadian Database

As part of a team, Consolidated USA and Canadian instances of the PeopleSoft application. This

project centralized the administration of PeopleSoft application. Upgraded the Canadian HRMS

7.5 to 8.3 and this was done without any down time to the production servers.

• Involved in Fit/Gap analysis.

• Involved in the database analysis to get the differences between HRMS 7.5 and HRMS 8.3.

• Involved in the developing the table loading sequence for setup and employee tables.

• Designed and developed Application Engines and Component Interfaces to load setup data from Excel

spread sheets, for automatic data entry. This involved lot of complex people code, extensive redesigning of records,

Pages, Components to enforce business rules and maintain data integrity.

• Designed and developed SQRs, Application Engines and Component Interfaces to load employee data from

7.5 to existing 8.3 databases, while taking care of new fields.

• Designed and developed custom Manager Self Service functionality for Canadian users.

• Designed and developed Application Engine and Component Interface to load training data as an interface

to third party.

• Designed and developed Application Engine and Component Interface to load Employee Review as an

interface to third party.

• Identified the new and changed fields in 8.3. Incorporated these changes into the custom SQRs.

• Designed, developed and automated business tasks using PeopleSoft Integration tools.

• Wrote People Code to Maintain Data integrity between Canadian and USA data.

• Worked on Post Production Issues.

• Was involved in developing unit test scripts, Test plans, Test data and Unit Test Conditions

• Conducted system test and assisted business users during acceptance testing.

• Extensively involved in interviewing business users to obtain requirements, writing technical specifications

and documenting application development.

ENVIRONMENT: People Tools 8.17, HRMS Application 8.3, Oracle 8i, PL/SQL, SQR, Tuxedo/Jolt 6.5,

Weblogic, K-Shell, Windows 2000, HP-UX

Programmer Analyst/Peoplesoft DBA Nov 2001 – Apr 2003

Client: ToysRus

• Installation of PeopleSoft 8 HRMS SP1, including Creation of the databases, Create Configure

and Start the Apache Web Server, Process Scheduler, Application Server for various domains.

• Applying patches and fixes on Time and Labor, in accordance with the guidelines of PeopleSoft.

• People Tools upgrade from 8.15 to 8.17 using Upgrade Assistant.

• Refreshing TEST, DEV (Testing & Development) instances with PROD database.

• Assist in capacity planning, develop and implement system and taking database backups and

recovery of databases

• Extensively involved in Fit/Gap analysis to develop technical tasks and estimates.

• Customized numerous Time & Labor and HR pages and processes using PeopleCode, App.

Engine and Application Messaging.

• Wrote interfaces for ToysRus and Hewitt to send the employee benefit information using SQR

• Developed Component Interface to delete profiles for the employees who are terminated.

• Tuned the Time Admin process of T&L module through management of temporary table instances and

concurrent processing.

• Worked on Post Production Issues.

• Worked on applying Application Patches using upgrade Assistant

ENVIRONMENT: People Tools 8.1x, HRMS Application 8.0 SP1, Oracle 8i, PL/SQL, SQR,

Tuxedo/Jolt 6.5, Apache web server, K-Shell, Windows 2000, Sun/Solaris

County of San Bernardino CA Sep 2000 to Oct 2001

Peoplesoft Technical Consultant

• Worked extensively with the implementation and maintenance of Peoplesoft Payroll, HR,

Benefits T&L. worked with all areas of the product from the initial design, customization of the

system.

• Created new records, new panels, menus, new SQR Reports, Interface programs, modified

existing SQR Reports, Panels, and Records based on the user requirement.

• Data conversion from legacy to PeopleSoft records (HRMS), Used Data Mover to export Data to

other platforms, used Import manager to import data

• Participated in-migrating the developed objects from the development environment to the Testing.

Also worked on the Performance issues. Created indexes and modified existing views to enhance

the performance.

ENVIRONMENT: PeopleSoft 8.1x, Oracle 8i, PL/SQL, SQR, Tuxedo/Jolt 6.5, Apache web server, K-

Shell, Windows 2000, Sun/Solaris

References provided on request

Contact this candidate