SUMMARY

• Over 8 Years of diverse experience as PeopleSoft Financial/Functional/Business Analyst in Information Technology includes PeopleSoft HRMS/HCM. Worked as Functional/Business Analyst on implementation, upgrade, 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 8 years of experience in PeopleSoft HRMS/HCM which includes HR, NA Payroll, and Payroll Interface, TL, Compensation, Benefits, Benefit Administration, Profile Manager, TAM, CGW 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, 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

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,QA Testing

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

PeopleSoft Functional Lead/Testing Analyst

Responsibilities:

• Worked on Analysis, Developed Functional Design, Testing completion and UAT coordination.
• Coordinate with user 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 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
• Written 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 delivery the requirement status on time

Environment: PeopleSoft HRMS 9.1 (Workforce Admin, Benefits Administration, Payroll, T&L, TAM, ESS and MSS), Tools 8.51, Oracle10g, Web Designer, Green Bite SQL Developer, MS-Office

Confidential, Portland, OR

PeopleSoft Functional Lead/Testing Analyst

Responsibilities:

• Solicited user input and requirements and designed the functional specification for modules HR, T&L, NA Payroll, Benefits.
• Designed new Reports, Online Pages, Tables, Inbound and Outbound Interfaces
• 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,
• Developed Test Plans, Test Scripts and Test Cases for modules HR, T&L, NA Payroll, and Benefits work units.
• Prepared documentation of System Test Execution for the functional specification for modules HR, T&L, NA Payroll, Benefits.
• Created the Phire tickets for different work units and re-validated the test execution after closing the Phire tickets.
• 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, CGW, Profile Management, ESS and MSS), Tools 8.51, Oracle10g, Web Designer, Green Bite SQL Developer, 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, Benefits and Ben Admin.
• Conducted Fit-Gap Analysis and created extensive documentation of discovered issues and proposed solutions.
• Setup the tables like Business Units, Set Ids, Department, Job Codes, Location, Plans, and Benefits Plans and so on.
• Strong ESS/MSS experience with Employee Change Forms
• Provided production support for HR, Payroll, Benefits, Ben Admin, and TL
• Setup the Benefits related tables and enrolled the employees into Benefits.
• Resolved various Production System issues related to Benefit Programs & Plan setups and calculation rules; provide assistance in troubleshooting and implementation of fixes.
• Conducted full Base Benefits & Benefits Administration Audit and reconfigured set-up tables as needed.
• 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.
• Created functional documents for TAM and CGW for creating new templates in different areas.
• Integrated Profile Management with TAM to access different profiles
• 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 9.0/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:

• Working 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. Processed the deductions for payroll interface to ADP
• 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 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.
• Created functional documents in TAM module for Template customizations, Offer approvals and Hire approvals.
• Worked on Profile management. Created profiles for TAM and integrated with the TAM. Worked on Approvals and training.
• 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

Confidential, Chicago, IL

Sr. Financial Functional Analyst

Responsibilities:

• Worked on modules HR, Payroll, 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.
• 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.
• Worked on Applicants exams in CGW and other templates setups and customizations in TAM.
• 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, 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, 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.
• 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, 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.