SUMMARY:

• 8+ years of PeopleSoft experience in various industries, including banking, healthcare, insurance, software consulting & services, etc.
• Strong working knowledge in functional design, development, testing, data mapping, system integration, implementation, and upgrade of software as a PeopleSoft functional consultant
• Participates in all levels of Systems Development Life Cycle (SDLC) of PeopleSoft projects, including fit/gap analysis, system design, development, testing, implementation, troubleshooting, and production support
• Expertise in PeopleSoft FSCM (GL, AP, AR, Asset Management, eProcurement, Project Costing, Contracts, Purchasing, Grants, Inventory, Billing, and Expenses), HCM (Payroll, Time and Labor), and ELM
• Solid working experience of RDBMS (Relational Data Base Management System)
• Extensively involved in developing QA test plan, test conditions, and test cases based on system specifications
• Expertise in SIT/UAT, regression, system integration, and data conversion testing using Agile/Waterfall methodology on PeopleSoft applications
• Strong documentation and presentation skills. Develop various functional and technical specs with test plans and procedures to ensure quality standards of projects
• Self - motivated team player and fast learner with excellent communication skills, has clear understanding of business procedures and ability to work as an individual as well as a part of a team.

TECHNICAL SKILLS:

Application Modules: PeopleSoft FSCM 8.9/9.1/9.2; PeopleSoft HCM 9.1; PeopleSoft ELM 9.1/9.2

PeopleTools: Application Designer, Process Scheduler, Application Engine, Component Interface, Configuration Manager, Change Assistant, Data Mover, Tree Manager, Workflow, Process Scheduler, Integration Broker, File Layout

Reporting Tools: PS Query, Crystal Reports, PS/nVision

Operating System: Windows, Unix

Languages: SQL, Shell Script

Tools: SQL Developer, UPK

RDBMS: Oracle, MS SQL Server, MS Access

Application Servers: Web Logic, Tuxedo

PROFESSIONAL EXPERIENCE:

Confidential, Sylvania, OH

Functional Consultant

Environment: PeopleSoft FSCM 9.2, PeopleTools 8.53; PeopleSoft FSCM 9.1, PeopleTools 8.52

Responsibilities:

• Conducted fit/gap analysis to gather business requirements and to create functional/technical design specifications
• Created test scripts and test cases based on business processes
• Prepared unit, system, and integration test cases between GL and other PeopleSoft applications, such as Account Receivable, Account Payable, Billing, Inventory, Project Costing, Asset Management, eProcurement, etc.
• Participated in creating portal test cases based on user requirements
• Worked with security team to implement security in various levels creating roles permission lists, user profiles, and portal security
• Worked with business users and technology partners to analyze their needs, get feedbacks, and obtain sign-offs
• Participated in designing and implementation of online journal entry template and validation checks for online journal entries
• Coordinated between business users and technical staff and discussed new requirements across the business
• Created nVision Balance Sheet reports. Modified and maintained Income Statements, Trial Balances, and Cash Flow statements
• Data mapping and conversion from legacy systems to PeopleSoft system
• Participated in PeopleTools upgrade from by applying patch/bundle/maintenance
• Troubleshoot various system support issues, such as inconsistent printing of vendor part number and user session kick-out
• Assisted users in suspense journal corrections
• Assisted security team to manage Chart fields security
• Reviewed and evaluated final UAT test results and obtained sign-offs from various business units
• Developed UPK documentation for user training
• Worked with Oracle support on various system issues found during system upgrade

Confidential, Smithfield, RI

Functional Consultant

Environment: PeopleSoft ELM 9.2, PeopleTools 8.53; PeopleSoft HCM 9.1, PeopleTools 8.52

Responsibilities:

• Worked with technical team to prepare SIT/UAT environments for ELM 9.2 Image 6 application testing
• Reviewed compare report for customization
• Conducted fit/gap analysis and developed test scripts for ELM 9.2 PUM Image 6 application
• Discussed with stakeholders and business users regarding individual customization in PeopleSoft ELM 9.2 system and followed SDLC for the feature implementation
• Worked with business line to obtain sign-offs for UAT testing
• Gathered requirements for development process, determining which requirements were the highest priority for implementation and developed test plan using Agile methodology
• Performed data conversion, testing, and cleanup for catalog setup, class enrollment, and program registration for PeopleSoft ELM 9.2
• Supported SCORM 1.2, AICC, and SCORM 2004 content loading and worked with content development team and vendors for content issues
• Troubleshot PeopleSoft ELM and HCM integration issues related to job and personal data
• Provided resolutions and suggestions to fix errors in the delivered product. Worked with Oracle support team on issues.
• Trained business on how to use delivered functionality to achieve their business needs
• Participated in the go-live process, and performed post-production support

