SUMMARY

• Over 10+ years of experience in Implementation, Upgrade, Customization, Development, and Enhancement of PeopleSoft HRMS 8.X, HCM 8.9 and 9.x(Core HR, NA Payroll, Base Benefits, Benefits Administration, Self Service (MSS/ESS), TAM (Recruit Workforce +e - Recruit), Time and Labor, performance management, Learning Management system (LMS) and FMS applications.
• Excellent working experience of PeopleSoft 8.x PIA (PeopleSoft Internet Architecture), Web Browser, Web Server, Application Server and Data Base Server
• Well versed in People Tools version 8.5x: Application Designer, People Code, Query, Process Scheduler, Application Engine, Component Interface, File Layouts, Application Packages, Integration Broker, Data Mover and Change Assistant.
• Technically proficient in performing User/Security administration, interfacing and report writing using SQR, Crystal Reports, PeopleSoft query tool and BI Publisher.
• Experienced in PeopleSoft Application Engine to perform the bulk data base SQL processing with appropriate business validations as per the client requirements.
• Involved in Data Migration and Created Technical Design Documents based on User and Functional requirements.
• Experience in design the UNIX batch jobs to execute SQR programs through scheduling tools.
• Strong working knowledge in RDBMS (SQL, PL/SQL).
• Experienced in writing Test cases, Test Plans & scripts based on system specifications and expertise in unit testing, regression, system integration, functional and performance testing
• Experience also includes Debugging and performance tuning of processes. Well versed with Debugging tools like SQL trace, PC debugger, and Application Engine trace for troubleshooting
• Excellent analytical, problem-solving and communication skills, with particular emphasis on clearly communicating/documenting detailed Business Requirements

TECHNICAL SKILLS

Management/Leadership Skills: PeopleSoft Associate Projects in CSC India Pvt Ltd

Methodologies Used: Waterfall (SDLC) and Agile(Adaptive)

Functional Skills: HRMS 8.x, HCM 8.9/9.x (HR, Payroll, Benefits, Ben Admin, Time Labor, TAM, Candidate Gateway, Performance Management and Self-Service Modules)

Software, Tools: People Tools 8.xx -Application Designer, People Code, Application Engine, Component Interface, Process Scheduler, PC Debugger, Data Mover, Security, PS Query, Application Packages, Integration Broker, Change Assistant, Query Tool, Crystal, STAT tool, XML Publisher, nVision, Informatica

Databases: Oracle, SQL Server and DB2

Operating Systems: Windows, UNIX (HP-UX)

PROFESSIONAL EXPERIENCE

PeopleSoft Technical Consultant

Confidential

Environment: People Soft HRMS(9.x), People Tools (8.53), PS Query, PL/SQL, Informatica.

Responsibilities:

• Responsible to perform the analysis for various enhancements, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities
• Understanding the Confidential Environments and their different ticketing system i.e. Oscar, TSR and JIRA.
• Worked on resolving day to day Query Issues raised by HRIS team.
• Worked on creating analysis and solution documents for different Oscar tickets.
• Preparing migration document for moving enhancement to Production environment.
• Enabling forgot password link for PeopleSoft CABS - HRIS system.
• Worked on Data migration activity for generating output files from PeopleSoft Database to Success Factor.
• Effectively worked on Informatica tool for generating mapping files based on client requirement.
• Involved in modifications /additions and support to the Peoplesoft delivered software package. Record definitions, pages, components and people code needed to be changed to meet the business needs of the Client, which encompasses study of the Business process and business flow
• Used People Code to control the program flow and logic for validation to meet the current business requirements.
• Cloned some run control records to run the process and jobs according to the client specifications through process scheduler
• Performed SQL/SQRs tuning to improve performance using advance SQR features like Load lookup and Arrays and through creating new indexes.
• Delivered Adhoc reports as per the business user requirements.
• Involved in unit testing and review of the requests in the project
• Responsible to create Archive sets for project (CSR’s) migration using STAT tool.

PeopleSoft Technical Consultant

Confidential

Environment: People Soft HRMS, ELM (9.x), People Tools (8.53), PS Query, DB2

Responsibilities:

• Preparing high level effort estimate for all the feasible requirements.
• Preparing functional specification document and giving walk- through to client for all the new requirements.
• Prepared Technical Design Documents, Unit Test Case documents, Test Plan for all the business processes.
• Worked on enabling delivered programs functionality rollout for ELM users.
• Worked on creating new pagelets for most enrolled and highest rated learnings.
• Worked on customizing Search catalog page as per new requirement.
• Created new custom process for register learners to programs and also created Job code based auto registration learner to programs.
• Prepared user guides and training materials for all the business Processes.
• Worked on connected Queries and XMLP reports for eTalent Enhancements.
• Developed new UNIX ftp scripts to transfer the outbound absence files to client specified paths.
• Responsible to perform the analysis for various enhancements, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities
• Involved in the analysis of compare reports, re-applying and retrofitting of client customizations
• Involved in the data conversion and data clean up activities.
• Involved in analysis, coding, unit testing and review of the requests in the project
• Developed, tests, implements and maintains attendance points requirements
• Responsible to create Move to Production (MTP) documents and project (CSR’s) migration using conventional application designer upgrade tool.

PeopleSoft Technical Consultant

Confidential

Environment: People Soft Finance (9.x), People Tools (8.53), SQR, nVision and Crystal Reports.

Responsibilities:

• Preparation of the following various technical documents, Requirement Specification document, Detailed Design Document, System test plan and test procedure document and implementation plans
• Conducted multiple workshops on Fit/Gap analysis and delivered the documentation on upgrading the current system to 9.1 to project review committee.
• Worked extensively in retrofitting of records and PS Query’s.
• Worked on Retrofitting SQR’s, Crystal reports and nVISION reports.
• Worked on New enhancement related to SQR's, PSQuery, Crystal and Nvision reports.
• Developed New PeopleSoft Query’s in 9.1 Environment.
• Extensively Worked on UAT bug fixing related to ALL reports.
• Worked on new sing-in page implementation in 91 Environment.
• Created new Bi Publisher report for APPO requirement.
• Supporting upgraded system after go live.
• Responsible to create Move to Production (MTP) documents and project (CSR’s) migration using STAT tool.

Senior Software Engineer

Confidential

Environment: People Soft HRMS (8.8 & 9.1), People Tools (8.50 & 8.52), SQR and UNIX.

Responsibilities:

• As a team member of project involved in the development and customization of on-line panels, record definitions and menus using People Tools like Application Designer
• Involved in Fit - gap analysis for both internal and external objects.
• Involved in preparation of retrofitting guide lines.
• Involved in Field Change impact analysis for upgrade due to change in LINE NUM and PAGE NUM field length change.
• Involved in Record Change impact analysis for upgrade due to change in EMPLOYMENT and PERSONAL DATA records.
• Worked extensively in retrofitting of fields, records, pages, components and people code.
• Extensive involvement in retrofitting of reports using SQR, Application Engine Programs.
• Extensively involved in unit / integration testing of the upgrade version after each upgrade pass
• Involved in deletion of Upgrade Obsolete Object Project (OOP)
• Prepared a detailed test plan for unit, integration testing. document.
• Extensively used PS/Query to develop ad-hoc queries, generate crystal reports and to produce analyzing reports using excel.
• Used Application debugging tool and PS Trace/Debug options to capture the errors on various PeopleCode and SQL code.
• Performed SQL/SQRs tuning to improve performance using advance SQR features like Load lookup and Arrays.

Senior Software Engineer

Confidential

Environment: People Soft HRMS 8.8 People Tools 8.50, SQR and UNIX.

Responsibilities:

• Involved in modifications /additions and support to the Peoplesoft delivered software package. Record definitions, pages, components and people code needed to be changed to meet the business needs of the Client, which encompasses study of the Business process and business flow
• Involved in understanding of Confidential S&SP payroll process and modified few inbound and outbound processes.
• Worked on fidelity outbound interface which sends our payroll data to Third party vendor.
• Created new online page for T&L and implemented row level security on it.
• Used People Code to control the program flow and logic for validation to meet the current business requirements.
• Designed interfaces using application engine and file layout to upload data from legacy systems to peoplesoft database.
• Developed and customized peoplesoft delivered SQR reports according to the client requirements.
• Developed several reports using SQR and PS/ QUERY and submitted processes to the process scheduler to run daily tasks at a specific time to run process recursively at a specific interval
• Cloned some run control records to run the process and jobs according to the client specifications through process scheduler
• Extensively used Application Engine to perform background SQL Process
• Involved in testing of various purposes to improve the quality of the queries written using PS-Query.
• Prepared DUT test plans for newly created and modified objects.
• Migrated objects from one environment to other environment by using CAPI tool.
• Conceptual Knowledge about Talent Acquisition Management Process.

Associate Projects

Confidential

Environment: People Soft HRMS (9.0), People Tools (8.495), SQR and UNIX

Responsibilities:

• Understanding the Confidential -AON integration project requirements.
• Understand fidelity stock data load programs and extract same data from Confidential database.
• Developed new inbound interface and shell script to generated employee’s stock data file.
• Developing new Inbound interfaces which will read data from input stock files and load data into payroll tables.
• Ran the payroll for several times for NA employees to verify how the stock deductions are happing in employees pay check.
• Controlled Change Management process. Only allow items to production based on approvals from various business owners. Proper documentation is maintained for explanation. Migrations are restricted to PS Admins.

Associate Projects

Confidential

Environment: People Soft HRMS (9.0), People Tools (8.495), SQR and UNIX.

Responsibilities:

• Working on Preparing New TDD’s for Tree Vision Project.
• Developing New SQR’s for Tree Vision Project.
• Involved in Creating New Online pages for Tree Vision Project.
• Developed new PS Query’s for European region.
• Developed new Application Engine and Component Interface programs for Tree Vision Project.
• Worked on security to grant access for newly created pages to specific group.
• Worked with HPQC tool to fix bugs those are reported

Associate Projects

Confidential

Environment: People Soft HRMS (8.0 & 9.0), People Tools (8.17 & 8.49), SQR and UNIX.

Responsibilities:

• Involved in Preparation of new TDD's in 9.0 Environment.
• Retrofitting the Benefits SQR’s, App Engine from 8.0 version to the 9.0 version.
• Involved in the SIT testing of SQR’s and App Engine in 9.0 version.
• Involved in Development of new payroll SQR in 9.0 Environment.
• Worked on Row Level and Query Security.
• Involved in Fine Tuning and Modification of PS Query’s.