SUMMARY:

• Senior PeopleSoft consultant with 8.5 years of experience in all stages of Application Development including Business requirements gathering, Development, Implementation, Customizations, Production Support, Interfacing/Reporting and Upgrade in PeopleSoft Financials and HRMS applications.
• Substantial experience in implementing and Customizing modules within PeopleSoft Financials Modules - Accounts Receivable, Accounts Payable, Billing, Purchase Order, General Ledger, eProcurement, and Asset Management modules.
• Good amount of experience in implementing and Customizing HRMS Modules which include - Core HR, Time and Labor, Base Benefits, Benefits Admin, Payroll, eRecruit and Absence Management modules.
• Solid technical skills in the areas of - Application Designer, Application Engine, Component Interface, Data Mover, Peoplecode, Application Packages, Integration Broker, and Workflow developer tools.
• Extensive knowledge and experience developing and customizing of PeopleSoft Reports and Interfaces like SQR, Crystal Reports, n/Vision, PS Query, XML/BI Publisher, and Application Engine.
• Experience in writing PL/SQL queries and have exposure to different databases, includes SQL Server and Oracle.
• Worked in FSCM and HRMS upgrades from 9.1 to 9.2 for two clients.
• Expertise in data Conversions both outbound and inbound with Third party systems using SQR, Application Engine, Component Interface, File Layout, and Excel to CI.
• Good Technical and Functional knowledge of Financials and HRMS Modules.
• Experience in Java integration with PeopleSoft systems.
• Solid in RDBMS application design and development.
• Worked on full length Life-Cycle implementation of PeopleSoft modules.
• Created specifications and programmed interfaces to and from PeopleSoft system to satisfy business requirements.
• Worked intensively with Security Administrator to implement Creating Roles, Permission lists, User Profiles, Portal Security, and Definition Security.
• Demonstrated proficiency in leading several projects as well as mentoring and guiding other team members to maximize productivity and forming cohesive team environment.
• Excellent analytical, communication skills and adapt to new technologies with ability to work as an individual or part of a team.
• Also, worked on Data Conversion, Documentation, End-Users Training, System Integrating, UAT, Mentoring and Knowledge Transfer sessions.

TECHNICAL SKILLS:

PeopleSoft FSCM and HRMS: 9.2, 9.1 and 9.0; Tools Release 8.55, 8.53, 8.52, 8.51, 8.50 and 8.49.

Financials: Accounts Receivable, Accounts Payable, Billing, Purchase Order, General Ledger, eProcurement, and Asset Management modules.

HRMS: Core HR, Time and Labor, Base Benefits, Benefits Admin, Payroll, eRecruit and Absence Management modules.

Databases: Oracle, DB2, SQL Server, SQL Base, and MS Access.

Languages: C, C++, COBOL, VB, HTML, XML, JavaScript, and Java.

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr. PeopleSoft Techno-Functional Consultant

Environment: PeopleSoft: 9.2 and 9.1, PeopleTools 8.55

Responsibilities:

• Principle Developer for Finance upgrade project - from PeopleSoft 9.1 to PeopleSoft 9.2, People Tools .
• Assisting in the initial tools upgrade and patch levels agreed upon by the project team.
• Guided the QA team in defining test conditions & scenarios related to the upgrades and enhancements and coordinated the SIT & UAT's along with issue resolution
• Performed Vanilla Comparison test between our demo database and our copy of production to identify customization and analyzed the reports.
• Worked on upgrading PeopleSoft Accounts Payable & Purchase Order from 9.1 to 9.2 which include Fit-Gap analysis.
• Worked on stabilizing recently installed PeopleSoft 9.2 and Fixed query security issues during the upgrade.
• Worked on converting around 40 Crystal reports to BI publisher reports.
• Designed test plans and test scripts for the seamless integration of Accounts Receivable/Billing/ General Ledger with invoicing application system.
• Tested additional tables to hold billing data received in PeopleSoft from the 2 additional source systems and enhanced the Staging Process (SQR program) and Billing Interface (BIIF0001) according General Ledger.
• Developed PeopleCode to create dynamic grids to populate General Ledger information.
• Customized the enrollment summary pages to include general deductions on to the summary page and printed confirmation statement.
• Worked on SQR related to Employment Self Service pages.
• Modified the outbound interfaces to insurance providers per the requirement.
• Developed Custom tables and pages to setup the benefit plans and coverage codes.
• Designed a custom interface which will accept files from other systems and create Journals into the PeopleSoft General Ledger system.
• Extensive production troubleshooting and tuning duties. Recent examples include creation of Requisition was taking 3-4 minutes and reduced it to 5 secs by tuning some views and making changes on Application server which was blocking access to a site to fetch DTD for xml schema validation for punch out.
• Worked on delivered eProcurement AWE workflow and helped with design and development of custom Voucher workflow.
• Extensively worked on Travel and Expense module by making enhancement to the pages and processes as per the requirements.
• Worked on modifying transformation engine for cXML based punch out and Purchase Order dispatch integration with online catalog and ordering solution (Sciquest). Also, did a proof of concept on Purchase Order Acknowledgement (POA).
• Involved with Request for Proposal (RFE) process when choosing a new Imaging solution.
• Worked on several interfaces to import the journal data from external systems into General Ledger.
• Worked on plan mapping process related to Aetna and UHC.
• Worked on Application Engine programs to figure the issues and add the dependents to the enrollment summary page.
• Wrote Peoplecode to limit the access to Chief Officer Compensation and Bonus data for the Job Data, Pay Rate Change, Current Job, and other related pages.
• Wrote SQL scripts to resolve issues related to 403E50 benefit plan.
• Worked on custom Load Purchase Order and Receipts from Legacy Order management system using Integration broker, Application Engine, and Component Interface. Made modifications on voucher association and costing part of the Three-way match process.
• Worked on several interfaces using Component Interface to load data into HRMS.
• Configured and customized Invoice as Email attachment functionality in Billing.
• Worked on Setting up the core records for Benefit Administration. Records include Benefits Cost Setup, Eligibility Rules, Event Rules, Program Definitions, etc.
• Generated Eligibility reports for various benefit plans showing eligibility of employees for different vendors, employee and employer share, eligibility period, eligibility conditions like service date etc
• Created Application Engine program to generate manual checks. This involved creating a Component Interface to load data in PAYSHEET component.
• Also, done Quality Analysis on various modules like Manager Dashboard, Absence Management, General Ledger, Global Payroll, ESS and MSS after retrofitting is done.
• Worked on Outbound interface related to ACA and developed a App engine program to send the file to deloitte.
• Learned about a new ACA Component Interface (CI ACA ELIGIBILITY) that Oracle is delivering with 9.2, are you delivering an Excel To CI or just the CI ACA ELIGIBILITY.

Confidential, Dallas, TX

Sr. PeopleSoft FSCM and HRMS Consultant

Environment: PeopleSoft: 9.2 and 9.1, PeopleTools 8.55/8.53

Responsibilities:

