SUMMARY:

• PeopleSoft Techno Functional Consultant with more than 6 years of experience in PeopleSoft Development, Implementation, Customization, Upgrades, Testing, Maintenance and Production environments.
• Proficient Experience in PeopleSoft HCM modules, Administer Workforce, Base Benefits, Benefits Administration, Talent Acquisition Manager, Candidate Gateway, NA Payroll, Employee/Manager Self Service, Time and Labor, Administer Training, ePerformance, Track Global Assignments and Monitor Health.
• Excellent coding and debugging skills in SQR, PeopleCode and Application Engine and proficient in writing SQL queries, Stored Procedures, functions and UNIX Shell Scripts.
• Proficient in performing FIT/GAP Analysis, Impact Analysis, Data Conversion, Debugging, Troubleshooting and Performance Tuning.
• Extensive Experience in Uploading data from flat files to PeopleSoft tables using Application Engine/ Component Interface/ File layout combinations and SQR programs.
• Testing expertise in performing Functional, System, Regression, Performance, Integration, End to End and User Acceptance Testing.
• Experience with Database Technologies (Oracle, Informix, DB2 and SQL Server), Microsoft Office Tools, Visio, Version Control Tools, Scheduling Tools.
• Strong PeopleSoft technical Skills include PeopleTools, PeopleCode, Application Designer, Application Engine, Application Packages, Component Interface, File Layout, Fluid, Integration Broker, Security, PS Query, Process Scheduler, Data Mover, Workflow, SQR, Crystal Reports and BI Publisher.
• Extensively used PeopleCode, Process Scheduler, Data Mover, SQR, and Application Designer in developing batch and report applications.
• Extensive experience in implementation, upgrade and conversion, enhancement and support of PeopleSoft Application.
• Experienced in working with Report Generation in PS Query, XMLP, PS/nVision and Crystal Reports.
• Expertise in the development of Conversion and Interface programs using SQR, Component Interface and Application Engine, Integration Broker.
• Used PeopleSoft Integration Broker/Web Services for real time interfacing of PeopleSoft systems with external systems.
• Hands on experience in working on PeopleSoft Application development and Production Support model projects with on call support experience.
• Expertise on Data mapping and Data Analysis between Legacy systems and PeopleSoft System and in writing functional specifications documentation for business requirements.
• Expertise in creating the PeopleSoft technical design document and in creating test plans, test scripts, and perform end - to-end testing.
• Experience with end user training and preparation of training material and user documentation.
• Analyzed Upgrade Plans, executed and reviewed Compare Reports, applied Upgrade Application steps, fixes and patches for the upgrade process, and performed production test moves.
• Expertise in troubleshooting of various technical and functional issues. Proficient in creating and customizing pages and tables using Application Designer and PeopleCode.
• Expertise in documenting technical specifications for customizations in various modules and Solid background in strategic business analysis, change management, and risk assessment.
• Ensure all merchant services are handled through the department Perform Special Projects related to banking and Cash Management
• Extensive experience in eliciting business requirements by conducting user interviews, JAD session workshops, meetings and seminars, analyzing and optimizing processes and converting user requirements into business requirements throughout the SDLC.
• Exemplary skill in creating artifacts such as Unified Modeling Language (UML) standard diagrams including Use Cases, Activity, Class, Sequence, Process flow Diagrams and system context diagrams using Microsoft Visio.
• Expert in developing all the SDLC documents such as Business Requirement Documents (BRD), Functional Requirement Document (FRD), Non-functional Requirement Document (NFRD), Use Case Specifications, Requirement Traceability Matrix (RTM) and testing documents.
• Excellent Presentation skills and Flexibility in adapting to a wide range of work environments by inculcating new relevant skills with ease in a time sensitive frame.
• Experienced in GAP Analysis, Cost Benefit Analysis, organizing, facilitating and coordinating weekly meetings, conference calls and other regular project meetings.

SKILLS/TOOLS:

ERP: ELM - Setups of ELM system, Creating and security of Items/Activities. HRMS/HCM - e -Performance, Recruiting, Core HRMS, ESS, MSS, Setup HRMS/HCM and Workforce Administration, TAM, Time & Labor, Benefits and Payroll.

PeopleSoft Technical:

People Tools: Application Designer, PeopleCode, Application Engine, Fluid, Activity Guide, Web Services, Integration Broker, SQR, Component Interfaces, XML Publisher, PS Query, File Layout, Excel to CI, Workflow, SQL, Data Mover, Stat tool, Query Security, Row Level Security, Mainframe (JCL) to run SQRs on UNIX, Tree Manager, nVision, Talent acquisition.

Reporting Tools: SQR, XML Publisher for PeopleSoft, PeopleSoft Query, Pagelets Creation

Management Tools: MS Excel, MS Access, MS Word, MS Power Point, Clarity, MS Project 2010, MS Outlook, MS SharePoint, Sales Force, Oracle.

WORK EXPERIENCE:

Sr. PeopleSoft Techno-functional Consultant

Confidential, Bloomington, IL

Responsibilities:

