SUMMARY:

• Result - Oriented PeopleSoft HCM Application Analyst with extensive experience in HCM data conversions, full-implementations, upgrades, strategic transformation, data migrations, end-user production support, along with a focus on designing and implementing efficient business solutions.
• Progressive technical and functional experience in data conversions, customizations, integration and implementation of PeopleSoft 9.2/9.1/8.9/8.8/8.3/8. x/7.x HCM (HR, Base Benefits, Payroll, Position Management, Recruiting Solutions, Time & Labor, eApps, Self-Service modules).
• Strong technical expertise in PeopleSoft module integration/interfaces, upgrades, data conversions, development, customization, security setup, data migration, workflow and reporting based on PeopleTools 8.55, 8.50, 8.47, 8.46.06, 8.42.05/8.x/7.x.
• Broad and in-depth knowledge and experience in PeopleSoft's programming and enterprise Integration Tools including Application Engine, Integration Broker, Component Interface, PeopleCode, Application Engine, XML/BI Publisher, Application Package, AWE, Fluid and PS Query.
• Successfully completed full Life-Cycle Implementations of PeopleSoft HCM and end-to-end HCM Application Upgrades
• Proficient in all phases of the systems development life-cycle including requirements definition, data conversion, data mapping, integration testing, system implementation.
• Coordinated requirements from end-user community, built business design proposals, functional design specifications and technical specifications for system enhancements. Strong background in Integrations and working with 3rd Party Vendors
• Extensive PeopleSoft development experience using SQR, PeopleTools, SQL and PeopleCode.
• Database Programming experience using Oracle, DB2 & SQL Server
• Efficient team player, ability to multitask with excellent communication and interpersonal skills.
• U.S. Citizen

EXPERIENCE SUMMARY:

Confidential, Confidential, NY

Senior PeopleSoft HCM Consultant

Responsibilities:

• Currently involved in Production Support of PeopleSoft HCM at Confidential - handling break-fix issues, product maintenance and product enhancement requests from end-users
• Utilizing Service Now to support and resolve day-to-day tickets reported by HR/Payroll end-users
• Supporting Core HR, Payroll, Benefits, employee Profile, Time & Labor, Talent Acquisition Manager, ESS, MSS
• Involved in evaluating migration to cloud based HCM product - creating functional design specifications, technical specifications, and documenting custom modifications in PeopleSoft batch and online processing
• Contributed to SAP SuccessFactors data migration planning - produced data compare reports, custom modifications, impact on batch processing. Developed programs to extract data from PeopleSoft to load SuccessFactors
• Developing Excel-To-CI’s and App Engines to load employee data for new Confidential acquisitions
• Supporting creation of migration packages, utilizing HP Quality Center for performing system tests and Dell STAT system for tracking PeopleSoft migration changes and retrofits.
• Built a new Interface process to feed the Person/Employee level data to KRONOS
• Designed and developed an Interface process to load Time detail/Payroll entries into PeopleSoft HCM/Payroll from the KRONOS system daily.
• Developed functionality in PeopleSoft HCM to identify and maintain Time Approvers and Administrators for the daily feed to KRONOS
• Involved in supporting and troubleshooting Integration Broker Issues with Managed Hire process
• Maintain standards documents around PeopleSoft migrations from DEV/UAT/Production

Environment: PeopleSoft HCM, Oracle DB, STAT, HP Quality Center, ServiceNow

Confidential, Washington Confidential, VA

PeopleSoft HCM Lead

Responsibilities:

• Provided expertise on a new PeopleSoft HCM implementation at the Confidential
• Participated in fit-gap sessions for HR, Payroll, Benefits and Pension modules
• Developed Data Conversion Plan / Strategy / Approach / Methodology to convert Senate’s Legacy data into PeopleSoft HR, Payroll, Benefits Administration, Pension & EPM
• Lead the efforts for data mapping sessions with the Senate’s functional stake holders
• Involved in supporting the development team in evaluating the U.S. Senates requirements for interfaces and enhancements. Evaluated and utilized XML Publisher as solution to deliver the Senate’s reporting requirements.
• Participated in planning activities, requirements gathering, creation of functional design documents, technical design documents, and conducted code reviews.
• Developed Data migration scripts, Data Mover scripts, SQRs, CIs, Application Engine programs and related unit testing and integration testing scripts. Played a key role in taking the Confidential system live on HCM.
• For the upgrade efforts, identified and performed code compares, design, build and tests for the PeopleSoft HCM 9.1 to 9.2 Upgrade Project. Retrofitted custom PeopleCode, Application Engine code where appropriate
• Participated in test moves to Production passes, executed test cases for business process verifications, as well as overall integration testing of the upgrade process

