SUMMARY:

• Over 14+ years’ experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• Excellent experience in PeopleSoft 9.2, PeopleSoft 9.1, PeopleSoft 9.0, PeopleSoft 8.9, PeopleSoft 8.8 Upgrade projects.
• 3 full implementation lifecycle experience as a PeopleSoft Conversion Development Manager with a thorough understanding of conversion, configuration and integration between major functional areas within PeopleSoft HCM 9.2
• Have extensive experience implementing and supporting complex public sector pensions functionality including July Rate changes, multiple pension programs by labor agreement, integration between human resources and pensions, etc.
• Experience with PeopleSoft human capital management upgrade and/or implementation activities at public sector, higher education, or healthcare industry clients.
• Expertise working on customized Oracle, PeopleSoft HCM and integrating with PeopleSoft or Oracle financials, supply chain, student, and OBIEE functionality, and custom and/or 3rd Party Systems and Service Providers.
• Extensively worked with People Tools such as Application Designer, Application Engine, Process Scheduler, Data Mover, People Code, Workflow, Component Interface, File Layout, XL to CI, Approval Workflow Engine (AWE), Application Packages, Integration Broker, PeopleSoft security (Roles, Permission lists, User profiles), HTML, PeopleSoft Update Manager(PUM), project migrations and Unix Scripts.
• Extensively Worked on PeopleSoft HR Modules - Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), ePerformance, Candidate gateway/TAM, and Absence management, Position Management, Base Benefits, Benefits Administration, North American Payroll, Compensation and Time & Labour.
• 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 SQR, Application Engine, Component Interface and File Layout.
• Having hands on experience in Manage and Lead a team of conversion developers to design, implement, and support conversion programs for PeopleSoft HCM based on input gathered from a variety of sources including Business Systems Analysts, functional conversion consultants, Client locations, analysis results and industry best practices.
• Worked on the latest toolset People tools 8.55. Developed new pages, components using the fluid designs.
• Used PeopleSoft REST services extensively for exposing PeopleSoft components to outside applications.
• Expertise in developing, Customizing Interfaces and Conversion programs using SQR, Application Engine and Component Interfaces for HCM modules.
• PeopleSoft technical skills include People Tools (Application Designer, People Code, Application Engine, Component Interface, Process Scheduler, PS Query, SQR, Data Mover, Security Administrator and Definition Security, Integration Broker and SOA.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Expertise in the creation of complex reports using SQR, and PS/Query by translating client business requirements into technical specifications. Hands-on experience using template-based reporting tool XML Publisher.
• Worked with reporting and analysing tools such as SQR, BI Publisher /XML Publisher, PS/Query, Crystal.
• Worked on setting up Fluid pages, PeopleSoft Work Centres / Dashboards / Navigation Collections, Pivot tables and related content services.
• Created new dashboards and work centre and used pivot grids to create reports for leadership.
• Strong expertise in Branding and HTML5, CSS 3 and JavaScript.
• Gather Data conversion/ Consolidation requirements for foundation and employee data tables and build the code for all the setup tables and Transactional tables for new 9.1 environments.
• Gather Data conversion requirements for any key functionality that should be migrated to 9.1 as a part of upgrade.

TECHNICAL SKILLS:

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8/8.3/8. x

PeopleSoft Technical Skills: Application Designer, People Code, Application Engine, Data mover, Process Scheduler, PS Query, Security, Component Interface, File Layout, Tree Manager, Process Scheduler, STAT.

PeopleSoft HRMS/HCM Skills: Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), ePerformance, Candidate gateway/TAM, Absence management, Position Management, Base Benefits, Benefits Administration, North America Payroll, Compensation, Time & Labor and E-Applications, KRONOS,GL.

Reporting Tools: PS Query, SQR, Crystal Reports, BI/XML publisher.

Integration Tools: File Layout, Component Interface, Integration Broker, Approval workflow engine (AWE).

Databases: Oracle 9i/10g/11g/12c, Toad, SQL Server, DB2, MS Access.

Languages: SQL, PL/SQL, C, C++, Java, COBOL

Operating Systems: Windows 95/98/2K/NT/XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

Peoplesoft Consultant

Responsibilities:

• Worked performance issue of Delivered processes such as PAYGL02 (General Ledger Interface) and PSPPYRUN.
• Involved in the development and re-design of ESS and MSS modules, North America Payroll, Compensation, Time & Labor based on campuses.
• Implemented Approval Workflow Engine (AWE) line approvals for all GL related interfaces like Direct Retro, Benefit Cost Transfer (BCT) and Funding Entry.
• Developed the new AE process for relates to amount distribution of fringe expense in Confidential, currently, there is no functionality to mark one or more jobs as ineligible to be charged for a given fringe expense deduction code.
• Redesigned the I-101 FS COA-INBOUND INTERFACE by modifying the SQL’s reduce execution time from 8.hrs to 1 hr.
• Worked on the Change Requests related to UC customized processes based on campuses requirements.
• Redesigned the UC customized batch processes.
• Worked the defects related to Benefits, Payroll and GL.

