SUMMARY:

• Over ten years of experience in software analysis, design, development and implementation of large applications
• Over ten years of experience in PeopleSoft 7.5/8.0/8.4/8.8/8.9/9.0/9.1 development, Customization, Upgrade, and Production Support
• Experience in PeopleSoft Financials (GL, AR, BI, AP, AM, Grants, CA, PC, TR, CM), SCM (PO, E - Procurement, INV, OM), HCM (HR, Payroll, Benefits, T&L,TAM), ELM, EPM (Budgeting)
• Hands on experience in designing the Technical specifications for Data mapping, conversions and interfaces
• Proficient in gathering and analyzing requirements to successfully design applications based on user needs
• Excellent experience with Implementation, Upgrade, and Production Support
• Proficient in all phases of the systems development lifecycle, including requirements Definition, Data Conversion, System Implementation, System Testing, and Acceptance
• Expert in reporting tools like PS Query, Crystal reports, SQR, XML Publisher and nVision
• Knowledgeable in service oriented Architecture (SOA) and BPEL concepts
• Skilled with Application Designer, Application Engine, Approval Workflow Engine, PeopleCode, SQR, Integration Broker, XML Publisher, Component Interface and File layout objects
• Excellent experience in PeopleSoft Reporting and decision supporting tools
• Excellent oral/written communication skills and a good team player

TECHNICAL SKILLS:

Software: ERP, PeopleSoft 7.5/8.0/8.4/8.8/8.9/9.0/9.1 (FSCM and EPM)

Tools: PeopleTools 7.5/8.44/8.46/8.47/8.49/8.51 - PeopleCode, Application Designer, Application Upgrade, Application Engine, Data Mover, SOA, Process Scheduler, PS/Query, Crystal Reports, Security Administrator, Utilities, nVision, Workflow, Application Messaging, Component Interface, XML Publisher, STAT 5.5

Databases: MS SQL Server, Oracle, DB2

Reporting Tools: SQR, Crystal Reports 8.5, n/Vision

Operating Systems: UNIX, Win NT

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. PeopleSoft Technical Developer (Consultant)

Responsibilities:

• Involved in designing technical specifications for various interfaces and enhancements in HR, Benefits, Payroll, ELM modules during the implementation of HCM 9.1 and ELM 9.1
• Designed and developed a bolt on customization to enable the employees to enroll in PTO Sell, in addition to the two delivered options.
• Designed an interface to load the 403b and 457b benefits plan data from fidelity into PS savings plan table.
• Designed and developed a Bolton solution for entering and maintaining the employee bus pass and parking card information which is offered as a benefit at TMHS
• Designed an interface to send employee course completion data from PS ELM to a third party vendor system
• Designed an interface to load volunteer person data from a third party system VSys one into PS ELM.
• Designed an interface to send employees’ job change information, newly created departments and newly created positions to CE Direct.
• Developed a custom Time & Labor rule to validate duplicate assignment codes reported for the same amount of time under same time reporting code.
• Defined and built Work Schedules by creating Shifts, Workdays, and Template Definitions for Biweekly employees.
• Developed custom Time & Labor Queries to enable Functional users to identify specific employees.
• Worked on the interface of Payroll with Time & Labor for calculating Payables Time.
• Designed and developed a customization to provide an attachment feature to the users when they go for a name change. Also the customization involves name change workflow to enable the management to view the attached supporting documents for name change request.
• Designed and developed bi-directional interfaces to exchange premium, billing and eligibility data to and from benefits to a third party vendor called You Decide.
• Designed and developed an enhancement in Benefits module to add the Spousal Surcharge feature to the delivered spouse enrollment in medical coverage functionality.
• Unit tested and system tested all the developed processes.

Environment: PeopleSoft HCM 9.1 (HR, Benefits, Payroll, T&L, ELM), PeopleTools 8.52, PS Query, Peoplecode, Application Engine, Integration Broker, Application Packages, SQR, XMLP, nvision, Oracle 11g

Confidential, Houston, TX

Sr. PeopleSoft Technical Developer (Consultant)

Responsibilities:

