SWETHA RANI SUMMARY: Over 8 years of experience in IT. Over 6 Years of experience in PeopleSoft Analysis, Implementation, Upgrade, Production Support, Data Conversion, Interfacing/Reporting and Troubleshooting experience. Possesses strong technical knowledge of Enterprise Resource Planning management skills. Extensive experience in Information Systems encompassing strategic planning, analysis, design, development and enhancement of client/server based applications with 3-Tier Architecture and Web based applications. Experienced on PeopleSoft Internet Architecture PIA - PeopleSoft 8.0/ 8.3/8.8/8.9/9.0. Strong PeopleSoft analytical experience in HRMS 9.0/8.9/8.8/8.3/8.0/7.5 HR, Base Benefits, Ben/Admin, Payroll, payroll Interface, Time and labor, employee self-service modules eRecruit, eBenefits, eProfile, ePerformance, eCompensation and ePay and Manager self-service modules. Specialized in designing and developing online customizations, interfaces, and reports for PeopleSoft HRMS. Developed and debugged several SQR Reports and have extensive experience in Ad-Hoc reporting by piping data from PS-Query to both Crystal Reports and Excel. Involved in Workflow, Debugging, Troubleshooting and Testing of SQRs, Setting up Security and PeopleSoft Applications. Developed application interfaces, batch and reporting programs using SQR. Expertise in User interface, specification development and troubleshooting. Worked extensively in setting up Security Setups in HRMS. Customizing and developing new Interfaces for HR, BENEFIT AND PAYROLL applications. Experience in developing Interfaces with 3rd Party application integration with PeopleSoft applications. Specialized in Data extraction interfaces and Conversion from legacy to PeopleSoft applications. Proficient in the use of PS/nVision, SQR, Crystal Reports, Application Designer, Data Mover, Import Manager, Maintain Security/Security Administrator, Query/Crystal, Application Engine, PeopleCode, MassChange, Workflow and Database agent, and Message agent. Experience in Databases such as SQL Server, Oracle, SQL Base, MS-Access and DB2. Excellent in Production Support, Documentation, End-Users Training and Knowledge transfer. Excellent Interpersonal skills, has clear understanding of business procedures and ability to work as an individual and also part of the team. Possess superior skills of problem analysis with exceptional ability to follow project. Standards and procedures, quickly master new concepts and applications.

Technical Skills Enterprise Software : PeopleSoft HRMS 9.0/8.9/8.8/8.3/8.0/7.5

Reporting Tools : SQR, Crystal Reports, PS/nVision GUI : Visual Basic5.0, Developer2000

Operating Systems : Windows 2003/XP/2000/98/95, Windows NT 4.0 and UNIX

Programming Languages : PeopleCode, C, COBOL, SQL, PL/SQL, ASP

Databases : Oracle 10g/9i/8/7.x, DB2, MS-SQL Server

Professional

Experience

Confidential

PeopleSoft Techno

Environment: PeopleSoft HRMS 9.0 HCM HR, Benefits, Ben Admin, Employee Self-Service, Global Payroll , SQL Query Analyzer, PeopleTools 8.49, PeopleCode, App Engine, Component Interface, SQR, Security, SQL Server 2005, Windows 2003.

Responsibilities: Extensively used People Tools, Peoplecode, Application Designer and Application Engine to develop various inbound/outbound interfaces. Developed detailed functional and technical specifications using knowledge of PeopleSoft data model. Worked with Application Reviewer, People Code trace in AE and SQR trace for debugging and tracing errors. Worked with functional counterparts to design and develop complex configurations, customizations, and system integration for the self-service portal. Played key role in Development of Interfaces, Online Customizations and Conversions using SQRs, People Code and Application Engine for PeopleSoft HR, Benefits modules. Involved in Setup of Eligibility rules and Plans in Benefits Administration. Developed custom look-up tables and edits for medical providers in Benefits Open Enrollment. Resolved critical employee benefits rate calculation problem for all plan types. Modified and maintained Base Benefits and Benefits Administration control table. Developed Hartford interfaces, which, reads an inbound file from Hartford and updates custom benefits tables. It also generates output file with the required fields as a filelayout. Worked with end users to help resolve production support issues and current design issues in Payroll. Developed a customization to manage Hires event and the Job component to automatically enroll / un-enroll employees in Benefits Plans based on Job data activity and stored SQL. Troubleshooting the problem areas in interfaces with Benefits programs, enrolling employees into Benefit plan, calculating deductions and in producing Benefits reports. Modified and written several Benefits Admin SQRs for reporting purpose. Involved in Customization of employee self-service modules such as eRecruit, ePay, eBenefits, eProfile, eCompensation. Responsible for issue and problem monitoring. This includes documenting issues and problems, coordinating the resolution process, and documenting the resolution. Developed a Benefits process which automatically generates run controls and schedules the Calculate Periodic Accrual process for all eligible Plan Types and Benefit Plans. This saves the users from having to manually run the process dozens or even hundreds of times. Did unit testing and was involved in user acceptance testing. Customized many of the Benefits Open Enrollment pages and Benefits Summary pages. Created an SQR extract that retrieves the employees information from 12 different tables using case statements and outer joins. Documented the design and business process development so that it may be maintained and enhanced in the future. Participated in internal meetings to better understand requirements and challenges. Ability to work under stress with time-critical deadlines and expectations. Confidential

