Peoplesoft Tester

MaheshBabu

maheshkolla***@gmail. P: 812-***-****

PROFESSIONAL SUMMARY

5.5+ Years of experience as a HRMS technical consultant, with experience in analysis, design development, upgrading and production support of PeopleSoft HRMS Applications.

Professional experience in PeopleSoft HCM modules (HR, Time &Labor, Base Benefits, Ben Admin, NA Payroll, Payroll Interface).

Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade.

Extensive experience in requirement analysis, fit gap analysis, technical design, conversion strategies, Data mapping, development, major customization, issue resolution, performance tuning, testing and training.

Extensively worked with Application Designer, Peoplecode, Application Engine, Process Scheduler, Security Administrator, Data Mover, File Layout, Object Security, Component Interface, Integration Broker, PS Query, Tree Manager, SQR, XML, Workflow, and Crystal Reports.

Involved in applying PeopleSoft Patches and Bundles.

Worked closely with Business Users in understanding the Business Processes.

Worked on PeopleSoft Security – User Profiles, Roles, Permission Lists, Components, Pages, Menus, Component Interface, Process Groups, Query Security, and Department Security etc.

Strong collaboration & team building skills with proficiency in grasping new technical concepts quickly and utilize the same in a productive manner.

Great understanding towards the needs of the client to provide invaluable support from design to post-production stages.

Possess excellent data modeling, analytical and problem solving skills.

Very good team player with excellent communication skills.

TECHNICAL SKILLS

People Tools

(8.548.52,,8.51,8.48)

Application Designer, PeopleSoft Internet Architecture, People Code, Upgrade Assistant, Change Assistant, Process Scheduler, Configuration Manager.

Integration Tools

Application Engine, File Layout, Component Interface, Application Messaging, Application package, Integration Broker, Approval Workflow Engine (AWE),IBM WBI

Reporting Tools

PS Query, SQR, XML Publisher, BI Publisher

Data Management Tools

Data Mover

Databases

Oracle 9i, Oracle 10g,Oracle 11g, SQL Server 2005, SQL Server 2008,DB2

Programming Languages

People Code, SQL, C/C++,java

Operating Systems

MS Windows 98/NT/2000/XP, UNIX.

Migration tools

STAT 5.5, Phire

PeopleSoft-HRMS Modules(9.2,9.1,9.0)

Core HR, Time and Labor, Base Benefits, Benefits Administration, NA Payroll, Payroll Interface.

Microsoft Tools

Visio, Projects, Access, Excel, Word, PowerPoint, Outlook, Publisher and Front Page

Work Summary of Supported End Clients:

Client: United Health Group, Eden Prairie, MN Jun 16- Till date

Role: PeopleSoft Developer

Involved in Development of PeopleSoft HCM 9.1 applications (Core HR, Affordable Care Act)

Responsibilities:

Developed an interface with app engine for Mangers Approval for EPI which is sending the Active, Future and Terminations file for EPI.

Modified the SQR’s for Employee Censes Reporting for Active and Rehire censes Reports depending upon the Business Scenario’s and rules.

Modified an App Engine UAE0261 TDP request for sales force and modified the SQL’s to send additional information needed for salesforce team.

Conducted Unit Testing on the Scenarios using some Test Cases.

Worked on Integration Broker and Component Interface for the integration of GSS to EPI for My Professional Profile pages and Modified the license section for the integration to EPI.

Worked on Affordable Care Act Project for electronic access of 1095-c for the employees instead of paper forms using Integration Broker.

Worked on Affordable Care Act Project for 1095-c consent forms to get the electronic 1095-c forms from EY for active employees in the current year.

Worked on App Packages for Email Notification for the Affordable Care Act Project when the employee is consented or withdrawn their 1095-c forms electronically.

Developed the consent and withdrawn pages for 1095-c to get it electronically for Affordable Care Act project.

Developed two interfaces’ to send 1095-c consent or withdrawn information for active and termination of employees for current year using App Engine and File Layout.

Involved in Testing for telecommuters by creating the test scenario’s to send the telecommuter request for Managers automatically from SQL inserts to test the performance of HUB.

Involved in Testing for license and Certification section in My Professional Profile page to send the license and certification information for mangers for approval by creating the SQL inserts.

Worked on Service Contract Act for Creating Outbound FCE Indicative Interface for Third party Administrator for calculating the fringe Benefits using App Engine.

