SUMMARY:

• Certified Project Management Professional that includes more than 16 years of IT experience in System Analysis, Design, Development and Implementation of various business and client/server applications.
• Experience in PeopleSoft HRMS, ELM & Financials ( 7.5/8.0/8.3/8.4/8.9/9.0/9.1 ). Expertise in Analysis (FIT - GAP), Designs and Development PeopleSoft Financials/Supply Chain Management (Account Payables, Account Receivables, General Ledger, Inventory, Order management, Billing, Purchasing and Asset Management, eSettlements) modules and PeopleSoft HRMS modules like North American Payroll, Time & Labor, Workforce Administration, Talent Acquisition and Candidate Gateway, Base Benefits, Benefits Admin.
• Expertise in PeopleSoft Designing, Development, Implementation, Upgrade, Customization, Maintenance, Interfacing/ Reporting, Data Conversion, Testing and Post production support.
• Expertise in PeopleSoft application development using PeopleTools 8.5x like Application Designer, PeopleCode, Application Engine, PS Query, Application Package, File Layout, Component Interface, Integration Broker and Workflows.
• Technically proficient in report writing using Crystal Reports, nVision and SQR and XMLP.
• Understanding of Object Oriented concepts, Web Services & SOA architecture.
• Experience in PeopleSoft System Administration, Installation and Maintenance of Database, Application and WebLogic Web Server, Directory Interface. Assisted in Upgrading objects using PeopleSoft Change Assistant.
• Expertise in applying Tax updates, patches and bundles as applicable.
• Experience in Datawarehousing using ETI Extract and Business Objects.
• Experienced in preparing Technical and Functional specifications and design documents for Reports, Interfaces and Conversions.
• Expertise in troubleshooting technical and functional issues on various PeopleSoft Platforms.
• Expertise in creating training materials using UPK, assisting business users in testing with automated scripts in QTP.
• Expertise in coordinating with Project Leads and Functional and Technical Team Members to facilitate in time Project Deliverables.
• Strong working knowledge in RDBMS (SQL, PL/SQL), PeopleTools 8.49, Programming proficiency in PeopleCode, SQR, Java, ASP, JavaScript, Java, VB Script, Perl, SQL, PL/SQL SQL*Plus, Oracle BPEL Process Manager.

SKILL:

PeopleSoft Functional Skills: PeopleSoft HRMS (7.5, 8.0, 8.3,8.8, 8.9 & 9.0,9.1): Workforce Administration, NA Payroll, Time & Labor, Base benefits, Benefits Administration, TAM & CG, Employee Self Service, Manager Self Service, e-Performance. PeopleSoft Financials (8.4,9.1) General Ledger, Accounts Payable, Billing, Account Receivables, Asset ManagementInventory, Order management, Purchasing and Asset Management, eSettlements

PeopleTools Application Development & Reporting Using: Application Designer, Application Engine, Application Messaging, Component Interface, PeopleCode, Security, File Layout, Process Scheduler, Data Mover, PeopleSoft Query, SQR, Crystal Reports, Workflow, Integration Broker, SOAP, Web Services, XML, HTTPS, XML Publisher, XSLT

Languages: Java, JavaScript, JSON, JQuery, JSP, VB, VBScript, SQL, UNIX Shell Scripts, PL/SQL, COBOL

Databases: Oracle 8i/9i/10g/11i, Microsoft SQL Server 7.0/6.5, DB2, MS Access.

Microsoft Office: Word, Excel, Outlook, Access, Project, Visio

Operating System: Windows 98/NT/2003, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Erie, PA

PeopleSoft Financial Techno Functional Consultant

Environment: PeopleSoft FSCM 9.1, 9.2 PeopleTools 8.51, 8.55, Application Designer, Oracle 10g, SQL, PL/SQL, SQR, XMLP, PeopleCode, Application Engine, Application Package, Integration broker, Unix Shell Scripts, Oracle 11 g, Harvest Version Control, Change Assistant, AWE

Responsibilities:

• Conducted discovery sessions to understand client's use of current functionality and business processes and demonstrated new GL, AP, AR & BI 9.2 functionality in 9.2 that client can in corporate in current business processes.
• Worked as lead to configure the GL WorkCenter and conducted work sessions regarding for WorkCenter and Dashboard, and Account Reconciliation (GL and Subsystem Account Reconciliation) and overall lead to set standards, training and document WorkCenter standards for all finance modules.
• Conducted "to be" configuration and business process design sessions. Collaborated with sub-modules (Asset Management, Billing, Contracts, Payables, Procurement, Projects, Receivables and Treasury) to discuss, develop and retrofit configuration, modifications and business processes that are shared between GL and the particular sub-module/ system.
• Designed enhanced funds distribution feature in Project Costing that exceeds the functionality delivered in Peoplesoft v9.2.
• Installed and configured Elasticsearch for use with search framework, setup PeopleSoft Update Manager (PUM) images on Oracle Virtualbox Image#23 and also setup PeopleSoft Change Assistant on PeopleTools 8.56 to create/apply the Change Package from Image#23.
• Ran and analyzed multiple SYSAUDIT, DDDAUDIT, ALTER AUDIT and upgrade comparison reports and implemented corrections suggested by the reports.
• Retrofitted all the internal as well as third party custom SQR and Application Engine Interfaces to banks and other vendors related to AP, AR, BI.
• Coordinated and conducted unit, system and user acceptance testing.
• Lead the design, testing, and implementation of the ProShip interface in Inventory. This interface would send the data for orders and MSRs to the ProShip tables during the picking process. Users would scan barcodes in ProShip to print appropriate carrier labels and then the data would be sent back to PeopleSoft Inventory in a depleted status
• Define project scope and objectives in collaboration with Business stakeholders
• Project Plan to include cost, schedule, and resource requirements and review it with key stakeholders to confirm project scope, risks, issues, assumptions and constraints.
• Created various Interfaces from PeopleSoft Financials AP to Ariba which will include Setup/Master data for:
• ChartFields - Accounts, Business Units, Department, Product, Projects and Statistics.
• Account Combination - Highly complex Interface to extract Chartfield combination edits
• Vendor Data - Vendors, Addresses, Vendor Location, Remittance Location.
• Payments - Payment Terms, Payment Term Steps, Payment Term Step Details and Payment Method
• OK2PAY - This is inbound interface will load Payment data into Voucher staging Tables. This interface will have inbuilt logic to determine Sales/Use Tax/ Tax Exempt settings and will read the configuration to impose appropriate tax on Header/Line levels. After this interface has been run, Voucher build will be run to create to create vouchers.
• Email Interface - This interface will read Email ID from LDAP Server using service created.
• Designed and developed online components/pages/records to maintain Ariba User Group and roles.
• Assisted in setting up Ariba ITK to automate the interfacing.
• Created Batch Job to load Ariba eForms payment details in Voucher staging Tables.
• Developed batch job to load remittance information from Ariba to PeopleSoft.
• Developed to several queries to balance Ariba and PeopleSoft on daily basis.
• Design the overall architecture for electronic payments integration with Wells Fargo.
• Responsible for overall setup which will include updating Vendors with new EFT Payment Type,
• Creation of New Pay Cycle to select these vendors, setup EDI Manager.
• Assisted in running 1099 and Year End close.
• Create outbound EDI 4010 file to be sent to Wells Fargo.

Confidential, Pittsburgh, PA

PeopleSoft Techno Functional Consultant

Technology Stack: PeopleSoft FSCM 9.1, PeopleTools 8.51, Application Designer, Oracle 11 i, SQL, PL/SQL, SQR, XMLP, PeopleCode, Application Engine, Application Package, Integration broker, Unix Shell Scripts, Harvest Version Control, Change Assistant

Responsibilities:

• Developed Use Cases for XMLP reports to issue delinquency letters to foreign addresses with logic to modify them based on any federal regulation updates or changes.
• Assisted in setting up Split billing where portion of premium is collected from subscriber and rest is paid off by cost-sharing reduction
• Developed an Functional Specification and use cases for Application Engine Interface which will report discrepancy between expected advance payment of premium tax (APTC) and the actual amount received as indicated by 820.
• Customized the AR Aging Report by Corp Customer, AR unallocated Cash Report, New Customer Report, AR Aging by Collector Crystal and SQR Reports.
• Designed Archiving solution for PeopleSoft Accounts Receivables, Payables & General Ledger to archive 20 M records from Parent and child tables using the PeopleSoft’s Data Archive Manager. Developed custom Archive object definitions, Archive Template and Queries to archive custom Tables. Developed custom application engine which will run after the PSARCHIVE has been run in Selection Mode to update the BatchNum# to the latest as assigned in the History Table so that the corresponding rows are deleted from the Online Tables when run in the Delete Mode.
• Responsible for 24x7 technical Production Support for the General Ledger and Accounts Payables and Accounts Receivables systems. Solutions included debugging existing interface programs for error conditions and performance efficiency, modifying Unix scripts for error conditions, making PeopleTools and PeopleCode related changes, resolving Journal Generator process issues with General Ledger and Accounts Payables interface files, enhancing and fine-tuning Oracle PL/SQL Packages and Procedures, resolving issues with the Maestro Job Scheduler tool.
• Overall Month End process, Maintain Chartfields(Add, inactivate with the effective dates), Control Accounts (disconnecting and adding back), Source, Maintain Alternate Accounts, GL Processes, Maintain Trees for OU, Accts, Prod and Dept, Open close periods as required for Month end close, Maintain Ledgers / groups / Ledgers for Units, Maintain Year End closing rules
• Maintenance of Application Server, Database Server and Web Server. Developed script for OnDemand refresh from PS FSCM Production to Test Environment.

Confidential, Pittsburgh, PA

PeopleSoft Techno Functional Consultant

Environment: PeopleSoft HCM 8.8, 9.1, PeopleTools 8.51, Application Designer, Oracle 10g, SQL, PL/SQL, SQR, XMLP, Crystal Reports, PeopleCode, Application Engine, Application Package, AWE, Integration broker, Unix Shell Scripts, HTTP Watch, Oracle 11i, Weblogic 10.3

Responsibilities:

• Ran compare reports using a copy of production
• Developed necessary functional documents as required for upgrade project (PS 9.1).Performed Fit/Gap analysis for the existing 8.8 functionality compared to delivered 9.1 functionality and come up with solution to address gaps. Met with end users/business owners to go over best practices. Performed the business and technical Fit Gap Analysis, prepared mapping documents, analyzed and created list of all existing customized objects and collaborated with the team in deciding the strategy for re-applying the existing customizations.
• In current 8.8 environment, there are more than 8 Component Interface which are built over the highly customized Job and related components which are used in hiring Contractor. These CI needed to be updated with new Person Model introduced in 8.9 and above.
• Extensively worked on retrofitting and creating new CI to fit in the process.
• Re-designed the entire Confidential which will be used as an Information Sheet to have contractors (Drivers/Helpers/Temps) screened by background check and have Authorized Officers recruit the personnel.
• In Recruiting Solutions the Resume Template is further modularized to include various sections which will then comprise of Pages which will comprise of single Template. Designed various Resume Templates, Job Posting Templates which will be attached to Recruitment Templates which in turn will be attached to various Job Openings. Developed setup for Pre Screening Questions/Answers so that Applicant cannot continue further if he/she does meet certain criteria. Also worked with Business to gather various set up data for Degrees, Honors and Awards, Languages, Licenses and Certificates, Memberships, Schools, Text Catalog, Recruiting Statuses, Third Party Vendors, Employee Referral Programs.
• Retrofitted the existing SQR, XMLP Reports and Queries to reflect the new Table structure changes while maintaining the same functionality.
• Retrofitted database object like stored procedure and trigger to reflect Table structure changes,
• Involved in Development, Customization, Unit testing, User Acceptance training and System Testing and Support
• Prepared training documents, User-guides & reference guides. Also Trained end users in nVision and PS query.

Confidential, La Crosse, WI

PeopleSoft Lead Consultant

Environment: PeopleSoft HRMS 9.1, PeopleTools 8.51, MSSQL Server 2008, PS Query, SQR, XMLP Reports, Crystal Reports, Change Assistant, Application Designer, Application Engine, PeopleCode, Application Package, Integration Broker.

Responsibilities:

• Created Billing Interface which will read comma separated (.csv) file and load the data into Billing Interface and Accounting Entry, Discount, and Surcharge Tables.
• Fixed data and application problems in Asset Management like Negative NBV, salvage values on tax books, Assets depr in 2 depts, retired assets showing In-service status, Assets not retiring with correct quantites or cost, Books not in sync, depr entries not gen for capitialized assets, unbalanced entries sent to GL etc.
• Modified the existing PeopleCode behind the distribution records of voucher distribution pages to send the current date as the accounting date to combo edit procedures when saving the voucher. This customization is coded as the business is only keeping the combinations effective for the current period in the GL combination selector tables resulting in combo edit errors when saving a contract that belongs to the previous accounting period.
• Applied FSCM 9.1 Maintenance Pack #6.
• Assisted in developing strategy for Data Archival and set up Data Archive Manager to Archive data for AR, AP and GL. Developed custom Archive object definitions, Archive Template and Queries to archive custom Tables. Developed custom application engine which will run after the PSARCHIVE has been run in Selection Mode to update the BatchNum# to the latest as assigned in the History Table so that the corresponding rows are deleted from the Online Tables when run in the Delete Mode. Developed several SQL scripts to unit test as well as Data Mover Scripts to back up the Tables before the annual Archiving process will be run.
• Updated the Application Engine - Confidential so set the Accounting date according to client needs. The delivered interface assigns the Invoice Date to the Accounting Date and Transaction Date fields for the ADD transaction. Invoices that are not entered into the system on a timely basis, placed on hold, or held up by match exceptions could cause a transaction to be created with an Accounting Date for a prior period or a closed period. To avoid this problem, the Accounting Date field has been set to the current system date.
• Prepared documents for change management. Coordinated with various teams to migrate projects to production environment
• Conducted weekly meetings to provide update on outstanding issues and coordinated with Senior Management, PeopleSoft administrators and other team members.

Confidential, Pittsburgh, PA

PeopleSoft Consultant

Environment: PeopleSoft Financials, PeopleTools 8.51, Oracle 11i, Change Assistant, Application Designer, Application Engine, PeopleCode, Application Package, Integration Broker, SQR, Crystal Reports

Responsibilities:

• Member of the upgrade 8.8 to 9.0 team. Responsible for retrofit analysis and recoding of customizations, as well as, the recoding or removal of “break-fixes” and “one-offs”.
• Led Business Process Review sessions in which Fit/Gap determinations were made, Future State Business Processes were devised. Participated and led effort to document Solution Models and Configuration Workbooks.
• Evaluated current modifications and worked with users to determine which modifications could be retired with the upgrade and which had to be carried forward.
• Gathered requirements and drafted detailed technical specifications, mapping documents and developed an interface for the General Agency Receivable to load pending items into the AR tables. This interface reads flat file data and inserts into Pending Item, Dist Item and Control Group tables. (U AR ITEM LOAD) Performs the data checks and verifies the control data, purges the invalid data and inserts valid Pending Item data.
• Developed an AR Maintenance SQR process that looks at the PS ITEM table and matches like debits and credits for customers with unique document number. This process creates a maintenance worksheet, which is subsequently processed and closed by ARUPDATE.
• Worked with super-users to configure PeopleSoft Applications and execute Unit Testing. Worked with users and team members to develop Integration Test scripts and to execute the Integration Test and User Acceptance Testing.

Confidential, Milwaukee, WI

PeopleSoft Support

Environment: PeopleSoft HCM 9.0 (Workforce Administration, Base Benefits, NA Payroll, ESS/MSS, Time & Labor), PeopleTools 8.49, Application Designer, MS SQL Server 2005, SQL, PL/SQL, SQR, XMLP, Crystal Reports, PeopleCode, Application Engine, Application Package, Integration broker, Change Assistant

Responsibilities:

• Support the existing PeopleSoft System. For NA Payroll - apply Maintenance packs, Tax Updates and bundles & patches migrating objects across environments and implementing change control methodology
• Develop Employee Profile report showing EE profile with past 5 years of history.
• Developed Application Engine process to load Non Employee data in PeopleSoft.
• For NA Payroll, developed an Application Engine to load COBRA data from Wageworks to PeopleSoft. Since the Wageworks excel file needs formatting, wrote VBA excel macro to clean and format the data before the file gets loaded.
• Designed and developed RDE Application Engine process to load accrual hours from Kansas City Location
• According to Created custom rules for shift changes in Harley’s Buell site.
• Designing and develop customization for leave accrual where Super users can do adjustment to the leave balance online
• Design and Develop program to upload Promotion data in to Job Data Component using Component Interface, accrual reports for business users
• Install and maintain all the components for the PIA, which included file server, application server, process scheduler, web server, and database server
• Triage and resolve complex processing issues and escalations from HR, ESS/MSS, Payroll and Benefits team. Drive root cause analysis and closure of support tickets within time.

