We provide IT Staff Augmentation Services!

Peoplesoft Techno Functional Consultant Resume

Detroit, MI

PROFESSIONAL SUMMARY:

  • Around 8+ years of experience in Implementation, Upgrade and Development of PeopleSoftFinancials modules like General Ledger, Account Payables, Accounts Receivable, Purchasing, ePro and Billing.
  • AR/Billing Functional SME assistingwith conversion of Accounts Receivable fromLawsonto PeopleSoft.Duties include configuration of Billing and AR for the new Business Units, advising on Customer conversion, Training of end users, and advising on Business Process changes.
  • Peoplesoft 8.9 to 9.1 Upgrade - Fit Gap analysis, creating functional and technical design documents, configuring new functionality, developing/retrofitting HR, Payroll, Benefits self service and MSS applications.
  • Excellent Knowledge of PeopleSoft Financials (GL, AP, AR, AM) PeopleSoft Distributions (Billing, Purchasing, Inventory and Order Management),e Supplier, Travel and Expense and Asset Management and PeopleSoft Project Costing, Contracts, , and Travel & Expenses modules.
  • Extensively worked on Application Designer, People Code, Application Packages Application Engine,AWE, Security, Portal, Query, File Layout, Process Scheduler, Tree Manager, Data Mover, Custom Interface and Reporting tools (SQR andBI Publisher).
  • Extensively used SQL and PL/SQL for writing Stored Procedures, Functions, Triggers and Packages.
  • Currently working on upgrading PeopleSoft AP & GL from 9.1 to 9.2 which include Fit-Gap analysis.
  • Used Job, personal data, employee tax data, Time and Labor component interfaces to insert the employee related data into PeopleSoft using Integration Broker custom messages
  • Providing technical assistance to Tribal 638s and precise interpretation of the ACA as mandated.
  • Strong understanding of RDBMS concepts and experience in database design and development.
  • Configured the Payment Terms, EntryTypes, LetterCodes, Aging ID, Statement ID in AR module
  • Expertise with PeopleSoft FSCM 9.2; 9.1; 8.9; 8.x and People Tools 8.51; 8.50; 8.48; 8.47, 8.49 in changes assistant.
  • Experience spans in developing and analyzing requirements of various HR modules like Core HR, Base Benefits, Ben Admin, NA Payroll in of Business Systems Analyst and various Consulting roles with diverse clients. Having good experience on benefits and payroll.
  • Worked With GPI Team in Data Mapping and Data Cleanup of AP Vendor and Historical Payables Data.
  • I have worked in various Implementations, Upgrade & Support projects of PeopleSoft FSCM 8.8 to 9.2
  • Used to PeopleSoft Application Designer's Project Copy functionality to copy integration metadata between PeopleSoft databases.
  • Experience developing complex interfaces into legacy and 3rd party systems
  • Experience in SQL and PS/Query for reviewing data, troubleshooting and testing/validating source system data.
  • Responsible for filing 1095­C and 1094­C tax forms for "escalated" and "top 100 revenue" Paychex clients that met the Affordable Care Act requirements established by the IRS
  • Expertise in Business Analysis, Business Technology Optimization, Process Management, Software Design, Analysis, Data Modeling and Testing of PeopleSoft solutions.
  • Extensive experience in documenting Use Cases, Business Requirements Document(BRD), FunctionalSpecificationsDocument(FSD),Test Specifications/Plans, and UI Navigation Documents.
  • Excellent skills in Development of applications using SQL, PL/SQL, Oracle Database 11g, 10g, 9i. DB2. Having good understanding of Workflow, SOAP, Web Services, and Enterprise Portal.

TECHNICAL SKILLS:

Operating Systems: UNIX, DOS, Windows XP, Windows NT, Windows 98.

Languages: People Code, HTML, PL/SQL, SQR

People Tools: 8.48 to 8.55 -Application Designer, Data Mover, Process Scheduler, Import Manager, Workflow, Application Engine, Application Security.

PS FSCM Module: General Ledger, Accounts Payable, Accounts Receivable, e-procurement, Purchase Orders, Billing, Asset management, Inventory,Projects Costing.