Worked on Service Contract Act for creating of FCE 401k Company Match outbound Interface to transmit the company Match for 401k investments after each on-cycle pay run.

Involved in the Migrations of Projects from one instance to other using the Phire Migration tool.

Environment: PeopleSoft HCM 9.1 (HR, Benefits, Affordable Care Act), People Tools 8.52, People Code, SQR, SQL, PS Query, Application Engine, File Layout and Putty.

Client: Giant Eagle, Pittsburgh, PA Nov 15- Jun16

Role: PeopleSoft HCM Technical Benefits (Affordable Care Act)

Involved in Development of PeopleSoft HCM 9.0 applications (HR, Benefits, Affordable Care Act)

Responsibilities:

Mostly developed Affordable Care Act files like FEIN, Benefit Plans, Employee Benefit Transactions, Dependent Benefit Transactions, COBRA and Retiree files.

Created new pages and applications for Benefit Plan Mapping and Benefit Plans for ACA.

Developed the interfaces from Scratch using App Engine and File Layout.

Gathered the requirements from vendor and developed complex SQL’s depending upon the Scenarios they provided in functional documents.

Conducted Unit Testing on the Scenarios using some Test Cases.

Modified the SQR like Medco Eligibility (GEXBN603) for getting Non Open Enrollment Team member’s data by adding run control to SQR.

Worked on Detangling of Non Open Enrollment’s data for Liberty Mutual Demographic (GEX_LM_EMP) and modified the App Engine according to the requirements

Worked on App Packages for email collection page should popup when team member’s logs on to the portal if personal email address is not in the file.

Generating of Excel files for getting Pension Balance and Pension Hours Summary for 2015 by using SQL’S.

Detangling work to modify SQR and App Engine to separate NON open enrollment Team Member’s data

Involved in BATCH processing to setup the jobs in UC4.

Created PS Query for HSA carrier information for benefit focus deduction codes.

Modified the SQR GEXPL600 (Local23 Legal Aid Interface) by combining UNIX and NT SQR’s to run in both NT and UNIX.

Created PS Query for tax balances.

Environment: PeopleSoft HCM 9.0 (HR, Benefits, Affordable Care Act), People Tools 8.54, People Code, SQR, SQL, PS Query, Taleo, Application Engine, File Layouts and Win SCP.

Client: Blue Cross Blue Shield, BCBS, Chicago, IL Aug 14 –Jun 15

Role: PeopleSoft HCM Techno-Functional Consultant

Involved in implementation of PeopleSoft HCM 9.2 applications (HR, Benefits, Time &Labor, Affordable Care Act, Talent Acquisition Management)

Responsibilities:

Involved in Fit-gap analysis, designed gap strategies, Design, data analysis, data mapping for conversion, data cleaning, preparing technical documentation, Table set up & interface design for PeopleSoft 9.2 Upgrade project which include HR, Ben admin and Payroll for NA modules.

Retrofit new customizations in HCM 9.2 and People Tools 8.54 environment, exclusively worked on custom pages, AE, SQR and people code.

Conducted Compare Report analysis for PeopleSoft Changes, Customer Modified changes and analyzed the objects to be upgraded.

Analyzed Data Mover Scripts as part of Upgrade process.

Created a custom job in Upgrade Assistant and migrated the Patches and Bundles to different instances.

Performed extensive debugging and Performance tuning of various processes.

Configuration of the new AWE frame work and configuration of Pagelets for new Manager Dashboard.

Developed an Application Engine Programs like Blue cross blue shield and HRIS Premiums Interface.

Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.

Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables.

Developed many Inbound/Outbound interface Application Engine Processes to get data between PeopleSoft system and third-party systems.

Also involved in acquiring Specifications from the functional team and modifying the SQR’s as per the Specifications

Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.

Worked on Excel to Component Interface to upload 300 promotions in the system through Job data component

Used File Layout Definition to get data from the legacy system to people soft tables.

Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.

Created fluid pages and components for developing of fluid pages.

Extensive knowledge on fluid pages and created custom Grouplets.

Main customization I had done in edevelopment is to bypass the approval and workflow process completely and save the information to a record.

Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.

Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.

Environment: PeopleSoft HRMS upgrade and implementation to 9.2 HCM (HR, Benefits, eDevelopment), People Tools 8.54/8.52,Peoplesoft fluid, SQR, Application Engine, Component Interface, Integration Broker, XML Publisher, Windows NT and Oracle 11g.

