SUMMARY:

• Around 7+ years of experience as a PeopleSoft Consultant, has good experience with PeopleSoft HCM (HR, Benefits Administration including ACA Reporting, Time and Labor, Payroll, Commitment Accounting, Position Management, and the e - Modules).
• Functional and technical exposure of PeopleSoft modules like HR, Payroll, Benefits, Employee Self Service and Manager Self Service.
• Hands on experience in PeopleSoft Application 8.3, 8.9, 9.0, 9.1, 9.2 and People Tools 8.18, 8.49, 8.5X versions Global Implementations & Production support, Development and Upgrade projects, and data-conversion.
• Strong PeopleSoft analytical experience in TAM, Core-HR, Benefits, Payroll Interface, Employee Self-Services and Manager Self-Services.
• Specialized in gathering the requirements and design specifications for data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Understanding both technical and business necessity for all features within the application, including backend and API configuration and involved in documentation of technical specifications and developing test cases.
• Verified and Responsible for running the biweekly (On-Cycle and Off-Cycle) payroll by providing analysis support on PeopleSoft Time & Labor and Payroll modules.
• Successfully implemented Full life cycle projects- worked through the phases of requirement gathering, scope management, process analysis, GAP analysis, testing.
• Proficient in data conversion from legacy system to PeopleSoft system as well as supported Commitment Accounting setup as it related to Payroll processes.
• Hands on experience with various HCM modules: NA Payroll, Self Service (ESS & MSS), Time and Labor, Administrator workforce.
• Working experiences in Databases like Oracle and DB2 and experience with implementation of enhancements and changes to Benefits and Payroll processes (SQRs, Application Engines, and CI) before and during the Open Enrollment period.
• Experienced in PeopleSoft upgrade, devising implementation methodology, conversion strategy, production support, troubleshooting.
• Good Knowledge on PeopleSoft HCM 9.2 modules: Payroll, Time and Attendance, Employment Data and Workforce Administration.
• Extensive knowledge in creating requirement specifications, analyzing requirements, creating functional documents and has the proven ability to translate them to system requirements and technical specifications.
• Proficient in collaborating with different teams, establishing milestones and weekly status reports. architects, support center and hence ensuring smooth Go Live deployment of projects.
• Processed customer requests, gather and document requirements, design and perform application setups, perform unit testing and production setups.
• Provided PeopleSoft functional consulting services by acting as subject matter expert and leading clients through the entire system development lifecycle.
• Worked on project phases including fit/gap, configuration, System Testing and UAT and experience in creating Functional design documents.
• Ability to adapt to changes and continuously meet deadline and advised client on options, risks, and any impacts on other processes or systems.
• Knowledge of reporting tools PS Query and configured the PeopleSoft system to meet each client's unique business requirements.
• Advanced user skills in MS-Office (Excel reports: Pivot Table/Chart, V-look Up, Multiple v-Lookup. H-look Up) PowerPoint, Outlook.
• Completed tasks efficiently and reported progress to clients and project managers in a timely manner.
• Working knowledge includes Application designer, People codes, and PS Query Reporting.
• Hands on Experience in PeopleSoft Core HR, Workforce Administration, Global Payroll and Absence management, NA Payroll, Benefit Administration, PS Recruit Workforce, PS Query, MS Office (Excel, Word, PowerPoint, and Outlook).
• Contributed to a small team that serves as the primary PeopleSoft functional support for process, transaction, and system inquiries.
• Significant PeopleSoft implementation experience from project conception through roll-out which includes fit gap analysis, development, major customization, testing, and training.
• 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.

TECHNICAL SKILLS:

Peoplesoft Functional: Core HR, Workforce Administration, Position Management, Time and Labor, Absence Management, Profile Manager, Base Benefit, Benefit Admin, Global Payroll, Payroll Interface, ESS, MSS.

PeopleSoft Technical: People Code, Application Designer, Application Engine, Tree Manager, Component Interface, File Layout, Data Mover scripts, Integration broker, PS Security

Databases: Oracle, SQL Server, DB2

Reporting Tools: SQR, PS Query, XMLP, BI Publisher

Operating Systems: Windows, UNIX, Linux, Solaris

Other Tools: STAT, MQC, MS Project, SharePoint, PL/SQL Developer, OBIEE

MS Office: MS- Visio, MS-Word, MS-Excel, MS-Power Point, MS-Access

Methodologies: Analysis and Designing, OOPS, System Analysis and Designing.

Languages: SQL, C, PL/SQL, XML

PROFESSIONAL EXPERIENCE:

Sr. Business System Analyst- PeopleSoft

Confidential,Miami, FL

Responsibilities:

• Involved in the production & support and upgrade of HR/Benefits/Payroll, Time & Labor modules using PeopleSoft 9.2 and People tools 8.56.
• 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 and created data mover scripts to move the data from one database to another database.
• Developed Queries using PS Query and export the results with Microsoft Excel and Crystal Reports to perform further calculations and develop reports.
• 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.
• Resolved 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, App Engine and component interfaces.
• Worked with the People Tools 8.56 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, App Engine, 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.
• 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 Ben Admin 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 & 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.
• Helped client understand the department chair position management and how to implement in PeopleSoft.
• Developed the test cases from functional requirements and technical specifications and identified the complexity and necessity of the business requirement during the functional test scenario execution.
• Set up roles, permission lists including row level security, department based security and created user profiles to establish security for the system.
• Extensively worked with Security Administrator to implement security in various levels creating Roles Permission Lists, User Profiles, Portal Security, Definition Security, Query Security & Row level security.
• Developed the test cases from functional requirements and technical specifications and identified the complexity and necessity of the business requirement during the functional test scenario execution.
• Planned and executed the migrations to next environments and keeping the Projects in Synch.

PeopleSoft Business System Analyst

Confidential,Dover, DE

Responsibilities:

• Conducted user interaction sessions to allow business owners and users to gain familiarity about the new functionality delivered in HCM 9.1.
• Analyzed existing Time and Labor configuration, which included Time Reporting Codes, Time Reporting Programs, Workgroups, and Value Lists to make sure the configuration has been set up correctly.
• Responsible for leading the design of Inbound and Outbound interfaces in Time and Labor, retrofitting Time and Labor Rules.
• Set up Time Period Calendars, Manager Time Calendar view options, Compensatory Time Plans.
• Defined Exceptions, PeopleSoft Application Engine sections, Validation criteria, Override reason codes.
• Worked on mapping the Time Reporting Codes to Earning Codes, Created Leave Plans and Benefit Plans as well Benefit Programs.
• Responsible for Requirements Gathering and Fit-Gap Analysis proposing possible solutions to develop new functionality and some workarounds.
• Involved in the reviewing, writing & execution of Test cases pertaining to Time and Labor, Core HR and Payroll.
• Supervised the team to make sure about the configuration needed for 9.1 version, created and maintained a configuration document.
• Implemented the solution design decisions and tailors the designated application to meet the requirements of the end users.
• Designed and developed functional/technical design specifications for Reports, Interfaces, Conversions, Enhancements, and workflow.
• Configured and set up the online rule processing in Peoplesoft Time and Labor and developed several Interfaces, Conversions, Enhancements, and workflows.
• Customized ACH, Bank Reconciliation, positive pay files, PO dispatch and implemented workflow using Approval Framework (AWE) for Time sheet Approval.
• Responsible for coordinating status reports, updates for the solution they are responsible for, as well as participating on teams and working with the end-users to assure that requirements are incorporated within the solution design.
• Major project converting Data from PeopleSoft into EBS and worked closely with the business customers to create new customized BI dashboards.
• Responsible for assisting and assigning work to team members and assuring timely completion of project milestones and deliverables.
• Prepared Test plans, which included Test scripts to make sure SIT, UAT are completed in an efficient manner. Leveraged PTF (Peoplesoft Test Framework).
• Support for Bi-weekly Payroll Processes, Holiday Payrolls and Time& Labor processes, which included Time Administration, Batch Approval and AWE.
• Designed and configured multiple Time and Labor rules using a delivered template, custom SQL objects and User Exits.
• Collaborated with business users to identify areas for process improvement to reduce manual efforts. These activities included developing data loaders, training users on use of Mass Update functionality, working with Developers to design audit reports and programs to automate upload of Merit Increases and Performance Ratings.
• Worked in conjunction with the technical development team to develop and support interfaces to/from third party software, reports and programs.
• Well versed with the setup of Work Structures- Location, Organization, Job and Grade in HR.
• Identified and addressed client needs: building solid relationships with clients, developing an awareness of Firm services.
• Set up of elements to implement new Cellular Stipend Allowance and coordinating testing through import to Payroll system.
• Participated in Oracle HR System testing for innovative solutions and upgrades.
• Submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval.
• Analyzed the customizations to the delivered SQR reports and worked with the functional analyst to determine if the customizations need to be reapplied or retired.
• Involved in designing workflow so that the specific user will get emails when a manager level employee.
• Created new Menu and registered that in Portal providing Permissions and securities for the above page in Manager self-service so that only Managers can view that page.
• Created workflow for self-service so that whenever an employee changes the address in the Personal page worklist will be sent to manager.

Business Data Analyst- PeopleSoft

Confidential,New York, NY

Responsibilities:

• Worked on Business requirement study & analysis by engaging with client / users as well as documented the customizations required within PeopleSoft to support the dataflow and workflow for HR, Benefits and Payroll. Involved in for creating new workflows for Time and Labor using AWE.
• Developed Technical Specification Documents to bridge between functional users and technical developers for HR, Payroll and Benefits Module.
• Upgraded the Employee Self Service, Manager Self Service, ePerformance, and Workflow Administrator
• Worked with functional users, analyzed and tested PeopleSoft HCM benefits administration processes
• Developed and tested PeopleSoft HCM retroactive payroll/benefit and deductions test case scenarios and business requirements
• Actively involved in QA process activities, like Creation of test plan, Creation of test case, Creation of Test Matrix, Test Case execution, Reporting the bugs, problem resolution, bug tracking, system defects, and retesting the bugs
• Performed all phases of end-to-end testing which includes Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing of the Application.
• Designed and processed test scripts for manual testing of each application and developed test cases and test scripts for the functional testing.
• Performed manual Quality Assurance testing (QAT) and User Acceptance Testing (UAT) activities for new releases.
• Utilized Load Runner for performance testing to analyze the response times of the business transactions under load.
• Actively involved in the performing Functionality, Integration, Regression and System Testing and reported bugs using Quality Center and generated the defect reports for review.
• Maintained the test traceability matrix and set up guidelines for and participated in back end testing for the e-Commerce site.
• Build a stored procedure library on the Oracle database and used stored procedures to simulate marginal invalid conditions, modify product price and quantities, validate site's search engine results, etc.
• Performed white-box testing of Java Script embedded components used in the in-house management and bug tracking utility.
• Defined project deadlines and worked closely with team members to insure strict timeline adherence.
• Lead Load/Performance testing effort of the products using Web Load, Load Runner, and URL Hammer.
• Enhanced the scripts by adding checkpoints, transactions, rendezvous points, created parameters, and performed manual correlation to enhance recorded scripts.
• Used Bugzilla for tracking and reporting defects and developed load scenarios using Load Runner.
• Developed Test Plans and Test Scripts for Automated Testing using Quality Center and also modified existing scripts as per the new builds.
• Performed smoke testing and tested front-end web applications and ran SQL queries to SQL server for results verification.
• Extensively used SQL to verify the integrity and consistency of the data in the database and Worked on the Data Validations & Unit Testing of Dashboards in OBIEE and PeopleSoft HR.
• Conducted the Regression tests for already reported Bugs to test whether fix has been applied or not and also to test whether the fix causes another problem or not.
• Building and modifying PeopleSoft objects plus documenting the changes for system improvement request and production support.
• Involved in gathering & defining requirements, and overall scope definition in terms of functional & technical requirements. Participated in the Fit/Gap sessions with the user s to define the Customizations to upgrade.
• Designed and developed Rule Variation Front End Template to access the dynamic values and to define multiple rules with different variations for each workgroup.
• Developed Workforce Time and Labor security. Defined dynamic groups with combination of multiple workgroups for Time Administration process.
• Gathered Functional requirements. Created functional specifications for Self-Service transactions. Developed analysis documents for Employee Self-Service transactions.
• Involved in the analysis of compare reports from PeopleSoft upgrade labs and finalizing the upgrade script changes.
• Involved in the analysis of compare reports from PeopleSoft upgrade labs and finalizing the upgrade script changes. Upgraded online Customizations. Added new pages and People code.
• Reapplied Customizations in SQRs and Application Engine interfaces to carriers/vendors, time entry inbound from multiple systems, benefits, HR interfaces and reports.
• Customized the workflow of employee job data maintenance and employee self-service. Closely worked with functional team to define the reconciliation rules and worked on data reconciliation. Coordinated the payroll parallel activities and involved in payroll parallel reconciliation.

Business Analyst

Confidential,NYC, NY

Responsibilities:

• Organized and facilitated JAD session for effective communication of views between stakeholders and document business requirement.
• Translate stakeholders' requirement into various documentation deliverable such as functional requirements, use cases and process workflow diagram.
• Worked independently with users to define concepts and clarify functional and Non-functional requirements on a daily basis.
• Conducted meetings and workshops to discuss user requirements and developed User Requirements Specification Document.
• The User Requirement Document contained detailed requirements, formatted such that the traceability matrix elements could be matched from features to test cases.
• Worked closely with developers participated in the Product Design Process including specifications and end-user reviews and application walk-through.
• Managed Version Control, each version of the application was stored in Visual Source Safe and necessary modifications, updates, analysis was done.
• Configured test environment for specific Test Cases, created test data, executed manual unit tests, document results and updated URD.
• Met with users to generate and review Business Test Cases and prepared Use Case Documents.
• Created Workflow Diagrams, Process Models, Activity Diagrams, and Use Cases for incorporating design changes in business processes.
• Analyzed the impact of Business Process changes on the existing systems and process flows. Analyzed the testing efforts that would be undertaken by other systems due to the changes in current systems. Coordinated analysis, development and testing efforts.
• Created non-functional system requirements pertaining to data quality and system performance.
• Conducted Integration Testing and Regression Testing with developers in development and conducted User Acceptance Testing (UAT) with UAT team.
• Utilized MS Visio to create various flow charts, use case and sequence diagrams to provide detail outline of the various actors of the diagram and how the various components of the system interacted,
• Maintained Requirement Traceability Matrix (RTM) and maintained document for change request, implementation and testing change.
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
• Validated technical designs created by IT developers against functional specifications and provided technical and procedural support for User Acceptance Testing (UAT).