Confidential, Los Angeles, CA

PeopleSoft HCM Techno-Functional Consultant

Environment: People Tools 8.54/8.55, People Code, People Soft HRMS (HR, Base Benefits), Compensation, North America Payroll, Time & Labor, SQR, Oracle 9, Java script tools in PeopleSoft, BI Publisher, App Package, Integration broker and SOA, component interface

Responsibilities:

• Identified required PeopleSoft tables and prepared mapping documents for data conversions from Workday to PeopleSoft (PeopleSoft HR, Payroll, Benefits, and Time & Labor, Absence Management).
• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54/8.55
• Used the Application Engine for writing the Component Interfaces in Payroll and Base HR modules for reapplying the business logic associated with PeopleSoft delivered components using the existing PeopleSoft Component APIs.
• Worked on various conversion interfaces from legacy systems to PeopleSoft Payroll system.
• Getting STD data from Workday to PS and process STD data create STD letters using XML Publisher.
• Developed application engine program for loading WD data from Flat Filed to PeopleSoft Payroll tables using component interfaces.
• Loaded the PS tables from Legacy systems to PeopleSoft systems using component interfaces.
• Developed a number of validation edit to make sure the data is clean before loading the data into the application tables.
• Involved in the development and re-design of ESS and MSS modules, North America Payroll, Compensation, Time & Labor
• Established the connection between PeopleSoft and Third-Party systems for bi-directional data flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging.
• Wrote SQR/PL-SQL scripts to extract Mass change/Application Engine/SQL view scripts.
• Prepared Reports for ARC.
• Customizations and making necessary changes on a regular basis as per the client’s needs.
• Configured the PeopleSoft interaction Hub to develop the landing page for the self-service applications.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft HCM with third party services and publish the employee information from PS HCM to other application.
• Created a custom Application Package for implementing error handling for the custom Load Applicant Data.
• Designed and Developed different custom reports using XML Publisher in TAM module.
• Developed two nightly processes, which include Application Engine and Component Interface to insert the HR Self Service transaction data into job component performing all the job component validations.
• Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.
• Extensively worked on fluid responsive design for ARC screens.
• Creating BI Publisher reports (utilizing connected query) for mortality and life insurance confirmation information.
• Created custom Benefits inbound interface to handle open enrollments and daily enrollments to load into Ben Admin tables, which comes from other UT system.
• Adding modification to display employee name on hyperlink for Manager Self Service.
• 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 SQR, Application Engine, Component Interface and File Layout.
• Developed Inquire panels for Dependent Benefits and Employee Benefits.
• Applying 9.2 related changes to custom Report Time detail page for T&L.
• 9.2 modifications to custom Excess hours report SQR.
• Perform and /or facilitate Code Reviews of all objects and ensure compliance with coding standards.
• Ensure generation of Unit Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of End to End Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of test cases for Integration and performance testing and ensure successful completion of the test phase.
• Created new Permission lists and Roles for the Benefits Self Service module.
• Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports .
• Created a number of reports using Pivot Grids and used them to create Dashboards and Work centres.

Confidential, Irving, TX.

PeopleSoft HCM Techno-Functional Consultant

Environment: People Tools 8.54/8.55, People Code, People Soft HRMS (HR, Base Benefits), North America Payroll, Compensation, Time & Labor,SQR, Oracle 9, Java script tools in PeopleSoft, BI Publisher, App Package, Integration broker and SOA.

Responsibilities:

• Identified required PeopleSoft tables and prepared mapping documents for data conversions from legacy to PeopleSoft (PeopleSoft HR, Payroll, Benefits, and Time & Labour, Absence Management).
• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54/8.55
• Used the Application Engine for writing the Component Interfaces in Payroll and Base HR modules for reapplying the business logic associated with PeopleSoft delivered components using the existing PeopleSoft Component APIs.
• Worked on various conversion interfaces from legacy systems to PeopleSoft Payroll system.
• Getting STD data from Confidential to ARC and process STD data create STD letters using XML Publisher.
• Developed the SQR program to read the STD data from Metlife file and load into Confidential and ARC tables and processed.
• Developed application engine program for loading ARC data from Flat Filed to PeopleSoft Payroll tables using component interfaces.
• Loaded the ARC tables from Legacy systems to PeopleSoft systems using component interfaces.
• Developed a number of validation edit to make sure the data is clean before loading the data into the application tables.
• Involved in the development and re-design of ESS and MSS modules, North America Payroll, Compensation, and Time & Labor.
• Established the connection between PeopleSoft and Third-Party systems for bi-directional data flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging.
• Wrote SQR/PL-SQL scripts to extract Mass change/Application Engine/SQL view scripts.
• Prepared Reports for ARC.
• Customizations and making necessary changes on a regular basis as per the client’s needs.
• Configured the PeopleSoft interaction Hub to develop the landing page for the self-service applications.
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft HCM with third party services and publish the employee information from PS HCM to other application.
• Created a custom Application Package for implementing error handling for the custom Load Applicant Data.
• Designed and Developed different custom reports using XML Publisher in TAM module.
• Developed two nightly processes, which include Application Engine and Component Interface to insert the HR Self Service transaction data into job component performing all the job component validations.
• Worked with PeopleSoft Global Support team to resolve the issues in XML Publisher.
• Extensively worked on fluid responsive design for ARC screens.
• Creating BI Publisher reports (utilizing connected query) for mortality and life insurance confirmation information.
• Created custom Benefits inbound interface to handle open enrollments and daily enrollments to load into Ben Admin tables, which comes from other UT system.
• Adding modification to display employee name on hyperlink for Manager Self Service.
• 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 SQR, Application Engine, Component Interface and File Layout.
• Developed Inquire panels for Dependent Benefits and Employee Benefits.
• Applying 9.2 related changes to custom Report Time detail page for T&L.
• 9.2 modifications to custom Excess hours report SQR.
• Perform and /or facilitate Code Reviews of all objects and ensure compliance with coding standards.
• Ensure generation of Unit Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of End to End Test Cases and monitor Test Results and make any required code corrections.
• Ensure generation of test cases for Integration and performance testing and ensure successful completion of the test phase.
• Created new Permission lists and Roles for the Benefits Self Service module.
• Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports .
• Created a number of reports using Pivot Grids and used them to create Dashboards and Work centres.