Environment: PeopleSoft HCM, Oracle DB, STAT

Confidential, McLean, VA

Senior PeopleSoft Analyst

Responsibilities:

• Provided PeopleSoft expertise to business users in HR, Payroll and Time & Labor
• Was involved in PeopleSoft 8.9 to 9.0 upgrade efforts - participating in fit-gap sessions and contributing towards developing an upgrade mythology, along with executing compare reports
• Worked with end users to design and implement enhancements and configuration setup for Talent Acquisition Manager (TAM)
• Played a key role in evaluating, selecting and working with Talent Technology team for implementing Resume Mirror modules (Resume Extraction, Resume Search, Job Posting)
• Created and lead interactive design and prototype sessions to gather system requirements for implementing TAM 9.1 solution.
• Produced design documents summarizing the design sessions, scope, table setup values, business process flows, communication strategies and TAM 9.1 rollout strategies.
• Developed functional design specifications for each eRecruit customization identified in design sessions.
• Ensured that SDLC and change management processes were followed and documented to support full traceability and transparency of the teams’ tasks. Supported junior team members during technical design creation and unit testing
• Utilized Integration Broker to send employee indicative data to Confidential ’s module
• Coordinated testing (SIT, UAT) of Talent Acquisition Manager and Resume Mirror
• Involved in supporting productions issues, implementing tax updates and ongoing support of PeopleSoft HCM (HR, Payroll, Time and Labor, eRecruit, eTime, ePay, MSS, ESS) - extensively utilizing STAT for change management and to migrate work between development, test, UAT & production environments

Environment: PeopleSoft HCM, Oracle DB, HP ALM, Clarify, STAT

Confidential, Washington

PeopleSoft HCM Lead

Responsibilities:

• Led the effort to consolidate the Confidential Schools Systems human resources / payroll / benefits into PeopleSoft HCM.
• Developed the approach and methodology to bring various District’s contract employees into the customized HRMS Federal system deployed at the Confidential Government
• Conducted Data Mapping sessions to map Legacy Confidential to PeopleSoft HCM
• Developed a dynamic system to load New Hire (US Federal) data into PeopleSoft via Component Interfaces / App Engines / Data Record Layouts
• Participated in planning activities, requirements gathering, functional and technical designs, and conducted code reviews.
• Designed Functional and Technical specifications, developed and deployed a Summer Hire add-on module to PeopleSoft HCM. Several new App Engines, Component Interfaces were utilized in conjunction with Position Management
• Developed System Integration Test Plans, created System Test cases, and provided Post Go-Live support
• Developed and tested delivered and custom workflows within Talent Acquisition Manager
• Assisted the HR support team - worked on SCRs to fix open issues & support of PeopleSoft HCM

Environment: PeopleSoft Federal HRMS, Oracle DB

Confidential, Wilkesboro, NC

PeopleSoft HCM Conversion Lead

Responsibilities:

• Functioned as a PeopleSoft HCM Consultant implementing PeopleSoft HRMS Version 8.8 and ADP GlobalView Payroll for Canada.
• Analyzed existing HR/Payroll/Benefits processes, SQR programs, reports, and interfaces and Employee ID conversion of US employees to a Global ID. Created Test case scenarios for the team to execute system integration tests
• Conducted mapping sessions to map data from PeopleSoft HRMS to ADP G2 Interface Toolset
• Responsible for running weekly and semi-monthly Payroll Cycles during Parallel Test Phase
• Responsible for code modification and testing as per Employee ID conversion & SOX compliance
• Ensured that SDLC and change management processes were followed and documented to support full traceability and transparency
• Utilized SQRs, COBOL, SQL, COBOL stored procedures to developed enhancements to HR modules to fit Confidential ’s specific requirements
• Analyzed SQRs and PeopleTools for planned 8.9 upgrade
• Establish time estimates for PS 8.9 code migration, testing, and deployment

