We provide IT Staff Augmentation Services!

Sr. Peoplesoft Functional Consultant Resume

Roanoke, VA

Summary:

  • Over 7 Plus years of experience in the software analysis, design development, New implementation, Upgrade, customization and testing Of ERP, client/server, Data Warehouse and Enterprise Performance Management applications, for various clients in areas of Corporate, Consumer, Investment Banking, Hedge Funds, Auditing, Insurance, Commercial Real Estate and Public sector undertakings, which includes 5 Plus years of PeopleSoft Experience within United States. Extensively worked in implementations of PeopleSoft Financials and EPM applications ranging from versions 8.4 to 9.1
  • Expertise in technical role and good functional understanding during implementations, upgrades, interfaces reports development, conversion, migration, production support, operational procedures, scheduling, performance tuning, Application development and database solutions. Analyze and resolve support issues raised by the functional support team, guide and train support teams on new technology and functionality.
  • Industrial domains include Transportation, Healthcare, Financial Insurance and Construction.

Technical Skills:
Hardware : IBM PC Compatibles
Operating Systems : Windows 95/98/2000/NT, Ms-Dos, UNIX
Languages : SQL, SQR, PL/SQL, C and People Code
RDBMS : Oracle (8, 9, 10, 11) SQL Base, MS SQL Server and Sybase
GUI Tools : Forms 4.5 and Reports 2.5, Visual Basic, Autosys.
ERP Packages : PeopleSoft Financials.
People Tools : Application Designer, Security Administrator, Workflow.
Data Management Tools :Data Mover, Import Manager, Application Engine.
Reporting Tools : Query, Crystal, SQR, nVision, Tree Manager, Process Scheduler
Component Interface, Excel to CI, Application Messaging, Upgrade Tools : Upgrade Assistant.

Professional Experience:

Confidential, Roanoke VA. Nov 2011 - Till Date
Role: Sr. PeopleSoft Functional Consultant
Project: Implementation of AR, BI, ebilling modules in Peopletools 8.51 and Peoplesoft 9.1.

Description: This client is Advance Confidential, VA. This project Name ACC Advance Commercial Credit Project Create a Credit and Accounts Receivable organization. Replace all outsourced credit management functions with an AAP- managed solution that provides better, flexible customer service to sustain future growth. Implement PeopleSoft AR, Billing and GL modules.

