PROFESSIONAL PROFILE

• PeopleSoft Business Analyst with 7 years of IT experience with strong exposure as People Soft Consultant spanning the complete Techno-Functional domain in Peoplesoft HCM NA Global Payroll, Time Labor etc.
• PeopleSoft Modules: HRMS, Base Benefits, eRecruit, ePay, Employee Self Service, Payroll Interface, Position Management, Time Labor, Financials, Accounts Payable, Billing, Order Management, Projects and Contracts, PeopleSoft Security
• Strong Exposure on various aspects of PS technologies like Application Designer, People Code, and Component Interface Application engine programs and functional knowledge in PeopleSoft payroll NA GP .
• Astute planning and strong analytical and leadership skills with exemplary communication, relationship management, and organizational skills.
• Coordinated and succeeded in planning and managing project for an entire team of 90 trainees as part of training at INFOSYS Global Training Centre.
• Worked on the complete aspect of the software lifecycle from requirements elicitation to design, coding and testing of the system, along with deep involvement in coordinating, Developing and testing of SQRs and PeopleSoft Applications.
• Knowledge in creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security.
• Expertise in managing the complete SDLC gained functional skills in analyzing the client requirements: translating new ideas into clients' solutions including opportunity identification, requirements development, delivery, support analysis and documentation.
• Functional knowledge of Peoplesoft North American Payroll. I have given a significant contribution towards quality improvement of the Project, that added value in handling and optimizing the Onsite Offshore model.
• Involved extensively in unit testing, writing unit test cases and develop test plans.

EMPLOYMENT HIGHLIGHTS

Confidential

Business Analyst

I was Responsible for:

• Business Process Study to understand the various business process and the way they are presently carried out
• Requirement Analysis and gathering requirement using Software Requirement Specification SRS form to further the process study
• Conducted Fit-Gap Analysis on the upgrade of the modification and customizations of Payroll and T L and facilitate requirements gathering sessions and fit-gap efforts in preparation for the conversion.
• Fit gap analysis to point out any gaps if existent between standard capabilities of the existing system and the desired system
• Business Mapping Report for follow-up of the GAP Analysis, which should address identified solution s for the GAP Areas
• Schedule meeting with Clients and Business, and understand the business process and provide feasible technical solutions to support the system.
• Provide technical Solution and oversee the delivery on time by the technical team.
• Test the changes in SIT/UAT for bugs.
• Provide solutions and bug fixes.

Involvement in other areas

• Facilitated Kick-Off presentations to Design team and HR Personnel for HCM PeopleSoft NA Payroll Time Labour applications.
• Wrote functional specifications for T L Payroll modules.
• Involved in design and setup of Automated Benefit Programs, Event rules and Eligibility rules for Open Enrollment and Event Maintenance.
• Master Data preparation and Management ,accuracy of the data of existing system has to be maintained throughout out the implementation life cycle.
• Technical Design and documentation for customization of payroll interface reports ,both existing and custom reports as per requirements
• Training end user on the setup and configuration of the Peoplesoft HRMS Payroll System
• Managing a team in handling and taking up CRS,estimating reviewing and testing and oversee the delivery on time
• Trained users in aspects of payroll.
• Ran queries to gather data for analysis and presentation to the client.
• Met weekly with the client to review open issues and potential solutions.
• Ran multiple payrolls from start to finish, including audit reports, calculations, confirms and W-2 processing.
• Designed, developed, and implemented new applications and reports involving the PeopleSoft Interface, HR, and Payroll teams.
• Involved in Mapping of HR data with Payroll and Payroll Mapping.
• Gather HR enhancement requirements from key HR end-users and coordinate completion of development requests.
• Coordinated with the Security Team to configure HR Security for all HR/Benefits/Payroll Roles/User Profiles.
• Lead the efforts for the creation of Test Strategy, Software Test Plan and Test Cases for PeopleSoft HR, Payroll, Benefits and Custom Applications.
• Handling change request related to all payroll operations in Merck Peoplesoft
• Requirement analysis requirement gathering, development testing related to Fidelity Benefits Vendor changes for Benefit plans using Application Engine Component Interfaces.
• Addressing incident raised by Merck Business Team
• Analysis and design of new requirement raised by Merck Harmonization Project
• Coordinate conduct status update meetings with business representatives.
• Evaluate bugs and work with Oracle-Peoplesoft for all cases raised by Merck.
• Application development review using Peoplesoft Tools and peoplecode
• Review of test cases prepared to test bug fixes/enhancements in Peoplesoft.