• Worked on Upgrading PeopleSoft HRMS 9.1 to HRMS 9.2 using Agile Methodology. Project involved in carry forward the customizations done in various modules such as Absence Management, Global Payroll, Employee Self Service, and Manager Self Service.
• Provided consultation on unit and Integration testing in preparation for PeopleSoft HRMS 9.1 to 9.2.
• Extensively utilized Compare reports for retrofitting the application by identifying differences between databases and to also compare the base version with the target version.
• Retrofitted the customized objects, based on the compare report, and analyzed to retain vanilla or to reapply customization.
• Identified the impacted SQR's and SQC's and retrofitted complex custom SQR's and SQC's in preparation for upgrade to 9.2 based on 9.1 customizations.
• Involved in Fit Gap analysis sessions. Analyzed the Compare reports for identifying the customizations and discussed the impact of changes with the functional and technical teams.
• A custom Application Engine was designed to import billing information from a flat file and load it into billing staging tables.
• Created BI Publisher Reports using PS Query, XML as Data Source. Also, converted Crystal reports to BI Publisher reports.
• Created Checks using XML/BI Publisher.
• Created upgrade scripts to overcome data issues encountered during upgrade.
• PeopleSoft application testing after the initial upgrade.
• Supported the issues encountered by interfaces after integrating with Upgraded PeopleSoft HRMS system.
• Modified the existing upgraded SQR to user’s requirement.
• Customized the Billing interface process, Invoice Pre-process and finalize process and Invoice printing process.
• Modified (AR DUNNING) Application Engine in Receivables, to create report of all accounts for which the customers are past due and send them to Collection Processing.
• Designed an interface program to load pending items from a third-party billing legacy system in to PeopleSoft Receivables pending tables.
• Performed problem solving and analysis for PeopleSoft Receivables, Payables, and General Ledger.
• Engaged in daily Accounts Receivable maintenance which included, but was not limited to, application of previously unidentified cash receipts, write-offs, invoice reversals, processing refunds to Primes and to the US Government and application of invoices to each other.
• Created custom bank recon rules, views, and Peoplecode for Semi-Manual Reconciliation of certified deposits in Accounts Receivable.
• Modified delivered customer pages for Accounts Receivable.
• Did fit / gap analysis for integration of Order Management, Inventory and Accounts Receivable and Billing.
• Provided technical and functional support for billing and Accounts Receivable.
• Customized the outbound benefit interface sqr, BEN803.sqr and added a new plan CDHP to send a weekly file to BCBS for them to load enrollments, changes and terminations for eligibility and claims payment.
• Designed and developed a File Attachment Server to attach and review Performance reviews by the employees and Managers from ESS and MSS navigation respectively. This included design and development of the pages, Application engine, CI, and Page People code to manually load or automatically load, view and delete the files.
• Worked on enhancement of Educational assistance and Stock Purchase Plan application. Also, Customized the SPP plan enrollment letter.
• Built an interface for a new provider named UNUM to accept the employee elections from UNUM to be loaded into PeopleSoft general deductions.
• Customized the Benefit enrollment letter for terminated employees.
• Identified & written custom scripts to enable users to specify which ABBR to use for a Benefit Plan. (Multiple Annual Base Benefit Rates).
• Developed an Application Engine Program which fetches data from PS EMPLOYEES table based on paygroup criteria and send email.
• Resolved issues regarding Leave Accrual and customized the Time Reporting page
• Provided Production support after the upgrade and resolved issues pertaining to Security and Customizations.
• Debugged the Open Enrollment Process to figure out the Issues pertaining to multiple benefit programs being offered.
• Wrote PeopleCode to limit the access to Chief Officer Compensation and Bonus data for the Job Data, Pay Rate Change, Current Job, and other related pages.
• Wrote SQL scripts to resolve issues related to 403E50 benefit plan.
• Generated a process to create interface between Benefits and Time and Labor which compares employee's leaves recorded in Time and Labor against the allowed leaves; this process is used as an alternative to the existing Payroll feature, which calculates the Leave Accruals.
• Involved Data conversion tuning and Performance tuning of various SQR’s and Queries that were taking too long after the upgrade.

Confidential, Atlanta, GA

Sr. PeopleSoft Techno-Functional Consultant.

Environment: PeopleSoft: 9.1, PeopleTools 8.48

Responsibilities:

• System analysis and design of interface for Purchase Order and receipts into PS from OMS.
• Involved in designing/developing and deployed multiple SOA SOAP Integrations from PeopleSoft to third party systems.
• Designed and developed Integration broker interfaces for Inbound/outbound interfaces.
• Worked on custom Load Purchase Order and Receipts from Legacy Order management system using Integration broker, Application Engine, and Component Interface. Made modifications on voucher association and costing part of the Three-way match process.
• Developed online Pages, Components, Search Records, Menus, Folders and online PeopleCode to Update and deleted error interface data from OMS.
• Developed Online page, Component, and Search Record for changing the status of a Cancelled Purchase Order to allow users edit data once the Purchase Order is cancelled.
• Gathering requirements for Intransit/Reverse Intransit report.
• Modified Application Engine program to create an In-transit/Reverse In-transit report to calculate balances for month end reporting purposes.
• Created new matching rules for matching process in Accounts Payable
• Created/Updated the customized costing functionality in Accounts Payable to cost goods based on Purchase Order price or Invoice Price and sends the costing information to OMS by developing online pages, components, and Application engine programs.
• Developed Application engine program to search thru XML files for a Purchase Order or receipt in each date range as manually searching thru over 5,000 XML pages online was taking too long. Developed Run control tables, Pages for running it online.
• Customized PeopleSoft workflow for match exceptions. Customized the workflow so that distribution center routs matching exceptions. For this changed the work list record to meet the specifications. Modified the workflow Application EngineMTCH ERR WF to route the exceptions by distribution center for pricing and quantity exceptions and route the system exceptions to the super users.
• Worked on issues relating to nightly batch as part of off hours Production support.
• Involved in redesign of nightly batch.
• Developed numerous PeopleSoft queries for user community.
• Worked on PeopleSoft conversion and interface data from 8.8 to 9.1 for Accounts Payable as part of GPC1 project.
• Modified the Attorney Data Page to accomdate tracking and reporting .
• Wrote Peoplecode to accomdate the various changes for the Self Service Pages required by the client.
• Created various Permission lists, Users Roles and assigned roles to Users.
• Configure Absence Elements i.e. Entitlement, Takes & Creating Formulas According the needs of Organization.
• Worked on most critical issues such as Absence Management Balances, Multiple jobs .
• Managing absence event, take, adjustment and entitlement. Integration with payroll system.
• Having good experience managing time and labor like report time, create schedules, organize employee groups , approve time.
• Involved in the Absence Management implementation as a technical consultant .
• Responsible for designing and developing Aetna Eligibility and security interfaces using application engine program. These Interfaces send the FMLA, STD & LTD data, security level data of the qualified employees to Aetna.
• Created a Component Interface for the employee absence balance conversion from the existing TOPS system to PeopleSoft absence management system to load the time, carryover and other balances into the positive input table.
• Created a custom component, page, record and peoplecode in the employee self-service and manager self-service portals to show the current absence balance summary for the time and miscellaneous absence types.
• Created a custom component, page, record in the manager self-service portals for miscellaneous absence type's entitlement and used peoplecode to implement business rules such as sending emails.

