PROFESSIONAL SUMMARY:

• Total 9 plus years of experience, around 2 Years as workday functional consultant and 7 plus Years as PeopleSoft Consultant in Development, Upgrade, Production Support and Maintenance projects.
• Strong programming, analytical and logical skills.
• Proven team player with effective interpersonal and communication skills.
• Excellent working knowledge in Workday Core HCM 29v, 28v & 27v and recruiting module.
• Worked on PeopleSoft HCM, FSCM 9.2/8.55/8.54 , 9.1/8.51, 8.9/8.49 and 8.9/8.45 that includes various modules like GL, Core HR, Workforce Administration, ELM, Employee Self Service (ESS), Manager Self Service (MSS), North American Payroll, Base Benefits, Benefits, Time & Labor, Recruiting and ePerformance applications.
• Excellent working knowledge in People Tools Application Designer, Application Engine, People Code, Process Scheduler, XML Publisher, Security, Data Mover, Integration Broker, Application Package, nvision, Component Interface, Web Services, Crystal Reports and SQR.
• Experience in using Integration Tools like Component Interfaces, Integration Broker and Web Services for interacting with in and outside People Soft applications.
• Excellent working knowledge in Upgrade - People Tools and PeopleSoft Application.
• Proficient in developing new Inbound and Outbound SQR Interfaces and writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Generated various reports by using the Reporting Tools - SQR and XML Publisher.
• Expert level knowledge of designing and customize PS Queries.
• Involved in requirement gathering, fit-gap analysis, design, development, Testing and documented processes in Agile/ SCRUM methodologies.
• Testing - Unit, Integration and Database (Parallel) and writing Test Script Scenarios with navigations, actual and expected results.
• Developed the Quality related documents for all the projects involved at various levels.

TECHNICAL SKILLS:

ERP /Database: Workday 29v, 28v & 27v, JIRA, Easy VistaPeopleSoft (8.9/9.0/9.1/9.2 ), People Tools (8.45, 8.49, 8.51, 8.54, 8.55), Application Designer, Application Engine, PeopleCode, File Layout, Data Mover, Tree Manager, XML Publisher, Workflow, Process Scheduler, Application Package, Component Interface, Integration Broker, eclipse, soapUI, Remedy Ticketing Tool, Agile, Rally, TOAD, Phire, SourceSafe, Tortoise SVN, Quest STAT, Excel, PowerPoint, Visio, Oracle7.x/8.x/9.x/10g/11g, DB2, SQL Server 2005& 2008, PL/SQL, Mainframes Z/OS 390.

Reporting Tools: PS Query, SQR 4.x/6.x, XML Publisher, Crystal Reporting.

Programming Languages: PeopleCode, SQL, SQR, Java 2.0, PL/SQL, C, C++.

Operating System: Unix, Windows NT, Windows 2000, Windows 98, Windows XP, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Workday Functional Consultant

Responsibilities:

• Configuration responsibilities may include modifications to business processes, compensation set-up and security configuration.
• Contribute to the operations and the developments of HRIS to support Recruiting and Compensation.
• Managed Workday upgrade cycles to ensure current operation is not impacted.
• Creating and providing the required security groups to the users.
• Maintain Security roles and Assignment of roles.
• Configured security process flows and notification for business process.
• As per business requirement implemented Business process setups and added necessary security groups.
• Modified existing Business processes to meet new requirements, added new conditions rules and validations.
• Created new Allowance and Salary plans based on eligibility criteria.
• Maintaining Organization chats as per client requirement and assigned proper superior Org.
• Created new location hierarchies.
• Creating custom report for data validation and modified the existing custom reports.
• Developed Custom report like Advance and Matrix report.
• Granted proper security groups to access custom reports.
• Ensure the data is accurate and scheduling timely deliverable and provided the technical assistance to Management.
• Implemented new Dashboards for support third party URL’s.
• Update Readiness - Keep current with Workday releases, via release notes, and schedule internal release review meetings to understand changes and new functionality.
• Provided technical support and responds to all assigned JIRA tickets.
• Monitoring the integration and addressing the custom errors.
• Documenting Business process procedures and end user training materials.

