Career Summary

8 years of working experiences in Implementation, Upgrade of PeopleSoft Financial and HR Projects, as a Techno-functional Consultant, responsibilities including analysis, design, development, testing and troubleshooting. Participated in all levels of the systems development life cycle SDLC of PeopleSoft projects including Fit/Gap analysis, Requirements gathering, Technical Development, Interface Design, Configurations, Reporting, Data Conversion, Testing, Troubleshooting and Production support.

Qualifications

• Experience in Implementation, Production Support, Customization, Upgrades and Troubleshooting in GL, AP, AR, Expenses, Contracts, Project costing, Cash, Grant, Purchasing, Billing, eProcurement, and Inventory modules.
• Areas of expertise in HR Modules as Time and Labor, Benefits Administration, Payroll, Recruiting including Talent Acquisition Manager and Employee Self Service, Manager Self-service, ePerformance, Profile Management, Workforce Administration, Absence management and ELM.
• Experienced in Business process analysis and design, end-user Training design, development and delivery for Campus solution module including Student Financials, Campus Community, Student Records, Financial Aids
• Solid working knowledge of Relational Database Management System.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture and SQL Query Writing.
• Strong documentation and written presentation skills, developed various functional and technical specs with Test Plans and Training document for users.
• Coordinate with business and technology partners to get feedback and sign off's
• Expertise in developing QA Test Plan, Test Scenarios, and Test Cases ensuring adequate testing on software both before and after completion conducting and documenting UAT.
• Scoping and defining new business opportunities and requirements with users.
• Involves designing the requirements development process, determining which requirements are the highest priority for implementation, and managing change.
• Excellent Team player to work in conjunction with other testers, developers, offshore team and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

Peoplesoft expertise

• Application Modules: PeopleSoft Financials and FSCM 8.8/8.9/9.0/9.1 GL, AP, AR, Expenses, Project costing, Purchasing, Billing and Inventory Modules and HRMS Version 8.9/9.1 Time and Labor, Base Benefits, Benefits Administration, Payroll, Recruiting including Talent Acquisition Manager and Employee Self Service, Manager Self-service, ePerformance, Profile Management, ELM, Workforce Administration, Security and Training .
• PeopleTools: Application Designer, Tree Manager, Work Flow, Process Scheduler, PeopleCode, Application Engine, Integration Broker, File Layout, Configuration Manager, Component Interfaces, Data Mover and Change Assistant.
• Reporting Tools: SQR, Peoplecode, PS Query, Crystal Reports and PS/nVision
• Languages: SQL, SQR, PeopleCode, Shell Script, VB
• Tools: PeopleTools 8.51, 8.52, SQL, SQR, Crystal Reports Visual Basic, UPK, QC, Toad
• RDBMS: Oracle, MS SQL Server and MS Access

Project summary

Functional Consultant

Confidential

