SUMMARY:

• Over 8 Years of diverse experience as PeopleSoft Technical in the Information Technology includes PeopleSoft HRMS/HCM. Worked as a Technical Developer on different projects like implementation, upgrade, migration and testing projects in PeopleSoft HRMS.
• Skilled in collecting facts, discovering problems and providing effective and timely solutions. Great Team Lead/Player with good interpersonal and communication skills.
• Possess excellent skills in Fit/Gap analysis, test cases, user requirement analysis, prototyping, data modeling, project management, proposal writing and documentation of functional and technical specifications. Good communication and presentation skills.
• Had the experience in PeopleSoft HRMS which includes HR, N/A Payroll, and Payroll Interface, TL, Compensation, Benefits, Benefit Administration, Profile Manager, TAM, CGW and ELM modules.
• Expertise in both Technical/Functional areas includes Analysis, Design, Document, Development, etc.,
• Upgrade experience of PeopleSoft HRMS application from 8.8 to 9.2.
• PeopleSoft experience includes over 5 years of Production support (On call) for PeopleSoft HR applications.
• Experienced in analysis, design, development and maintenance of IT applications in PeopleSoft.
• Experience in PeopleSoft Application Security (User Profiles, Permission lists and Roles), Department Trees, Row - level Security, Query Security, and Query Trees.
• Development experience in People Code, Application Designer, Application Engine, Component Interface, File Layout, Application classes and Packages.
• Extensive knowledge in T-SQL in SQL Server and Oracle PL/SQL. Development experience in SQL Server Stored Procedures and Database Programming
• Good understanding of PS Admin activities.
• Good understanding of basic Administration of SQL Server databases
• Knowledge of HTML, JavaScript and their application in PeopleSoft applications.
• Knowledge of PVCS version control tool, BMC Remedy, Clear Quest.
• Support and Maintenance of Application and Web Servers as part of PeopleSoft System.
• Excellent communication and interpersonal skills.
• Worked on multiple PeopleSoft upgrade projects for different modules: HCM 9.0 to 9.2,and Finance 9.0 to 9.1, Applied patches and bundles using PeopleSoft Update Manager PUM images and installed Oracle Secured Enterprise Search database software and configuring it from within 9.2 applications.
• Installed bundles PeopleSoft PUM Images using Oracle Virtual Box and configured and instruct client in use of the PeopleSoft Update manager PUM for their upgraded 9.2 HCM system. He has installed and configured of PeopleSoft Software in Dev, Customer Testing, QA and Prod regions and configured of PeopleSoft Internet Architecture PIA instances for various PeopleSoft/Oracle Database Instances in DEV, CUSTOMER TEST, QA and PRODS regions.
• A highly motivated, energetic and professional team player with good analytical, problem solving and interpersonal skills.
• Very good team player with excellent interaction/communication skills and willing to travel.

TECHNICAL SKILLS:

PeopleSoft Applications: PeopleSoft HRMS/HCM 9.x/8.x/7.5 ( Workforce Administration, Base Benefits, Benefit Administration, Payroll, Compensation, T&L, ELM, TAM,, ESS, MSS, Campus Solutions), E-Recruit, E-Profile Manager, E-Pay, E-Comp, E-Benefits, E-Performance, ADP,PUM

PeopleSoft Development Tools: Application Designer, PS Query, Workflow, SQR, Data Mover, Tree Manager, XML Publisher, Import Manager, Process Scheduler, Mainframe, Workflow

Reporting Tools: SQR, Crystal reports, PS Query

Operating Systems: Windows NT/95/98/2000/XP, DOS, UNIX, MVS

Databases: Oracle 9.x/10x/11x, DB2, SQL Server 6.5/7.0, and MS Access

Applications: Visio, MS Project, MS PowerPoint, MS Word, MS Excel, Adobe Photoshop, Test Director, STAT

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

PeopleSoft HRMS Upgrade Implementation Consultant

Responsibilities:

• Mainly PeopleSoft Developer role for retrofitting the existing customizations into the target PeopleSoft 9.2 application.
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Base Benefits modules.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Developed an Application Engine Programs like Blue cross blue shield and HRIS Premiums Interface.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• 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.
• Worked on interface programs for migrating data from other systems to People Soft.
• Also involved in acquiring Specifications from the functional team and modifying the SQR’s as per the SPECS.
• Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• Used File Layout Definition to get data from the legacy system to people soft tables.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Active role in changing the SQRs as per the change requests from the users.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• Handled bundles for the process of solving the issues in the enhancements.
• Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.