• Involved in fixing several defects during the functional and user acceptance testing during the implementation of FSCM 9.1
• Worked on customizing the AP cost collect process in Grants module to not include the billable transactions to be billed if the vouchers were not paid
• Created a SQR report to generate project detail report based on the requirements
• Converted a PS Query into SQR report to generate PO open orders report
• Used Financial Gateway EIPs for integrating bank files with BOFA and Wells Fargo with MDACC PS system in Treasury module.
• Involved in customization of Reconciliation and Statement Accounting process in Cash Management.
• Developed additional features like Cash Position Analysis Worksheet, Bank Fee Analysis & Error report, Letter of Credit and Deal capture.
• Gained knowledge in Setup of Market Rates Process, Facilities and Settlement Manger for Deals in Deal Management.
• Modified delivered App package peoplecode to fix an issue in Accounts Payable to include “check” payment vendors in the prompt table of a field in the pmynt vchr xref record
• Debugged the PC WRAPPER App Engine program to find out the root cause for the unique constraint error

Environment: PeopleSoft FSCM 9.1 (AP, PO, Grants, GL, AR, BI, CA, PC, TR, CM), PeopleTools 8.51, SQR, PS Query, Peoplecode, Application Engine, Integration Broker, Application Packages, SQR, XMLP, nVision, Oracle 11g

Confidential, Winston - Salem, NC

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Gather and analyze functional requirements for the upgrade of the University and the Hospital PeopleSoft systems
• Work on conversion of Financials and HCM data into a merged instance
• Create interfaces to EPIC Health system from FSCM and HCM
• Retrofitting PeopleCode, components and pages in Grants module as a part of the upgrade
• Converting HR, Payroll, TAM data from the Hospital database into merged database
• Converting AP, AR, GL, BI, Grants, PC data into merged database

Environment: PeopleSoft FSCM/HCM 9.1 (AP, PO, Grants, GL, AR, BI, HR, Payroll, T&L,TAM), PeopleTools 8.51, PeopleCode, Application Engine, Integration Broker, Application Packages, SQR, Oracle 11g

Confidential, Cleveland, OH

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in gathering and analyzing business requirements for the conversion of HR, Payroll, Time and Labor data for the newly acquired banks
• Worked on data mapping for core tables PS Names, PS Addresses, PS Job, PS Personal Data, PS Earnings Bal, PS Tax Balances tables and generated reports by Pay Group, Run ID in Payroll module
• Developed Payroll data conversion for Employee tax data, general deduction data for employees
• Performed design of reports for HR, Payroll and Benefits modules using SQR, PS/Query based on organizational needs

Environment: PeopleSoft HCM 8.9 (Payroll, HR, Benefits and T&L), People Tools 8.49, PeopleCode, Application Engine, Integration Broker, Application Packages, SQR, Oracle 11g

Confidential, Houston, TX

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in analysis of business requirements with users and functional team for required setup for PeopleSoft GL Journal Approval Workflow implementation
• Designed and developed custom Journal entry Approval Workflow in GL
• Developed business process, approval rule sets and activity maps as per the requirements of the JE Workflow
• Developed an application engine program to validate the journal and route it to the appropriate workflow based on the chart fields
• Customized the delivered Journal Edit application engine program to call the workflow program for online and import source types
• Developed a component interface to invoke from the application engine to trigger the workflow PeopleCode in the component
• Customized the workflow approval Status history page as per the requirements
• Wrote complex PeopleCode at various levels of records and pages to meet the workflow requirements and validations

Environment: PeopleSoft FSCM 9.0 (AP, GL, Treasury, AM, PO), People Tools 8.49, PeopleCode, Application Engine, Integration Broker, Approval Workflow Engine, Application Packages, SQR, Oracle 11g

Confidential, Austin, TX

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in analysis of business requirements with users and functional team for required setup for PeopleSoft Procurement contracts Workflow implementation
• Designed and developed custom Contract Approval Workflow in PO
• Developed business process and activity maps as per the requirements of the Procurement contracts workflow
• Developed an application engine program send the escalation notifications to the supervisors
• Developed an application engine program to send daily reminder emails to the approvers with pending approvals in the workflow
• Developed a workflow approval status history page as per the requirements
• Designed custom recall and reassign functionalities using PeopleCode as per the business requirements
• Wrote complex PeopleCode at various levels of records and pages to meet the workflow requirements and validations

Environment: PeopleSoft FSCM 9.0 (AP, PO), People Tools 8.49, PeopleCode, Application Engine, Integration Broker, Approval Workflow Engine, Application Packages, SQR, SOA, Oracle 11g