Confidential, Columbus, OH

PeopleSoft Technical Consultant

Responsibilities:

• Involved in Enhancing, Modifying, Debugging and Testing PeopleSoft Applications and SQR’s for Core HR, Base Benefits.
• Involved in Annual Enrollment process for 2017 (AE-2017).
• Created new and customized existing Record definitions, Pages, Components for the client specific functionality.
• Modified existing SQR's for LTD's enrollment and confirmation form layouts as per business requirement.
• Developed various Outbound and Inbound Interfaces for transmitting employee Data to Benefits vendors and process the receiving data to insert into various PeopleSoft Tables.
• Modified existing Application Engine program “NBAS474” and Peoplecode to update Enroll Action field to “E” in BAS PARTIC PLAN table.
• Created new Text Catalogs as per client requirement.
• Used Phire version control Tool for Migrations.
• Prepared Unit Test Scripts for Unit Testing.
• Involved in fixing the defects/issues raised during User Acceptance Testing.

Solution Environment: PeopleSoft HCM 9.2, People Tools 8.55, Oracle, Toad, Phire, UNIX, Windows NT. (People Code, Application Engine, Component Interface, SQR)

Confidential, Alpharetta, GA

PeopleSoft Technical Consultant

Responsibilities:

• Involved in requirement gathering, fit-gap analysis, design, development, Testing and documented processes.
• Involved in running Upgrade scripts using Change Assistant for the Upgrade process and analyzed Upgrade.
• Compare reports to identify and document existing customizations.
• Developed number of conversion scripts and uploaded data. Used Change Assistant tool to move the objects from 9.1 to 9.2.
• Used People Tools in carrying over the customizations from the existing version to new upgrade version.
• Extensively used Application Designer for creating new objects, modifying the existing customizations and bringing them over successfully into 9.2.
• Developed a batch Application Engine which uses Component Interface to load General Deductions and Garnishments for each employee to reflect the company changes.
• Customized the eBenefits module according to functional requirements so that the employee has the ability to review and update benefits information online.
• Created new SQR Programs to update Annual Base Salary, and to add new Benefit programs, Plan, Plan Types and automated Benefit Admin Process.
• Implemented Row-level security, Field-level security, Object-level security to control application security using Administrator and Object Security.
• Involved in creating of Task Groups and establishing Time Periods, Calendars, Shifts, work schedule templates and work groups.
• Developed Application Engine Process to Evaluate Retirement Indicators based on Employees Birth & Service Dates. Modified 401K Interface to change the employee company.
• Customized Daily Time Calendar, Weekly Elapsed Time Entry and Punch Time Entry and Manager Time. Approval pages as per the requirements. Extensively used People Code and People Tools during the customization.
• Involved in Data Conversion from the legacy System in to Oracle using SQL*Loader, DMS scripts and SQR’s.
• Retrofitted Integration Broker Service Operations including Routing configuration and Handler PeopleCode.
• Implemented online and batch customizations in Payroll, HR, Time & Labor, Benefits and Benefits Administration modules as per functional requirements.
• Developed new queries using XML Publisher to replace some existing SQRs.
• Effectively utilized tools and utilities provided by PeopleSoft (Debugger, tracing etc.) for trouble shooting issues on PeopleCode, Application Engine, COBOL, SQR’s.
• Developed Technical Design Documents and Test Case Documents.

Solution Environment: PeopleSoft HCM 9.1/9.2, People Tools 8.51/8.54 Oracle 11g, Windows NT. (People Code, Application Engine, Component Interface, SQR, XML Publisher)

Confidential, Carrollton, TX

PeopleSoft Technical Consultant

Responsibilities:

• Involved in Enhancing, Modifying, Debugging and Testing PeopleSoft Applications and SQR’s for Core HR, Benefits.
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Responsible for design, develop, test, conduct User Acceptance Test and deploy the customizations and (or) enhancements to the Enterprise Applications to meet the client’s business specific requirements.
• Customization to the existing SQR reports and developed new interfaces.
• Designed the new Run Control pages and attached to the Menus to run various SQR’s and AE’s.
• Working closely with the business users and the functional team for identifying issues and to provide the technical/ functional solutions.
• Developed Promotion Interface using File Layout, Application Engine, and Component Interface, which loads data from CSV into staging tables while doing various data validations using AE PeopleCode and finally loads into PeopleSoft tables through Component Interface.
• Successfully completed the performance evaluation for the ePerformance module wherein a manager can perform performance evaluation of his employees.
• Created Permission lists, users, roles and assigned roles to users through Maintain Security.
• Created Application Packages to validate and move the applicant data from e-Recruit to HR Module.
• 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.
• Provide support regarding production-related problems.
• Documented all production support issues and created test cases.

Solution Environment: PeopleSoft HCM 9.1, People Tools 8.51, SQL, Oracle 11g, People Code, Application Engine, Application Packages, XML Publisher, SQR Reports, Process Scheduler, UNIX, Windows NT.

Confidential, Philadelphia, PA

PeopleSoft Technical Consultant

Responsibilities:

• Developed synchronous request/response type of integration in Same Day Termination Tool with work brain system (third party) using web services for worked hours.
• Worked on Separation Customized module, developed online pages and custom records to store Employee separation Process and developed Approval Workflow Engine for Approval Process as per the Client Requirement.
• Created new Application Package for sending request and getting response from the work brain system to PS system using web services.
• Worked on XML publisher to generate employee promotion letter as per the client requirement.
• Cloned and modified complex SQR’s DDP003 and PAY003 as per the client requirement to print the paycheck information to the My HR system (third party).
• Involved in applying the Tax updates.
• Worked on Payroll deductions, Pay calendars, running of the Payroll process (from Pay calendar, Pay sheet, Pay calculation to Pay confirm).
• Created the custom processes to track the employee’s shares and dividends in PeopleSoft Payroll system and offset the net pay and calculated the taxes.
• Developed SQR reports that displayed Leave Accrual information by leave plan and employee. It included information such as plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date and remaining leave balances.
• Developed the new SQR for the employee suspension Process to stop the restoration bonus Deductions for employees on suspension.
• Designed and developed the new Workers Compensation Code report using SQR.
• Created the Year end SQR process for enrolling the new Deductions who are employees turning AGE50.
• Customized the delivered Application Engine (HR PER502) for Change ID and Delete ID Process as per the client requirement.
• 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.
• Designed technical approach for data conversion using Application Engine and Component Interface.
• Developed SQR Processes, SQR Reports, Crystal Reports, Dashboards and XML Publisher Reports.
• Developed queries using PS queries to get the employee status and head count of each business unit integrate it to the Crystal Report Writer.
• Created new and customized existing PeopleSoft objects (Panels, Panel Groups, Menus, People Code, and Process Definition) and applied Security.
• Trouble shooting HR and Payroll issues as part of daily production support.
• Creating the Queries for the reports as per the user requirement using PS Query Tool.
• Created Unit Test Cases and involved in User acceptance testing.

Solution Environment: PeopleSoft HCM 9.1, People Tools 8.51, SQL, Oracle 11g, People Code, Application Engine, Application Packages, XML Publisher, Web Services, SQR Reports, Process Scheduler, UNIX, Windows NT.

Confidential

Sr. Software Engineer

Responsibilities:

• Played key role in Development and Testing of Interfaces, Online Customizations using SQRs, People Code, Component Interfaces and Application Engine.
• Involved in developing the integration tool Component Interface.
• Perform Job Data and Personal changes requested by Managers, HRs and Recruiters.
• Created new records, pages and menus by using Application Designer.
• Customized critical programs like payroll, benefits and tax related process based on client requirements.
• Involved in modifications to Benefits interfaces for the third party. The transmission through SFTP from PeopleSoft system to third party vendors.
• Worked on Foundation Tables, Organizational relationships, Template-Based Hires, Compensation packages for core HCM & Self-Service modules including integration setup between FSCM & ELM.
• Used People Tools Application Designer, Process Scheduler, Process Monitor, PS Query, Security Administrator.
• Customized various components/pages in the areas of Job Data, Job Entry Application Engine programs and other SQR programs in HR and Payroll Modules.
• Worked extensively on People Code to implement the new required business rules of the client and also modified the Delivered People Code as Business requirements.
• Involved in writing Technical Specification documents to facilitate writing codes as per client requirement.
• Designed and developed various customizations based on Integration Broker Class, SOAP and XML Doc.
• Configured and Setup Integration Broker for retrieving real time data from the legacy/source systems.
• Profile Management Issue - While adding a new Non Personal Profile, Header information missing once the transaction saved.
• Involved in User Acceptance Testing for new developments and Break-Fix.

