Functional Consultant Resume
Baltimore, MD
SUMMARY
- More than fourteen years of experience in PeopleSoft HRMS and HCM applications (7.0 - 9.1) full life cycle implementation as well as upgrades. Working knowledge in PeopleSoft HCM 9.2.
- Expertise and responsible for providing consulting service to support all aspects of HCM systems implementation including requirements gathering, performing Fit/Gap Analysis, application design documentation, process flow using Visio and Microsoft tools. application configuration and implementation, mentoring and training, third party integrations and project management
- Workshop Presentations in the use of MS Office Suite including: Word, Excel, PowerPoint, and Visio
- Developed functional and testing design templates for different clients.
- Created functional designs documents for RICEFW/CEMLI objects.
- Worked with technical team and user community
- Worked independently as well as in a team
- Used UPK tool for business process documentation, testing, training, and performance
- Created test plans and test scripts. Involved in SIT & UAT testing and moved to production database
- Over Sixteen (16) years’ experience working as PeopleSoft HCM Functional Consultant.
- Strong experience working on Core HR, Payroll, Time and Labor, Benefits, ePerformance, Compensation, Position management & Commitment Accounting, ESS and MSS.
- Strong experience on PeopleSoft HCM implementation, upgrade, enhancement and support
- Strong experience working with Higher Ed, K12, City/County, Medical/Pharma, Food, Stationary, Insurance, Harbors, Energy and Auto Mobile Industries.
- Worked with Higher Educations Clients like Confidential & Confidential . Confidential and Confidential .
TECHNICAL SKILLS
PeopleSoft Modules: HR, Administer Workforce/MSS and ESS/eProfile, Compensation/eCompensation, Payroll/ePay, Benefits Administration, Base Benefits/eBenefits, Time and Labor, Recruiting Solutions (Talent Acquisition Manager), Performance Management/ePerformance, General Ledger, Account Payable, Account Receivables, Billing, Asset Management
PeopleTools: PeopleTools I and II, PeopleCode, SQR, UPK (User Productivity Kit)
Database: Oracle, SQL Server, DB2
Operating System: HP-UNIX
Software: MS Office/Visio
Other: Fit/Gap Analysis, Business Process Flow, UAT Testing
PROFESSIONAL EXPERIENCE
Confidential, Baltimore, MD
Functional Consultant
ENVIRONMENT: PeopleSoft HCM ( 9.1), PeopleTools (8.51), Oracle (11g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Participated in team meeting with business analysts, technical and functional team.
- Clients existing Lawson system to PeopleSoft
- Created fit/gap design documents for payroll for PTO accruals and salary Accruals.
- Pay to GL integrations - Given Power point presentations on different process involved in Pay to GL
- Worked on customization on Payroll allocation for setup configurations.
- Created function design on PTO, Salary Accruals and Labor Distribution reports
- Worked on Time sheets and time admin process. Approve payable time to payroll
- Run payroll process and post to GL.Integrating TL with Project Costing. Created PS Queries and generated reports.
- Participated in team meetings with EIT, Business owners and user communicated.
- Involved in gathering requirements and created IDP work books. The work includes Gap analysis.
- Setup Configuration (Commitment control tables, Department Budget and Encumbrances). Employment data changes, update encumbrance calculations using either the Batch Encumbrance Calculation process or real-time budget checking.
- Create pre-encumbrance and encumbrance transactions for the fiscal year, Creating and Posting Actuals Data to PeopleSoft Financials .
Confidential, Tallahassee, FL
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.9 - 9.1), PeopleTools (8.5), Oracle (11g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Participated in team meetings with EIT, Business owners and user communicated.
- Involved in gathering requirements and created IDP work books. The work includes Gap analysis.
- Setup Configuration (Commitment control tables, Department Budget and Encumbrances). Employment data changes, update encumbrance calculations using either the Batch Encumbrance Calculation process or real-time budget checking.
- Create pre-encumbrance and encumbrance transactions for the fiscal year, Creating and Posting Actuals Data to PeopleSoft Financials .
Confidential, Boca Raton, FL
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.9 - 9.1), PeopleTools (8.5), Oracle (11g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Perform fit/gap analysis and create functional design documents
- Given Power Point Presentation on AWE (Approval Workflow Engine) to the client
- Setup Configurations in Direct reporting, Org Chart, Alerts, Manager Dashboard. AWE for Employee Promotions & Transfers.
- Created Worklists and email notifications. Approval transactions are performed through second level managers
- Performed Approval Work flow transactions through AWE
- Performed MSS Transactions for Report Change, Full Part Time.
- Created Test plans and Test scripts. Data is validated against Employee Job Data
- Expertise in using HPQC for updating transactions and defect catalogues Base, Variable Compensation, Compensation & eCompensation:
- Created setup Compensation tables, running compensation cycles.
- Setup AWE for Allocate Compensation.
- Performed Approval work flow process for Allocate Compensation upon available funding. Drill down direct line reports.
- Performed Request, Approval and View - Ad Hoc Salary change transaction through regular work flow.
- Setup Configuration for ePerformance - Template definition, Section Definitions, Document type, text Catalogue.
- Loaded third Party Competencies (Lominger) into Content items for Profile Management.
- Setup AWE for ePerformance. Created Work lists and email notifications
- Created Employee performance documents and self-evaluations.
- Making manager and other Manager evaluations.
- Performed Manager Evaluation and Approvals through AWE
- Employee performance rating integrated with Allocate compensation
- Preformed Integration testing & UAT testing
- Created test plans and test scripts. Performed Data validations
- Performed SIT & UAT testing and moved to production
Confidential, Melville, NY
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.0 - 9.1), PeopleTools (8.5), Oracle (11g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Perform fit/gap analysis and create functional design documents. HR & job code tables, Job earnings
- Define Comp rate. Setup Base Compensation (Salary Plan, Grade & Steps) Funding salary plans for Merit & Bonus. Ad Hoc salary change. Setup VC Plan, Individual payout, process eligibility and proration. Process annual bonus and merit compensation
- Involved in setup configuration for position data, salary and compensation, and commitment accounting (Budgeting)
- Positions are FTE and budget approvals, and rehire.
- Setting up Commitment accounting integrating with General Ledger
- Perform fit/gap analysis and create custom designs for HR, payroll data, rate codes, salary plan, salary grade, step, and job code tables
- Involved in giving resolutions and fixing errors during the payroll process, retro pay processing, W-2, pay stubs, transferring payroll data to GL interface, and processed leave accruals
- Create functional design for outbound interface garnishments to account payable; ePay transactions viz., direct deposit; voluntary deductions for employee access though self-service
- Review the Payroll to Accounts Payable integration. Coordinate with Financials Consultant and Technical Consultant to resolve issues.
- Involved in fit-gap analysis, identifying benefit deduction codes, setting up Benefit Plans, flexible credits, Even Class definition.
- Setting benefits billing and retroactive benefits. Running to process Event maintenance and Open Enrollment. Validating Elections.
- Created functional designs for different interfaces for different health providers, Pension ACS & 401K.
- Create test plans, test scripts, and move to production
- Create functional design documents configuration workbook, test plans, and test scripts for all modules
- Involved in setting up configurations
- Create custom page modifications as per customer request, as well as created SQL scripts and PeopleSoft queries using Query Manager (web). Used SQL Plus & TOAD tools.
- Familiar in using App. Designer (8.52)
- Create designs for workflow and setup configurations and direct reporting
- Manager Self-service - involved in workflow approval, setup work lists, and email notification
- Perform testing so data could be validated online as well as batch objects; complete gathering requirements
- Perform fit/gap analysis; compiled business process documentation; conduct training and development
Confidential, Omaha, NE
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.0 - 9.1), PeopleTools (8.5), Oracle (10i), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Performed gathering requirements, set up configurations for HR core tables which include job codes, action and action reason codes and union codes
- Administered compensation cycles; defined compensation rates and rules and set up rate codes
- Setup Configuration (Commitment control tables, Department Beget and Encumbrance). Employment data changes, update encumbrance calculations using either the Batch Encumbrance Calculation process or real-time budget checking.
- Create pre-encumbrance and encumbrance transactions for the fiscal year, Creating and Posting Actuals Data to PeopleSoft Financials.
- Involved in gathering requirements and setting up configuration tables for payroll module
- Involved in setting up configurations and conversions. Performed payroll and garnishment process
- Involved in setting up retro-pay for employees missing payments. Involved in processing garnishments
- Involved in data mapping, loading into tables. Performed analysis, created fit/gap documents
- Created Configuration Workbook. Set up billing parameters and process payments
- Created SQL scripts and PeopleSoft queries using Query Manager
- Created Custom SQL and used TOAD. Familiar in using App. Designer for building records and Pages.
- Performed testing so data could be validated online as well as batch objects
- Gathered requirements. Created test plans and test scripts. Compiled Business Process Documentation
- Conducted training and development. Created designs for workflow and setup configurations and direct reporting
- Manager Self-service - involved in workflow approval, setup work lists and email notification
Confidential, St. Louis, MO
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM (9.1) PeopleTools (8.51), Oracle (11g), Windows/NT, UNIX, Business process documentation, Training and Development, Visio, Microsoft Office.
Responsibilities:
- Involved in gathering requirements, performed fit/gap analysis; created configuration workbook for setting up HR core tables
- Created workflow configurations for self-service modules WF transaction and direct reporting
- Performed fit-gap analysis created functional design documents. Involved in Set up Configures for Position Data, Salary & Compensation, and Commitment Accounting (Budgeting). Positions are FTE and budget approvals, processing rehire. Setting up GL interface for Commitment Accounting (Combo Codes from HCM GL to Financial GL) and Time & Labor
- Setting up configurations for compensation and variable compensation, plan memberships control tables, rate codes, salary plan, salary grade, step, job code; managers can review or verify the worker’s compensation history, ad-hoc salary change, and budgeted salary change; eCompensation integrated with HR and stock administration
- Created Compensation workbook, created test plans and test scripts; Created PS Query (Query Manager); the SQL data is validated against online pages
Confidential, Ft. Myer, FL
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HCM upgrade (9.0), PeopleTools (8.5), Oracle (11g), Business process documentation, Training and Development, Visio, Microsoft Office.
Responsibilities:
- SME in PeopleSoft HCM applications
- Gathering requirements, performing fit/gap analysis; created functional documents
- Setup configurations for organization foundation tables, job code, job profiles and compensation tables
- Involved in data mapping and conversion to PeopleSoft Data Personal, job and employment and additional data
- Involved in set up configures for position data, salary and compensation, and commitment accounting (Budgeting); positions are FTE and budget approvals, processing reappointments
- Setting up GL interface for commitment accounting
- Created SQL using TOAD. Used App. Designer for Custom records and pages.
- Created test plans, test scripts and moved to production
- Able to review PeopleCode and SQR program code; actively involved in team meetings for fit/gap sessions; created fit/gap documents, gap solutions and creating functional design to support CEMLI development
- Used UPK tool for business process documentation, testing (Testing Director and Win Runner), training and performance
Confidential, Ft. Worth, TX
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HCM (8.9), PeopleTools (8.46), Oracle (11g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Involved in identifying fit/gap analysis of Cardinal Health Legacy System ADP-PCPW data to PeopleSoft HCM data; setting up configurations for variable compensation control tables, rate codes, salary plan, salary grade, step, job code tables; loaded Excel data files into PeopleSoft tables using component interface
- Setup Configuration (Commitment control tables, Department Beget and Encumbrance). Employment data changes, update encumbrance calculations using either the Batch Encumbrance Calculation process or real-time budget checking Create pre-encumbrance and encumbrance transactions for the fiscal year, Creating and Posting Actuals Data to PeopleSoft Financials .
- Created test plans, test scripts and moved to production
- Workflow: created functional designs for workflow and setup configurations and direct reporting
- Manager self-service - involved in workflow approval, setup work list and email notification; good technical knowledge in workflow business process
- Application data validations performed on on-line as well as batch processes
- Created test plans and test scripts; involved in UAT testing and move to production database
- Used UPK tool for business process documentation, testing (Testing Director and Win Runner), training and performance
Confidential, Chicago, IL
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HCM Upgrade (8.8 - 8.9), PeopleTools (8.48), Oracle (10g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Created functional designs for inbound and outbound interfaces to external system. Created data mapping scripts for conversions. Involved in setting up partial position to maintain positions
- Created functional designs for workflow activities for new hire, terminations, rehire, promotions, pay rate, location change and service awards. Setup workflow configurations sending approvals and notifications. Involved in self-service workflow configurations. Review transaction activities and direct reporting
- Setting up configurations for variable compensation control tables, plan memberships, rate codes, salary plan, salary grade, step, job code tables; involved in compensation history and salary change
- Involved in recruiting business process flow for Talent Acquisition Manger; setting up recruiting process, status, Third Party Integration, and work flow on approvals and notifications; involved in following tasks online registration, job search for job opening, uploading resume, submit attachments, references, and interview schedules using Candidate Gateway; created test plans, test scripts and moved to production
- Created ad-hoc SQL using TOAD. Used App. Designer for Custom records.
- Involved in trouble shooting for production support and re-applying customization and testing; created test scripts, performed unit testing and moved from development to production
- Used UPK tool for business Process documentation, testing (Testing Director and Win Runner), training and performance; application Data validations performed on on-line as well as batch processes; created test plans and test scripts; involved in UAT testing moved to Production environment; involved in the full upgrade SDLC implementation of PeopleSoft HCM (8.9)
Confidential, Miami, FL
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HCM (8.9), PeopleTools (8.46), Oracle (10g), Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Participated in gathering functional requirements; setup positions (partial and full) and assign positions to the employees; maintain position data and establishing departmental position budgets
- Setup Commitment Control tables. Process encumbrances. Integrates with General Ledger
- Load time and labor data, such as payable time, from the PeopleSoft Enterprise Time and Labor application to pay sheets for processing; load refund information and tax data from the PeopleSoft Enterprise Stock Administration application to pay sheets for processing; load approved employee advance and expense reimbursement amounts from the PeopleSoft Enterprise Expenses application to pay sheets for processing
- Administer COBRA (Consolidated Omnibus Budget Reconciliation Act) coverage for qualified participants and their dependents; process retroactive benefits and deductions; send enrollment data to third-party administrators
- Involved in gathering Participating in PCD workflow; recruitment solutions; setup security role users and permission lists; created and given presentations on PeopleSoft workflow and security to the client; participated in gathering functional requirements; setup positions (partial and full) and assign positions to the employees; maintain position data and establishing departmental position budgets; workflow: created functional designs for workflow activities for new hire, terminations, rehire, promotions, pay rate, location change and service awards; setup workflow configurations sending approvals and notifications; involved in self-service workflow configurations; review transaction activities and direct reporting
- Created test plans and test scripts; performed UAT and moved to production; involved in compare and fit/gap analysis, created functional designs for Vanilla and Customer Application; created PS Query to run ad-hoc reports; created test scripts and performed Unit Testing; application data validations performed on on-line as well as batch processes
- Involved in the implementation of SDLC for PeopleSoft HCM Upgrade (8.8)
Confidential, Kansas City, MO
Senior PeopleSoft Functional Consultant
ENVIRONMENT: PeopleSoft HCM Upgrade (8.3 - 8.8), PeopleTools (8.44), Oracle, Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Upgraded HR, Benefits and North American Payroll Modules, Created ad-hoc SQL using TOAD
Confidential, Dearborn, MI
Senior PeopleSoft Functional Analyst
ENVIRONMENT: PeopleSoft HRMS (8.3), PeopleTools (8.14), Oracle, Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Worked on enhancements, Implemented HR, Benefit and North American Payroll Modules.
Confidential, Orlando, FL
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HRMS (8.3), PeopleTools (8.14), Oracle, Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Implemented HR, North American Payroll, Benefits and Time & Labor Modules
Confidential, Irwin, TX
Senior PeopleSoft Functional Analyst
ENVIRONMENT: PeopleSoft HRMS Upgrade ( ), PeopleTools (8.12), Oracle, Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Upgraded HR, Benefits and North American Payroll Modules
Confidential, Ann Arbor, MI
Senior PeopleSoft Functional Analyst
ENVIRONMENT: PeopleSoft HRMS (7.5), PeopleTools (7.5), Oracle, Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Implemented HR, North American Payroll, Benefit Administration, Time & Labor Modules
Confidential, Toledo, OH
PeopleSoft Functional Analyst
ENVIRONMENT: PeopleSoft HRMS (7.0), PeopleTools (7.0), Oracle, Business process documentation, Training and Development, Visio, Microsoft Office
Responsibilities:
- Implemented HR, Payroll and Benefit Modules