Confidential, Houston, TX

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in production support on AP, PO, E-Pro, GL, PC, AM, TR, CM, AR and BI modules after upgrade to PS 9.0
• Built custom page to allow the requestor to submit a SQL script online and go through the approval process to be executed online; used App designer and complex PeopleCode to design and develop
• Solved an issue where inventory items are missing during the ITM LOAD process from a third party system
• Resolved a trouble ticket to associate a receiver to a matched voucher
• Developed custom page to validate a GL Combo edit string from a third party system
• Involved in retrofitting several application packages, pages, PeopleCode and app engines as a part of the application of bundles 25-30 to the PeopleTools v8.49
• Worked on customizing the Treasury module App package TR FORMAT according to the business requirements
• Customized PMT DISPATCH application engine in Cash Management as a part of the bundles
• Modified custom SQRs to generate the project information which was posted to GL; the programs involve complex logic to extract the data from tables like JRNL LN, PROJ RESOURCE
• Interacted with business users on various production issues
• Developed a process to reconcile the AP invoices with ImageNow
• Developed several SQL scripts to solve several AP and PO related data issues
• Debug AP VCHRBLD and AP PSTVCHR App Engine processes
• Designed and developed E-Procurement Requisition Approval Workflow process that provides different levels of approvals
• Worked on resolving several AR, BI and AM production issues

Environment: PeopleSoft FSCM 9.0 (AP, PO, E-Procurement, GL, PC, AM, TR, CM, AR and BI), People Tools 8.49, PeopleCode, Application Engine, Integration Broker, Approval Workflow Engine, Application Packages, SQR, SOA, Oracle 11g, NT, STAT 5.5

Confidential, Madison, WI

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in production support on AP, EX, GL and Grants modules for 26 universities across the state of Wisconsin as a part of UWS
• Developed an online page and component to allow users to update Fiscal Year Edit Rule Table in GL
• Developed an application engine to create a flat file that will contain the data to be sent to DOA via FTP in GL
• Involved in analyzing and supporting the GL module business structure during the implementation of HCM
• Wrote the technical specs for converting and interfacing the GL Chart field to HCM for 23 Universities/ Colleges across the state
• Designed and setup the GL Chart field full syncs and incremental syncs interfacing using Integration Broker to HCM
• Involved in designing technical specs to integrate Vendor information from HCM to AP using Vendor Sync functionality
• Wrote a technical spec for a process to enable the payment of non-deferred deductions in HR Payroll to be run through AP module
• Developed an interface between HCM and AP for voucher load for vendor trailer payments using the delivered AP Voucher Sync process
• Involved in customizing the PeopleSoft delivered Credit card transaction load data Application Engine from US Bank EX PUB USB, to define the cards for the employees and perform validations in Expenses module

Environment: PeopleSoft FSCM 8.9 (AP, EX, PO, Grants), People Tools 8.48, PeopleCode, Application Engine, Integration Broker, Workflow, Application Packages, SQR, Oracle 10g, NT, STAT 5.5

Confidential, Athens, GA

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in production support on AP, PO, E-Procurement, GL, KK, and Grants modules for 33 universities across the state of Georgia as a part of USG
• Involved in building a custom query to allow users to reconcile AP and GL when the vouchers are mistakenly posted to a different account instead of an accrual account
• Resolved an AP issue where the vouchers are showing as budget exceptions in commitment control
• Involved in solving a ticket where a 1099 vendor was paid in partial and the IRS payment was not processed
• Fixed a problem in AP where a check in the Bank statement register is not reconciling with the payment table
• Involved in release testing of custom SQRs which will allow the users to generate salary and Travel report of the employees in AP and EX to the State Auditors

Environment: PeopleSoft FSCM 8.9 (AP, TR, CM, PO, E Procurement, Grants, GL, KK), People Tools 8.48, PeopleCode, Application Engine, Integration Broker, Workflow, Application Packages, SQR, Oracle 10g, NT

Confidential, San Antonio, TX

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in Re-implementation and production support on GL, AP, PO, Projects, AR, BI and E-Pro modules
• Involved in configuring 445 accounting calendar and year-end close plan for GL
• Solved a ticket related to Journal posting incorrectly to the ACTUALS Ledger
• Worked on the Expenses side of Projects for expenses to flow into projects for approvals by project managers and then notifying General ledger of the same
• Involved in solving several AP issues related to pay cycle, matching, vendor bank setup
• Modified PO SQR POPO005 to change the logo of the company from Confidential Assessment to Confidential after the acquisition
• Involved in configuring E-Procurement Requisition Approval workflow based on the Cost Center, Commodity Code, monetary amount levels
• Involved in set up of Integration Broker to integrate with vendors for the Direct connect Punch-out functionality in E-Pro for Staples, Lenovo and other vendors
• Involved in solving several AP issues related to pay cycle, matching, vendor bank setup
• Developed custom App engine process to invoke created XMLP Definitions
• Involved in extracting data in AP for payment history, 1099 Paid invoices, and active vendors as a part of conversions
• Involved in fixing the MICR font issue on AP checks when the bank started to reject the checks
• Modified AP check print crystal report to change the signature and logo of the company from Confidential Assessment to Confidential after the acquisition
• Involved in fixing the Matching error caused due to unverified control group in AP

