SUMMARY

• Over 8 years of experience in Implementation, Customization, Upgrade and Development of PeopleSoft HRMS applications
• Extensive experience in Implementation, Customization, Upgrade, Maintenance and Production Support of PeopleSoft HRMS applications with Modules such as HR, Payroll, Benefits, Benefits Administration, Time and Labor, Absence Management, ESS and MSS.
• Very strong SQR coding skills and experience modifying complex existing SQRs. Developed many SQRs including Complicated Interfaces and Conversion reports using important SQR methods like Break Logic, Load - Lookup, Arrays and Multiple reports.
• Extensively worked on People Tools such as Application Designer, People Code, Application Engine, Maintain Security, Query and File Layout, Process scheduler, Data Mover, Component Interface, Integration Broker, Application Messaging, XML Publisher and Reporting tools (SQR and Crystal Reports).
• Expert report writing skills using SQR, Crystal Reports, nVision and PS QUERY.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization and new development.
• Extensively involved in implementation of collaborative applications (self services areas) eRecruit, eBenefits, eDevelopment, eProfile, eCompensation, ePay and ePerformance.
• Extensive experience in transferring existing data from legacy system to PeopleSoft application database tables using SQR, Application Engine, People Code, File layout and Component Interface.
• Used STAT extensively for object migrations.
• Significant PeopleSoft implementation experience from project conception through roll-out which includes fit gap analysis, development, major customization, testing, and .
• Excellent End User Facing capabilities, Explain & Present the products and project estimations, budgets required for the projects & their alternate solutions.
• In-Depth understanding of PeopleSoft Internet Architecture (PIA), Data models and client server applications on Windows and UNIX platforms.
• Tested PeopleSoft Applications by creating Test plans and test cases.
• Very good exposure to Testing Tools (Mercury and Rational).
• Experience in Unit, Integration, Interface, Functional, Regression, Acceptance, Load and System Testing using Black Box and White Box methods.

TECHNICAL SKILLS

PeopleSoft: Application HCM/HRMS 9.1/9.0/ 8.8/8.4 SP1/8/ 7.5 (Payroll, Base Benefits, BenefitsAdministration, Benefits, eRecruit, Time and Labor, Pension Administration,Upgrade, Global Payroll)

People Tools: 8.51/8.50/8.49/8.47/8.45/8.44/8.43/8.41/8.20/ 8.17/7. x (Application DesignerApplication Engine, Maintain Security, Query, Process scheduler, WorkflowAdministrator)

Reporting Tools: SQR, PS Query, Crystal Reports, nVision, Business Objects

Operating systems: Windows-95/98/NT/2000/XP, MS-DOS, UNIX

Languages: People Code, C, C++, Java, SQL-PL/SQL, HTML, XML, VB Script, Java Script,COBOL.

Web Servers: Web Logic 5.1/6.1/8.1, IIS 6.0, MQ series, SOAP.

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

Data Management: Data Mover, Import Manager

Integration Tools: Component Interface, File Layout, Integration Broker

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 9.1 and People tools 8.51
• Extensively worked on lot of Interfaces (In & Out bound) and Reports for converting data from AS400 system to PeopleSoft.
• Responsible of the design, development and testing of all HR, Payroll, Benefits and Ben Administration.
• Customized and implemented PeopleSoft HRMS modules
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Extensively involved in performing customizations to the HR application by creating new fields, pages and components.
• Used File Layout Definition tool to get data from the legacy system.
• Developed custom PeopleSoft on-line organizational, instructor and facility calendar panels for assigning courses and retrieving non- days.
• Worked on setup of SetID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System Generated SQR reports to create summary reports on payroll details check and validate the data.
• Maintaining PeopleSoft user security using PeopleSoft Security Administrator and Operator Ps.
• Including on boarding of new employees for one-time cutover as well as ongoing processes.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Executed unit test plans for medium complexity batch interface programs for eRecruit and Self Service Modules.
• Worked on customization of PeopleSoft process using People Code.
• Submit absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enable plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise eBenefits Self-Service Estimate Pension function.
• Involved in PeopleSoft Enterprise HCM solutions to integrate pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.

ENVIRONMENT: PeopleSoft HCM 9.1, People Tools 8.51, PL/SQL, UNIX, Weblogic6.1, MQ series, Kronos, COBOL, TOAD, Crystal Reports.