• PeopleSoft HCM8.9/HRSM 9.1 Core HR, Workforce Administration, MSS/ESS, Staffing, ELM, Base Benefits, Payroll
• Worked closely with Business users and HRIS in capturing requirements and creating Functional documents BRD FD
• Organize meetings with different groups and maintain document updates
• Utilize Functional expertise to lead fit-gap sessions with primary stakeholders to setup and configure the system
• Expertise in analyzing complex business process of various enterprise and design solutions in PeopleSoft.
• Create test plans for System and Integration testing, Regression Testing, User Acceptance Testing
• Create various test scripts as per test plans and execute them in different environments for Talent Acquisition Manager Recruiting/Staffing , Workforce Administration WFA , Manager self-service MSS and employee self-service ESS , Enterprise learning Management ELM , e-Performance, Absence Management , Base Benefits, Benefit Administration, Payroll , Performance Management, Compensation modules
• Worked different projects with tight timeline, multi-tasking with different groups, closely with Developers, HRIS and UAT Testers to make sure work is progressing as expected, schedule meeting during the requirements gathering and daily defect call during testing
• Be Accountable to the project team, and periodically give ad hoc reports of the progress of testing.
• Documented all new changes in requirements and test plan and maintained up-to-date specifications for developers and testers
• Logging defect in Quality Center, track and update defects for the project, send defect status report daily
• Conduct daily defect calls with business user, SIT/UTA testers, developers and offshore teams, summarize the testing progress
• Develop test plans and test scripts for Staffing projects relate to Associate pre-hire processing, Labor group union , Time in Title change and lead the testing, response to sign off from QA
• Configuration of PeopleSoft Time and Labor report time, scheduled time, exceptions, rules
• Integrating Time and Labor with Absence Management
• Configuration of PeopleSoft Absence Management
• Payee Data, Absence and Payroll Processing, Taxes, Year-End Processes, Time and Labor delivered integration with payroll, Absence Elements, Payslips, Reports, Banking, Social Security, Loans, Terminations, Pension plans.
• Data Migration from Legacy systems
• Work on payroll processes to elaborate a fit/gap analysis and identifying the customizations required to fulfill the business processes
• Processing Absences to generate computed absence results to Global Payroll by employee and pay period
• Executing payroll processes in a parallel way comparing results between PeopleSoft and the payroll system of the client
• Pay check validation, defect retesting for print pay check issue

• Develop and update the training strategy for HR administrators, which incorporate training material, user guides, helpdesk scripts and any other relevant eRecuit/eHire knowledge-based materials.
• Based on the Training strategy, develop and update Training materials user manual, on Demand scenarios, workflows, jobaids and user guides for the end-to-end eRecruit/eHire business process
• In line with the training strategy, develop a Training of Trainer's strategy that includes training scenario-based modules to be used for future releases of eRecruit/eHire
• Provide support to e-Recruit users and respond to incoming inquiries from external applicants
• Lead the UAT for scheduled milestone 1 and 2 releases of the eRecruit/eHire project
• Provide business analysis support for the requirement specifications and development of a roster in eRecruit
• VZlearn project: Self-service options for employees learners include the ability to enroll in classes, change address and phone information, view their course bill, accept/decline financial aid, and view course schedules, grades, and transcript information. Managers and academic advisors can enter and change grades and view advisee class schedules
• Recruiting change request for International degree, maintain all the external applicant's academic record including degrees, education institutions and scholarship information
• Processed employee benefit elections using PeopleSoft Benefits Administration module
• Fiscal year Open Enrollment, including configuration of new Benefit Programs, Program Eligibility Rules, and Plan options, OE testing, and OE Reporting
• Definition of segmentation for half period hiring or salary increase, validate the compensation tab after the change
• Hands on enroll employees into benefit plans and setup dependent and beneficiary data
• Implementation project of ELM 9.2, lead the UAT testing of power users and executing testing script
• Test the customized project for ELM to assign different credits to learner within learner group based on the Job Titles
• Data validation in different environment after project migration, data conversion testing, regression testing after environment refresh or shake out
• Set up the test cases for payroll processing of benefit deductions
• Responsible for the PS staffing module batch processing, work with prod support team to schedule the job running Investigate the batch processing result during UAT testing or based on daily tasks
• Using SQL to query table, validating data mapping, dump testing data for end users, get data to set up test case, environment refresh shake out
• Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenances
• Maintain and monitor the process scheduler to run App Engine/ SQR program and batch job daily
• Using PS Query to generate report and validate the report with data from the table
• Defect testing and debugging, cooperate with Prod Support and development team for trouble shooting investigation, Post go-live support, Prod defect retesting in SIT
• 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
• Analyzing and developing strategic imperatives for organization / business units using various strategic management methodologies
• Experienced in People Tools Application Designer, Import Manger, Data Mover, People Code, QC, QTP, Security Administrator, Object Security, Maintain Security, SQR, PS/Query and Crystal Reports, Process Scheduler, Application Messaging, Utilities, Application Engine and Upgrade Assistant
• Work with Prod support team and HRIS to monitor system performance and coordinate tuning activities with DBA
• Response to SIT environment shake out regression test every time database refresh
• Coordinate with 3rd party vendor for interfaces integrated with PeopleSoft integration test
• SDLC Projects Lead:
• Move CS system to PeopleSoft and test all the functions including AP/ePerformance
• Payroll effective date change Project
• CBA sort order for Union change
• Union associate for Time in Title Project
• Employee Referral Program
• Unprocotored assessment testing for Associate job Pre- hire exam integrate the test result with 3rd party vendor into PeopleSoft
• Job posting enhancement for prohibit wording change
• Pre-hire portal change Project
• I9 enhancement Project
• Re-Org change by adding new LOB, validate Scope and Business unit updates
• EEO report testing
• Executive LTI Long term incentive plan calculation report Project
• Company mobile device update project in ESS module
• Finance chart field change Project
• Data mapping change between Finance LOB and location with HR LOB and location
• QTP script functional validation for staffing project automation testing
• ELM learning 9.2 implementation Project UAT testing