Environment: PeopleSoft HRMS, DB2, COBOL, SQRs

Confidential, Omaha, NE

PeopleSoft Consolidation Lead

Responsibilities:

• Lead for consolidating Confidential and TD Waterhouse HR/Payroll/Benef Confidential .
• Conducted thorough study and analysis of the existing TDW’s Hrizon / ADP system
• Developed strategy and methodology of consolidating Confidential and TD PeopleSoft HRMS 8.8 (Payroll, Benefits, Human Resources, Time and Labor).
• Key player in defining consolidation strategy & TDW data conversion approach
• Conducted fit gap design sessions and data mapping sessions
• Lead teams comprising of TDW database experts, Technical experts and PeopleSoft 8.8 functional experts
• Designed and developed functional & technical specifications, along with coding complex Application Engine (App Engines) programs and SQRs to massage, convert and load data from SQL Server 2000 to Oracle 9i PeopleSoft database.
• Assisted with applying PeopleSoft Bundles / Tax Updates
• Assisted Confidential Payroll Team in Production Support
• Provided best-fit solutions for Time and Labor Business Rules
• Designed, coded and tested MetLife Eligibility Interface program. Coded new functionality to Confidential Healthcare and FSA vendors Interfaces. Separately, coded new Workflow functionalities for Confidential ’s Payroll users.

Environment: PeopleSoft HRMS, Payroll, HR, Benefits, Time & Labor, Oracle DB, SQRs

Confidential, Boise, ID

PeopleSoft HCM Conversion Lead

Responsibilities:

• Lead Analyst for analysis and conversion of legacy databases to PeopleSoft HRMS 8.8 (Payroll, Benefits, Human Resources - the total population converted was approximately 350,000 active employees)
• Key player in defining conversion scope, conversion strategy & legacy data conversion road-map
• Conducted fit/gap design sessions and data mapping sessions - leading teams comprising of Confidential legacy data experts, PeopleSoft functional experts and Technical experts
• Recommended the best-fit solutions to developing conversion scripts and conversion programs
• Designed and developed functional & technical specifications, along with coding and executing complex conversion programs using SQRs, PeopleCode Component Interface, and PeopleTools
• Developed and implemented programs that generated conversion scripts based on PeopleTools definitions - thereby producing a substantial savings in coding time.
• Functioned as a liaison and advisor to Interface team members - providing expertise in designing and developing external interface specifications for PeopleSoft HR modules
• Provide technical expertise to other teams in areas of database design, conversion engine specifications, PeopleSoft technologies (PeopleCode, PeopleTools, Business Components, SQRs, Application Engine modules), along with providing expertise and liaison with mainframe staff (IMS, MVS, JCL, TSO/ISPF, COBOL Stored Procedures, DB2, COBOL)
• Provided post-implementation production support for Payroll related issues
• Additionally, worked with the Benefits Functional team to re-design key functionalities of Employee Self Service modules - in particular, wrote functional and technical design documents for eBenefits and ePay modules - redesigning page functionalities, Electronic Signature functionalities, Dependent/Beneficiary process improvements, providing State W-4 forms, COBRA Rights notices, and links to external vendor sites.

Environment: PeopleSoft HRMS, Oracle DB, IMS, DB2, COBOL, SQRs

Confidential., Chicago, IL

PeopleSoft HRMS Consultant

Responsibilities:

• As a team member on a Payroll/HRMS PECO Energy consolidation project, contributed in design and customization of PeopleSoft objects, PeopleTools, SQR(s) and Query/Crystal.
• Role entailed providing functional and technical assistance to different Confidential project teams, along with working with end users to develop and design system-wide product customizations.
• Was also involved in comparing and retro-fitting PeopleCode modifications, enhancing Confidential customized panels, records and menus.
• For these efforts, extensively used PeopleTools- including Process Scheduler, Application designer, Crystal Reports, PS Query and SQRW.
• Conducted Performance Tuning of Time Admin Process
• In addition to this technical role, designed and developed several SQR programs related to PeopleSoft Time and Labor, Payroll and internal Interface programs.