Development Tools: Application Designer, People Code, Data Mover, Application Engine.

Reporting Tools: SQR, PS/query, BI/XML Publisher, PS/n vision.

Testing Tools: HP Quality center(QLM),PTF

Databases: Oracle, MS SQL 7.0, SQL Base and MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

PeopleSoft Techno Functional Consultant

Responsibilities:

  • Involved in all stages of Upgrade of PeopleSoft FSCM from version 9.1 to 9.2
  • Developed technical specification documentation for the new changes brought out in version 9.2
  • Executed and prepared test scripts for Integration Broker (xml messages) to load datafrom third party systems (Ops Technology) to AR/BILLING modules.
  • Train client contact on ACA product and provide “Tier 2” level support to clients on daily issues and attend client meetings to review functionality issues and roll out discussions
  • Conducted multiple Fit Gap Analysis sessions and analyzed upgrade compare reports to identify and document existing customizations
  • Involved in Retrofitting of several customized objects like Application Engines, SQR's in the process of upgrade.
  • Worked in interfacing with HCM PeopleSoft HR, GL, Personnel Data through PeoplSoft FSCM using Integration Broker
  • Involved in customization and gathering requirements discussing with users and team members about planning and development in particular time frame. As a BA consultant communicating between client and team members.
  • Solution design for replacing multi instance/ multi product legacy FSCM System with PeopleSoft 9.2

Environment: PeopleSoft FSCM 9.2, People Tools 8.52, People Code, SQR, Application Engine, Component Interface, PS Query, n vision, XML Publisher, Application Designer.

Confidential, Arlington, VA

PeopleSoft Techno Functional Consultant

Responsibilities:

  • Actively involved in all stages of Upgrade of PeopleSoft FSCM from version 9.1 to 9.2.
  • Developed technical specification documentation for the new changes brought out in version 9.2
  • Train and support new employees on processes, questions, and concerns that arise and serve as the Lead Point of Contact when the Supervisor is out or unavailable
  • Reviewing business requirements and designing, building and testing solutions that satisfy those requirements.
  • Required to create Functional/Technical Specification documents for the proposed solution.
  • Developing in PeopleSoft Accounts Payable and e Procurement/Purchasing.e Supplier, e Settlement, Strategic Sourcing, Travel and Expense and Asset Management.
  • Responsible for reading a Requirements document and putting together a Technical Design document.Experience in working Production support environments.
  • Developed so many app engine programs, wrote People Code to modify the functionality and developed pages menu’s and components, records in front end
  • Worked on number of requirements in PO, AP, AM, Inventory, eProcurement modules developed technical and functional requirements.
  • Developed various application engine programs to notify the nightly batch job status to the respective team members.
  • Worked in PeopleSoft security including creating and managing user roles, permission lists, user profile management.
  • Generating a list of setup tasks for your organization based on the features of implementing.
  • Create detailed technical documentation.
  • Ability to create design solutions.Involved in customization and gathering requirements discussing with users and team members about planning and development in particular time frame. As a BA consultant communicating between client and team members.
  • Thorough understanding/experience of technical tools like SQR, app designer, PeopleCode and App Engine.
  • Developed and customized People Code, Pages, Customs, Custom interfaces, and Application engine, Approval workflow engine (AWE), Integration Broker, and Application Packages.

Environment:PeopleSoft Financials 9.2, People Tools 8.52, People Code, SQR, Application Engine, Component Interface, PS Query, nVision, XML Publisher, Application Designer.

Confidential, Jersey City, NJ

PeopleSoft Techno Functional Consultant

