We provide IT Staff Augmentation Services!

Senior Peoplesoft Techno Functional Consultant Resume

Dublin, CA

PROFESSIONAL SUMMARY:

  • Over 10 years of experience as a PeopleSoft Techno - Functional consultant Experience in Implementation, Customization, Upgrade and Development of PeopleSoft HCM/FSCM applications in offshore/Onsite Model.
  • Managed the application through all stages of the software development life cycle including defining the project scope, executing fit-gap analysis, designing, developing, testing major customizations to modules and end users.
  • Key strengths are strong commitment to results, customer satisfaction, excellent analytical, problem solving skills and self-learning skills.
  • Experience in wide range of PeopleSoft HCM/FSCM modules including Core HR, Base Benefits, Ben Admin, NA Payroll, Time and Labour, TAM, Candidate Gateway, AP, AR, GL, PO, Expenses, AM &e Pro.
  • Experience in working on all ERP life cycle like Upgrade, Development Implementation, Customization, and Production Support.
  • Experience in PeopleSoft HRMS ( HR/ NA and Global Payroll/ Base Benefits/ Benefit Administration/ Time and Labour ).
  • Strong technical expertise is in online development, People Code, data management, conversions, interfaces, reporting, and Application Engine, across HCM, and Financials.
  • Implemented P2P cycle, Asset Management, Travel & Expenses and GL modules in 9.2
  • Involved in full upgrade of PeopleSoft HRMS/FSCM versions 9.0 to 9.2 using Upgrade Assistant/Change Assistant, Application Designer and Data Mover Scripts.
  • Excellent knowledge in creating smart HR forms to update the employee data, position data
  • Strong Knowledge to implementing translation Framework .
  • Developed the interfaces to send the PeopleSoft PO, Invoice information to ARIBA.
  • Involved people tools objects retrofitting to fit the functionality into the higher version.
  • Prepared Fit and Gap analysis documents as per requirement.
  • Technical expert in using Application Designer, SQR, People Code, Application Engine, Excel To CI, Integration Broker, Component Interface, Process Scheduler, Fluid Pages, PS Query, Process Monitor, Data Mover and File Layout .
  • Strong technical expertise in module interfacing, data conversion, data migration, data archiving, reporting and writing/debugging People Code.
  • Designed, developing and customized Fields, Records, Pages, Component, Menu and wrote People Code at all events of record, component record and Page Activate.
  • Created various Reports using PeopleSoft Reporting Tools, SQR, Crystal Reports, XML publisher, PS Query. Developed and tuned SQL queries.
  • Worked on providing People soft Security thru Permissions and Roles, also worked on PS Application security, department security.
  • Experience in Oracle Database including Oracle PL/SQL, DB2, Oracle 10g, 11i, SQL.
  • Developed Reports using SQR, Crystal report, XML Publisher, PS Query and OBIEE.
  • Profound knowledge on SQL and RDBMS concepts such as Normalizations, SQL optimizatio n and tunings.
  • Work Experience on UNIX, Windows Servers, Shell Script, Batch Scheduling Application Control-M, and Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Controller Tool STAT, Phire and Defect Tracking Tools like HP Quality Center, JIRA and Test Director.
  • Worked very closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD) and designing Technical Documents based on FR.
  • Extensive knowledge of full Software Development Life Cycle (SDLC) and agile methodology.

TECHNICAL SKILLS:

Programming Languages: People Code, SQL / PLSQL, Core Java, HTML and XML

ERP HCM Modules: Core HR, Base Benefits, Benefits Administration, Profile Management, TAM, Time and Labor, NA Payroll and Self-services modules.

ERP FSCM Modules: PeopleSoft Financials (9.2/9.1 / 9.0 ) - AP / GL / AR / AM/T&E)

People Tools: People Code, Application Engine, Integration Broker, private grids, Component Interfaces, Excel to CI, Security, DMS, Tree Manager, Fluid Pages, PS-Query, Process definitions and Report Manager.

