Data Peoplesoft

Geeta Kodamanchili

WORK STATUS: - GREEN CARD *****.************@*****.*** 412-***-****(M)/732-***-****(L)

Experience Summary:

** ***** ** ******* ** Experience and 15 years of PeopleSoft Development

Experience working within the HCM (HR, Payroll & Benefits) modules and GL, AP.

Excellent verbal and written communication skills.

Strong Technical design documentation skills.

Good knowledge in UNIX and Windows Environments.

Extensive Experience in Production support 24/7

Performed Techno functional role. (Gathering requirements from Vendors & Business users).

6 Upgrade projects experience.

Education: Bachelor of Science (BS) in Engineering

Technical Skills:

ERP Packages PeopleSoft 7.5/ 8.15 /8.3 /8.8 /8.9 /9.0/9.1/9.2 HCM Formerly known as HRMS (HR, NA Payroll, Benefits Administration, Base Benefits, Time & Labor, Self-Service, PeopleSoft Financials (AP, AR, GL, AM) and Student Admin.

Software/Languages C, C++, People Code, SQR, C, JAVA, SQL, PL/SQL and HTML, VB, COBOL

RDBMS (Databases) Oracle 7.x/8i/9/10, MS-SQL Server, DB2

Development /

People Tools: Application Designer, Application Engine, Data Mover, Component Interface, and PeopleSoft Update Manager.

PeopleSoft

Reporting Tools SQR, PS Query, Crystal Reports, BI Publisher

Operating System Windows NT/ 10/XP/8.1, UNIX (HP-UX)

Professional Experience

RaboBank International, New York, NY May’17 to Till Date

Sr. PeopleSoft Developer

Worked on HR Upgrade to retrofit the custom PC, SQR & AE programs.

Created BIP reports as per the Business requirement.

Converted Crystal reports to BIP reports.

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files. (Outbound).

Developed Technical design specification documents for Benefits & Payroll to GL interface.

Developed new queries using query Tool, SQR & BI publisher to generate reports.

This is UPGRADE project from 9.1 to 9.2(Application) & 8.52 to 8.56(People tools)

Environment: PeopleSoft 9.2, People Tools 8.55, Oracle 11 G, PeopleSoft HCM, FSCM

University of Delaware, Newark, DE Jul’16 to Mar’17

Sr. PeopleSoft Developer

Set up the IB requests from HR to SA systems for the location Sync and Department Sync.

Modified the Student Transcripts to generate PDF report.

Written New Application Engine program for the LAM system.

Created new SQR program for the Financial SCRUB system.

Worked on HR Upgrade to retrofit the custom PC, SQR & AE programs.

Used PeopleSoft Update Manger for applying patches.

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files. (Outbound).

Developed Technical design specification documents for Benefits & Payroll to GL interface.

Developed new queries using query Tool, SQR & BI publisher to generate reports.

According to priority of the production issues, analyzed and fixed the production issues (NA Payroll).

DTCC, Newport, NJ Jun’15 –Jun’16

Sr. PeopleSoft Techno functional Consultant

Developed new Application Engine & SQR process for Interfaces (Outbound) to convert into Oracle Fusion HCM..

Involved in writing design specifications for developing custom interfaces.

Developed CI New interfaces from Oracle HCM Fusion to PS.

Developed Interfaces HR, Benefits and salary data for Faculty using Application Engine.

Developed outbound Interfaces Deductions, Benefits files from PeopleSoft to Oracle Fusion for all department employees using Application Engine

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files. (Outbound).

Developed Technical design specification documents for HCM fusion to PS interface.

According to priority of the production issues, analyzed and fixed the production issues (NA Payroll).

Environment: PeopleSoft 9.1, People Tools 8.53, Oracle 11 G, Stat, Toad, PeopleSoft HCM and Oracle Fusion HCM.

University of California Nov’14 –May’15

Sr. PeopleSoft Technical Consultant (conversion from Legacy to PeopleSoft 9.2)

Developed Design specification for HR, Payroll and Benefits data from Legacy Data to PS system.

Developed new Application Engine & SQR process for Interfaces (Inbound).

Developed & written DMS scripts for migrating data from one environment to another.

Developed Interfaces HR and salary data into PeopleSoft using SQR’s and Application Engine.

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files. (Outbound).

Developed new queries using query Tool, SQR & BI publisher to generate reports.

Developed App Engine Programs for Time & Labor and Absence Management.

According to priority of the issues during the SIT, analyzed and fixed the issues.

Developed custom people code for the Personal data changes to notify & send through Integration Broker to the HR.

Environment: PeopleSoft 9.2, People Tools 8.53, Oracle 11 G, Stat, Toad, PeopleSoft HCM

Philly Insurance (TMNAS), Bala Cynwyd, PA Jun’14 –Oct’14

Sr. PeopleSoft Technical Consultant (Production Support & Enhancements PeopleSoft 9.1)

Developed Design specification for HR, Payroll and Benefits data for new interfaces & Reports

Developed new Application Engine & SQR process for Interfaces (Inbound & Outbound).

Developed & written DMS scripts for migrating data from one environment to another.

Involved in writing design specifications, Technical documents for custom interfaces & reports.

Involved in unit testing, documentation & end-user training.

Created Database Audit tables for HR, Payroll and benefits tables.

Worked on position data to create job requisition.

Created new custom pages & people code as per the client business requirement.

Developed new queries using query Tool, SQR & XML publisher to generate reports.

Involved in Production support, Trouble shooting, coding & testing.

According to priority of the production issues, analyzed and fixed the production issues (NA Payroll).

Environment: PeopleSoft 9.1, People Tools 8.52, Oracle 11 G, Stat, Toad, PeopleSoft HCM, Remedy

Nassau County, Mineola, NY Jan’13 – May’14

Sr. PeopleSoft Technical Consultant (conversion from Legacy to PeopleSoft 9.1 & upgrade to 9.2)

Developed Design specification for HR, Payroll and Benefits data from Legacy Data to PS system.

Developed new Application Engine & SQR process for Interfaces (Inbound).

Developed & written DMS scripts for migrating data from one environment to another.

Involved in writing design specifications for developing custom interfaces.

Developed Interfaces HR and salary data into PeopleSoft using SQR’s and Application Engine.

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files.(Outbound)..

Developed new queries using query Tool, SQR & XML publisher to generate reports.

Environment: PeopleSoft 9.1/9.2, People Tools 8.52/8.53, Oracle 11 G, Stat, Toad, PeopleSoft HCM

North Shore LIJH, Long Island May’12-Nov’12

Sr. PeopleSoft Technical Consultant (conversion from Legacy to People soft 9.1 and upgrade from 8.9 to 9.1)

Developed Design specification for all HR, JOB, Personal, Payroll and Benefits data from Huntington Hospitals Legacy data to LIJH PS system.

Developed new Application Engine & SQR process for Interfaces (Inbound).

Developed & written DMS scripts for migrating data from one environment to another.

Involved in writing design specifications for developing custom interfaces.

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files.( Outbound).

Written SQR’s from scratch to generate Reports in PDF format.

Developed new queries using query Tool to generate reports.

Environment: PeopleSoft 9.1, People Tools 8.51, Oracle 10 G, Stat, Toad, PeopleSoft HCM

Canon, Long Island Jul11-Apr’12

Sr. PeopleSoft Technical Consultant (conversion from ADP to PeopleSoft 8.9 & Upgrade from 8.9 to9.1)

Developed Design specification for Payroll data from ADP to Canon PS system.

Developed new Application Engine & SQR process for Interfaces (Inbound).

Developed & written DMS scripts for migrating data from one environment to another.

Involved in writing design specifications for developing custom interfaces.

Involved in writing Interfaces (Inbound &Outbound) using SQR’s for HR, Benefits, Payroll and Sales.

Developed Interfaces HR and salary data into PeopleSoft using SQR’s and Application Engine.

Involved in unit testing, documentation & end-user training.

Developed new Application Engine & SQR process for Interfaces for benefits vendor files.( Outbound).

Written SQR’s from scratch to generate Reports in PDF format.

Developed new queries using query Tool to generate reports.

Environment: PeopleSoft 8.9/9.1, People Tools 8.47/8.52, Oracle 10 G, Stat, Toad, PeopleSoft HCM

UPMC, PITTSBURGH, PA Jan’11-Jun’11

Sr. PeopleSoft Technical Consultant (UPGRADE from 8.9 to 9.1)

Involved in identifying table differences from 8.9 to 9.1

Modified SQR program and online pages according to new Version Changes as per the business requirement.

Developed new Application Engine & SQR process for Interfaces (Inbound & Outbound).

Involved in writing design specifications for developing custom interfaces.

Involved in unit testing, documentation & end-user training.

Developed new custom pages for self service( Employee applications& Manager Applications)ePay,eProfile,ePerformance,ePay and TAM &Candidate Gate way(Erecruit Applications) .

Created Roles & Permission lists for new users using PeopleSoft HR security.

Created New Data Archive tables for custom data transaction tables.

According to priority of the production issues, analyzed and fixed the production issues (NA Payroll).

Environment: PeopleSoft 9.1 & PeopleSoft 8.9, People Tools 8.5 & 8.47, Oracle 10 G, Stat, Toad, PeopleSoft HCM

TD Bank, Cherry hill, NJ Jan’10-Nov’10

Sr. PeopleSoft Technical Consultant (UPGRADE from 8.8 to 9.0)

Involved in identifying table differences from 8.8 to 9.0

Involved in Fit-Gap Analysis for 8.8 vs. 9.0

Modified SQR program and online pages according to new Version Changes as per the business requirement.

Developed new Application Engine & SQR process for Interfaces (Inbound & Outbound).

Involved in writing design specifications for developing custom interfaces.

Involved in unit testing, documentation & end-user training

Environment: PeopleSoft 9.0 & PeopleSoft 8.8, People Tools 8.5 & 8.45, Oracle 10 G, Stat, Ultra Edit, Toad, PeopleSoft HCM, PeopleSoft Financials, Student Administration.

Eisai Pharma, Wood Cliff Lake, NJ Jun’08-Nov’09

Sr. PeopleSoft HRMS Technical Consultant

Involved in writing new benefit programs for new company (MGI) employees from scratch.

Developed all pages, menus, and department and user security reports. Also modified the department security Tree.

Involved in setting up of the HR security by creating new roles and permission lists.

Developed and modified all benefits (life plans) pages and self service for MGI company people.

Developed new Interface program for sales people Incentive compensation with all business rules.

Involved in writing Interfaces (Inbound &Outbound) using SQR’s for HR, Benefits, Payroll and Sales.

Involved in unit testing, documentation & end-user training

Worked with users & business analyst to fix the production issues.

Worked with performance modifications as per client requirement.

According to priority of the production issues, analyzed & fixed the production issues.

Involved in unit testing and integration testing according to business requirement.

Involved in System (Production) Support. Run the DMS scripts for the migration.

Involved in writing design specifications for developing custom interfaces.

Environment: PeopleSoft HRMS/HCM8.9 production support & Enhancements (payroll, Benefits, HR)

Peopletools8.47, Oracle 10, UNIX, SQR5.3, Toad, ultra edit, windows XP, Lotus notes, STAT

Cablevision, MSG, New York Jan’07-May’08

Sr. PeopleSoft HRMS Technical Consultant

Involved in writing Interfaces (Inbound &Outbound) using SQR’s for HR, Benefits, Payroll, Work Brain (Time & Labor to PS) and Payroll to GL.

Interact with business analysts & end users to gather requirements to write the technical design specifications.

Involved in portal Registry using component Registry for web based application according to PeopleSoft portal node standards to meet client business requirements for portal, 3-tier (web browser) used web logic server

Involved in unit testing, documentation & end-user training

Worked with users & business analyst to fix the production issues.

Modified SQR program and online pages according to new business process.

According to priority of the production issues, analyzed and fixed the production issues.

Involved in unit testing and integration testing according to business requirement.

Involved in System (Production) Support. Run the DMS scripts for the migration.

Involved in writing design specifications for developing custom interfaces.

Involved in setting up of the HR security by creating new roles and permission lists.

Developed Interface program to load the requisition data into PeopleSoft tables.

Involved in implementing eRecruit with resume processing to track and recruit various applicants online.

Upgraded the PeopleSoft system from 8.9v to 9.0versions with applicable changes and Updates.

Worked with ePerformance modifications as per requirement.

Environment: PeopleSoft HRMS/HCM8.9/9 production support & Enhancements (payroll, Benefits, HR, GL)

Peopletools8.46, DB2, UNIX, SQR5.3, Toad, ultra edit, windows XP, Remedy 6

Saint-Gobain, Valley Forge, PA Aug’05- Dec’06

Sr. PeopleSoft Technical Consultant

Interact with business analyst & end users to gather requirements to write the technical design specifications

Involved in technical design for various conversions Interfaces and Reports.

Developed various data conversion SQR’s from legacy systems (JD Edwards) to PeopleSoft

Involved in portal Registry using component Registry for web based application according to PeopleSoft portal node standards to meet client business requirements

Involved in writing Interfaces (Inbound &Outbound) using SQR’s & Application Engine for HR, Benefits, Payroll, AP and GL.

Involved In writing custom people code as per the client business requirements

Developed new Application Engine programs and also customized existing Application Engine programs.

Used Test Director 8.2 to post issues. Used Quest Stat for Migrations.

Involved in unit testing, system and parallel testing. Documentation & End-user training

Involved in writing DMS scripts to copy the Record structures into the seed database during database creation.

Involved in Performance tuning of various SQR’s and Queries that were taking too longer to run.

Involved in setting up of the security by creating new roles and permission lists.

Involved in system production support.

Designed & developed GL, AR and AP interface from JDE system to PeopleSoft feed to SAP financial system.

Environment: PeopleSoft HCM8.9 (payroll, Benefits, HR, GL, AP) Peopletools8.46, Oracle 9, Toad, STAT

Ford Motor Company, MI Oct’04-Jun’05

Sr. PeopleSoft Technical Consultant

Involved in technical design for various conversions.

This project was implementation of new modules & Upgrade.

Developed various data conversion SQR’s from legacy systems to PeopleSoft.

Developed Component Interface for salary changes.

Interact with business analyst & end users to gather requirements to write the technical design specifications.

Involved in unit testing, system and parallel testing. Documentation & End-user training

Developed & modified various online pages according to business requirement.

Worked extensively on online customizations for Employee self-services & Manager self-service and eBenefits as per the End User Requirement and Business need.

Environment: PeopleSoft /HCM8.8 (payroll, Self service, Benefits, HR) Peopletools8.44, Oracle 9, UNIX, Toad, STAT

Bank One, Columbus, OH Jan’03 to Aug’04

Sr. PeopleSoft HRMS Technical Consultant

Involved in the customization and Upgrade of the PeopleSoft 7.02 HRMS (HR, Payroll and Benefits Administration) Modules to 8.3 Version based on Organizational needs and requirements. Performed interfacing, conversions, data migration and report writing (using People Code, People Tools and SQR). Primarily involved in Report Customizations using SQR and Crystal reports conversions to version 8.3

Involved in applying on-line customizations to HR, Payroll and Self Service modules of PeopleSoft HRMS v8.3. Also responsible for developing SQR interface programs and Application Engine programs that are of high degree complexity.

Extensively applied People code validations. Developed generic People code function library programs for various tasks, for example, implementing field level security based on end user roles.

Designed & developed Technical documents for various reports &Interfaces.

Environment: PeopleSoft HRMS 8.0/7. 0.2, People Tools, People Code, SQR 5.3.2, SQL, UNIX, and Oracle 8.0

Alcoa, Pittsburgh, PA April’2000 to Nov’2002

PeopleSoft Developer

Technical/functional analysis, documentation, requirements gathering, design, and development of PeopleSoft Payroll Reports.

Developing and coding of new SQR's for running Interface programs after Merges and Exporting data from database to the other.

Gathering requirements from the End User, analyzing the process flow, creating and modifying Reports, coding new SQR programs as per the requirement.

Identifying Fields and Tables that were changed from Ver 7.5 to Ver 8.0 and making necessary changes to the Client's Customized SQR’s in order to perform in PeopleSoft 8.0 Environment.

Import and export of the database using the Data Mover.

Involved in solving problems related to Benefits, HR, Payroll and GL-Interface etc.

Regularly interacted with the end-users and work according to the modifications required by them.

Developed Various Reports using SQR for various Reporting requirements.

Environment: PeopleSoft HRMS 7.0/7.5/ 8.0, People Tools, People Code, SQR 4.0, SQL, Windows NT, Oracle 8.0

Contact this candidate