Confidential, Atlanta, GA

Sr. Technical PeopleSoft Developer

Environment: PeopleSoft: 9.1, PeopleTools 8.48

Responsibilities:

• Worked extensively on Evaluation, Data Mapping, and Conversion of data from the legacy system to FSCM 9.1
• Worked on integrating billing information from Alliance, GCOM to Billing.
• Worked on interface programs when BOSS (Order Management system) is replaced with WIN.
• Worked extensively on gathering requirements to integrate Alliance into PeopleSoft.
• Loaded open items in Accounts Receivable from Alliance into PeopleSoft Accounts Receivable.
• Loaded Journal entries from Alliance into PeopleSoft General Ledger.
• Worked on setting up new business units in Accounts Receivable, Billing, and General Ledger for Alliance integration.
• Wrote Application Engine programs to export from PeopleSoft Purchase Order and Asset Management to LanDesk. Import premature retirement date from LanDesk to PeopleSoft.
• Interface New Confidential sites into PeopleSoft. Fetch Billing and customer data from Luxemburg and load into PeopleSoft Billing to be processed to General Ledger.
• Customized the BIIF0001 Application Engine program to meet Confidential billing process for interface loads.
• Customized AR STMTS Application Engine program per Confidential specifications.
• Designed and developed Voucher and General Ledger integration broker interfaces using service operations, app messages, app packages and PeopleCode.
• Involved in major clean-up of Billing, Accounts Receivable module which was caused when inter unit accounts were changed.
• Worked on Integration Broker Messaging, process monitor issues.
• Training end users on using the PeopleSoft system.
• Support LANDesk application in creating new reports and LanDesk administration.
• Implement Integration Broker setup which involved in enabling Publish and Subscribe services between cross platform PeopleSoft applications.
• Developed Queries, XML Publisher reports which identify employees with no managers, employee’s reporting to vacant position, track employee supervisor.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits, and Payroll Modules.
• Generated SQR repots to create Employee Data file which is sent to Finance system along with Payroll Data with CFT transfer Protocol.
• Worked on adding a person, job data, Creating Pay Calendar, Processing Payroll and reviewing Pay Check and solving the errors messages during the process of Payroll.
• Estimate, plan, assign, assist and track development specific to Core HR and NA Payroll.
• Involved in Payroll Processing and have working knowledge on tables like PAY TAX, PAY CALENDER, PAY CHECK, PAY EARNINGS, PAY DEDUCTIONS, etc.
• Involved in Auditing and troubleshooting SQR's like PAY034, PAY035, PAY036, PAY011 and PAY General Ledger01 and also build customized audit scripts.
• Involved in developing the SQRs for benefits out bound interfaces.
• Troubleshooting of COBOL SQL processes like PSPPYBLD, PSPPYRUN, and PSPCNFRM by performing various audits.
• Requirement gathering for Data conversion from Legacy System to PeopleSoft.
• Data analysis in PeopleSoft HRMS and developing reports using PS Query.
• Customized Load Time and Labor Process to Payroll and Pull Cost Process from payroll to Time and Labor to process prior period corrections.
• Involved in running weekly, biweekly, semi-monthly, and monthly payroll with functional team and resolving errors-if any.

