SUMMARY

• Senior PeopleSoft Financial Consultant having overall 19+ years of IT experience with 10 plus years of PeopleSoft Financial and 3 years in HRMS.
• Experience in PeopleSoft Financials with these modules: Accounts Payable, Purchasing, General Ledger, Accounts Receivable, Billing, Travel and Expense and Customer Contracts.
• Experience in PeopleSoft HRMS with these modules: HR, Payroll, Time and Labor and Benefits.
• Expertise in PeopleSoft Implementation, Upgrade, Enhancements, Interfacing/Reporting, Data conversion and troubleshooting.
• Perform all aspects of development life cycle including design, development, unit testing and documentation
• Extensive experience in working with financial users to define and analyze business requirements.
• Knowledge of Integration between financial modules.
• Proficient in the use of PeopleSoft Development tools.
• Proficient in the use of Workflow, AWE and PHIRE migration tool.
• Expertise in deploying PeopleSoft web services between PeopleSoft to PeopleSoft and PeopleSoft to non - PeopleSoft.
• Expertise in Interfacing and Conversions from Legacy Systems and External systems.
• Extensive experience in creating inbound and outbound interface files with banks and other external systems.
• Extensive experience in creation and execution of test plans and test scripts for Confidential applications
• Work with users to review user acceptance test plans and results.
• Extensive experience with supporting Confidential applications in production environment
• Good functional understanding of PeopleSoft Finance & Supply Chain modules.
• Experience in gathering requirements, create technical design doc and provide estimates for enhancement projects.
• Good Knowledge with PeopleSoft tables and structures for research and Analysis.
• Good Knowledge in PeopleSoft Security. Create new user profiles, Permission lists, Roles based on the requirement.
• Excellent problem solving, analytical, debugging and troubleshooting skills
• Self-directed - works effectively both independently and in a team environment.
• Ability to effectively work on multiple tasks and work under pressure to meet tight deadlines.
• Identify system performance issues and assist with system tuning.
• Worked on Identifying the impacted custom objects during PUM upgrade projects.
• General understanding of Sage Intacct payable and concur expenses.
• Ability to absorb new technology and features.

TECHNICAL SKILLS

