Orange Aspen Incorporated - Evergreen, Colorado - calvin (at) OrangeAspen (dot) com
Calvin have developed a broad range of skills through his diverse professional background. I have several years of consulting experience, with specific experience in conversions, design, development, implementations, upgrades and post-implementation support of PeopleSoft HRMS Application. I specialize in Benefits Administration and eBenefits as a techno-functional resource.
PeopleSoft Products Experience
- Human Resource
- Benefits Administration
- NA Payroll
- Base Benefits
- Workflow
- Self Service
- eBenefits
- Security Admin
- ePay
- eRecruit
- eProfile
- Manager Self Service
- Candidate Gateway
- Talent Acquisition Mgmt
- Recruiting
- Life Events
- PeopleTools 8.4x
- PeopleCode
- Application Engine (AE)
- SQR Programming
- PS Query
- Application Messaging
- Component Interface (CI)
- Application Upgrades
- Change Assistant
- Data Management Tools
- Tree Manager
- Process Scheduler
- COBOL
- PL/SQL
- UNIX shell scripts
- Oracle
- SQL Server
- Sybase
- RapidSQL
- DB2
PROJECT EXPERIENCE
PeopleSoft HRMS v8.9 - Benefits Open Enrollment Consultant for JeffCo Public Schools - Mar 2009 to July 2009
* Responsible for providing Benefits Administration functional and technical support for Benefits Open Enrollment period.
PeopleSoft HRMS v8.9 - Customer Enhancements for The Children's Hospital - May 2008 - Oct 2008
* Responsible for designing and developing User Profile Management Process to control the creation and updating of PeopleSoft HR user profile accounts. Process consisted of Application Engine program and Component Interface.
* Responsible for designing and developing a manager workforce review inquire pages. This functionality offered the management the ability to review data all the employees that report directly and indirectly to the manager/VP/Director.
* Responsible for providing Benefits Administration functional and technical support for upcoming Benefits Open Enrollment period.
PeopleSoft HRMS v8.9 - Upgrade from 8.8 for Time Warner Telecom - Dec 2007 - May 2008
* Responsible for performing Move To Production Upgrade using Change Assistant and custom programs.
* Utilized Change Assistant to practice Move To Production upgrade and created multiple 8.9 environments for Development, System Testing and User Acceptance Testing.
PeopleSoft HRMS v8.9 - Open Enrollment Support for The Children's Hospital - Oct 2007
* Responsible for providing functional and technical guidance with client's 2008 Benefits Open Enrollment process.
* Reviewed and altered Benefit Event Rules and Benefit Programs to support current OE process.
* Performed enrollment testing via eBenefits and Election Entry panel.
* Provided data mover scripts to migrate setup data to production and other test environments.
* Provided knowledge transfer to client via Open Enrollment "How-To" document based on their benefits settings.
PeopleSoft HRMS v8.9 - Upgrade from 8.8 for Time Warner Telecom - July 2007 - Sep 2007
* Responsible for performing initial Move To Production Upgrade. Utilized Change Assistant to upgrade both the client's 8.8 hr demo environment and production 8.8 environment to version 8.9. Re-applied customizations to 8.9 environments to allow the client to test functionality.
PeopleSoft HRMS v8.9 - Production Support for The Children's Hospital - Dec 2006 thru May 2007
* Responsible for providing technical production support in the following areas: Candidate Gateway, Talent Acquisition Manager, eBenefits, Payroll for North America, Benefits Administration, Enterprise Learning, and Human Resources.
PeopleSoft HCM v8.8 SP1 Production Support for Time Warner Telecom - Oct 2005 thru Nov 2006
* Responsible for providing technical production support in the following areas: eRecruit/Recruiting, Enterprise Learning, Payroll Interface, Base Benefits, and Human Resources.
* Provided technical and functional oversight for Benefits Administration Definition, Fit/Gap, and Design Phases.
* Responsible for documenting and creating customer enhancement for Benefits Administration and eBenefit pages.
* Responsible for creating and maintaining interfaces to vendors such as Success Factor, Aetna, Delta Dental...
PeopleSoft HCM v8.8 eBenefit & Workflow - Remote - for Itron - Sep 2005 to mid Oct 2005
* Responsible for designing and developing custom eBenefit Election confirmation Page.
* Responsible for designing and developing workflow solutions for employee change processes related to benefits, life events, and personal information changes.
PeopleSoft HCM v8.8 BenAdmin & eBenefit Impl. - Remote - for MasterBrand Cabinets - Apr 2005 - Sep 2005
* Responsible for providing customization designs and developing technical solutions to support the implementation of Benefits Administration, eBenefits, and Life Events.
* Responsible for mentoring clients' support staff about the inner workings of Benefits Administration and eBenefits.
* Responsible for reviewing all development work as relates to implementation of Benefits Administration and eBenefits.
* Responsible for documenting and testing Go-Live technical tasks for the implementation of Benefits Administration.
PeopleSoft HCM v8.8 Production Support - Remote - for MasterBrand Cabinets - Nov 2004 - Feb 2005.
* Responsible for providing technical production support in the following areas: Human Capital Management, Payroll, General Ledger Interface, and Base Benefits for their PeopleSoft HCM application.
PeopleSoft HCM v8.8 Benefits Open Enrollment support for MasterBrand Cabinets - Sep 2004 - Oct 2004.
* Designed and Developed an Application Engine/Component Interface process to calculate and Insert job records for annual benefit base rate yearly adjustments.
* Designed and Developed SQR report to support Evidence of Insurability notification.
* Updated carrier interface SQR programs to support upcoming Benefits Open Enrollment process.
SQR Developer contract for TriZetto - July 2004 to mid Aug 2004.
* Responsible for re-working SQR programs to execute more efficiently.
* Provided knowledge transfer to client's SQR developers'.
PeopleSoft HRMS Upgrade v8.01 to HCM v8.8/PT 8.44 for Arapahoe County Government - May 2004 to July 2004.
* Provided assistance validating the upgraded system test environment.
* Performed necessary development work on custom objects and SQRs to meet latest release requirements.
PeopleSoft HRMS Benefit/Payroll support HRMS v8.01 for Arapahoe County Government - Nov 2003 to April 2004.
* Performed functional and technical analysis on Retroactive Processing for Benefits\Deductions, and Retroactive Payroll.
* Implemented custom AE/CI Process to Enroll Employees into Benefits Billing for those employees on leave with percentage of benefit cost being paid by employees.
* Applied various patches and fixes related to Benefits and Benefits Billing.
PeopleSoft HRMS Upgrade from v7.5 to v8.8 & v8.42 tools for Key Bank - Feb 2003 to Aug 2003.
* Responsible for designing and developing user security automation programs. The programs consist of using Application Engine and Component Interface to Create UserIds, Update Manager Row Level Security, Update email addresses, Assign Manager Backup row level security and process terminations.
* Responsible for designing and developing Life Events suited to the client's needs for Birth/Adoption, Marriage/Divorce, Open Enrollment, Death, Spouse/dependent status change.
* Implemented workflow process to notify Benefit's Staff of the life event activity.
* Implemented workflow process to support Notification to Managers of Department reassignment.
* Responsible for setting up, upgrading and system testing client specific Benefit Open Enrollment programs to be functional with HRMS v8.8 and eBenefits.
PeopleSoft HRMS Upgrade Analysis from v7.5 to v8.3 for Key Bank - Jun 2002 thru Dec 2002.
* Lead Technical Analyst for PeopleSoft HRMS v8.3 Upgrade Analysis from v7.5 HRMS.
* Responsible for creating Technical Analysis & Specifications for Benefits Administration, eBenefits, eRecruit, eProfile, Payroll Interface, Security, and Leave related custom functionality to carry forward and/or build in v8.3.
* Redesigned message agent workflows to execute combination Application Engine and Component Interface programs.
* Also participated with Benefits related Fit/Gap and Functional Design sessions with functional users.
* Analyzed custom SQRs and indicated areas that required modifications to conform to the latest release
PeopleSoft HRMS Upgrade from v7.02 to v8.01 for Qwest Communications - Mar 2001 thru Mar 2002.
* Co-Technical Lead and Developer for PeopleSoft HRMS v8 Upgrade from v7.02 HRMS.
* Assisted with setup and performed modifications to HR, Payroll, Ben Admin and Self Service pages.
* Participated in Benefits Business Process Re engineering efforts with emphasis on Ben Admin, Retro Deductions, and eBenefits.
* Implemented and modified delivered Fast Security functionality to perform real-time updates using peoplecode and application engine programs.
* Designed and created workflow activities to support re-engineered business processes, such as Retro Benefits notification letters, New Hire Worklist to Payroll and Benefits staff, Company Transfer email notification to Payroll...
* Analyzed and Modified Client's custom Brio SQRs, customized COBOL programs, and PeopleCode.
* Performed object migrations into staging environment.
* Assisted with debugging Upgrade Assistant scripts.
* Created new interfaces and processes to support the Benefit's staff.
* Provided knowledge transfer to development team members.
PeopleSoft Benefits Administration on v7.5 for Wild Oats - Jan 22, 2001 to Feb 2, 2001.
* Performed functional Benefits Administration setup; defining eligibility rules and event rules, analyzing snapshot information.
* Performed technical tasks including assigning eligibility configuration values on job records, and scrubbing base benefit data to indicate terminated benefit records.
PeopleSoft HRMS Payroll Production Support for Arapahoe County Government Jan 1999 thru Mar 1999.
* Provided payroll technical support for PeopleSoft HRMS v7.02 on SQL Server.
* Resolved issues related to GL Interface process.
* Modified Check Reconciliation Process, provided an on-line means for the user to reconcile incorrect check balances received from bank transaction file. Created on-line Check Reconciliation Inquire Panels.
* Modified Brio SQR-based interfaces for internal applications and outside vendors.
PeopleSoft HRMS Impl. & Prod support on v7.02 for Qwest Communications - Aug 1998 thru Mar 2001.
* Provided production support for HR, Payroll, and Benefits Administration modules.
* Provided technical and functional support for 1999 - 2001 Benefit Open Enrollment process.
* Provided technical support to troubleshoot issues with Ben Admin.
* Modified delivered Confirmation Statement SQR to provide employee benefit information onto 1 page.
* Created custom Benefit Open Enrollment forms and process.
* Converted 35,000+ Employee Benefit and Dependent data into PeopleSoft Ben Admin OE tables to allow for passive benefit enrollment for 2001.
* Created process to transfer Leave Accrual Balances for employees that transfer between companies.
* Created PeopleCode to manage Eligibility Configuration Field values and BAS Group Id values for Benefits Administration Processing.
* Created a number of Brio SQR-based interfaces for internal applications and external vendors.
* Implemented Customized Fast Security to improve on-line Panel processing and Query Reports.
* Created a number of Query Reports for customer.
* Implemented 6,000+ Employee Data into PeopleSoft HRMS system.
PeopleSoft HRMS Implementation on v7.0 for Adams County School District - Mar 1998 thru Aug 1998.
* Lead conversion effort of an existing HR\Payroll system running in an HP3000/VSAM environment to a SQL Server Client Server PeopleSoft solution.
* Assisted with the functional HRMS setup efforts.
* Setup the Department Security Tree and assisted with Security definitions.
* Created external vendor interfaces using Brio SQR.
* Performed modifications to the application as defined by the client.
PeopleSoft Financials Implementation on v6 for Government of Puerto Rico - Jul 1997 thru Jan 1998
* Created Standard Interface Architecture to be used for interface data files, tracking interface processing activity, and auditing incoming and outgoing interface data.
* Created detailed designs for inbound and outbound Scribe SQR-based interface programs.
PeopleSoft HRMS Implementation on v5.1x for Coors Brewing Company - Sep 1996 thru Mar 1997.
* Created internal and external vendor interface programs using Scribe SQR.
* Implemented PeopleSoft record and field auditing functionality and customized database views and SQR programs to provide data for internal interface programs such as Employee Change Notification and for data entry tracking.
* Assisted with technical aspects for the upgrade effort from v5.10 to 5.12.
EDUCATION & TRAINING
* PeopleSoft Server Administration and Installation v8.44 - 2004
* Data Management Tools - PeopleSoft PeopleTools v8.12 - 2001
* PeopleCode - PeopleSoft v8.12 - 2001
* Accelerated PeopleTools I & II - v8.12 - 2001
* Application Engine - PeopleSoft v8.12 - 2001
* Directing, Controlling and Managing Projects Seminar - 2000
* Bachelor's of Science - Industrial Computing, Eastern Michigan University, 1992