Confidential

Sr. Associate PeopleSoft Developer

Environment: PeopleSoft: 9.1/9.0, PeopleTools 8.48/8.49

Responsibilities:

• Interacted with clients for business requirements gathering, prepared functional and technical specification documents.
• Involved in automating the pre-billing processes for multiple customers (Development).
• Involved in Creation/Development and Customization of Records, Pages, Components and Menus, Application Engine processes and File Layouts using Application Designer.
• Wrote PeopleCode for validating the data in the pages and for implementing the functionalities in the Application.
• Involved in the design of Audit functionality to create various records and implemented effectively.
• Read to records and writing to the files by using the File Layout and Application Engine.
• Involved in designing and customizing the reports using the tools PS Query, SQR and XMLP.
• Prepared Unit testing documents, test logs and testing functionality of the reports based on given requirements.
• Lab tested the application by migrating to sample environments.
• Monitored the migration activities during migration to Production.
• Coordinated with users during UAT.
• Implementation of IDM integration with PeopleSoft TAM Candidate Gateway for Job Applicant in is ready to hire, once applicant status got hired personal & job record is created in workforce Admin, Building Key & badge request, Computer access and other onboarding functionality is initiated thru customized IB Message (Web Services) with 3rd party systems.
• Provided Production support for own developed and existing Finance modules like Projects, Billing, Purchase Order etc.,
• Worked on analyzing multiple Billing related delivered and customized SQRs to adopt the same logic in later designed reports.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Mentored the junior resources trained them on PeopleSoft Application Designer, PeopleCode, Application Engine, SQR.
• Expertise in PeopleSoft Security, creating permission lists and roles, assigning them to users.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.
• Conducted training on SQL.
• Acquired knowledge on EXCEL to CI.
• Coordinating with HCM/HRMS team members to solve complex technical issues as and when needed.
• Worked on Unit testing and PeopleSoft HCM/HRMS modules like ESS, Timesheets etc.

Confidential

Junior PeopleSoft Developer

Environment: PeopleSoft: 9.0, PeopleTools 8.45

Responsibilities:

• Main responsibility is to work as a developer handling end-to- end development of critical business requirements.
• Involved in all the stages of Software Development Lifecycle (SDLC) - analysis, design, development, testing.
• Developed online Pages, Components, Search Records, Menus, Folders, and online People Code to Update and deleted error interface data from OMS.
• Modified the Accounts Receivable Dunning Application Engine extract (AR DUNNING), and the Crystal Reports layout, Involved in data mapping between legacy and PeopleSoft Receivables
• Developed conversion programs using AE, Implemented and customized workflow.
• Customized Journal Entry Detail Report, FIN2001 to show correct chart field values.
• Developed custom Application Engine that uses Component Interface to load data into tables and workflow to notify the managers to take proper action in specified time line in Accounts Payable.
• Developed Interface Application Engine program to load Billing Invoice information from a flat file that validates and loads data in to Interface tables.
• Implemented Voucher Upload and Journal upload templates.
• Design and Development of Interface programs for Vendor portal
• Created custom interface to load voucher data in to voucher staging tables from Flat files in Accounts Payable using application engine Preparation of the technical specifications (TS). This involves analysis and design of the system for enhancement or customization.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance.
• Responsible for working with testing team and drive this by providing required technical assistance.
• Worked on PS/Query tool to generate Ad-hoc queries, analyze the query results and to generate SQR reports.
• Developed Reports and interfaces for Benefits Providers using SQR.
• Worked on the Depreciation calculation and accounting entry calculation using SQR.
• Automated the business processes using workflow by creating roles, rules and routings thereby sending the right information to the right person at the right time.
• Reapplied People Code, application engines, sections, actions, People Code, SQL's, Queries, Pages, Components, SQRs and Crystal Reports.
• Developed an Application engine to interface Asset management and General Ledger Module.
• Used Process Scheduler for creating SQR reports for General Ledger reports.
• Involved in developing nVision, Crystal reports for the first time in organization.