SUMMARY

• PeopleSoft consultant with overall 8 years’ experience in Information Technology in PeopleSoft FSCM implementation, upgrade, troubleshooting and support.
• Progressive functional, technical and testing experience in the customization and implementation of the PeopleSoft Financials and Supply Chain (Accounts Payable, Accounts Receivable, Billing, General Ledger, Purchasing, eProcurement, Travel and Expenses, Strategic Sourcing, Inventory, Order Management, Grants, Asset Management).
• Proficient in conducting business process analysis, gathering requirements, Fit - Gap Analysis, creating functional and technical design specifications and user training.
• Extensive experience in Information Systems encompassing strategic planning, analysis, design, development and enhancement of client/server based applications with 3-Tier Architecture and Web based applications.
• Strong PeopleSoft technical skills in PeopleTools that include Application Designer, PeopleCode, Application Engine, Component Interface, File Layout, Integration Broker, Process Scheduler, Workflow, Query, Data Mover, Security Administrator, Approval Workflow Engine and Definition Security.
• Expertise in writing, tuning and debugging the PeopleCode, SQR and Application Engine programs.
• Extensive experience on data mapping and conversion of data from legacy systems to PeopleSoft systems using Integration Broker, SQR, App Engine, Component Interfaces, and Excel-To-CI tools.
• Extensive knowledge in developing and customizing reports using reporting tools such as SQR, Crystal Reports and nVision.
• Involved in Production support, responsibilities include maintaining, updating, and providing fixes for applications, configuration, specifications and migration of fixes to different environments for testing.
• Experience in Unit Testing System Testing, Integration Testing and Functional Testing.
• In-depth understanding of PeopleSoft Internet Architecture (PIA), Data Model and client server applications.
• Proven the ability to work in the team as well as individually on various projects.

TECHNICAL SKILLS

ERP: PeopleSoft Application (FSCM) 8.x/ 9.xAccounts Payable, Accounts Receivable, Billing, General Ledger, Purchasing, eProcurement, Travel and Expenses, Strategic Sourcing, Inventory, Order Management, Grants, Asset Management.

People Tools: People Tools 8.5x / 8.4x / 8.0 - Application Designer, Application Packages, Application Engine, PeopleCode, Component Interfaces, File Layout, Data Mover, Integration Broker, AWE and Portal Administration.

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

Database: Oracle 11g / 10g/ 9i, MS SQL Server /2003 and DB2

Scripting: HTML 5, CSS, JavaScript, Core Java and PHP

Version Control: STAT, Phire, Remedy, HP Quality Center, SharePoint

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

PeopleSoft Technical Consultant

Environment: PeopleSoft Finance 9.2 / 8.8, Peopletools 8.54/8.46 (Accounts Payables, Accounts Receivables, General Ledger, Billing), SQL Developer

Responsibilities:

• Responsibilities include development, retrofitting, upgrade & conversion validation, and testing
• Played key role in retrofitting Interfaces, Application Packages, PeopleCode, Application Engine programs and SQR’s.
• Provided Fit/Gap and Business Analysis to identify process changes and their impact.
• Analyzed compare reports to determine objects to carry forward during the upgrade effort.
• Responsible for performing impact analysis of drop and retain customizations. Created a comprehensive report with the results.
• Responsible for coordinating project migration to adhere development standards and troubleshooting issues during migration.
• Conducted review sessions with business users for requirement gathering and converted functional requirements to technical requirements.
• Developed custom inbound/outbound interfaces using application engine - file layout for BI, AR and AP applications.
• Customized delivered customer component interface to load customer and address information.
• Built complex reports for reviewing available budget for ledger groups using BI publisher using PS Query as data source.
• Converted custom Crystal reports from 8.8 to BI publisher reports in 9.2
• Customized delivered CCcard load application package to disable encryption of procurement cards.
• Actively involved in creating test cases and carrying out those tests for Unit Testing of retrofitted and new builds.
• Responsible for customizing the PT BRANDING application package to apply custom branding and customize the portal layout.
• Developed custom pagelets to improve accessibility of portal page.

Confidential, Jacksonville, FL

