Senior Consultant - Peoplesoft Finance Resume
3.00/5 (Submit Your Rating)
Nyc, NY
SUMMARY:
- 6+ years experience implementing, developing, configuring and supporting PeopleSoft Financials/Supply Chain, HCM suite of applications (AP,GL, PO, AM, AR, Travel & Expenses, Billing, Inventory, ePro, HR, Payroll, Benefits, Time &Labor).
- Proficiency working with People Tools, Application Designer, People Code, SQR, Component Interface, PS Query, XML/BI Publisher, Data Mover, Integration Broker, Application Package, Web Services, AWE Workflows and File layouts.
- Extensive experience with several stages of the system life cycle, including defining business requirements, Fit gap Analysis, configuring, development, Testing, conversion, end - user, functional and technical documentation and production support.
- Expertise in PeopleSoft - from version 8.8,9.0,9.1 and 9.2 and People Tools - from 7.5 to 8.5x - Application Designer, Application Engine, Upgrade Assistant, Maintain Security, File Layout, Component Interface, Process Scheduler, PS Query and Data Move.
- Involved in Upgrade of PeopleSoft HCM from version 9.1 to 9.2 and performed impact of changes with the technical teams.
- Design, and development and testing of various PeopleSoft modules such as GL, Order to Cash process, Purchase Order.
- Experience in business-related project milestones such as in Requirements Gathering, Data Modeling (logical and physical design of databases), Business Gap Analysis, Unit/ Integration Testing, Data Migration, User, and System Maintenance.
- Hands-on configuration of PeopleSoft Financial modules (GL, KK, AP, AM, PO, AR, BI) as well as for assisting clients in the selection, implementation and support. Leading clients through design workshops and validation, configuration, testing, deployment cycles. Solid understanding of fit/gap analysis requirements for Workflow implementations.
- Functional lead and support of the Oracle Financial project, which included GL, AR, AP, Purchasing, and Inventory. Provided fits and gaps business analyses, user tests, system tests, trouble shootings and post-production support.
- Advanced knowledge and experience which includes End-End Implementation, Upgrade, Legacy to PeopleSoft Conversion, Integration between PeopleSoft Finance and third-party system, Customization- Enhancement and Production Support in various PeopleSoft Financial (FSCM) applications.
- PeopleSoft Consultant with sophisticated technical skills in the areas of Application Designer, Application Engine, Component Interface, Data Mover, People Code, Application Packages, Integration Broker and Workflow developer tools.
- Hands-on experience in Requirements Gathering, Data Modeling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User, and System Maintenance.
- Strong Functional experience in PeopleSoft financials 9.2, 9.1, 9.0, 8.8, 8.4, 8.3, 8.0, 7.5, 7.0 and experience in analysis, design, and development and testing of various PeopleSoft modules such as GL, Order to Cash process, Purchase Order
- Experience in PeopleSoft FSCM and used Application Designer, UNIX shell scripting, HTML/ DHTML, People Code, SQR, Application Engine, Application Package, Crystal Reports, Integration Broker, Component Interface, JavaScript and Oracle (creation of complex SQL, Query optimization, creating database triggers, creation packages and procedures) from version 10/11g.
- Worked on Fixed Asset Version 8.9 and application life-cycle implementation experience including Global Support Center.
- Good knowledge of whole PeopleSoft Enterprise Portal functionality to do impact analysis for any customizations.
- Involved in requirements gathering, technical/functional design and testing file layouts for interfaces and Application Engine programs in AP, eProcurement, Purchasing and General Ledger modules.
- Excellent knowledge of PeopleSoft Financials 9.2 modules, including Account Payables, General Ledger, Purchasing, ELM, Accounts Receivables, Billing, Inventory, Order Management, Asset Management, Project Costing modules as Functional Analyst.
SKILLS:
FSCM, General ledger, accounting, billing, accounts payable, accounts receivable, purchasing, procurement, order management, project coding, contract, expenses, asset management, data mover, application upgrade.
PROFESSIONAL EXPERIENCE:
Senior Consultant - PeopleSoft Finance
Confidential, NYC, NY
Responsibilities:
- Project Management and lead role managing and implementing Claim Management, PeopleSoft and Warehouse Distribution Software experience in various industries including Health Care, Financials, Insurance, Manufacturing
- Extensive experience with analysis, design, development, customization's, implementation, Support and upgrade of software applications including ERP applications.
- Experience in converting data from legacy systems to PeopleSoft 7.0 thru 9.2
- Proficient in analyzing and translating business requirements to technical requirements and architecture.
- Strong database skills (SQL server, Oracle, DB2 and Postgres databases), Object Oriented Programming and development knowledge
- Good communication skills, interpersonal skills, self-motivated, quick learner, team player
- Dedicated, creative and self-reliant
- Strong on Reporting Tools like BI Publisher, SQR, Crystal Reports and PS/Query
- Lead Fit/Gap analysis of the Finance processes in the PeopleSoft Version 9.2 and identified the customizations that needed to be carried forward.
- Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
- Have good understanding of Functional aspects of various modules in PeopleSoft Financials - GL, AP, eProcurement, Travel & Expenses
- Proficient in store procedures, data archiving
- Worked on archiving more than 2 billion rows of Data at Security Benefit.
- Built complex SQL and performed performance tuning.
- Worked on end to end user & system testing of financial & SCM. Testing involved agile process.
- Work also involved creating data for testing using sqlgZ6 test scripts.
- Successfully completed numerous full lifecycle implementations of various software packages.
- Senior Supply Chain Consultant at PeopleSoft Inc, Westchester, IL USA ( ).
- Designed and developed innovative Processes and Methodologies to provide large organizations with required implementation efficiencies.
- Worked closely with business users for requirements analysis, created design solutions to meet business requirements to eliminate non-PeopleSoft sub-systems which are mostly store procedures.
- Involved mostly in all implement/upgrade activities of PeopleSoft SCM & Finance (AP, GL, PO, ePro) system from different versions of people soft (starting at people soft 7.0 thru 9.2)
- Establish Gaps as per Client requirements and develop Functional Specs required for necessary enhancements to the People soft functionality.
- Designed and Developed several SQRs to create interfaces/load files as well as initial load of data
- Worked on resolving application engine performance issues to perform set processing instead of individual record processing thus improving performance and cut down processing time.
- Involved in developing Integration broker messaging technology to load POs in core PO system from ePro.
- Developed lot of complex PS queries in SCM and Financials.
- Developed several application engine programs to load data from different feeding system to PeopleSoft.
- Developed integration broker messages between HR and Financials to exchange data
- Designed and Developed different reports for SCM and Financials using XML Publisher.
- Worked on end to end testing of financial & SCM. Testing involved agile process.
PeopleSoft Consultant
Confidential, Portland, OR
Responsibilities:
- Participated as the Techno-functional Consultant on the PeopleSoft 9.0 Campus solutions, Portal upgrade and support project. Responsibilities include configuring the applications, impact analysis, and detailed functionality walk-through sessions for Student Admissions, Student Records, Academic Advising, Student Self Service, Financial Aid and Student Financials.
- Design, Develop, Customization, support and maintenance of PeopleSoft Campus Solutions Student Admissions, Academic Advising, Student Records, Financial aid, Student Financial modules applications using PeopleSoft Development, Reporting and Integrations tools.
- Designed, Develop 3rd party systems like Qnomy for token management, Higher One for refund integration.
- Crystal reports been converted to BI Publisher, new BI reports been designed, development for Campus modules.
- Financial Aid: Design, Develop, Customization, support and maintenance of PeopleSoft Campus Solutions Finance aid module applications using PeopleSoft Development, Reporting and Integrations tools.
- Designed, Developed to custom processes the Multa-campus changes for financial terms, ISIR, PELL origination.
- Developed process to the FA unit's updates based on student enrollment unit's changes.
- Custom crosswalk setup, process designed, developed for FA Checklists, Comment code, Service indicator assignments for various student attributes and ISIR data.
- Analyze, retrofit, testing and support during Oracle CS Regulatory bundle application for Financial Aid modules.
- Assist production users on issues related to student accounts, business processes or any performance impacts.
- Support and maintenance of business processes of Financial Aid and Student Financials PeopleSoft modules in relation to ing, packaging, authorization and disbursement (i.e. FA student account to SF student account) and troubleshoot user problems to resolve operating difficulties.
- Manage need analysis, packaging, repackaging, disbursement, and loan processing.
- Process origination and disbursement for Direct Loan and Pell Grant programs.
- Developed equations using Equation engine and associated it with Packaging/Repackaging Plans/Item Type setup. Also familiar with Equation SQL subroutines and Equation security.
- Academic Advising: Design, develop the student course planner, tool to calculate the future terms GPA, Total credits, Academic standing calculations.
- Setup, designed, modified various delivered Academic Advising report based in XML template and app packages as per the business requirement.
- Customized the online and batch Degree verify Advising transcript reports to access the students in student center.
- Configured the Custom advising rules and added bolt-on process to Academic standing calculation job.
- Student Admissions: Designed and configured the Matriculation automation with assigning the Checklists, Aid year activation, Service Indicators, Term activation, User profile creation and including 3rd party systems integrations.
- Troubleshooting the student bio-demo data changes through Application entry, maintain applications, Add/Update person.
- Designed and setup the Search/match process to exclude duplicate student ids, tied to service indicator to exclude in future transaction.
- Designed, setup to change the student bio-demo through student self-service that including the student ethnicity, citizenship, phone and residency address.
- Setup student Admission checklist, service indicators and comments.
- Designed, implemented student application data changes to in-house third party systems.
- PeopleSoft CS 9.0/FIN 9.2/HR 9.2 and People Tools 8.54/8.53, BI Publisher, SQR, Crystal and Oracle 11i, SQL server, Quality Center, Windows 8.1/10, Unix/Linux.
PeopleSoft Consultant
Confidential, Harrisburg, PA
Responsibilities:
- Participated in planning and design of PeopleSoft Application 9.2 upgrade. Analyze, retrofit, testing and support during application upgrade for student modules.
- Converted the Approval Workflow Engine data from CS 9.0 HRMS application to CS9.2 Campus application and re-configured in CS 9.2 Approval Workflow Engine.
- Configured PeopleSoft Workbench for data migration between environments, Majorly FA setup data, and fluid objects migration from one environment to other environments.
- Participated in 9.2 implementation planning, fit/gap analysis, troubleshooting application upgrade issues and helped the business team on functional process flow.
- Identified and developed strategy for retrofits of PeopleSoft Customizations.
- Analysis, Design, Develop and Configure the dashboards, Tiles based on Fluid content. Design, Developed Fluid pages and interface for mobile friendly pages and transactions.
- Implemented the GRE/TOEFL integration process and automated the process to download the student scores.
- Worked on retrofit of various customizations such as Interface, extension and reports as part of PeopleSoft campus solution upgrade (9.2).
- System testing of business processes of Financial Aid PeopleSoft module in relation to ing, packaging, Verifications, authorization and disbursement.
- System testing of business processes in Student Admission, Student Records and Academic Advisement modules.
- Provided financial aid data\reports on adhoc basis by developing queries based on client's needs and requirements.
- Analysis, Design, Customized and debug the Academic advising, Student records COBOLs as per the business requirement.
- Analyze, retrofit, testing and support during Oracle CS Regulatory bundle application for Financial Aid & Student Records modules.
- Design, Develop, Customization, support and maintenance of PeopleSoft Campus Solutions Student Admissions, Academic Advising, Student Records, Financial aid, Student Financial modules applications using PeopleSoft Development, Reporting and Integrations tools.
- Custom crosswalk setup, designed process, Developed FA Checklists assignment process with including Comment codes, Service indicator assignments for various student attributes and student ISIR data.
- Developed complex equations using Equation engine and associated it with Financial Aid Packaging, Repackaging Plans and Item Type setups. Also familiar with Equation SQL subroutines and Equation security.
- Process origination and disbursement for Direct Loan and Pell Grant programs.
- Developed and configured various financial aid communications using XML BI Publisher, 3C Engine and Communication generation process.
- Design, Configured custom Classes self-Service component with enrollment, swap and Pre-Registration functionality.
- Designed, setup for Class, class roster, Grades and Grade roster functionally for student, faculty and advisors.
- Responsible for end-to-end implementation of Prospect Data load for prospect data load from various data sources.
- Designed and setup done for the XML transcript online/batch process for multi-campuses and batch printing.
- Enrollments planner, student history pages have been configured and implemented for student and faculty centers.
- New Facilities, Buildings location setup and mapped to classes.
- Various Student Financials, Recruiting/Admission Crystal reports been converted to BI Publisher and decommissioned the Crystal reports and relevant objects.
- Designed and developed Financial Aid reports for the institution using application engine, BI Publisher reports.
- Customized Business process on Financial Aid modules with respect to NSLDS, INAS, s & disbursements & Refunds.
- Designed and developed SAP calculation process with application packages and SQR report.
- ICCB, NSA and various other reports have been designed and configured.
- PeopleSoft CS 9.2/9.0, FIN 9.2, HR 9.2 and People Tools 8.56/8.55/8.54 , BI Publisher, SQR, Crystal, COBOL and Oracle 12/11G, SQL server, Quality Center, Windows 10/7, Unix/Linux, STAT, Jira
PeopleSoft consultant
Confidential, Austin, TX
Responsibilities:
- Experienced in application development using People Tools and has knowledge on application designer, people code, component interface, application engine, PS query and SQR reports and is well conversant with PS HCM and PeopleSoft Financial applications.
- Strong Functional experience in PeopleSoft financials 9.2, 9.1, 9.0, 8.9, and experience in analysis, design, and development and testing of various PeopleSoft modules such as GL, Order to Cash process, Purchase Order
- Handled worldwide support, develop, trouble shoot of whole suits of PeopleSoft Financial and Supply Chain, which includes GL, AR, AP, Purchasing, eProcurement, Inventory, OM and BI for 8 different business entities from v.8.9, v.9.0, v.9.1, v.9.2.
- Developed expertise in setting up and configuring PeopleSoft approval framework in PeopleSoft 9.1 for Travel & Expense, Billing, AR and Accounts Payable modules
- Functionally involved in the Fit Gap Analysis, Work around Solutions and Requirement analysis for entire O2C modules AR and BI.
- Design, and development and testing of various PeopleSoft modules such as GL, Order to Cash process, Purchase Order.
- Experience in implementation, upgrade, support, customization, writing interfaces and administration of PeopleSoft Financials/SCM (AP, AR, GL, AM, Project Costing, Contracts, Billing, Purchasing, Vendors)
- Functional lead and support of the Oracle Financial project, which included GL, AR, AP, Purchasing, and Inventory. Provided fits and gaps business analyses, user tests, system tests, trouble shootings and post-production support.
- Provide primary support to PeopleSoft Accounts Payable Provide secondary support to PeopleSoft Asset Management, General Ledger and SCM.
- Define application problem by conferring with clients; evaluating procedures and processes. Develop solution by preparing and evaluating alternative solutions.
- Involved in analysis of bugs during SIT and UAT. Used HP quality center for defect analysis, defect resolutions and closure
- Experience in Trouble shoot and provide resolutions and Hands-on experience on PeopleSoft Internet Architecture (PIA) . Experience in good Project Management and decision-making skills and Proficient in mapping business requirements, designing & developing.
- Demonstrated skills in customizing and data conversion PeopleSoft HRMS 9.1/9.0/8.x applications using People Tools, People Code, and Application engine, Component Interface, Data Management Tools, SQR and Crystal Reports - Process Scheduler - Interfacing with other systems like Kronons, UNIX and Windows platforms.
- Collaborative PeopleSoft Consultant with an outstanding ability to interface cross-functionally to execute consulting strategies and processes.
- Proven ability to manage the design and implementation of technology-based solutions for complex business objectives.
- Self-motivated with high-performance standards and strong emphasis on goals, deadlines and quality of work.
- Extensive experience in the areas of System Analysis, Design, Development, Implementation, Data mapping, Conversion and tuning.
- Perform Fit-Gap analysis, gathering Requirements and work closely with the client requirements to define changes and process flow.
- Experience in Conversions, Migrations, Interfaces and Reporting, experience working within production support environment.
- Excellent understanding of CRM Data Model, Created & tuned complex SQL Queries record joins, filtering criteria & Effective Dated Active status rows.
- Configured Billing Setups (Invoice Number Id's, Bill types, Bill Sources, Invoice formatting, printing options, distribution codes, billing charge codes, discounts and surcharges, billing business unit)
- Setup integration between CRM & FSCM using delivered EIP. Performed full data load as well as incremental sync.
- Extensively used Data Mover for data movement and upgrades.
- Planning upgrade activities and co-ordination with developers and DBAs for upgrades.
- Complete involvement in the full life cycle of Development, Customization, Migrations, Testing, Test move to Production and Go-Live activities.
- Technical proficiency in People Tools, SQR, Crystal reports, People Code and Application Engine.