Reporting Tools: PS-Query, SQR, and BI Publisher.

Database Technologies: Oracle,SQL Server 2000/7, Mysql, DB2 8, MS Access, TOAD, Golden, PL-SQL, Putty, PS Data Management tools, Data Mover, BORM model.

Operating Systems: Windows XP/2000/ 95/98, UNIX/LINUX.

Controller Tools: Stat, Phire

Tracking Tools: JIRA, Phire, HP Quality Centre

Microsoft Tools: Visio, Projects, Access, Excel, Word, PowerPoint, Outlook, Publisher, Front Page.

Cloud Applications: ARIBA, Trade Beam, BAM, Oracle Fusion

PROFESSIONAL EXPÉRIENCE:

Confidential, Dublin, CA

Senior PeopleSoft Techno Functional Consultant

Environment: PeopleSoft v9.2, People Tools 8.56, Oracle DB

Responsibilities:

  • Involved in Resolving day-to-day production tickets in HR and Payroll.
  • Involved in integration from PeopleSoft HR to PeopleSoft FSCM using IB messaging.
  • Developed the integration to send employees expense sheets from FSCM to HR payroll system.
  • Involved in fit-gap analysis, compare reports between Cloud HR and PeopleSoft HR system..
  • Upgraded SQR’s, Peoplecode to 9.2 based on 8.0 customizations.
  • Retrofitted HR and Payroll based on new requirements and customizations.
  • Created customized Application Engine programs based on user requirements.
  • Wrote Peoplecode to customize the delivered objects for HR records.
  • Worked on several customs Table Audits and created Test scripts for functional test.
  • Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, Job Code, Deductions and Processes such as Pay sheet creation, PayCalc, Payconfirm, Tax Tables etc.
  • Involved in running weekly and biweekly payroll with functional team and error solving.
  • Involved in sending payroll deduction information to 3rd party vendors.
  • Applied tax updates and Retrofitted customizations after each tax update.
  • Applied ADP patches to PeopleSoft.
  • Involved in adding new pay groups to all the customizations.
  • Wrote custom error messages on Benefits records and pages to hide beneficiary information based on different Plan Types.
  • Retrofitted several views to carry forward 8.8 customizations to 9.0.
  • Developed the application engine to send the payroll data to General ledger.
  • Developed vendor interface to load the vendor information into PeopleSoft received from the external system.
  • Implemented FSCM modules (AP, AM, GL, PO or Expenses) modules.
  • Daily monitor the batch jobs in control-M.
  • Developed the PS query to export the payment and remittance vendor details for audit purpose.
  • Developed the new application engine program to generated automated report if vendor is paying first time in the system.
  • Developed the IB to send the PO, Invoice and Payment details to ARIBA.
  • Developed the IB to send the expense sheets to payroll.
  • Worked Application Engine, People Code, SQR, Process Scheduler, PS Security and PS Query.
  • Worked Procure to pay cycle and basic accounting concepts.
  • Developed application engine program to load the PO’s and invoices into PeopleSoft system.
  • Worked on month end closer activities.
  • Developed the reports to do the reconciliation between PeopleSoft and external systems.
  • Excellent knowledge in adoc crystal and Nvision reports.

Confidential, New York, NY

Senior PeopleSoft Developer

Environment: PeopleSoft v9.2, People Tools 8.55, Oracle DB