Confidential, Harrisburg, PA

PeopleSoft Techno Functional Consultant

PeopleTools: 8.50, Application Designer, Oracle 10g, SQL, PL/SQL, SQR, XMLP, Crystal Reports, PeopleCode, Application Engine, Application Package, AWE, Integration broker, Unix Shell Scripts.

Responsibilities:

• Interacted with application users and gathered functional requirements and involved in analyzing organizational concepts and mapping the existing GL process to PeopleSoft GL.
• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables.
• Worked with ChartField conversions, ChartField validation, combo edit checks in GL.
• Designed and created several trees and combo edit rules for ChartField Combinations in GL.
• Gathered requirements, designed, wrote technical specifications and developed custom pay date update program(P PAYDTUPD). This program updates the payment dates on the PS PYCYCL table. Using current date this program calculates the new payment date, New pay through date next payment date and next pay through date. The payment dates should be valid business days. And the pay through dates is calculated based on the next payment date. If the next payment date is more than one day ahead of the new calculated payment date then the pay through date will be one day prior to the next payment date.
• Voucher Build (AP VCHRBLD) tuning. Using SQL trace recognized the SQL which is the cause for the performance issues and designed a solution. By pre-populating the remit vendors custom table avoided the usage of a view in the APVEDTDFPV sub program.
• Developed various customizations for Refund of Credit Voucher, Self Billing Invoice Notification, Datawarehouse extract processes, Customer Inactivate, Asset Management Mass Change, Asset Load Interface, Vendor Load Interface
• Gathered requirements and drafted detailed technical specifications and developed an interface for the General Agency purchasing system to load their POs into the system. (UPO ASC UPLD) this process loads the data from ASC files and verifies the control data and inserts the new PO into the PO staging tables. And the PO POCALC and PO POCREATE will create the Purchase orders out of the staged data.
• Gathered requirements, designed technical specifications and developed an interface program to load the Requisition files sent by Quantum online purchasing system. Using the custom File Layout the program loads the data into the staging tables(PO REQLOAD RQST, PO REQLOAD CMT) and the PO REQLOAD process creates requisitions out of these entries.
• Involved in the detailed design and development of seamless integration process using Integration Broker and Application Messaging between ARIBA and PeopleSoft for the upload of Purchase orders. Also developed a change order process that uses Component Interface to create the change orders.
• Created the templates for the SOAP envelopes and the XML documents that ARIBA needs use to send the purchase orders.
• Wrote the technical specifications for the development of receiver message subscriptions to parse the XML documents and loads the purchase orders, and change orders into the PO staging tables and custom change order records respectively.
• Designed and developed a new application engine to load the ARIBA change orders into the PeopleSoft using PO entry component interface. Business requested the use of a component interface to utilize the functionality behind the panels to make changes at the distribution level as well. Point of contact for the whole project including design, development and testing.
• Wrote the technical specifications and impact analysis for a Customization to the delivered 'amaedist.sqr' which creates the Asset accounting entries to send error notifications to the AM support in case of errors occurred during the validation of open transactions and in case of invalid distribution template the process continues processing the other entries belong to the same business unit.
• Gathered requirements, designed, wrote technical specifications and developed a custom PO accrual process for the year end closing. This Program selects the Purchase orders at the distribution level and inserts into the P PO ACCRUALS table. And creates an Excel spreadsheet with all the purchase orders that needed to be accrued.
• Confidential BUILD developed this program according to the technical specifications to by pass the inventory replenishment approval workflow. This program selects all the new replenishments from the Replenishment Request table. If the replenishment requires approval, update the status to In Work Flow, and insert a row into the custom Replenishment table. Send a replenishment notification email to the planner. Send a second "items by planner" email to the planner. If the replenishment does not require approval update the status to Ready for Processing. Send an "items by planner" email to the planner.