SUMMARY

• Over 6 years of IT experience in system analysis, design, development, testing and implementation of ERP applications.
• Experience in customization, implementation, and upgrades of PeopleSoft HRMS/HCM, including Human Resource, NA Payroll, Benefits, Succession Planning, Competencies & Accomplishments, HCM Portal Pack, and PeopleSoft e - Modules (e-Recruit/Talent Acquisition & Candidate Gateway, e-pay, e-Performance, e-Profile Employee/Manager Desktop, and e-Benefits).
• Experience in upgrading PS8.3/8.8 to PS 8.9/9.0/9.1/9.2
• Experienced in design of technical/functional specification based on the end user interaction.
• Being a Consultant expert in dealing with HRMS, Benefits, Payroll End-users, explains them the pros & cons of developing projects & provides innovative and alternate solutions for their requirements.
• Integration broker, Application messaging, Web Services, WSDL, XML, SOAP.
• Proficient in performing fit gap analysis, design, Interfacing, conversion and report writing using People tools, People code, application Engine & SQR.
• Demonstrated skills on PeopleSoft Pure Internet Architecture (PIA).
• Experience in PeopleSoft 8.x Upgrade (7.5 to 8.0/8.3/8.8/ 8.9/9.0/9.1/9.2 ) & full life cycle implementation.
• Strong functional expertise in Human Resources, North American Payroll (US Payroll), Base Benefits, Benefits Administration.
• Solid experience in complex reporting using SQR, PS/Query and Crystal Reports.
• Expertise in Designing Functional & Technical Specifications as Per CMM Level 5 & 6-sigma Standards.
• Commendable experience in Data Conversion, Migration, Import and Upgrade involving the tools like People Tools, SQL,SQR, XMLP, AE programs, Component Interfaces, Data Mover and Import Manager.
• Demonstrated Expertise with Application Upgrade, Tax Updates, Tuxedo, Web logic, Web Sphere and Security Administration.
• Expertise in the Complete Installation process of PeopleSoft, Application Server, & Portal Configuration.
• Expertise in developing interfaces to Taleo /Success Factors/Kronos /Sum Total Applications.
• Developed complex PeopleSoft work flow’s for automation of the business processes.
• Experienced in Unit testing and Integration Testing of PeopleSoft objects and work products.
• Expertise in developing Oracle PL/SQL, SQL stored procedures.
• Experienced in using version control tools STAT, PVCS, CVS, CA Harvest.
• Motivated, hardworking individual with excellent communication skills.
• Utilizing the APP Designer tool, researched the Field, Page or Record layout to expedite the development team’s resolution to functional issues.
• Produced many ad-hoc reports using SQL, PS Query or Crystal reports to verify data within the system data table. Produced reports to validate system user access were in compliant with Internal Audit request and access in compliance with SOX regulations.

TECHNICAL SKILLS

PeopleSoft ERP: PeopleSoft HCM (Base Benefits, Benefits Administration, North American Payroll, Workforce Admin, e-Benefitse-pay), ADP EHRMS

People Tools: Application Designer, Application Engine, Component InterfaceApplication Messaging, File Layout, Query Manager, Change AssistantData Mover, Configuration Manager, Process Scheduler, WorkflowProcess Scheduler, Maintain Security, Integration Broker

Programming Languages: People code, SQL, PL/SQL, Java, C++

Reporting Tools: SQL, XMLP (XML Publisher) SQR, Crystal Reports, Report Smith, Toad

Admin Tools: Security Administrator, Maintain Security, Object Security, Mercury Test Center

App. Servers: Web Logic 8.x, Web Sphere 5.1

Data Bases: Oracle 6i/9i/10g, SQL Server

Operating Systems: UNIX, Windows NT/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

PeopleSoft Technical Consultant

Responsibilities:

• Requirement Gathering and fit gap analysis to document gaps business process
• Design/Development/testing of PeopleSoft Interfaces/Reports/Online customizations using People Tools.
• Work with end users to gather requirements and translate them in to design documents.
• Work with end user to find solutions to functional gaps and proposing best solutions.
• Create test scripts and prepare requirement traceability matrices
• Perform peer reviews and migration/security validations
• Provide support during UAT/Production deployment
• Provide production support on critical interface issues.
• Setup the PeopleSoft assigned appropriate access based on functional job requirements. Liaison between technical project teams and end-users to ensure security was assigned properly for new systems.
• Created new Roles and Permission list.
• Create custom security reports for audit purposes.
• Setup Query Security trees and department security trees
• Run Periodic security jobs and run portal security Sync when required.
• Develop interfaces and reports using SQR, Application Engine, XMLP, PS Query
• Test end to end payroll cycles to confirm calculations
• Customize and create new payroll interfaces and reports
• Work with end users and guide the domain team in user acceptance testing
• Participated in applying Tax Updates and fixes
• Resolve payroll errors and help users with payroll related queries and issues.
• Created custom formulas to support Absence Management module in calc process.
• Involved in Analysis, Design & Development of Fidelity Outbound SQR Interface for 401k Contributions & Loan Repayments.
• Created a SQR program which checks for the terminated employees in the organization and shuts down the parking benefits of the employee
• Created a SQR program to update the benefits of the INTER-COMPANY transferred employees based on their transferred company location

Environment: ERP: PeopleSoft HCM (HR, Benefits, N/A Payroll, e-modules) 9.0/9.2

Confidential, St Louis MO

Senior PeopleSoft HCM Technical Consultant

Responsibilities:

• Responsible for gathering User Requirements and designing the Technical & Functional Specs as per the new Version of PeopleSoft 8.9
• Created and implemented express vendor business process using PS workflow and Component interface.
• Involved in running Tax-Updates, Patches & Fixes using Change Assistant Tool.
• Responsible for Production Support of current PeopleSoft 8.9 Version.
• Success Factors Interfaces and reports using XMLP/Crystal Reports.
• Create custom security reports for audit purposes.
• Run Periodic security jobs and run portal security Sync when required.
• Resolved the issue with on-line Checks in Portals for Check Print.
• Configured Absence Management setup pages so employee can enter there takes on Self Service pages.
• Resolved the Issues related to the payroll Error Messages occurred after PAYLOAD Process runs.
• Involved in analyzing the Data Errors that occurred when off cycle payroll is run and fixed those Issues.
• Involved in resolving Issues related to Payroll Error Messages when Rapid Entry Pay sheet is run.
• Cloned the DDP003.sqr and added additional Logic as per the Client Requirement which produces interface files to ADP for printing of checks and advices history.
• Customized the pay002.sqr pay register by adding fast views to implement row level security for this program.

Environment: ERP: PeopleSoft HCM (HR, Benefits, N/A Payroll, e-modules) 8.9/9.1

Confidential, Miamisburg OH

PeopleSoft Technical Consultant

Responsibilities:

• Involved in Analysis, Design & Development of Custom gdbenhel.sqr for provide benefit enrollment information to benefits provider.
• Customized the Outbound SQR Interface to send Appropriate Business Phone, Cell Phone and E-Mail Address Information to labor office.
• Involved in Analysis, design & development of Custom SQR to Merrill Lynch as per the Client Specifications for Stock Options.
• Wrote Custom Interfaces from scratch for LT Tax like Tax Withholdings by Pay Cycle, Quarterly Unemployment, and Reconciliation Interface.
• Designed & developed an interface which loads all employees’ emails & their personal Information from People Finder (External Software) into PeopleSoft System.
• Designed & Developed an Interface which shows the Organizational Structure for an entered Employee Id.
• Employee offer interfaces with TALEO and Employer manager feed to Taleo.
• Responsible for Design & Development of Sales Incentive Load program which loads data into Post Payroll tables before running the confirmation process.
• Developed outbound Interface which calculates tax withholding by pay cycle to third party Software (LT Tax).
• Developed outbound interface which calculates the Quarterly Unemployment and sends to LT Tax.
• Involved in Designing & Developing custom Tax Re-Conciliation report which runs for every pay period.