Responsibilities:

  • Involved in all stages of Upgrade of PeopleSoft FSCM from version 8.8 to 9.1.
  • Developed technical specification documentation for the new changes brought out in version 9.1.
  • Conducted multiple Fit Gap Analysis sessions and analyzed upgrade compare reports to identify and document existing customizations.
  • Prepared Functional and Technical specifications, Unit Test scripts, training materials.
  • Involved in Estimating project hours for technical design, development and testing.
  • Gathered requirements from business partners and provided fit/gap details and suggested customizations based on requirements.
  • Worked in PeopleSoft security including creating and managing user roles, permission lists, user profile management.
  • Worked in designing and implementing security across PeopleSoft applications including PeopleSoft Portal..
  • Developed custom Application Engine process to load Payables data into to payables interface tables.
  • Worked on Procurement complete control and oversight of contingent labor and outsourced services spending. Step-by-step online processes provide the necessary tools to increase both efficiency and cost savings by managing external workers and service providers via statement of work projects, deliverables-based services.
  • Developed Integration Broker handler PeopleCode for request and reading response.
  • Set up Integration Broker services (such as, Messages Queue, services and service Operations etc) for automatic updates between HR and FIN applications.
  • Designed and developed billing interface from custom application in HRMS system to PeopleSoft financials using integration broker and component interface.

Environment: PeopleSoft FSCM 9.1, People Tools 8.52, People Code, SQR, Application Engine, Component Interface, Integration Broker, PS Query, nVision, XML Publisher, Application Designer, EDI Manager, UNIX, Oracle 11g.

Confidential

PeopleSoft Consultant

Responsibilities:

  • Modified the Journal Status Inquiry to retrieve journal lines associated with the Business Unit of the Journal selected in GL.
  • Developed Purchasing Interface using File Layout, Application Engine, and Component Interface, which loads feed data into staging tables while doing various data validations using Application Engine People Code and finally loads into PeopleSoft tables through Component Interface.
  • Modified PeopleSoft delivered Purchase Order SQR program. Customization developed an interface using Application Engine and Component Interface to convert all open vouchers from legacy system in to PeopleSoft Accounts Payable.
  • Done for printing the Ship To Comments at the Ship To Label, which is used for printing the address.
  • Worked on Procurement complete control and oversight of contingent labor and outsourced services spending. Step-by-step online processes provide the necessary tools to increase both efficiency and cost savings by managing external workers and service providers via statement of work projects, deliverables-based services.
  • Migration of customizations like Record Definitions, Pages, Components, Run Control Pages, Portal Registries, A.E Programs and Component Interfaces for all modules.
  • Developing new components, pages, records and People Code customizations added.
  • Migration and upgrade the customized people code on various record events.
  • Developed Custom Invoice Print SQR .
  • Setting up of process definitions and process scheduler jobs for various processes.
  • Extensively Worked with PS Query tool for constructing the Queries.

Environment: PeopleSoft Financials/SCM 8.4/8.9 (GL, AP, PO, AR, BI), Peopletools 8.42/8.46, PeopleCode, SQR, PS Query, SQL Server.

Confidential

PeopleSoft Techno functional Consultant

Responsibilities:

  • Did FIT/GAP analysis against Lotus Notes to PeopleSoft Time & Labor and identified the Fits and Gaps.
  • Functionally proficient in Implementation, Customization, Maintenance, Interfacing, Reporting, Data Conversion, Integration Broker between Project Costing and T&L modules, Upgrade, Maintenance, 1099 Processing Production Support and Testing.
  • Changed the Customer Balance Interface in AR to Exclude certain Business Unit data from the Output File
  • Produced Scripted-Demo document and presented to business users.
  • Written Functional design specs including the TimeAdmin and Load process running strategy following the deadline requirements.
  • Generating a list of setup tasks for your organization based on the features of implementing.
  • Used to PeopleSoft Application Designer's Project Copy functionality to copy integration metadata between PeopleSoft databases.
  • Identified the issues in AWE and applied bundles #7 and #8.
  • Designed and developed various customizations based on Integration Broker Class and SOAP and XML script.
  • Developed outbound interface SQRs for Benefits module to extract benefit/insurance information from PeopleSoft tables and send to respective vendors.
  • Worked on Custom TPAR, PAR modules and wrote several complex SQL’s.
  • Using Application Messaging and App Engine (batch process) synchronized the Department data between HR and Finance environments.

Environment: People Tools 8.51, FSCM version 9.1, Lotus Notes, Application Engine, Application Messaging, Workflow, People code, STAT.

Hire Now