SUMMARY:

• Above 11 years of experience as a Project Lead/Senior PeopleSoft Techno Functional Consultant in Requirement Gathering, Analysis, Design, Development, New Implementations, Customizations, Upgrading and Testing of PeopleSoft Applications.
• Worked on various modules of PeopleSoft HCM v 8.8/9.0/9.1/9.2 like Core HR, Workforce Administration, North American Payroll, Employee Self Service (ESS), Manager Self Service(MSS), Base Benefits, Benefits Administration, Time & Labor applications.
• Expertise in Technical role and Good Functional understanding during Application Development, Implementations, Upgrade, Reports development, Data Conversion, Migrations, Production support, Scheduling, Web services and Performance tuning using Waterfall/Agile development practices.
• Worked as a Lead for different teams during Application Development and guided the team to achieve Business functionality.
• Demonstrated excellent Technical and Leadership skills on numerous projects by coordinating with the onsite and offshore resources, creating documentation, developing solutions and design, performing technical control and testing of delivered work, keeping track on project progress, leading meetings and conference calls.
• Proven track of record on all stages of System Development Lifecycle and object - oriented analysis, and programming methods.
• Performed Fit-gap analysis and Created functional requirements as an input to application design.
• Performed full-lifecycle Implementations with emphasis on design, customization and production support.
• Experienced in PeopleSoft HCM requirement analysis, technical design, implementation methodologies, conversion/interface strategies, data mapping, development, customization, tuning, and issue resolution.
• Proficient with Payroll Scheduling, On-Cycle Processing, Off-Cycle Processing, Online Checks and Payroll Balances.
• Extensive experience on PeopleTools like Application Designer, Peoplecode, Application Engine, Component Interface, Workflow, PS Security, Process Scheduler, ESP, PS/Query, Data Mover, Import Manager, Application Messaging, Web Services, Configuration Manager, Process Monitor, Application Package, Workflow, AWE, Application Packages, Integration Broker, PeopleSoft portal and Utilities (SQL Trace and People Code trace), STAT, Phire.
• Help all business users achieve maximum utilization of the PeopleSoft system capabilities to achieve process improvements, identifying and communicating opportunities for automation.
• Good hands on experience in trouble shooting the problems and improving the performance of application processes by Debugging, tuning and tracing.
• Strong SQL development skills using multiple joins, multiple unions, and sub queries.
• Excellent report-generating skills using PS/Query, SQR, Crystal Reports and XML Publisher.
• Trained employees at different levels in People Tools, SQR, and design and development process.
• Good knowledge in PeopleSoft Internet Architecture and its components.
• Experience in PeopleSoft HCM security with knowledge of profiles, roles, permissions and portal structure/registry, password controls, query security and tree management.
• Energetic, enthusiastic, self motivated person with good communication skills, strong problem solving and analytical skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure.
• Quick learner with an ability to rapidly achieve organizational integration, assimilate job and employ new ideas, concepts and methods.

TECHNICAL SKILLS:

ERP: PeopleSoft HCM v 8.8/9.0/9.1/9.2

Enterprise Applications: PeopleSoft HCM CoreHR, Absence Management, Employee Self Service, Manager Self Service, Benefits Administration, NA Payroll, Time

People Tools: People tools v8.4x, 8.5x, Application Designer, Peoplecode, Process Scheduler, Application Engine, File Layout, Component Interface, Data mover, Configuration Manager, Workflow, Data Mover, Web Services, Application Packages, Integration Broker

Administration Tools: Security Administration, Object Security

Reporting Tools: SQR, PS/Query, Crystal Reports and XML Publisher.

Debugging Skills: Peoplecode, Application Engine and SQR.

Database: Oracle, DB2, MS SQL Server.

Languages: SQR, SQL, PL/SQL, HTML

Web & GUI Tools: XML, HTML, JavaScript

Tools: STAT, Phire, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Orangeburg, NY

Peoplesoft Techno Functional Consultant

Responsibilities:

• Involved in Design, Development, Testing of PeopleSoft HCM/HRMS Application for Core HR and NA Payroll.
• Involved in fit-gap analysis, Design and Development for MetLife to Sedgwick Disability Claims Projects.
• Worked on HR and Payroll Enhancements for New Acquisitions (Yahoo, XO Communications).
• Worked on Peoplesoft to SAP Interface programs to send Peoplesoft Job data to SAP system.
• Provided implementation and post-production troubleshooting and support for PeopleSoft HR and Payroll Projects.
• Managed and Created Technical design Documents, Test plans, Test scripts.
• Created customized Application Engine programs based on user requirements for Disability Notifications.
• Created custom SQR’s to validate all approved Alternate Work Arrangement and ensure the Tax tables are correct based on work and alternate location
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Enhanced SQR’s to implement new logic for Sedgwick Disability Requirements.
• Involved in running weekly and biweekly payroll and sending payroll deduction information to 3rd party vendors.
• Modified online objects to hide beneficiary information based on different Benefit Plan Types.
• Created Unit test scripts to test the business functionality for the delivered code based on the requirements.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Conducted thorough UAT, integration, and regression testing of the application and migration of the projects.
• Coordinated and facilitated with different teams for change requests and issue resolutions.

Environment: PeopleSoft HCM v9.2, People tools 8.53, Oracle.

Confidential, Columbus, OH

Senior PeopleSoft Developer

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement PeopleSoft HCM/HRMS Application for Core HR, Base Benefits and Payroll.
• Worked on Benefits Annual Enrollment process for 2017, Payroll Overtime and Bravo (Rewards & Recognition) Enhancements.
• Developed Outbound Interfaces for transmitting employee Data to Benefits vendors and created Inbound Interface to process the received data from third party systems and insert into various PeopleSoft Tables.
• Worked directly with business users to develop enhancements to the business processes and to improve the employee experience when using the Self-Service application.
• Understood the business needs and analyzed Functional Requirement and Defined the scope of requirement and prepared Technical Design Documents.
• Joint efforts with functional analysts to identify technical requirements, program specification, functional system test, user acceptance tests and implementation plans.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Created Application Engine Programs and Component Interfaces for Payroll Overtime Auto Approvals and Notifications for FLSA eligible Associates.
• Modified Associate and Manager Self Service pages as per client requirements for different regions for Overtime Entry and Approvals.
• Customized online people code to update employee enrollment plan details into Health Benefit, FSA Benefit, Life Benefit, Savings Plan and Disability Benefits running BenAdmin Process.
• Worked on XML Publisher to create Payroll Overtime reports for the Managers.
• Created new Text Catalogs and Message Catalogs for Email templates for different notifications as per client requirement.
• Identified poorly performing SQL and fixed by indexing, hints, or other techniques
• Migrated PeopleSoft objects from development to test environments using Phire.

Environment: PeopleSoft HCM v9.1, People tools 8.54, Oracle.

Confidential, Boston, MA

Project Lead/ Consultant System-Dev

Responsibilities:

• Understanding the legacy system in dominos and prepared fit gap analysis and design documents to retrofit and upgrade the Benefits and Time & labor applications in Peoplesoft HCM 9.2.
• Extensively utilized Compare reports for retrofitting the application by identifying differences between base versions with the target version.
• Retrofitted the customized objects, based on the compare report and analyzed to retain vanilla or to reapply customization Ran Audit reports SYSAUDIT and DDDAUDIT Reports to compare data structures.
• Translated design and GUI requirements into portal branding rules, including PeopleSoft style sheet creation role-based branding, templates, and themes.
• Worked alongside of business analysts and testers to communicate capabilities and limitations of PeopleSoft HCM Enterprise portal technology (as SME).
• Facilitated and participated in Joint Application Development (JAD) sessions for communicating and managing expectations with the business users and end users.
• Designed PeopleSoft Security using Security by Row Level Security, Roles & Permission lists
• Involved in creating new User profile, Roles and Permission list according to the business requirements to access certain pages.
• Implemented online peoplecode to eliminate batch programs between the systems and reduced the wait time.
• Designed test plans and approach to validate complex Time and Labor, Absence Management business rules.
• Responsible for the Data mapping, Data Conversion and Data Loading into people soft tables and preparing conversion reports using SQR, Component Interfaces and load data into people soft tables.
• Using Application Engine for performing background SQL processing against the database.
• Created Interface between Absence and Time and labor System to report employees who have medical and FMLA time reporting codes.
• Design, develop and implemented Short Term Disability (STD) custom process for all non management employees.
• Extensively worked on XML Publisher for Repots and generating Medical letters.
• Designed and developed peoplecode and application engine programs to send emails with PDF attachments to the administrators.
• Created XML files and generated XML publisher reports for FMLA Letters.
• Fixed modal window issue for all Secondary pages and updated queries, views and label changes after people tools upgrade from 8.51 to 8.53.

