We provide IT Staff Augmentation Services!

Peoplesoft Technical Developer Resume

5.00/5 (Submit Your Rating)

Tampa, FL

SUMMARY

  • Appreciated for good work at Peoplesoft partner Cherryroad Technologies for Confidential Project.
  • Commendations Received at Confidential Customer satisfaction survey.
  • Have worked in projects for State Government, Public Sector, Banking, Consulting, Telecom and University.
  • Underwent corporate PeopleTools I & II training from Confidential.
  • Worked as Peoplesoft Technical Developer for 12+ Years . Worked extensively in Peoplesoft HRMS, Portal, FSCM, and EPM & CRM.
  • Subject Matter Expert (SME) in People Tools (Application Designer, Component Interfaces, Import Manger, Work - Flow, Data Mover, People Code, Security Administrator, Object Security, PS-Query/Crystal Reports, nVision Drill-down reports, Process Scheduler, Utilities, Application Engine, XML Publisher, Integration Broker and Upgrade Assistant).
  • Development of Peoplesoft for the common RICE (Reports, Interfaces, Conversions, Extensions) objects using combination of People Tools (App Engine, App Designer, Component Interface etc...), SQR, SQL and Crystal Reports.
  • Experience in Testing PeopleSoft Applications by creating Test plans and Test cases, have done Performance Tuning.
  • Good at system proposals, evaluation, analysis, technical specs, coding, testing, UAT and user training.
  • Emphasize enormous on timely delivery of my deliverable. Speed and Quality are my integral skills. Good Team player. Spend time to understand how the team works, and adapt myself so that the team & I can be most productive. Ability to resolve complex technical issues with effective simple solutions.
  • Have been involved in the different phases of Peoplesoft environment namely Implementations, Upgrades and Maintenance (Post-Production Support). Able to predict/rectify the type of complications that may arise.

TECHNICAL SKILLS

Languages: Peoplecode, PL/SQL, SQR, SQL, Java

Modules: HRMS/HCM - (Payroll, Base Benefits, Benefit, Administration, Global Payroll) FSCM - (AP, AR, Billing, PO, GL, aM, Inventory) EPM - (HR-Dashboard, Finance, E-Performance, Star Schema) CRM-Case Management Versions 6.1, 7.51, 8.13, 8.4, 8.8, 8.9 & 9.1

PeopleTools: Application Designer, Component Interfaces, Import Manger, Workflow, Data Mover, Peoplecode, Security Administrator, Object Security, PS-Query/Crystal Reports, nVision Drilldown reports, Process Scheduler, Utilities, Application Engine, XML Publisher, Integration Broker. Database MS SQL 7.x/8.x(2000), Oracle 7.x/8.x/9i/10g, Sybase ASE, IBM DB2, MySQL

Operating Systems: Windows, UNIX and Linux

Servers: Apache, IIS, Java Web Server, IBM Websphere, BEA Weblogic

Testing Tools: HP ALM, iMacros, LoadRunner (partial)

Scripting: PHP, HTML, CSS, JavaScript, SASS, ETL Informatica, Talend, BPM Pega PRPC (only training attended)

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Peoplesoft Technical Developer

Responsibilities:

  • Worked on Peoplesoft Test Framework 8.51
  • Worked on PeopleTools upgrade from 8.49 to 8.51
  • Worked on migration from HP server to Oracle Exadata Appliance.
  • Developed Component Interface based Application Engine programs for loading data into different components.
  • Worked on various enhancements including integration with Java Web Services.
  • Worked on Cyber Ark security integration into Peoplesoft.
  • Worked on project to sync customer data across the company with Peoplesoft.
  • Created many small & large enhancements to Peoplesoft custom/delivered functionality with weekly Production installation.

Environment: PeopleSoft 8.8 CRM, PeopleTools 8.51, Oracle 11.02, Windows, Unix, Data Mover, Component Interface, Integration Broker, SharePoint, SQR, Quest TOAD, Atlassian Github, Quest STAT, Crystal Reports, XML Publisher, Mass Update, nVision, HP ALM, iMacros, MKS Integrity, Clarity, Serena PVcM and PS/Query.

Confidential, Tampa, FL

Peoplesoft Technical Consultant

