SUMMARY

• Over nine years of diverse experience as PeopleSoft Financial/Functional/Business Analyst in Information Technology specializing in PeopleSoft HRMS/HCM. Worked as SME, Functional/Business Analyst on implementation, upgrade, and migration and testing projects in PeopleSoft HRMS.
• 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 as well as excellent communication and presentation skills.
• Over 9 years of experience in PeopleSoft HRMS/HCM which includes HR, NA Payroll, and Payroll Interface, TL, Compensation, Benefits, Benefit Administration, Profile Manager, Absence Mgt, TAM, and ELM modules.
• Expertise in both Technical/Functional areas including Analysis, Design, Document, Development, Testing and UAT coordination.
• Worked on system upgrade projects and setup the security for many components and users.
• Conducted Fit - Gap Analysis with full documentation and tracking of issues discovered and proposed solutions for defects.
• Worked as Financial Functional Consultant in PeopleSoft Benefits and Benefits Administration in various implementation projects.
• Well proven in providing Production support for various clients in the area of Banking, Financial institutions.
• Created many queries using PS-Query tool for creating Reports, XML publisher report templates and for other data validation.
• Expertise in creating Test Plans, Test Cases, Test Scripts and Test execution.
• Supported the users during UAT in understanding the PeopleSoft system and fixed any reported issues.
• 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, Core HR, Base Benefits, Benefit Administration, Payroll, Compensation, T&L, Absence management, ELM, TAM, ESS, MSS, Campus Solutions), E-Recruit, E-Profile Manager, E-Pay, E-Comp, E-Benefits, E-Performance, Campus solutions

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

Reporting Tools: SQR, Crystal Reports, PS Query

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

Databases: Oracle 7.x/8.x/9.x/10g, 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, Green Bite, and HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential, St Paul, MN

PeopleSoft Functional Lead & SME

Responsibilities:

• Coordinated with users gathering requirements and designed the functional specification for different countries to build new Payroll Interfaces and worked with Pay performance and Security Peoplesoft Applications
• Conducted Fit-Gap Analysis with full documentation and tracking of issues discovered and proposed solutions for defects.
• Resolving Day To Day Business Support Question for different countries
• Supporting and guiding Support team in Production issues
• Create new Change requests and projecting in E-Solutions for Approvals
• Designed Workflow documents explaining the process of mapping and transformation of data taken from different tables and integrated in the new tables
• Designed new Reports, Online Pages, Tables, Inbound Interfaces
• Created and modified PI Configurations
• Approved the Unit Test and Tech Design documents for all PI Issues
• Developed Test Plans, Test Scripts and Test Cases for modules for QA and UAT Testing
• Designed Workflow documents explaining the process for Security Administration
• Created many queries using PS-Query tool for creating Reports, XML publisher report templates and for other data validation.
• Verified the table structure and field information from Application Designer
• Developed various queries in SQL and validated the data from data base
• Responsible for tracking and fixing defects for Functional Designs for HCM modules
• Responsible for sending the HR and Payroll data from PeopleSoft to SAP
• Mapping the SAP Infotypes with Peoplesoft and created the Functional Design
• Troubleshooting Payroll and Benefits Defects related to Functional Specifications in Testing
• Followed Agile Methodology and delivered the requirements on time

Environment: PeopleSoft Core 8.80 (Workforce Admin, Benefits Administration, Payroll Interface, ESS and MSS), Tools 8.51, Remedy Street, Web Designer, Green Bite, HP Quality Center testing tool, Win SQL, MS-Office

Confidential, New York City, NY

PeopleSoft Functional Lead

Responsibilities:

• Worked on Analysis, Functional Design development, Testing completion and UAT coordination.
• Coordinated with users on input and requirements and designed the functional specification
• Designed Workflow documents explaining the process of mapping and transformation of data taken from different tables and stored in the new tables
• Designed new Reports, Online Pages, Tables, Inbound and Outbound Interfaces
• Created and modified Inbound and Outbound Interfaces.
• Developed Test Plans, Test Scripts and Test Cases for modules HR, T&L, NA Payroll, and Benefits work units.
• Created Timeadmin process by Determining time reporters, Create Batches, Build Rule map, Build TR Profiles, Punch matching, Create IPT, Track attendance, Process Rules, Post Rules Process, Offset Processing, Update Payable Time, Process Exceptions, Update TR status.
• Configured workflow for Abs Mgmt approvals.
• Conducted testing for Abs Mgmt, Time and Labor and the integration with Payroll.
• Created many queries using PS-Query tool for creating Reports, XML publisher report templates and for other data validation.
• Verified the table structure and field information from Application Designer
• Developed various queries in SQL and validated the data from data base
• Responsible for tracking and fixing defects for Functional Designs for Payroll, Benefits and HR.
• Troubleshooting Payroll and Benefits Defects related to Functional Specifications in Testing
• Followed Agile Methodology and delivered the requirements on time