Responsibilities:

  • Provided detailed test plans and technical documentation
  • Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
  • Developed Custom Billing Online Components to Review Billing Summary and Custom processed data.
  • Developed Enquiry page for Billing Invoices for Custom billing interface run.
  • Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and Scheduled the jobs through process scheduler.
  • As a offshore and onshore team coordinator for China, India and USA.
  • Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts
  • Involved in writing SQR, which moves data from ESI system to PO tables like PO_HDR,PO_LINE and PO_LINE_SHIP etc
  • Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR's & Online
  • Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports.

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, Washington DC Dec 2010 - Oct 2011
Role: Techno functional Consultant
Description: Confidential, financial applications are being implemented in PeopleSoft 9.1 Integrated Finance Organization Project. Working as Lead techno-functional specialist working on the design, development, build and testing of core interfaces and conversion, customizing new functionality based on the new chart fields after gathering the client requirements. Modules include GL, AP, PO, PC, AM, AR, BI.
Responsibilities:

  • Develop technical specifications based on the Functional requirement document.
  • Created technical specifications and built the online vendor attachments to be added at the vendor level.
  • Developed technical specifications and built the process using application engine and People Code for the inbound and outbound interfaces between the PeopleSoft and the Maximo for the Purchasing requisitions and the Purchase Orders.
  • Developed the technical specifications for the conversion of the existing projects, project activities, and project budgets, open purchasing documents, budgets, GL balances currently in the PeopleSoft financial database, the creation of grants sponsor/customers, the conversion or creation of grant awards, and the establishment of billed balances by customer contract.
  • Excellent experience in troubleshooting, debugging and tracing.
  • The scope of Projects for conversion includes open, existing projects including CIP, Rail Construction, ARRA, Reimbursable, and Safety & Security.
  • Developed technical specifications to provide MTA with the ability to perform a mass update of the Buyer field on the tables storing Items and Item Categories. The delivered functionality allows the Buyer field must be updated individually for each item and item category. If many updates must be made, it could take a significant amount of time to complete the effort.
  • Developed excel to CI component interfaces to mass update the buyer data for the items and the Item Categories.
  • Developed the custom SQR programs in addition to the delivered component interfaces for converting the existing data into PeopleSoft finance applications.
  • Developed pseudo code and unit testing procedures in the technical specifications for the development team.
  • Defined the system testing and integration procedures for System testing and User Acceptance testing.
  • Created test scripts and test scenarios based on the functional and the technical specifications.
  • Developed control reports, error reports and reconciliation reports for the interfaced and converted data.
  • Developed Data integrity reports to validate the orphan data in the PeopleSoft tables.

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, NJ Nov 2009 - Oct 2010
Role: Techno functional Consultant
Description: The project involves the implementation of QCare to PeopleSoft inbound interface for claims and revenues. The modules include GL, AP, PO, AM, PC.
Responsibilities:

  • Developed technical specifications based on the Business requirement document (BRD).
  • Created user manual for the end users on the QCare to GL interface process for claims and premiums.
  • Developed extract programs using sqr to send outbound and inbound GL and AP data from PeopleSoft programs to external systems QCare Claims and Revenue system.
  • Performed data mapping of the external systems to PeopleSoft data.
  • Developed user based online PeopleSoft mapping rules pages for the interfaces.
  • Created custom records, pages, components for holding the mapping rules online.
  • Created application engine program to load the mapping rules from the external files from QCare Claims system.
  • Developed sqr programs which are executed on the remote applications (QCare) to improve the performance.
  • Created partitions to improve the performance.
  • Created different types of Oracle Partitions and sub partitions such as Range Partitions, Hash Partitions, and Composite range harsh partitions.
  • Developed pages, components and application engine programs to create and maintain the partitions thru online PeopleSoft as part of the production maintenance.
  • Fine tuned the long running custom application engine programs.
  • Tuned the custom sqr programs to improve the performance adopting the load lookup tables and the array concepts.
  • Fine tuned the custom queries to improve the performance.
  • Improved the performance of the online application pages.
  • Excellent experience in troubleshooting, debugging and tracing.
  • Involved in performance tuning of the Application Engine programs.
  • Developed error reports and reconciliation reports to track the errors and reconcile the source and target data.
  • Supported the end users in providing the queries and assisted in testing of the interface in UAT.
  • Coordinated with the DBA in migrating the PeopleSoft projects from development to SIT and UAT and Prod.

Environment: PeopleSoft 9.0, Oracle 10G, Windows 2000/NT/UNIX

Confidential, NY Aug 2007 - Oct 2009
Role: PeopleSoft Techno Functional Developer
Description: Confidential, engages in Agency/Brokerage, Capital Markets and Client Solutions. Cushman & Wakefield Sonnenblick Goldman is a global leader in real estate financial services, providing highly specialized debt structuring, debt and equity placement, hospitality financing and sales, note sales and associated advisory services. As a lead developer involved in several developmental activities, Conversions, interfaces, migrations, Testing and Performance tuning. Modules include GL, AP, EX, AM, PC.
Responsibilities:
Interfaces/Conversions:

  • Developed custom interfaces using App Engine program to load the data from the external AS400 Commissions System into PeopleSoft Applications such as Outside Brokers Payroll
  • Developed ADP Journals Import Custom process to load the Journals Accounting Entry Data into PeopleSoft General Ledger such as Cash Broker Payroll and Corporate payroll etc.
  • Developed Independent Contractor payroll process custom interfaces using App Engine program to load the data from the external AS400 Commissions System into PeopleSoft Applications.
  • Developed custom sqr process to capture the currency exchange rates from Bloomberg into PeopleSoft and send the rates from PeopleSoft to Outlooksoft.
  • Automated the existing month end interfaces in PeopleSoft for the Operations.
  • Developed the interface which runs on a daily batch schedule to load the projects into the PeopleSoft tree.
  • Developed custom sqr and application engine programs to convert the historical data into PeopleSoft financial applications.
  • Developed control reports, reconciliation reports and data integrity/validation reports for the conversion data.
  • Customized the delivered ACH/EFT payments process to fit in the business requirements.
  • Customized the delivered Positive Payment creation process (Crystal Check) to generate the file to be sent to the chase bank.
  • Worked on the pay cycle process.
  • Developed application engine program to load the incoming check reconciliation data from the CITI and the Chase banks into the PeopleSoft Bank statement tables.
  • Customized the delivered (Pay cycle) Payment selection and creation process.
  • Developed application engine program using PeopleCode to extract the AMEX data from PeopleSoft expense data to generate the file to be sent to the American Express.