Environment: PeopleSoft HCM v9.2, People tools 8.53, Oracle.

Confidential

Project Lead/ Consultant System-Dev

Responsibilities:

• Lead a team on Peoplesoft HCM Absence - 4 Day Exempt and 10 Day Cap projects.
• Served as a business and technical advisor, employed best practices and project management methodology to guide team to effectively use the solution to meet business requirements and ensure member satisfaction
• Experience in conducting Joint Application Development (JAD) with end-users and clients.
• Conduct Conference Room Pilots and demos on New design and implementations
• Create Master Test Plan and Test cases for UAT and coordinate the UAT with Business users.
• Act as Liaison between HR users and Technical team.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation. Provided production support and functionality enhancements to improve HR and Payroll efficiencies.
• Provide status reports to higher management and made sure project timelines are met.
• Initiated Daily calls to discuss project direction, scope changes, and other issues.
• Tailored online peoplecode to provide exemptions for employees who are within the eligible Labor agreements for wire line associates of Confidential USA.
• Developed new SQR program to implement the 4 day and 10 day Attendance exemption for New York employees and generate reports.
• Developed Application engine programs to find the discrepancies between the PeopleSoft and third party system and send emails and reminders to the supervisors and absence administrators.

Environment: PeopleSoft HCM v9.1, People tools 8.52/8.53, Oracle.

Confidential

Project Lead/Consultant System-Dev

Responsibilities:

• Developed and implemented an application for Reporting Tardiness.
• Worked on SQR’s to create new reports for Employees tardiness.
• Partnered with the key project stakeholders including Business Team, Integration team and IT development teams to define project scope, develop/refine project schedule and develop overall project plan.
• Developed components and pages to check the Employee information about his attendance score card, Attendance history and discussions held by their supervisor and employee.
• Created new online screens for documenting the tardy discussions held between the supervisors and their direct reports.
• Tailored peoplecode to integrate the tardy discipline logic for Attendance Control Plan into the discussion documentation components.
• Designed and developed SQR program to load the Time data into the peoplesoft system and calculate the FMLA balances.
• Participated in Joint Application Development (JAD) sessions for communicating and managing expectations with the business users and end users.
• Worked on Application Designer in developing Run control pages and Menu customizations.
• Developed Application engine programs to send emails to supervisors.
• Implemented custom security by creating different roles and permission lists.

Environment: PeopleSoft HCM v9.1, People tools 8.52/8.53, Oracle.

Confidential

Project Lead/ Consultant System-Dev

Responsibilities:

• As an Implementation Lead, managed the team in design and development activities for Attendance Control Plan project to meet client requirements.
• Involved in discussion with Onshore and clients and created Technical designs.
• Developed Application Engine programs to send emails and reminders to complete the disciplinary actions.
• Worked on the Details designs and development for Workplace accommodations.
• Created and customized new pages, records, fields and components through Application designer.
• Worked with Process Scheduler, Process Monitor, Edited Run Control, Granting security access and scheduled programs on recurring basis.
• Customized and created new message catalog information according to the business requirement.

Environment: PeopleSoft HCM v9.1, People tools 8.52, Oracle.

Confidential

Consultant System-Dev

Responsibilities:

• Involved in User discussions to understand the overall requirements of the various Labor Unions and participated in creation of BRD.
• Travelled onshore to directly interact with the Business users in order to understand the requirements first hand.
• Involved in creation of Functional flow diagrams and created Technical Designs.
• Initiated walkthroughs of the application with the users to reduce the manual work and automate the process.
• Created data conversion programs to load data from the legacy system.
• Develop custom reports utilizing XML, SQR, and File Layout with Application Engine.
• Involved in detail design, development, testing, conversions and modifications of the application as per the client requirement.
• Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both the systems.

Environment: PeopleSoft HCM v9.1, People tools 8.52, Oracle.

Confidential

Consultant System-Dev

Responsibilities:

• Extensively worked on peoplesoft objects to delegate access and created dynamic views for search records.
• Worked on Peoplesoft security to create new custom roles and assign the roles dynamically through batch process.
• Worked directly with business users to develop enhancements to business processes to improve the employee experience when using the self-service application; resulted in a reduction in support staff.
• Developed and customized new pages, records, fields and components through Application designer.
• Created SQR to grant Absence supervisor roles to the supervisors with associate’s as direct reports.
• Developed online pages for Absence supervisors to delegate access to Administrator, Cross Coverage and Executive roles.

Environment: PeopleSoft HCM v9.x, People tools 8.5x, Oracle.

Confidential

Specialist System-Dev

Responsibilities:

• Involved in Technical Gap analysis with functional team for ONE-HR system.
• Modified the existing system to accommodate the application into ONE-HR.
• Involved in retrofitting the application into dashboards to make the application user friendly and make it easier for the users to access.

Environment: PeopleSoft HCM v9.x, People tools 8.5x, Oracle.

Confidential

Specialist System-Dev

Responsibilities:

• Involved in Requirement gathering and designs of FMLA Frequency and Duration and Short Term Disability automation projects.
• Created batch (SQR) process to automate the STD process which inserts the STD data sent by external system into Absence tables on a daily basis and worked on process scheduler to schedule jobs.
• Researched and delivered printer friendly options for custom PeopleSoft pages.
• Created Application Engine programs to send data to external Dominos systems.
• Developed batch programs to update the approvals sent by the Absence Reporting Center (Dominos) and update the absences and track the balances and eligibilities.
• Developed new application to change the existing system and make it more users friendly and efficient.
• Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed batch process to load the payroll time data into the AMTS system and calculate the eligibilities and exemptions.
• Created online screens to correct the data feed sent by the payroll system.

Environment: PeopleSoft HCM v9.x, People tools 8.5x, Oracle.

Confidential

Analyst

Responsibilities:

• Retooled and upgraded the whole Peoplesoft HCM AMTS application from DB2 environment to Oracle Environment.
• Retrofitted custom SQRs and Application Engine programs so as to ensure they successfully run in the new environment.
• Developed and created online objects, Batch programs and reports to retool the application from DB2 formats to Oracle format.
• Extensively worked online peoplecode, Application Engine programs and SQR’s and created online objects to achieve the exact business requirement.
• Developed Style sheets and java script to improve the look and feel of the application.
• Worked closely with the clients and system users to achieve the exact requirement and functionality.
• Efficiently Handled and resolved the data conversion issues
• Detailed impact analysis was done to identify the objects, compared between old and new model to retro fit. All customized objects were identified, exported and migrated.
• Involved in user meetings and technical discussions with the onsite counterpart to develop and deliver the application which meets the user expectations.
• Worked on WLI (Wire Line Integration) project to make the AMTS system available for all wireline associates also.

Environment: PeopleSoft HCM v8.8/9.0, People tools 8.4x,DB2, Oracle.

Confidential

Analyst

Responsibilities:

• Worked on AMTS (Absence Management Tracking System) Production support and Enhancements.
• Providing technical support for the existing application and was responsible for Analysis, Troubleshooting and Problem Resolution.
• Cleaned up all objects from SYSAUDIT and performing analysis for objects such as menu, menu groups, panel groups, panels, records and fields, People Code and reviewing all custom batch processes such as SQR, AE and prepare document for all re-mapping.
• Monitored and tuned scripts to achieve optimum performance levels.
• Provide support by troubleshooting and fine tuning performance issues related to PeopleSoft batch programs.
• Worked with the clients to understand the functionality to resolve the issues.
• Involved in providing the estimation on work effort for the new Enhancements.
• Enhanced SQL’s and Views to improve the performance of the System.
• Created AMTS application reports using PS Query and Crystal Reports.
• Worked on the new enhancements for FMLA Compliance including technical design documentation, development and Unit testing and Production Support.
• Solely worked on FMLA Compliance Enhancements like creating new objects for state law eligibility, Flu symptoms, Time data and Absence status correction.
• Created new objects for creating FMLA certification only for West employees within the AMTS system.
• Developed FMLA Compliance Reports using SQR’s and Crystals.

Environment: PeopleSoft HCM v8.x/9.x, People tools 8.4x/8.5x,DB2, Oracle.