Responsibilities:

  • Created fit gap analysis between version 8.9 and 9.1, Modules upgraded - Benefits, Payroll, Tax, HR, and Manager/Employee Self Service. Showed all Peoplesoft objects that are getting impacted due to the upgrade. Upgrade time line, costing will be derived from such documents.
  • Created presentation on technical highlights of the new version. Showed the different UI changes to the new version.
  • Showed client use of AWE (Approval Workflow Engine), XML Publisher and New Mass Update and its benefits.
  • Generated scripts for conversion to new environment and different database.
  • New infrastructure requirement discussion held. Clients plans to move databases from Oracle DB to MS-SQL and OS from UNIX to Windows server.
  • Wrote few SQR, Crystal reports based on the new environment.

Environment: PeopleSoft 8.9/9.1 HRMS, PeopleTools 8.49/8.51, Oracle 10g/MS-SQL, Windows, Unix, Data Mover, Component Interface, Integration Broker, SharePoint, SQR, Crystal Reports, AWE, XML Publisher, Mass Update, nVision, HP Quality Center and PS/Query

Confidential, Albany, NY

Peoplesoft Technical Consultant

Responsibilities:

  • Created fit gap analysis between version 8.8 and 9.1, Modules upgraded - AR, AP, GL, PO, INV
  • Did mapping of new records to old / dropped records. Generated compare reports and applied all the People code / object changes in the target environment.
  • Was given the task to upgrade custom Queries, SQR, Application Engine, Record Views, Crystal reports based on the fit gap analysis documents.
  • Ran Peoplesoft delivered conversion Application Engine programs in given sequence. Log files generated where kept in central location for easy reference. Created data maps for data migration/conversion from other database/systems into Peoplesoft.
  • Created new interfaces and UI for bringing in other functionality which were scattered across variety of technologies.
  • Changed all the dropped tables into record view for easy reference later.
  • Wrote new SQR & Crystal reports in different modules. Also created multiple PDF reports from single SQR.

Environment: PeopleSoft 8.8/9.1 FIN, PeopleTools 8.48/8.50, Sybase ASE DB, Windows, Unix, Data Mover, Component Interface, App Package, Integration Broker, sQr, Crystal Reports, nVision, HP Quality Center and PS/Query, Serena Change man, RapidSQL & SQLDBX

Confidential, Richmond, VA

Peoplesoft Technical Consultant

Responsibilities:

  • Created fit gap analysis between version 8.8 and 9.1
  • Converted various Peoplecode functions in Field Formula to App Packages. Modified multiple app packages to fit in custom code.
  • Worked on entirely new workflow in 9.1 for Travel & Expense. Had to modify various parts of the App package to include the custom workflow that was present in 8.8
  • Plugged in new workflow modification for approval for expense to adhere to custom approval. The delivered AWE was customized for this.
  • Fixed issues while the system / UAT testing was being performed.
  • Analyzed and modified SQR to fetch data from modified record structures. Modified Queries used in Crystal Reports to new data structures.
  • As a POC incorporated Google Map API in expense report with Mileage expense, to show in a map the Start and End.
  • Implemented real time Help using the documentation provided by Oracle.
  • As a POC implemented Voltage Security Encryption for Credit card Numbers/SSN. Installed the delivered JAR file in Application Server, opened the required port and created the Peoplecode functions for the same. The functions are for encrypt and decrypt. The functions open a connection to the remote server and generate the encrypted values. Using 3rd party encryption rather than using Peoplesoft delivered allows the same encryption methods for use in non Peoplesoft system

Environment: PeopleSoft 9.1 FIN, PeopleTools 8.50/8.51, Oracle 11g, Windows, Unix, Data Mover, Component Interface, App Package, Integration Broker, SQR, Crystal Reports, nVision, HP Quality Center and PS/Query, Voltage Security

Confidential, Tampa, FL

Peoplesoft Technical Consultant

Responsibilities:

  • Created iScript based screens for online reporting with Java applets Pie-chart and Bar-chart, this reports were for Total Reward Statement.
  • Created new Total Rewards Summary (TRS)Reporting was done for North America operations. Compensation, Payroll, Benefits data was used in preparing the statement. Users can view using portal all the information about their personal income details etc.
  • The work involves preparation of scoping sheet, impact analysis document, fixing the incident, Discussion Document and preparing unit test plans in the relevant versions of PeopleSoft HRMS.
  • Fixed bugs extensively in Administer Training, Workforce Administration and Monitor Workforce. Written people code as per the requirement, on different events to implement the Business rules and validations.
  • Developed SQR’s on “Union Hourly Functionality” in HRMS 8.9 it includes Layoff Roaster Report, Bumping Report, Seniority Report and Recall Roster Report
  • Developed “Component Interfaces” and “Excel Interfaces” for “HR Setup Tables”.
  • Created new Application Engine / SQR programs to load / report against the database. Provided security for objects created.