• Worked in the Application upgrade, development and Customization of PeopleSoft HCM, Benefits, Self Service modules, NA Payroll, TAM, Candidate Gateway, NA Payroll, Profile Management. This involved program design, development, planning, Unit & Integration testing.
• Designed and developed, Unit and Integration Testing of various interfaces and reports in Payroll, Training, Benefits as part of the Chart of Accounts Restructure for 9.2 Upgrade.
• Responsible for the design, development and implementation of complex initiatives like SCA, Onboarding and the post go live support.
• As a Techno- Functional Consultant involved in the analysis of Core HR & Payroll modules and presented Technical Design walkthrough for NA Payroll to the Functional users.
• Worked extensively on customization of modules including Self Service (MSS, ESS), North American Payroll.
• Involved in the functional design gathering for new enhancements and in retrofitting the customize objects of NA Payroll and benefits as per PeopleSoft 9.2.
• Provided functional support in new implementation of Absence Management module to support and converting existing system to PeopleSoft module implementation.
• Worked with Leave Management office in gathering business requirements and converting the policies of PTO, Sick and other leave types.
• Gathered requirements from the users, and modified the Application Engine programs, People code, SQR related to PeopleSoft.
• Created several Queries, SQR reports for the users and customized page for the users to review receipts that are not matched before the accrual process.
• Created an App engine that closes the unmatched receipts after the user approvals from the above page. Also, found the bugs in existing PeopleSoft 9.2 system and report to Oracle and created BI Publisher Reports for Monthly, Quarterly & Yearly using PS Query.
• Extensively involved in the Application and Tools Upgrade and Customization of the PeopleSoft HR, Payroll, Benefits, TGA, Self Service modules and TAM from v8.9 to 9.2.
• Participated in the fit-gap analysis, developed Functional and Technical specifications with Test cases, Test plans and Test Scenarios for Upgrade.
• Responsible for the analysis of the customizations to upgrade, created the Keep Drop Analysis of Track Global Assignments for 8.9 to 9.2.
• Performed Vanilla Comparison test between our demo database and our copy of production to identify customizations and analyze the reports.
• Retrofitted their old database customizations into the newer database and prepared the Keep drop analysis for Talent Acquisition module for PeopleSoft Upgrade to 9.2.
• Defined Data Conversion rules developed Data Mapping documents and written Conversion programs to convert the Employee's data from legacy systems into PeopleSoft system.
• Responsible for Migration of objects from Development to test regions and administering the development Unix box which hosted web servers, application servers, process scheduler.
• Created interfaces, fields, records and setup pages for the NA Payroll for Salary Averaging. Created Loaders for loading the contract data, personal data using Unix shell scripts.
• Created eDiscovery process, which takes snapshot of the PeopleSoft data for an employee, this involved creating an Application Engine using metadata to fetch information pertaining to an employee and associated organizational information from different PeopleSoft tables, to cater to the legal requirements.
• Created security views, permission list, roles and attached the role to the Users, for security requirements - eDiscovery a custom tool for snapshot of an employee this is to cater to the legal requirements. Created and modified Application Packages as needed for use with Integration Broker.
• Provided technical application support to business, quality assurance and end-user support teams

PeopleSoft Techno-functional Consultant

Confidential, New York, NY

Responsibilities:

• Extensively involved in the Customization of the PeopleSoft HR, Admin Workforce, Self Service modules, and Helpdesk modules.
• Defined Data Conversion rules developed Data Mapping documents and written Conversion programs to convert the Employee's data from legacy systems into PeopleSoft system.
• Interacted with Business users, IT SMEs and functional SMEs every day, and support day to day queries of business users on PeopleSoft functions or issues.
• Developed and maintained an effective business relationship, acting as a liaison between the end users and technical support staff.
• Mapped complex businesses processes and make recommendations for Business improvements.
• Derived requirement gathering, design, unit testing, UAT coordination and final implementation stages. Responsible for the code modifications and configurations for People Tools Upgrade to 8.52.
• Created new Application Engine programs and Interfaces using Integration broker for Internal Apps and PeopleSoft environments.
• Discussed with clients about the requirements of HCM Recruiting, Core HRMS, ePerformance, Payroll reporting and Configuration related.
• Conducted meetings with Development teams and Business users for reviewing the product and test scenarios to get sign-off.
• Executed test scripts for Functional Unit Testing, System Testing and Data Conversion validation testing.
• Presented complete flow of e-performance system and Learning Management system using Visio and PowerPoint presentations.
• Used agile methodology. Have been involved in Sprint Planning, Daily scrums, Sprint Review and Retrospective with cross functional team.
• Worked on many user stories and Fit gap analysis of HCM and ELM System and have worked on Base benefit and Ben administration implementation.
• Performed Integration testing to check appropriate Benefits of Employees coming from Benefits. Involved in the integration testing 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.
• Worked on HR to ELM sync using Integration Broker. Have done customization of recruiting module includes detail analysis, designing, coding and testing with documentation.
• Worked on testing the Integration Broker that sends file to third Party Vendor. Developed use case documents, activity diagrams, workflows and process maps.
• Learned the functional concepts of NA Payroll and resolved the issues which we faced while running the payroll jobs and NA Payroll
• Involved in debugging the complex Application package codes and resolved most of the issues and development and Unit test plan creation.
• Collaborate with stakeholders to discuss the feasibility, profitability, and risk of the project and assist to develop project plan using Agile Methodology.
• Gather detailed business requirements and deliver detailed business functional requirements specifications.
• Create UML diagrams such as Sequence Diagrams, Activity Diagrams and User Stories when needed
• Getting involved in System Integration, User Acceptance Testing and in Implementation