Environment: PeopleSoft HRMS v8.8 Payroll, Core HR, Base Benefits, Benefits Administration, Time Labor MS Excel, Oracle10g and UNIX.

Confidential

Responsibilities

• Act as techno-functional consultant in coordinating with Technical team and business team.
• Conducted Fit-Gap Analysis on the upgrade of the modification and customizations of Payroll and Benefits Administration and Lead position to facilitate requirements gathering sessions and fit-gap efforts in preparation for a conversion of PeopleSoft Payroll from ADP.
• Document system requirements by working with business and technical teams
• Detailed review of system requirements for completeness
• Conduct review sessions with members of business and technical team outlining current system and future system requirements
• Review previous project defects, current system limitations and defects, and enhancement requests and verify they are covered within the requirements documents
• Wrote functional specifications for Benefits, Payroll modules.
• Involved in design and setup of Automated Benefit Programs, Event rules and Eligibility rules for Open Enrollment and Event Maintenance.
• Provided post-live assessment of the Benefits module functions and issues relating to Benefits Administration, COBRA Administration and Benefits billing applications.
• Helped define tax tables and pay groups for new companies.
• Researched and solved multiple issues regarding Tax data for employees working in multiple states as well as conversion and new hires.
• Provided on call assistance during peak payroll processing times.
• Trained users in aspects of payroll.
• Ran queries to gather data for analysis and presentation to the client.
• Met weekly with the client to review open issues and potential solutions.
• Ran multiple payrolls from start to finish, including audit reports, calculations, confirms and W-2 processing.
• Designed, developed, and implemented new applications and reports involving the PeopleSoft Interface, HR, and Payroll teams.
• Requirement gathering and development of online application involving app designer, PS Queries , Permission Lists and creating and documenting MS Word Visio the process flow for the Hewitt supported application with the integration of the HR Inventory Tool.
• assessment of existing MS Access inventory database
• identification of data elements to be incorporated into a new Oracle database for tracking of Hewitt-supported application components with respect to the elements of EPI
• design of the Oracle database inventory
• migration/conversion of existing MS Access inventory database to the Oracle database
• data gathering across the Hewitt-supported application components with respect to the elements of EPI
• loading of gathered data into the Oracle inventory database
• provision of online access to the Oracle inventory database to Hewitt and Prudential resources for the purpose of viewing and updating data based on agreed-on roles and responsibilities
• provision for ad-hoc reporting against the Oracle inventory database PS Query
• provision for standard reporting against the Oracle inventory database
• Involved in customization and development of PeopleSoft applications using various people tools.
• Involved in customization of views, fields and search records, record definition. Created Record definitions, Page definition, Component, Run control pages attached them to required menus through Application Designer and made them available to various operators through Security Administrator to have the reports run under Process Scheduler.
• Prepared Technical Design Documents, Test Cases for Processes, Reports, and Interfaces.
• Involved in created queries through query manager.

Environment: PeopleSoft HRMS v8.8 Payroll, Core HR, Base Benefits, Benefits Administration, Time Labor MS Excel, Oracle10g and UNIX.

Confidential

Responsibilities

