Sr Peoplesoft Consultant Resume
Hopkins, MN
SUMMARY
- Extensive 11+ years of IT experience at various levels, in a highly competitive and challenging environment that stimulated and encouraged constant learning on the job and at the same time demanding creative & innovative skills of the highest order.
- The range of responsibilities held, have demanded me to draw upon my interpersonal skills, objective thinking and ingenious approach and co - ordinate with various functions to accomplish the goals & grow from a Junior analyst to Techno-functional Lead.
- Experienced working with flexible schedule to accommodate global business users across time zones and ability to provide leadership/support to both Offshore/Onshore Teams across different US/India state locations.
- Possess excellent skills in Fit/Gap analysis, test cases, user requirement analysis, data modeling, project management and documentation of functional and technical specifications as well as excellent communication and presentation skills.
- Experienced as PeopleSoft & SAP FSCM Technical/Functional on implementation, upgrading, and migration and testing projects.
- Develop Training and Testing Strategy. Assist with change management methodology / migration of code and projects from DEV to PROD.
- Hands on experience on PeopleSoft Development Tools like Application Designer, Process Scheduler, Workflow, Component Interface, People Tools, People Code, SQR, Application Engine, and PS Query File Layout.
- Hands on experience in Oracle 8i/9i/10g and SQL Server 2000, DB2 using tools like SQL Navigator, Toad for performing SQL and PL/SQL programming.
- Possess knowledge of the basic UNIX commands.
- Expertise in Financials and Supply Chain Management modules, including AP, PO, GL, Project Costing, Contract, Inventory, P2P, R2R and Billing, Travel & Expenses, Grants.
- Extensive experience in full life cycle of implementation/upgradation, including design, configuration, testing, Education Change Management and deployment.
- Well proven in providing Production support for various clients in the area of Banking, Financial institutions.
- Expertise in creating Test Plans, Test Cases, Test Scripts and Test execution.
- Implemented and managed cash management services, such as, lockbox, ACH, Wire transfer, online banking.
TECHNICAL SKILLS
ERP Application: PeopleSoft Finance (8.9/9.0/9.1/9.2 ) Accounts Payable, Asset Management, Billing, General Ledger, Receivable, HRMS (Payroll/ Time & Labor/ Benefit), SAP ECC 5.0/6.0, Oracle Apps (11.5.10, R12), Lawson & Workday
People Tools: People Tools 8.48, 8.54, 8.55, 8.56, Application Designer, People Code
Development Tool: Application Designer, Application Engine, People Code, PS Query, Process Scheduler, Workflow, SQL Developer/TOAD, Putty.
Reporting Tools: PS Query, SQR, BI Publisher, Crystal Report, nvision, Hyperion Reports
Databases: Oracle 9i, Oracle 10g, MS Access
Project Management & Tracking Tools: Visio, MS Project, MS PowerPoint, MS Word, MS Excel, Test Director, HP Quality Center testing tool, Remedy.
PROFESSIONAL EXPERIENCE
Confidential
Sr Peoplesoft Consultant
Responsibilities:
- Working on PeopleSoft Project Costing, Asset Management, Inventory, eProcurement, Invoice, Billing, AR, AP, Purchasing, GL, Grants, Vendor management in FSCM modules.
- Working on Integrations between T&L, Expenses, Service Procurement, GL, Project Costing, Grants.
- Working with Functional, Testing, PS Administrators, PeopleSoft security, Change management teams during complete software development lifecycle using Waterfall methodology for new production support, and Agile methodology during development & implementation of custom functionality.
- Transformation of how processes are efficiently managed in a new 9.2 environment. Work involved taking this implementation through proof of concept and then guide client until it is fully implemented.
- Working on requirements, fit gap, design and configuration of PeopleSoft CM, GL, GM, AR, BI, AP, Grants Management modules for countries such as UK, Canada
- Major work includes fit-gap analysis, designing functional and technical specification documents for various financials modules such as CM, Grants Management, AP, AR, BI, GL, AM
- Developed new SQR programs to pull the Payroll related data from PeopleSoft HCM database to generate Flat files for determining the total Earnings, Deductions and Taxes for the employees.
- Involved in the modification of pages/components and validating the data fields using People Code.
- Extensively used PS Query to develop various queries based on User requirements.
- Performance tuning of various SQRs in Payroll, HR and Benefits modules.
- Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interfaces.
- Performed People Code and Component Interface troubleshooting in the HRMS, Payroll and Benefits modules.
- Written several SQRs for updating employee level record on benefits, Payroll and also to accomplish periodic database updates and correct data errors.
Confidential
Senior Peoplesoft consultant
Responsibilities:
- Hands on experience in full cycle of Workday Implementation - from the discovery phase to Project planning, Designing, Developing and Implementing interfaces (Workday Confidential, Recruitment, Payroll, Compensation, Time Tracking, Benefits) with other internal and external systems.
- Worked along internal HR and Business stakeholders to identify requirements, design enhancements and functionality to meet organization requirements.
- Unified withHuman Capital Management,Payroll, Absence Management, and Project and Work Management.
- Defined business processes and Proposed new or improved processes by Functional analysis with validated new processes with the business process owners.
- Worked on complete cycle of Compensation (Compensation Criteria, Plans & Grades), Configuring Security to the employees in an organization.
- Analyzed change and update requests, Coordinated the execution of tests and integration within the module.
- Worked with internal HR in taking the requirements and doing the data entry for several scenarios.
- Worked on creating Workday Reporting writing for the compensation project like Budget Allocation, Bonus Allocation, Stock Allocation, Red Flag reports and complete compensation planning list reports.
- Participate in local and regional Workday module review session, requirement gathering session, facilitate requirements meetings, development walk through, and user acceptance testing sessions with the client.
- Analyzed the functionality of Time and attendance pages, components, records and menus. Tested the functionality of Time and attendance workflow related to payroll.
Confidential, Hopkins, MN
FSCM Lead(Finance &Tax)
Responsibilities:
- As a Finance & Tax WP lead (Onshore): responsible for managing/supporting 25 applications (North America and Global) based on multiple technologies and ensure to meet SLA’s and the highest levels of customer satisfaction.
- Supported PeopleSoft FSCM that includes GL (Multi-currency processing), Asset Management, Accounts Payable, Billing, Travel &Expenses and PC in multi environment area.
- Assisted in end to end support for Upgradation from PS 9.1 to 9.2.
- Created functional specs for old and new processes. Analyzed code in order to draft documentation for Benefits Change File. Provided production support for Compensation changes that were occurring simultaneously.
- Hands-on writing test plans, creating test scripts, executing test cases, documenting test results.
- Keep tracking and reporting progress and status for escalated issues to higher manager and ensure timely resolution.
- CreatednVision Balance Sheet reports. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
- Managed/supported weekend patching/outages. And was responsible for ticket allocations and keep tracking with associated resource by providing necessary support for issue/incident closure.
- Responsible for preparing, presenting & publishing the weekly/monthly operations metrics to client.
- Designed and implemented cross-training programs for Offshore team.
- Actively involved for CMDB/Info quest page setup as part of change management.
- Attend and provide input/suggestion on weekly meetings with client on deliveries.
- Responsible for debugging and resolving business critical application and database performance issues. Maintain/update the issue trackers categorically for management/future reference.
- Actively participated on Business Requirement Documents review, Functional Specifications and Technical Specifications review and validate against requirements.
- Strong hands-on experience inApplication Engine, Peoplesoft Application, Integration Broker, App Designer.
- Involved in the smoke test for TSF project: related to one of the Gold application (Summit)
- Was Solley responsible for Asset Retirement implementation process and participated during go live cutover activities.
- Collaborated with management to improve and customize the reports related to production support.
- Coordinated escalation and resolution of major service issues and ensured to establish healthy relationship with client, business & other third-party vendors and negotiate avoiding escalations.
- Provided additional support to existing production support procedures and liaised with client/third partied to close all open issues.
- Performed as a change coordinator if any changes required to implement in production environment.
- Hosted/attended regular meetings/con calls with clients, Offshore and vendors to derive the accurate requirement.
- Responsible for giving KT to offshore people.
Environment: PeopleSoft FSCM 9.2(AP/AR/BI/GL/AM), People Tools 8.56, Application designer, People Code, Process Scheduler, PS-Query, SQR, SQL Plus, Application Engine, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2010
Confidential, Detroit, MI
Senior Peoplesoft Consultant
Responsibilities:
- Involved in Resolving day-to-day production tickets in PeopleSoft FSCM (Asset Management/ Accounts Payable/ General Ledger/ Accounts Receivable/ Grants/Contracts/Commitment Control) system.
- Lead functional walk-thru sessions with clients and executives, including project status presentations.
- Prepared and executed fit/gap sessions with the user community analyze all functional requirements for translation into functional fits and gaps.
- Was responsible to lead a 7 members Accenture testing Team during the upgradation process from Peoplesoft 9.1 to 9.2.
- I have hands on working experience in People tool 8.56.
- Develop Training and Testing Strategy. Assist with change management methodology / migration of code and projects from DEV to PROD. Address load balancing, Patch and bundle, architectural infrastructure, and parallel development.
- Prepared and maintained project plan, project scope, functional requirements, and functional solution specifications documents.
- Assisted with impact analysis, decision making, workarounds, and designs related to the functionality being implemented.
- Worked on several enhancement requests including changes to AR/express deposit pages, writing custom queries using the PS Query Tool, PeopleSoft Fluid interface, importing conversion Data, creating and configuring 3rd party Interfaces into and from PeopleSoft and out/in, to/from other systems.
- Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.
Environment: PeopleSoft FSCM 9.2(GL/AP/AR/BI/AM/Grants/ Contracts/PC), People Tools 8.56, Application designer, People Code, Process Scheduler, PS-Query, SQR, SQL Plus, Application Engine, Oracle 9i, MS Excel, Crystal Reports, Windows NT/2010
Confidential, Plano, TX
Business Analyst
Responsibilities:
- As an onsite team lead, responsible for the functional and technical aspects of the implementation of the following modules/products: Requisition, Purchasing, Payable, Receivable, and Billing. Also, responsible for interfacing with the client’s external fund system corporate applications.
- Performed Production Support, enhancements and customizations ofPeopleSoft FSCM 9.1(General Ledger/Asset Management/ Accounts Payable)
- Created Business Requirement Design Documents, High Level Flow, Low Level Design LLD and Deployment documents for all financial modules where the modifications were identified and listed.
- Co-ordinated and processed all outgoing wire transfers and ACH payments.
- Organized and provided training sessions to development and QA team to reinforce their understanding of financial modules functionality and specifics of PeopleSoft applications.
- Created detailed test scripts for Functional Unit Testing and System Testing and load testing using ALM QC Tool.
- CreatednVision Balance Sheet, Income Statements, Trial Balances and Cash flow statementsreports.
- Documented and managed defects related to the testing of designed solutions.
- Responsible for supervising and supporting the offshore development team in creating design documents, coding, testing and resolving issues.
Environment: People Soft 9.1/9.2, People tools 8.46, FSCM (GL/AR/BI/AP/AM), People code, SQR, Oracle 8.x and UNIX.
Confidential
Business Analyst
Responsibilities:
- Hands-on implementation experience as a functional consultant forAccounts Payable9.0andGeneral Ledger 9.0 modules.
- Designed and configuredchart-fieldsfor assurance. Modified and customizedchart-field labelsto suit assurance business.
- ConfiguredBusiness Units, Ledgers and Ledger Groups, Journal Sources.
- Designed and configuredcombination edits and closing rules.
- DesignedGL Journal approval workflow.
- Creatednvision Balance Sheet reports. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
- Configured newAllocationsincludingInter-Unit Allocations.
- Designed and configuredpayment handling codesandpayment term timing codes, AP Voucher approval workflow.
- UsedTree Managerto set upSummary Ledgers, security and Chart Field summarization rules, reporting hierarchies and rollup structure.
- Creatednvision Balance Sheet reportsfor new Business Units. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
- Maintained Business Units and Accounts reporting tress usingTree Manager.
- Performedmonth-endandquarter-end close, troubleshot out of balance Balance-sheets.
Environment: People Soft 9.1, People tools 8.46, FSCM (GL/AR/BI/AP/AM), People code, SQR, Oracle 8.x and UNIX.
Confidential
Business Analyst
Responsibilities:
- Provided daily ticket-based support and working on various enhancements including areas of GL, Taxes, AR, AP, Treasury, Asset Management etc.
- Analyzed and solved reported issues and bugs, track and monitor status of issues to meet all service level agreements coming on daily bases, doing enhancements as per requirement.
- Created new tax code or changing properties of existing tax code which includes define condition types, creating tax procedure, assigning tax procedure to companies’ country, defining tax jurisdiction structure, defining tax jurisdiction code, define tax codes, define tax accounts, export-import of tax codes.
- Created G/L accounts, Created of reconciliation accounts for accounts receivables and accounts payables, cross company transaction. Setting of various type of accounting posting like Negative posting.
- Configuration of customer master and vendor account groups, master data in FI, Number ranges, posting keys, and document types for posting. Terms of payment, Creation of dunning program for reminder to customers with different dunning levels, correspondence, automatic payment configurations.
- Defined Assets class, Account determination, integration with G/l, creation of asset, Retirement of assets, Asset acquisition. Depreciation runs.
- UsedTree Managerto set upSummary Ledgers, security, and Chart Field summarization rules, reporting hierarchies and rollup structure.
- Defining financial statement version, reports using financial information system.
Confidential
Business Analyst
Responsibilities:
- Gathered functional requirements and prioritized for application enhancements.
- Acted as a liaison between the business community and SAP Support Team.
- Documented, tested, and oversee all business processes within the modules.
- Prepared and executed test scripts and sign off on changes to production environment.
- Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to SAP Asset Management.
- Designed Purchasing workflow process.
- Troubleshoot GL Journal Edit issues.
- Worked with Business unit, setup Ledger.
Confidential
Intern
Responsibilities:
- Analyzed and researched the legacy systems for SAP implementation
- Gathered business requirements, designed business processes diagrams
- Conducted stakeholder’s meetings to identify AS-IS and TO-BE business processes
- Analyzed the business processes and mapped to SAP functionality
- Configured and implemented SAP system
- Organized data migration, testing processes and provided training
- Conducted SAP HR training and post implementation support
- Worked closely with the technical teams and delivered technical solutions
- Worked and improved manual and automated processes.
Confidential
Jr. Functional Consultant
Responsibilities:
- Assisted in business process and billing process., Analyzed, validated, and documented system and business requirements.
- Identified gaps in business operations and suggested solutions.
- Liaised between heads of the departments and resolved issues