Environment: PeopleSoft HRMS, Oracle DBMS, SQR, Unix Servers

Caremark, Northbrook, IL

PeopleSoft Upgrade Consultant

Responsibilities:

• Functioned as a critical member of a team upgrading PeopleSoft Human Resource, Payroll and Benefits modules, version 7.5.
• Responsible for evaluating, comparing and customizing and upgrading SQR programs. Also involved in comparing and upgrading PeopleCode modifications, Caremark customized panels, records and menus.
• Assisted with applying PeopleSoft Updates and Bundles
• Utilized several PeopleTools including Process Scheduler, Application designer, Workflow, Import Manager, Crystal Reports, PS Query, COBOL, SQRW, and operator security.
• Responsible for designing and developing several key interfaces - Caremark Benefits related data to various Health Carriers - First Health, Aetna Healthcare, Magellan, & Caremark PSD Services.

Environment: Oracle & DB2 DBMS, COBOL, SQR, Windows 98/NT Servers, PeopleSoft HRMS

Confidential, Milwaukee, WI

PeopleSoft Product Consultant

Responsibilities:

• Played a key role in implementing PeopleSoft Human Resource, Payroll and Benefits modules, version 7.5.
• Was involved in writing complex SQR programs that fed time and attendance data from Kronos into PeopleSoft Paysheets and other time repository custom tables.
• In conjunction with the PeopleSoft Payroll time and attendance implementation, designed, coded and customized online rapid entry panels according to client requirements.
• Successfully made PeopleCode modifications, and helped in customizing delivered panels, records and menus.
• Participated in designing, developing and coding several customized SQR reports related rapid time entry, payroll and tax processing. Modified the PeopleSoft batch Leave Accrual process to handle prorated accruals, freeze periods and special processing of employees on leave of absence or terminated in the current week.
• Utilized several PeopleTools including Process Scheduler, Application designer, Import Manager, Crystal Reports, PS Query, SQRW, and in setting up operator security. Additionally, also designed and developed 2 interface programs to pass Periodic and Quarterly Tax data from PeopleSoft Payroll to ADP AutoTax services.
• Trained end-users on procedures and processes pertaining to the new modules & panels developed.

Environment: SQL Server, SQR, Windows 98/NT Server, PeopleSoft HRMS

Confidential, Chicago, IL 8

PeopleSoft Consultant

Responsibilities:

• Technical and functional resource for implementing Peoplesoft HRMS version 7.0.
• Designed and coded Payroll and Benefits reports according to User needs.
• Created system design documents for interfaces to external systems, along with designing and coding a new rapid time-entry system in the PeopleSoft Payroll module.
• Played a vital role in setting up testing environments and for successful testing of interfaces & reports. Was also responsible for design and creation of departmental timesheets using SQR, and for analysis and design of interfaces from Kronos time entry system to PeopleSoft Payroll.

Environment: DB2, COBOL, MVS & ORACLE DBMS on UNIX operating system

Confidential, Chicago, IL

PeopleSoft Consultant

Responsibilities:

• Functioned as a technical resource on a PeopleSoft HRMS.
• Analyzed customer’s current data conversion and migration needs and participated in implementing the recommended approaches.
• Instrumental in setting-up the current change management procedures related to PeopleTools customizations.
• Gathered user requirements, based on which performed detailed functional and technical design of online customizations.
• Designed, coded and successfully implemented Position Data to Job Data auto-feed system that incorporated complex user requirements.
• Designed a real-time automatic organization hierarchy and Security Tree building system that was driven from changes to employee’s Position Data.
• Provided guidance to other team members in designing and coding PeopleCode programs, new Panels, Menus and SQR reports.

Environment: Sybase DBMS on UNIX operating system

Confidential, Danbury, CT

PeopleSoft Consultant