Environment: PeopleSoft FSCM 7.5/9.0 (AP, PO, GL, E-Procurement, PC, AR, BI), People Tools 8.49, PeopleCode, Application Engine, SQR, Integration Broker, component Interface, Workflow, Crystal Reports, PS Query, XML Publisher, Cognos 8.0, Mercury Load Runner, Oracle 9i, UNIX

Confidential, Atlanta, GA

PeopleSoft Techno-functional Lead

Responsibilities:

• Involved in analysis of business requirements with users and functional team for required setup for PeopleSoft AP, PO, E-Procurement implementation
• Involved with functional team to gather specifications and information in designing conversions, interfaces and Workflow
• Involved in configuring E-Procurement Requisition Approval workflow based on the Cost Center, Commodity Code, monetary amount levels
• Involved in set up of Integration Broker to integrate with vendors for the Direct connect Punchout functionality in E-Procurement for Staples, Lenovo and other vendors
• Involved in developing Purchasing Workflow if the PO has changed more than 10% using Activities, Business Processes and Workflow PeopleCode
• Modified PV DC POSR Application Engine to change the XSLT action to meet Lenovo’s cXML requirements
• Involved in modifying Application Package PeopleCode to transform the CXML containing Punchout order items in PeopleSoft PV DC ITEMS Message
• Involved in Activating Application Messages like PV DC CONNECT REQST, PV DC CONNECT RESP, PV ORDER and Message channels like PV DC, PV MS ORD DISPATCH
• Involved in defining nodes for each vendor to allow punch-out and electronic PO dispatch and setting up relationships for synchronous and asynchronous transactions

Environment: PeopleSoft FSCM 8.8 (AP, PO, E Procurement), People Tools 8.46/8.47, PeopleCode, Application Engine, Integration Broker, Workflow, Application Packages, Tree Manager, SQL Server, NT, IBM WebSphere

Confidential, Charlotte, NC

PeopleSoft Technical Consultant

Responsibilities:

• Involved in converting the newly acquired power plants data into the PeopleSoft
• Involved in setting up LDAP Authentication to allow users to log into PeopleSoft using their network accounts
• Configured the MSAD directory using the PeopleSoft Security pages
• Involved in activating the LDAP Authentication Sign-on PeopleCode
• Involved in setting up Authentication Maps and User Profile Maps as a part of LDAP configuration

Environment: PeopleSoft FIN/SCM 8.9 (GL, AM, Cash Management), People Tools 8.46/8.47, PeopleCode, Application Engine, Component Interface, SQR, SQL Server, NT

Confidential, Tallahassee, FL

PeopleSoft Technical Lead

Responsibilities:

• Involved in analysis of business requirements with users and functional team for required setup of Budgeting custom module in PeopleSoft
• Involved with functional team to gather specifications and information in designing pages, interfaces and reports for the Budgeting sub module
• Designed and created Security roles, permission lists and user profiles for the Budget coordinator, Budget Preparer and Budget Analyst
• Designed and developed configuration pages for both E&G and Non E&G Budgets to set up and configure the Budget transaction pages
• Created custom Budgets staging tables for Beginning Balance, Revenue, Operating Expenditures, Non-Operating Expenditures, Allocation and Distribution and Search Views and derived work records as per the requirements
• Developed Application Engine to load the History Budget data from PS LEDGER BUDG for the NON E&G Budgets based on the configuration data
• Developed Application Engine to load all the School - Fund Combos in to the E&G staging tables
• Developed an Application Engine to extract the Budget request from PS LEDGER BUDG and send the file to DCU
• Good Understanding of the tables accessed and updated by the Grants processes
• Involved in analyzing the compare reports during the upgrade project
• Involved in Retrofitting SQRs during the upgrade from PeopleSoft 8.4 to PeopleSoft 8.9

Environment: PeopleSoft FIN/EPM 8.4/8.9 (GL, Budgeting, Projects, Grants, Contracts, EPM), People Tools 8.46/8.47, PeopleCode, Application Engine, Integration broker, Component Interface, SQR, Crystal Reports 8.5, PS Query, STAT 5.0.3, DB2, UNIX