Peoplesoft Lead Analyst Resume
Philadelphia, PA
PROFESSIONAL SUMMARY:
- Over 14 years of extensive experience as PeopleSoft lead analyst, successfully completed many implementations and upgrades of different version of PeopleSoft, includes fit - gap analysis, requirement gathering, design, documentation, development, testing,, implementation and production support of applications on client/server environment and web enabled systems on PeopleSoft SCM/FIN 9.1/8.8/8.4/8.0/7.5/7.0 applications and all PeopleSoft related suite and tools.
- Strong ability to provide functional and technical leadership in a variety of PeopleSoft projects which includes implementation, upgrade, integration, production support, customization, performance tuning, conversion, security, batch job, EDI, Queries, Reports, and supporting PeopleSoft SCM/FIN application.
- Extensive experience Accounts Payable, Inventory, Purchasing, eProcurement, General Ledger, Asset Managemet, Project Costing, Manufacturing Order Management, Accounts Recievables, Shipping, Costing, and Expense, Billing modules.
- Strong expertise working with functional and technical team on SQR, People Code, Application Designer, Application Engine, Application Package, and web services, Tree Manager, Security, Query Manager and Crystal Reports.
- Good Knowledge of relational databases DB2, ORACLE 11, MS SQL Server, SQL Base, DB2/400.
- Pursuing project management - PMP
FUNCTIONAL SUMMARY/SKILLS:
Worked in Implementation/Upgrade of PS SCM Application, involved in Fit/Gap Analysis, requirement specification documentation, design, testing, Configuration and Setup of Business Unit, ePro, shipto, item, location, vendor, buyer, requestor, receiving, shipping, workflow, user profile, consignment and other business related setups, user, spec writing, documentation also explore new peoplesoft functionality for the business, working with user on day to day production issues, enhancement and testing, recommend best business practice, introduce new functionality
PROFESSIONAL SUMMARY/SKILLS;
Software and Applications: PeopleSoft Financials 9.1/8.8/8.4/8.0/7.5/7.0 , Brio SQR 6, Crystal Report 9.0, Cobol, STAT, People Tools 8.51, Application Messaging, Peoplecode, Application Engine, Component Interface, Query, Functional, upgrade, implementation, Development, Customization, Maintenance, Production Support, Patches - bug fixing, Oracle, MS SQL Server 7.0/2000, Unix, MS Visual Basic 6.0, MS FrontPage 2000, AS/400, RPG/400, DB2, FoxPro 2.5 MS Office Suite 2000, Ultra Edit 32, JAVA 1.2, HTML / DHTML and Visual Cafe
Languages: SQR, SQL, PeopleCode, VB Script, JAVA
Environment: s Unix, Windows NT,DOS, MS Windows 3.x / 9 / ME, and Confidential AS400
Database: Oracle11, MS SQL Server, DB2,AS400
PROFESSIONAL EXPERIENCE:
Confidential, Philadelphia, PA
PeopleSoft Lead Analyst
Responsibilities:
- Key Player in PeopleSoft upgrade from 8.9 to 9.1, tools 8.51 and integration of newly added hospital into PeopleSoft
- Involved in fit/gap analysis
- Involved in configuration setup like Business Unit, AtPar, Item Fulfillment setup,Vendor load, update payment terms, dispatch method, Ship to, Location, Fixed bin locations, Permission List, Requester, Buyer, Inventory business unit, Items, Atpar profile setup and configuration, analysis, design, documentation,, deployment support, production support, security permission list and role assistance, batch job setup, job aids
- Created test plan for UAT and SIT testing for Atpar, Inventory and Purchasing
- Setup inventory replenishment, par replenishment, fulfillment process, items, location, shipto, user p, roles, permission list, batch jobs, purchasing buyers, requestor, receiver.
- Trained users on Atpar/Inventory Cycle count, Putaway, bin to bin transfer.
- Modified custom queries and reports
- Involved in third party warehouse integration interfaces
- Ceated catalog based on item category
- Involved in ePro workflow setup based on department and amount
- Implemented Recurring PO Voucher Contract module for fixed payment contract like servicing, repair etc
- Trained ePro user on web punch out ordering, special request, different types of requisitions
- Load assets from component interface excel, depreciation and accounting process
- Testing EDI PO, Order Acknowledgment, ASN and Invoice transactions
- Worked on setting up and configuring consignment, configuration of consigned items, consigned location, owned locations
- Configured accounting rules for different transaction types and interunit transfer setup
- Trouble shooting inventory transactions not costed like landed cost, PPV
- Translate business requirement into functional and technical requirement
- Involved in configuring Supplier Contract module, setting up documents library
- Created queries for payment history.
- Trained AP to use recurring voucher contract also trained purchasing users on RTV process for stock and non stock items
- Troubleshooting voucher related issues due to incorrect EDI data for vendor item id, PO not received, amount mismatch, uom issue
- Setup bank, paycycle and match rule
- Day to day production support
- Pursuing project management -PMP
Confidential
PeopleSoft Lead Analyst
Responsibilities:
- Key Player in PeopleSoft implementation
- Involved in fit/gap analysis, creating requirement specifications and design documents
- Worked on data conversion from legacy to PeopleSoft
- Work with technical team to create functional specification for interfaces and reports
- Translate business requirement into functional and technical requirement
- Involved in warehouse integration interfaces
- Data conversion from legacy system into peoplesoft
- Trouble shooting vouchers not posted
- Extensively work on resolving Matching errors
- Involved with day to day production support, trouble shooting, user
- Created queries and report as per business requirement
- Propose best practice and standard to improve business process
- Actively work with other groups like security, DBA, PS Admin, Business Owners, Users .
- Worked on test plan and testing documentation using quality control
- Day to day user liaison and interaction, production support
Confidential, Seattle, WA
SCM Senior Analyst
Responsibilities:
- Key player in NEW implementation of PeopleSoft v9.0, analysis of business requirement, configuring as per business process, customization and maintenance, production support after go live on Inventory, Purchasing/ePro module.
- Involved in, process documentation before and after PS implementation.
- Working on day to day production support, after go live issues of replenishment, receiving, purchasing, inventory, AtPar putaway, cartcount and picking.
- Gathering information from user and continously working on different types of query reports to extract data as per requirement both on Purchasing as well as on Inventory side.
- Working with users in their day to day business process.
- Have been helping in PS security, setting up user p etc.
- Worked on configuring and setting up business rules.
- Involved with inventory costing and monthend process interacting with finance on costing side, item cost.
- Closely working with technical team in designing and testing customization/enhancement like out of stock warning, customizing pick plan to get comments from epro user as stock request goes to MSC while non-stock to purchase order and vendor
- Improving business process and functionality to better use the system for the business.
- Regularly meeting with business and process owners to implement available
- Functionality like using inventory cycle count, return to vendor (RTV), Purchasing contracts.
- Continuously working to improve unit of measure/conversion rate issue on stocking and issuing side to the nursing department
- Recently worked with atpar to fix the zero picking issue as when one item in order was zero picked entire order would get zero pick resulting in inventory discrepancy
- Performs monthly e-Pro for nursing department and other units also do in-service for MSC in inventory for transfers, adjustment, par location, IUT, fulfillment.
- Created nVision reports for stock and non-stock items to be distributed to all the directors
Senior PeopleSoft Lead Analyst
Confidential, Rockville, MD
Responsibilities:
- Key player in the upgrade, integration, development, customization and production support of PeopleSoft Financials/Supply Chain system mostly on Materials Management side, involved in configuration, setup, loading items, loading inventory from third party into PeopleSoft
- Currently working on modifying receiving side to get Tag and Serial number from Materials Management to Asset Management. worked on consolidating ePro requisitions that split into multiple POs due to multiple vendor location
- Working on implementing serial id tracking while receiving items so that it gets into Accounts Payable and Asset Management.
- Completed assignment to load document on Requisition to PO on header level with workflow
- Working on RMA modification
- Working on Budget Department workflow automation by customization.
- Delivered process for Treasury daily cash automation load from bank into PS/GL
- Implemented Applicant background checking process in PS with 3rd party Vendor, this is HR module.
- Loading Vendor rebate from flat file into PeopleSoft
- Finished integration of a new business unit into PS, responsible to upload AM including depreciation of all Assets till their life.
- Uploading Vendor from legacy system into PeopleSoft using ExceltoCI.
- Day to day production support, bug fixing, system maintenance.
- Applied patches and fixes.
- Implemented RTV (Return to Vendor functionality) from Purchasing to AP to GL.
- Worked on setting up configuration for Pay Cycle manager, Banks, Check printing.
- Modified check printing program.
- Modified programs to load Purchasing contracts for different business unit having same item but different prices.
- Completed DBA and UNIX .
- Modified and created Cystal reports as well as Queries for Financial modules.
- Continuously worked on Voucher Exception issues, Costing Accounting line errors, maintaining inventory, cycle count, Express Putaway and Express Issue, shipping, un-shipping, depletion.
- Setup/configured Material storage location
- Created test scripts for upgrade
- Extensively worked on Inventory project to get data from legacy system to PeopleSoft using Application Messaging, SQR and Application Engine and Component Interface.
- Worked extensively with Component Interface, Application engine to create Interunit Transfer and Receiving till the accounting line creation
- Performed security task, created roles, permission list, user profiles.
- Working on eProcurement workflow with new business rules.
- Production support on Journals and G/L issues.
- Experience in STAT
- Modified cobol programs
- Implemented Replenishment in production
- Successfully implemented RTV (return to vendor).
- Provide assistance in managing Project Management and SDLC
Environment: PeopleSoft SCM/Financial 8.8/9.0 (ePro, PO, INV, AP, AM, GL and TR),, PeopleCode, Workflow, Crystal Report, SQR, ORACLE 8, DB2, UNIX and Windows NT
Confidential, LasVegas, NV
PeopleSoft SCM Upgrade/Development/Customization/Production Support
Responsibilities:
- Involved in upgrade from Application 8 to 8.9, tools 8.48, on the supply chain side of Inventory, Purchasing, Accounts Payable, PCard, General Ledger, AR.
- Used application messaging by getting data from BASWARE system and loading into AP, creating vouchers.
- Implemented Consignment functionality in inventory module with functional users on the setup and configuration and all technical stuff, and then worked on the bugs/fixes and patch.
- Worked on different customized report like creating sub ledger report for the entire business, consignment report
- Worked on Workflow and Component Interface to notify users when difference in Price
- Day to day production support, technical as well as functional on SCM
- Created queries as per user requirement
- Modified crystals as tables changed in new version
- In the process of implementing Bar Coding system with High Jump
- Also modified some of the delivered application packages
- Working on Costing as there are lot of issues due to setup/configuration, weighted average cost and consignment
- Continously working on day to day production support as well
- Use Change Assistance to apply patches/bundles/fixes
- Work with PS Admin and DBA for performance tuning, job scheduling
Environment: PeopleSoft SCM/Financial 8.4/8.9 (ePro, PO, INV, AP, AR, GL),, PeopleCode, Workflow, Crystal Report, SQR, ORACLE 9, UNIX and Windows NT
Confidential, NY
PeopleSoft SCM Upgrade/Development/Customization/Production Support
Responsibilities:
- PeopleSoft Financials/SCM 8.0,SP2, Oracle 8, Windows NT
- Worked with functional team for business setup and configuration, very good understanding of business process and data flow of OTC(order to cash), Buying Agreements, Order Creation, Reservation, Pick plan, Shipping/un-shipping, Billing/Export billing, Inventory Management, Inventory transactions, Production Management, Accounting, Journal entries and Receivables.
- Currently working on 8.9 upgrade infact it is new implementation .
- Developed application engine for container transfer program.
- Developed Application messaging to get data from Biztalk/Camstar and process it to create express putaway.
- Created app message and component interface to close PID, create PID and calculate actual hours
- Developed and modified SQR/Application Engine Programs to upload data from flat file to get sales order into PS OM .
- Capturing date difference when the order is created and confirmed by plant this sqr report will display time and day difference .
- Develop program to display production skid completion.
- New sqr to get shipping information into excel file.
- Worked on program to close back orders still open.
- Developed program to fix qty and date difference between schedule and demand lines.
- Modified existing Crystal reports as per business requirement.
- Trouble shooting/Problem solving in all Modules for Data Problems, PeopleSoft delivered bugs in Tables, Views and Wrong Business Settings.
- Developing the test cases and documenting the test results after the Unit Level test of all Pieces of processes, running trace and debugging.
- Created new queries and made changes to the existing Private, Public and Role Queries
- Helping fix production support day to day issues functionally as well as technically.
- Used Change Assistance to apply patches/bundles/fixes
- Modified delivered purge process.
- Performance tunning and load balancing worked with DBA and architecture team.
- Involved in many small projects and assignments of OM, INV, BI, CM,PP and Shipping
- User, designing test manuals and documents, job aids
- PeopleSoft Certified
- Work with PS Admin and DBA for performance tuning, job scheduling
- Extensively worked on Purchasing, Inventory and Payables in purchasing the po calculation process - Application Engine -pocalc was heavily customized to create a separate PO for ePro Requisition lines with contract and without contract for the same vendor and then it was further customized for creating PO for multiple BU’s where the user can select as many BU’s from the run control page this modification was done for eProcurement requisitions
- Application Engine pocreate was modified to enhance the functionality to set the status of PO as Approved/Pending/Open for the requisition item with contracts, w/o contracts, special requisition and Pantellos for the selected group of Business unit .
- In Inventory created buyer purchasing attribute where buyers can update certain fields instead of all and add vendors to item and business unit but cannot delete vendors, buyer can add manufacture id for that particular item and vendor, item vendor UOM can only be added for the new vendor but cannot delete .
- Troubleshooting of all modules of SCM.
- Modifying PeopleCode and running trace and debug PeopleCode, Application Engine to fix any issues.
- Applying PeopleSoft fixes and patches for all modules
- Involved in the trainer
- Developing the test cases and documenting the test results after the Unit Level test of all Pieces of processes. Running in trace, debugging the code/programs if need.
- Query - made changes to the existing Private, Public and Role Queries and created new Queries as per Clients Requirement
- Worked with the Upgrade Team for the Finance/eProcurement Upgrade from PS 7.0 to PS 8.16 which includes Compare Report, Database Upgrade, and Tools Upgrade.
- Involved in FIT GAP Analysis with Functional Team for AP,PO,INV,eProcurement,AR,AM,PC,GL
- Configuration of AP, PO, INV, eProcurement Inventory setup data (like Business units, Control data, Vendor, Location, Origin, Items, etc.)
- Query - made changes to the existing Private, Public and Role Queries and created new Queries as per Clients Requirement
- Customizing the fields, records, menus, and writing PeopleCode for new requirements.
- Modifying PeopleCode and running Application reviewer, trace, debug PeopleCode to fix any issues.
- Identifying PeopleSoft fixes and Patches from PeopleSoft customer connection site and applying those in Test environment and moving to production environments.
- Trouble Shooting- Problem Solving in all Modules for Data Problems, PeopleSoft delivered bugs in Tables, Views and Wrong Business Settings like Shipping Code, SETID, ChartFields and security Records.
- Create/Modifying the Crystal, SQR reports.
- Developing the test cases and documenting the test results after the Unit Level test of all Pieces of processes. Running in trace, debugging the code/programs if need.
- Applying Fixes and patches from PeopleSoft delivered errors
Environment: PeopleSoft Financials 7.5 / 8.16, PeopleTools, Workflow, PeopleCode, SQR, Crystal Reports and Oracle 8.