Functional Consultant Resume
Ann Arbor, MI
SUMMARY
- Techno Functional Consultant with over 11+ years of consulting, business analysis, project management and development experience with concentrated effort in implementing and upgrading PeopleSoft HCM, Benefits, Payroll, Time and Labor, Performance Management and Enterprise Learning Management (ELM) areas for various industries including Education, Retail, Public Sector (State Governments), Oil & Gas.
- Experienced in all aspects of full life cycle implementations including Project Management, Assessments, Fit/Gap Analysis, Conversion, System Design, Training, Testing and Deployment and has lead implementation teams on multinational projects.
- Consistently demonstrated effective teamwork, performance and focus on quality client services and has been recognized for ability to analyze client requirements and provide optimum solution and implement them efficiently with in time and budget.
- 10+ years of Techno - Functional experience in various modules of HCM (Core HR, Payroll, T&L, Compensation, ePerformance and Absence Management) and ELM.
- Involved in PeopleSoft Implementations/Support/Integration/Upgrade projects in 9.X and 8.X versions.
- Experienced in Fit-Gap analysis, planned and conducted multiple Fit-Gap sessions.
- Worked on Fluid User Interface, Custom Fluid Pages, Components, and Custom Tiles using Navigation Collections.
- Extensive experience in customization, implementation, and upgrades of PeopleSoft HRMS/HCM including Human Resource, NA Payroll, T&L, MSS, ESS, Benefits, Benefits Administration, TAM & CG and PeopleSoft e-Modules (e-Recruit/, e-pay, e-Performance, e-Profile Employee/Manager Desktop, e-Benefits).
- Work collaboratively with cross-functional project teams within Finance, HR, ELM and IT organizations by establishing a strong relationship the end user-committee and the team members.
- Expert in designing Interfaces with legacy and third-party systems.
- Knowledge of implementing Position Management with fluid interfaces and classic interfaces.
- Extensively worked with Security Administrator to implement security in various levels for creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security.
- Conducted interviews with Subject Matter Experts (SME) to examine end user job responsibilities and module functionality to identify training needs
- Designed several training programs for training the end users for both new implementations and system updates.
- Conducted several UAT workshops involving Business users, Development team and QA team.
- Strong working noledge in all types of testing like Unit testing, Integration/System testing, User Acceptance testing, Regression testing, Smoke testing and parallel testing.
- Well versed with project development life cycle, System Business Process Analysis, Requirements Study, Fit-Gap Analysis and Post-Implementation support.
- Expert in creating documents and keeping them updated throughout the project lifecycle.
- Advised and trained users for creating reports using PS Query tool and PLSQL.
- Experience in creating Business Requirement Documents (BRD) dat will be handed over to the developers to create new customizations after user approval.
- Experience using MS Project and JIRA to create project plans and track progress.
- Experience with people tools, Integration Broker, Workflow, Application Messaging, WebServices, AWE, XML, SOAP.
- Worked as a liaison between the business users and Oracle team and as Liaison between the HR and ELM business users to define and maintain business processes and compares with PeopleSoft system to determine functionality gaps and work with designated personnel to identify appropriate changes in the business processes and/or required software modifications.
TECHNICAL SKILLS
ERP: PeopleSoft HRMS 8.9 & HCM 9.0, 9.1, 9.2, PeopleSoft ELM 9.0, 9.2
People Tools: Application Designer, Application Engine, Application Packages, Application Messaging, Integration Broker, Peoplecode, PS Query, Security, Data Mover, Process scheduler, Configuration Manager, File layout, SQR, People tools versions 8.19, 8.23, 8.52, 8.53, 8.54, 8.55, 8.56, 8.57.
Reporting Tools: PS/Query, Crystal Reports, BI Publisher
Databases & Tools: DB2, Oracle 8.x/9.x/10.x/11i, Data Mover, PLSQL, SQL Plus, TOAD
Hardware & Operating Systems: Windows NT/2000/XP, ScoUnix, Linux
Tools: TOAD, Quest (STAT), AQT, HP Quality Centre, Phire, Captivate, Oracle UPK, Control-M, JIRA
PROFESSIONAL EXPERIENCE
Confidential, Ann Arbor, MI
Functional Consultant
Responsibilities:
- Implement new functionality within PeopleSoft HCM system.
- Lead the upgrade of Peopletools version 8.57 by providing budgets and timelines.
- Created new Approval Workflow processes with custom roles for ePerformance module Administrators.
- Implemented Time and Labor security configurations and made changes to person and non-person profiles for sup-porting T&L according to new position management rules.
- Created new T&L rules for opening of new SCC in different states and regions including Canada.
- Worked on resolving daily issues to make sure the Time Admin process runs smoothly.
- Integrated PeopleSoft T&L system to Kronos system as a pilot program for Supply Chain centers.
- Created Kronos workforce Genies to display time and attendance information for managers to review and approve.
- Configured shift swapping functionality in Kronos self-service for employees to request for approval from manager.
- Represent Human Resources team in system changes including new interfaces, new modules and system upgrades
- Audit and document security procedures and train users in implementation best practices.
- To conceptualize and develop a global e-Performance solution which accommodates the process requirements of different divisions in the functional areas.
- E-Performance administration including creating /managing documents, templates,, performance calendar, etc.
- Created new events for Absence management for both ESS and MSS transactions.
- Created multiple queries for TAM as per the user requirement in the field to be able to create and approve positions.
- Worked on creating approval process and guided self-service workflows to open a new position.
- Implemented fluid functionality within MSS to include recruiting home page tiles to show applicant lists, interviews, calendars along with Recruiting analytics and made sure the row level security is followed.
- Responsible for Training End-users like Recruiters & Hiring Managers, setting up training session for them and trained them the JOB Opening, JOB Offer & Applicant Process and the Work Flow Approvals.
- Customized the Self-service Applicant Career’s Page to add Endorsements in License & Certificates subpage.
- Customized the Manager self-service to be able to request promotions/transfers within the organization.
- PS Query and PLSQL to create and run queries related to e-Performance and ratings.
- Involved in setting up of Custom Workflow Approvals POC for both Job Opening & Job Offer.
- Involved in customizing the AWE workflow Notifications to be sent to Users (Approvers) by E-Mail.
- Responsible for Training End-users like Benefits Administrators & Payroll Managers in various PeopleSoft processes.
- Assist with designing efficient business processes by configuring system software to leverage vendor capabilities
- Identify and recommend system enhancements to further gain efficiencies or best practices
- Support of Human Resource Information Systems including PeopleSoft HCM, (T&L, Payroll Self Service, Manager Self Service, Variable Compensation, Performance Management, Absence Management)
- Perform root cause analysis for data error scenarios and recommend business process remediation strategies
- Designing & Developing Application Packages in Peopletools, to provide & consume web services using PeopleSoft Integration Broker, SoapUI for developing, Testing XML & SOAP messages.
- Setup earnings and deductions for different pay components and deductions
- Setup Pay Calendars for Weekly/Bi-weekly/Monthly Payrolls.
- Created a new process to opt-in automating W2 generation process to deliver them electronically.
- Worked on implementing new process for Retro payroll to include driver payroll into regular retro payroll process.
- Lead and facilitate business process improvement change. Provide business expertise and input to the design, improvement and overall solution architecture of the Time & Labor and Payroll systems.
- Updated Approval workflows to change the approvals for Absences entered into the system.
- Write payroll interfaces to load additional pay data in to pay sheet
- Do end to end payroll cycles to confirm calculations
- Customize and create new payroll interfaces and reports using Power BI.
- Work with end users and guide the domain team in user acceptance testing
- Participated in applying Tax Updates and fixes
Environment: PeopleSoft HCM 9.2
Confidential, Austin TX
Lead Implementation Consultant
Responsibilities:
- Lead and facilitate business process improvement change. Provide business expertise and input to the design, improvement and overall solution architecture of the HCM Integrations and ELM systems.
- Complete Fit-Gap analysis of the ELM system and identify Gaps and Assist client in creating Functional design documents for the Gaps identified.
- Participated in requirement gathering to implement security changes in PeopleSoft Unified Navigation for HCM, FIN, TAM, Recruiting, Candidate Gateway and ELM
- Develop security architecture for HCM roles and permission lists to implement Unified navigations.
- Implement and track project schedules for security, integrations and customizations.
- Lead off shore development team to deliver customizations in a timely manner while maintaining standards.
- Review Technical Design documents for the FDD and coordinate with offshore resources for development tasks.
- Detailed impact analysis was done to identify the objects, compared between old and new model to retrofit. All customized objects were identified, exported and migrated.
- Designed and implemented new profile management process for implementing row level security in ELM using HCM as the base system.
- Run Full Sync and Incremental Sync between HCM and ELM.
- Create and execute test scripts for testing both the delivered functionality and the customizations in the system.
- Created new process for User Access requests in HCM to align with ELM for the on-boarding agencies.
- Responsible for Security changes in existing HCM and FSCM applications to implement ELM with unified navigation.
- Reviewed work done, identified issues and roadblocks and provided solutions to overcome them and get the project back on track.
- Worked on resolving integrating issues between TAM and HCM/ELM.
- Worked on testing TAM and Candidate gateway integration for assigning courses in ELM based on Job profile.
- Configured AWE process for class approvals from manager when a cost is attached.
- Worked with Content Integration with third party vendors (Skill Soft) and loaded all the catalog into ELM.
- Created web services to open two way communication between PeopleSoft ELM and Skill soft vendor to communicate and update the course completions and launching the courses from PeopleSoft application.
- Provided training and Knowledge transfer to various resources throughout the project.
- Evaluated conversion design and suggested optimum alternatives to load the historical data.
- Worked on creating permission lists and roles for allowing payroll to process retro paychecks.
- Designed and developed data conversion reports and Inbound/Outbound Interfaces to facilitate the transfer of data from Legacy System to PeopleSoft system using Component Interface and Application Engine.
- Involved in resolving the issues related to creating Learner Groups and Query manager.
- Resolved the Issues related to the payroll Error Messages occurred after PAYLOAD Process runs.
- Involved in analyzing the Data Errors dat occurred when off cycle payroll is run and fixed those Issues.
- Extensively used Process scheduler and Control-M for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
Environment: PeopleSoft HCM 9.2, ELM 9.2
Confidential, Jacksonville FL
Functional Consultant
Responsibilities:
- Worked as a PeopleSoft Consultant in implementation/support of HCM 9.2
- Involved in the PeopleSoft Data Conversion Project for Core HR, Benefits and Customizations in T&L, Payroll and Base Benefits Modules.
- Configured and maintained all the tables involved in Payroll processing such as Pay calendar, Job code, Deductions and Processes, Pay-sheet creation, pay calc, pay confirm and Tax tables.
- Modified the Application Engine Process to call Web Services upon hire replacing existing methods, which will up-date the Return-to-work Service date.
- Worked on creating multiple workgroups and task groups for processing Time and Labor rules.
- Involved in the development and customization of on-line pages, record definitions and menus using Peopletools like Application Designer related to HR, Payroll, Benefits, Benefits Admin, Time & Labor.
- Worked on debugging delivered COBOL programs for payroll and made updates to resolve the errors.
- Created a new Military report for fiscal year using XML publisher for different agencies and created a new value list and run control related objects for Time and Labor.
- Designed new Application Engine, Component Interface program in Peopletools to upload employee’s new Compensation rates from input file to Job component in Time and Labor.
- Created PS queries to pull terminated employees for a fiscal year based on the user requirements.
- Involved in fiscal year conversions and rollover processes and developed an application engine process for pay increase to employees with exceptions.
- Involved in execution of off cycle payroll process to create checks for employees who received an incorrect check.
- Produced multiple reports for Benefits, HR and Payroll including customization of reports like leave accrual reports and compensation reports.
- Functional support consisted of gathering system enhancement requirements, documenting change requests, re-searching incident reports, and documenting cost assessments for proposed projects.
- Executed unit test plans for medium complexity batch interface programs for Payroll, Human Resource and Benefits modules.
- Developed and executed Benefits administration (Event Maintenance and Annual enrollment) test cases. Involved in testing quarterly and annual reporting batch processes
- Completed numerous requirements gathering sessions with several business users across the organization to complete above-mentioned design and configuration work.
- Developed Custom Time and Labor Reports including compare Reports, which were extensively used while transferring data from a Third-party system to PeopleSoft Time and Labor.
- Did performance tuning of Receipts Pending and Aging Report by converting Query based BI Publisher Report to XML File based Report.
- Facilitated UAT testing involving the Business users, Development and the QA teams.
- Implementation of HTML Email approval feature for Self-service transactions.
- Developed an Interface to load the Supervisor from HRMS to add or update the User Profile and tan the Re-quester table with employee specific values for Workflow (AWE).
Environment: PeopleSoft HCM 9.2 / CS 9.0
Confidential, Madison, WI
Functional Consultant
Responsibilities:
- Created scope documents for several bolt on customizations.
- Develop and track project schedules for statewide PeopleSoft implementations and also individual schedules for specific agencies by grouping them together based on the requirements and customizations.
- Worked on converting Classic PIA Components to PeopleSoft Fluid User Interface.
- Involved in the PeopleSoft Data Conversion Project for Core HR, Benefits and Customizations in T&L, Payroll, Base Benefits Modules.
- Created new courses and classes for training the Employees to perform Day to Day Jobs in the PeopleSoft System.
- Configured AWE process and email approvals for enrollment approvals.
- Worked on troubleshooting several Payroll issues during the Pay Calc and Pay Confirm processes while running the On-Cycle and Off-Cycle Payroll.
- Collaborated with Technical Writers, Content SME and Trainers to deliver the content and support the sessions.
- Designed custom pagelets in PeopleSoft manager Dashboard which includes externals URL’s and Pivot Grids as per the business requirements.
- Worked on resolving TAM, Payroll and HR related defects as part of 8.54 Peopletools upgrade.
- Developed programs for employee general deduction data conversions using the Component Interface, File Layout, Application Engine and People Code.
- Put huge efforts on creating Audit tables.
- Responsible for conducting data migration workshops and deliver conversion strategy, design, data mapping be-tween PeopleSoft and legacy system.
- Worked as On Call support to monitor production systems (using Control-M and CA Workload Automation tools) and resolved many failed jobs immediately.
- Participated in Fluid Planning meetings and Fit-Gap sessions.
- Supporting the application in 9.2 after go live.
- Worked with pay sheets, pay calculations, pay confirms, payroll taxes, new hire, rehires and garnishments.
- Helped in resolving the issues related to HCM and ELM in 9.2 and helped the users understand new functionality.
- Provided post-production support on PeopleSoft HCM 9.2 and ELM 9.2.
- Setup workflow roles and updated route control profiles as required.
- Created the scripts to compare Security Tables.
- Produced multiple reports for Benefits, HR and Payroll including customization of reports like leave accrual reports and compensation reports.
- Played key role in Development of Interfaces, Online Customizations and Conversions using SQR’s, People Code and Application Engine for PeopleSoft HR, Benefits, Payroll and Pension modules.
- Developed several conversion programs and interfaces in the Benefits and Payroll modules.
- Interacted with Users to understand the business requirements and developing technical specifications for various tasks involving object modifications, developing new objects, customizing delivered reports and developing new interfaces and reports.
- Involved in meetings with the QA team for Test Planning, Test Preparation, Test Execution, Issue Resolution and Re-port Generation to ensure dat all aspects of a Project are in compliance with the Business Requirements.
- Created interfaces to load employee data from Central Payroll System, Budget System into HR tables
- Implemented row-level security using Dynamic Views
- Worked on converting the Account Receivables Customers from Legacy system to PeopleSoft using the Application Engine Program and CI.
- As a day-to-day routine provided support to the users and noledge transfer to users.
Environment: PeopleSoft HRMS 9.2, ELM 9.2
Confidential, Atlanta, GA
PeopleSoft Upgrade Consultant
Responsibilities:
- Responsible for Requirement Gathering, Analysis and build using Functional/Technical specifications
- Designing of Application Widgets, File Layouts and Reports to meet the Functional requirements
- Performed system business analysis, worked with users to create technical/ functional specification, detailed process flow diagrams.
- Convert Crystal reports to BI Publisher and design new BI Publisher reports as per business requirements.
- Designing Allocation steps and developing custom process to perform allocations
- Designed Conversion programs to convert General Ledger data from Legacy to PeopleSoft using Application Engine programs.
- Designed number of interfaces to legacy systems using PS Query, PLSQL, File layouts and Application Engine Pro-grams through Peopletools.
- Worked on designing the Excel2CI templates for conversion of Locations, Ship to Locations and Requestors.
- Developed Conversion programs using App Engine, SQR’s, File layout and Component Interface to load data from the Legacy system to People Soft Tables.
- Used ExceltoCI feature to load data from files containing delimited field files and other flat files such as CSV or .xls files to PeopleSoft data tables.
- Worked on changing of the receipts program to accept the correct UOM for the Item and not receive more quantity than PO qty. Also included the checks on converting the UOM if the receipt UOM is different the PO UOM.
- Worked on retrofitting voucher approvals in 8.8 to AWE 9.2 for creating the approval flow based on roles
- Developed benefits related conversion Application Engine program, which reads the data from file, loads it into a staging table, and tan uses component Interfaces to load data from staging tables to target tables.
- Involved in execution of off cycle payroll process to create checks for employees who received an incorrect check.
- Participating in quality management reviews of the designs and Testing of the build People Soft technical objects
- Creation of appropriate documents required by the developers, testers, deployment team and application management team.
- Participate and Conduct review sessions ensuring the standard practices were followed.
Environment: PeopleSoft HCM9.2 / FSCM 9.2 / ELM 9.2
Confidential, Sacramento, CA
PeopleSoft Upgrade Consultant
Responsibilities:
- Configuration, customization for PeopleSoft ELM 9.0. Gathered business requirements, setup ELMS 9.0, created Functional test scripts and mockups for Manager Self Service, Delegate Self Service and Learners SS. Leading test efforts through the software development following LEAN and Agile methodology.
- Work closely with operations, engineering and usability team to analyze operational performance & trends and identify opportunities for continuous improvement. Design and perform operational impact analysis.
- Performed Analysis, Designed and developed custom Delegate self service module and provided team list functionality, group actions and individual actions.
- Customized Manager self-service, Learner self-service modules by customizing the flow and providing team list functionality, customized Group Actions, Individual Actions.
- Customized Team Members, Team Learners, Search catalog, Browse Catalog and Supplemental learning, Team Learning, program details, activity details and conformation pages.
- Involved in Dumb Content, ePerformance, Certification, Group Roster, Individual Learning Plan.
- Worked with Data Conversion team in efforts to map data from legacy systems to PeopleSoft ELM, developing SQR programs, File Layout, CI & AE programs to load data into PeopleSoft.
- Customized and created new Application Packages.
- Customized flow form Team Member page, Search Catalog and Browse catalog to in corporate business requirement and to add to Plan Activity, Catalog, Program and Add Enroll in to Activity, Catalog and Register in Program.
- Worked on Portal, Portal registry, Security, Structure & contents.
- Created Functional Design document, technical design document, User interface guide and training material. Worked towards fixing Bugs, Documentation, End-Users Training and Knowledge Transfer.
- Gathered requirement to create Mockups, Functional test scripts, ELM setup. Interacted with Key Customer Focal during daily tag up meetings & Report out.
- Proficient in People Tools, People Code, Application Designer, Application Package, Application Engine, Integration Broker, XML Reporting, Component Interface, Process Scheduler, Upgrade Assistant, Tree Manager, Process Moni-tor, Import Manager, Operator Security, People Code, Data Mover, PLSQL and PS Query
Environment: PeopleSoft HCM 9.0/9.2, People Tools 8.51/8.53, UNIX, Data Mover
Confidential, Houston, TX
PeopleSoft Upgrade Consultant
Responsibilities:
- Developed custom Application Engine programs, Integration broker, file layouts.
- Involved in the production & support and upgrade of the PeopleSoft HCM 9.2(HR, Benefits and Benefits Administration, Payroll, E-performance, Time & Labor) modules based on organizational needs and requirements.
- Processed employee benefit elections using PeopleSoft Benefits Administration module
- Created custom online pages dat involved huge People Code efforts on page and record level.
- Created various custom interfaces for department security tree.
- Setup workflow roles and updated route control profiles as required.
- Created the scripts to compare Security Tables.
- Involved in the design of the HCM existing security PeopleSoft system.
- Involved in setting up new users in the PeopleSoft Systems.
- Worked on Integration Broker to setup interfaces between PS HCM 9.2 and an external (Australia PS Instance of HCM 9.0) system of PS HCM on 9.0
- Used IB with Web services to integrate between PS HCM and third party recruiting application Kenexa.
- Identified and fixed issues with IB and assisted in setting up IB for the third-party integration
- Involved in the upgrade of PeopleSoft Application from 9.0 to 9.2
- Supported the application in 9.2 after go live.
- Worked on customizations of Benefits module as per the new functionality in 9.2
- Modified Application Engine programs based on the client requirements in 9.2
- Created and modified multiple BI Publisher reports as per the client requirements.
- Helped in resolving the issues related to Performance Management and ELM in 9.2 and also helped the users understand the new functionality.
- Put huge efforts on comparing the custom code from 9.0 for the issues in 9.2 and fixed the same by retrofitting.
- Gained experience in working with tools version 8.53
Environment: PeopleSoft HCM 9.0/9.2, People Tools 8.51/8.53, Oracle, UNIX, STAT, Data Mover
Confidential, Woodlands, TX
PeopleSoft On site Coordinator
Responsibilities:
- Has Designed, Developed & Tested Micro/Small/Large Enhancement
- Perform requirement gathering, analysis of business requirements, design and development of technical specifications, and provide estimates for project completion.
- Interacting with end users for discussion on business requirements, resolving issues and process usage development.
- Communicate with the vendors and partners to ensure the accuracy of interfaces.
- Providing post production support on PeopleSoft HCM 9.1 and ELM 9.1/9.2.
- Integrated ELM & HCM, made customizations to employee/learner data.
- Developed custom queries for managers to view and track certifications across the entire company.
- Developed ad hoc Reports and Interfaces using SQR, PLSQL, PS Query & Application Engine.
- Designed and configured the complete batch Job stream in Control-M.
- Batch job monitoring and rectifying failures as part of production support. Primary contact for both Onsite & Off-shore team members.
- Applying tax Updates/Releases in various environments and testing the complete payroll processing and providing the summary reports to Users.
- Provide the Disaster Recovery capability for the PeopleSoft HRMS system.
- Handled major issues with yearend activities.
- Coordinated development and testing efforts between technical team and user groups.
- Involved in estimation of work efforts and project schedules including development, Testing and product delivery.
- Handling On-site and Off-shore Co-ordination
Environment: PeopleSoft HCM 9.1 & HRMS 8.8/PeopleSoft ELM 9.1/9.2 / Oracle / Unix
Confidential
PeopleSoft BA
Responsibilities:
- Worked on dis project as Offshore-onsite coordinator for the full life cycle from requirements gathering to post Implementation enhancement support
- Performed requirement gathering, analysis of business requirements, design and development of technical specifications, and provide estimates for project completion.
- Coordinating with Offshore development and testing teams to monitor with ongoing development work and to ensure meeting delivery deadlines as per project schedules.
- Interacting with end users for discussion on business requirements, resolving issues and process usage development. Communicate with the vendors and partners to ensure the accuracy of interfaces.
- Developing new SQR’s as per the business needs and retrofitting the existing ones for the new changes.
- Writing Technical Specifications, Developing Interfaces and UAT testing of all the deliveries made.
- Allocating work for offshore developers, code review and testing.
- Performing the end to end testing and coordinating with the User for the UAT.
- Applying Tax Updates - Analyzing the impact of the tax changes on the system and modifying customized batch pro-grams and customizing new programs delivered by PeopleSoft to fit the needs of Users.
- Implemented ELM 9.0 from requirements gathering to go-live with 23000 active employees, 900 courses.
- Configured ELM according to client specifications documented and implemented customizations.
- Configured system to stage learners in various learning statuses.
- Conducted unit testing, system testing and integration testing of HR Self Service, HRMS and ELM sync process.
- Configured and updated PeopleSoft Security tables and roles for ELM access, Manager Self Service.
- Designed and Developed Component Interface.
- Writing Tech Specs, development and UAT testing of all the deliveries made.
- Allocating work for offshore developers, code review and testing.
- Performed requirement gathering, analysis of business requirements, design and development of technical specifications, and provide estimates for project completion.
- Guided offshore team project development and test activities progress on timely basis to assure the flows and completion of work on schedule.
Environment: PeopleSoft HCM 9.0 & PeopleSoft ELM 9.0 / DB2 / Unix