PeopleSoft Consultant

Confidential, New York, NY

Responsibilities:

• Designed and developed Commitment Account rules. Created Workflows for Long-term retro in Commitment Accounting. Created new IB Interfaces.
• Retrofit new customizations in HCM 9.1 and People Tools 8.53 & 8.54 environment, exclusively worked on custom pages, AE, SQR and people code.
• Worked on Forms in ELM and have created a CI to load data from Form onto the People soft Component.
• Worked extensively to understand Time Reporting Codes, Workgroups, TRC Programs, Value Lists, Template Built Rules and Custom Time & Labor Rules.
• Met customer needs by creating custom reports, editing existing reports, and scheduling reports with PeopleSoft reporting tool and calculation fields.
• Worked on customizations and reports in Time and Labor, Absence Management, ELM and HR modules.
• Troubleshot and diagnosed PeopleSoft, Transitions, and Taleo issues, delivering swift resolution and Involved in development and maintenance of HR dashboards weekly, monthly, quarterly, annual reports, Headcount, Hires, Terminations, off cycles, Merits, Global Compensation & Turnover reports to outline and analyses some of the following: workforce trends, quarterly dashboards, monthly reporting with detailed analyses.
• Worked as a functional consultant to analyze and support the PeopleSoft HCM/ELM Upgrade effort.
• Analyzed, documented and advised commitment accounting, payroll regarding tax updates, and applied patches, and Tax updates; worked with Oracle support team to obtain delivered solutions to issues.
• Modified Time & Labor reports as a part of upgrade and retrofitted several customizations analyzing the reports.
• Responsible for payroll tax and garnishment accounting, auditing, and all reconciliations.
• Extensively worked with the HCM Upgrade team and functional users to develop, support and resolve technical issues in Workforce Admin, Absence Management, Talent Management, Payroll, and Benefits.
• Retrofitted custom Time & Labor rules, exceptions, developed new rules and rules migration. Conducted Compare Report analysis for PeopleSoft Changes, Customer Modified changes and analyzed the objects to be upgraded.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Developed many Inbound/Outbound interface Application Engine Processes to get data between PeopleSoft system and third-party systems.
• 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.
• Working on customizations for self-services, core HR and Benefit HRMS modules
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Absence Management, Talent Management, 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.
• As a Techno- Functional Consultant involved in the analysis of Core HR & Payroll modules and presented Technical Design walkthrough for NA Payroll to the Functional users.
• Involved in the functional design gathering for new enhancements and in retrofitting the customize objects of NA Payroll and benefits as per PeopleSoft 9.1.
• Also, found the bugs in existing PeopleSoft 9.1 system and report to Oracle. Created BI Publisher Reports for Monthly, Quarterly & Yearly using PS Query.

Business Analyst

Confidential, Jersey City, NJ

Responsibilities:

• Performed Business Modeling to understand their current business process and existing application and conducted requirement workshops among all project stakeholders to verify and validate the business requirements.
• Participated in Joint Application Development (JAD) sessions by convening project sponsors, end- user representatives, development team members, subject-matter experts, technical personnel, and different stakeholders to communicate their perspectives with each other, resolve any issues and come to consensus.
• Identified Use Cases and wrote Use Case Narratives and worked closely with the development team to help them understand Use Case Narratives.
• Handled the development of Business Requirement Documents (BRD) resulting from JAD sessions by gathering business requirements from users.
• Involved in maintaining Requirements Traceability Matrix (RTM) and participated in identifying opportunities and parameters for business process improvements.
• Iteratively developed the project using Scrum. Used SQL to retrieve and update requirements during project execution.
• Created Use Case Diagrams and Activity Diagrams using MS Visio, and Assisted QA department to write and execute Test Cases.
• Conducted research to determine if solutions to business requirements currently exist within or outside the business unit, and if not, whether new solutions are feasible.
• Analyzed impact of proposed solution across the business, develop use cases to explain/demonstrate business requirements/specifications to IT team, and contribute a business or process perspective during design reviews.
• Assisted Quality Management team to ensure that requirements documentation can be easily translated into test plans and ensure that the proper testing plans have been completed.
• Facilitated implementation of new functionality through training sessions, demos, and the development of appropriate documentation.
• Prepared weekly Review and Status Reports, which included Test Case Standings, Metrics, QA Issues and Defects and communicated the project status to client bi-weekly, highlighted changes made in requirements and gathered new requirements.
• Created End-User Training Manuals as well as documented Release Notes.