PROFESSIONAL SUMMARY:

• Over 6+ Years of experience in PeopleSoft HCM as a Senior PeopleSoft Technical Consultant, PeopleSoft Analyst, Techno - Functional in NA Payroll, Technical Experience in HCM & FSCM and PeopleSoft technologies.
• Executed Implementation, Re-Implementation/Upgrade, Customization, Testing, Production Support and Maintenance (deployed on time) of PeopleSoft HRMS in large corporations with remote teams.
• Experience in User Interaction, analysis of business requirement/processes, performing discovery session, fit-gap analysis, data conversion, effort estimation, milestones, deliverable and production support.
• Expert in system configuration, creation and review of functional design document, technical design document, coding, Unit test plan/test scripts, unit test results, Regression, User Acceptance, Security and Performance testing.
• Developed Custom Interface between PeopleSoft HCM and Digital portal application using Integration Broker for Job and Personal. One Link HCM sends job and Personal data from PS to Digital portal when a new hires and Digital portal solutions create LOGID & Email address sends back to PS.
• Developed custom Application Engine program to load External Total Reward data from external files (CSV, .txt and.dat). The conversion of both the Pension and Tuition external data sources for consumption by the Total Rewards module.
• Developed Custom SQR Report to generate Bi-weekly EMP Labor DL file and FTP process move the same file to Finance folder and Set up lunch schedules in Epay.
• Developed Payroll Conversion program using Application Engine between ADP and PS for Fed Tax, State Tax, Local Tax, Balances (Deductions, Earnings and Tax), Direct Deposit Distribution, Garnishment Details, Pay Check, Pay Line, Pay Other Earns and Pay Special Earns.
• Created a mapping document for HR and Personal Conversion between ADP system and PS HCM 9.2. Developed conversion programs (using Application Engine) for HR, Personal and Taxes.
• Created queries to view/Access from Hadoop Hue database for business compliance and working as a team member for Historical Data Migration for merger from various source.
• PeopleSoft HR Functional skills in Core HR, North American Payroll, Absence Management, Contracts, and Benefits.
• Developed SQR audit report to generate multiple reports like State Unemployment report, Worker's Compensation report and Service fee report.
• Leading merger, special projects and Production release items by collaborating with customers to develop business requirements.
• Facilitate requirements gathering and discovery sessions to understand and document complex business needs.
• BRD's and Functional specs for HCM merger projects, Special projects and Production Release and Partner with HRIS to articulate correct requirements for development and Design.
• Developed workflow to automate benefits Retro and arrears processing wage progression for Merger project.
• Assisting the HCM operations and risk management team by writing and running as hoc PS queries and reports.
• Involved documenting the functional and technical impact analysis for the P5 (Payroll processing partitioning) Project. Gone through a lot of internal and external interfacing applications, functional components and the complete PeopleSoft Application Engine, Batch, Custom, delivered modules, SQRs, COBOLs, JCLs and ESP part of their impact analysis exercise.
• Develop test plans and coordinate testing procedures for new implementations or changing processes, including writing process documentation.
• Extensive experience of different types of testing e.g Smoke Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Security Testing, Load & performance Testing.
• Functional HCM -Workforce Administration, Base Benefits, Benefits Administration, NA Payroll, Employee Self Service (ESS), Manager self Service (MSS), ePay, Payroll, e benefits, eDevelopment, Time and labor.
• In-Depth understanding of PeopleSoft Internet Architecture (PIA), Data models and client server applications on Windows and UNIX platforms.
• Provided Technical support for upgrade, worked on implementing Ben admin, TAM and Commitment Accounting modules.
• Experienced in gathering the requirements and analyzing those requirements and evaluates on more enhancements of the product, which suits the company for better performance and user convenience.
• Excellent technical experience includes working on People tools objects like Application Designer, Application Engine, AWE, Component Interface, File layouts, People code, Process Scheduler, PeopleSoft Query, Data Mover and PeopleSoft security including row-level security and setup of User Profiles and Roles.
• Experienced on upgrading the PeopleSoft HCM from version 8.8 to 9.2 and upgrading the People Tools version .
• Implemented Oracle HCM compensation module in Oracle Fusion Cloud. Extensively worked on FT EXTRACT process and modified the programs as per the business functionality.

WORK EXPERIENCE:

Sr. Peoplesoft HCM consultant

Confidential, Oakland, CA

Responsibilities:

• Created the file extract templates for core HR configuration and transaction data conversion processes and on-going interfaces for legacy to PeopleSoft system.
• Tested Enable Employee Self-service Enhancement where the user is unable to change his/her home address in Update Profile page and enable expense payments to be routed to alternate locations (addresses) other than the address sent from PayServ.
• Interacted with the Users and Functional analysts to come up with new requirements for the business unit and Change reporting period dates in EPay.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.
• Provided Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• Involved in Recruitment, Workforce Admin, Self Service (Employee and Manager), Compensation (Base and Variable), Core HR, Time and Labor, Benefits, Ben Admin, NA Payroll, Global Payroll, Absence Management and Time Collection Devices (TCD).
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR's & Online.
• Hands on experience with software analysis, design development, New implementation, Upgrade, customization and testing of ERP, client/server, Data Warehouse, Enterprise Performance Management applications, for various clients in areas of Corporate, Consumer, Investment Banking, Hedge Funds, Auditing, Insurance, Commercial Real Estate and Public sector undertakings.
• Worked closely with Installation, administration and upgrades of PeopleSoft environments on an Oracle/Solaris, PeopleSoft application architecture including the table structure, delivered objects, design standards, protocols and Involved in various PeopleSoft Applications Up gradation using Upgrade/ Change Assistant.
• Tools: Application Engine, Oracle 11g, MS Excel, PeopleCode, SQR, File Layout, Component Interface, Integration Broker / App. Messaging, XML Publisher, Crystal Reports and PS/Query, nVision.
• Maintained all application engine applications like PC TL TO PC, PC EX TO PC, PO CALC, ARUPDATE, GLPEDIT, VOUCHER EDIT & POST, Payment selection, Payment creation, Pay check creation processes as daily work.
• Configured Load balancing and high availability on Application server, Process scheduler and web Server and Involved in PeopleSoft Application upgrade.
• Developed Unix shell scripts to schedule reset of Process Scheduler, and Application Server domains. Developed shell scripts on the Application Server to generate the average transaction time served by each Application Server Instance. Created simple scripts to monitor the tuxedo domain to check queue/server status.
• Comprehensive experience in setting up security in HRMS, Financials, CRM, EPM, and Portal environments and created designs for AP, General Ledger, AR, AM, Billing, PC, PO, ePay and Expenses modules.
• Developed and test report, interface, conversion, and enhancement programs to meet the requirements in the technical specifications.
• Worked with New and Modified SQR Programs that deals with Global Payroll, Absence Management, and Time and Labor & Page and component creation, People code changes, creation of Application Engines and classes and Creation of Technical specification.
• Customized the delivered pages and Debugged the PeopleCode and the SQR reports for the requested requirements for Account Payable and Account Receivable Aging reports.
• Created functional specifications based on business process needs, wrote test scripts and supervised the entire customization process in collaboration with the technical team.
• Developed an SQR data conversion program to import payments from a third-party system to AR module and Involved in the setup of business units, configuring the setup options for Supply Chain Modules (AP, Purchasing, eProcurement).
• Customized delivered GL SQR's (GLS 7010, GLS 7002, GLS7014) to run the reports for 'ALL' Business Units.
• Developed a custom AE process that uses Component Interface to load project teams in Project Costing in peoplesoft Financials that gets messaged over to peoplesoft HR through Integration Broker.
• Co-ordinate with the Offshore developers in testing and documenting all the code changes, which includes Unit testing using the CA Sand Box, component integration testing, system integration testing, and performance testing using the CA MAT Tuner tool, capacity testing, quality reviews and implementing them successfully.
• Retrofitting various SQRs, Application Engines and People Code involving external inbound/outbound interfaces to new version and migrating them to the Production environment.
• Developed SQR program which will show the structural and data differences between any selected source database like HCM 8.9 to target database HCM 9.1 and writes the differences in two files one file is for Structural and other file is for Data differences which will be very useful for data conversions.
• Retrofitting the PSQUERY queries for both Public and Private queries as part of PeopleSoft Upgrade and handling the Integration issues from HCM 9.1 to CRM 9.1 and validating the Asynchronous messages at both ends.
• Developed Application Engine Program which will take the input file and process the particular associate into the Learning plan Enrollment and maintain the data into the PeopleSoft ELM tables.

Sr. Peoplesoft HCM consultant

Confidential, Minneapolis, MN

Responsibilities:

• Configured and successfully set up the PeopleSoft Auto Enrollment functionality and Involved in the reviewing, writing & execution of Test cases pertaining to Time and Labor, Core HR and Payroll, payroll interface & Completed in depth performance testing of new functionality implemented using PTF, HP-ALM and load runner.
• Worked on mapping the Time Reporting Codes to Earning Codes, Created Leave Plans and Benefit Plans Benefit Programs as well & Major project converting Data from PeopleSoft into EBS and worked closely with the business customers to create new customized BI dashboards.
• Coordinated with Users and Testing Team in successfully implementing the business requirements and customization into PeopleSoft Application and developed relationships with prospective and current clients by consistently reaching out to them and educating them about Epay
• Extensive work experience in understanding of Time Reporting Codes, Workgroups, TRC Programs, Value Lists, Template Built Rules and Custom Time Labor Rules.
• Created and Used Application Packages, Application engine programs, SQR Batch Programs, Menus, Components, Pages, Records, Fields and several complex SQL Definitions in order to achieve functionality.
• Responsible for creating, configuring and maintaining objects to support requested Business user Functionality according to development standards.
• Developed the new SQR process, Simplex compare process to load the exceptions into the custom tables we created for this project. An exception is created if there is a difference between the elapsed time from the simplex system and the payable time from people soft beyond the tolerance level set by the payroll team.
• Provided Gap and Business Analysis to identify modifications and business requirements, functional and technical programming for HRMS, Benefits Administration, Payroll, Employee Self-Service, Workflow, benefits modules which consisted of design documentation, table structure setup and modification of workflow process for daily event processing and Open Enrollment functionality.
• Extensive experience on support and enhancement of Peoplesoft HRMS - Time & Labor, North America Payroll, Core HRMS, Manager Self Service, Employee Self-service, Compensation and Profile Management.
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select & Implemented complex technical and system design specifications for benefits, benefits and Self-Service. Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
• Involved in maintaining and production support of PeopleSoft HRMS (Core HR, Workforce Administration, Performance, Benefits, NA Payroll) & Analyzed Human Resources/ Time & Labor/ Payroll/Benefits/ Time Capture business processes; work with business owners to achieve consensus for business process changes and facilitate transition to best practices as supported by PeopleSoft HCM.
• Configured the Pay check modeler, Online rule processing in PeopleSoft and Set Up and Configured WorkCentre and Dashboards in PeopleSoft & Set up Earnings codes, Earnings Programs, Pay Groups, Deduction Codes and Garnishments.
• Configured PeopleSoft Template based Time and Labor rules using Period Threshold, Holiday, Accumulator, Shift Premium templates & Perform Black Box Testing, White Box Testing, System Testing, System Integration Testing, Backend Testing and Functional testing for upgrade.
• Provided detailed test plans and technical documentation and Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Procedures for HCM module within PeopleSoft as well as interfacing modules, worked in Maintenance project, which includes Production Support as well. Apart from the Core HRMS, most of modules are newly developed; where my contribution is towards Performance Management, RTO, and s, Stocks &Improve project.
• Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and scheduled the jobs through process scheduler & Worked on several inbound and outbound interfaces using Application Engine, Component interface, File layout and also Integration Broker.
• Changes to People-Code so as to reflect the customizations as per the Clients requirements and execution of Queries on Security tables for Performance checks & Developed SQR programs for one-time conversion of Vendor and Customer's Data from legacy system to PeopleSoft & Created around 20 crystal Reports and ran through the process scheduler.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc.) for trouble shooting issues on People Code, Application Engine, SQR's & Online.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Report & Worked on NA payroll and Benefits, starting from adding an employee into the PeopleSoft system, enrolling that employee in benefit program by choosing plan type, options and coverage associated with various deductions.
• Developed SQR programs for one-time conversion of Vendor and Customer's Data from legacy system to PeopleSoft & Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR's & Online.
• Involved in the production & support and upgrade of the PeopleSoft HCM (HR, Benefits and Benefits Administration, Payroll and Time & Labor) modules based on organizational needs and requirements & Performed the Fit -Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.
• Responsible for implementing Position Data Pages in MSS by creating departmental budgets, Defined budget period calendars and source transactions & experienced PeopleSoft HRMS applications with Modules such as HR, Payroll, Benefits, Benefits Administration, Time and Labor, Absence Management, ESS and MSS.
• Worked on People Tools such as Application Designer, People Code, Application Engine, Maintain Security, Query and File Layout, Process scheduler, Data Mover, Component Interface, Integration Broker, Application Messaging, XML Publisher and Reporting tools (SQR and Crystal Reports).

Peoplesoft Consultant

Confidential, Lexington, MA

Responsibilities:

• Configured a new server and setup for generating form letters for Benefit Administration Process; Setup new eligibility rules and event rules for automated processing & Applied fixes and patches connecting to customer connection using change assistant.
• Led all development & testing efforts for People tools upgrade project (People Tools 8.48), HCM upgrade from 8.8 to 8.9. Mentored testers to identify and write effective test scenarios and manage test plans. Collected status reports and guided test resources with best practices and continuous improvement plans.
• Work involved configuration, customization and testing NA Payroll, e-Performance, e-Profile applications processing & Enhanced many online HCM applications with the Amazon's custom features in implementing new business rules by coding People-Code logic.
• Retrofitted and rewritten SQR and Application Engine programs. Developed configurable matrices compatible to PeopleSoft version & Facilitated Unit testing and System Testing process. Implemented PeopleSoft object Security by developing new Roles and Permission lists for user to access applications distinctively.
• Designed and developed Core HR and Time and Labor WorkCentre. Involved in online changes to the delivered pages, components, menus and translate values & Involved in Development, Enhancement, Upgrade and Maintenance of HR, Base Benefits, Benefits Administration, Payroll, and Time & Labor.
• Designed and developed of PeopleSoft HRMS for HR, Payroll, Base Benefits, Benefits Admin, Time & Labor and Self-Service modules on client specific functionality & Developed Excel To CI component Interface utility for loading data into tables.
• Involved actively in testing the Conversion Process to load Core Human Resources Tables, Benefits Deduction and Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Base Benefits modules.
• Developed Smart Flash enhancements for hire/ rehire, internal transfer and termination using Workflow notification templates & Worked with New and Modified SQR Programs that deals with Global Payroll, Absence Management, payroll interface and Time and Labor.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs & Assignments focused on Conversion, Configuration, Customization and testing Benefits, Benefit Administration, ELM and Talent acquisition applications processing.
• Customized the online programs functionalities using people code based on business need & Performed troubleshooting, testing, and HR, Benefits, and Benefits Administration application Event Maintenance and Open Enrollment process.
• In this project PeopleSoft HR system need to decommission after implementation of Success-factor system went live. Major responsibilities include lead in creation/modification of mapping, configuration and conversion workbook, conducting workshops, regular meeting with stakeholder of project.
• Worked on PeopleSoft HCM Modules (ESS, MSS, Timesheet) in FLUID mode and Experienced PeopleSoft Testing Framework (PTF) writing, executing test scripts & Worked on use of: Application Designer, Application Engine, Component Interface, SQR, People Code, Workflow, Cobol, Data Mover, Import Manager, Security Administrator, PS Query /Crystal Reports, xml publisher, Integration Broker, n Vision.
• Involved in the reviewing, writing & execution of Test cases pertaining to Workforce Administration, Payroll, e-Compensation, Variable Compensation, Benefits, Benefits Administration, e-Performance, Skills inventory and MSS/ESS.
• Designed a complete new custom SQR process to create passive events based on the parameters passed to the process and, I was Involved in setting up different flat rates and salary-based rates for different plans for the deductions to happen.
• Created and maintained a Project Tracker, Tracker includes Time-line, Tasks, Tables, Business Processes, Action items, Issues & Worked on Data Conversion from legacy system to PeopleSoft system and developed utility in PeopleSoft using Application Engine, Component Interface and SQR.
• Modified existing/vanilla PeopleSoft SQR Reports/ Interfaces/Processes as well as developed new reports/interfaces/process as per the business requirements. Also worked on Crystal reports.
• Worked on different Application Designer, People Code, Application Engine, SQR, Component Interface, Process Scheduler, PS Query, PeopleSoft Security, Process Monitor, Data Mover, File Layout, Integration Broker, XML Publisher.

Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Created requirement Specification (SRS) and FRD/FDS capturing Process Flows, Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams and Performed Gap Analysis and recommended solutions for better practice.
• Participated in Inception phase of multiple projects to identify the scope, high-level estimation and sprint planning.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Supported maintenance efforts, which helped me, develop client interfacing and management skills.
• Engage client to gather software requirements/business rules and ensure alignment with development teams.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Working with business to gather Print shop requirements for cancellation/Non-renewal documents and policy Documents.
• Resolved client issues on a regular basis and Obtained accounts payable information, researched, and reported findings back to client
• Customized page layouts for standard/custom objects and assigned record types and document the data tables, gap analysis, and work flow diagrams for the XML schema interfaces.
• Assisted in initial project planning with the management along with project scope, budget, timelines and other parameters.
• Acted as a liaison between users, business stakeholders and technical team to keep them in sync with the project progress.
• Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs and improving on shelf availability.
• Assisted in the development of project definitions, project scope, cost/benefit and risk analysis, work plans, daily and weekly progress reports, and presentations.
• Have uploaded data using MS Add Ins for additions, deletions and changes within the database tables
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a system.
• Assisted project team in preparing Functional Specification Document (FSD), developed non-functional requirements, and documented Business Requirements Document (BRD).
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Worked with developers and designers of BPM System to make sure development understands business.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).