Responsibilities:

  • Analyzed functional requirements and developed technical solutions as needed.
  • Implemented pay check modeling using Employee Self service.
  • Developed new bolt-on page to enroll the employees to send the paycheck to mail box.
  • Developed the Conversion Programs to load the invoices, Assets and Journals into PeopleSoft System.
  • Customized the HR TREE BLD application engine program to display the vacant positions at org chart Viewer.
  • Developed reports using private grids.
  • Modified the application package people code to hide vacant position based upon the custom setup.
  • Developed the custom HIRE pages which will hire the employee after certain approval and load the data into the PeopleSoft JOB, PERSONAL DATA components.
  • Developed maternity forms and bonus confirmation letters.
  • Setup AWE for employee related transactions such as promote, Pay Rate change etc..
  • Designed the custom run control page which is being used to run all custom programs.
  • Wrote the custom application engine to pull employees benefits data to send to vendors.
  • Reapplied the customizations due to customizations were not fitting due to 9.2 changes.
  • Ran compare reports and identified the customizations from the compare report and also performed project migration. Coordinated with testing team to perform Unit and Integration Testing.
  • Applying customizations on the objects in higher version
  • Responsible for retrofit of SQR’s, People Code and Application Engine programs (CEMLI’s)
  • Developed the inbound interface to load the supplier data into PeopleSoft System.
  • Involved to add the assets into PeopleSoft system by using basic add, express add and Excel to CI methods.
  • Did AWE setup for expenses in T&E and voucher approvals in AP.
  • Created new library and updated PC AP TO PC Application engine program and add the newly created library to update the PS PROJ RESOURCE table in projects to resemble the billable T&L rows in the project.
  • Updated CA BI INTFC Application Engine program to create the invoices for credit and debit amounts which were sourced from T&E and AP to Billing.
  • Good knowledge of Support model, Incident management (with SLAs), Problem and Change management, Service Now tool experience.
  • Migrate the PeopleSoft objects using STAT.
  • Interact with Business users, IT SMEs and functional SMEs every day.
  • Developed the interfaces to send the payment files to bank on daily basis.
  • Very strong technical and functional knowledge from P2P-AM-GL cycle.

Confidential, Madison, WI

PeopleSoft FSCM - Techno - Functional Consultant

Environment: PeopleSoft FSCM 9.2, People Tools 8.55, Oracle DB

Responsibilities:

  • Worked on requirements, fit gap, design and configuration of PeopleSoft CM, GL, AR, AP, AM modules.
  • Created technical design document and unit test cases in unit testing Phase.
  • Performed Impact analysis during the Code fixes, so that the fix provided wouldn’t affect the current structure and anywhere else where the objects are being used.
  • Extensively involved in Code Debugging and Code Fixes during the User Acceptance Testing.
  • Modified print paycheck(APY2021) xml publisher report to print the logo and sign on the payment checks.
  • Provided technology estimates for the Change Requests raised by the Business stakeholders.
  • Retrofitted all the objects which are having schema s.
  • Ran compare reports and identified the customizations from the compare report and also performed project migration. Coordinated with testing team to perform Unit and Integration Testing
  • Applying customizations on the objects in higher version
  • Responsible for retrofit of SQR’s, People Code and Application Engine programs (CEMLI’s).
  • Solve the interface related issue - Debugging the SQR and Application Engine Program and Fix the error
  • Involved in the development and customization of on line modifications.
  • Evaluation, customization and setting up of workflow for Journal Entry Approval, Asset Transfers approval and Voucher Approval Processes, Receivable processes.
  • Created and modified several new reports and queries.
  • Solve the interface related issue - Debugging the SQR and Application Engine Program and Fix the error
  • Involved in the development and customization of on line modifications.
  • Generated Crystal reports for updating the status of Order Schedules, for Processing Inbound and Outbound transactions for order, for reporting all contracts and their status.
  • Involved in defining Approval Rule Sets for Purchase Order Approval in PO.
  • Engaged in extensive fit/gap analysis and business process discovery.
  • Retrofitted SQR, Pages and People code objects as per the requirement.

Confidential, New York

PeopleSoft - Technical Consultant

Environment: PeopleSoft 9.1, People Tools 8.53, Oracle DB