Environment: P eopleSoft 8.9 HRMS, PeopleTools 8.49, Oracle 10g, Windows, Unix, Data Mover, Component Interface, Integration Broker, SharePoint, SQR, Crystal Reports, nVision, HP Quality Center and PS/Query.

Confidential, Boston MA

Peoplesoft Technical Consultant

Responsibilities:

  • Integrated Peoplesoft with Esker Fax/Mail server with Voice integration. In HR integrated Voice, Fax in Employee Self Service.
  • Extensive use of PeopleTools (Integration broker) and web services.
  • Created new enhancement for status update to Administration users on Messaging while status is in new status of a specified period of time. The application will send an email to concerned persons with the Message id.
  • Created new SQR for new functionality being added. Created new Application engine, Components, Pages, Menus, Component Interfaces, and wrote Peoplecode for making the functional specs to operation.
  • Created reports using Oracle plug-in / XML publisher. These reports where either sent by email, viewed online or sent by Fax using the above Fax integration with Esker.
  • Wrote new application interfaces for bank transactions based on BAI2 specifications for receiving/sending data using secure sockets. This information was required by the PS FIN application.

Environment: PeopleSoft 9.0 Financials/HR, PeopleTools 8.49/8.50, Oracle 10g, Windows, Unix, Data Mover, Component Interface, Integration Broker, SharePoint, SQR, Crystal Reports, nVision, and PS/Query

Confidential, Richmond, VA

Peoplesoft Technical Consultant