Client: Common Wealth of PA, Harrisburg, PA Dec 13 – Jun 14

Role: PeopleSoft HCM Techno-Functional Consultant

As a member of team involved in Upgrade and Implementation of PeopleSoft HCM 9.1 applications (HR, Time & Labor, Benefits, Enterprise learning Management(ELM))

Responsibilities:

Responsible for design analysis, technical specifications, development, implementation, support, and maintenance of PeopleSoft HCM 9.2 and PeopleTools 8.54.

Involved in setting Time Reporting codes (TRCs), Compensatory time off plan, Work Groups & Task Groups.

Developed complex custom Time and Labor rules to calculate Late In, Excess Meal & short break, where the associates work in cross over shift and consists multiple login and logout on same day.

Created customization for all employees reported greater than 12hours has to be reported at TRC at @1.5.

Prepared new custom pages where employee can request for a Shift change and shift swap.

Develop custom reports utilizing XML, SQR, and File Layout with Application Engine.

Developed/Enhanced SQR Programs scheduled to run monthly to submit Personal and Payroll data.

Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement.

Developed on-line customizations, custom interface programs for Benefits, Payroll.

Set up Integration Broker services(such as gateways, nodes, services and service Operations)

Developed Integration broker for application messaging between ESA and HCM applications to send employee project allocation details in real time.

Developed AWE for Shift change and Shift swap request approvals.

Experience in Contingent Worker Workflow.

Created User Profiles, Roles, Permission Lists, Components, Menus, Pages, Process Groups, Query Security, etc.

Involved in User security (Roles, Permission lists) and row level security using Department tree.

Provided programming and analysis support for customizations made to HR, Benefits and Payroll modules.

Reviewed and improved performance for online and batch routines, including App Engine, SQR, and People Code routines.

Experience with UAT testing and also working with MS suits.

Created Application package for Warning messages that will be imported while save/submit and will issue a warning message to the user. Also vigorously tested these messages for different scenarios to make sure they are triggered as per the requirement.

Created Application package for Error messages that will be imported while save/submit of the timesheet. Also vigorously tested these messages to make sure the user cannot save anything invalid and also the error messages are triggered as per the requirement.

Analyzed the projects using agile methodology which is incremental and iterative process.

Developed customized Benefits reports for Open Enrollment, New Hires, and Employee Benefits.

Provided production support for Benefits, Payroll and HR systems.

Designed PS query structure to reduce client efforts for duplicated activities.

Environment: PeopleSoft HCM 9.2 (HR, Payroll, Time & Labor, Benefits, EPM), PeopleTools 8.54, PeopleCode, Kronos, SQR, XML Publisher, Workflow, SQL, PS Query, Component Interface, Application Engine, File Layouts.

Client: ERPA, India May 11– Jun 13

Role: PeopleSoft HCM Technical Consultant

I was involved in Support and Maintenance of HCM Apps including HR, Time and Labor, Payroll, and Benefits modules.

Responsibilities:

Performed development, testing, modifying of some of the SQR, Query, existing pages, and various PeopleSoft objects.

Involved in working and fixing the user and change Requests.

Involved in BATCH processing to setup the jobs in Control – M tool.

Created the UNIX shell scripts as per the application process.

Developed new inbound interface programs using AE and File Layout.

Interacted with Hewitt functional consultants to understand their functional needs and customized the system to incorporate the same.

Involved in creating Technical design documents and Unit testing.

Impact analysis of various Tax Updates and Fixes.

Extensively involved in reapplying customizations to records, pages, People Code, components, menus, permission lists, message channels, portal registry structures and various other PeopleSoft objects.

Worked extensively on SQR’s and created several inbound and outbound interfaces to meet the client’s requirements.

Developed and modified UNIX scripts for batch process scheduling.

Created custom application pages and records as per client business needs.

Developed different custom reports using PS Query and SQR according to user requirements.

Modified & Created records, on-line pages, and components according to the requirements using Application Designer.

Migration of People Tool objects from one environment to another environment through Quest Stat.

Involved in creating Users Profiles, Roles, and Permission Lists.

Environment: PeopleSoft HCM 9.0(HR/Benefits/Payroll), People Tools 8.48, DB2, Kronos, COBOL, Control-M, Stat, and UNIX.

Contact this candidate