Responsibilities:

  • Designed application Engine program to get finance data into HRMS system for employee salary calculation. Customized the People Code for semi manual reconciliation.
  • Configure the Gateway, Node (Local and Remote), messages, Queues, Service operations.
  • Implemented the new Time and labor validations and rules, wrote necessary SQL objects.
  • Troubleshoot the TL TIMEADMIN process and also improved the performance by applying the hints.
  • Developed outbound interface to send employee compensation data to external systems.
  • Developed inbound interface to get the payrate changes from ADP payroll system to PeopleSoft.
  • Worked extensively on SQR in leave system; generated reports based on the functional specification.
  • Developed SQR reports for reconciliation data in GL.
  • Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the company. Implemented People Code for online validations and user interface.
  • Designed, Customized & Tuned Records, Fields, Pages, Menus, Components, SQL Queries, DMS scripts, PS Integration, People Code events, Grids & Scrolls, Cursors & SQLEXEC.
  • Developed and modified various interface SQR programs and reports in HR, Payroll and to meet the business requirements.
  • Supported in Troubleshooting and fixing of batch processes for HR, payroll modules.
  • Worked with Employee Self Service and Manager Self Service Modules.
  • Scheduled and monitored jobs using Process scheduler.
  • Developed application engine program to import the time cards from external systems to process the payroll.
  • Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans.
  • Developed the Conversion Programs to load the invoices, Assets and Journals into PeopleSoft System.
  • Helped modify requisition, PO, voucher and receipt pages so that the asset information flows through correctly from the source systems to the asset management tables
  • Involved in developing Inbound Interfaces customizations in FSCMs GL, ePro, Billing, AP and AR.
  • Involved in month end activities to run the asset depreciation.
  • Created new Bolton pages to create or update the dispute by customer.
  • Developed the new bolt on pages to create credit/ rebill the invoice lines if dispute raised by the customer.

Confidential ;

PeopleSoft HCM - Technical Developer

Environment: PeopleSoft HCM 9.2, People Tools 8.55, Oracle DB

Responsibilities:

  • Understanding the requirements based on the functional design document.
  • Created technical design document and unit test cases in unit testing Phase.
  • Worked on TAM related enhancements like People code changes and page design as per client requirement.
  • Created DMS scripts for TAM related Configuatations.
  • Implemented Candidate Gateway for external Applicants to apply for job posting in the organization.
  • Retrofitted all the objects and modified objects as per requirement.
  • Retrofitted Objects, Records, Pages, Components, People code, AppEngines and AppPackages
  • Cleaned up Portal Objects, deleted and retrofitted objects that have been changed in 9.2
  • Modified Pay related components to customer requirements
  • Worked on enhancements to the Time & Labor related components, and created new components for Time Absence reports
  • Designed and Developed processes for auto enrollment in the Time and Labor system. This was an automatic process, which looked for certain key job elements to segregate time reporters into different groups.
  • Used PeopleSoft delivered Time and Labor rules and also developed Custom Time and Labor rules which included Holiday, Weekly Threshold, Daily Threshold, and Day Breaker Rules.
  • Requirement Gathering for eRecruit, Talent Acquisition, Candidate Gateway.
  • Involved in Setting up Pay Groups, Pay Calendars etc..
  • Responsible for setting up eRecruit, Talent Acquisition, Candidate Gateway for recruiting process.
  • Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
  • Customized components and pages in CoreHR, rmation Pages, JOB Components, made changes to company directory component and modified delivered App Packages.
  • Did setup of AWE for approvals.
  • Developed fluid pages for employees apply leave and to see the paychecks from mobile phones.
  • Worked extensively on ePerformance, worked on conversion of historic Disciplinary Actions, Action and reasons, setting up groups for creating Performance documents for Employees, new hires and students.
  • Set up Core Time and Labor setups, which included Workgroups, Rule Programs, and Value lists. Defined Holiday Schedules, Schedule calendars, TRC Programs and Time periods, which would be used in the Rules.
  • Worked on requirement gathering, Fit Gap Analysis, creating Functional Design Documents for several Complex Custom Rules, which take care of Holiday, Holiday premium, Call Back and Comp Time pay for state employees.
  • Defined Exceptions, PeopleSoft Application Engine sections, Validation criteria, Override reason codes.
  • Set up Calculation Elements, Eligibility rules, Accumulators, Schedules, Absences, Absence approvals and Delegations in Absence Management.
  • Worked on mapping the Time Reporting Codes to Earning Codes created Leave Plans, Benefit Plans as well Benefit Programs.
  • Enrolled Time Reporters into the System. Defined Badge Details, Group .
  • Involved in setting up Row Security Permission Lists for employees enrolled in Time and Labor.
  • Worked on Defining TCD Setup Data, Data Elements to send to a TCD in the PeopleSoft Time and Labor system.
  • Involved in the System Integration and parallel testing of Time Tracking system Interfaces to PeopleSoft like Smart Track systems and Vice versa.