Responsibilities:

• Customized and produced client specific medical SQR reports. This was a fire-fighting mission to analyze existing issues and bugs in custom SQR reports, fix the problems and deliver results, all in record time.
• Along with fixing current code, also designed, coded and unit-tested two new SQR reports using product knowledge in PeopleSoft Payroll and Benef Confidential s.

Environment: DB2 DBMS on MVS operating system

Confidential, Hoffman Estates, IL

PeopleSoft Consultant

Responsibilities:

• Developed data mapping between the existing Legacy and the PeopleSoft system.
• Developed numerous migration processes from mainframe to an Informix database.
• Designed and executed test scripts to test converted data using SQL scripts and reporting tools.
• Wrote numerous Payroll and HR interfaces both inbound and outbound.
• Interacted with different vendors to make outbound interfaces compliant with the systems present at the vendor's site.
• Designed and developed numerous HR, Benefits and Payroll reports using SQR and Crystal Reports.

Environment: Informix DBMS on UNIX, COBOL, DB2 on MVS operating system

Confidential, Schaumburg, IL

Human Resources Implementation Team Leader

Responsibilities:

• Developed and implemented three new client/server human resource systems, enabling the company to better manage more than 150,000 employees world-wide.
• Responsible for coordinating and executing successful system development/customization, integration/parallel system tests and conversion. The following applications were included in the new systems: human resources, payroll, benefits administration, employee history, /recruiting, data security, and reporting hierarchy.
• Also served as the primary consultant in designing and implementing interfaces between legacy systems and client/server systems - providing distinct solutions that cut client budgets by more than $150,000.00.

Environment: DB2 DBMS on MVS operating system / Oracle on UNIX

Confidential., Hartford, CT

Human Resources Principal Consultant

Responsibilities:

• Provided client/server and mainframe expertise to a team of IS professionals implementing Payroll and Personnel management systems.
• Integral part of a team in areas of designing PC/mainframe interfaces. Also designed, coded and implemented a real-time check writing system for Payroll and Employee Garnishment systems.
• Primary design and implementation responsibility for all compensation related activities included: design and document detailed business requirements, design and document package modifications, interfaces, and reports.
• Developed and implemented Operator Security for 1500+ users. Also participated in performing end-user and producing system guides for the global implementation of the new Human Resources package.

Confidential, Kansas City, MO

Human Resources Consultant

Responsibilities:

• Assisted human resources management in evaluating and documenting existing company policies and HR procedures, making improvements as necessary to fit new Human Resources packaged software.
• Supervised a team of 8 consultants and client employees for design, customization and implementation of on-line Personnel, Payroll and Benefits management system.
• Was responsible for a final successful release of the production system and was also voted the Most Valuable Player among the implementation team.

Confidential, Walnut Creek, CA

Senior Systems Analyst

Responsibilities:

• Coordinated a total of 115 successful Human Resources software installations at Fortune 500 clients. Traveled extensively throughout Confidential States and Canada to meet customer needs and requirements.
• Had a unique 100% success rate in completing implementations of software products at client sites and in obtaining client satisfactions. Also provided technical and application know-how to the software company’s product development teams.
• Confidential regular duties, contributed to recruiting, selecting and other systems professionals in the department.

SKILLS SUMMARY

PeopleSoft PeopleTools: Application Designer, Application Engine, Integration Broker, Application Packaging, PeopleCode, Change Assistant, Component Interface, SQR/SQL, Data Mover, Workflow, Import Manager, Query/Crystal, Process Scheduler, PS Security, XML Publisher, PeopleTools 8.54

Operating Systems: Unix, Shell Scripting, Windows NT/2000 Server, MVS/OS390

PeopleSoft Modules: PeopleSoft 9.2 HCM, Benefits Administration eBenefits eRecruit (TAM), Time & Labor, Payroll, Employee Self Service

Databases: SQL Server 2000, Oracle, DB2

Other Skills/Languages: Waterfall Project Management, System Integration Testing, Artificial Intelligence, HP ALM Quality Center, HTML/DHTML, Dell STAT Version Control, JavaScript, Active Server Pages