Summary

Confidential is a Senior PeopleSoft ELM/HCM Functional consultant. He has over 10 years of experience working in PeopleSoft ELM and HCM applications versions 8.x through 9.2 , modules including ELM, HR Core, Base Benefits, Benefits Administration, Payroll for North America, Manager Self Service, Employee Self Service, and Recruiting TAM . His overall expertise includes design, configuration, data conversion, development, testing and maintenance of the applications during all phases of System Development Life Cycle SDLC . Hands-on experience includes Fit-Gap Analysis, Requirement Gathering, Proof Of Concept Analysis, Data Mapping Analysis, Functional/Technical Design and Documentation, Testing proficient with HPQC, Loadrunner and PS Test Framework experienced in various testing stages like SIT or UAT PeopleTools and SQL Query Development Enterprise Integration Point EIP Configuration and Management, Approval Workflow Engine AWE Configuration Change Management, Operations Management Applications Research. Additional application experience includes SalesForce, SAP, Siebel, and MS Dynamics.

Technical Skills

• PeopleTools: Integration Broker, App Designer, App Engine, PeopleCode, SQR, Component Interface CI Excel to CI, Data Mover, Process Scheduler, Performance Monitor, PS Query, and Change Assistant.
• Databases: Oracle , MS SQL Server.
• System Platforms: Windows XP/VISTA/Win7 , UNIX, and Macintosh.
• SQL Development Environment: SQL SQL Developer Embarcadero DBArtisan and, TOAD.
• Time Tracking System: Kronos, Artemis, SmartTime, Chimes
• Web Services: BEA Tuxedo, Weblogic, IBM Websphere, Apache
• Software: IBM Lotus Notes, MS OUTLOOK, MS Visio, MS Project, MS Word, MS Excel, Crystal Report, MS Live Communication Server, MS Live Meeting, WebEx
• FTP/SFTP server: MS DOS FTP server, Humming bird, Bullet-Proof, FileZilla
• Other software systems: Edify Voice Interaction Platform IVR , Spirent Smartbits Testing System, IMACRO, RUEI, OPNET, Oracle IMS, BPEL, Tumbleweed, BMC Remedy, BMC Control-M, UC4, CA Workload Automation, HPQC/ALM, LoadRunner and Clearquest.

Consulting Experience:

Confidential

Major responsibilities and roles include and have included:

• As the leading ELM resource in HR Delivery and Solutions team, took over data cleanup and system stability projects after an unsuccessful ELM 9.2 implementation completed on Dec 2013. The same projects were worked on by a previous team before I joined but didn't go well.
• For data issues in Curricula and Certificate Programs causing errors in ASYNC process and class enrollment transactions , worked closely with tech team, training team and HRSS team, examined data, understood the issues and came up with backend/online solutions, finalized requirement documents, obtained sign-off from business, presented in front of the HR Analytics and Solutions team, performed SIT, led UAT, drove the production implementation of the fixes, and performed post-production support for training and HRSS teams.
• For data issues in enrollments, reviewed data, identified where the errors are, provided resolutions, currently working on sign-off and testing.
• Provided solutions on 'closing up' duplicate programs once the hidden programs are fixed and show up from online search, while the 'in-progress' enrollment can still continue.
• Helped training team administrators and instructors configure and set up the systems to achieve their business requirements.
• Provided resolutions to fix wrong information displayed in New Learning Pagelet.
• Enabled/disabled pagelets in homepage according to the business needs.
• Provided multiple ways on sending system-wide announcement and notifications during emergency.
• Worked on Search Framework, troubleshot the failure of 'build search index' process that happened in production recommended new support procedure to avoid business interruptions.
• While addressing and resolving data issues, provided education and training on how to enable and use advanced delivered functionalities for business needs.
• Provided clarification and education on 'effective dates', Scores, Grade and Attendance, etc.
• Provided overview and recommendations to email notifications in enrollment activities, disabled unnecessary notifications, enabled and trained business how to use delivered functionality, such as adhoc notifications, to achieve their needs.
• Troubleshooting HCM/ELM integration and security issues.
• Worked on new ELM implementation projects, loaded contents, tested and troubleshot content launching and completion issues. Still ongoing.

Confidential

Major responsibilities and roles include and have included:

• Reported to the HCM/ CRM-HR HelpDesk HRHD Support Manager in PeopleSoft group worked closely with PS Solution Architect, developers, Benefit Directors, Project PMs, and application support colleagues in PS Financials and Data Warehouse teams. Successfully completed every task assigned.
• Worked as the major resource, performed functional design, Data Mapping, interface development and testing for the implementation of HR Edcor project which is about Tuition Remission and Reimbursement for employee students. All the deliveries, including data files, requirement/design/troubleshooting documentation, were on time with fine quality. Cleaned up HR data including Highest Level Degree and Reports To .
• Worked as the lead functional resource for Send Word Now project, met the legacy support team, talked with the SWN vendor, went over the existing interface, performed functional re-design and re-development, enabled web services to achieve real time automation, eliminated the multiple steps of manual work that sometimes last 15 hours helped clean up PS HR data including Address and Reports To .
• Planned interface testing activities during the upgrade of HCM and FS from 9.0/8.49 to 9.1/8.52. Tested and troubleshot for HCM HR/Benefits/Payroll interfaces, downstream legacy interfaces, GL Spreadsheet Upload and nVision reporting. Attended HCM Payroll Parallel testing. Worked closely with PeopleSoft Administration team and DBAs. Met users to ensure customer service during and after go-live.
• Participated in and drove HCM/FS interface projects with Real Estate vendor Planon, actively involved in functional and technical design, data mapping, FDD/TDD documentation, and interface testing. Moved the projects in a steady pace.
• Worked with the Solution Architect of Web Development team, successfully performed the re-design, data mapping, development and testing for the PS HCM integration with corporate Active Directory and FrontRange ticketing systems.
• Worked with the Solution Architect of Web Development team, MCIT CTO, Security Officer and PeopleSoft Admin team on Identity and Access Management IAM Multi-factor Authentication project, identified the involvement of PS HCM application, estimated the integration efforts and planned what needs to be done.
• Worked with the Solution Architect in the Web and SharePoint Development team, implemented and enhanced the worklist exportation project that was initiated and tested directly by the CTO and CIO of the medical center. All the requirements were satisfactorily met.
• Appointed as the lead functional resource from IT group, participated in the PeopleSoft CRM - HR HelpDesk HRHD 9.2/8.53 implementation, performed fit-gap, requirement gathering and customization design, performed SIT and UAT testing, verified system setup related to integration with HCM, ERMS, Search Framework, SES, and Telephony CTI , verified agent/manager data and core functionalities like create and assign a case, ensured vendor deliverables of system integration diagram and support documentations including process run book, Benefit Program Code Customizations, security, and training guides on Agent/Manager/ERMS/Telephony. Participated in the cutover activities and production support after go-live.
• Worked as support staff, helped the manager come up and adjust support policy monitored, prioritized, assigned and troubleshot tickets/cases sent from FrontRange system, followed up the tickets/cases with users until resolved. Provided ticket reports to management in a weekly basis.
• Worked as support and research staff, according to PeopleSoft product defects and business requirements, created Oracle GSC service requests SRs and business case documents, provided issue reproduction steps and screen shots, provided technical and functional answers to inquiries, followed up the SRs until resolved. Provided SR reports to management. Participated in the discussion and research of extending support for NYUMC.
• Explored and evaluated the new features in HCM 9.2/8.53, prepared for HCM upgrade.
• Participated in HCM performance analysis, improved user experience.
• Participated in the security optimization for HCM during the upgrade. Performed security audit and submitted monthly access logs to corporate security office.
• Participated in the strategy design of HCM/FS bundle/patching applications, retrofit analysis of the customizations, regression test.
• Worked as the sole resource, configured/implemented Unified Navigation for PeopleSoft Interactions Hub PIH , previously called Portal Solutions or Enterprise Portal. Participated in the design and discussion of Content Management, Enterprise Search and Feed Publisher.
• Planned for the project of retiring unsupportable 3rd-party job scheduling software and participated in the movement of PS jobs to PS Process Scheduler. Evaluated 3rd-party scheduling software that may bring value to the organization.
• As the integration analyst, designed interface/integration strategy based on technology, business requirements and timelines helped finalize and enforce development standards provided standard for functional and technical design documents oversaw HCM and Financials interface deliverables and test plan/results coordination of the migration of HCM and Financials interface code troubleshot interface issues, proactively identifying issues that may cause problems or errors.
• Delivered insights and clarifications on functionalities and data structure of enterprise solution, eliminated unnecessary efforts for development and support, simplified and optimized data handling programs and processes
• Participated in the maintenance of data handling/manipulation Shell/Perl scripts and logs.
• Planned and led the migration of PeopleSoft file transfer from FTP to SFTP, successfully met the compliance/security requirements.