PeopleSoft Techno-functional

Consultant

Environment: PeopleSoft HRMS 8.9/8.3 HRMS/HCM HR, Payroll, Benefits, Ben Admin and T L , TOAD, PeopleTools 8.47, PeopleCode, Application Messaging, App Engine, Component Interface, SQR, Data Mover, Security, Oracle 10g, UNIX, Windows 2003.

Responsibilities: Worked as Sr. PeopleSoft Analyst for PeopleSoft HRMS Implementation and HRMS 8.3 to 8.9 Upgrade. Designed and Created Application Engine programs, Component Interfaces in PeopleTools to enable Java based intranet applications to integrate with PeopleSoft. Worked on a number of SQRs pertaining to Benefit Administration, annual enrollment process and other interfaces such as Omni TDA deductions, Ceridian benefits deductions, Colonial life insurance, monthly eligibility override report and also reports pertaining to compensation, payroll, by constantly interacting with the functional specialists and end users. Designed and developed payroll interfaces from internal union payroll system to PeopleSoft Payroll module by creating new rows in payroll tables both for the hourly and salaried . Developed an interface to generate flat files which have data of new hires and changes to certain HR/Payroll data and to generate flat files to be sent for third party vendors. Designed functional, technical documents and developed SQR interfaces for new employee security. Analyzed the Compare reports and retrofit the Customizations in applying the tax updates. Involved in setting up the Integration Broker for interfacing between Legacy and Peoplesoft. Responsible for Crontab maintenance. Daily job run changes/batch process scheduling changes. Involved in year end processing. Resolved many Employee Manager Self service critical issues related to online checks view and security. Modified reports using Crystal Reports and Ps-Query. Involved in modification of the PeopleCode so as to accomplish business rules. Loaded data from the flat files to various tables in PeopleSoft database using Import Manager and SQR. Fixed the errors in the data and rules by running the Pre-Sheet Audit report. Involved in writing SQRs to convert the legacy data into PeopleSoft Core tables and was involved in testing of these SQRs and the data that was converted into the PeopleSoft tables. Worked extensively with debugging issues SQR, App. Engine and resolved so many critical tickets. Confidential

PeopleSoft Techno-functional

Consultant

Environment: PeopleSoft 8.8/8.9 HRMS/HCM HR, Payroll, Benefits, Ben Admin, eApps, and T L , PeopleTools8.47, SQR, PS Query, PeopleCode, App-Engine, TOAD, Oracle9i, Windows 2000, UNIX.