Solution Environment: PeopleSoft HCM 9.1, People Tools 8.51, DB2, TOAD, Windows XP, Web Services.

Confidential

Sr. Software Engineer

Responsibilities:

• Performed Key role in Upgrade task.
• Gathering client’s business requirements.
• Involved in the design, development and testing of all HR, Payroll, Benefits.
• Customized HR, payroll menus, enquiry pages as per the user requirement so that user can view more information.
• Worked on integration PeopleSoft ELM & HCM using integration broker.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft HEALTH BENEFIT Table, LIFE ADD BEN Table, SAVINGS PLAN Table, LEAVE PLAN Table, and LEAVE ACCRUAL Table.
• Involved in Data Conversion for payroll from external system using SQR and Application Engine.
• Involved in Upgrade People Tools from .
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Performed Setup & Configuration for PS HCM & Self-Service modules.
• Performed foundation Table loading sequence, setup Country specific tables, Absence Data, Events, Eligibility, Rate, Benefit Programs, Templates, Statuses, Referral Programs, Approvals process& Integration with PeopleSoft and 3rd party systems.
• Reapplying the customizations on V9.1 in terms of SQR’s, components and People Code.
• Used Advanced SQR techniques Arrays, Dynamic SQLs, Database links, On-Break and Load lookups for creating the complex Multiple Reports.
• Experience in retrofit of SQRs during upgrade from V8.9 to V9.1.
• Generating the new Inbound and Outbound SQR Interfaces that well suited to the Business Requirements.
• Prepared Unit Test Scripts for Unit Testing.
• Involved in fixing the defects/issues raised during User Acceptance Testing.

Solution Environment: PeopleSoft HCM 9.1 (Core HR, ELM, ePerformance, Base Benefits, Recruiting and NA Payroll) People Tools 8.51, DB2, Windows XP.

Confidential

Software Engineer

Responsibilities:

• Update the Job Data component using Application Engine program and Component Interface whose employee’s Job code change, Company change and Pay group change.
• Used Data Mover to export project to a data file then used the file to load data in to the PeopleSoft system.
• Customized, Debugged & Tested Applications using App Designer, People Tools.
• Worked on SQR, People Code, DMS, UNIX scripts, batch processing tools & Web Services.
• Involved in User Security Setup like creating new roles, permission lists, assigning authorizations for users etc.
• Prepared technical specifications for Payroll, HR, Time & Labor and Benefits Modules.
• Maintaining PeopleSoft user security using user profiles, roles & permission lists.
• Involved in Field Mapping for the tables.
• Created new Application Package for sending request and getting response from the work brain system to PS system using web services.
• Created multiple web services into PeopleSoftFinance/HRMS updating tables.
• Developed Custom Time and Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time and Labor.
• Worked on Integration Broker within PeopleSoft and 3rd Party systems.
• Worked with Prompt tables, Dynamic prompt tables and also worked in SQL Views and Dynamic Views to optimize the Query performance and used views as search records.
• Configured and Setup Integration Broker for retrieving real time data from the legacy/source systems.
• Setup and Configured Integration Broker and trusted nodes for PeopleSoft single sign on.
• Modifications to the existing reports that are impacted by customization and newly developed reports/processes as per the Customer request.
• Prepared technical design documents.

Solution Environment: PeopleSoft HRMS 8.9, People Tools 8.49, SQL, PL/SQL, TOAD, Oracle 9i, STAT 5.2, Windows XP, Mainframes Z/OS 390.