Confidential

One of the largest implementations of PS 9.0 for the Public Sector. Major responsibilities and roles had included:

• Worked in CUNY HCM Functional implementation team with 3 director-level implementers from the beginning of HR Core/TAM/ESS/MSS/PM rollout until after go-live, participated in fit-gap and design meetings with the software vendors and business stakeholders, gathered requirements, customization CEMLI requests and change orders, assessed resources and time required to implement, followed up with all the parties, helped decision makers to make final determinations walked through PeopleSoft HCM and TAM functionalities with HR users, provided sample queries or reports, explained what they can or can't see and what they can change/customize with the help of software vendor or CUNY support team.
• Designated as the Payroll Lead Resource by central office processing and support team, participated in payroll implementation meetings/calls, gathered payroll requirements from business teams, translated into test scenarios and test scripts worked with Oracle consultants to ensure deliverables and quality control/assurance, performed payroll test runs, troubleshot issues and errors, finalized customization processes, validated paycheck earning/deduction amounts and payroll reports, confirmed accounting line data posted to GL validated Payroll setup during cutover coordinated and performed payroll parallel testing activities, analyzed discrepancies participated in the design and finalization of FDD/TDD for Payroll Interfaces, participated in the sign-off process.
• Analyzed and finalized data mappings for certain HR and Benefits CEMLIs, performed data migration/conversions for HR and Benefit legacy data.
• Set up and configured CRM/ELM applications, performed data conversion and fullsync from HCM application to CRM/ELM applications during CRM/ELM implementation go-lives conducted user training for HelpDesk personnel and training team Train the trainer
• Worked as support staff, troubleshot production issues for HCM, CRM and ELM applications, helped the manager come up and adjust support policy monitored, prioritized, assigned and troubleshot tickets/cases sent from PeopleSoft CRM ticketing system, followed up the tickets/cases with users until resolved. Provided ticket reports for management in a weekly basis.
• Worked as support and research staff, according to PeopleSoft product defects and business requirements, created Oracle GSC service requests SRs and business case documents, provided issue reproduction steps and screen shots, provided technical and functional answers to inquiries, followed up the SRs until resolved. Provided SR reports to management, attended the calls with Oracle GSC team. Participated in the discussion and research of extending support for CUNY.
• Reviewed functional, technical and security documents, planned and developed test plans and test scenarios, executed test scripts, coordinated campus and central office testers on their testing activities, maintained and managed test results in HPQC helped users, followed up and resolved their functionality and performance problems.
• Planned/created/managed the batch schedule for HCM/CRM/ELM.
• Enforced the inbound/outbound interface file transfer rules and daily monitor tasks, troubleshooting errors enforced school policy on development standard, application security and workflow approval process, managed post-production projects such as patching, applying bundles/tax updates, and enabling Accessibility for visually impaired users , review, analysis, development or retrofit, testing and the migration to production environments.
• Conducted PeopleTools 8.49 to 8.50 upgrade for HCM, CRM and ELM. Meanwhile, assessed 3rd party software that may help the automation of integration and batch scheduling among applications, eventually recommended BMC Control-M to supervisors and the product was soon purchased and adopted.
• Led the design, documentation and support activities of the integrations between HCM and CRM, Financials, ELM, Campus Solution as well as 3rd party applications maintained the master list for all the interfaces and EIPs generated status reports and dashboards for upper management in regular basis.
• Prepared for HCM/ELM 9.1 upgrade. Researched on the new functionalities and identified key features that can be utilized by CUNY.

Confidential