Functional Consultant

Confidential

• Managed and support the implementation of PeopleSoft GL, AP, AR, Travel Expenses, Project costing and Budgeting and Contract modules. The project included creating a finance and project strategy, redesigning their finance processes, training the core client team and implementing PeopleSoft to provide for these new requirements. During the course of the project, beside the vanilla version installed, we have develop different customized pages and functions per client'e requirement. This included adding a new chartfield and rewriting the interface between the project costing module and the contract module. In addition to my project management responsibilities, I played a key role on the training team over one hundred users were trained in the use of the new system during the UAT testing.
• PeopleSoft Financials 9.1 GL, AP, AR, Travel Expenses, Contract, Project costing, Grant, Purchasing, Billing, eProcurement and Inventory
• Responsible for preparing Functional/Technical design specifications, Preparing Data Mappings, developing and testing interfaces in GL, AP, AR, Project costing, Purchasing, Expenses, Billing, eProcurement modules
• In-depth knowledge of PeopleSoft Development Life Cycle SDLC Fit/Gap Analysis, Design, Data Conversion, User Interface Customization, Unit / Integration / System /Acceptance Testing, End User Training.
• Fit/Gap analysis and configuration on GL, AP, AR, Billing and Expenses, functional documentation writing for Project costing integration with GL/AP/AR/Contracts modules
• Understand functionality and integration to create functional designs, test scripts, configuration documents and create and submit final documentation
• Writing function specification for customized components and component interface design, using Application designer for Application Interface Design
• Gathered all requirements created BRD for a full turn around start to finished interface
• Designed tested Component Interface for 3rd party Purchasing Portal. Interfaced all Invoices, Vendors GL Accounts within compliance Chart of Account values.
• Processing Journals, Open Item Accounting, Financial Consolidations, Entry Events and Journal Entry Approvals etc.
• Set up and configure control tables for GL module
• Integration of General Ledger with Accounts Payable, Accounts Receivable, Travel Expenses and Project Costing
• Modified the GL Balancing Crystal Report for Travel and Expenses per user's new requirement
• Processed weekly, monthly, and quarterly interfaces and resolved any feed related issues.
• Schedule and maintain job running for application, online page, reporting in process scheduler
• Designed and developed conversion and audit programs to convert into PeopleSoft Contracts, Customers, GL Journals, Purchase Orders, Projects, Budgeting and Item Categories
• Experience with VAT, multi-currency, product/item management, Excel to CI for Project Costing, Contracts Integration with Billing, AR and GL
• Supported the AR upload process, along with payment, maintenance, and transfer worksheets.
• Add additional lines to the Purchase Order
• Add secondary Buyer approval to Purchase Order by client's Change Request
• Set up the Create Bill page, Bill Status page
• Design the generated invoices format
• Walk through with the business functional of Monthly Billing Process
• Configuration of eProcurement, lead UAT testing for shake out
• Validate requisition in eProcurement, set up page configuration with data conversion checking in the table
• Configured LDAP authentication and Troubleshooting LDAP authentication performance related issue
• Production system design/capacity planning/platform certification verification
• Participated in applying patch/bundle/maintenance files
• Integration broker configuration and troubleshooting
• Support the technical team to develop Application Engine program to load data into Project costing
• Converted legacy system data into PeopleSoft application via Excel To CI and application engine programs
• Troubleshooting with data loading, developed scripts to automated American Express K1025 wallet transaction download file processing
• Troubleshoot various system support issue such as duplicate invoice issue, check printing process, user session kick out issue
• Post go-live supporting from techno-functional aspect to the user group
• Strong Experience in nVision and Crystal reporting
• Developed UPK documentation for user training
• Conduct the workshops with power users and documented business requirements
• Using ILT- Instructor Led Training for UAT testers, work with different group of users to walk through the business process with functional training
• Responsible for developing testing procedures to meet business process requirements and solutions
• Handle the tasks of planning testing approaches to solve major business issues
• Conduct the testing followed by the test documentation that created by the lead including function test, UAT, key in transactions and unit test
• Perform responsibilities of developing test case, reviewing and evaluating final test results