Confidential, San Antonio, TX

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the production & support and upgrade of the PeopleSoft HCM 8.9 TO 9.1 (HR, Benefits and Benefits Administration, Payroll) modules based on organizational needs and requirements.
• Set up the open enrollment system for the new employees. Prepared the election analysis reports for the Open Enrollment Process.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Played key role in retrofitting of Interfaces, Online Customizations using Sqr’s, People Code and Application Engine programs.
• Improved system productivity and processing execution time of Open Enrollment.
• Interaction with end-users to define system setup, improve benefits system processing and data requirements for Benefits and Open Enrollment.
• Provided Gap and Business Analysis to identify modifications and business requirements, functional and technical programming for HRMS, Benefits Administration, Payroll, Employee Self-Service, Workflow, eBenefits modules which consisted of design documentation, table structure setup and modification of workflow process for daily event processing and Open Enrollment functionality.
• Implemented complex technical and system design specifications for benefits, eBenefits and Self-Service. Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
• Managed daily HRMS which consisted of multiple jobs and benefit event maintenance and implementation of yearly Open Enrollment, which consisted of employee choice options and selective Benefit elections of non-choice active and retired employees.
• Daily maintenance of open events and the benefits process error log.
• Provided functional and technical support for Benefits Billing and Cobra. Performed functional and technical one-on-one EUT for HRMS and Benefits Administration.
• Development of functional and technical step-by - step documentation.

ENVIRONMENT: PeopleSoft HCM 9.1, People Tools 8.51, PL/SQL, UNIX, Weblogic6.1, MQ series, Kronos, COBOL, TOAD, Crystal Reports.

Confidential, Westwood, MA

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the production & support and upgrade of the PeopleSoft HCM 9.1 (HR, Benefits and Benefits Administration, Payroll and Time & Labor) modules based on organizational needs and requirements.
• Performed the Fit - Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Extensively worked on Tax Updates in functional implementation parts and involved in year end tasks particularly by applying payroll tax updates for running the payroll as expected.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Applied regular tax updates, patches & bundles to all relevant instances applied the Bundles, patches Tax Updates 10-A, B, C, D, E, F and resolved issues related to year-end processing.
• Worked on NA Payroll Year-End Processing and generating W-2’s.
• Responsible for setting up eRecruit, Talent Acquisition, Candidate Gateway for recruiting process.
• Designed screens for the Talent Acquisition, Candidate Gateway, eRecruit for End Users.
• Identified all the Business Process, Desktop reports and evaluated the required Business processes reports in Core HR, eRecruit, Talent Acquisition, Candidate Gateway.
• Developed several inbound & outbound interfaces to transmit the benefits related data to the vendors.
• As part of PeopleSoft upgrade Fine expertise on Change Assistance (Upgrade Assistance), Quest Stat and data migration.
• Involved in upgrade Assistant to prepare Upgrade for comparison Reports, Upgrade Statistics for Oracle to run the Benefit Reports and configured options to run unattended processes for error notification by Email.
• Responsible for implementing Position Data Pages in MSS by creating departmental budgets, Defined budget period calendars and source transactions.
• Modified the Absence Approval page in Manager self service in order to update or delete the approved absence.
• Involved in Setting up the Absence Data and Developed Report for Employee Absence and Track Vacations.

Environment: PeopleSoft HCM 9.1, People Tools 8.50, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and UNIX, Weblogic6.1, Kronos, COBOL, Oracle 10g, SQL*plus, SQL Tools, TOAD, Crystal Reports.