Confidential

PeopleSoft HCM - Technical Developer

Environment: PeopleSoft HCM 9.1, People Tools 8.54, Oracle DB

Responsibilities:

  • Understanding the requirements by studying functional document.
  • Worked on core hr to develop the data conversion programs for core HR Components.
  • Implemented ESS and MSS for view/update and pay/absence related requests.
  • Having good knowledge in translation framework to developing PeopleSoft application in their country local language for users.
  • Handling integrations between N/A Payroll, T&L, and Core HR modules of People soft HCM 9.0 to AP, PC, Staffing, and GL of FSCM 9.0.
  • Provided People soft Security by creating Permission list, Roles for various users. Development of Iscripts and Security setups for the content.(Data Security)
  • Implemented ePerformance for employees to maintain performance documents for year end and midyear appraisal cycle.
  • Implemented approval workflow to approve the employee performance documents.
  • Developed New Application Engine programs for Data Conversion, Data Scrambling and Translation Framework.
  • Having good knowledge in Creating CSR to migrate the project from Source instance to Target Instance.
  • Developed new component interface and file layout for data conversion.
  • Played key role in Time & Labor and Payroll setup table design. Ensured that setup tables were configured and maintained per business requirements and trouble-shoot set up table configuration to ensure that design meets business requirements and performing quality assurance testing.
  • Configured Time Reporting Code, TRC Program, Workgroup, Override Reason Code, Task Template, Task Profile, Task Group, Schedules, Value List & Security Groups.
  • Maintain/add Time Reporting and Earnings Codes as needed; updates TRC Programs and maps the TRCs to the appropriate earning codes.

Confidential, Memphis, TN

PeopleSoft - Technical Developer

Environment: PeopleSoft 9.1, People Tools 8.53, Oracle DB

Responsibilities:

  • Worked on Integration Broker created XML Messages related to FSCM. Defined the Message Application, Message Nodes, Message Channel, and Messages. Added People Code for Publishing and Subscription and Specified the Channel Routing. Implemented and tested people soft delivered EIP in FSCM.
  • Implemented People soft EIP between CRM8.9 and Financials/SCM 8.8. Worked on Integration broker, created XML messages and wrote People Code to process response. Customer Sync, Product Sync, Order and Order Status EIP Messages.
  • Implemented People soft EIP between CRM8.9 and Financials/SCM 8.8. Worked on Integration broker. Customer Sync, Product Sync, Order and Order Status EIP
  • Configured the Integration Broker for the People Tools 8.45, and worked on both the Inbound and outbound Application Messaging. Created XML & Soap messages
  • Developed New Application Engine programs to write the un posted journals and error journals details to file.
  • Understanding the process flow of UNIX shell scripting and modified script based on client requirement.
  • Analyze existing Cobol programs and developed new application engine and sqr program in PeopleSoft instance.
  • Worked with the business team to gather requirements, proposed design solutions, and prepared design documentation. Also implemented customizations to speed up the entry of transactional data. As a result, the client gained measurable increases in productivity
  • Designed People soft objects such as Pages, Component, Menu, Record and wrote People Code at all events of Record and Component Record level. Customized translate values, modifying People Code, adding fields to pages and modifying Components and menus.
  • Supported the multiple testing tracks, prepared summary of test results as well as involved in troubleshooting issues uncovered.
  • Solve the interface related issue - Debugging the SQR and Application Engine Program and Fix the error
  • Involved in the modification of pages/components and validating the data fields using People Code.
  • Extensively used PS Query to develop various queries based on User requirements.
  • Performed People Code and Component Interface troubleshooting.
  • Developed new interface to load transactions for new bills directly from excel into staging tables and then interfacing them into Projects Interface tables to generate the revenue lines and the new bills.