• Primary responsibilities included working closely with HR managers, technical team and vendors, conduct PeopleSoft HRMS 8.0 functional and technical support, system/interface testing for HR/Benefit/Payroll programs, and conduct data migration and data conversion from PeopleSoft to Fidelity System after the acquisition of Engelhard Renamed as BASF Catalyst LLC by BASF.
• Designed and set-up new coverage codes based on the new introduced benefit plan policy of BASF. Designed new benefit programs for Union/Salaried/LTD/Retiree employees a highly complex task .
• Designed new carrier IDs, rate tables, benefit plans, deduction codes, and rules tables for 2007 Open Enrollments, validated Benefit Administration Process and the On-Demand Event Maintenance process, tested 21 benefit programs covering 3000 salaried and 300 hourly employees, validated deductions for Medical, Dental, Prescription Drug, Life, LTD, Spousal Surcharge, Vision, Group Legal, 401k, Vacation Buy, Health Care FSA, Dependent Care FSA, etc
• Conducted meetings with IVR vendor Viecore , discussed IVR enhancement requirements for Open Enrollment.
• Provided Ben Admin support during the Open Enrollment process.
• Participated in the tax update and year end processing setup and testing and made sure employees have the correct tax setup.
• Participated in the pay group conversion of salaried employees from weekly/monthly to biweekly, troubleshot benefit related deduction problems occurred in the payroll interfaces and reports updated/customized SQR interfaces and SQL queries, including ten benefit SQR interfaces sent to Harvard, Atena, Blue Cross Blue Shield, Health Net, Health America, Medical Mutual, MVP, Kaiser and other HMOs coordinated and communicated among BSAF Catalyst LLC HR department, BASF Off-shore EAI team and the HMO vendors.
• Retrieved lost pension plan data for well over 500 employees was caused by using incorrect recruiting/hiring processes.
• Worked with the director of Financial Department, payroll manager and HR manager on cost center migrations, clarified requirements, pulled data from SAP FICO, performed data clean-up, designed and tested SQRs.
• Applied DST patches to PeopleSoft and Edify servers, supported Siebel phone systems for Catalyst service center.
• Produced the PeopleSoft Production Support Procedure manual, which includes all details on PeopleSoft HR/Benefits/Payroll interfaces, including processing schedules.
• Worked on a 1-year long data migration/conversion project from PeopleSoft to Fidelity system for salaried employees, attended weekly meetings with Fidelity requirement team and development team, participated in the requirement gathering, design, data mapping, documentation, development and testing of H W SQR interfaces between PeopleSoft and Fidelity system, analyzed Fidelity's iterative error reports and provided feedback to Fidelity in a timely manner participated in the back-feed design and testing for union employees on their HR/Payroll data from Fidelity back to PeopleSoft system.
• Converted and implemented from SAP HR into PeopleSoft the HR/Benefits/Payroll data of a small company called Construction Chemical after it was acquired by BASF. Performed data mapping and testing.
• Quality Assurance for project migrations and managed the change control processes.
• Conducted Feasibility Report and Fit-Gap Analysis as part of the evaluation of an upgrade to PeopleSoft HRMS/HCM 8.9 or 9.0

Confidential

• Primary responsibilities were to design and analyze implementation processes, generate process and training documents, perform testing, troubleshoot, and provide production support on Talent Acquisition Manager, eRecruit, Employee Self Service, Manager Self Service, ePerformance, eBenefits, eProfile, Approval Workflow Engine, Training Admin, Benefits and Payroll modules during a PeopleSoft HCM upgrade from 8.3 to 8.9.
• Generated process documents on Hiring Process, New Hire Re-Hire Data Entry Process, Employee Review Process, and Manager Labor Relation Process.
• Set up and configured training administration module for features including training courses/programs/ costs/requirements/budgets/administering course sessions/ enrolling students/ tracking student training and training costs, designed test plan and scripts, created test data and conducted system and regression tests.
• Conducted Fit/Gap analysis with Recruiting personnel including recruiters, business partners, hiring managers and interviewers, generated training documents on Recruiting Workforce and Self Service Job Application.
• Conducted query and security analysis between 8.3 and 8.9, identified the differences between the two versions.
• Conducted testing on external and internal hiring and other recruiting process, verified the workflow.
• Communicated and followed up with developers or PeopleSoft support personnel to resolve the issues filed in problem reports.
• Troubleshot and performed testing for Benefit and Payroll, especially year end processing module and tax setup, verified tax calculations.
• Production support for Recruiting, HR, Benefit and Payroll modules.