Confidential

Functional Consultant

Confidential

• PeopleSoft HCM8.9/HRSM 9.1 Time Labor, Benefit Administration, Payroll for North America, ePerformance
• Analyzed the legacy system on Time Labor/Benefit/Payroll/GL areas, gathered the requirements, reports, processes needed to maintain the routine work for the corporate, compared with PeopleSoft HCM8.9, provided customization analysis and advised necessary changes on the business processes to minimize the amount of customizations
• Designed custom time sheet and scheduler module for Time Labor to meet the business requirements
• Set up foundation tables for PeopleSoft HRSM Benefit/Payroll modules, wrote test plans and test scripts, designed test data, conducted unit/system/regression/integration/performance tests, verified workflows, approval processes and other processes
• Worked on designing the workflow for position request from department chair and escalation to HR department and having it approved from Budget. The system was designed flexible to add approver ad-hoc to fit in the requestor needs
• Worked on Development of Technical And Functional Spec for Payroll and Time Labor Processes
• Experience with HCM Core Configuration including HR, Payroll, and Time and Labor
• Used Change assistant to execute the upgrade activities
• Participated in applying patch/bundle/maintenance files
• Provided data conversion/migration requirement documents and templates for HR/Financial systems
• Communicated with HR users to clean up the data errors, review SQRs and made use of component interfaces to load the data into PeopleSoft
• Modified the Permission lists, Roles to meet the upgrade system navigation and customization
• Running the reconciliation report for Time Labor, Benefits, Payroll modules to help client review their data
• Validating the benefit plans and family coverage and dependent information from their HR files and cross-validation with vendors for billing purposes
• Reconfigured Benefits system extensively to correct, update, and streamline Base Ben and Ben Admin design and return client to delivered and best practice state.
• Created job aids, user procedures for every Benefits process. Assisted with Organizational Planning and Change Management to better support Ben.
• Created functional spec for e-performance and manager dashboard and how documents created for period for group 11 and 12 employees and approval process for evaluation through reviewer and HR admin before updating the person profile
• Created functional spec on keeping the person profile and non-person profile in sync using batch process. The job specific, core competency and licensure were automatically updated for employees based on their job profiles
• Help user validate the courses available under each activities and how they are tied to each role during initial training roster for HR. Also help configuring the learner group based on their job and departments
• Apply and validate of Tax update
• Worked on building PS queries and security for users on ad-hoc reports
• Re-tested the processes and reports, conducted UAT tests and user training, worked with PeopleSoft admins to resolve issues
• Assigned responsibilities of coordinating with end users to identify issues to develop best testing techniques to improve the system
• Performed the tasks of testing the functionality and perform customization of component parts
• Handled responsibilities of writing test case, test result, and test traceability matrix
• Responsible for setting up functional systems as well as perform comprehensive system testing
• Assigned responsibilities of assisting senior tester in developing and implementing standard testing procedures for improvements

Functional Consultant

Confidential