PeopleSoft Developer

Environment: PeopleSoft FSCM 9.1, People Tools 8.51, Contracts, Project Costing, Accounts Receivables, Accounts Payables, General Ledger, Billing, Oracle 11g, App Engine, Component Interface, Integration Broker, SQR.

Responsibilities:

• Gathered the requirements to ensure that Prior year Project accounting for legacy APS and Idea Integration will be migrated to PeopleSoft 9.1 Projects.
• Gathered the requirements from end Users and helped in defining the chart fields in 9.1 setup.
• Prepared the documentation for Projects module which will feed billing information to the Billing module.
• Worked on Fit/Gap Analysis for Project Costing, Contracts Modules, Billing, Accounts Payables.
• Built an interface from PeopleSoft 9.1 GL to Adecco OF will be utilized to update Adecco financials.
• Developed a Journal Interface program using Application Engine and File Layout to load JGEN ACCTG TBL from the flat files received from Oracle Financials corporate GL system.
• Configured JGEN accounting template and definition to process Oracle Financials journals.
• Developed an outbound vendor interface to Pay mode system using Application Engine and File Layout.
• Wrote vendor conversion program to converts IDEA and APS vendors into PS v9.1 using application engine.
• Modified delivered fineft.sqc and wrote new sqc program to send EFT payments to TD Bank and Bank of America.
• Customized delivered AP APY2015 Payment selection and Creation process to implement Paymode payments.
• Customized Positive Pay application engine program AP APY2055 as per business requirements.
• Developed program to convert project data from IDEA system to PS v9.1.
• Worked in providing production support for legacy PeopleSoft 8.4 financial module AP., GL, BI and AR for Specialty staffing business units.
• Developed several queries and reports as per user specifications as a part of production support.
• Extensively worked with business users and implementation partners on system configuration, design.
• As a part of production support, helped the users fixing issues on AP, GL, BI, AR modules, provided access/restricted access as security admin and provided assistance with issues relating to various third party applications interacting with PeopleSoft.
• Debugged several nVision and Crystal reports.

Confidential, NY

PeopleSoft Developer

Environment: PeopleSoft FSCM (AR, AP, GL, ePro, BI, Inventory, Expenses, Purchasing, Contracts) 9.0, People Tools 8.49

Responsibilities:

• Created several functional flow diagrams for the customizations which will be more useful to the users to understand the flow of the customizations.
• Involved in fit-gap analysis from PS8.0 to PS9.0 version. Designed the document for master customization list which will take care of all the gaps should be fulfilled in PS9.0 version.
• Designed the technical design documents (AR Augmentation and Validation, Billing Augmentation and Validation, Generating Invoices, Processing EDI 820 Files, Move project Chart fields to line Distribution, Customer Refunds, Miscellaneous Online enhancements in Billing and Accounts Receivables), Duplicate invoice checking, Vertex Interface, Process 1099, AP-HUB-GL reconciliation, Voucher Approval process, AP approvals in Accounts Payables Module, Chatfield changes, Combo edit on chart fields in General Ledger modules, Transaction Billing processor interface (RE GENTRANS).
• Created the Technical designs for Invoice extract process changes, new invoice layout designs for NORTHSHORE HEALTH SYSTEM, Contracts to Billing Interface changes, and Expense Employee Data update changes to the delivered Application Engine program, Accounts Receivable Update changes.
• Customized Dispatch Purchase Orders with New PS Vanilla Version (POPO005) as per the client requirements.
• Added Micrographics Link to all voucher pages (VCHR EXPRESS1, AP VOUCHER INQUIRY, PO INQUIRY, PV PO INQUIRY).
• Customization is to add the justification/summary area on the ePro manage requisitions page under the requisition information.
• Modified changes for the ePro comments displaying incorrectly on the Requisition Detailed Summary (PV REQ APP DTL GRD) page when choosing the expand bar under Display Shipping and Distribution.
• Created new Custom App Engines (ZZ SC EAGLE) for Custom Eagle Patient Refund Interface, Custom Invoice quick key page (Validates if Invoice exists already, valid State, Only allows up to $25K). Also an Audit report for the interface.
• Tested the interfacing between General Ledger, Accounts Receivables, Accounts Payable and Billing modules to ensure that the data is accurately interfaced.
• Developed an Application Messaging process to make sure the Journal lines in PeopleSoft journal table are consistent with the entries in the third-party system.

