SUMMARY

• Highly motivated and results - oriented Technical PeopleSoft Consultant with 7 years of experience in Analysis, Solution Design, Implementation, Development, Customization, Maintenance, Data Conversion, Upgrade, Testing, Project Management and Off-shore Team Management and support of various applications.
• Strong working knowledge on People Tools - Application Designer, Application Engine, PeopleCode, Process Scheduler, PS Query, File Layout, XL to CI, Component Interface (CI), Application Package, SQL, Data Mover, BI Publisher, Integration Broker, Web Services, and SQR.
• Experience in Data Conversions between PeopleSoft and legacy systems including conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Expert understanding of PeopleSoft HR Modules - Core HR, Workforce Administration, Base Benefits, North American Payroll, Time & Labor and Talent Acquisition Management (TAM) and GL.
• Good experience on PeopleSoft 8.9/9.0 to 9.1/9.2 Application Upgrade.
• Having On-shore/Off-shore team management experience with multi-tasking abilities.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Interfaces - Extensively worked on inbound and out bound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using Application Engine, File Layout, Component Interface (CI), XL to CI and SQR.
• Extensive experience of different types of testing e.g. Unit Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Load and Performance Testing.
• Documentation - Involved in analysis, creation and updating the Functional Design Document (FDD), Technical Design Document (TDD), Process Flow, Processing Logic, Unit Test Plan Document (UTP), Migration Check List, Minutes of Meeting (MOM), Weekly Status Reports, Coding Standards Document, End User Training Documents, Data Mapping & Conversion Strategy Documents.
• Having good experience of System Development Life Cycle (SDLC) for successful completion of projects.
• Work Experience on UNIX, Windows Servers, Shell Script, Batch Scheduling Application Control-M, Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Control Tool STAT and Defect Tracking Tools like HP Quality Center and Test Director.
• Analyzed and Applied Tax Updates, HR Bundles & Patches extensively.
• Having good experience of Migrations Activities within application upgrade using STAT migration tool.

TECHNICAL SKILLS

• PeopleSoft Financials/HRMS/ELM/Portal (9.2, 9.1, 9.0, 8.9)
• Application Designer JDeveloper PeopleCode
• Application Engine File Layout Component Interface
• SOAP UI BI Publisher SQR
• HTML/CSS Integration Broker Crystal Reports
• PS Query Unix Web Services

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Data Conversion Developer

Responsibilities:

• Involved in Design, implementation, and supported data conversions as part of an implementation of a new PeopleSoft HCM system.
• Participated in peer reviews and inspections of requirements documents, functional / technical designs, and code.
• Involved in applying advanced application programming concepts in designing, developing, modifying, debugging, and evaluating highly complex conversion programs using People Tools technology.
• Create migration packages and develop scripts for data and code objects to be migrated across instances.
• Initiated and recommended changes in development, maintenance, and system standards.
• Developed Application engines to load Tax data, Direct Deposit, Balances, Personal and Job data into PeopleSoft system from legacy system by performing complex transformations and validations.
• Created Component Interface and Application Engines for loading Additional Pay(by generating other income and prorated income) into PeopleSoft system based on Earning code, Pay Begin date, Pay End date and Earnings Date .
• Involved in pay parallel testing during the conversion runs to load the data into PeopleSoft System.
• Modified and develop Application Engine to load 2020 W4 forms data into the system to calculate accurate Tax Data for 2020 paycheck for an employee.
• Involved in developing the Application packages for Error handling and page level validations.
• Created multiple Component Interfaces to load multiple JOB Data. Created three mandatory rows for each employee (conversion dated row, distribution row, hire date row) during conversion.
• Customized Application Engine programs and Application Packages based on client requirements. Also, created Technical Designs for assigned ac tivities.
• Technical programming experience and conversion knowledge in the development phase of the Conversion project, researching and documenting many of the issues in conversion runs.
• Analyzing critical Development and Configuration Issues and proposing so lutions.
• Identify, resolve and escalate project issues (when necessary) in a reasonable period of time.
• Act as a liaison between functional and technical conversion teams . Assist the University's locations in converted data validation and issue resolution.
• Developed a custom interface to load a flat file from the bank as part of Bank Reconciliation process to our People soft system. It involved validating of bank ID, Account etc. and also mapping of fields to the bank statement table and recon cycle header tables.
• Worked on customizations for lock box and payment predictor.
• Good understanding for Critical aspects of PC Fund Distribution and Pricing. Worked with Oracle to resolve some critical issues with these processes.
• Perform application troubleshooting and problem solving related to conversion.
• Involved in supporting upgrade of PeopleSoft HCM 9.2 and People Tools 8.54, 8.55, 8.56. Involved in the design, development and testing of all HR, Manager Self Service and Employee Self Service.
• Modified the application package people code on different TAM pages like Career and Job Posting pages.
• Design and develop new and custom applications and pages for PeopleSoft HCM modules like Recruiting, E-Performance and Core HR.
• Developed many interfaces to receive and send data from one PeopleSoft system to another PeopleSoft system.
• Developed web services to integrate the third party system to PeopleSoft HCM system.
• Developed application package for web service project that is assigned to send the required data fields based on the position fields.
• Solved many issues for existing applications in E-Performance and Recruiting modules.
• Modified the existing HR interface programs (SQR, Application Engine) as per new version changes.
• Responsible for resolving production issues which gets created thru Service Manager Ticket tracking Tools.
• Worked with ExcelToCI tool to import Learning Resources, update/map Learning references to objectives/competencies and written SQL data loading scripts.
• Used Component Interface and Application Engine program for Conversion of JOB data and Personal
• Actively involved in the testing and issue resolution of system integration testing.
• Develop and maintain interfaces and batch control scripts for the PeopleSoft HCM system and supporting processes; develop scripts to support optimal operation of the systems.