Responsibilities:

  • Worked with the end users and gathered information for modification to existing vanilla Travel & Expense module.
  • Created multiple work flows to accommodate the new change. Also updated Portal to reflect this change. Used Integration broker (Message Subscription Peoplecode) for this.
  • Wrote new application interfaces for bank transactions based on BAI2 specifications for receiving/sending data using secure sockets. This information was required by the PS FIN application.
  • C Environment Company Duration Version Designation Responsibilities Environment Company Duration Version Designation Responsibilities reated SQR Reports for the T&E custom module. These reports were used in ESS & MSS.
  • Created inventory items using EDI (This depended on the vendor's IT infrastructure; feeds could be of CSV file, App Messaging etc.)
  • Created Peoplesoft entries using remote activation of Component Interface

Environment: PeopleSoft 8.8 Financials, PeopleTools 8.45, Oracle 10g, Windows, Unix, Data Mover, Component Interface, Integration Broker, Knowledge Link, SQR, Crystal Reports, nVision, and PS/Query and PHIRE Architect Inversion

Confidential, Indianapolis, IN

Peoplesoft Technical Consultant

Responsibilities:

  • Customized record, Queries, Crystal reports definitions and pages of Accounts Payable, purchasing & General Ledger module.
  • Used People Code to implement Business Rules and to validate the data entry process
  • Developed SQR listing of Voucher due Details, Payment Register General Ledger Voucher Details etc.
  • Major work done in Accounts Payable module is the customization of the Pay Cycle process
  • Provided security to the users by writing various Validations through People Code especially in General Ledger module.
  • Developed Workflow for Voucher Approval, Vendor Approval & Pay cycle Approval.
  • Customized voucher posting process (Application Engine) to support mufti-currency validations.
  • Prepared Technical Design Specifications, requirement gathering and giving suggestion to the functional people for the technical scope.
  • Developed Journal Generation error report using Application Engine & SQR for greater performance. It generates multiple reports one for payment & the other for vouchers.
  • Customized Requisition & Purchase Order workflows (Virtual workflows) using PO approval rule set as per the business requirements.
  • Created Process Definitions, Pages, Components, Component Registration (Structure & Content), Records, Fields, PS Jobs, User Profiles, setting rights to Menu Definition.

Environment: PeopleSoft 8.8 Financials, PeopleTools 8.49, Oracle 10g, Windows 2000/NT/ Unix, Data Mover, Component Interface, Integration Broker, MQC (Mercury Quality Center), SQR, Crystal Reports, nVision, and PS/Query

Confidential, Tampa, FL

Peoplesoft Technical Consultant

Responsibilities:

  • Worked in Peoplesoft Best In Class - Country Core project later rechristened to Global Financial Accounting Technology
  • Project involves Data acquisition from various Citibank worldwide locations and consolidating in a single Mart and giving feed to existing different systems. Created complex calendar for usage within the various processes
  • Performed Data archival/conversion using tools like SQR, Application Engine/File Layout, Golden, Talend and ETL (Informatica) from legacy Citibank systems into Peoplesoft ODS Layer.
  • Debugging Peoplecode, SQR, Application Engine, Component Interfaces, SQL using trace and log files.
  • Required to work in strict compliance of Sarbanes-Oxley (SOX) Act.
  • Setting up Budget targets, preparing line-item budgeting, applying allocation for budgeting, and generation of Asset budget. In addition to this created setup for Planning, maintained forecast items and seasonal items and simulating these for different Accounting periods and Fiscal years.
  • Created process to calculate the YTD and the CFWD process in Financials and Management Adjustments.
  • Created control and dependency between various processes to control the flow of data via ETL and the batch.
  • Created Reference data for Dimensions with the concept of Flexible attributes. Flexible attributes gives the benefit of scalability of Dimensions.
  • Created process for Average and Pool process. Also assisted in creation ROMS (Recon Offset

Confidential, Cleveland, OH

Peoplesoft Technical Consultant

Responsibilities:

  • Created and maintained Reference data for Product, state and channel information in PeopleSoft trees including creation of Tree structures and Tree flattened tables for storing flattened tree data.
  • Used Application Engine and File Layout to transfer the data from flat files to PeopleSoft tables. Designed, developed and supported Metadata driven Component Interface tool, which generates file layout and loads data into specified CI. This tool is totally Meta data driven.
  • Used recursive process to update processes based on the Process Monitor end date time Peoplesoft 9.0 Financials EPM, PeopleTools 8.49.07, Oracle 10g (10.2.0.2.0 ), UNIX, Application Engine, Component Interface, SQR, PS Query, Peoplecode, STAT Version Control 5.2.1, MS-Share-point, Serena Team Track

Confidential, Richmond, VA

Peoplesoft Technical Consultant

Responsibilities:

  • Level 3 support for HR-EPM & E-Performance (includes handling Informatica Maps/Workflow, Data loaders, Data mart, Configuration)
  • Created Informatica map & workflow for Acquisition data for Hibernia Bank (from Lawson HCM), Supplier data from the Peoplesoft MSS module.
  • Implemented dynamic logic to run the Data mart for 36 periods.
  • Optimized Data loaders and the Data marts.
  • Implemented logic to automatically extract Action/Action Reason codes from the Action Reason table to the Action Reason map in EPM.
  • Implemented archiving of FACT tables for better performance of Hyperion OLAP reports / Dashboard. Used Informatica to accomplish this. Also used SQR for this purpose.
  • Assisted in troubleshooting any ETL and Data Loader technical related errors.
  • Created data mover scripts to facilitate ease in setting up new environments (test, sandbox, production copy). Provided recommendations on technical architecture of environments and deployment.
  • Created customizations as necessary, per fit-gap and configuration document.
  • Setup and configured metadata including but not limited to: Record Metadata, Table map, Data map, Filter, Constraint, Data Element, Assessment, Target Rules, Strategy, Trees, Scorecards, and Security.
  • Supported and extensive troubleshooting efforts for metadata created many custom allocation rules.
  • Analyzed the PF JOBSTREAM process for choosing the available Record Suites, and incorporated logic to fail the job stream in the event of Record Suites being locked.
  • Enhanced Session Calc data for E-Performance data.
  • Developed customized process scheduler for running batch jobs which could be Perl scripts, Informatica workflows, other 3rd party applications. This provides a complete view of all processing happening in the EPM platform.
Environment: Peoplesoft 8.8 HRMS / Peoplesoft HR EPM, Informatica 6.1, PeopleTools 8.45, Oracle 9i / DB2, UNIX, Application Engine, Component Interface, SQR, PS Query, Peoplecode, STAT Version Control 5.2.1., IBM Rational Clear Quest.

We'd love your feedback!