SUMMARY:

• Technical Consultant specializing in PeopleSoft versions 8.0 through 9.2 - Financials, HR, EPM and ELM.
• Worked with PeopleSoft Tools version 8.53.
• Proficient in development of PeopleSoft applications with PIA (PeopleSoft Internet Architecture) and integration tools including Application Engine, Component Interface, and Application Messaging using Integration Broker.
• Specialized in writing data extraction interfaces and conversion scripts from legacy/feeder systems to PeopleSoft applications and proven experience in data conversion and cleansing data using Data Mover, Export, Import and ODBC Utilities.
• Expertise in PeopleTools, SQR, PeopleCode and Tree Manager.
• Develop reports using SQRs, Crystals and PS Query.
• Expert in Application Engine Development.
• Very good knowledge on table structures in Finance, EPM and LMS. Working knowledge on HR.
• Excellent troubleshooting experience including online server trace, app engine trace, SQR trace using SQR Runner, COBOL trace etc.
• Experience managing and coordinating BearingPoint Off-shore GDC( Global Development Center) in Hattiesburg, MS.
• Winner of BearingPoint Beacon for excellence in project delivery and client satisfaction.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Workday HR to PeopleSoft Financials, EPM and LMS Integration.
• Design and develop interfaces between Workday and PeopleSoft Finance using Component Interfaces and XML messaging.
• Develop Reconciliation reports between Workday and PeopleSoft.
• Production Support.

Confidential

Senior PeopleSoft Developer

Responsibilities:

• External interface for AP Matching in a 3rd party system to release payments.
• Voucher Interface using application messaging.
• Item conversion using ITEM SYNC application messaging.
• Go-live and Prod Support.

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Vendor to Third party outbound interface using Integration Broker.
• Vendor, PO and receipts Conversion.
• Impact analysis on existing customizations.
• Develop Technical design documents.
• Support functional team in troubleshooting issues.
• Data and project migration.
• Develop ETL’s using IBM InfoSphere DataStage.
• Post Go-Live support and Prod Support.
• Security Support.

Confidential

Advisory PeopleSoft Developer / PeopleSoft Support

Responsibilities -

• Enhancement and Support for PeopleSoft Travel and Expense module.
• Support for PeopleSoft interfaces, external loads and integrations.
• Expense module enhancement to setup new Business Units, expense types, credit card vendors
• Integrate with Visa / US Bank to interface Corp Card load to My Wallet.
• Multi Currency BU setup.
• Integrate with external banks to send payment and remittance file.
• Agile software development experience.
• Lead developer for Confidential UK PeopleSoft Travel and Expense module rollout. Setting up Corporate Card/My Wallet functionality and integration with Elavon-Visa Corp Card, Remittance file, BACS ( Payment file ), User setup data conversion, Banking data setup, Vendor setup, Corporate card data conversion etc.
• Production support for PeopleSoft V9.2 upgrade project.

Confidential

Responsibilities:

• Technical Consultant for the PeopleSoft LMS system implementation at FCC.
• Setup integration with HR to import employee profile, department information etc using Integration broker.
• Fix Oracle delivered bugs as required.
• Development and maintenance of the “required learning” process that automatically assigns learning to employees based on learning plans assigned to their job profile.
• Data Conversion using App Engines, CI’s, IB etc to convert existing data like employee information, previous learning etc.
• Interface with third party learning content vendors like RMA, SkillSoft etc.
• Technical Consultant responsible supporting AP, GL, EX, AM, EPM, ETL’s, HR.
• Analyze, prioritize and fix bugs as required.
• Work with Oracle to develop fixes.
• Conducted bi-weekly meetings with business to review bugs and progress.
• Oracle UPK 3.5.1 Implementation (Client Server model) and support. - Create users, setup security.
• Create and publish help manuals for PeopleSoft FSCM and Custom modules.
• Performance tuning application by using PeopleCode, SQL trace and analyzing trace files. Work with DBA’s to fine tune hung SQL’s, create Gather stats plans, use SQL hints, engage Oracle to get point fixes or extract fixes from patches identified by Oracle.
• Create Technical Design documents for customizations to existing PS functionality to suit FCC business requirements
• Work with business and SME’s to gather requirements.
• Technical Design of the FCC Financial authorities (FA) system that was used to maintain hierarchical approval limits for users. This was then interfaced with the AP and EX modules to control approval routing.
• Develop custom page for temp delegation of financial authorities and approval routing, generate emails to notify users of pending authorities etc.
• Create roles and permission lists to provide specific access to employees, managers and admins.
• Implemented Audit functionality on important FA tables.
• Developed multi language support ( ENG and CFR ) on all pages, emails etc, and created Lang specific tables.
• Developed numerous app engine batch processes to maintain the FA system.
• Worked with Oracle to fix existing issues, apply bundles to extract point fixes for specific issues as delivered by Oracle.
• Datastage Ascential ETL customization and execution for year end load from HR and Finance to EPM.