Confidential, New York

PeopleSoft - Technical Developer

Environment: PeopleSoft HCM 9.0, People Tools 8.52, Oracle DB

Responsibilities:

  • Worked extensively in analyzing, designing and developing Interfaces, Custom reports HR, Payroll and Time & Labor modules.
  • Worked on ePerformance Setup, Setting up Self Service Transactions, Direct Reports To, Emil notifications, rating Models, competencies. Creating performance documents.
  • Worked in HR and self service modules to add a custom page to give users access to add their Military Status.
  • Modified HRIS reporting data to accommodate the new reporting changes sent to the State Comptroller
  • Created an App Engine program to send Employee data file and Payroll Data file, new interfaces to send ACA (Affordable care act ) related information
  • Worked on Pay sheet creation, Payroll calculation and Payroll confirmation for newly added Biweekly employees.
  • Developed a series of Workflows to send an email and work list to appropriate roles on the event of Hire to employees using Approval Workflow Engine.
  • Worked in creating reported time tables to fix production issues
  • Created reports to generate Audit reports from Time reports and Time Audit table.
  • Tested payroll process end-to-end for yearend processing.
  • Designed and developed the efforts to move 3000+ employees from legacy to PeopleSoft system, setup payroll and benefits configuration.
  • Customized the delivered Component Interfaces CI PERSONAL DATA, CI JOB DATA CWR to migrate Contingent Workers to PS.
  • Designed and developed Application Package to transfer employee information to update into a custom table at real time.
  • Setup Paygroups and configured payroll.
  • Designed and Developed Application Engine process for Employee Basic Sync.
  • Analysis, design, coordinating with onsite for coding and unit testing of enhancements/bug-fixes
  • Involved in decreasing the defects during SIT/UAT Phase.
  • Created bolt-on page to maintain the DB link between HCM and EPM.
  • Accepted several Change Requests and delivered on time.
  • Involved in the preparation of Technical Design Document and Test Cases.

Confidential

Technical Developer

Environment: PeopleSoft HCM 9.0, People Tools 8.52, Oracle DB

Responsibilities:

  • Analysis of functional document and preparation of Technical Design Document and Test Cases.
  • Coding for new interfaces and enhancements process using SQR, Application Engine,
  • Component Interface, File Layout and Process Scheduler.
  • Created new online objects like records, pages, components for Workforce Administration
  • Module for conversion.
  • Implemented security for access the components and pages based on roles and permission list.
  • Help the team in arranging the projects documents like, BRD, TDD, FDD, Check lists.
  • Prepared unit test cases during the unit testing phase.
  • Created new roles and permission list as per the requirement.
  • Provided the access to the newly developed components as per the requirement.
  • Creation of PeopleSoft objects like Fields, Records, Pages, and Components as per the requirement.
  • Involved in retrofitting the Fields, Records, Pages, Components, Record field People Code,
  • Component People Code, SQRs, Application Engine Programs and other objects.
  • Developed and modified the SQRs, App Engines and PS Queries as per the new functional requirements and ensures timely delivery.

Hire Now