Environment: PeopleSoft v9.2, Tools v8.54, v8.55, v8.56, App Package, CI.

Confidential

PeopleSoft Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HCM 9.2 and People Tools 8.54. Involved in the design, development and testing of all HR, Manager Self Service, Employee Self Service and Benefits Administration.
• Involved in gathering the requirements for Recruiting Action Sheet Project using web service to integration PeopleSoft system with other system and prepared BRD for this project.
• Developed application package for web service project to send the required data fields based on the position number from PeopleSoft system to other system. Prepared Technical Design Document for the project.
• Involved in the development of Filed glass Phase I project where we used to send the contractors details to the filed glass and also resolved many issues regarding this after they went to live.
• Developed Web Service project using integration broker to integrate the PeopleSoft system with the BPA system. Required details sent to the BPA system based on the position number filed.
• Configured SOAP UI for testing the RAS Web Service Project using the position based file provided by the team.
• Design and developed existing SQR as per the requirement.
• Responsible for resolving production issues after upgrade to v9.2 which gets created thru Service Manager Ticket tracking Tools.
• Performed requirements gathering and created detailed functional specifications for each modification, including a large bolt on Time & Labor GUI mimicking the functionality of version 9.2.
• Involved in software neutral Timekeeping Analysis Phase, finalized by the selection of PeopleSoft Time & Labor 9.2. Conducted Fit Sessions and prepared Fit/Gap Analysis for each Timekeeping option being considered. Prepared a detailed Cost Benefit Analysis for the Implementation of an automated Time Collection System.
• Led Client through a Time Collection Device and Vendor Analysis and selection process.
• Used Component Interface and Application Engine program for Conversion of JOB data and Personal Data.
• Modified the application package people code on different TAM pages like Career, Job Opening and Job Posting pages.
• Involved in designing and implementing the application enhancements for HCM modules like Recruiting, E-Performance and Core HR.
• Prepared technical design documents for new and existing projects.
• Resolved many issues in Recruiting and E-Performance modules.
• Modified the existing HR interface programs (SQR, Application Engine) as per new version changes.
• Actively involved in the testing and issue resolution of system integration testing and UAT.

Environment: PeopleSoft HCM v9.2, Tools v8.54, App Package, SQR, CI, Web services

Confidential, Long Island city, NY

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HCM 9.2 and People Tools 8.54. Involved in the design, development and testing of all HR, Payroll, Time and Labor, Benefits Administration, Manager Self Service and Employee Self Service.
• Work involved development of interfaces with Component Interfaces to read inbound files and manipulating the PeopleSoft tables such as to creating pay sheet using PSHUP load for over time, creating general deductions, additional pay for the employee.
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing / advice form printing specific to client requirements.
• Responsible for understanding the LIJ Medical Center Recruiting system and make the necessary changes in current Northwell TAM system which is accessed by LIJ employees.
• Modified the TAM pages (for external site) where LIJ employees would go and apply for Northwell job openings.
• Modified the application package people code on different TAM pages like Career and Job Posting pages.
• Modified the existing HR/Payroll interface programs (SQR, Application Engine) as per new version changes.
• Responsible for resolving production (Level 2) issues which gets created thru Service Manager/MAGIC ticket tracking Tools.
• Worked with ExcelToCI tool to import Learning Resources, update/map Learning references to objectives/competencies and written SQL data loading scripts.
• Customized the Candidate Gateway to be section 508 compliant per the PeopleSoft Accessibility guide. Worked with screen reader software JAWS to test the Candidate Gateway for visually impaired users.
• Revised the basic eligibility questions in eRecruit Profile (Int. & Ext.) and Add New Candidates for LIJ Medical Center merger. Involved redesigning the HRS CANDIDATE MANAGER application package.
• Developed custom AWE process to implement custom position request form approval process in HR, worked on the setup of transaction registry, approval process setup, user list and wrote code for instantiating/Launching AWE.
• Worked on the T&L customization of overtime request form pages and developed new pages for missed clock form and absence request form for employee self service and approval pages for manager.
• Worked on the misc. T&L customizations such as timesheet, payable time and exceptions pages.
• Worked on Absence Pay Outbound Interface for NA Payroll: The OT Calc system calculates Overtime Pay for non-exempt employees. A new program is needed to create a file for OT Calc containing time entry transactions for these employees. Prior to PeopleSoft PTO, the old DOTS system used to create this file, which was called OTABS.DAT. This new program will create INTPY022.DAT file will be received at the Payroll office each morning from PeopleSoft. It is a flat fixed length ASCII file, and contains the absence data for each employee.
• Created Application Engine program to enroll associates to STD benefit once they have completed 5 years of service in the organization.
• Performed System Development Life Cycle (SDLC), from analysis and design through testing and supporting.
• Managed full SDLC implementation projects starting from requirements gathering to deployment to transition.
• Used Component Interface and Application Engine program for Conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Life ADD Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Involved in converting the custom crystal reports into BI Publisher reports as per the business need.
• Create Crystal Reports with multiple drilldown and sub-reports.
• Published and scheduled the reports using Crystal Management Console so that reports are accessed from Front-end application.
• Actively involved in the testing and issue resolution of system integration testing and UAT.

Environment: PeopleSoft HCM/ELM v9.2 (TAM, CG, T&L, Payroll, Benefits), Tools v8.54, AWE, App Package