Responsibilities: Involved in the Analysis, Implementation and Support of PS HRMS 8.8/8.9. Developed data conversion programs using SQR for HR, Payroll, Benefits and T L. Implemented eApps modules, designed lot of online customizations, designed pages for the organizational needs. Developed an SQR process for loading pay sheets with one time Deductions and One time Pay. Involved in customization and development of PeopleSoft applications using various PeopleTools such as Application designer, PeopleCode, maintain security. Involved in setting up the core tables for HR module and Benefits module. Was involved in gathering user requirements for the interface and the reports developed. Developed reports for HR, Payroll and Benefits. Developed SQR Interface from ADP Payroll to General Ledger Created Intermediate tables to store ADP Payroll Values in Peoplesoft. Created run control record and run control page to run the SQR. Modified Peoplecode, Pages and Components to enhance the functionality as per client requirement. Created Record definitions, Page definition, Components, Run control panels, attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler. Created process definitions to all conversion and SQR programs. Played a major role in applying the Tax updates/Patches/Bundles. Involved in running compare reports for tax updates. Analyzed the compare reports and retrofit the customizations. Involved in cleaning up the copy of production based on the DDDAudit and SYSAudit reports. Worked on PS Pay Calender, PS Pay Check, PS Job, PS Personal Data tables and Generated reports by PayGroup, RunId in Payroll Module. Involved in troubleshooting and fixing bugs and problems in the implementation of HR. Prepared development documentation and migration documents for the object migration. Preparation of Functional Test Plan and writing actual test cases. Extensively executed SQL on DB2 tables to determine successful transaction of data from the application. Involved in Year End Processing Team. Involved in Documentation, Production Support and User Training. Confidential

PeopleSoft Technical

Consultant

Project involves bringing FedEx Freight HRMS into Peoplesoft 8.9. Responsibilities include converting the interface programs written in COBOL into SQR and Application engine programs.

Environment: PeopleSoft 8.9/8.3 HR, Global Payroll, SalaryPlan, Benefits, Manager self-service modules , PeopleTools8.45/8.47, SQR, Crystal Reports, Application Engine, Application Designer, Upgrade Assistant, Cobol, PeopleCode, PeopleSoft Security, SQL Server 2K, UNIX, Windows NT.

Responsibilities: Involved in upgrade of the application from PeopleSoft 8.3 to PeopleSoft 8.9. Extensively used People Tools, Peoplecode, SQR, Application Designer and Application Engine to develop various inbound/outbound interfaces and reports. Created various PeopleSoft pages, components and menus to run on-demands job related to various Payroll and HRMS processes. Applied different PeopleSoft patches to update already delivered processes from PeopleSoft. Created outbound interface for Employee Stock Purchase Plan, which generates multiple outbound extracts, loaded with employees information from Employees PAY CHECK, and PAY DEDUCTIONS. Created FTP scripts to send these files to external vendor ComputerShare for processing. Created Bureau of Labor Statistics Report for Hourly Employees report using SQR. This report consists of hourly employees location, hours, wages, gender data from various PAY EARNINGS, PAY OTH EARNS tables, and sent to Bureau of Labor. Developed Cigna Outbound interface, which creates a fixed-length, flat record of an employees health benefit record as header with his/her dependents as detail for employees who participate in health benefit medical, dental and/or vision of Cigna. Developed an Application Engine program to create Direct Deposit transmission files for three operating companies simultaneously. Created a Positive Pay application in SQR to be a part Pay Final in Payroll run. This application performs the extraction of Positive Pay file from PAY CHECK, PAY CALENDAR and PAY DISTRIBUTN tables and then FTPs to Bank of America BOA . And later retrieves Acknowledgement from BOA. Developed Bank Reconciliation Inbound interface, which is used to reconcile the checks that have cleared through Bank of America. The main processes are to retrieve cleared check data sent by Bank of America, to format the bank data to fit into reconciliation program, to read and update the PS bank account related tables, and to generate error listing and various bank reconciliation reports. Developed Merrill Lynch Outbound interface, which, processes 401k deductions and creates files to be sent to Merrill lynch for administration. It also reports out contribution and deduction details. Developed Merrill Lynch Inbound interface, which, reads an inbound file from Merrill Lynch and updates both savings plan and general deduction tables. It also reports out 401K plan changes and inbound data statistics. Created an Audit report in SQR that reports the changes made for any employees tracked by Audit tables for core tables like JOB, PERSONAL DATA, EMPLOYMENT, BENEFIT PARTIC etc. Developed an outbound interface for generating Flexible Spending Account FSA deductions for the current pay period. Data conversion and Writing interfaces in the Benefits and Payroll modules. Involved in tracing and fixing the problems for Benefits and Payroll interfaces. Worked with functional team and testing team in System Test, User Acceptance Test and Parallel Test for Payroll. Confidential

PeopleSoft Application Analyst/Developer

Environment: PeopleSoft HRMS 8.3/8.8 HR, T L, Payroll, Base Benefits , self-services eRecruit, ePay, eCompensation, eBenefits People Tools8.19/8.20/8.42/8.43, Quest Stat, OS/390, and DB2