ERP Package: PeopleSoft Financial/SCM 7.5x/ 8.0/8.4/8.8/8.9/9.0/9.1/9.2 (Billing/Accounts Receivables/Accounts Payable/Customer Contracts/ Purchasing/Asset Management/Travel and Expense , Project Costing, Campus Solutions and HRMS modules (HR, Benefits, Benefits Admin Time and Labor and Payroll)

Integration Tools: Integration Broker, Component Interfaces, Wes Services (SOAP Enabled, Restful based Web Services, Services, Service Operation, Routing, Application Messaging), Business Interlinks, File Layout.

People Tools: Application Designer, People Code, Application Engine, Application Package, Component Interface, SQR, Application Messaging, Tree Manager, Import Manager, Data Mover, File Layout, Excel to CI templates,, Fluid Development, Data Migration Work Bench.

Reporting Tools: Crystal reports, BI Publisher, SQR, PS/Query, nVision

Programming Languages: PeopleCode, COBOL, C, C++, Visual Basic, SQL, PL/SQL. HTML, XML,VBScript, Style Sheets.

Operating Systems: Windows NT/95/98/2000/XP, MS DOS, Unix/Linux

Databases: Oracle 11g/10g/9.x/8.x/7.3, MS SQL Server 2000/7, DB2, MS-Access

PROFESSIONAL EXPERIENCE

PeopleSoft Sr. Financial

Confidential, Columbus, OH

Responsibilities:

• Perform all aspects of development life cycle including design, development, unit testing and documentation
• Work with users to gather requirements, a nalyze business requirements, create technical design doc and provide estimates for enhancement projects.
• Create and execute test plans and test scripts for Confidential applications
• Work with users to review user acceptance test plans and results.
• Perform Code review and approve for migration to UAT.
• Provide production support for Confidential applications.
• Develop and lead end user .
• Provide technical mentoring to members of the team.
• Involved in customization on AP/BI/AR/PC/GL/Purchasing/eProcurement/Customer Contracts module.
• Developed and used extensively data mover scripts to export data from Prod and Import into non-prod for testing.
• Developed various inbound and outbound interfaces using File Layout/Component Interface/Application Engine and SQR programs.
• Setup a new business Unit in AP, GL, AR, BI, PC and Customer Contracts.
• Update User Ps, common definitions, product related, Business Unit Security, Pay Cycle Security and Open GL and AP periods.
• Created BI Publisher checks for Confidential Report Checks for JPMorgan. Worked with Banks to validate the checks and positive pay files.
• Create/Update online vendors and load vendors via component interface process. Involved in processing 1099 vendors.
• Setup banks and reconciliations, enter and load bank statements, created process to reformat the external bank statement files.
• Worked on PPD, CCD, CTX and NACHA EFT/ACH file formats.
• Transmit direct deposit from HCM and dispatch Payments through Financial Gateway.
• Enter and post vouchers, review voucher errors, write scripts to clean up voucher errors and run pay cycles.
• Load external invoices into PS via flat files, EDI manager and web services.
• Setup Debit Card payment method, created a process to send the debit card payments to the bank via pay cycle. Created a process to void/cancel debit card payments over $2500 and flip the payment to Check.
• Involved in troubleshooting AR UPDATE process and payment predictor.
• Created Interfaces to load external journals into General Ledger using Journal Import Excel Template, Web Services and Application Engine Process.
• Created Credit card billing interfaces for AR module.
• Developed several Pages and programmed in PeopleCode.
• Created Style Sheets to update the company logo on PIA.
• Developed SQR programs to convert customer set up data from legacy system to People Soft in Accounts Receivables and created/modified Aging reports.
• Load Confidential employee and CONCUR expenses data into PeopleSoft Expenses table from a flat file. To do these two SQR’s were written. First one to convert it into the required format for the EDI process to run successfully and then to load it from staging tables to PeopleSoft tables.
• Designed and developed inbound and outbound interface with Application engine for Project Costing.
• Worked closely with the Functional team to design and develop AWE workflow for Purchase Orders, Requisitions, Vouchers and Journal approvals/denials.
• Created Excel to CI templates with Search/add/update push button features to load Budgets and Salary Update Changes into PS.
• Created a process to send Job data to third party system called Confidential using web services.
• Created outbound Employee data Interface from PS HCM to Kronos.
• Created component interface to ChangePoint/Kronos employee time sheet into time and labor module.
• Enter/Update Express Bills, and created billing BI Publisher invoices as per client’s requirement.
• Created Application Engine process to deliver the output file in Excel format (GL Reports).
• Load various chartfield combinations, combo rules, trees and implemented ADB for GL business Units.
• Worked on both fluid and classic travel & expense reports approval workflow setup.
• Worked on Confidential WorkFlow setup.
• Developed and Tested Hyperion/PBCS Interface.
• Tested the integration between contracts to billing and AP.
• Worked on retrofitting customizations.
• Developed and tested Hyperion/PBCS Interface.
• Customized Purchasing, requisition, receipts, Return to Vendor and eProcurement pages/components as per user’s requests.
• Worked on modifying the approval and denial templates (XML, HTML).
• Apply 1098T patches every year for student financials.
• Worked on ELM Budget load process.

Environment: PeopleSoft Financial/SCM 7.5x/ 8.0/8.4/8.8/8.9/9.0/9.1/9.2 (Accounts Payable/Billing/Accounts Receivables/General Ledger/Customer Contracts/ Purchasing/Travel and Expense)

PeopleTools: 8.5x/8.4X/8.16/8.12/7.5.

Senior Developer

Confidential

Responsibilities:

• Worked with Confidential and Confidential users on gathering the HR and Payroll data.
• Developed Mapping Documentation (Mapping PS fields with Confidential / Confidential fields) in order to convert the data into PS.
• Written SQR program to convert Confidential / Confidential hr and payroll data to PS.
• Tested and Reviewed HR and payroll data in PS.
• Provided Production support on HR and Payroll modules.
• Involved in Setting up Coverage codes, Dependent and Beneficiary Information.
• Worked on Enrollment Process.
• Written Functional Specification for setting up Health Plans, Leave Plans, Savings Plans and Life Insurance plans.
• Modified Payroll checks and troubleshooted pay check creation and direct deposit programs.
• Created WebServices to send employee personal and job data to third party.
• Created component Interface to auto load the employee time entry data into change point.