Confidential

• Primary responsibility was to provide QA testing activity and provide functional production support for a PS 8.8 environment.
• Participated in the support of PeopleSoft HRMS/HCM 8.8 system, performed Payroll and Benefits data conversion for employees from multiple departments.
• Generated User Guides for Payroll and Benefits, clarified the correct sequence and order to configure and set up payroll and benefit tables, trained and troubleshot payroll and benefit problems for users, fixed errors related to Pay Groups or Pay Calendars, etc., helped develop and test queries on payroll and benefit data.
• Participated in the upgrade from PeopleSoft version 8.8 to 8.9, conducted research on the difference between those two versions, communicated with PeopleSoft users, informed them of the change, gathered new requirements on the new version, provided to technical team for customization.
• Conducted fit/gap analysis, gathered feedback and requirements on Payroll, Benefits and Time Labor modules, acted as a liaison between customers and technical development team, identified and clarified business requirements project risks, translated the requirements into highly detailed functional system specifications, recommended solutions, conducted query and reporting.
• Responsible for design, setup and testing of Security and Open Enrollment troubleshot for users in HR Department and Benefit Department.
• Provided assistance with the upgrade of Recruiting, set up recruiting templates and components, verified workflows, developed and executed test scripts, troubleshot and set up Recruiting security.
• Created user manuals, documented the general implementation procedures and troubleshooting processes.
• Conducted Tree Maintenance and Security Analysis on PS 8.8/8.9 systems, helped security team maintain user profiles, custom roles and permission lists.

Confidential

• Primary Responsibilities included conducting fit/gap analysis, Tree and Security Management, provide QA testing and support for PeopleSoft 8.8 HRMS/HCM system.
• Performed Benefits and Payroll data conversion for employees for 300 employees.
• Conducted fit/gap analysis, gathered feedback and requirements on Payroll, Benefits, Self Service and eApplications, acted as a liaison between customers and technical development team, identified business requirements project risks, translated the requirements into highly detailed functional system specifications, recommended solutions.
• Conducted and participated in the analysis, planning, set-up, development, testing, conversion, verification and support.
• Assisted with vendor review and selection for health, disability, life insurance and FSA accounts. Modified coverage code to meet compliance and cost effective goals.

Confidential

• Primary Responsibilities included conducting fit/gap analysis and QA testing to verify the updates and fixes made by the tech team, make sure the needs from application users can be met.
• Analyzed the setup and administration of Benefits and Payroll modules, appraised intended results, helped technical team to develop and implement needed fixes and tested processes. Identified and rectified module setup, administrative and training problems residual from the previous implementations, restored Payroll and Benefit functionalities. Worked closely with technical staff to identify, locate and enact needed updates.
• Participated in the planning and design of PeopleSoft HR base / Benefits module implementation requirements, developed test plans.
• Performed system regression tests, conducted platform tests functional verification tests.
• Participated in design reviews, worked with developers and functional analysts through software development life-cycle, ensured bug-free product releases logged and prioritized bugs verified fixes maintained manual automated test scripts debugged and run existing automated test scripts for page sweeps and business process flows provided results and feedbacks to developers.
• Participated in the implementation of PeopleSoft HCM 8.8 system, documented the general implementation procedures as well as troubleshooting processes.

Confidential

• Responsibilities included testing and working as a functional consultant, help the Technical team and PeopleSoft application users to upgrade PeopleSoft from v8.3 to 8.8.
• Analyzed the setup and administration of HR Base/Benefits/Payroll modules, evaluated intended results for upgrading to v8.8, planned and developed testing processes before and after the upgrade.
• Performed system regression tests, conducted platform tests functional verification tests.
• Identified and clarified HR and Payroll setup, administrative and training problems resided from the initial installation, restored correct Benefit Administration and Payroll functionalities.
• Conducted and participated in design reviews, worked with developers and functional analysts through software development life-cycle, reduced high/medium level defects logged and prioritized bugs verified fixes developed and executed test scripts provided results and feedback to tech team.
• Documented the general implementation procedures as well as troubleshooting processes/tips.
• Performed functional production support after go-live.
• Provided training for application users.