Confidential, San Diego, CA

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the upgrade of the PeopleSoft HCM 9.0 (HR, Benefits and Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Participated in setting up of Department, Location, Job codes, Pay groups, Health, disability and FSA.
• Involved in the business process meetings along with Functional Team lead to identify the customizations.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Experienced in the design and development of the Workflow. This tool was primarily used to develop Work lists, Events and Routings for various businesses needs.
• Developing test Strategy, test Plan, requirements traceability matrix, use cases, test scripts for system and regression testing of HR and Manager Self Service applications using Quality Center.
• Developed several outbound interfaces to transmit the benefits related data to the vendors.
• Worked on PeopleSoft Integration Broker to develop and administer messaging integrations. These processes include configuring messaging systems and managing integration gateways. They also include defining message channels, messages, nodes, transactions, relationships, and transaction modifiers.
• Created Absence Run Types and wrote rules on Absence takes, customized the T&L Self service modules by managing absences and customized the delegation in absence management.
• Involved in setting up of Payee overrides of an absence element.
• Responsible in writing XML Publisher reports using Bursting logic in T&L & Absence Mgmt module.
• Fixed Issues related to Manager Self-Service (MSS) for Job Opening Approvals, Absence Approvals, Student Admin
• Modified search records to implement row level security.

Environment: PeopleSoft HCM 9.0, People Tools 8.50, Oracle10g, Windows-NT/2000/XP and UNIX, Kronos, SQL*plus, SQL Tools, TOAD, Crystal Reports.

Confidential, Irving, TX

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the consolidation of the PeopleSoft HCM 8.9 (HR, Benefits and Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Played key role in development of Interfaces, Online Customizations using SQRs, People Code and Application Engine programs.
• Developed new Conversion SQR programs for flat file creation by mapping the fields between legacy (EIS and Tessaract) and PeopleSoft systems.
• Set up the open enrollment system for the new employees. Prepared the election analysis reports for the Open Enrollment Process.
• Developing test Strategy, test Plan, requirements traceability matrix, use cases, test scripts for system and regression testing of HR and Manager Self Service applications using Quality Center.
• Worked on PeopleSoft Integration Broker to develop and administer messaging integrations. These processes include configuring messaging systems and managing integration gateways. They also include defining message channels, messages, nodes, transactions, relationships, and transaction modifiers.
• Modified search records to implement row level security.
• Developed programs for employee general deduction data conversions using the Component Interface, File Layout, Application Engine and People Code.
• Application Designer was used to create new pages to provide Graphical User Interface to the users, Search Views, Audit tables to track row level security, and to create menu.
• Used People Code to control the program flow logic and for the validation to meet the current business rules.
• Customized the Time Admin process to post the Payable time to N.A Payroll before finalizing the Absence Management Process.
• To subscribe to data, third-party applications can accept and process XML messages posted by PeopleSoft using the available PeopleSoft connectors or by adding a custom built connector to the Integration Gateway.
• Developed Application Engine Program to Load the External Data into Temp Tables and from temp tables into PeopleSoft application tables.
• Analyzed and debugged the problems and provided online help to customers.
• Conducted interactive sessions to transfer knowledge in People Tools, People Code and SQR to client employees.
• Tested and replicated and resolved various issues reported by customers
• Maintained and updated the Department Tree and the Query Tree in the development database.
• Modified existing report formats and developed crystal reports using PS query.

Environment: PeopleSoft HCM 8.9, People Tools 8.47, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and UNIX, Weblogic6.1, MQ series, Kronos, ADP, COBOL, Tuxedo6.5, Jolt, SQL*plus, SQL Tools, TOAD, Crystal Reports.

Confidential, UT

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Extensively worked with Application Designer to modify record Definitions, pages, components, menus and giving access to them by using Maintain security.
• Developed Functional and Technical Spec for the HR, Payroll and Benefits Reports.
• Extensively worked on Production Support by handling tickets on North American Payroll, Benefits and Time and Labor modules.
• Adding permission lists to the run control pages and used process scheduler to run the reports online.
• Designed and developed people code to set up workflow for Hiring and triggering events to mail the new-hire details to all administrators such as Payroll, Benefits and Time and Labor.
• Developed SQR reports for premium journal Reports in Benefits and compliance reports and Garnishment Reports in payroll etc
• Designed and developed the Interface programs necessary to move data into PeopleSoft tables using Application Messaging through Integration Broker.
• Extensively used Process Scheduler for running different reports create and submit groups of processes as a job, and used Process Monitor to control the processes that are submitted to the Process Scheduler and to check the status of processes.
• Design of functional specifications for eligibility and event rules customizations in Benefits Administration and Salary change request with workflow routing in Manager Self Service applications.
• Worked on portal security including the access to pages and folders.
• Created custom Application Engine programs to synchronously create user accounts in the Portal Database for new employees.
• Worked on various People Tools such as Application Designer, Data Mover, Maintain security, Object Security, Process Scheduler, PS Query, and Application Engine.
• Extensively worked Global Payroll to Isolate country-specific regulations, processes, reports, self-service, and user-defined rules from the core application by using delivered country extensions, State, calculate and distribute an employee's pay in multiple currencies.
• Worked on Global Payroll to improves accuracy, timeliness, and financial controls, consolidate disparate payroll operations for multiple countries by using a single database, yet enter and access payroll data from anywhere in the world.
• Extensively worked on Payroll interface to ADP for several interfaces.
• Extensively worked on Absence Management to submit absence requests and view their status and View current and projected absence balances.
• Used Maintain Security to give access to the pages and customized Menu and created Permission lists, Users, Roles and assigned Roles to users.
• Requirement Gathering for eRecruit, Talent Acquisition, Candidate Gateway.
• Documented for the customizations, development programs for the user .
• Tested different new customizations and SQR Reports based on the Client’s requirements.
• Developed Queries using PS Query and export the results with Microsoft Excel and perform further calculations and develop report.

Environment: PeopleSoft HCM 8.9, People Tools 8.47, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and UNIX, Weblogic6.1, MQ series, ADP, Kronos, COBOL, Tuxedo6.5, Jolt, SQL*plus, SQL Tools, TOAD.

Confidential, Lexington, KY

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in analysis, customization, and implementation of HR/Benefits/Payroll modules using PeopleSoft 8.8 and Oracle 9i.
• Responsible of the design, development and testing of all HR, Payroll, Benefits and Time and Labor.
• Customized and implemented PeopleSoft HRMS modules
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Extensively involved in performing customizations to the HR application by creating new fields, pages and components.
• Used File Layout Definition tool to get data from the legacy system.
• Developed custom PeopleSoft on-line organizational, instructor and facility calendar panels for assigning courses and retrieving non- days.
• Worked on setup of SetID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System Generated SQR reports to create summary reports on payroll details check and validate the data.
• Maintaining PeopleSoft user security using PeopleSoft Security Administrator and Operator Ps.
• Including on boarding of new employees for one-time cutover as well as ongoing processes.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Executed unit test plans for medium complexity batch interface programs for eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on customization of PeopleSoft process using People Code.
• Using Global Payroll Integrate with standard chart fields to facilitate payroll expense reporting, Use a robust Absence Management engine to manage the most common leave types and automate the leave accrual balance process.
• Submit absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enable plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise eBenefits Self-Service Estimate Pension function.
• Involved in PeopleSoft Enterprise HCM solutions to integrate pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.

Environment: PeopleSoft HRMS 8.8(HR, Payroll, Base Benefits), People Tools 8.42, Crystal Reports, SQR, Oracle 9i, Web Logic 8.1/6.1, MQ series, Tuxedo 6.5, Toad, Windows NT/2000, Query Analyzer, Application Designer, People Code, SQR, PS/Query, security/View and Process Scheduler.

Confidential, Dulles, VA

PeopleSoft HCM Upgrade Consultant

Responsibilities:

• Worked on Pension Administration to manage multiple, complex defined benefit plans with a single, pure Internet solution that can be configured to match your unique plan rules.
• Interacted with Business Analysts to figure out the Process flow in various Business processes.
• Involved in analysis, design, data mapping and data conversions using SQR.
• Involved in the Application upgrade from version 8.3 to version 8.8 by using upgrade Assistant to prepare Upgrade for comparison Reports, Upgrade Statistics for Oracle to run the Benefit Reports and configured options to run unattended processes for error notification by Email.
• Involved in system testing and bug fixing during the initial and move to production phases of the Application upgrade.
• Involved in upgrade of people tools objects and primarily responsible for loading base data, fields compare reports and converting, reviewing Application Engine Reports.
• Prepared the database for the upgrade, applied required patches and fixes for the upgrade, ran DDDAUDIT, SYSAUDIT reports and cleaned the database before the upgrade process.
• Designed workflow applications for Payroll as well as Payroll interface.
• Responsible to run various Initial Audit Reports, Application Audit reports, compare Reports, Script modifications, involved in the upgrade process.
• Created run controls record pages and attached to the process scheduler, to run the process.
• Executed job for the initial pass of upgrade using Upgrade Assistant, documented issues related to upgrade steps, worked with PeopleSoft and resolved issues.
• Developed an application engine program to generate random passwords for the existing users and email them after the cut over process.
• Involved in migrating the projects from within various development environments and to production environment.
• Responsible for modifying & upgrading several customized SQR reports from PeopleSoft version 8.3 to 8.8.
• Identified in-efficient SQR programs and tuned them to improve performance.
• Performed system testing on the customized reports and pages.

Environment: PeopleSoft HRMS v 8.3/8.8, People Tools v8.1x, HR, Payroll, Benefits, People Code, Application Designer, Application Engine, File Layout, Application Upgrade Assistant, SQR, Crystal Reports 9.0, PS/Query, Configuration Manager, Object security, User security/ View, Process scheduler, Data Mover, Oracle 9i, Windows 2000/NT, HP-Unix, MQ series.

Confidential, Atlanta, GA

PeopleSoft Associated Consultant

Responsibilities:

• Worked on enhancements, customizations based on Service Requests by business users for PeopleSoft online objects and Non-PeopleSoft objects like SQRs.
• Involved in resolving the trouble tickets and issues related to custom reports and processes.
• Resolving issues like directing the output files to the server and client based on the need. Also worked on both inbound and outbound interfaces using SQRs, AppEngine and component interfaces.
• Worked with the People Tools 8.3 Integration Broker and involved in setting up the local gateway and created different target nodes as per the requirement.
• Worked in modifying the SQR interfaces/reports based on the regular service requests by first preparing the design and impact analysis. Reports included Absence History, Employee Review Audit, and Department Salaries using SQR and Crystal Reports for HR to name a few.
• Debugged Application Engine, People Code, Component Interface and SQR. Proficient in using traces (online People Code, AppEngine, SQR & COBOL traces) and debugging tools.
• Submitted processes to process scheduler to run daily tasks at a time or run recursively by creating a Recurrence definition to run at specific intervals.
• Design and Development of Interface programs to move data from Corporate Directory Services into PeopleSoft tables and involved in Data mapping between the two systems.
• Developed Application Engine programs and used File Layout and Component Interface to load data from flat file to PeopleSoft system. Written and modified People Code for validations.
• Developed and customized on-line pages and menus using People Tools.
• Setting up of process scheduler to enable end user to do multi- process jobs to run at client or at server and also used process monitor to keep track of the status.
• Usage of Import manager to import data from ASCII file to existing database.
• Worked on PeopleSoft Security, online application & data and had good exposure to security administration.
• Worked with Payroll Users in updating Pay sheets and calculating salaries for a specific pay period to perform pay in Payroll module and used pay calculations to calculate employee's gross pay and process manual checks.
• Worked on Benefits Administration in resolving BenAdmin issues. Worked closely with Benefits team for requirements gathering and converting functional requirements into technical requirements and developed the functionality.
• Supported Payroll (Payroll Administration - Pay Sheet, Pay Calc and Pay Confirm Processes) and worked on issues related to payroll.
• Used Data Mover to move data from development database to testing database and from testing database to production database.

Environment: PeopleSoft HRMS 8.3, People Tools 8.17, ADP, PL/SQL, Windows NT, Sun Solaris 2.8, Weblogic5.1, Tuxedo6.5, Jolt, SQL*plus.

Confidential

PeopleSoft HRMS Consultant

Responsibilities:

• Involved in the analysis, development/customizations and production support for various PeopleSoft modules like HR, Base Benefits and Benefits Administration.
• Involved in conversion of the HRMS Data from legacy system and formatted the data according to the PeopleSoft format. Used SQR’s and Application Engine’s for data conversion.
• Worked extensively with different people tools viz., Application Designer, Import Manager, Data mover.
• Used Application Designer to modify custom PeopleSoft objects. Modified existing records and created new records and views to meet the application needs. Created and modified pages and existing menus to reflect the customized pages and controlled the process flow with People Code.
• Worked on Data Conversion from legacy system to PeopleSoft system and developed utility in PeopleSoft using Application Engine, Component Interface and SQR.
• Modified existing/vanilla PeopleSoft SQR Reports/ Interfaces/Processes as well as developed new reports/interfaces/process as per the business requirements. Also worked on Crystal reports.
• Applied PeopleSoft delivered updates and patches.
• Involved in the development of run control pages, components and modified existing menus to reflect the component. Created Process definition, Process type definition and provided appropriate security to process groups.
• Used People Code to hide unwanted fields in some pages.
• Developed SQR Report for security reporting which lists all the users (OprIds) and their access type in PeopleSoft.
• Developed Report for Head count turnover based on locations and detail listing by departments.
• Involved in the daily support of this project.

Environment: PeopleSoft HRMS 8, People Tools 8.14, Oracle 8i, Windows NT, Sun Solaris 2.7, Weblogic5.1, Tuxedo6.5, Jolt, SQL*plus, PL/SQL.

Confidential

PeopleSoft HRMS Consultant

Responsibilities:

• Developed conversions programs to load Payroll and Benefit tables in PeopleSoft using SQR and Import manager.
• Wrote a SQR programs to modify balances in Payroll.
• Created data mover scripts to move the data from one database to other database.
• Performance Tuning of Reports.
• Developed Queries using PS Query and export the results with Microsoft Excel and Crystal Reports to perform further calculations and develop reports.

Environment: PeopleSoft HRMS 7.5, People Tools 8, Oracle 8i, Windows NT, Sun Solaris 2.5, Weblogic5.1, Tuxedo6.5, Jolt, SQL*plus, PL/SQL.