SUMMARY

• 9+ years of IT experience in analysis, design, development, configuration, testing and support of PeopleSoft applications.
• 9+ years of proven experience in working complex ERP applications and wif medium to large projects in terms of both scope and resources.
• Extensive experience in interacting wif the clients/business users to identify, finalize and drive the scope of the project.
• Has extensive hands on experience in handling day to day PeopleSoft Operations, managing PeopleSoft Workforce Administration, NA Payroll, Time and Labor, Recruiting, Talent Acquisition Management, Absence Management, Base Benefits, Ben Admin, Performance Management, Compensation, Configuration setup, Interfaces and Security modules.
• Efficient and knowledgeable in working wif, PeopleSoft HCM 9.2/9.1/9.0/8.8 , and People Tools 8.5X involving Application Designer, Application Engine, Component Interface, PeopleCode, SQR, and Knowledge on Fluid UI Interface
• Well versed in various PeopleSoft HCM functional modules like NA Payroll, Time and Labor, Payroll Interfaces, Base table configuration, HRMS Security, Pension Administration, Base Benefits, Canadian Payroll, Time and Attendance
• Understand business process and transform them into functional specification document for implanting into PeopleSoft system
• Part of PeopleSoft upgrade team from PeopleSoft HCM 8.8 to 9.1 and 9.2
• Proficient in setting up and processing NA payroll, reconciling the payroll checks, automate the Payroll reconciliation process and provided value addition to the client.
• Supported State of Texas ERP environments (e.g. CAPPS and HHSAS) since July 2014, including onsite at the Confidential .
• Performed design, implementation, configuration, upgrade and execution of Compare Tool for Parallel Testing of Payroll, Benefits and Pension Data by performing complex compares between two systems using various business rules and translations.
• Proficient in writing complex BI Publisher reports and customizing PeopleSoft Delivered SQR reports. To make it 508 compliant
• Expertise in handling Daily Operations across multiple instances in production and non - production environments.
• Involved in the full life cycle of software development including Analysis, Design, Coding, Unit Testing, Integrated Testing, Packaging and Release.
• Good exposure to Quality Management ensuring that the necessary processes are in place to meet project goals.
• Strong expertise in Quality Assurance as part of full life cycle implementations of the above modules wif specific emphasis on creating system/integration test plans, requirements traceability; developing manual test cases/test scripts; performing functional, integration and regression testing; managing defects and preparing comprehensive test metrics.
• Good technical Knowledge of PeopleCode, Application Engine, SQR, SQL, Integration Broker, Application Messaging and XML Publisher.
• Excellent process orientation in performing project scoping, business process re-engineering, fit/gap analysis, requirements gathering, functional design, application configuration, user interactions, testing and production support.
• Extensive PeopleSoft functional knowledge wif tremendous enthusiasm and creative energy and a commitment to achieve the excellence in my work
• Strong believer of team spirit and has been excellent team player wif leadership qualities and coordinating abilities.
• Proven ability to learn new technologies independently & efficiently, and ability to achieve tight deadlines.
• Managed to design and develop role based application/tools security and implemented Confidential (State of Texas Tax collecting system) system for global portal users and Employees.

TECHNICAL SKILLS

ERP: PeopleSoft HCM 8.8, 9.1,9.2, PeopleSoft FSCM 9.1, 9.2

Tools: People Tools 8.5x (Application Designer, PeopleCode, App Engine, App Package, CI, Workflow, Integration Broker, Change Assistant)

Reporting Tools: PS Query, SQR, XML/BI Publisher, Crystal, Nvision

Database & Tools: Oracle, SQL Server, MYSQL, TOAD, SQL Developer

Languages: PL/SQL, C, C++, HTML, CSS, JavaScript

Integration Tools: Integration Broker, App Messaging, Component Interface, Excel2CI, SOAP UI and POSTMAN.

Testing Tools: HP Application Lifecycle Management, Quick Test Professional, HP Quality Center 10.0, QTP 10.0, Sprinter, Peoplesoft Test Framework, JAWS, WAVE, Sort Site.

Version Control Tools: STAT and PHIRE

Administration: JIRA, Confluence, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

HCM Techno/Functional Consultant

Responsibilities:

