Peoplesoft Benefits System Analyst Resume
SUMMARY
- Confidential have twenty plus years of experience working with information technology, with focus on PeopleSoft HCM implementations, conversions, customizations, reporting and upgrades since December 1997. Working in a PeopleSoft functional and technical role combined with strong communication, organizational, planning, and technical skills to achieve professional results.
- The various opportunities have allowed me to maintain a strong technical background that includes a wide variety of software, languages, hardware, and operating system within various industries.
TECHNICAL SKILLS
Application Development Tools: PeopleSoft Application Designer, Process Scheduler, PeopleTools, Peoplecode, App Engine, Component Interface, ExceltoCi, Crystal Reports, Data Mover, DMS Statements/Scripts, Projects, Query, UltraEdit
Application Package: PeopleSoft Payroll, Human Resources, Base Benefits, Benefits Administration, eBenefits, eRecruit, Reporting Tool, Self Service, Talent Acquisition Manager (TAM), Benefits Billing
Databases / DB Tools: Unix, PL/SQL, Toad, DB2, Oracle, SQL Plus, MS Access
Desktop Tools: MS Project, MS Office, Visio, Lotus Notes, SharePoint
Operating Systems: Unix, Oracle, OS/VS, MVS, IBM Mainframe, IBM XT/AT/PC/NT
Programming Languages: Cobol, SQR, SQL Server, Peoplecode, Microfocus COBOL
Network Software / Communications: TCP/IP, HTTP, HTTPS, FTP
Utilities / Command Languages: JCL, PANVALET, SPF/PC, TSO
PROFESSIONAL EXPERIENCE
Confidential
PeopleSoft Benefits System Analyst
Responsibilities:
- Setting up benefits configuration tables for 2014 open enrollment
- Preparing test scripts for benefits open enrollment testing
- Writing various specification documents, documenting changes to system
- Making necessary changes to vendors interface data pertaining to include new 2014 open enrollment
- Updating daily and monthly reports
- Preparing test scripts for outsource testing to new benefits vendor
- Writing various sqls to needed data for testing
- Working with various vendors to validate new 2014 benefits data are being interfaced correctly
- Working on various mini projects assigned
- Assisted with daily errors and resolutions
- Wrote the custom State Mandated Leave Accrual specification document
- Setup the custom State Mandated Leave Accrual testing scripts
Environment: SQL, MS Access, PeopleSoft: (HR, Job, Benefits, Payroll), PeopleTools (Application Designer, Query
Confidential
PeoplSoft Conversion
Responsibilities:
- Writing functional documentation to support US and global conversion for HR/JOB/ and payroll data.
- Writing technical templates and supporting documentation for the HR/JOB/ and payroll data.
- Working with users to validate data and conversion data
- Create ExceltoCi to assist with converting data
- Create conversion programs to convert data
- Setup configuration of Latin America conversion population
- Validated conversion data that would feed into the payroll interfaces for the global clients
- Managed offshore team by assigning tasks and test case for conversion
- Traveled to various user sites to assist with fit gap analysis and give presentations
- Created test scripts for conversion data
- Created document for go - no-go presentation
- Attend all post go-live meetings
- Part of the post go-live support team
- All documents are stored on secured drive
Environment: SQR, SQL, MS (Access, Power point), PeopleSoft: (HR, Job, Payroll), PeopleTools (Application Designer, ExceltoCi, App Engine, migration, Query, Component Interface), Remedy ticketing system
Confidential
PeopleSoft Functional Payroll and Benefits Conversion
Responsibilities:
- Writing various sql to validate the converted data.
- Create various PeopleSoft reports using PeopleSoft Query tool and sql scripts to send back to the users to validate data.
- Created various MS Access databases to load the converted data and validate
- Run PeopleSoft Benefits Admin to test benefits population and assignments
- Reported test results and fallouts to project manager and users for next steps
- All documents are being stored in SharePoint depository
Environment: MS Access, SQL, PeopleSoft: (HR, Payroll, Benefits, Query)
Confidential
PeopleSoft 9.1 Upgrade System Analyst Developer
Responsibilities:
- Wrote technical specification documents for all coding changes
- Made necessary coding changes for all Cobol and SQR programs (including supporting interface programs that sends benefit data to various vendors including selected 401k vendor).
- Made necessary JCL changes accordingly
- Unit tested all coding changes made to ensure programs function
- Executed necessary jobs to perform System test
- Resolved issues detected during the testing phase with the Benefit Analyst
- Documented any modifications required
Environment: Cobol, SQR, Lotus Notes, JCL, SQL, DB2, MVS, TSO, JES, PeopleSoft: (HR, Benefits, Benefits Admin, Benefits Billing), TSO, Panvalet, File-Aid
Confidential
Benefits Administration Functional Interface Lead
Responsibilities:
- Proposed that Confidential use the EDI HIPAA layout for their interfaces that would be sent to outside vendors deemed, which saved CPS money, time, and kept them government compliant
- Conducted analyst by meeting with Benefits team, vendors, and Director of the Benefits Department to gather data, issues, and concerns
- Conducted the fit-gap analysis phase by meeting with Benefits team, vendors, Director of the Benefits Department, and technical team to gather data, issues, and concerns
- Wrote all benefits interface functional specification documents for various outside vendors
- Met with Benefits team and Technical team on each specification documents
- Wrote all benefits interface technical specification documents
- Met with Technical team on each technical specification documents to explain and elaborate on data selection for junior developers
- Created test plan documents
- Created test cases
- Tested interfaces with Business Analyst and vendors as a joint effort
- Worked with Business Analyst and vendors to resolve any detected issues
- Also resolved some payroll issues and Benefits Billing issues
- Wrote various PeopleSoft Queries
- Also wrote and documented supporting interface for CPS Life Insurance vendor
Environment: Excel, Word, SQR, SQL, Process Scheduler, Oracle, Unix, PeopleSoft Queries, PeopleSoft 8.9
Confidential
PeopleSoft Open Enrollment Lead Developer
Responsibilities:
- Created project time line and assignment of task
- Updated benefits configuration tables
- Added new rates to rate tables
- Updated Peoplecode supporting 2008 changes
- Updated the benefits text tables with modified 2008 verbiage
- Updated the link pointing to the 2008 Confidential Benefits handbook
- Update benefits tables with new vendor information
- Wrote SQR program supporting new vendor interface file
- Wrote functional and technical specification documents supporting new interface
- Worked with Business Analyst and created test scripts testing open enrollment 2008 changes and new interface
- Created test plan with Business Analyst
- Attended weekly status meetings
- Participated in the post implementation support
Environment: Peoplecode, SQR, PeopleTools, PeopleSoft: HR, Benefits Administration, eBenefits, PeopleSoft benefit tables, Unix/Oracle, SQL, MS Project, MS Excel and Word, PeopleSoft Application Designer, Process Scheduler, UltraEdit
Confidential
Learning Management Developer
Responsibilities:
- Modified delivered Peoplecode supporting the Self Service modules with Aegon customizations
- Coded customized error capturing page
- Created test scripts with Business Analyst
- Tested customizations with Business Analyst
- Created technical specification document defining customization
- Attended the weekly status meetings
Environment: DB2/MVS, SQL, Peoplecode, PeopleSoft Self-Service and Learning Management modules, PeopleTools, MS Word, PeopleSoft Application Designer, TSO, Panvalet, File-Aid
Confidential
PeopleSoft Upgrade Testing Team
Responsibilities:
- Developed test scripts for ePerformance, eRecruit, and Benefit modules
- Created test plan with Benefits Analyst for the ePerformance, eRecruit, and Benefit modules
- Also created special test scripts more custom to Confidential with Benefits Analyst
- Processed online self-Service testing
- Executed Payroll calc’s and confirms
- Wrote testing documentation defining testing process and results
- Participated in post implementation support
Environment: PeopleSoft: HR, ePerformance, eRecruit, TAM, MS: Project, Excel and Word, Unix/Oracle, PeopleTools, SQL, PeopleSoft Queries
Confidential
PeopleSoft Benefits Customization Technical Developer
Responsibilities:
- Attended weekly fit gap and specification gathering meetings
- Wrote functional specification document
- Wrote technical specification document
- Wrote customized benefits Cobol program which also will retrieve necessary data from customized benefits tables
- Coded new SQR program to support new benefits vendor
- Coded new SQR program to support GL interface program
- Created new PeopleSoft pages to support customization
- Created test scripts
- Developed test plan to test all new programs and interface programs
- Worked with Benefits Analyst during testing
- Participated in post implementation and resolved all issues that arose
Environment: PeopleTools, SQR, Microfocus Cobol, Oracle/Unix, MS: (Project, Word, Excel), PeopleSoft: (HR, Benefits, Benefits Admin), Application Designer, UltraEdit
Confidential
PeopleSoft Production Support Developer
Responsibilities:
- Resolved daily PeopleSoft issues: security settings, password resets, added new hires, etc
- Resolved ticket issues relating to: HR, Benefits, Payroll
- Addressed all phone called issues
- Documented new issues and inserted into the issue tracking systems for the appropriate department
- Closed/cleared tickets that were resolved to user satisfaction
- Tested changes and fixes with user
- Wrote various PeopleSoft Queries
Environment: PeopleTools, PeopleSoft: (Application Designer, Query, Security, App Engine, Process Scheduler), Unix, Ultra Edit, Microfocus Cobol, SQR, UltraEdit