Confidential, Philadelphia, PA

Techno-Functional Consultant

Environment: PeopleSoft FSCM 9.1, PeopleTools 8.52

Responsibilities:

• Responsible for preparing functional/technical design specifications and data mappings in GL, AP, Billing, AR, Asset Management, Grants, Purchasing, Project Costing modules
• Conducted fit/gap analysis and configuration
• Gathered all requirements & created design specifications for a full turn around start to finish interface
• Designed & tested CI for 3rd party purchasing portal. Interfaced invoices, vendors & GL accounts within compliance chart of account values
• Processed journals, open item accounting, financial consolidations, entry events, journal entry approvals, etc.
• Integration of General Ledger with Asset Management, Grants, Purchasing, Project Costing, and Accounts Payable
• Modified the GL Balancing Crystal Report for travel and expenses per user’s new requirements
• Integration Broker configuration and troubleshooting
• Conducted data conversion between legacy system to PeopleSoft application via Excel to CI and application engine programs
• Troubleshot various system support issues, such as duplicate invoice issue and user session kick out issue
• Developed UPK documentation for user training
• Responsible for developing testing procedures to meet business process requirements and solutions

Confidential

Environment: PeopleSoft ELM 9.1, PeopleTools 8.52

Responsibilities:

• Provided expertise and operational knowledge to help conduct fit/gap analysis
• Assisted in the identification and evaluation of system configuration and business process choices to help make the best practice decisions
• Set up classes & courses, troubleshot content launching and learner group issues
• Integrated and troubleshot ELM and PeopleSoft HCM 9.1
• Performed data importing, data mapping and verification/validation for class enrollment and program registration
• Worked on Question Mark Tool for creation and configuration of assessment and surveys for various courses in ELM
• Assisted in identifying customization, interface, report, and conversion requirements
• Worked on workflow designs and implementations
• Maintained and assigned roles and permission list to the ELM end users
• Worked on PeopleSoft ELM course listing for department manager and update the status so that the courses could be completed and notifications are sent out
• Acted as the second level of support to assist field learner questions related to the system, customer application and system problems
• Assisted in production system design/capacity planning/platform certification verification
• Acted as a liaison between technical and business teams
• Participated in SIT/UAT testing for PeopleSoft ELM
• Developed test plan and test scripts for all testing stages and UPK documentation for user training
• Prepared documentation for training for managers and end-users

Confidential, Philadelphia, PA

Techno-Functional Consultant

Environment: PeopleSoft HCM 8.9/9.1, PeopleTools 8.49

Responsibilities:

• Comparison of data, checking data integrity between the third party system and the Oracle database
• Created new pages and records in job data to accommodate change supervisor process
• Designed custom time sheet and scheduler module for the Time & Labor to meet the business requirements
• 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
• Provided data conversion/migration requirement documents and templates for HR/Financial systems
• Communicated with HR users to clean up the data errors and made use of CI to load the data into PeopleSoft
• Modified the permission lists and roles to meet the upgrade system navigation and customization
• Ran the reconciliation report for Payroll and Time & Labor modules to help client review their data
• Validated 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 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
• Worked on building PS queries and security for users on ad-hoc reports
• Re-tested the processes and reports, conducted UAT testing and user training, worked with PeopleSoft admins to resolve issues
• Assigned responsibilities of coordinating with end users to identify issues to develop the best testing techniques to improve the system
• Assigned responsibilities of assisting senior testers in developing and implementing standard testing procedures for improvements

Confidential, Atlanta, GA

Functional Consultant

Environment: PeopleSoft FSCM 8.8/8.9, PeopleTools 8.4x

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed, and documented business requirements based on the analysis of accounting processing workflow model functioned as the primary liaison between the business line, operation, and the technical team throughout the project cycle
• Provided functional specification to development team to build Enterprise Reporting Systems
• Assisted with product evaluation, product customization, and system integration
• Responsible for preparing technical design specifications, prepared data mappings, developing and testing interfaces in GL, AP, AR, Project Costing, Asset Management, Billing and Inventory modules
• Generated invoices and accounting entries and loading the pending items and updated the customer balances
• Processed journals, open item accounting, financial consolidation, entry events and journal entry approvals
• Supported the production team for development of the customized payment pages
• Prepared test scripts for various reports and interfaces and executed them
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be converted in scripts and tested properly
• Assisted client in developing content and training materials; recommended enhancements, and identified new business requirements