• Key member in in Alcoa-project transition
• Involved in production support and enhancement to the application.
• Custom open enrollment system interfacing directly with PeopleSoft Base Benefits Utilizing some basic Benefits Administration records and concepts
• Work with business, developers, and project manager to determine design considerations based on PeopleSoft best practices and future project considerations
• Provide feedback and expand on current test cases
• Assist developers with execution of test scripts during unit testing to eliminate defects prior to system testing
• Execute system testing and validation prior to business user acceptance testing
• Triage defects and assign to correct developers based on failed test scripts and feedback from tester in both system testing and unit testing environments
• Analyze root cause of defects and assist with designing and developing fixes
• Engage business to determine priorities for design and development of defects and change requests
• Validate system stability and interface with business to verify production environment and data
• Involved in creating run control record, run control page, components and assigning them to menu to make them available to particular through maintain security.
• Created the Technical Design Document, Unit Test Case, Peer review and Migration documents for the Development ID's assigned.
• Worked in writing UNIX shell scripts for uploading the Interface files to FTP site and sending notification emails with and without attachments, scheduling the processes using Crontab.
• Requirement gathering by interacting with the business users.
• Developed many sqls and datamover scripts
• Developed sqr interfaces to port data to the ftp server to be further sent to Albertsons' client.
• Generated sqr reports for the Albertsons' client for data validation.
• Worked as a production support on-call person for weekly payroll activities.
• Created custom security views in order to provide row level security.
• Application Designer: Created Pages, Components and Menus for Web Client.
• PeopleCode: Written extensive PeopleCode for validations, used all the events available in PeopleCode.
• Involved in customizing Records, Views, Subrecords, Derived Work Records, Pages, Components, Menus, and
• PeopleCode, writing SQR programs for reporting Purposes and for interfaces.
• Performance tuning on the SQR reports/interfaces.
• Directed design and development of some on-line customization.
• Involved in writing program specifications, program development/enhancements, program unit testing, develop test Plans, etc.
• Coordinating regular conference calls with the offshore team and the client.
• Modification of Design specs with respect to the solution for Production problems and enhancements.
• Prepared test cases and tested the code.
• Preparing Work Plans and doing Work Estimates.
• Created Benefit Programs, Beneift Plans, Rate Tables, Limit Tables, Event Rules and Eligibility Rules
• Designed Event Rules to requrie minimal manual processing by streamlining processing
• Developed and designed retiree life insurance reduciton schedule using delivered Peoplesoft product
• Implemented eBenfits to include View Benefits Summary, Open Enrollment and Life Events
• Created new Component Interface programs and application engine programs.

Environment: PeopleSoft HRMS v8.8 Payroll, Core HR, Base Benefits, Benefits Administration, Time Labor MS Excel, Oracle10g and UNIX.

Confidential

• Gathered client's requirements from users and administrators about Benefit Programs, Plan Types, Plans, Rules and Rates and incorporate them into the system.
• Worked on designing and implementing solutions for the support of business requirements.
• Worked with multiple business units and interacted with all levels of administration.
• Conducted workshops for user education on Payroll, HR and Base Benefits.
• Prepared functional specifications for reports and interfaces.
• Configured all the base tables including Company, Department, Location, Job Data and Earnings.
• Designed and Configured Accounting and Payroll.
• Designed and configured all deductions, earnings, benefit plans, Work Groups/Pay Groups and other supporting Tables including mapping of Earnings Code.
• Mapped Employee ID's to new Dept ID's, Payroll Business Units to GL Business Units and Earnings Codes to new Accounts.
• Worked on Paysheet Creation, Pay Calculation/Confirmation and all other Post Confirmation processes/reports.
• Carried out unit testing, system integration tests and supported users on Parallel/UAT.
• Base Benefits and Benefits Administration Setup including Benefit Plans and Benefit Programs.
• Set up Eligibility Rules and worked with custom Eligibility Configuration fields
• Set up of geographic eligibility rules as a part of automation of benefits administrative process.
• Implemented the Open Enrollment processes Customization of enrollment forms and confirmation statements.
• Set up eligibility rules for mechanization of Open Enrollment and Event Maintenance processes.
• Meetings with user groups to define security configuration and synchronized efforts with Technical group for implementation.
• Conducted full Base Benefits Benefit Administration Audit and reconfigured setup tables as necessary.
• Involved with the testing team in performing parallel testing of Benefits module right from HR transaction to Payroll paycheck process.

Environment: PeopleSoft HRMS v8.8 Payroll, Core HR, Base Benefits, Benefits Administration, Time Labor MS Excel, Oracle10g and UNIX.