Performance Tuning/Reports:

  • Developed summary, detail and comparative Income Statement and Balance Sheet reports using PeopleSoft nVision.
  • Created new layouts, report requests, scope definitions, and used Report books to run the reports.
  • Developed Expense Open Liability Report.
  • Developed Summary and Detail Payment History report, Positive Payments Report and the Voucher register Reports in Accounts Payable.
  • Developed Expense Report Detail Report and Expense reports by Business Unit in Travel and Expense Module.
  • Customized the delivered check printing crystal report according to the business requirements.
  • Developed multiples reports in General Ledger such as Ledger Verse Journal Integrity report, Custom GL Activity Report for AP/EXP all accounts by Department Id.
  • Developed custom Trial balance Report.
  • Modified the existing check printing Crystal report
  • Worked on resolving the performance issues and fine-tuning of the Query/SQR programs.

Migration/SIT/UAT, Testing and Production Support

  • Explained the delivered PeopleSoft reports and their functionality to the end users.
  • Provided 24/7 after hours support during the month end closing as and when necessary.
  • Provided Level 3 support.
  • Migrated PeopleSoft projects, objects, configuration data and various other components of the application into multiple database instances.
  • Data Quality issues and day to production issues.
  • Performed smoke/unit test to make sure the process and online applications are working per the requirements after the migration.
  • Created Test requirements documents based on the functional specifications.
  • Developed test cases and test scenarios based on the testing requirement documents.
  • Performed negative testing to ensure the functionality as per the user requirements.
  • Performed system integration testing and supported the end users in user acceptance testing.
  • Tested the Online customizations.
  • Documented and tested the PeopleSoft Batch process, inbound and outbound interfaces etc
  • Tested the Reports for Data validations and reconciliation reports.

Configuration:

  • Performed fit/gap analysis and system configuration.
  • Configured the business units, banks, pay cycles for Voucher Payments and vendors etc.
  • Changed the fixed assets depreciation calculation from Half Year Convention to Following Month for Straight Line method.
  • Documented and designed the technical specifications for interfaces, reports, data conversion and validation.
  • Worked with the end users and gathered information for designing the specifications for Vendor/Customer setup, Business Unit setup, EDI file etc.

Environment: PeopleSoft 9, SQL Server, Windows 2000/NT/UNIX

Confidential, VA Dec 2006 - July 2007
Role: PeopleSoft Technical Developer
Description: Confidential, offers traditional term life insurance, universal life insurance and term life insurance with that of premium options. The project deals with interface/Conversion & Performance tuning. The modules include General Ledger, Accounts Payable, and Accounts Receivables.
Responsibilities:

  • Developed custom interface using App Engine program to load the data from the external legacy billing system into PeopleSoft Accounts Receivable.
  • Used Application Engine to convert the historical data from the legacy system into PeopleSoft AR.
  • Customized the delivered ACH/EFT payments process to fit in the business requirements.
  • Customized the delivered Positive Payment creation process (Crystal Check) to generate the file to be sent to the chase bank.
  • Keeping trace, debug options and researching the trace file to isolate the issue.
  • Developed application engine program to load the incoming check reconciliation data from the CITI and the Chase banks into the PeopleSoft Bank statement tables.
  • Customized the delivered (Pay cycle) Payment selection and creation process.
  • Developed application engine program using PeopleCode to extract the AMEX data from PeopleSoft expense data to generate the file to be sent to the American Express.
  • Developed summary, detail and comparative Income Statement and Balance Sheet reports using PeopleSoft nVision.
  • Created new layouts, report requests, scope definitions, and used Report books to run the reports.
  • Tested the Online customizations.
  • Tested the Reports for Data validations and reconciliation reports.
  • Involved in performance testing and fine-tuning of the Query/SQR programs.