Confidential, Cincinnati, OH

Responsibilities:

• Senior Technology Consultant responsible for AP and GL Interfaces.
• Interact with Client to understand existing business process and provide recommendations.
• Conduct weekly status report meetings to update progress to management team and client and to discuss existing issues / resolutions.
• Conduct classroom sessions for knowledge transfer.
• Designed Interfaces for Positive Pay, EFT, ACH, Checks, Cleared Checks, 1099 File, OFAC vendors list, Escheat Payments etc using Peopletools and Ascential ETL tool.
• Designed and built Interfaces using Excel to CI for GL Journal Generation.
• Designed and built File attachment page for attaching scanned vouchers to the PeopleSoft Voucher Page, customized approval page to enable approver to view the attachment.
• Design and build custom page for Manual Accouting Entry Journals.
• Implemented Chartfield Combination Editing for custom accounting entry page.
• Gathered file layouts / business rules / field mapping for the interfaces from Client.
• Designed and Implemented Secure Automated FTP process for file transfer between UNIFI and OOD ( Oracle PeopleSoft Hosting Environment )
• Designed Process Schedules and handled dependencies between PeopleSoft and External systems using external Mainframe scheduler.
• Conduct Unit test, Integration test, System test and UAT on installed modules and organize weekly sessions to update percentage completes, issues etc. Log issues and escalate unresolved high priority issues
• Assist functional leads and client in conducting Unit testing using UPK for requisition, POs, Vouchers, Vendors etc for signoff.
• Assist functional leads in creating custom test script documents based on UPK like Vendor Add, Voucher creation, Voucher approval, create control groups, enter quick invoice etc.
• Configured Purchase Order Fax and email process for sending PO by Fax and email.
• Full setup and configuration of Integration Broker and Messages for AP Voucher spreadsheet upload. Customized this process to include extra fields required by UNIFI.
• Coordinated work with ETL developers and GDC (BearingPoint Global Development Center) team to implement AP interfaces.
• Conducted Peer-review / Code-review to sign off on development activities and quality control.
• Migrated Customizations and moved data using Datamover.
• Troubleshooting/ tracking App Engines Journal generation issues for the GL team.
• Designed and implemented automated file Archiving process for Outbound Interface processes.

Confidential, Richmond, VA

PeopleSoft Financials 8.9 Implementation ( AP, GL, Payroll Interface )

Responsibilities:

• Senior Consultant responsible for complete Functional and Technical design and implementation and of the CIPPS ( Payroll to GL ) Interface and reports.
• AP Vendor Customizations to support existing business processes at VCCS.
• Worked closely with the client to gather functional specs and prepare functional design document for the CIPPS interface.
• Developed complete design specs for the Interface including TDD.
• Developed custom FTP scripts for interfacing with Virginia Dept of Accounting Mainframe server and downloading payroll files daily
• Reverse engineered existing Mainframe COBOL programs and converted them into Application Engines.
• Built custom tables, fields, pages, components, peoplecode etc to implement the complete interface.
• Built custom scripts using VEDIT and Perl to unpack Mainframe EBCDIC format data to ASCII.
• Tuning of app-engines to include set based processing to reduce overhead and processing time.
• Created Custom reports and automated report distribution to designated folders for the colleges/ business units to view their specific reporting folder.
• Custom programs were developed to run multiple instances of FS JGEN ( Journal Generator ) in parallel by business unit to reduce run times and overload.
• Setup of the journal generator template, accounting entry table definition and run controls.
• Unit testing, writing test case scenarios, and regression testing of the CIPPS Interface.
• Client webex sessions were conducted to familiarize client with the new PeopleSoft CIPPS Interface system and reports distribution.
• Post production support.
• Create custom Crystal reports to summarize expense by chartfields, employee, business units etc.

Confidential, Amherst, MA

PeopleSoft Student 8.0 upgrade planning

Responsibilities:

• Conduct weekly sessions on Application Engine development.
• Client had a highly customized SQR based system which they were looking to convert to App Engines.
• Convert custom SQR programs into App Engines for the new system.
• Troubleshoot known PeopleSoft bugs and apply fixes for student transcripts, student enrollment etc.
• Manually reapply customizations in 8.0 to 8.8

Confidential, St Paul, MN

Responsibilities:

• Worked as Techo-Functional Consultant for the Global Inventory management Solution implementation.
• Involved in 3M Fit Gap Analysis meetings to identify core 3M business processes and to integrate these into PeopleSoft.
• Writing Functional and Technical Specifications required for customizations and Developed Multiple AE’s.
• Developed Custom Applications, AE’s, CI’s, Pages etc to implement current Inventory business process.
• Customize IN ITMLOAD to maintain Inventory Items and add / update items using messaging ( ITEM SYNC message etc). Customized to save existing ACCT material #, Ledger Codes etc, since the delivered app engine does not save these during an update
• Customize subscription message PeopleCode to in corporate 3M business process rules.
• Developed a custom Costing App Engine that does Putaway (020), Depletes (030), Interunit Transfer, RMA Receiving and Adjustments (050)
• Developed Custom Trans Costing / Putaway / Deplete Program to do a load test with millions of items.
• Developed Custom AE’s for Accounting Material Number (AMN) maintenance.
• Was involved in a entirely new product - 3M Global Costing System ( GCS ) which includes GCS Configuration Page, Cost Version/Cost Type setup, AMN Setup. Maintenance includes Production and Non-Production Summary, Processes includes Burden Rates, Pre Summarize PID Info, BOM Sequencing, Transfer Prices etc. Also included multiple Crystal reports.
• Did numerous project migrations, Testing, QA etc as part of going to SYS / Functional Testing.

Environment: PeopleSoft 8.8 SP1 (Inventory), DB2, PeopleTools, 8,45.12 PeopleCode, PS/nvison, UNIX, Windows NT, WebLogic 6.1.0.

Confidential, Galveston, TX

Responsibilities:

• Created reports like DDDAUDIT, SYSAUDIT, Alter Audit to verify consistency across database.
• Created and Modified Records, Record fields and Trees for People Tools 8.45 that had been earlier customized for version 8.4
• Worked on posting and unposting journals and handled journal errors during the Journal processing for the General Ledger module.
• I was involved in security migrating security in PeopleSoft 8.4 and redefining process groups, operator ps etc in the upgraded version of PeopleSoft 8.8.
• I was involved in Integration tools to enhance the functionality in the upgraded version of PeopleSoft 8.8.
• Developed a new report which will give the vendor payment summary for all the vendors to list the details such as vendor name, their ID, remitting address, vendor class, and the amount paid during the year.
• Worked extensively on interfaces related to Grant, Billing, Projects costing, Contracts, AR, AP, GL, etc.
• Modified Application Engine job CA BI INTFC to use accounting data on the project resource table for effective date to check on contracts accounting UAR rows.
• Modified Billing interface process (BIIF0001.SQR) for getting data from other modules like contracts, projects and grants.
• Modified existing SQR and Crystal Reports to add new ChartFields, which was not included in version 8.0.
• Modified and created new components, pages and records to implement existing functionality which was customized in version 8.4.
• Created a new File layout definition and modified Voucher build App engine program.
• Developed PeopleCode to in corporate specific requirements while Upgrading Version 8.4 to 8.8.
• Performed data conversion during an upgrade process by creating/modifying new data mover scripts and SQR reports.
• Created new and customized existing Run Control Record definitions, Pages, Components and Process Definitions for running the SQRs online through Process Scheduler.
• Involved in identifying and analyzing requirements of Batch processing jobs and developed job schedules, custom scripts to check the Job conditions. Defined batch schedules for Accounts Receivable, Billing and Contract.
• Validated, compared and migrated several projects between instances and moved into production.

Environment: PeopleSoft8.8 SP1/8.4 (GL, AP, AR,Billing,Contracts,Projects,Grants), Oracle9i, PeopleTools, 8.44, 8,45.12 PeopleCode, PS/nvison, SQR, Application Engine, Crystal Reports 8.5, PVCS, UNIX, Windows NT, WebLogic 6.1.0.

Confidential, Janesville, WI

PeopleSoft Financials Technical Consultant

Responsibilities:

• Researched the existing system tables and business processes and identified the customizations necessary for upgrade.
• Conducted Business Fit gap analysis. Compared new release and business requirements, compared new release menu and pages, identified customizations, online processing, reporting and interfaces.
• Upgraded the existing Financial System, which involved removing of inconsistencies in database using SYSAUDIT and DDDAUDIT, generation and review of compare reports and System Audits.
• Involved with upgrading the PeopleSoft Security, Created Permission Lists, Roles and Users.
• Analyzed all existing customizations and customized the platform specific code.
• Analyzed the customizations to the delivered SQR reports and worked with the functional analyst to determine whether or not the customizations needed to be reapplied or dropped.
• Used Component Interface & File Layouts in Application Engine program to load the data from the flat file into the group control and pending item tables.
• Designed interfaces using Application Engine, PeopleCode, Process Scheduler and SQR
• Developed Unit Test Plans and executed the plans to test the individual components like pages and SQR programs
• Created and executed system integration and end-user acceptance test plans, ensuring expected system behavior in addition to software and data integrity

Environment: PeopleSoft Financials 7.53/8.1 and Windows NT.