• PeopleSoft HCM/Campus solution 9.0 Student Administration included Student Records, Campus Community, Student Financials, and Financial Aid
• Functional consultant in the core team and directing the project teams in-terms of business processes, gathering requirements on Implementation and post production support
• Involving in Fit-Gap analysis and Functional Design Documentations for Student Administration module
• Developing PeopleSoft HCM/Campus Solution 9.0 to offer comprehensive solutions to manage client's business processes requirements
• Collaborate and share knowledge including demonstrating functionality and expertise to educate internal/campus clients
• Documenting and sharing tools, tips and knowledge within and across teams and expanding customer support expertise
• Contribute knowledge and process improvement including posting and reviewing with internal/campus client's helpful documentation for SME and recommendations for process/procedure improvements
• Lead the test planning and write test script and cases for UAT testers
• Review the defect for SIT and UAT testing, work with dev team manager for debugging and retesting, response to sign off on behalf of QA for the project
• Implementing various custom business processes related Online Page, Event managements, Application Evaluation process, Course Catalog, Class search and Advisor Assignment and Major Advancement processes.
• Conduct the regression test for PS Upgrade/Patches/Bundle Fixes/Compares and project Migration operations
• Designed various Interfaces/Batch process through App Engine, SQR programs and several online customizations through People code and CIs
• Conduct Training programs for the team from functional prospect of PeopleSoft and Project Management

Confidential

Functional

• PeopleSoft HRSM 8.9 Time Labor, Absence management, Payroll, Recruiting
• Responsible for functional design, data mapping, configuring job competencies and other functional roles
• Involved in design, development, testing, and enhancement of PeopleSoft HRMS for Time Labor, Payroll and Base Benefits modules
• Worked gathering requirements on personal profile section of the employee self-service application where employee can be able to update their personal information Name, Email and phone numbers and emergency contact
• Set up foundation table for Time Labor, Base Benefits and Payroll
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
• Configuration and troubleshooting for Benefits module
• Running the reconciliation report for core HR, Benefits, ELM and profile management E-performance modules to help client look-up their data
• Involved in online changes to the delivered pages, components, menus and translate values
• Validating the benefit plans and family coverage and dependent information from their HR files and cross-validation with vendors for billing purposes
• Created functional spec on training to keep their training completion
• Worked on interface programs for migrating data from other systems to PeopleSoft
• Applied 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
• Writing the test case, test plan and conduct the UAT test with HR director and Testing manager

Confidential

Functional Consultant

• PeopleSoft Financials 9.0 AP, AR, Expenses, Purchasing, Billing, Grant, Cash
• Design develop conceptual solutions addressing business requirements
• Creating and reviewing functional and technical specifications, project schedules, documentation and test plans
• Work with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives
• Conducted interviews with key business users to collect requirements and business process information
• Perform extensive requirement analysis including data analysis and gap analysis
• Designed and coordinated the development of control reports for validating AR converted data. Analyzed and resolved conversion issues related to AR and vendor consolidation
• Developed new crystal report for the AP Self Billing Invoice
• Designed and coordinated development of post conversion validation queries for identifying any missing conversion data in AP
• Researched and resolved a Voucher posting issue related to Group vouchers not posting after initial post and unpost operations
• Complete the functional design of the Grants module and functional documentation
• Partner with internal client users to ensure effective knowledge transfer related to the delivered features in the Grants module
• Made changes to online Bill entry pages. Changes included adding additional pages Custom pages specific to client to the existing Bill entry Component
• Documented requirements associated with the reporting and paying employee travel and entertainment expenses
• Developed and Created SQR reports, Crystal reports for purchasing module
• Performed a business process improvement review of Purchasing practices and procedures to reduce requisition to dispatch time by making better use of PeopleSoft functional features
• Used PS Query with Crystal Reports and PS/nVision to create and run multiple layouts and reports
• Support to developers with Unit testing and Integration Testing the Interfaces and Processes and created the Test Scripts
• Design and develop Test cases to check module functionality as well as interaction between modules