Confidential - Dayton, OH

PeopleSoft Developer

Environment: PeopleSoft FSCM 8.8 / 9.1 46 (Accounts Payables, Accounts Receivables, General Ledger, Billing), PeopleTools 8.53 / 8.50, SQL Developer

Responsibilities:

• Worked with the functional team to gather requirements, perform fit-gap analysis, and define overall scope and definition of the project in terms of functional & technical requirements.
• Prepared Technical Specification Documents for the Conversion of Customers (active customers), Customer Conversations, open AR-Items (invoices related to open Items) & Bills (installment, recurring bills and open transactions).
• Customized AR30003.SQR, AR30004.SQR to print the number of disputed items for each customer along with the number of disputed items for the business unit, order number, and reports.
• Troubleshoot the GLPPPOST (SLEDGER STG - staging table edits) to correctly post a Journal to Budget Ledger for Ford’s Business Unit and a particular Journal ID.
• Customized the Commitment Control Posting App Engine (FSPQPOST) to post the budget journals to the control budget ledger.
• Involved in Performance Tuning of SQL scripts using Explain Plan, Indexes etc.
• Customized the AR PREDICT (AR PREDICT1- App Engine) App Engine to accept the New Business Units and the New Set id from the Midwest data Conversion.
• Modified the respective queries attached to the crystals. Format and layout changes were made according to the Functional User Specifications.
• Customized the BIIF001 App Engine so as to avoid populating the fields ACTIVITY ID and BUSINESS UNIT PC in the BI HDR table as per the Functional user requirements.
• Perform monitoring of batch job schedules using ESP to ensure batch cycles completes as scheduled and make sure online transactions are available.
• Developed a SQR to load Contracts for Purchasing to obtain the most favorable Contract pricing and to report on YTD purchases by Contract.
• Customized the purchase order consolidation process to allow for consolidation based on the Ship To locations to accommodate vendor requirements.
• Technical implementation of codes to receive the XML messages and convert and create a PeopleSoft application specific entry in SCM.
• Customized the Inventory pages and modified the People Code to facilitate daily stocking, add Sync button to Login page on Inventory scanner.
• Developed a bolt-on process to allocate inventory according to user specified logic. Since delivered functionality does not include order type as a part of the allocation logic.
• Updated Financial Transfer report and Inventory Transfer report based on new location typed added.

Confidential

PeopleSoft Developer

Environment: PeopleSoft Financials 8.8, PeopleTools 8.46, Oracle 9.2, Data Mover, Component Interface, SQR, Crystal Reports, nVision, Quest STAT

Responsibilities:

• Involved in the implementation and production support of Financials 8.8 (BI, AP, AR and GL).
• Extracted, converted and loaded data from legacy system to PeopleSoft tables.
• Systems converted - Vendors, Purchase Orders, Receipts, Contracts, and vouchers.
• Modified FIN2025.SQR to keep track of Payment files, and created interface to Electronic files transfer the Payment File to Bank.
• Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
• Involved in customizing BIIVCEN.SQR according to specific client requirements.
• Customized the GLS9002.sqr, which loads journals from flat files.
• Developed several inquiry pages and modified existing pages for the users to enter data and run reports for the AR and Billing modules.
• Developed several customizations by creating complex pages and business logic as per client requirement.
• Debugged the Journal Generator process to correctly populate the VCHR ACCTG LINE record.
• Administered, scheduled and maintained the Jobs on Process Scheduler.
• Ran compare reports and analyzed them for the collisions, retrofitted the old customizations, SQR’s and Crystals.
• Involved in modification and fine-tuning of Application Engine, SQR programs.
• Reviewed all interfaces that update PeopleSoft to ensure that data integrity will exist in the upgraded system.
• Created a project to delete all the orphan objects.
• Involved in production support and provided support to functional team members on SQR and PeopleTools/People Code understanding.