Confidential

PeopleSoft HCM Techno-Functional Consultant

Environment: People Tools 8.42, People Code, People Soft HRMS (HR, Base Benefits), North America Payroll, Compensation, Time & Labor, SQR, Oracle 9

Responsibilities:

• Leading the team as a POC.
• Involvement of Client’s calls.
• Developed MMRP Letters using XML publisher.
• Developed SQR reports for generating the employee MMRP information as per the requirements.
• Involved in developing new Components and pages.
• Involved in the development and re-design of ESS and MSS modules, North America Payroll, Compensation, and Time & Labor.
• Worked on Benefits admiration customizations.
• Principle Developer for upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2 and People Tools 8.54
• Participating in Fit/Gap analysis & defining the organizational process related customizations to new functionality under 9.2
• Identifying the level of effort for retrofitting customization to 9.2
• Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Involved and identified Uni-code problem in data which crashes the COBOL procedure called by the Payroll Interface.
• Analyzed the Customizations to the delivered SQR reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired.
• Involved in design and implementation of standard heading SQC's customized to suit client requirements for all the payroll-related reports .
• Designed and Developed interfaces, reports using SQR, Application Engine, Component Interface.
• Designed and developed several interfaces to load data into PeopleSoft Payroll from different vendors/systems using SQR, Application Engine and Component Interface.

Confidential

Senior Analyst

Environment: People Tools 8.42, People Code, People Soft HRMS (HR, Base Benefits), SQR, North America Payroll, Compensation, Time & Labor, Oracle 9

Responsibilities:

• Involved in preparing a document identifying the retrofits that need to be done to meet the business requirements.
• Performed key role in compare objects analysis for PeopleSoft HCM and identified list of objects for retrofit and removals.
• Created Fit Gap, Functional Design Documents and technical design documents.
• Coordinating with Onsite for HRMS - Batch module to get understanding on Pfizer existing customization and shared the information with offshore team to create Technical specifications and resolving issues related to retrofitting and executing batch objects.
• Worked on the SQR and Application Engine retrofits as a part of upgrade from 9.0 to 9.2.
• Modified and Retired some of the People code, SQR’s and Application Engine as part of retrofits in upgrade.
• Developed Application Engine/Component Interface Programs for Data Conversion.
• Performed post-upgrade production support for various issues and documented the same.
• Production Support.
• Developed SQR reports for generating the employee absence information as per the requirements.

Confidential

Analyst

Environment: People Tools 8.12, People Code, People Soft HRMS (HR, Base Benefits), SQR, Windows NT, DB2

Responsibilities:

• Customized the application by modifying the Records, Pages, using Application Designer to full fill the Business user requirements.
• Views work created to accomplish row level security.
• Tailored People Code to implement data validation and enforce field level security.
• Developed SQR reports for generating employee information as per the requirements.
• Extensively used process scheduled for setting up the reports to run specific time and used Process Monitor to status of the reports.
• Prepared and documented Unit Test cases along with parallel System Testing.

Confidential

Sr. Software Engineer

Environment: People Tools 8.12, People Code, People Soft HRMS (HR, Base Benefits), SQR, Windows NT, Oracle 9i

Responsibilities:

• Created & modified Fields, Records, and Pages as per the Client requirements.
• Created Application Engine Program for Payroll interfaces.
• Creating Application Engine programs such as writing data to a file, reading from flat file and batch processing by adding new Sections, Steps and Actions through Application Designer.
• Created technical designs and scripts using People code and SQR’s for Payroll and Base Benefits Modules.
• Used Process Scheduler and Process Monitor for running Application Engine.
• Created run control panels for all the SQR’s for scheduling them on process scheduler to generate reports and flat files.
• Generated SQR Reports for the Employees details.