Senior Peoplesoft Consultant Resume Profile
Houston, TX
SKILLS SUMMARY
- 9 years of experience in customization, enhancement and support the development of various PeopleSoft application modules in FSCM, HCM, and CRM.
- Expertise in PeopleSoft Application Designer, PeopleCode, Application Engine, File Layout, PS Query, Application Packages, PeopleSoft Integration Broker, SQL Query, Data Mover, and SQR
- Designed, developed and delivered few tools for PeopleSoft Technical team to enhance the production support and maintenance.
- Experience in PeopleSoft FSCM Payables, Purchasing, Strategic Sourcing, Financial Gateway , PeopleSoft HCM Compensation, Workforce Administration, Self Service , PeopleSoft CRM Customer, Tasks, Opportunity, Order and Quotes .
- Extensive Experience in PeopleSoft PeopleTools.
- PeopleSoft certified Application Designer
- Working directly with PeopleSoft Functional support teams
- Designed Tools which help PeopleSoft Technical and business team in working with PeopleSoft objects in support phase.
- Possesses strong trouble shooting and problem solving skill
- Mentored and assisted other programmers in developing applications.
- Trained on PeopleSoft Installation, Server Configuration and Oracle Database configuration for PeopleSoft
- Possess excellent communication and presentation skills. Ability to grasp new technologies and applications and excel in the deliverables
- Experienced with PeopleSoft Integration technology, Workflow, and Mobility approval.
- Engaged in learning PeopleSoft FSCM 9.2 Purchasing and Payables upgrade functionality.
TECHNICAL SKILLS
Operating Systems | Windows 98, 2kP, XP |
Languages | C, C , Java, HTML, JavaScript, J2EE, VC , VB |
Database | Oracle 11g, IBM DB2, MYSQL |
ERP Applications | PeopleTools 8.1, 8.48, 8.49, 8.52 |
ERP Modules | PeopleSoft FSCM Payables, Purchasing, Strategic Sourcing, Financial Gateway , PS HRMS Workforce Admin, Self Service, Manager Self Service, Benefits, Benefits Admin PS CRM Customer, Tasks, Opportunity, Order and Quotes |
Reporting Tools | SQR, Crystal Reports |
Application Tools | People Code, Application Designer, Application Engine, Data Mover, Security, Query Manager, Component Interface, App Package, Integration Broker, AWE, BI Publisher |
Project Management Tools | Quest STAT |
Professional Experience Summary
Confidential
Role: Senior PeopleSoft Consultant
Responsibilities:
- Assigned as a dedicated resource for PeopleSoft AWE issues and enhancement.
- Involved in implementing the Financial Gateway for the client with Wells Fargo and Chase banks.
- Involved in supporting the client's Integration systems with PeopleSoft application and new integration requirements.
- Involved in solution design for enhancements.
- Involved in developing the solution for the fixes.
- Involved in preparing Technical Functional documents.
- Involved in reviewing and suggesting changes on teammates fixes for effective solution.
- Created the Financial Gateway interface for Wells Fargo Domestic/International Wire ACH payments.
- Created a complex month-end process to create accrual journal lines for all open vouchers, which are not posted/matched/paid.
- Created email notification processes for Procurement Contracts, to intimate bidders with the status and agreement details, when Sourcing events are awarded to Contract
- Created a custom process to validate any non-distributed transactions exists in all financial subsystems, before user plan to inactivate the cost center/department.
- Created a complex process and customization to create multiple schedules for Purchase order to manage split payments if the Purchase Order cost is in millions.
- Created Project procurement matrix and notification to allow user to search the procurement status based on Projects/Dept IDs.
- Designed and delivered Project Costing mobility approval enhancement, which allows users to approve the Project workflow using smartphones
Environment: PeopleSoft FSCM 9.0, PeopleTools 8.52, Oracle 11g
Confidential
Role: PeopleSoft Team Lead
Responsibilities:
- Proposed idea to integrate Attachment functionality exists in PeopleSoft FSCM modules where use can access the utility to upload set of files at one short and the attached files to be viewed in the corresponding PeopleSoft component.
- Mentoring the team members in data collection from all module attachments functionality.
- Designing the utility framework for all setups required to integrate the utility with modules' attachment functionality.
Environment: PeopleSoft FSCM 9.2, PeopleTools 8.54, Oracle 11g
Confidential
Role: PeopleSoft Team Lead
Responsibilities:
- Proposed idea to produce the Application Engine design in PeopleSoft runtime environment
- Designed the tool to access Application Engine program in PeopleSoft Internet Architecture PIA as same as it looks in Application Designer
- Trained junior resources in PeopleSoft technology and monitored them in their deliverables and guided them for efficient design
- Lead the team to produce the PeopleCode and SQL present in the Application Engine
- Received appreciation for the innovative idea and design output.
Environment: PeopleSoft FSCM 9.0, PeopleTools 8.52, Oracle 11g
Confidential
Role: PeopleSoft Team Lead
Responsibilities:
- Proposed idea to build modular architecture view for SQR linear programming
- Designed the tool to access SQR program in PeopleSoft Internet Architecture PIA with modular view for different sections in SQR program
- Trained junior resources in PeopleSoft technology and monitored them in their deliverables and guided them for efficient design
- Lead the team on logic design for back-end processing
- Received appreciation for the innovative idea and design output.
Environment: PeopleSoft FSCM 9.0, PeopleTools 8.52, Oracle 11g
Confidential
Role: Application Programmer
Responsibilities:
- Involved in System Analyst role for the client
- Involved in analyzing providing solutions for the issues
- Involved in finding the root cause for the production issues
- Involved in solution design for enhancements.
- Involved in developing the solution for the fixes
- Involved in preparing Technical Functional documents
- Played the role of System Analyst for Scholastic Book Fairs division
Environment: PeopleSoft CRM 9.0, People tools 8.49, Oracle 9i
Confidential
Role: Application Programmer
Responsibilities:
- Playing the role as Tech team lead for the enhancement and support team
- Involved in analyzing and provide the solution for issues
- Involved in finding the root cause for fix, enhancement and process improvement
- Involved in developing the solution for the fix
- Involved in creating Unit test plan for the code fix raised with Production Bugs
- Involved in Preparing Functional and Technical Specification Doc
- Involved in supporting the processes scheduled in Production
- Involved in developing tuning Out-of-Balance automation tool.
Environment: PeopleSoft Finance 8.4 AP, People tools 8.45, Oracle 9i
Confidential
Role: Technical Consultant
Responsibilities:
- Involved in analyzing and provide the solution for the functional design
- Involved in Interface development with PS CRM to create Order and all related information for the legacy OM 400 system's order.
- Involved in analyzing the possible methods to satisfy the client needs for the process with better performance.
- Involved in preparing technical design and Unit test case document
- Involved in IB setup Services, Service Operation, Nodes, Messages, Routing Info .
Environment: PeopleSoft CRM 9.0, People tools 8.48, App Package, CI, Integration Broker and Messaging, Oracle 10g.
Confidential
Role: Techno-Functional Consultant
Responsibilities:
- Involved in analyzing and provide the solution for issues
- Involved in finding the root cause for fix, enhancement and process improvement
- Involved in developing the solution for the fix
- Involved in creating Unit test plan for the code fix raised with Production Bugs
- Involved in Preparing Functional and Technical Specification Doc
- Involved in supporting the processes scheduled on daily basis
- Involved in ADP Payroll Process for China, reconciliation of rejected data from ADP interface during payroll run.
Environment: PeopleSoft HRMS 8.9 Portal , People tools 8.47, App Engine, Oracle 10g.
Confidential
Role: Technical Consultant
Responsibilities:
- The project involves outsourcing the Global Payroll system of Standard Chartered bank to ADP. Our work involves developing the interface from Standard Chartered bank PeopleSoft to ADP SAP .Initially it is going to get implemented in Singapore, China and Hong-Kong and later to spread across 80 countries.
- Designing the functional and technical setup of a Cross Component Interface to map the fields and field values in PeopleSoft to SAP. The design involved creating configuration mapping tables and pages in PeopleSoft which acts as a data configuration for the data-mapping with SAP system.
- Designing the functional design, technical design and coding for Initial Load Specification for all master data of the employees to be loaded to ADP for initial setup in SAP system.
- Designing the functional design, technical design and coding for Subsequent Load Specification for all payroll transaction related data of the employees to be loaded to ADP for payroll process between two dates.
- Involved in attending the country workshops, requirements gathering, fit-gap analysis, and various phases of design setup.
- Involved in preparing test case and in Unit Testing, UAT for the interface.
- Prepared functional, technical and User manual documents for the interface.
Environment: PeopleSoft HRMS 8.9, People tools 8.47, App Engine, Oracle 10g
Confidential
Role: Techno-Functional
Responsibilities:
- Involved in the resolving the technical and functional issues related to AP, AR and AM
- Involved in performance tuning of SQRs and Application Engine processes.
- Involved in DBA health check
- Deployed process between instances and granted permissions.
- Extensively developed and deployed a SQR report for Purchase Order register
- Involved in Unit Testing and System Testing
- Involved in PS Admin task for granting securities to users by roles and permission lists.
Special Mention Performance Tuning
- Involved in tuning the Payment Predictor process with 96.87 performance improvement
- Involved in process enhancements of Invoice Upload, Fixed-Asset Register
- Prepared test cases for Receipt Upload Interface
Environment: PeopleSoft Finance 8 sp1, People tools 8.16, SQR, Crystal Reports, PS Query, PS Security, Oracle 8i, Windows NT, AP, AR and AM.