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 PS8.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-Benefits,
• e-pay , ADP EHRMS
• People Tools : Application Designer, Application Engine, Component Interface,
• Application Messaging, File Layout, Query Manager, Change Assistant,
• Data Mover, Configuration Manager, Process Scheduler, Workflow,
• Process 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.

Work Experience:

Confidential

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
• Languages/Tools : SQR, SQL, People Tools 8.50/8.52, People Code, Application
• Engine, Application packages, Change Assistant.
• Database : Oracle

Confidential

Senior PeopleSoft HCM Technical Consultant

Responsibilities:

HRMS/HCM:

• 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.
• Configured Absence Management setup pages so employee can enter there takes on Self Service pages.
• Resolved the issue with on-line Checks in Portals for Check Print.
• Run Periodic security jobs and run portal security Sync when required.
• Create custom security reports for audit purposes.
• Success Factors Interfaces and reports using XMLP/Crystal Reports.
• 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
• Languages/Tools : SQL, SQR 8.16, People Tools 8.44/8.47, People Code, Application
• Engine, Application packages, Change Assistant.
• Database : Oracle 9.i

Confidential

PeopleSoft Technical Consultant

Responsibilities:

HRMS/HCM/Benefits:

• 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.
• Responsible for Design Development of Sales Incentive Load program which loads data into Post Payroll tables before running the confirmation process.
• Employee offer interfaces with TALEO and Employer manager feed to Taleo.
• Designed Developed an Interface which shows the Organizational Structure for an entered Employee Id.
• Designed developed an interface which loads all employees' emails their personal Information from People Finder External Software into PeopleSoft System.
• 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.