Environment: PeopleSoft HCM 8.8/9.2 (Workforce Admin, Benefits, Benefits Administration, Payroll, Profile Management, ESS and MSS), People Tools 8.51, PS-Query, Process Scheduler, Oracle10g, TOAD, MS-Office

Confidential, New York City, NY

PeopleSoft Technical Consultant

Responsibilities:

• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 8.8 and Oracle 9i.
• Involved in the design, development and testing of all HR, Payroll, Benefits.
• Involved in Data mapping between the two systems.
• 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 developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Involved in setup of SETID table, Company Information, Establishments, Location, Department, Salary plan, Job Code and Pay Group tables for HRMS System.
• Generated SQR reports to create Time Load to pay sheets, master employee listing, employee pension plan data, new hires and terminations.
• Install Change Assistant, run initial passes and MTPs, Install Oracle Secure Enterprise Search db software and configure it from within application, Install Bundles PUM Images using Oracle Virtual Box.
• Maintaining PeopleSoft user security using user profiles, roles & permission lists.

Environment: PeopleSoft HCM 9.1 (Workforce Admin, Benefits, Benefits Administration, Payroll, Profile Management, ESS and MSS), People Tools 8.51, PS-Query, Process Scheduler, Oracle10g, TOAD, MS-Office

Confidential, Parsippany, NJ

PeopleSoft Production Support/Development

Responsibilities:

• Performed Production Support, enhancements and customizations of PeopleSoft HRMS 8.9.
• Resolved issues with HR and benefits reports and interfaces, by correcting the logic and making necessary modifications as required to the SQR programs.
• Developed a new SQR to pull records of terminated employees and inserts into a table. Also created script and attached it to the batch process to run the SQR nightly.
• Created new Pages, Components, Records and Views to implement the functionality of Delegation in Manager Self Service.
• Created Roles for Delegate to access only delegate pages like Job Change Request, Approve and Status.
• Modified PeopleCode by displaying the Managers name and Emplid for all the delegate Job change Request, Approve and Status pages.
• Applying latest bundles using PeopleSoft Upgrade Manager PUM and Virtual Box.
• Created Workflows to send emails for both Delegation and Job Change Request sections in Manager Self Service.
• Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Mainly PeopleSoft Developer role for retrofitting the existing customizations into the target PeopleSoft 9.2 application.
• Created the Test plans, Test Cases and Test Cases in all modules.

Environment: PeopleSoft HCM 8.9/9.1 (Workforce Admin, Benefits, Benefits Administration, Payroll, Profile Management, ESS and MSS), Tools 8.51, Oracle10g, TOAD, MS-Office

Confidential, Princeton, NJ

PeopleSoft Techno-Functional

Responsibilities:

• Worked on the Conversion project. Converted the data from legacy system Tesseract to PeopleSoft.
• Involved in the creating conversion mapping documentation.
• Worked on different modules in HCM.
• Developed an SQR to print the employee’s personal information, benefit plan type, and the deductions amount for the plan type using HR, Benefits and Payroll tables.
• Created new Application Engine & Component Interface program to upload employee’s new Compensation rates from input file to Job component.
• Developed various Outbound and Inbound Interfaces for transmitting employee Data to Benefits vendors and process the receiving data to insert into various PeopleSoft Tables
• Modified different Paycheck Templates and tested all XMLP reports
• Worked on created functional document in TAM module for Template customizations and Offer approvals.
• Worked on Profile management. Worked on Approvals and trainings.
• Supported the users during UAT in understanding the PeopleSoft system and fix the issues as and when they arise.
• Prepared business test cases functionally to help the users in testing thoroughly.
• Created the Test plans, Test Cases and Test Cases in all modules.

Environment: PeopleSoft HCM 9.0 (HR, Benefits, Payroll Interface, E-Profile, TAM, Profile Management, ELM), Tools 8.48, Oracle10g, TOAD, MS-Office

Confidential, Chicago, IL

PeopleSoft Developer

Responsibilities:

• Worked on modules Student Records, Student Finance, Financial Aid and Recruiting & Admissions
• Involved in Functional & Technical design and testing.
• Involved in Plan, design, develop, and schedule all activities and exercises related to system and application testing for the PeopleSoft Campus Solutions
• Worked with the Campus Solutions Developers, and the Campus Solutions Implementation Team members
• Used software tools for business systems such as Visio, Microsoft Word and MS Project.
• Involved in Student Records setup, Term Activation and Enrollment and also involved some Self Service components.
• In Student Financials, involved in setup for Tuition Calculations, Late Fees Process, Credit History and Collection.
• In Recruiting and Admissions, involved in setup Prospects and worked on external test score processing.
• Worked on upgrade project and setup the security for many components and Users.
• Involved close familiarity with the core Student Administration data model and table structures.
• Prepared documentation of test exercises and activities to assist campus departmental testers in navigating through test exercises
• Worked on employee profiles approvals and profile change pages.
• Worked on Applicants exams in CGW and other templates setups and customizations in TAM.
• In student financials, worked on calculating tuition and fees setups and created course list.
• Created the FDD for every assignment.
• Created the Test plans, Test Cases and Test Cases in all modules.

Environment: PeopleSoft HRMS 8.8/9.0 (HR, Campus Solutions, Benefits, Payroll, E-Profile, Profile Management, TAM, ELM), PS-Query, Tree Manager, Security, TOAD, Ultra Edit, SQL Plus, PL/SQL, Test Director, Oracle 10 and UNIX

Confidential, Toledo, OH

PeopleSoft Developer

Responsibilities:

• Involved in understanding several Business Over views, Intersection meetings to understand the complete business process.
• Documented and Presented As-Is Business Process findings.
• Gathering client’s requirements from system users and administrator’s about the HR, Payroll, Benefits and Time and Labor related issues and provided recommendations.
• Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Proposed PeopleSoft functionalities to enhance the current Business Process
• Documented Impact Analysis of custom interfaces, reports and processes that are impacted due to the Benefit Setup changes in PeopleSoft 9.0 that includes Calculation Rules, Life AD/D and disability plan setup, FSA Plan setup changes, Rate configurations, dependent and beneficiary additions in the system.
• Involved in Project Planning meetings and provided inputs on Benefits Upgrade Methodology.
• Involved in the biweekly status meetings and provided progress on the Base Ben and Ben Admin modules.
• Prepared and Presented Pre-Upgrade and Post-upgrade tasks to be implemented before and after the Initial Pass.
• Worked on ELM modules, created functional specification.
• Provided Estimates on the Requirements Gathering, Functional Design and Testing for Phase two of the project.
• Created and executed test cases logged defects and resolved setup related defects.

Environment: PeopleSoft HRMS 8.8, PeopleSoft HCM 9.1 (HR, Benefits, Compensation, Benefits Administration, Payroll, TL, ELM), E-Performance, E-comp, E-Profile, TOAD, Oracle 9i

Confidential, Salisbury, MD

PeopleSoft Analyst

Responsibilities:

• Conducted Fit-Gap Analysis and developed full documentation of issues discovered and proposed solutions regarding the upgrade of HRMS 7.5 to 8.8
• Involved in setups for flat rate table, event rules and eligibility rules setup.
• Created Functional and Technical specification documents based on the requirements
• Audited employee’s Job record, deductions and benefit elections to ensure accuracy.
• Designed functional specification and created prototype for Payroll Interface files
• Developed the functional specs for the SQR that loaded ABBR annually
• Defined Calculation Rules on Life Plan Coverage Calculation based on employee’s ABBR.
• Involved in the setup for Payroll tables
• Modified delivered PeopleSoft programs to meet business specifications and needs.
• Worked on page design and customization that reflects business requirements.
• Coordinated the User Acceptance testing, made sure the business users have all the scripts.
• Tracked and validated the requirement changes
• Gathering client’s requirements from system users and administrator’s about the different types of benefit plans, plans types, plan Rules and incorporated them into the system by conducting multiple workshops.
• Involved in preparation for Annual Open Enrollment.
• Defined retroactive benefit and deduction programs and selection criteria for mass request.
• Designed and documented functional specs for vendor interfaces
• Developed test plans and test cases.
• Modified several PeopleSoft delivered Ben Admin reports.
• Developed several specification documents for Benefits Administration SQRs for reporting purposes
• Reviewed design documents and provided feedback for the same.
• Customized some pages, menus and process definitions according to user requirements and developed corresponding People Code for additional functionality
• Created pages, modified security settings and developed People Code for Benefits Open Enrollment
• Built and maintain positive working relationships with clients and vendors
• Involved in requirements review meetings and analyzed requirements for further development and testing purposes.

Environment: PeopleSoft HRMS 7.5/8.8, Tools 8.48 Windows XP, Visio, TOAD, and Oracle