Environment: PeopleSoft HRMS 9.1 (Workforce Admin, Benefits Administration, Payroll, T&L, Absence Mgt, ESS and MSS), Tools 8.51, Oracle10g, Web Designer, Green Bite, HP Quality Center testing tool, SQL Developer, MS-Office

Confidential, Portland, OR

PeopleSoft Functional Analyst

Responsibilities:

• Solicited user input and requirements and designed the functional specification for modules HR, T&L, NA Payroll, Benefits.
• Implemented CWR (Contingent workers) in PeopleSoft HR
• Designed new Reports, Online Pages, Tables, Inbound and Outbound Interfaces
• Created Internal and External Learning’s in ELM
• Modified Inbound and Outbound Interfaces of HCM
• Integrated Time and Labor with NA Payroll
• Created T&L rules and the T&L processing workflows
• Mapped the legacy fields to PeopleSoft Fields and created new fields when needed
• Designed Workflow documents explaining the process of mapping and transformation of data taken from different tables and stored in the new tables
• Loaded data into SFTP server and SQL Developer using Insert, Update and delete commands
• Setup the Benefits related tables and enrolled the employees into Benefits.
• Successfully conducted daily meetings with the users to gather the client requirements, overcoming challenges of user interaction located in multiple countries.
• Demonstrated great teamwork in working with different team members to discuss the requirements and other business issues.
• Involved in running interfaces to load the external data into PeopleSoft.
• Worked on various projects related to different modules in HCM.
• Proposed PeopleSoft functionality 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 included Calculation Rules, Life AD/D and disability plan setup,
• Prepared documentation PeopleSoft T&l and Payroll configuration, test scripting and execution, testing, test script writing, payroll parallel testing.
• Involved with the Tech Team in explaining the changes needed for the development
• Closely worked with Tech Team and UAT Team in helping them understand the functionality of the work unit needed for development and test case generation

Environment: PeopleSoft HRMS 9.0/9.1 (Workforce Admin, Benefits, Benefits Administration, Payroll, T&L, TAM,Profile Management, ESS and MSS), Tools 8.51, Oracle10g, Web Designer, Green Bite SQL Developer, HP Quality Center testing tool MS-Office

Confidential, New York, NY

PeopleSoft Production Support/Functional Analyst

Responsibilities:

• Solicited user input and requirements and designed the functional specification for modules HR, T&L, NA Payroll and Ben Admin.
• Upgraded PeopleSoft Time and Labor 8.9 to 9.1v
• Conducted Fit-Gap Analysis and created extensive documentation of discovered issues and proposed solutions.
• Prepared and Presented Pre-Upgrade and Post-upgrade tasks to be implemented before and after the Initial Pass.
• Strong ESS/MSS experience with Employee Change Forms
• Provided production support for HR, Payroll, Benefits, Ben Admin,e-Performance and TL
• Resolved various Production System issues related to Benefit Programs & Plan setups and calculation rules; provide assistance in troubleshooting and implementation of fixes.
• Responsible for daily activities including running the Ben Admin process, generating flagged participant report, running pending events query for all the events that are not finalized.
• Involved in the project for Open Enrollment.
• Worked on Profile Management, created FDD for custom profiles, Workflow approvals and page modifications.
• Developed Audit processes for Payroll Report and various Vendor Interfaces which helped the company in achieving 100% accuracy for generated reports.
• Designed Workflow for Approval process in Template Based Hiring process and Manage Hires Process.
• Created many queries using PS-Query tool for creating Reports, XML publisher report templates and for other data validation.
• Conducted Training sessions to end users and provided the training manuals.
• Developed Test Plans, Test Scripts and Test Cases for all Projects.

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

Confidential, Wayne, NJ

Functional Analyst

Responsibilities:

• Worked on different modules in HRMS.
• Involved in creating functional specifications for the implementation of ESS and MSS.
• Setup the tables for Benefits includes Benefit program, Plans, field mappings etc.,
• Created Benefits related functional specifications and delivered to Off-shore team for development.
• Setup the tables for Payroll interface.
• Developed Payroll Interface Inbound and Outbound files
• Successfully run the Deduction calc process, Additional Pay process, Export Data app engine process and created the import and export files
• Prepared the technical specification for the build and sent to Offshore for development.
• Successfully conducted daily meetings with the users to gather the client requirements, overcoming challenges of user interaction located in multiple countries.
• Demonstrated great teamwork in working with different team members across the organization to discuss the requirements and other business issues.
• Involved in running the interfaces to load external data into PeopleSoft.
• Worked on various projects related to different modules in HCM.
• Supported the users during UAT in understanding the PeopleSoft system and fixed any issues that arose.
• Created the Test plans, Test Cases and Test Cases in all modules.