Responsibilities: Involved in upgrade of the application from PeopleSoft 8.3 to PeopleSoft 8.8 Performed Vanilla compare between production copy databases to demo database to identify all customizations to be carry forward with upgrade. Involved in resolving the upgrade issues from PeopleSoft v8.3 to v8.8 Involved in upgradation and customization of SQRs in HR, Benefit Payroll modules. Involved in discussion and participative resolution of issues arisen during running upgrade scripts, Planned and implemented fixes for issues and bugs with delivered scripts. Designed Developed several SQR Reports like Employees Summary, absence history, department salaries, salary plans, and deductions, participants in Benefit Programs, Data Report, Salary Change Report, Salary Mass Updates and also developed several Adhoc reports. Tested attendance rules based on long lunches, early outs and long breaks. Worked on eTime reports like Time Reporting Home Page, Weekly Time Entry, view Work Schedule for Employees. Used application reviewer to debug PeopleCode and fix errors. Developed various SQR Conversion Programs, Interfaces, Inbound and Outbound to convert data from existing databases, Flat files DAT files, ASCII files and Excel spreadsheets into the PeopleSoft system. Design and coding of Benefit related interfaces for 401K, VISION, DENTAL, AETNA and Bank interfaces. Used PeopleSoft browser-based Report Manager in Scheduling Processes using Process Scheduler viewed the reports using report log viewer and delivered reports to the personalized workforce portals. Developed Run control pages as per corporate requirements and attached to menu to run the SQRs On-line. I was involved in eRecruit for Post job descriptions and requirements online and keep all parties informed of application status and interviews. Extensively used Quest Stat for version controlling people soft objects like SQL, SQR, PS/nVision etc. Responsible for testing of various transactions and fixing of various issues and bugs at different stages of upgrade process. Production Support Was involved in issue solving day-to-day production issues and checking the process. Created SQR programs for the AMB Process. Annual Merit and Bonus Worked with Process Scheduler, Maintain Security, Ps Query, Process Scheduler, Process Monitor and Report Manager Tools in the Process of Development and Trouble Shooting. Worked with Maintain Security to define security at various levels. Created the Database maintenance scripts. Running the Cross-Reference and Audit Reports from time to time. Was involved in Addition/ Modification of PeopleCode/Objects for Objects for Issue Solving. Confidential

PeopleSoft ERP Application Analyst/Developer

Environment: PeopleSoft7.5/8.3 HR, Global Payroll, T L, Salary Plan, Benefits self-service modules eRecruit, eBenefits, eCompensation, ePay, eProfile , Manager self-service modules, PeopleTools8.19/8.20, SQR, Application Engine, Application Designer, Upgrade Assistant, PeopleCode, PeopleSoft Security, SQL Server, Windows NT.

Responsibilities: Responsible for PeopleSoft 8.3 upgrades / conversions. Involved in SalaryPlan module for setting and administrating the Salary plans, grades, and steps. Played key role in Development of Interfaces, Online Customizations using SQRs, People Code, Component Interfaces and Application Engine for PeopleSoft HR, Benefits and Payroll modules Developed new pages, components, menus and other PeopleSoft objects as per requirement. Involved in administering and developing workforce for hiring process, updating workforce information, defining employee categories, and entering additional data of employee. Create specifications for the Data Extract. Divided the Extraction Process into 4 major steps: Employee Related Extract, Benefit Extract, Elements Extract Earnings and Deduction Codes and information and Balance Data YTD, QTD, MTD . Maintained log files, test result and technical documentation of the work done and upgrade information. Enhanced PeopleCode for incorporating Version Changes. Wrote SQR program to extract the information of Employee Personal, Job, Address, Payment, Salary, w2 and W4 information. Used Fixed Period, Rolling Period and Step Period to track attendance. Created reports so that employees can view schedule on-line. Wrote Shell Scripts to run the Batch programs. Wrote interfaces to extract the Deduction, Garnishment, and Tax data. Involved in enabling applicants to create, review, and update resumes online. Validated and edited the legacy data and mapped the legacy files data with PeopleSoft records fields using SQRs. Involved in moving the objects between databases using Application Upgrader. Submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval. Involved in Creation of Integration Testing Plans and Test Data. Allow internal applicants to view information about job openings and collect interview results online. Worked on PeopleSoft Single-Sign on Portal. Participated in modification of the PeopleCode so as to accomplish business rules.