Environment: PeopleSoft 8.9, Oracle, Windows 2000/NT/Unix

Confidential, NY Jan 2006 - Nov 2006
Role: PeopleSoft Techno Functional Consultant
Description: Confidential, a Fortune 500 company headquartered in Pleasanton, California, is the nation\'s second largest off-price retailer. The objective of the project is to present a feasible and cost effective solution to help ROSS resolve the current issues in the areas like PO, Account Payables, GL, AR and Billing. This project mainly involved Development and Enhancements of PeopleSoft Finance 8.4
Responsibilities:

  • Involved in user enhancement of people soft financials (PO,AP,AR and Billing) utilizing people tools and crystal reports
  • Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts
  • Involved in writing SQR, which moves data from ESI system to PO tables like PO_HDR,PO_LINE and PO_LINE_SHIP etc
  • Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, COBOL, SQR's & Online
  • Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports
  • Conducted training Sessions on developing SQR, People Code and Application Engine, troubleshooting using SQR flags, People Code Debugger and Application Engine Trace
  • Customized the Component Interface program to load the data into additional tables
  • Worked on PeopleSoft Application Server Architecture and enterprise architecture
  • Experience with agile development methodologies
  • Provided detailed test plans and technical documentation
  • Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
  • Developed Custom Billing Online Components to Review Billing Summary and Custom processed data.
  • Developed Enquiry page for Billing Invoices for Custom billing interface run.
  • Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and Scheduled the jobs through process scheduler.
  • Provided Post implementation support as per the user requirements

Environment: PeopleSoft Finance 8.9, People Tools 8.42, PL/SQL, Oracle 8i

Confidential, India Jan 2004 - Dec 2005.
Client: Confidential, NY
Peoplesoft Financial Technical Developer
Description: Confidential, provides AAA financial guaranty insurance for asset-backed securities, municipal bonds and other structured obligations in the global markets. The modules include GL & Accounts Payable.
Responsibilities:

  • Lead developer in implementation and development of FP Accounting System.
  • Responsibilities included design, development, documenting and user requirements gathering for writing the technical specifications for interfaces, conversion and reports including migration.
  • Developed application engine programs to extract and interface data from PeopleSoft to be used by other subsystems.
  • Developed interface program to generate the profit and loss reports, Balance Sheet reports and trial balance reports for the trading operations for the ASSETS and GICS, SWAP's and FUTURE's in tab delimited.
  • Worked with functional team during the setup and configuration of the Journal Generator templates.
  • Participated in fit/gap analysis and system configuration.
  • Tested the Online customizations.
  • Documented and tested the PeopleSoft Batch process, inbound and outbound interfaces etc
  • Tested the Reports for Data validations and reconciliation reports.
  • Involved in performance testing and fine-tuning of the Query/SQR programs.
  • Data Quality issues and day to production issues.
  • Designed and developed the summary and the detail trees for the reporting.
  • Developed custom ledger templates, defined ledger sets, configured the ledgers for A business unit as a part of the ledger and summary ledger setup.
  • Developed queries/crystal, nVision report layouts, report requests, report books and scope definitions and also developed cross tabular reports using Crystal where PS nVision could not be used to develop the reports as there are certain limitations to nVision.

Environment: PeopleSoft 8.4, Sybase, Windows 2000/NT/Unix

Academics:
Master in Computer Applications

References Available on Request

Hire Now