Environment: PeopleSoft HRMS 9.0 (HR, Benefits, Payroll Interface, E-Profile, TAM, Profile Management, ELM), Tools 8.48, Oracle10g, TOAD, MS-Office, HP Quality Center testing tool

Confidential, Chicago, IL

Sr. Financial Functional Analyst

Responsibilities:

• Worked on modules HR, Payroll interface, Benefits, Campus solutions (Student Records, Student Finance, Financial Aid and Recruiting & Admissions).
• Created Functional & Technical design documentation for different implementations and customizations.
• Involved in Project Planning, design, develop, and schedule all activities and exercises related to system and application testing for the PeopleSoft modules and Campus Solutions module
• Performed system software upgrades including planning and scheduling, configuration modifications, testing and documentation.
• Successfully run the Deduction calc process, Additional Pay process, Export Data app engine process and created the import and export files
• Created Payroll Interface Export and Import file formats
• Successfully created the Payroll Interface cloning using PI Cloning utility
• Reviewed and Clarified different error messages in Payroll Interface
• Analyzed Reports data and Tested Payroll Interface reports
• Audit Pay sheets and verifying Employee tax data, reset w4 exempted list.
• Developed, implemented and completed extensive audit processes for all systems. Maintained PeopleSoft Financials configuration including: core tables, trees, security and workflow.
• Worked with the Implementation Team to explain the requirements and track their work progress.
• Created the different design documents using Visio, Microsoft Word and MS Project.
• Created the Pay Groups for Part-Time employees.
• Created separate Benefit program and completed employee enrollment into the program.
• Involved in Student Records setup, Term Activation and Enrollment and 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 system upgrade project and setup the security for many components and Users.
• Design and developed 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.
• In Financial Aid setup, financial aid terms, student budgets, external awards, loan counselling etc
• In student financials, worked on calculating tuition and fees setup and created course list.
• Created the FDD for every assignment.
• Created the Test plans, Test Cases and Test Cases for all modules.

Environment: PeopleSoft HRMS 8.8/9.0 (HR, Campus Solutions, Benefits, Payroll Interface, 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 Functional Analyst

Responsibilities:

• Involved in understanding several Business Over views, Intersection meetings to understand the complete business process.
• Documented and Presented As-Is Business Process findings.
• Conducted Fit-Gap Analysis and developed full documentation of issues discovered and proposed solutions.
• Gathering client’s requirements from system users and administrator’s about the HR, Payroll Interface, Benefits and Time and Labor related issues and provided recommendations.
• 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 input 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.
• Run the Payroll Interface process which include Deduction calculation, Additional Pay, Import and export application engine process and send the file to ADP
• Resolved Payroll Interface production support issues
• Loaded the Payroll Interface inbound interface data into seven different tables
• 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, Pleasanton CA

PeopleSoft Functional Analyst

Responsibilities:

• Participated in several business analysis meetings to gather requirements from administrators about different plan types, benefit plans, benefit programs and plan rules, earning codes, deduction codes, garnishments, Pay Groups, union and compensation rules to in corporate into the system
• Participated in gathering requirements and setting up of Core HRMS Foundation tables
• Coordinated several mini-projects end to end for the client.
• Responsible for doing the Impact and Fit/Gap analysis for the modification, enhancements and customizations of HR, Benefits Administration and Payroll modules
• Worked closely with functional users of the Benefits and Payroll department to implement solutions that support business requirements
• Analyzed system and business functional requirements for implementation and migrating data from legacy systems
• Created Functional Design for new interfaces and to modify delivered interfaces to interact with third party systems such as Hewitt and Vanguard.
• Worked with the Benefits Configuration team and setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Helped in configuring Deduction Codes, Earning Codes, Garnishments and GL Locations using Excel to Component Interface.
• Worked with Snapshot team and helped in base lining of employee benefits.
• Created Excel Spreadsheets, PowerPoint’s with Requirement Information, Budget Analysis and Time Expectations
• Gathered requirements for different Bargain Units and Union Rules.
• Gathered business requirements to Create Test Cases and Test Scripts based on the Functional Design.
• Performed back-end and front-end testing using SQL queries via Win SQL.
• Helped in uploading Test Cases and Test Scripts into Test Director
• Responsible for tracking and fixing defects for Functional Designs for Payroll, Benefits and HR.
• Created Test Scripts and Test Cases for Payroll Process, Leave Accruals, Benefit Enrollment and Custom Interfaces.
• Troubleshooting Payroll and Benefits Defects related to Functional Specifications in Testing
• Developed queries using PS Query and Win-SQL Tool.
• Conducted manual test on the Records/Tables for accuracy
• Wrote functional design documents for ‘Org Publisher’ product integration with PeopleSoft.
• Involved in running mainframe batch jobs.

Environment: PeopleSoft HRMS 8.8, (HR, Base Benefits, Compensation,, Payroll, ESS and MSS), Tools 8.49, Win-SQL, Visio, Test Director.