SUMMARY:

• Over 15 years of experience in PeopleSoft (7.5/8.0/8.4/8.8/8.9/9.0/9.2 ) extensive experience in PeopleSoft FSCM (OM, INV, AP, GL, AR, PO, BI, Contracts, AM, Expenses & PC)
• Extensive experience in PeopleSoft Analysis, Implementation, and Upgrade & Production support experience.
• Proficient in the use of: nVision, SQR, Application Designer, Data Mover, Import Manager, Maintain Security/ Security Administrator, Query/Crystal, Application Engine, PeopleCode, Mass Change, Workflow & Database Agent, Message agent.
• Specialized in Functional analysis, designing and developing customizations of Pages, Components interfaces, and reports.
• AP, PO, ePro, GL, PC, BI, AR, IN for Commercial.
• Responsible for Developing Interface and Data conversion for FSCM modules (AP, INV, OM, PO, ePro) using Component Interface, Application Engine, Excel to CI, File Layout.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered Crystal Reports and SQR Files.
• Self Study of SOX (SOX (Sarbanes - Oxley).
• Experience in Database - SQL Server, Oracle, SQL Base, MS-Access, DB2.
• Excellent in Production Support, Documentation, End-Users and Knowledge transfer.
• Served as the key point of contact/Liaison between on and offshore resources.
• Excellent oral/written communication and presentation skills.
• Over 10 years of experience in Technical Project Management, Business Process Modeling, System Analysis, Release Management, Requirements management using SDLC methodology, UML Modeling, Prototype design, Agile methodology using JIRA to manager projects.
• Overall 21 years of experience in managing and supporting Business and Technical teams in all Phases of Software Development Life Cycle (SDLC) by using different Methodologies like Iterative, waterfall, agile-scrum.
• Emphasis on requirements gathering from business stakeholders by using methods like Elicitation, conducting Interviews with users as well as Subject Matter Experts (SMEs) by asking detailed functionality aspect of business process, Requirement workshops, organizing Joint Application Development (JAD) sessions and carefully updating the information to create a Business Requirements Document (BRD).
• Extensive experience in gathering business and functional requirements, feasibility studies, risk analysis, Gap impact analysis, creating narrative Use Cases and UML diagrams- Class diagrams, Use Case diagrams, Activity diagrams, Data flow diagrams using UML Tools like MS Visio.
• Expertise in the areas of writing Scope documents, Request for Proposal (RFP), BRD, Functional Requirements Document (FRD), incorporating use cases in creating System Requirements.
• Experience in Object Oriented Design Technologies and maintain traceability of Requirements using Requirements Traceability Matrix (RTM).
• Working with QA and testing teams in close coordination in developing Test Plans, building Test Conditions and Test cases, creating test data, analyzing bugs, Interacting with development team to fix the errors; Facilitated User Acceptance Testing (UAT) with client representatives.
• Experienced of Data Warehouse Environment including Data Analysis, Data Modeling, Data Mapping, Data Integration and Data Migration using ETL tool- Informatica; Designed and Implemented Ad-hoc SQL queries to extract data from different databases for timely reporting, Data Analysis and Validation.
• In-depth knowledge of PS CRM, financials (AM, AP, AR, GL, KK, PO, Requisition, Expense, ePro, BI, IN), HRMS (Core, Benefits, Benefit Administration, Payroll, Time & Labor, ESS, eBenefits, eComp, ePay, Manager Dashboard) and EPM (Budgeting and Planning) CRM Salesforce systems. Combination of interpersonal, functional, technical, leadership abilities

TECHNICAL EXPERTISE:

Business / Modeling Tools: MS Project, MS Visio, MS Excel, MS Word, MS PowerPoint

Requirements Management Tools: MS Suite

Databases: SQL Server, Oracle, Sybase, MS Access

SDLC Methodologies: Agile Scrum, Waterfall.

Operating Systems: Windows 95/98/2k/NT/XP/Vista/Window 7,8 Windows server 2008, 2012, 2016, UNIX AIX

Web Technologies: Java, JSP, VB Script, VB 6.0, Integration Broker with REST & SOAP services.

Softwares: Financials (AP, AR, GL, AM, BUDGETS, PROJECTS, PURCHASING, Billing) Salesforce CRM, PeopleSoft, APPLICATIONS 6.0 through 9.2 HRMS/BENEFIT/PAYROLL/Time Labor/Pension

Tools/Technology: PeopleTools, Application Designer, Application Engine, Component Interface, File layout, PeopleCode, Data Mover, ExcelToCI, App Packages and related tools SQR, Business Objects XI 3.1, XML publisher, Ascential, Integration Broker REST/SOAP services.

Reporting Tools: PS Query, PS/nVision, SQR, Crystal Reports, Hyperion Reports, Tree Manager, BI Publisher(XMLP)

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

PeopleSoft FSCM Functional Consultant

Responsibilities:

• PeopleSoft FSCM upgrade ver. 9.0 to 9.2 and tools 8.56.09, Enhancements, Support
• Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (PO, Inventory, ePro, BI, GL, AP, AR) Assisted in streamlining the SCM process as per requirements and anticipated deliverables. Designed and Developed Several Custom interfaces to AR, BI, PO, AM, Inventory, AP and GL Modules. Worked extensively with AR Update and Payment Predictor process. Customized AR statement process with the interface with BI .
• Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
• Integrated PS Financials data with Hyperion for budgeting and planning.
• Designed Purchasing workflow process.
• Troubleshoot GL Journal Edit issues.
• Worked with Business unit, setup Ledger
• Designed and support of INV and ePro interfaces. .
• Accounts Payable integration/interface with 3rd party system.
• Accounts receivables setup and integration with billing module.
• Setting up new business unit Asset Management fixed asset.
• Created complex nVision reports for FS system.
• Created ExceltoCI to load Assets.
• Configured Business Units, Ledgers and Ledger Groups.
• Configured Journal Sources.
• Designed and configured combination edits and closing rules.
• Designed GL Journal approval workflow.
• Apply PeopleSoft upgrades and patches. Configured/enhanced Check Printing. Developed and customized crystal invoices as per the company’s requirement. Designed, developed and implemented custom Schedule Billing online pages
• Coded batch program for creating bills and email notifications to users basing on custom Schedule Billing.
• Designed and developed custom interfaces. Interacted with the Users and Functional analysts to come up with new requirements for the business unit. Worked with Long Term and simple receivables. Customize PO dispatch process. Fix issues related to Matching. Designed and Developed interfaces for p-card processing. Customized AP trial register and other AP crystal reports.
• Performed Testing of AP Voucher Post, Payment Post, Pay cycle processes.
• Troubleshoot and helped to resolve supplier purchase order and invoice issues
• Tested modifications to ensure they meet customer’s specifications. Provided on-call support to the end-user.
• Developed customizations using Application Designer for BI, AP, ePro, PO and INV.
• Involved in the analysis and implementation of PeopleSoft OM for Capturing and Validating Orders.
• Built and customized Component Interface and used Excel to CI PS delivered feature for Item Loader process
• Enhanced existing SQR’s to print invoices, purchase orders, price confirmations and request for quotes. Receiving Vendor, Item, Receipt Date and Receiving Log by Date, Item reports.
• Ran compare reports before and after applying the patches/fixes
• Interacted with the Users and Functional analysts to come up with new requirements for the business unit.
• Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules.
• Fixing of problems and issues which come across during various stages of implementation like development, User acceptance and live of project costing
• Extensively involved in Post-Production Activities, Documentation and end user

Environment: PeopleSoft 8.9/9.0/9.2 FSCM (OM, AP, PO, ePro, INV, GL, AR, AM , BI),

Confidential, Arlington, VA

PeopleSoft FSCM Consultant

Responsibilities:

• PeopleSoft Upgrade FSCM 8.8 to 9.0 and Enhancements, support
• Involved in designing and developing the interface programs to move data from legacy system to PeopleSoft tables using App. Messaging through Integration Broker.
• Worked with team and users to gather requirements, anticipated functionality deliverables and determine the specifications for implementation.
• Assisted users with P-card processing.
• Having a strong experience working with Multi Currency.
• Involved in developing Inbound Interfaces customizations in FSCMs 8.8 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
• Created and modified several new reports and queries.
• Solve the interface related issue - Debugging the SQR and Application Engine Program and Fix the error
• Involved in the development and customization of on line modifications.
• Generated Crystal reports for updating the status of Order Schedules, for Processing Inbound and Outbound transactions for order, for reporting all contracts and their status.
• Involved in defining Approval Rule Sets for Purchase Order Approval in PO.
• Used PS8 Features such as Buyer station for creating, editing or approving purchase orders and search criteria in eProcurement.
• Worked on SQR’s to create report for calculating a sales contract rebate for each customer ties to the contract, for creating Sales Order Acknowledgement report, to create Material Authorization, for displaying all Sales Orders with their order totals.
• Applied PeopleSoft fixes and patches to Order Management and Inventory.
• Customized RMA SQR Report to display RMA transactions for internal and external locations in Inventory module.
• Wrote an AE batch process to do the inter-unit transfer i.e. transfer of stock between two inventory business units on a daily basis in PeopleSoft Inventory.
• Supported the multiple testing tracks, prepared summary of test results as well as involved in troubleshooting issues uncovered.

Environment: PeopleSoft 8.4 FSCM (GL, AP, AR, AM, BI, ePro, OM, PO, INV).

Confidential, Reston/Mclean, VA

PS Technical Senior Developer/Lead Analyst

Responsibilities:

• Gathered requirements for creating new templates from end users. Upgraded PS Financials and HR form ver 8.8 to 9.0.
• Working with Business People and getting their requirements and customizations, Drawing Process Diagrams that helps other team members to understand system easily.
• Configure and setup tables 9.0 setup banks, bank accounts, inter unit accounts using centralized inter/intra unit functionality, sales/use pack defaults and option, withholding environment.
• Assisted in vendor data conversion
• Prepared document for payables, and trained key payable users for changes in payable 8.8
• Configuration OM, INV, AP, GL, AR setup data (like Business Units, Control data, Vendor Location, Origin, Items etc)
• Designed, developed and implemented custom Schedule Billing online pages
• Coded batch program for creating bills and email notifications to users basing on custom Schedule Billing
• Fixed errors in billing for several interfaces, printing invoices etc
• Developed test cases/plans to test various applications.
• Communicated between systems using App Messaging and business interlinks, by defining Message channels, nodes, by Publish and subscribe methods, configuring transactions.
• Evaluation, customization and setting up of workflow for Journal Entry Approval, Asset Transfers approval and Voucher Approval Processes, Receivable processes.
• Developing new components, pages, records and people code customizations added.
• Migration and upgrade the customized people code on various record events.
• Setting up of process definitions and process scheduler jobs for various processes.
• Fit gap analysis for various processes and helped users in finalizing various processes.
• Coordinated development and testing efforts between functional, technical and user groups. Managed issue tracking and creating project documentation.
• Provided production support, functional enhancements for AP, GL, AR, PO, Expenses and Requisition modules.
• Applying Patches.
• Responsible to keep track of SLDC in each release.
• Developed and managed implementation methodology used by all implementation consultants, including Kick-Off Presentation and Project Start-Up Materials, Statement of Work (SOW), Project Plan, Risk Assessment, and Process Design Workshops.
• Developed Technical Specification for Custom Benefits Reports mapping business requirements for the Technical Development Team.
• Performed Data mapping for Client Interfaces.
• Extensively used People Code, Application Engine, and IB for customization and development of new pages.
• Wrote nVision Reports for balance sheets and income statements for different business units.
• Converted nVision reports into Business objects reports.
• Generated the Test Strategy for System Integration Test Cycle, Parallel Test Cycle and User Acceptance Testing.

Environment: People Soft 8.4 FSCM (GL, AP, AR, PO, INV)