• Provide Functional and Technical support for Benefits, Payroll, Core HR, Recruiting, Time & Labor and TAM modules.
• Involved in implementing PeopleSoft 9.2 (PS tools 8.5X PS 9.2 Fluid UI) Implementation, customization, and production support.
• Extensively worked on PeopleSoft NA payroll processing like File staging, HR & Payroll Setup, Setting up test cases, Scheduling, On-Cycle Processing, Off-Cycle Processing, Online Checks, Garnishments and Payroll Balances.
• Created and managed “Donation of Sick Leave” functionality between employees.
• Applied bundles and retrofit all Tax updates and ACA.
• Upgraded people tools from 8.53 to 8.55, 8,56, 8.57 and 8.58.
• Developed multiple conversion program and Interfaces in all HCM modules using App Engine, Component Interface, SQR’s.
• Developed interfaces from TXCPA to all state agencies using Integration Broker.
• Created Webservices and REST API from HR system to Mainframe system (Legacy Financial system).
• Created multiple Inbound and Outbound interfaces between CAPPS Benefits and ERS (Employee Retirement System)
• Integrated CAPPS system wif legacy system to sync the HR data between Peoplesoft and mainframe system.
• Implementing TAM, Absence Management and Recruiting modules in new onboarding State agency TWC (Texas Workforce Commission)
• Extensively worked on Modifying and Creating App Packages. Validated and moved applicant data fromPeopleSoft e-Recruit/TAM Talent Acquisition Manager Self-Servicemodule using App Packages.
• Designed technical specification for customization inRecruiting, and Talent Acquisition Managerfor employees to submit resumes and attachments online.
• Involved in end-to-end testing of PeopleSoftHR application right from Recruitment to Payroll
• Configure Absence Management module for various leave accrual, consumption, payout and carryover logic.
• Analyzed and designed the customizations of delivered Global Absence management for Vacations and Work Risk leaves.
• Complete data conversion scripts to migrate data into new environment. Monitor and report to management on the status of project efforts, anticipating/identifying issues that inhibit the attainment of project goals and implementing corrective actions.
• Review current security configurations and discussed best practice guidelines in role-based, row-level, operator, query, definition, tree manager and process group security for all business processes.
• Converted legacy COBOL programs and copybooks to Peoplesoft Application Engine programs.
• Created Interfaces to integrate Manage Hire data and Job data.
• Created, scheduled and Maintained multiple jobs in Control -M.
• Implementing Workflow in TAM and Absence management.
• Implemented Tiles, Dashboards, Work centers and Pivot Grids.
• Integration of Absence Management to Time and Labor to enable the processing of time information and to generate payable time data that is subsequently loaded into Payroll for North America.
• Worked on converting classic PIA components to Peoplesoft Fluid UI.
• Performed parallel payroll runs and match payroll results cent-to-cent. Responsible for explaining differences in parallel payroll run to client payroll leads and get sign-off from them.
• Configuration updates to Time and Labor modules to accommodate payroll changes.
• Managed and troubleshot Time and Labor rules during the payroll process.
• Participate in the implementation of Oracle supplied fixes, patches, updates utilizing Peoplesoft Update Manager (PUM).
• Worked extensively on Rule programs wifin Time and labor to meet business needs.
• Support Benefits team in creating and maintaining the benefit program configurations and setting up benefits rates.
• Downloaded multiple patches from PUM 2X - PUM 3X and deployed those patches in all HCM modules.
• Ben Admin execution in Prod and test and support the team in triaging the issues.
• Facilitate AE open and AE Close
• Analyze and design the system for business requirements
• Understand business process needs and convert them as functional spec. to fit into PeopleSoft application.
• Managing multiple PeopleSoft applications wif Release Strategy, Instance planning and creating System Integration Testing (SIT) calendars.
• Provided functional support for the team during the 9.2 PeopleSoft upgrade.
• Efficiently handled multiple PeopleSoft production instances for day to day operations and assist the team in defining new process and standards for daily operations
• Worked extensively in creating the Payroll interfaces for PeopleSoft 9.2 Payroll.
• Prepare Go-Live project plan and check list of all activities during production cut-over.
• Responsible for applying PeopleSoft Tax updates/patches in timely manner.
• Run the parallel Payroll after applying Tax updates to make sure that payroll reports/checks/balances are as expected.
• Troubleshooting issues during the NA Payroll processing and help team fix them.
• Work wif Payroll & Benefits business team to understand the requirements and translate them into detailed functional requirements specification documents
• Prep the PeopleSoft instances to make it ready for Benefits, Payroll and Pension testing.
• Trouble shooting and Resolving production issues/failures across applications wif a quick turn-around time.
• Conduct meetings wif the Payroll, Benefits and Pension team to identify the root-cause of production issues and prevent the reoccurrence

Confidential, Austin, TX

.Net to Peoplesoft Conversion

Environment: Peoplesoft 9.2, People Tools 8.56

Responsibilities:

• Gatheird requirements, Designed, developed, and maintained Confidential, a multibillion-dollar payment portal for the collection of taxes for the State of Texas.
• Involved in the development of on-line pages, record definitions and menus using People Tools like Application Designer Detailed analysis & design and maintenance of User Profiles, Roles & permission lists.
• Segregation and grouping of roles based on business further classifying on privileges (Display only/Update).
• Integrated Peoplesoft portal wif Third Party service (ex: Java & Mainframe) using Rest API and webservices.
• Established single sign-on in Peoplesoft wif JAVA portal using OKTA.
• Created webservices to send and consume Texas taxpayer data from Mainframe system.
• Created Messaging between Peoplesoft portal and Treasury application for user self-registration and Forgot Password in Confidential portal (State of Texas Tax collecting portal).
• Tested all integrations in PeopleSoft using SOAP UI, POSTMAN, Handler Tester and service operation tester.
• Build custom portal sign-in, password reset and forgot user id for guest pages for Confidential system and prepare portal test use cases, and security/portal sites migration plans
• Worked on several Production support tickets on daily basis making sure to meet the Deadlines.
• Created multiple BI publisher reports and made the reports as 508 Compliant.

Confidential, Austin, TX

HCM Techno/Functional Consultant

Responsibilities:

• Complete Fit-Gap analysis of the HCM upgrade and identify Gaps. Assist client in creating Technical &Functional design documents for the Gaps identified.
• Involved in the PeopleSoft Data Conversion Project for Core HR, Benefits and Customizations in T&L, Payroll and Base Benefits Modules.
• Involved in the development and customization of on-line pages, record definitions and menus using People Tools like Application Designer related to HR, Payroll, Benefits, Benefits Admin, Time & Labor.
• Modified the Application Engine Process to call Web Services upon hire replacing existing methods, which will update the Return-to-work Service date.
• Worked on Third Party integrations using Integration Broker.
• Integrated CAPPS Benefits and ERS (Employee Retirement System) for employee benefits.
• Created Inbound and Outbound interfaces to integrate wif USAS (State of Texas Legacy Financial system).
• Developed and executed Benefits administration (Event Maintenance and Annual enrollment) test cases. Involved in testing quarterly and annual reporting batch processes
• Completed numerous requirementsgathering sessions wif several business users across the organization tocomplete above-mentioned design and configuration work.
• Developed Custom Time and Labor Reports including compare Reports, which were extensively used while transferring data from a Third-party system to PeopleSoft Time and Labor.
• Designed, developed and implemented automated Company/Pay group creation process.
• Applied Bundles for implementing ACA (Affordable Care Act) forms like 1095-C and 1094 and retrofitted customizations after each ACA bundle
• Applied TAX-UPDATES Patches 15-A, 15-B, 15-C, 15-D and 15-E and retrofitted customizations after each tax update to the existing 9.1 system.
• Configuration and maintenance of all the benefits, Time and Labor and payroll processing tables.
• Perform System Integrated Testing for payroll process wif the new release code/change items.
• Work wif Payroll & Benefits business team to understand the requirements and translate them into detailed functional requirements specification documents
• Worked as Backup system administrator and installed App Server, Web server and Process scheduler server.
• Setup new Company, Pay group, Department and other base table configuration for new acquisitions.
• Prep the PeopleSoft instances for payroll test by clearing the off cycles and artificially confirming the prior pay calendars.
• Maintain PeopleSoft base tables wif the new configuration updates and migrate data to production environment.
• Process parallel payroll executions for release changes and deliver the compare results to different functional area leads for validation.
• Provided functional support for the team during the 9.1 and 9.2 PeopleSoft upgrade
• Worked extensively in creating the Payroll interfaces for PeopleSoft 9.2 Payroll.
• Performed Tools & Application upgrade application testing.
• Creating the standard operating procedures for payroll executions.
• Responsible for applying PeopleSoft Tax updates/patches in timely manner.

Confidential, Boca Raton, TX

HCM Techno/Functional Consultant

Responsibilities:

• Involved in the PeopleSoft Data Conversion Project for Core HR, Benefits and Customizations in T&L, Payroll, Base Benefits Modules.
• Interacted wif Business Analysts to map End-user requirements into PeopleSoft Technical and Functional requirements
• Involved in Designing and documenting the requirements both technically and functionally.
• Map various SAP table fields to PeopleSoft data tables
• Developed Conversion programs using App Engine, SQRs, File layout and Component Interface to load data from the Legacy system to People Soft Tables.
• Used Excel to CI feature to load data from files containing delimited field files and other flat files such as CSV or .XLS files to PeopleSoft data tables.
• Developed benefits related conversion Application Engine program which reads the data from file and loads it into a staging table and then uses component Interfaces to load data from staging tables to target tables.
• Worked on Integration broker setup in creating Nodes, messages, services, service Operations and generating the WSDL from Provide Web service component.
• Performed validations on PeopleSoft Data structures to test the data integrity after performing conversion and uploading processes from legacy systems such as SAP to PeopleSoft Applications.
• Worked on designing Inbound Mass Load Interface (APP Engine) using Component Interface (CI) to load data to Salary Plan Table.
• Created, scheduled and Maintained multiple jobs in CA Scheduler
• Developed a new outbound interface which generated XML Interface file to send job postings information.
• Rebuilt an existing 2 interfaces and make them into one interface. Depends on the user selection on the run control page specific process will execute and send the file to 3rd party.
• Developed web-services in PeopleSoft to connect local and remote nodes for Inbound and Outbound XML file communication between legacy SAP application systems and PeopleSoft applications.
• Create Reports, me/O Interfaces, Enterprise integration points(EIP), Web services, 3rd party & legacy system Integration, User Interfaces, Extraction transformation loading(ETL), Data Mart & Migration, Job scheduling, batch processing, PS-Security, Workflow, Portal, PeopleSoft Objects, PeopleCode Events, DMS script, stored procedures, functions & triggers, PeopleCode events, develop & performance tuned application.
• Used Integration Broker, Customized Message, Setup Channel, Node definition, and Gateway properties. Performed Full Synchronization and setup Incremental Sync.
• Developed Application Engine Program to Load the External Data into Temp Tables and from temp tables into PeopleSoft application tables.
• Created a new SQR for the employee data load to Time and Attendance System Outbound Interface which will generates two XML files interfaced dis into PWM database and customized the process to exclude Office Max employees wif generic job codes.
• Customized the existing SQR for Store Portal Active directory to exclude client associates from the output file which is Ftp’d to USCHMM01 server.
• Created an App engine program for conversion of benefits program data for European employees. dis Conversion Loads Benefits program data for Confidential European countries employees to PeopleSoft 9.2 system
• Developed benefits related conversion Application Engine program OD BN OMXCNV which reads the benefit related data from file and loads it into a staging table Interfaces to load data from staging tables to target tables.
• Created Organization chat pivot grids to be displayed in home page.
• Developed programs for employee general deduction data conversions using the Component Interface, File Layout, Application Engine and PeopleCode.
• Developed PTO app engine program OD PTO OMXCNV to read the data from file sent by Office MAX and created a leave plan balance record for various plan types.

Confidential, Houston, TX

Peoplesoft Developer

Environment: HRMS 8.8, People Tools 8.47, Oracle 11g

Responsibilities:

• Involved in Development, Integration and maintenance of PeopleSoft HR and Oracle Finance e-business suite.
• Worked wif functional team and testing team in System Test, User Acceptance Test and Parallel Test for Payroll.
• Used File Layout Application Engine program to convert the Health Benefits Details and Deduction Balances Data.
• Participated and assisted in the HR & Benefits Fit Gap analysis.
• Developed and executed Benefits administration (Event Maintenance and Annual enrollment) test cases. Involved in testing quarterly and annual reporting batch processes
• Involved in tracing and fixing the problems for Benefits and Payroll interfaces.
• Worked on Benefits to provide employees online access to their benefit programs, including Health, Dental, Vision, Insurance and Savings plans
• Troubleshooting the problem areas in interfaces wif Benefits programs, enrolling employees into Benefit plan, calculating payroll deductions and in producing Benefits reports.
• Troubleshot several Payroll issues during the Pay Calc and Pay Confirm processes while running the On-Cycle and Off-Cycle Payroll.
• Involved in the setup of Deduction Codes, Earnings Codes, and Payroll Process Controls as per the Business rules.
• Responsible for analyzing, coding and maintaining the complex Payroll to interface.
• Customized Payroll register and added Business Unit in the logic.
• Developed and performed Unit testing and User Acceptance Testing (UAT) for various HR, Benefits and Payroll. Inbound/Outbound interfaces using Application Engine Programs.
• Set up the Savings Plan table and processed, resolved issues and confirmed the deduction in Payroll Interface Module.
• Involved in the setup of Deduction Data, Earnings Data, and Payroll Schedules in the Payroll Interface module as per the Business rules.
• Involved in upgrade and customization of SQRs in HR, Benefit & Payroll modules
• Worked wif pay sheets, pay calculations, pay confirms queries, payroll taxes, data entry for new hire, rehires and garnishments.
• Involved in developing training material for PeopleSoft HR, Payroll and Benefits.