Functional Consultant Resume
Baltimore, MD
SUMMARY:
- More TEMPthan fourteen years of experience in PeopleSoft HRMS and HCM applications (7.0 - 9.1) full life cycle implementation as well as upgrades
- 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, third party integrations and project management
- Workshop Presentations in teh 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 wif technical team and user community
- Worked independently as well as in a team
- Used UPK tool for business process documentation, testing,, and performance
- Created test plans and test scripts. Involved in SIT & UAT testing and moved to production database
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 me 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, and Development, Visio, Microsoft Office
Responsibilities:
- Participated in team meeting wif 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 wif Project Costing.
- Created PS Queries and generated reports.
- Participated in team meetings wif EIT, Business owners and user communicated.
- Involved in gathering requirements and created IDP work books. Teh work includes Gap analysis.
- Setup Configuration (Commitment control tables, Department Budget and Encumbrances). Employment data changes, update encumbrance calculations using either teh Batch Encumbrance Calculation process or real-time budget checking.
- Create pre-encumbrance and encumbrance transactions for teh fiscal year, Creating and Posting Actuals Data to PeopleSoft Financials .
- Involved in gathering requirements and created IDP work book for Time and Labor. Performed gap analysis. Identifying teh differences in TRC and work group and Taskgroups. Processing Reporting and Payable time through approval process for different employee categories. Running payable status reports. Creating PS Queries.
Confidential, Tallahassee, FL
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.9 - 9.1), PeopleTools (8.5), Oracle (11g), Business process documentation, and Development, Visio, Microsoft Office
Responsibilities:
- Participated in team meetings wif EIT, Business owners and user communicated.
- Involved in gathering requirements and created IDP work books. Teh work includes Gap analysis.
- Setup Configuration (Commitment control tables, Department Budget and Encumbrances). Employment data changes, update encumbrance calculations using either teh Batch Encumbrance Calculation process or real-time budget checking.
- Create pre-encumbrance and encumbrance transactions for teh fiscal year, Creating and Posting Actuals Data to PeopleSoft Financials .
- Involved in gathering requirements and created IDP work book for Time and Labor. Performed gap analysis. Identifying teh differences in TRC and work group and Taskgroups. Processing Reporting and Payable time through approval process for different employee categories. Running payable status reports. Creating PS Queries.
Confidential, Boca Raton, FL
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.9 - 9.1), PeopleTools (8.5), Oracle (11g), Business process documentation, 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 teh 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 cataloguesBase, 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.ePerformance:
- 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 wif 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, 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 wif General Ledger North American Payroll:
- 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 teh 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 teh Payroll to General Ledger Interface configuration and business process. Troubleshoot issues wif teh integration as well as teh creation of HR Accounting Lines. Re-test integration.
- Review teh Payroll to Accounts Payable integration. Coordinate wif Financials Consultant and Technical Consultant toresolve 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 and development
Confidential
Functional Consultant
ENVIRONMENT: PeopleSoft HR/HCM upgrade (8.0 - 9.1), PeopleTools (8.5), Oracle (10i), Business process documentation, 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 teh Batch Encumbrance Calculation process or real-time budget checking.
- Create pre-encumbrance and encumbrance transactions for teh 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
- Gatheird requirements
- Created test plans and test scripts
- Compiled Business Process Documentation
- Conducted 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, 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 Compensation, Variable Compensation and eCompensation:
- Setting up configurations for compensation and variable compensation, plan s control tables, rate codes, salary plan, salary grade, step, job code; managers can review or verify teh worker’s compensation history, ad-hoc salary change, and budgeted salary change; eCompensation integrated wif HR and stock administration
- Created Compensation workbook, created test plans and test scripts; Created PS Query (Query Manager); teh 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, 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 dataPosition Management and Commitment Accounting:
- 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 Talent Acquisition Manager & C
- 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), and performance
Confidential, Ft. Worth, TX
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HCM (8.9), PeopleTools (8.46), Oracle (11g), Business process documentation, 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 teh Batch Encumbrance Calculation process or real-time budget checking Create pre-encumbrance and encumbrance transactions for teh 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), and performance
Confidential, Chicago, IL
Senior Functional Analyst
ENVIRONMENT: PeopleSoft HCM Upgrade (8.8 - 8.9), PeopleTools (8.48), Oracle (10g), Business process documentation, 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 s
- Setup workflow configurations sending approvals and notifications. Involved in self-service workflow configurations
- Review transaction activities and direct reportingPosition Management & Commitment Accounting:Compensation (Variable Compensation and eCompensation (MSS and ESS):
- Setting up configurations for variable compensation control tables, plan s, rate codes, salary plan, salary grade, step, job code tables; involved in compensation history and salary change Talent Acquisition Manager, Candidate Gateway and eRecruit:
- 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, s, 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), 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 teh 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, and Development, Visio, Microsoft Office
Responsibilities:
- Participated in gathering functional requirements; setup positions (partial and full) and assign positions to teh employees; maintain position data and establishing departmental position budgets
- Setup Commitment Control tables. Process encumbrances. Integrates wif General LedgerNorth American Payroll:
- Load time and labor data, such as payable time, from teh PeopleSoft Enterprise Time and Labor application to pay sheets for processing; load refund information and tax data from teh PeopleSoft Enterprise Stock Administration application to pay sheets for processing; load approved employee advance and expense reimbursement amounts from teh PeopleSoft Enterprise Expenses application to pay sheets for processingBenefits Administration & eBnenefits:
- 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 teh client; participated in gathering functional requirements; setup positions (partial and full) and assign positions to teh 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 s; 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 teh implementation of SDLC for PeopleSoft HCM Upgrade (8.8)